Study of a trained data using advanced DAX

Problem Statement

Mr. Rafin is the COO of a multinational company established in Germany. He wanted to know the overall performance of the company. So, he asked his analyst team to make a report regarding the company's situation (from 2017-2019). Along with the report he also wanted to know some specific information which are stated below:

Sales comparison with previous year
Top 10 Clients
Top 10 Product Categories
Which countries contributed most to the sales
A scenerio analysis if the prices increses upto 100% and if the demand decreases upto 20% and increases upto 100%.
Weekend vs Weekday sales scenerio
Who are our grade A, B and C clients according to the total sales

Approach

Before starting the analysis, the analyst team cleaned the supplied data and added a DatesTable using an advanced query formula. Also the data types were checked according to the column data.

Page01:

Used DAX

DAX: SUMX function and some basic analysis
DAX Timeintelligence: CALCULATE, SAMEPERIODLASTYEAR, DATEADD
DAX Timeintelligence: CALCULATE, PARALLELPERIOD

Here, the Sales Comparison of previous year and the overall sales scenerio is visualized.

Page 01.PNG

Page02:

Used DAX

DAX: RANKX, ALL, IF with Parameter
DAX Timeintelligence: CALCULATE, FILTER, ALLSELECTED, MAX (=> cumulative Sales)
RanksToShow, a seperate peremeter is also created

Here, a graph of cumulative sales and the ranking of product category is visualized.

page 02.PNG

Page03:

Used DAX

Visualizing DAX Calculations

In this part, the visualized data represents the realtion between the total sales and the customer countries to identufy customers of which country boosted the company's sales. Use of map, bar charts and slicer is seen here.