Search for a command to run...
Articles tagged with #practical-exercises
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 following date foreign keys: 1. Due Date 2. Order Date 3. Delivery Date You need to support the analysis ...
Scenario: Given meta data: column_name, data_example, valid_profile IoT GUID, 48196321-3809-EC11-883D-0022489A2..., 100% IoT DateTime, 21/05/2022 18:59:25, 100% IoT ID, 10000010000, 100% The IOT ID columns are unique to each row in query. You nee...
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 in the data as numerical amount representing US dollars. You need to create a reference line to show ...
Scenario: Given meta data: column_name, data_example, valid_profile IoT GUID, 48196321-3809-EC11-883D-0022489A2..., 100% IoT DateTime, 21/05/2022 18:59:25, 100% IoT ID, 10000010000, 100% The IoT GUID and IoT ID columns are unique to each row in q...
Scenario: You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date. The tables have the following relationships: Sales...
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 than 100 million records. During the development process, you need to import a sample of the data from...