DBW624 Business Analytic Application Assignment

Assignment Help Database Management System

Reference no: EM133182393

DBW624 Business Analytic Application - Seneca College

Now that we have a complete data warehouse, loaded with data, we are going to build our Business Intelligence (BI) application which will actually answer the business questions below, which were highlighted in Assignment 1.

Here are the business analytics we will want to perform.
1. Sales Volumes Analysis by fiscal quarter
a. By Store
b. By Product
c. By Product Group (Age Group)
2. Sales Revenue Analysis by fiscal quarter
a. By Store,
b. By Product
c. By Product Group (Age Group)
3. Sales Profit Analysis by fiscal quarter
a. By Store,
b. By Product
c. By Product Group (Age Group)
4. Product Line Analysis by fiscal quarter, measured by revenue and profit
a. Which products have been the most / least successful
b. Which product groups have been the most / least successful
c. What is the product trends (growth or declining)?
5. Store Analysis by fiscal quarter, measured by revenue and profit
a. Which stores are the most / least successful
b. What is the growth trends for each store (growth or declining)?
6. Additional Analysis
a. Which names have been most successful by volume
b. Which gender has been most successful by volume
c. Who was the top sales person for the quarter?
d. What percentage of sales are cash versus credit card?
e. What percentage of sales were using a marketing campaign?
7. Analytics Against Reference Tables
a. Which ten cities should we open stores in, based on population?
b. Which names should we expect will be the most popular for our personalized products?

For each of the business questions above, write a SQL query which provides the business answer.

What you need to hand in is a copy of your BI application showing both the SQL used to run the required analytic query and the result set.

Attachment:- ETL Application.rar

Reference no: EM133182393

Questions Cloud

Venture capitalists provide funds to finance new companies : In hope of high returns, venture capitalists provide funds to finance new companies.which one do you believe provides highest possible return for new company

Record the second month lease payment : Metlock's incremental borrowing rate is 6% a year (0.5% a month). Simon's implicit rate is unknown. Record the second month lease payment

Explain the relevance of training to participants : Detailed knowledge of the products that Peach Phones produces has traditionally not been a high priority for the learning and development staff such as yourself

Similar forms of communication : Companies have been slow and reluctant to adopt social media channels, online videos, and similar forms of communication. If you were a senior manager, how woul

DBW624 Business Analytic Application Assignment : DBW624 Business Analytic Application Assignment Help and Solution, Seneca College - Assessment Writing Service

Virtual environments on the internet : Investigate games, simulations, and virtual environments and choose two that will enhance adult learning.

What is involved with moving and cleansing data : Creating a staging table which is the target of the IMPORT from the .csv files below - then - clean the data and move over to the final reference tables

Financial management-Examine ethical behavior : Examine ethical behavior within firms in relation to financial management. Explain how the incidents affected the company, the economy, and society.

Reimaging global hr operations : 1. Consider the question 'Reimaging Global HR Operations' - this should see you thinking about 3 potential phases/scenarios of the company you are writing about

User Account

All Pages