Sales Performance Insights
A Power BI report analysing first- quarter sales performance using transactional business data.
A Power BI report analysing first- quarter sales performance using transactional business data.
The project was completed as part of the Generation UK Data Analyst Programme using anonymised training data representing business sales performance.
The aim for the project was to explore first- quarter sales performance and develop a Power BI report that answers key business questions and supports data-driven decision-making.
The project followed a structured process from preparing the data to presenting insights clearly:
Imported the CSV sales dataset into Power BI Desktop
Promoted the first row to headers to correctly structure the data
Reviewed and corrected data types to ensure dates and numerical values were formatted correctly
Finalised the dataset for analysis in Power BI
To support time-based analysis, I created additional date fields:
Extracted the month name for the transaction date to enable month-level reporting
Created a month number column to ensure months were displayed in the correct chronological order within visuals
Built visuals to answer key business questions about revenue, product performance, store performance, and monthly trends
Used KPI cards, bar charts, a tree map, and a line chart to present findings clearly
Added written insight summaries to explain what the visuals showed
Power BI report visualising Q1 sales performance across products, stores and time periods.
Sales increased from January to February before declining in March, suggesting a possible seasonal trend or short-term demand spike.
Laptops were the strongest category overall, with high products driving a large share of total revenue.
Store B had the highest number of units sold, indicating a stronger sales performance compared to other locations.
The Galaxy Tab, Charger, and Samsung S23 were the best- selling products, showing a demand across different product types rather than just one category.
Based on the analysis of the first quater sales performance, the following actions could support improved business outcomes.
Maintaining strong stock availability and targeted promotions for high-performing categories could help sustain overall sales performance.
Present more opportunities for top-selling products, such as strategic promotions, bundling, or feature placement, to maximise revenue.
Ongoing monitoring of monthly trends could help identify seasonal patterns and support more informed sales planning.
Investigate operational or promotional differences between store locations to identify successful approaches that could be implemented more widely.
This project improved my confidence in preparing raw data and designing reports that clearly communicate insights. I strengthened my time- based analysis and learned how thoughtful visual design can make findings more accessible to business users.