DAT 520 Module Two Lab Worksheet
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
520
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
docx
Pages
6
Uploaded by ProfRiverDove20
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?
[we created connection between category and order database. We try to use category ID as the bridge to connect both database. In category data base, category is primary key and category id is foreign key. In order data base, order id should be primary key and it also include category id as foreign key. We can easily use category id to find out all the information when we search it with connections in different databases.]
Lab 3.1.1 Cleaning, Transforming, and Loading Connected Data
1.
After completing Step 5, take a screenshot of the Query Editor you updated.
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.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? 44
3.
What value has the largest representation?
Soccer ball
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, I can derive some extra features to provide more information or detail to my data analysis project. I will also improve model performance because more relevant
and diverse features will increase the accuracy and better handling complex relationships. We also can better do the customization to meet our goal or need when we want to update them. It also may help out the missing information handling with new variables adding in. ]
2.
What is the importance of formatting your data properly?
[First, improving accuracy without misinterpretation and flawed conclusion. Second, increasing compatibility to fit different kind of analysis tools. Also, good formatted data is more easier to interpret and integrate data. So, we want clear data labels and clear data structures to reduce the error. Last, it will improve and clear the visualization. We want to provide easy reading graphs to audiences.]
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