ANALYSIS OF A COMPANY'S BATTERY SALES USING POWER BI

Project: ANALYSIS OF A COMPANY'S BATTERY SALES FOR THE YEARS 2022-2024

Tool used: Power BI

Description

The project is an analysis of the sales of batteries by company X. The objectives of the project was to determine:

• Sales analysis trend for the years 2022-2024 (As of May)
• Brand penetration of the batteries
• Sales projection for the rest of the year 2024

Project Execution

• Data cleaning using power query in Power BI to ensure right formats, data types and deal with blank cells.
• Creation of date table to aid in data evaluation across time series
• Creation of visualizations to establish relationships between various data sets, to answer the project objectives.