Fitness Company Finance Analysis

Summary

Report submitted for Onyx Data DataDNA ZoomCharts Mini Challenge, August 2024. The report was built based on Fitness Company Finance Dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI. 

Author's description: 

Step 1: Data Understanding
The first step was to dive into the dataset, which includes financial information for a company specializing in sportswear, nutrition, and sports equipment. I thoroughly examined the data, analyzing its structure, including the number of columns and rows, to gain a clear understanding of what I was working with.

Step 2: Building the Star Schema Model
Next, I developed a star schema model to organize the data efficiently. This involved separating quantitative data into a fact table and creating dimension tables for various entities. This approach ensures the data is structured in a way that supports effective analysis.

Step 3: Defining Key Performance Indicators (KPIs)
I then defined six critical KPIs to measure the performance of the business lines. These KPIs include Revenue, Expenses, Gross Profit, Net Profit, EBIT, and COGS. These metrics provide a comprehensive overview of the company’s financial health and operational efficiency.

Step 4: Dashboard Design
Finally, I focused on designing the dashboard. I used PowerPoint to create a visually appealing background for the report.