The project helps Tailwind Traders analyze their sales performance across different countries, calculate revenue metrics in USD, and create interactive dashboards for data-driven decision making
-
Data Preparation in Excel
-Calculate Gross Revenue
-Calculate Total Tax
-Calculate Net Revenue
-
Data Configuration in Power BI
-File: scripts/data_preparation.py
-
Data Modeling in Power BI
-File: power-bi/Tailwind Traders Report.pbix
--Create Relationships
--Create Calendar Table (DAX)
--Create Sales in USD Table (DAX)
-
DAX Measures Creation
-Yearly Profit Margin
-Quarterly Profit
-Year-to-Date Profit
-Median Sales
-
Report Creation
-Sales Overview Report:
--Loyalty Points by Country
--Quantity Sold by Product
--Median Sales Distribution by Country
--Median Sales Over Time
--Key metrics cards
Profit Overview Report:
--Net Revenue by Product
--Yearly Profit Margin by Country
--Yearly Profit Margin Over Time
--Key metrics cards
--Gross Revenue USD
-
Dashboard Publishing
-Create "Tailwind Traders Executive Dashboard"
-Pin visualizations from both reports
-Configure mobile layout
-Set up data refresh schedule
-
Alerts and Subscriptions
-Daily Alert: Gross Revenue USD below $400
-Subscription: Sales Weekly Summary (Mondays at 5:00 AM)
-Subscription: Profit Weekly Summary (Mon, Wed, Fri at 6:00 AM)
-Multi-currency sales analysis
-Interactive dashboards with cross-filtering
-Time intelligence calculations
-Mobile-optimized layout
-Automated alerts and subscriptions
-Comprehensive data model with star schema
-Microsoft Power BI for visualization and reporting
-DAX for calculations and measures
-Microsoft Excel for initial data analysis
-Power BI Service for deployment and sharing
The solution provides Tailwind Traders with:
-Global sales performance in USD
-Product and category performance analysis
-Customer loyalty insights
-Time-based trend analysis
-Automated monitoring through alerts and subscriptions
This project is licensed under the MIT License. You are free to use, modify, and share this project with proper attribution.
Hi there! I'm Shoaib Dyre, an aspiring Data Analyst passionate about transforming raw data into meaningful insights. This GitHub repository showcases my journey in learning data analysis, including projects, SQL queries and analytic reposts.
-Curious about data – I love exploring datasets, finding patterns, and telling stories through numbers.
-Skills in development: SQL, Python (Pandas, NumPy), Excel, Power BI and data cleaning.
-Goal: Land my first Data Analyst role and contribute to data-driven decision-making.