DAT_520_Module_One_Lab_Worksheet Adriana Carroll
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
3
Uploaded by MateGerbil2595
DAT 520 Module One Lab Worksheet
Interacting With Visualizations in Power BI
Overview
In this lab, you will become familiar with Power BI. You will be introduced to several data visualizations and asked to answer questions related to them. Please make sure to review the DAT uCertify Student FAQ document before attempting to complete this lab. Instructions
First, open Lab 1.1.1. Interacting with Visualizations in Power BI
in uCertify. Follow the instructions to open the “MyFootprintSports_1” Power BI reports. Then, complete the activity below and replace the bracketed text with the relevant information.
Please note: This assignment will be submitted and graded in Brightspace
1.
Navigate to the Establishment Data
tab and expand the bar graph. Select Manufacturing
from the key at the top. During which month was Manufacturing below zero? August 2.
Staying in the expanded view of the Establishment Data
tab’s visualization, complete the following:
a.
Change the chart from a bar graph to a line graph. b.
Remove all five variables from the value section.
c.
Add Average Hourly Earnings, Utilities, Education and Health Services, and Transportation and Warehousing to the values section.
d.
Take a screenshot of the visualization you have created and insert it below.
e.
Describe what insights you see from looking at this visualization.
There is a downtrend in the values on the chart while the wages stay the same, and then
we see an increase in the values while the wages remain the same.
3.
Navigate to the Sales by Region and Category
tab and expand the stacked bar chart that displays the sales by category and subcategory. Open the filter section and apply a filter so that the stacked bar chart displays only those categories and subcategories with sales less than $30,000. a.
Take a screenshot of the new visualization. b.
Which subcategory has a substantial number of sales in the Footwear category but a small amount in Apparel? Youth
4.
Navigate to the Sales by Year and Region
chart and expand the visualization. Drill down to display the sales by month and apply a filter to display only sales from the year 2019. a.
Take a screenshot of the adjusted visualization.
b.
During which month do all seasons see a dramatic drop in sales? Does this happen consistently or just in 2019?
The biggest drop in sales occurred during the month of October and this drop happens consistently by viewing all the years instead of 2019. However, this drop does not occur in the Southern US region during the month of October. It is difficult to say why this is and further information is required.
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