Part 1: Data Mart Design (5 marks)

In this section you will design and document a data mart schema for Tasty’n’Yummy Pizzas (the scenario discussed in Assignment 1).

Design a data mart schema to satisfy Tasty’n’Yummy Pizzas decision makers’ information needs. You need to only design the data mart schema only. You do not need to implement it.

Write a short report (approx. 200 words excluding diagram & queries) which includes: Documented schema Subject-area/s covered by your data mart A discussion of how the data mart satisfies the information analysis needs of Tasty’n’Yummy Pizzas Give 5 examples of analysis queries that your design supports.
Save your document as A3_<student name>_PizzaDataMartDesign.docx.

Part 2: Business Intelligence Reporting (15 marks)

Adventure Works is a fictitious company that manufactures and sells metal and composite bicycles to North American, European and Asian commercial markets. Adventure Works Data Warehouse contains a number of data marts for the fictitious Adventure Works company.

Download and restore the AdventureWorks Data Warehouse database. The backup file is available on Blackboard at Assessment / ASSIGNMENT 3 / Assignment Specification / AdventureworksDW2017.zip

Part 2A: SQL Server Reporting Services (5 marks)

Create the following report using SQL Server Reporting Services. The report provides the monthly and yearly reseller sales for Australian territory for all years.

Save the project as A3_<student name>_SSRSReport. The format of the report is given below:

Note that the data is sample data and does not contain the exact values from the actual database.

Part 2B: Data Analytics – Report (5 marks)

Explore the data warehouse schema and data. Select subject area(s) that you would like to analyse in Adventure Works. Create data mart(s) either using either: SQL Server Analysis Server, or Power BI.

Save the project/file as A3_<student name>_AWDataMart.

Analyse the data and write a Business Intelligence report based on the Adventure Works data using: Power BI’s visuals, dashboards etc. in your analysis, data visualisation and presentation and/or Excel’s BI features such as pivot tables, charts and graphs.

Your report will include data analysis, information discovered and helpful insights and actions items from your data analysis. Include appropriate tables, charts, graphs etc. in your report to present your findings.

Note that your target audience for the BI report is the business management team of Adventure Works such as the CEO and senior management, so your BI report should be understood by business managers.

Save your report as A3_< student name >_BIReport.docx

Part 2C: Data Analytics –Presentation (5 marks)

In addition to the written report, you will present your Business Intelligence analysis during the Week 12 lab class. Your presentation should not exceed 5 minutes. Your presentation should be professional with some form of visual demonstration (i.e. slides).

Save your presentation document as A3_<student name>_Presentation.<filetype>

Progress Monitoring

In this assignment, progress will be monitored at labs. Please ensure that you attend the lab sessions to discuss your progress.

To Continue Click Here > INFO6002 Assignment 3 Data Marts and Business Intelligence Database Management2 Callaghan.pdf