Product Analysis

This Power BI report page provides a comprehensive analysis of product sales performance, leveraging the AdventureWorksDW sample database. The page focuses on identifying top-selling products and understanding their contribution to overall sales, with a particular emphasis on the 80/20 rule (Pareto principle). The report uses a combination of key performance indicators (KPIs), interactive visualizations, and advanced DAX calculations to provide actionable insights.

DAX Functions Utilized:

Aggregate Functions:
SUM, SUMX, AVERAGEX, DIVIDE, MAX, DISTINCTCOUNT, COUNTROWS
Filter Functions:
FILTER, CALCULATE, ALLSELECTED, ALL
Ranking Functions:
RANKX
Time Intelligence Functions:
SAMEPERIODLASTYEAR, DATESINPERIOD
Logical Functions:
IF, HASONEVALUE
Table Functions:
ADDCOLUMNS,VALUES, DATATABLE
Variable Declaration:
VAR
Other Function
EARLIER, SELECTEDMEASURE, SWITCH

Go Back

Page updated

Google Sites

Report abuse