Azure Project for
Summary of the Project
Minerva Corp is a fictitious consumer packaged goods company operating in Canada. Ms. Jane Doe, the Chief Marketing Officer needs to see a sales and marketing dashboard every day to know which products are selling well, which channel of distribution is working, conversion rate for B2B clients and which marketing campaigns are efficient in terms of ROI.
This dashboard drives her decision-making for all marketing verticals - sales and distribution, brand management, digital marketing and campaigns.
It is also important for her to have updated numbers daily so she can catch insights and trends that may cause concerns in future.
To solve for this we are going to create a dashboard consisting of the following reports
- Internet Sales Report
- Retail Sales Report
- Combined Sales Analysis
- Lead Analysis
- Campaign Analysis
Through our Azure Data Factory online course, you will learn to work with multiple data sources, build data models to understand relationships and format data in most appropriate visualizations. In other words, you will understand the business intelligence work flow.
Type of Reports
Tabular visualization, Drill down, Matrix, Maps, Funnels, Gauge Charts, Bar graphs, Histograms, Pie Charts, Scatter Plot and many more.
Parameters used for the report
While creating this dashboard you will work with the following:
Sale order Header, Detailed table (Where we have sales by product id, Store wise and Online Sales), Lead Header, Campaign Header, Campaign table, With Product details (s) combining them with Left Outer Join
Product Id, falg Variable, Amount
Sort, Merge, Join, and Aggregate (Count) to find top Customers
Sales Amount, Product, Customer, Account keys, Leads Number, Number of Campaigns, Date Campaign, Account keys
Type of Load:
Cube with Dim/ Fact Tables:
Dim: Date, Account, Product
Fact: Sales by Store, Online
Revenue, Tax Amount, Average Price, Product Cost, Combined, Revenue Combined, Tax Amount, Campaign Cost
YTD, QTD, MTD