2-2 Module Two Lab
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
520
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
docx
Pages
4
Uploaded by DeanRiver5511
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.
[
]
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.
[
.]
2.
What does creating relationships between two data sets do for your future analysis?
[allows me to determine what common factors each pane has and how to differentate the
relationships formed later down the line}coricorinw`corin.wilkersSame dea
Lab 3.1.1 Cleaning, Transforming, and Loading Connected Data
1.
After completing Step 5, take a screenshot of the Query Editor you updated.
2.
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.
[
]
2.
What is the total number of unique values?
[44.]
3.
What value has the largest representation?
[
Soccer Ball]
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
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.
[
By creating new variables we can transform existing data to suit our analytic goalsand address
specific research questions or hypothesis..]
2.
What is the importance of formatting your data properly?
[
Properly formulating data is crucial because it ensures the information is accurate, meaningful,
and useful for decision making. Proper data can provide insight, identify patterns, and reveal
trends.]