Overview

Hello,

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 bad) 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 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.

Tags
Reviews Add a review
No reviews yet

More From Ilgar Zarbaliyev

Browse our top rated business templates. See All
Row, Column, Index, Match, Offset Functions. Excel Tutorial
511
53
 “It's Excel's world, we just live in it.” “To be an accountant in the age of spreadsheet program is —…
New Dynamic Functions. Excel Tutorial
530
47
In September, 2018, we released dynamic array formulas for Excel for Microsoft 365. The differences between dynamic arrays and legacy…
Fill Series. Data Validation. Excel Tutorial
522
42
 If you have inherited workbooks from someone else or if you have imported data from external data sources, you have…
HR INSIGHTS DASHBOARD
3,377
112
 This report includes the necessary analyzes according to some characteristics of the people who made and participated in the job…
Supplier_Insights
3,570
101
 Hello, This report is consisted of four pages. 1-Supplier Quality Metrics 2-Supplier Quality Regional 3-Top - Bottom Analysis 4-Downtime Analysis…
What_If_Analysis_Data_Table
3,776
144
Data Table: It is a range of cells where one column consists of a series of values, called input cells…
See All