Reference no: EM132224606
Northwind Sales Order Analytics Business Intelligence Project -
Objectives - This project enables the participants to review the learning's of the Business Intelligence Using QlikSense & Tableau.
The primary objective of the project is to enhance the participant's knowledge of QlikSense & Tableau in Exploratory Data Analytics & Visual Data Analytics skills.
Dataset - The data contains sales order data of Northwind (a general supplies company) for the period Apr-2013 to Mar-2015.
Calculated Columns:
SaleAmt = Quantity * SalePrice Less Discount
CostAmt = Quantity * CostPrice Less Discount
Margin = SaleAmt - CostAmt
Assignment -
Design a Data Viz App using Tableau. Provide Dashboard & Charts which will give the use maximum insights from this data
Context: Strategic
Users: Top Management
Formats: All dates to be dd-mmm-yyyy
All numbers to be 999,999,999.00
Requirements - Design two Data Viz App using QlikSense & Tableau each.
Provide Dashboard & Charts which will give the use maximum insights from this data as per requirements given below.
The participants are to create a mix of 7 Charts as given below.
The marks / grades for each table / chart also given along with. For the marks / grade for tables / charts marks will be assigned for choosing the right type of graph for the data to be presented.
Apart from creating charts, the participant will also be asked to specify the insight provided by the charts / tables. The value of the insights provided will also be judged as given below.
Evaluation Methodology - The participants are to create a mix of 7 visualizations as given below.
Apart from creating charts, the participant will also be asked to specify the insight provided by the charts / tables. The value of the insights provided will also be judged as given below.
Evaluation Break Up
QlikSense [Common for all participants in the group]
- Dashboard
- Show All Data Columns
- Drill Down Table
- Drill Down Graph
- Combo / Dual Axis Chart
- Tree Map
- Geo Graph showing Total Revenue per City
Tableau [Common for all participants in the group]
- Dashboard
- Show All Invoice Data With OrdID wise & OrderDate wise Totals.
- Show FinYear wise strategic data with Months (Apr to Dec) in Row(s) and FinYear as Col (s).
- Compare Graph showing monthly strategic.
- Geo Graph showing a strategic measure per Geo Location.
- What If Analysis showing strategic data as Quant i ty goes 20% Up or Down.
- Forecast strategic data for the next 6 months.
Viva [Awarded To Individual participants]
Based on any one of the below
- explanation of visualization done in the project.
- duplicating the existing visualization done in the project.
- creating a new visualization as instructed.
Summary
- Prepare a one page presentation (.PPT) describing your experience of using QlikSense & Tableau for Business Intelligence.
Attachment:- Assignment Files.rar