I will do data cleaning, structuring, analytics and power bi visualization dashboards

R
ruby_rrana
R
ruby_rrana
Ravi Rana
Parte de la información aparece en idioma inglés.
do data cleaning, structuring, analytics and power bi visualization dashboards
Pantalla completa
do data cleaning, structuring, analytics and power bi visualization dashboards
Pantalla completa
do data cleaning, structuring, analytics and power bi visualization dashboardsdo data cleaning, structuring, analytics and power bi visualization dashboards

Acerca de este Servicio

Data Analysis | Visualization dashboards | Power BI | Excel & power query | Operational Excellence


Problem statement-

For a fine dining restaurant had an issue with tracking kitchen wastage and analyzing whether high value inputs (meat, dairy, cheese, proteins) were fully reflected in prepared dishes. The client had no system to measure efficiency or pinpoint losses.


Systematic Process Followed-

Data Collection: Gathered sales, material orders, issue notes, GRNs, and daily stock records.

Recipe Database: Built a structured menu database with unique codes and ingredient quantities.

Data Cleaning & Structuring: Organized datasets using Excel and Power Query for consistency.

Analytics & Modeling: Applied Power BI DAX to measure input vs. output, classify materials, and calculate variances in weight and monetary terms.

Advanced Analysis: Used histogram and Pareto methods to identify key wastage drivers and prioritize focus areas.


What I delivered-

Interactive Dashboards

Data Cleaning & Transformation

Analytics & Insights

Custom visualizations

Operational insights


Contact me to unlock the power of your data with professional analytics and visualization solutions!


Best

Ravi

  • Herramienta

    • Power BI

  • Tipo de gráfico

    • relación
    • KPI
    • Gráfico de barras
    • Perspectivas
    • Análisis
    • Histograma

Conoce a Ravi Rana

Ravi Rana

Data, Decisions and Impact, Analytics Dashboards and Business Models

  • DeSri Lanka
  • Miembro desdemar 2026
  • Responde aprox. en:1 hora

  • Idiomas

    Inglés
Hi I'm Ravi, I bring expertise in Data analytics, Analytical insights, BI dashboards, Excel automation, Operations modeling, Financial modeling and Project management. I bring operational to strategic level real business experience and a strong commercial sense—understanding where problems truly lie and helping clients make data‑driven decisions with actionable insights. Backed by a multidisciplinary background in manufacturing, industrial engineering, advanced analytics, supply chain, hospitality, financial services and commerce, I deliver practical solutions that drive measurable impact.

Mi porfolio

Etiquetas relacionadas