I will build interactive excel dashboards using power pivot

Nigeria

I speak English

Excel Data Analyst

Hi! I'm a data analyst specializing in Excel & Power BI. I help businesses turn raw data into organized, and useful reports. Whether you need help with messy spreadsheets, or interactive dashboards, ...
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