Advanced Data Visualization
B.Com (Business Analytics) V Semester
I.
From the file given below show the following data
visualization in Power BI.
1.
Percentage
of total ‘Gross Sales’ for each
Month.
2.
Top
3 ‘Month Name’ and Gross Sales.
3.
Sales by Country and Product. (Insert pivot
table)
4.
Sales price by Date and Country.
(Insert pivot chart)
5.
Manufacturing price by Product and Year.
6.
Segment
and Units sold. (Insert pivot chart)
7.
Discount
and Manufacturing price. (Insert
pivot table and chart)
8.
Year
and Discounts. (Insert doughnut chart)
9.
Frequency
of Manufacturing price.
10.Cogs and Profit find correlation
through Scatter Plot.
Create a dash board of sales
with KPIs and also establish the relational data models.
II.
From
the file given below show the following data visualization in Power BI.
GLOBAL SUPER STORE ORDERS LINK
11. Percentage of total sales for each ‘Ship mode’.
12.Caterogy with total sales higher than 4744000.
13.Insert a pivot table shipping cost by category, region and segment.
14.Discount by ship mode .
15.Quantity by segment and
category.
16.Make a decomposition table.
17.Quantity over ship date (line
chart).
18.Country and sales ______
country /profit / Quantity. Provide the decomposition table and the maps.
19.Ship mode & profit
(doughnut chart).
20.Discount shows a repeating
pattern over ship date.
Create a dashboard of sales and
profit with KPIs and generate a report.
III. From the file given below show
the following data visualization in Power BI.
Fraud insurance claim csv Link
21. Use Power Query to transform the data
22. Percentage of total “capital loss”
for each ‘Insured Education level’.
23. ‘Incident city’ with total
‘vehicle- claim’ higher than 6102000.
24. ‘Policy no’ by ‘Incident
-severity ‘authorised contracted’
and ‘fraud reported’.
25. Find the key
performance indicators of claims.
26. Capital loss and policy bind date.
27. Present the
decomposition table of claims with respect to age, gender, umbrella limit,
total claim and fraud report.
28. Present a dash board of
the visualizations
29. Give the inferences of
the claims.
30. Present a report on
the fraud claims.
Create the
dash board with the KPIs of capital gains and the fraud reported.
IV.
From
the file given below show the following data visualization in Tableau.
FINANCIAL SAMPLE LINK
31. Discounts and Sales.
Establish Correlation.
32. Year and Sales.
33. Profit and
Manufacturing price.
34. Frequency of COGS.
35. Segment and Sale
Price.
36. Segment and
Manufacturing price.
37. Sales and COGS.
38. Frequency of Gross
Sales.
39. Gross Sales and
Manufacturing price.
40. Sales and Profit.
Create
the dash board of the country wise product, units sold, sales, profit year wise
V.
From
the file given below show the following data visualization in Tableau
Fraud insurance claim csv Link
41. Injury claim and vehicle claim. (find correlation
42. Months vs customer
-policy bind rate
43. How is total claim and
injury claim
44. How are age and injury
claim, what relation exists. Do you see any outliers.
45. What relation exists
between age and property claim. Do you see any outliers at what age and
property claims.
46. Find the key performance
indicators for frauds
47. Find the key
performance indicators for claims
48. Generate a report to
present the inferences of claims
49. Generate a report to
present the fraud claims.
50. Give a report on how
to detect the fraud claims.
Comments
Post a Comment