This capstone project was built as part of the Microsoft Power BI Data Analyst Professional Certificate on Coursera. It simulates a real-world business scenario for Tailwind Traders, where I analyzed global sales and profitability using Power BI, DAX, and Power Query.
The project challenged me to apply core data analytics skills — from data cleaning and modeling to building a professional dashboard that offers deep business insights.
📌 Tools Used: Power BI Desktop, Power Query, Excel, DAX
The Tailwind Traders project was designed to assess how well analytical tools can support real business decision-making. The dashboard answers key questions across sales, profit, and product performance:
- 📈 What is the overall revenue, gross profit, and year-to-date (YTD) performance?
- 🌍 Which countries contribute the most to total revenue and profit margin?
- 💸 What are the most profitable and least profitable products?
- 🛒 How does stock level compare with quantity purchased and sold?
- 🎯 What is the distribution of loyalty points across regions?
- 🕒 How do median sales fluctuate over time?
- 🔢 What is the breakdown of net revenue and profit by product category?
- 📊 How do yearly profit margins trend over time?
- 🧮 What is the correlation between revenue metrics and time periods?
- 🧠 How can we use these insights to make pricing, inventory, or marketing decisions?
- Clean and transform raw Excel files using Power Query
- Build a semantic model with appropriate relationships
- Create calculated columns and DAX measures (e.g., Net Profit, YTD Sales)
- Develop a multi-page Power BI dashboard with slicers and cross-filters
- Translate raw data into actionable executive insights
| Section | Description |
|---|---|
| 📄 Tailwind Traders Report (PDF) | View Dashboard as PDF |
| 📊 Profit Overview (PNG) | Profit visuals from the report |
| 📈 Sales Overview (PNG) | Sales performance page |
| 📂 Raw Data | Includes Excel files: TailwindProject, Purchases, Countries |
| 📘 About the Project | Background and project explanation |
| 📚 Project Overview | Summarized insights and features |
| 📂 Tailwind Traders Report.pbix | Fully interactive Power BI dashboard |
- Visual breakdown of revenue and profit by region, segment, and product line
- Deep dive into high- and low-performing product categories
- Created custom KPIs: Net Revenue, YTD Profit, Cumulative Sales%
- Applied data normalization and relationship modeling
- Designed for use by sales, marketing, and finance teams
- Built to support monthly business reviews, customer retention tracking, and regional performance analysis
- Dynamic KPI cards for total sales, profit, and customer base
- Slicers for geography, customer segment, and product category
- Multi-page navigation (Sales, Profit, Product Breakdown)
- Clear visual hierarchy for storytelling and insight delivery
I'm Ananth Ajith, a designer-turned-analyst passionate about bridging creative thinking and data-driven decision-making. This capstone project reflects my ability to build effective dashboards, solve business problems, and communicate findings to stakeholders.
- Project guided by: Coursera – Microsoft Power BI Data Analyst Certificate
- Data is fictional and used for educational purposes only
- Dashboard created in Power BI Desktop as part of a professional portfolio
🚀 Dive into the visuals, explore the report, and view how insights evolve from raw data to executive storytelling!