For the final phase of the project, you can either follow the instructions to recreate the report shown below, or design your own version — the choice is yours! 1) Rename the tab “Topline Performance” and insert the Maven Market logo 2) Insert a Matrix visual to show Total Transactions, Total Profit, Profit Margin, and Return Rate by Product_Brand (on rows)
Read MoreUsing your report from Part 2, complete the following steps: 1) In the DATA view, add the following calculated columns: In the Calendar table, add a column named “Weekend“ Equals “Y” for Saturdays or Sundays (otherwise “N“) In the Calendar table, add a column named “End of Month“ Returns the last date of the current month for each row In the Customers table,
Read MoreUsing the report you created in Part 1, complete the following steps: 1) In the RELATIONSHIPS view, arrange your tables with the lookup tables above the data tables Connect Transaction_Data to Customers, Products, and Stores using valid primary/foreign keys Connect Transaction_Data to Calendar using both date fields, with an inactive “stock_date” relationship Connect Return_Data to Products, Calendar, and Stores using valid primary/foreign keys Connect Stores to Regions as a “snowflake” schema 2) Confirm the following: All relationships
Read MoreOpen a new Power BI Desktop file, and complete the following steps: 1) Update your Power BI options and settings as follows: Deselect the “Autodetect new relationships after data is loaded” option in the Data Load tab Make sure that Locale for import is set to “English (United States)” in the Regional Settings tab
Read MoreCongratulations! The Adventure Works clients were so impressed by your work that they referred you for another contract. This time you will be working with Maven Market, a multi-national grocery chain with locations in Canada, Mexico and the United States. Just like the Adventure Works project, you will
Read MoreUsing your Adventure Works report file, complete the following: 1) Add a new report page named “Customer Detail“, and complete the following steps (Note: Screenshot provided for reference below): Add a matrix visual to show Total Orders and Total Revenue by customer full name for the top 100 customers by revenue (0:31 mark) What
Read MoreUsing the Adventure Works report, complete the following: 1) In the DATA view, create the following calculated columns: In the AW_Customer_Lookup table, add a new column named “Customer Priority” that equals “Priority” for customers who are under 50 years old and have an annual income of greater than $100,000, and “Standard” otherwise (00:30 mark) In the AW_Product_Lookup table,
Read MoreUsing your Adventure Works report file, complete the following: 1) Navigate to the RELATIONSHIPS view, and perform the following actions (00:14 mark): Right-click to delete each relationship between AW_Sales, AW_Customer_Lookup and AW_Calendar_Lookup (including both date fields) (00:21 mark) Use the Manage Relationships tool to delete all remaining relationships between all tables (01:05 mark) 2) Recreate all table relationships (using any method you prefer), and confirm the
Read More