+61480015851
Northwind Sales Order Analytics - Qliksense and Tableau - Business Intelligence Project Assignment Help
Download Solution
Order New Solution
Internal Code: 2AGJD
Business Intelligence Project Assignment Help
Task: Dataset northwinds.xls 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 Assignments 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 Break Up QlikSense- Dashboard
- Show All Data Columns
- Drill Down Table
- Drill Down Graph
- Combo / Dual Axis Chart
- Tree Map
- Geo Graph showing Total Revenue per City
- 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 Quantity goes 20% Up or Down
- Forecast strategic data for the next 6 months
- 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
- Dashboard
- Show All Data Columns
- Drill Down Table
- Drill Down Graph
- Combo / Dual Axis Chart
- Tree Map
- Geo Graph showing Total Revenue per City
- Dashboard
- Show Data In Pivot with totals at three levels.
- Quick FinYear wise data with Months (Apr to Dec) in Row(s) and FinYear as Col(s)
- Compare Graph showing monthly measure
- Geo Graph showing measure per City
- What If Analysis showing dependent measures as strategic measure goes 20% Up or Down
- Forecast a strategic measure for the next 6 months
- 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
This Business Intelligence Assignment has been solved by our Business experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.