HashNotes
Tag

practical exercises

#practical-exercises

More content

Read more stories on Hashnode

Articles with this tag

Power BI Practice: Using DAX USERELATIONSHIP for Multiple Date Keys

Sep 17, 20242 min read1 views

Scenario: You have a Power Bl report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the...

Power BI Practice: Using DAX USERELATIONSHIP for Multiple Date Keys

Power BI Practice: Concatenation generally does not improve dataset performance

Sep 17, 20242 min read3 views

Scenario: Given meta data: column_name, data_example, valid_profile IoT GUID, 48196321-3809-EC11-883D-0022489A2..., 100% IoT DateTime, 21/05/2022...

Power BI Practice: Concatenation generally does not improve dataset performance

Power BI Practice: Average Line vs Median Line in Power BI Visualization

Sep 17, 20241 min read6 views

Scenario: You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present...

Power BI Practice: Average Line vs Median Line in Power BI Visualization

Power BI Practice: Optimize Power BI Datasets, Remove Irrelevant Fields

Sep 17, 20241 min read3 views

Scenario: Given meta data: column_name, data_example, valid_profile IoT GUID, 48196321-3809-EC11-883D-0022489A2..., 100% IoT DateTime, 21/05/2022...

Power BI Practice: Optimize Power BI Datasets, Remove Irrelevant Fields

Power BI Practice: Counting Orders by Different Dates in Power BI Using CALCULATE and USERELATIONSHIP

Sep 17, 20242 min read4 views

Scenario: You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and...

Power BI Practice: Counting Orders by Different Dates in Power BI Using CALCULATE and USERELATIONSHIP

Power BI Practice: Filter Step is Not Efficient for Importing Data in Power BI, Use SQL WHERE Clauses Instead

Sep 17, 20241 min read2 views

Scenario: You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more...

Power BI Practice: Filter Step is Not Efficient for Importing Data in Power BI, Use SQL WHERE Clauses Instead