Objective: This project is part of my Data Analytics Portfolio and demonstrates my advanced skills in data analysis, visualization, and reporting using Microsoft Power BI, Excel, and Python. It involves data cleaning, transformation, and the creation of dynamic, interactive reports, providing actionable insights for strategic decision-making.
- Seasonality in Sales: Identified a 25% revenue increase during Q4, particularly around the holiday season, enabling better demand forecasting and resource planning.
- Regional Performance: Highlighted the Southeast as the top-performing region (15% YoY growth), while the Midwest underperformed (5% growth), suggesting opportunities for market realignment.
- Profit Margins: Discovered key product lines with high revenue but low profitability, leading to strategic discussions on pricing and cost optimization.
- Multi-Source Integration: Integrated multi-currency sales data using Python-generated exchange rate tables, providing a global sales view and aiding international decision-making.
- Forecasting: Built predictive sales models using advanced DAX functions, forecasting a 10% increase in revenue for the upcoming quarter.
- Excel: Applied formulas for data cleaning and preparation, ensuring a well-structured dataset for Power BI integration.
- Python (Pandas): Generated and integrated exchange rate tables to support multi-currency sales analysis.
- Imported Excel data into Power BI, cleaned, and transformed it using Power Query.
- Built comprehensive Data Models using a Snowflake Schema, supporting accurate relational data analysis.
- Created custom calculations using DAX to generate insights, including advanced sales forecasts and profitability metrics.
- Developed interactive dashboards to visualize trends, product performance, and regional sales, providing stakeholders with clear and actionable data.
- Published reports to Power BI Service for real-time collaboration, enabling stakeholders to access interactive dashboards anytime, anywhere.
- Configured mobile views, making critical data accessible on mobile devices, supporting decision-making on the go.
As part of the project, I developed a Profit Overview Report that highlights key profit metrics through various visualizations:
- Net Revenue by Product: A bar chart visualizing product-level net revenue, enabling better product strategy decisions.
- Yearly Profit Margin by Country: A donut chart presenting profit margin distribution across different countries.
- Yearly Profit Margin Over Time: An area chart tracking profit trends over time, helping stakeholders monitor long-term profitability.
Additionally, key metrics such as YTD Profit and Net Revenue USD were displayed using cards for quick reference, and a KPI for Gross Revenue USD provided real-time performance tracking.
To provide executives with a high-level, mobile-friendly view of the company’s global performance, I developed an Executive Dashboard that focuses on key metrics such as sales quantities and profit margins:
- Sales Overview Visuals: Included visuals like Loyalty Points by Country, Quantity Sold by Product, and Median Sales Distribution by Country.
- Profit Overview Visuals: Pinned key charts such as Net Revenue by Product, Yearly Profit Margin by Country, and Yearly Profit Margin Over Time.
- Card Visualizations: Displayed YTD Profit, Net Revenue USD, and Gross Revenue USD as cards and KPIs for quick, actionable insights.
- Mobile Layout: Configured a mobile-friendly layout for easy access to key metrics and visuals from mobile devices, ensuring that important data is available anywhere.
To ensure stakeholders are always informed, I configured alerts and subscriptions to provide timely updates on key performance indicators.
- Created a daily alert for Gross Revenue USD, which triggers if revenue falls below $400, ensuring immediate action if revenue decreases.
- Sales Weekly Summary: A subscription that provides an overview of key sales metrics, delivered every Monday at 5:00 AM, helping stakeholders stay on top of sales performance.
- Profit Weekly Summary: Another subscription for profit metrics, delivered every Monday, Wednesday, and Friday at 6:00 AM, providing regular updates on profitability.
These alerts and subscriptions ensure that the executive team receives regular, proactive updates, enabling them to make data-driven decisions with confidence.
You can access the Tailwind Traders Executive Dashboard online through Power BI Service by clicking the link below:
Ensure you have the necessary access to view the dashboard, which may require a Power BI Pro license or relevant workspace permissions.
- Microsoft Excel: Data cleaning, preparation, and transformation using advanced formulas.
- Microsoft Power BI: Data visualization, Power Query, DAX for custom calculations, and interactive dashboards.
- Power BI Service: Publishing and sharing reports, along with configuring alerts and subscriptions for proactive insights.
- Python (Pandas): Generated exchange rate tables for multi-currency analysis.
- Git: Version control for tracking project updates and ensuring smooth collaboration.
- Power BI Desktop & Service:
- Download and open 'Tailwind-Traders-Analysis.pbix' in Power BI Desktop to explore interactive dashboards and integrated data from both Excel and Python sources.
- Alternatively, view the dashboards on Power BI Service for real-time insights accessible online.
This project generated several actionable insights:
- Product and Sales Performance: Identified high-revenue products with varying profitability, leading to strategic adjustments in pricing and marketing.
- Regional Analysis: Highlighted regions with underperformance, such as the Midwest, prompting the need for targeted strategies.
- Predictive Sales Models: Developed sales forecasts predicting growth in the Southeast region, aiding resource planning for future quarters.
- Multi-Source Integration: Enabled multi-currency sales analysis, providing global insights for international operations.
This project demonstrates my ability to handle end-to-end data analysis, from preparation to advanced visualization and real-time reporting. By integrating Excel, Power BI, and Python, along with leveraging Power BI Service for alerts and subscriptions, I delivered a comprehensive solution for data-driven decision-making. Through systematic project management using Git, this project showcases professionalism and a structured approach to delivering insights.
For more information about this project or to discuss potential collaboration opportunities, feel free to connect:
- LinkedIn: thiago-dejesus
- GitHub Portfolio: sthjes87
- Email: thiagojesus_87@hotmail.com