Businesses benefit from Sales Performance Analysis in a variety of ways, including finding areas for development, measuring progress, and boosting revenue. 📊💹
I analyzed the Primal Coffee sales order data and conducted a sales performance analysis.
Primal Coffee is a large multinational beverage company that produces and sells different varieties of coffee, including Arabica, Liberica, Robusta, and Excelsa, across the United States, the United Kingdom, and Ireland.
Additionally, Primal Coffee has a reward system for its customers with the highest order and also for its high-value customers in a particular month and year.
In this Sales Performance Dashboard, I provided the following insights:
📌 The current market demand for the company's products and how it varies with the different coffee type.
📌 The current sales performance and how it compares across the different coffee type and region.
📌 The most loyal customers in terms of total sales and orders made.
Steps taken toward the completion of this project include:
✔ Installing Database backup
✔ Reading through requirements and preparing user story
✔ Identifying required tables
✔ Cleaning tables and creating views in Microsoft Excel
✔ Connecting the excel file to PowerBI
✔ Data transformation in Power Query
✔ Data Modeling
✔ Data Visualization and
✔ Publishing to Power BI Service
The database used for this project was taken from the Data by Mo YouTube page. Working on the entire project phase would help you improve your data analysis skills if you are a data enthusiast.
If you are also interested in working on it, visit the Data with Mo Youtube page, take the Microsoft Excel Playlist by Data by Mo, and take EXCEL PORTFOLIO PROJECT | Build this Interactive Dashboard that is third on the list. You’ll be glad you did.
Link to the Playlist here - https://www.youtube.com/watch?v=DMkELaSvBYI&list=PLodYDTuHA29aFro3j4-Wsakm0jI8enRiN
And feel free to interact with my dashboard here - https://www.novypro.com/project/primal-coffee-sales-performance-dashboard
And follow my portfolio page @ https://www.novypro.com/profile_projects/sowunari
#salesanalysis #datavisualization #businessintelligence