Marie Camara | BI Analyst

Financial Performance Analysis

Finance

Industry: Finance

Role: Financial Analyst

Business problem

Revenue is rising, yet profitability is falling due to a drop in gross margins from 58% to 54%.

There are no evident performance discrepancies across regions or business units, but reporting is fragmented, relying on static files rather than real-time decision support.

Objectives

  • Consolidate 3 years of financial transaction data
  • Measure key P&L indicators across regions and service lines
  • Identify margin drivers and seasonal patterns
  • Deliver an interactive Power BI dashboard with actionable strategic recommendations.

Methodology and Tools Used

A structured six-stage pipeline — from synthetic dataset construction through interactive Power BI delivery and strategic recommendations.

Data Importation: Created a synthetic dataset of 2,880 financial transactions to simulate professional services performance for FY2022–FY2024, covering 12 key variables.

Data Transformation: Corrected data types, added Year and Month Number columns, and renamed the query to FactTransactions for analysis readiness in Power Query.

Data Modeling: Built a star schema in Power BI with a central fact table (FactTransactions) and four dimension tables (DimDate, DimRegion, DimBusinessUnit, DimProduct), ensuring time intelligence and single-direction filtering.

Data Analysis: Developed 24 DAX measures organized into five categories—Base Financials, Margins, Time Intelligence, Context & Ranking, and Dynamic Titles—for comprehensive profitability analysis.

Data Visualization: Created a 5-page Power BI report featuring an Executive Summary, Revenue & Profitability, Regional & Segment View, Time Intelligence, and Business Unit Drill-Through, incorporating slicers and drill-through navigation.

Tools Used: Microsoft Excel, Power BI, DAX, Power Query (M language), Canva.

Key Deliverables

Every deliverable was designed to support immediate data-driven decision-making.

Key Insights

  • Revenue growth from FY2022 to FY2024 is primarily driven by the Asia-Pacific region, fueled by demand for Digital Transformation and ESG Advisory services.
  • Gross margins decreased from 58% to 54% due to rising COGS, impacting profitability, while EBIT margins remained stable between 26% and 32%.
  • Revenue exhibits significant seasonality, with Q4 exceeding average revenue by 15% to 20%, while Q1 is the weakest quarter.
  • Revenue concentration risk exists, as Audit and Advisory services account for about 55% of total revenue.
  • Assurance and Consulting contribute approximately 60% of net income and 50% of revenue, with higher margins than Tax and Strategy & Transactions.
  • The Asia-Pacific region is the main growth driver, while EMEIA shows the slowest growth.

Recommendations

  • Accelerate investment in Asia-Pacific
  • Close the Q1 revenue gap with retainer structures
  • Recover COGS margins through delivery efficiency
  • Grow underperforming product lines through cross-selling
  • Deploy a real-time profitability dashboard with RLS (Row-Level Security).