I will create KPI performance dashboard on ms excel by pivot table

A
auralie_zevan
A
auralie_zevan
Auralie Z
create KPI performance dashboard on ms excel by pivot table
Full Screen
create KPI performance dashboard on ms excel by pivot table

About this gig

Are you looking to transform your raw data into clear, actionable insights? I'm a Data Visualization Engineer specializing in KPI dashboards, Excel dashboards, Power BI dashboards, and Google Sheets dashboards that make decision-making effortless and professional.

With my service, you'll get:

  1. KPI tracking & real-time performance monitoring
  2. Dynamic visuals charts, slicers, and filters
  3. Automation using VBA, macros, and Power Query
  4. Custom dashboard layout & design for clarity


Excel Expertise Includes:

Formulas: SUM, IF, VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS

Tools: Pivot Tables, Conditional Formatting, Power Query, VBA, Dynamic Arrays


Services Offered:

  1. KPI & Business Dashboards
  2. Inventory & Budget Dashboards
  3. MTTR/MTBF Reports & Team Trackers
  4. Gantt Charts & Project Tracking
  5. ️ Data Cleaning, Automation, and Analysis

Tools I Use: Power BI | Excel | Google Sheets | Looker Studio | PowerPoint | Word


Delivering accurate, automated, and visually appealing dashboards that drive smart decisions.

  • Tool

    • Excel

  • Chart type

    • Comparison
    • Distribution
    • Hierarchy
    • Range
    • User interaction
    • Time series
    • Analytics

Get to know Auralie Z

Auralie Z
  • FromUnited States
  • Member sinceJun 2025
  • Avg. response time1 hour

  • Languages

    English
Hi, I'm Zevan a solar energy engineer with 5+ years experience in the design of PV solar energy systems : residential, commercial and utility-scale. My expertise includes generating a detailed report contains 3d simulation ,production forecast , Circuit diagram , shading analysis and other features. I use mainly Pvsol as a design software along with Pvsyst.

Other Data Visualization Services I Offer

Related tags