Farman Ullah

Project OverviewThis 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.⚠️ Note: This project uses a public/sample dataset and does not contain any real company or confidential data.🛠 Tools & TechnologiesExcel – Data cleaning, preparation, and pivot analysisSQL – Data querying, aggregation, and trend analysisPower BI – Interactive dashboards, KPIs, and DAX measures📊 Dataset Description700+ sales transaction recordsKey fields include:CountryProductSegmentSalesProfitUnits SoldDiscount BandDate (Month / Year)The dataset was cleaned and structured to ensure accuracy and consistency before analysis.🔍 Analysis PerformedCountry-wise sales and profit analysisProduct-level profitability evaluationSegment performance comparisonDiscount impact on profit marginsMonthly and yearly sales trend analysis📈 Power BI Dashboard FeaturesThe Power BI dashboard includes:KPI CardsTotal SalesTotal ProfitProfit Margin (%)Units SoldInteractive VisualsSales by CountryProfit by ProductSegment-wise performanceMonthly sales trendSlicersYearCountrySegmentDAX measures were used to calculate key business metrics and enable dynamic analysis.📌 Key InsightsCertain products generate higher profit margins despite lower sales volumeHigh discount levels have a negative impact on profitabilitySales performance varies significantly across regions and seasonsSpecific segments consistently outperform others in profit contribution✅ OutcomeThis project highlights practical Data Analyst skills, including:Data cleaning and preparationBusiness-focused analysisSQL-based data explorationDashboard design and storytelling using Power BI📂 Repository ContentsCleaned Excel datasetSQL analysis queriesPower BI dashboard file (.pbix)Project documentation💼 Portfolio NoteAll content in this repository is shared for learning and portfolio demonstration purposes only.