A focused analysis project tackling specific business questions provided by Tata Forage using Microsoft Power BI. The goal was to transform raw sales data into clear, actionable insights to inform strategic decision-making.
To demonstrate proficiency in data analysis and visualization by answering key business questions and providing data-driven recommendations.
- Data Loading & Transformation: Power Query
- Data Modeling: Creating relationships between tables
- Metrics Calculation: DAX (Data Analysis Expressions)
- Data Visualization: Building effective and clear charts
- Analysis: Deriving insights from complex datasets
I addressed the following key questions posed by the organization:
- Answer: Identified February as the peak revenue month ($523,631.89), providing a clear target for analyzing successful strategies.
- Visual: Created a line or bar chart showing revenue by month.
- Answer: Ranked top-performing markets, revealing the Netherlands ($273K) and EIRE ($214K) as the highest revenue-generating countries. This highlights key markets for focused investment.
- Visual: Built a map or horizontal bar chart showing revenue by country.
- Answer: Analyzed customer revenue contribution, identifying the top 10 customers by Customer ID (e.g., #14646, #18102, #17450). This is crucial for developing customer retention strategies.
- Visual: Designed a table or bar chart ranking customers by revenue.
- Data Understanding: Examined the provided dataset to understand its structure and quality.
- Data Preparation: Used Power Query to clean and transform the data, ensuring it was analysis-ready.
- Data Modeling: Established correct relationships between data tables (if multiple were provided).
- Measure Creation: Wrote DAX formulas to calculate key metrics like total revenue.
- Visualization: Developed clear, purposeful visuals that directly answered each business question.
- Insight Synthesis: Interpreted the visualizations to provide concise, actionable answers and recommendations.
Based on the analysis, the core recommendations for the business would be:
- Capitalize on February's Success: Investigate the marketing tactics, product offerings, or external factors that led to the revenue peak in February and replicate them.
- Focus on High-Yield Markets: Allocate more marketing and operational resources to top-performing countries like the Netherlands and EIRE.
- Implement a Customer Retention Program: Develop a strategy to nurture and retain the top-tier customers identified in the analysis, as they contribute significantly to overall revenue.
- Tool: Microsoft Power BI Desktop
- Data Source: Provided sales transaction data (CSV/Excel)
- Key DAX Measures Used:
Total Revenue = SUM(Sales[Revenue])
Sales_Analysis.pbix- The main Power BI report file.README.md- This file.
