Ravindra BagaleCourses & study guides मराठी Track your progress

28. End-to-End Project: Blinkit Quick-Commerce Dashboard

By Last updated:

Come on, friends, now let us use everything we learned together – one full Blinkit quick-commerce dashboard project. Every step from requirements to publishing. This project will help a lot for your resume and interviews, so finish it yourself.

Project goal

Build a Blinkit quick-commerce operations and sales report for six Maharashtra cities (Pune, Nashik, Nagpur, Kolhapur, Mumbai, Sambhaji Nagar) from raw files – plus a Blinkit vs Amazon Now comparison page – publish it to the Power BI Service, secure it with RLS and schedule a refresh. All data is fictional sample data. Use this chapter as a checklist for your own portfolio project.

Live story: The full Blinkit Maharashtra project

Suppose we are hired to build the Blinkit quick-commerce dashboard for six Maharashtra cities, from raw files to a published app. Every earlier chapter is one step of this project. At the end we have one PBIX, an RLS demo and a published report: the three things interviewers ask to see.

All numbers in this story are fictional practice data.

Concepts in this chapter

  1. 28.0Beginner checkpoints (before you chase polish)
  2. 28.1Business Requirements
  3. 28.2Step 1 – Prepare the Raw Data
  4. 28.3Step 2 – Get Data and Transform in Power Query
  5. 28.4Step 3 – Build the Data Model
  6. 28.5Step 4 – Create the Measures
  7. 28.6Step 5 – Design the Report Pages
  8. 28.7Step 6 – Security
  9. 28.8Step 7 – Check Performance and Quality
  10. 28.9Step 8 – Publish and Automate

The chapter recap is at the end of the last concept page.

Ravi Sir's Cards: 12 revision, interview and comparison cards for this chapter · मराठी cards