I will build a power bi dashboard for gps fleet management and cost tracking

Argentina

I speak Spanish, English

1 order completed

Data Analyst, Power BI, Excel, Dashboards for Business

Do you have scattered data and don't know how to use it? I specialize in turning data into interactive Power BI dashboards and automated Excel tools that help you make better business decisions. What...
About this Gig


I developed an interactive Power BI dashboard for a GPS tracking company in Mexico managing over 50 vehicles.


The problem:

The client had data scattered across the Wialon platform with no way to visualize operational costs, fuel efficiency, or metrics for decision-making.


The solution:

Dashboard with 3 specialized views:


  • Executive View: KPIs for management (total cost, km traveled, idle alerts)
  • Operational View: Performance by vehicle, consumption deviation, max speed
  • Financial View: Cost per km, monthly trends, distribution by vehicle type


Deliverables:


  • Fully functional .pbix file
  • Documented KPI dictionary
  • User procedures manual
  • Complete technical documentation


Tools: Power BI, DAX, Power Query, Excel

Data modified to protect client confidentiality.

















Analysis type:

Quantitative Analysis

Qualitative Analysis

Expertise:

Alerts

Trends

Anomaly detection

Math

Statistics

Technology:

Excel

Power BI

Other

Programming language:

DAX

My Portfolio