Build Analysis Solution Using PowerBI
This assignment uses a GCU-provided virtual machine.
View the “SQL Server Analysis Services (SSAS)” video within the “Video Playlist: Relational Databases for Business Applications,” located in the topic Resources.
Step 1:
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:
- Load the Canyon Sales database into Power BI. 4 dimensions and a fact should be loaded.
- Use bar chart to visualize units sold by product name. Take a screenshot of the bar chart to be used in Step 3.
- Use bar chart to visualize units sold by year. Take a screenshot of the bar chart to be used in Step 3.
- Use bar char to visualize units sold by store region name. Take a screenshot of the bar chart to be used in Step 3.
- 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.
Take a screenshot that shows all the information from Step 2 to be used in Step 3.
Step: 3
Write an academic paper, using Microsoft Word, presenting your models and extractions from Steps 1 and 2. Submit your paper through the digital classroom.
The paper will include the following:
- An introductory paragraph
- Presentation, explanation, and interpretation of each of bar chart (Step 1: b-e) as if this report were being presented to your manager and the team. Include the screenshots of each bar chart along with their explanations.
- Presentation of an excerpt of your calendar that shows all the information from Step 2. Include the screenshot.
- A concluding paragraph
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
Benchmark Information:
BS- Information Technology (BS-IT) and BS Information Technology with Emphasis in Cybersecurity (BS-IT CYB)
1.3: Identify and manage data storage techniques and resource requirements using virtualization best practices.