Scribd
Upload
27 views1 page

Power BI Assignment for Data Analysts

The document outlines an assignment for a Power BI certification training module, where a Data Analyst must create a report using DirectQuery to connect to an Azure SQL Database. The tasks include loading specific tables, creating visualizations, and publishing the report to Power BI Service. Additionally, it provides contact information for support.

Uploaded by

quasif.danish.alam27
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
27 views1 page

Power BI Assignment for Data Analysts

The document outlines an assignment for a Power BI certification training module, where a Data Analyst must create a report using DirectQuery to connect to an Azure SQL Database. The tasks include loading specific tables, creating visualizations, and publishing the report to Power BI Service. Additionally, it provides contact information for support.

Uploaded by

quasif.danish.alam27
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Power BI Certification Training

Module 7 - Assignment
Problem Statement:
As a Data Analyst for AdventureWorks, you are investigating the use of live connections to Azure
SQL Database and Azure SQL Data Warehouse.
In this assignment, you will create a Power BI Desktop report and use DirectQuery to pull data from
the AdventureWorks database hosted in Azure. You will then publish this report to Power BI
Service.

You have been asked to:

a) Start with a blank Power BI Desktop file


b) Connect to AdventureWorksLT SQL Database using DirectQuery
c) Load the [Link] and [Link] tables
d) Create a chart based on the card visualization
e) Add an OrderQty field to the chart
f) Create a slicer and add SellStartDate
g) Save the file as Assignment 7
h) Publish the report to Power BI Service
i) Open the Assignment 7 report, and create a card visual with a LineTotal field
j) To view the data in Power BI Service, use Data Gateway
k) Save and close Power BI Service

support@[Link] - +91-7022374614 - US: 1-800-216-8930 (Toll Free)

You might also like