I will build interactive excel dashboards using power pivot

Nigeria

I speak English

Excel Data Analyst

Data without structure is just noise—until I clean up your spreadsheets, you’re basically flying blind. I help business owners, managers, and educators turn chaotic data into simple, dynamic Excel to...
About this Gig

I transformed a raw, 45,000+ row banking dataset into an automated Power Pivot Data Model and dynamic executive dashboard. By moving away from lagging grid formulas, I built a system that delivers real-time conversion insights without file bloat or calculation lag.

What I Delivered & Built:

  • Power Query ETL Pipeline: I standardized raw header schemas, cleaned messy text entries, and structured the data for easy automation.
  • Power Pivot & DAX Engine: I created structured data relationships and context-aware DAX measures to calculate dynamic KPIs across thousands of customer records instantly.
  • Executive Dashboard & Visuals: I designed polished horizontal bar charts, KPI summary tables, and intuitive layout hierarchies tailored for executive decision-making.


Technology:

Excel

Power Query

Other

Analysis type:

Quantitative analysis

Descriptive analysis

Expertise:

Web analytics

Business Insights

Business intelligence

Programming language:

DAX

My Portfolio