AsgnE_AZ_PowerBI_Winter_2024_v1

BTM 311 611 Asgn E: Data Analytics using MS PowerBI Each year Adventure Zone Amusements, headquartered in Calgary, Alberta, runs a major amusement park (Wander Wonder) in Southern Alberta. Adventure Zone Amusements has developed a growing customer base due to family-centered marketing, sensible cost-management (avoiding new, expensive, unproven rides) and innovative use of technology. Adventure Zone Amusements’ president Angela Kurusugawa and the board of directors are championing a refresh of the company that will cover everything from their branding and marketing to their facilities and technology.Adventure Zone hopes to stay the leading amusement park in western countries by ensuring a safe but fun time for the whole family while using technology to streamline the customer’s experience. Deliverables Working individually , use Power BI to build a data analytics report using a variety of visualizations to answer the questions posed by Miranda. Your report is composed of the requirements below. Requirements NOTE: Amendments or clarifications may be posted in “eClass announcements”. Please check it periodically. 1 Create and Name your report Create a Power Bi file on your computer. Use your first name and last name to name this file 5 marks z 2 Importing Data into PowerBI Unzip the provided AssignmentE_CSV_files zip file. Load all the CSV files to your PowerBi file created above. You should load all nine (9) CSV files, one for each table. Once you have loaded all nine (9) tables, make sure all relationships matches the provided “Manage relationships” picture in the next page. Hint : You may need to create a new relationship(s), activate/deactivate some relationship(s). Arrange the Model view in Power BI so that all tables and relationships are viewable on the screen and take a screenshot. You may need to move tables around and zoom out using the toolbar at the bottom of the window to include everything in your screenshot. ● Paste your screenshot in the space provided below. 10 marks ERD Screenshot [replace this text with your screenshot] Version 1 Winter 2024 Page 1

Version 1 Winter 2024 Page 2

● Rename Page 3 to “Customer Location” Use the Customer data table and a Map Visualization to create a visualization and answers the questions below. Give this visualization a business professional title. Your visualization should contain the following: - Create a new column called Customer_address and include Address Line1 , Municipality and Country in the following format: 1250 Fake Street, Calgary, Canada. o NOTE: You should separate these fields with a comma followed by a space. You should also include a dot at the end. - A new column called Customer_name which include customer first name and last name . It should use the following format: Peter Parker - Use the new Customer_address field as location in your visualization. - Use Customer_name field as legend in your visualization. Note : You may need to enable the security option for mapping visuals and then Refresh to produce the map. Make sure you are using your @ualberta account. If you are currently using your personal account, please logging out and try to log in again. ● What conclusions can AZ draw from this visualization? [replace this text with your answer] Now, create a new a table visualization which includes the following: - The Customer_name field - The Customer_address field. - The number of visits per month of each customer. ● How does this additional visualization enhance what AZA has learned from the Map visualization? [replace this text with your answer] 6 Employee Visualization  Create a new Page and rename it to “Employee” Use the Employee data table, a Funnel visualization and two DAX expressions to create a visualization and answer the questions below. Give this visualization a business professional title. Your visualization should include the following: - Employee_name column as the Group - A new column called Annual_salary that calculates that multiplies the Salary_amt by 12 and use that as the values. - A new column called Years_employed as the tooltips, using the DAX expression below: Years_employed = DATEDIFF(Employee[Hire_date],TODAY(),YEAR)  Is there correlation between the number of years an Employee has worked for AZA and their annual salary? [replace this text with your answer]  Describe a conclusion that AZA draw from your findings? [replace this text with your answer] 10 marks Version 1 Winter 2024 Page 4

7 Bell and Whistle ● Create a new Page and rename it to “Bell and Whistle” You decide to proactively answer a question with a visualization for AZA that Angela has not asked. This will help you to illustrate the “bells and whistles” of Power BI and explain how Power BI can be used to answer other questions using information hidden in the data. Choose one (or more) of the nine (9) tables that are in the Model on which you will base your visualization. ● Identify the table(s) you selected. [replace this text with your answer] ● Write a question below that you are going to answer by visualizing the data table(s) you selected. [replace this text with your answer] Create a visualization of your choices based on the table you selected above that will help you answer the question you wrote down. Give this visualization a business professional title. ● Describe how AZA could use this information. [replace this text with your answer] Note: “Bells and Whistles” are EXTRA features, in addition to any of the above requirements. You can earn higher marks by using your Google skills to develop any DAX expressions you may require to answer your question or make the results more useful to Darren. Your visualization will be assessed subjectively (i.e. compared to your colleagues) based on the layout, complexity and usefulness of the visualization. 10 marks You may use the space below to describe the “bells and whistles” you have researched and used. This could help in the assessment of this page. [replace this text with your answer] 8 Share and Publish the Report 10 marks Version 1 Winter 2024 Page 5

Submission requirements: Before the deadline, you must submit the following 3 files: ● One (1) completed BATR_REQUIREMENTS document with your answers and screenshots. ● One (1) PBIX report ● One (1) PDF report NOTE: Please ensure that you are submitting the correct, completed files as any incorrect submissions (i.e. wrong file attached, blank submissions, etc.) may be penalized. o Due NOON (12:00 PM), April 5 th , 2024 Cheating and Plagiarism: All work is to be done individually . Do not copy, in whole or in part, the work of others, including paper printouts, electronic files or computer programs. Do not use the work of others as a starting point and then modify it. All work submitted under your name must be from you alone. Note that penalties may be assessed if your work resembles a current or previous students’ work. The University of Alberta is committed to the highest standards of academic integrity and honesty. Students are expected to be familiar with these standards regarding academic honesty and to uphold the policies of the University in this respect. Students are particularly urged to familiarize themselves with the provisions of the Code of Student Behavior ( https://www.ualberta.ca/governance/resources/policies-standards-and-codes-of-conduct/code-of-student- behaviour ) and avoid any behavior that could potentially result in suspicions of cheating, plagiarism, misrepresentation of facts and/or participation in an offence. Academic dishonesty is a serious offence and can result in suspension or expulsion from the University. Version 1 Winter 2024 Page 7