The purpose of Step 1 is to build, visualize, and interpret data models using Power BI.
Review the Canyon Sales dimensional model you built in the Topic 1 assignment “Design a Relational Schema” and perform the following Power BI:
1. Load the Canyon Sales database into Power BI. 4 dimensions and a fact should be loaded.
2. Use bar chart to visualize units sold by product name. Take a screenshot of the bar chart to be used in Step 3.
3. Use bar chart to visualize units sold by year. Take a screenshot of the bar chart to be used in Step 3.
4. Use bar char to visualize units sold by store region name. Take a screenshot of the bar chart to be used in Step 3.
5. Use bar chart to visualize units sold by store region name and product vendor name. Take a screenshot of the bar chart to be used in Step 3.
Step 2:
In this step, the student will learn how to perform feature extractions using DAX in Power BI.
In Power BI, create a table named Calendar with the following columns:
• Date column populated with the most recently completed 2 years’ worth of data from January 1st to December 31st.
• Month column to display the name of the month.
• Year column to display the year.
• Month number to display the number of the month (e.g., 1 for January).
• Week number to display the number of the week (e.g., Jan 1 to Jan 7 is week number 1).
• Weekday to display the name of the day (Jan 01 has a weekday name of Sunday).
• Weekday number to display the day number of the weekday (ex: Sunday has a weekday number 7).
• Workday: display 1 if it is a workday, otherwise 0.