Sales Analysis Report
Originally published: 29/03/2021 13:52
Publication number: ELQ-44531-1
View all versions & Certificate
certified

Sales Analysis Report

Sales Analysis Report Template in PowerBI - to download.

Description
After participating in Enterprise DNA programs, I prepared reports on three topics in Power BI.

The first report I will share will be Sales Analysis.

Both the Power BI report and the relevant source file (in Excel format) are included in the Appendix.

Finding the required KPIs in the report measures are written in DAX.

That is, according to your filters, you can get Total Revenue, Total sales, Unique Orders, Average Daily Sales Amounts and Units and Income Margin.

Information in the form of pie charts according to regions, product groups and store groups (Top, Good and Worst) was also included in the report.

You can filter according to sales channels and time based on months.

Total Revenues by Running Total Sales, Cumulative Sales by Months and Quarters are shown in the report.

Total Running Revenue has been included in the report in the form of an Area Chart, comparatively in the Current Month and the Previous Month.

Finally, the information you will find in the report is shown in the form of a Map of the revenue distribution according to the characteristics of Total Revenue, Total Sales Quantity, Unique Orders, Average Daily Sales Amount.

Seventeen measures have been written in this report.

This Best Practice includes
One Power BI Report

Ilgar Zarbaliyev offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Users who deal with Sales Analysis

Intermediate Level Power BI Users

Beginner Level Power BI Users

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Ruth Mitchell(last updated: 01/06/2021 21:07)
  • Maha Khalid(last updated: 27/04/2021 12:33)
  • Amir Ganic(last updated: 01/04/2021 11:45)

keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Ilgar Zarbaliyev

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Sales Analysis Report?

The user community and author are here to help. Go ahead!


4.7 / 5 (3 votes)

please wait...