participating in Enterprise DNA programs, I prepared reports on three topics in
first report I will share will be Sales Analysis.
the Power BI report and the relevant source file (in Excel format) are included
in the Appendix.
the required KPIs in the report measures are written in DAX.
is, according to your filters, you can get Total revenue, Total sales, unique orders,
Average daily sales amounts and units and income margin.
in the form of pie charts according to regions, product groups and store groups
(top, good and bad) was also included in the report.
can filter according to sales channels and time based on months.
revenues by running total sales, Cumulative sales and quarters are shown in the
running Revenue has been included in the report in the form of an area chart,
comparatively in the current month and the previous month.
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.
measures have been written in this report.