DAT 520 Module Two Lab Worksheet
Lessons 2 and 3 Labs
Overview
In these Module Two labs, you will explore connecting data sources to Power BI, creating relationships
between various data sets, and shaping data for analysis.
Instructions
First, complete the following labs in the uCertify lab environment. Then, replace the bracketed text with
the relevant information.
Please note:
This assignment will be submitted and graded in Brightspace.
uCertify Labs
2.1.1 Creating Data Connections
2.2.1 Configuring and Managing Data Relationships
2.3.1 Saving Files in Power BI
3.1.1 Cleaning, Transforming, and Loading Connected Data
3.2.1 Profiling Data in Power BI
3.3.1 Shaping Data for Analysis
Lab 2.1.1 Creating Data Connections
1.
Navigate to the
Data
tab
and take a screenshot of the two data sources you have brought into
Power BI.
[Insert screenshot.]
Lab 2.2.1 Configuring and Managing Data Relationships
1.
Take a screenshot of the relationships (found on the
relationship view
) you have created
between the two data sets and insert it below.
[Insert screenshot.]
2.
What does creating relationships between two data sets do for your future analysis?
[Insert text.]
Lab 3.1.1 Cleaning, Transforming, and Loading Connected Data
1.
After completing #9 in Figure 10, take a screenshot of your work and insert it below.
[Insert screenshot.]
Lab 3.2.1 Profiling Data in Power BI
1.
Within the
Columns Profiles
pane of the
Transform Data Editor
, select the
Product Name
column and ensure that the
Column Profiles
selection is checked. Take a screenshot of the graph
displaying the distribution of the variables and insert it below.
[Insert screenshot.]
2.
What is the total number of unique values?
[Insert text.]
3.
What value has the largest representation?
