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


About this gig
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
Get to know Ravi Rana
Data, Decisions and Impact, Analytics Dashboards and Business Models
- FromSri Lanka
- Member sinceMar 2026
- Avg. response time1 hour
Languages
English

