DAT 520 Module Two Lab Worksheet (1)
docx
keyboard_arrow_up
School
University of Texas, Tyler *
*We aren’t endorsed by this school
Course
5360
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
docx
Pages
2
Uploaded by njoku1994
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?
[Insert text.]
Lab 3.3.1 Shaping Data for Analysis
1.
Explain why it would be advantageous to be able to create new variables within your data set.
[Insert text.]
2.
What is the importance of formatting your data properly?
[Insert text.]
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help