Sales and Market Insights for Atliq Hardware | Project video скачать в хорошем качестве

Sales and Market Insights for Atliq Hardware | Project video

In this project, I built a complete Sales & Market Insights Dashboard using Power BI and MySQL to analyze multi-year sales data and generate actionable business insights. The objective of this project was to transform raw transactional data into structured dashboards that support data-driven decision-making for revenue growth, profitability tracking, and market performance analysis. 🔹 Tools & Technologies Used: Power BI MySQL Power Query DAX ODBC Connectivity 🔹 Project Highlights: Connected MySQL database to Power BI using ODBC Cleaned and transformed multi-year sales data using Power Query Designed a Star Schema data model for optimized reporting Created DAX measures for Revenue, Profit, Profit Margin %, Contribution %, and YoY growth Built interactive dashboards with slicers for Market, Product, and Customer analysis Identified top-performing markets and underperforming segments Performed trend analysis to evaluate revenue patterns over time 🔹 Key Business Insights Generated: Revenue contribution by different markets Profitability comparison across products Customer-level revenue distribution Identification of high-margin segments Year-over-Year performance trends This project demonstrates my ability to handle end-to-end data analysis — from data extraction and modeling to visualization and business insight generation. 📌 If you are hiring for Data Analyst or MIS roles, feel free to connect with me. LinkedIn: (https://www.linkedin.com/in/akshita-dhillo...) GitHub: (https://github.com/Akshita7037) #PowerBI #DataAnalytics #SQL #BusinessIntelligence #MISReporting #DashboardDesign #DataAnalyst #PortfolioProject