Farman Ullah

<p>Project Overview</p><p>This project demonstrates an end-to-end data analysis workflow using a sample financial sales dataset. The objective is to analyze sales performance, profitability, product trends, and regional insights to support data-driven decision-making.</p><p>⚠️ Note: This project uses a public/sample dataset and does not contain any real company or confidential data.</p><p>🛠 Tools & Technologies</p><p>Excel – Data cleaning, preparation, and pivot analysis</p><p>SQL – Data querying, aggregation, and trend analysis</p><p>Power BI – Interactive dashboards, KPIs, and DAX measures</p><p>📊 Dataset Description</p><p>700+ sales transaction records</p><p>Key fields include:</p><p>Country</p><p>Product</p><p>Segment</p><p>Sales</p><p>Profit</p><p>Units Sold</p><p>Discount Band</p><p>Date (Month / Year)</p><p>The dataset was cleaned and structured to ensure accuracy and consistency before analysis.</p><p>🔍 Analysis Performed</p><p>Country-wise sales and profit analysis</p><p>Product-level profitability evaluation</p><p>Segment performance comparison</p><p>Discount impact on profit margins</p><p>Monthly and yearly sales trend analysis</p><p>📈 Power BI Dashboard Features</p><p>The Power BI dashboard includes:</p><p>KPI Cards</p><p>Total Sales</p><p>Total Profit</p><p>Profit Margin (%)</p><p>Units Sold</p><p>Interactive Visuals</p><p>Sales by Country</p><p>Profit by Product</p><p>Segment-wise performance</p><p>Monthly sales trend</p><p>Slicers</p><p>Year</p><p>Country</p><p>Segment</p><p>DAX measures were used to calculate key business metrics and enable dynamic analysis.</p><p>📌 Key Insights</p><p>Certain products generate higher profit margins despite lower sales volume</p><p>High discount levels have a negative impact on profitability</p><p>Sales performance varies significantly across regions and seasons</p><p>Specific segments consistently outperform others in profit contribution</p><p>✅ Outcome</p><p>This project highlights practical Data Analyst skills, including:</p><p>Data cleaning and preparation</p><p>Business-focused analysis</p><p>SQL-based data exploration</p><p>Dashboard design and storytelling using Power BI</p><p>📂 Repository Contents</p><p>Cleaned Excel dataset</p><p>SQL analysis queries</p><p>Power BI dashboard file (.pbix)</p><p>Project documentation</p><p>💼 Portfolio Note</p><p>All content in this repository is shared for learning and portfolio demonstration purposes only.</p><p></p>