Page 521 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

• Bar Chart: Compare sales amounts for different product categories.
• Map: Show the geographical distribution of sales using the Region information.

4 Implement Slicers:
• Add slicers to enable dynamic filtering. For example, create a slicer for the date range to view sales for a
specific period.

5 Calculate Key Metrics:
• Create new calculated columns or measures to calculate important metrics, such as monthly growth rate
or total sales.
6 Dashboard Creation:

• Assemble the visualizations on a Power BI dashboard for a comprehensive overview.
7 Interactive Elements:
• Implement interactive elements such as tooltips, drill-throughs, or bookmarks to enhance user experience.
Dataset Example:

Date Product Category Sales Amount Region
2022-01-01 Electronics 10000 North
2022-02-01 Clothing 12000 South
2022-03-01 Home Goods 15000 East

506

CITS : IT & ITES - Computer Software Application - Exercise 77