Hi! 👋 I’m a Data Professional with 3+ years of experience.
2 ratings and 29 bookings across all services
50,000 orders. 8 BigQuery scripts. A 5-page Power BI dashboard guide. Plus your README, resume bullets and 15 interview answers, so you finish with one project you can actually explain.
Most fresher portfolios fail for the same three reasons: the data is generic, the project stops at charts, and the person cannot explain *why* they chose a metric. Interviewers ask "walk me through your project" and the conversation ends early.
A full analysis of a fictional Indian D2C retail brand, UrbanKart India, answering five real business questions:
1. When does the business earn its revenue, and how fast is it growing?
2. Which categories make profit, not just revenue?
3. Who are the best customers, and who is slipping away?
4. Where is the business strong or weak across Indian states and city tiers?
5. Why do orders come back, and what does Cash on Delivery really cost?
- Explain an analysis from question to recommendation, in plain language
- Write window-function SQL (LAG, RANK, NTILE, running totals) and know *why* you used each
- Build a star-schema model and write real DAX measures
- Show a GitHub repo, dashboard screenshots and a one-page summary
- Answer "tell me about your project" for two minutes without notes
The dataset is synthetic: created for learning, with realistic patterns built in. It is not from a real company and no real customer data is used. The project shows how to analyse; it does not prove real-world facts.
The data has Indian realities built in: COD vs UPI, festive-season spikes, Metro vs Tier-2/3 cities, and COD refusals. Your project will read like it belongs to an Indian business, not a US case study.
Do I need paid software? No. BigQuery has a free sandbox and Power BI Desktop is free (Windows only).
Which SQL does it use? BigQuery syntax. Core logic (CTEs, window functions) carries over to other databases, but date functions need small changes.
I am a complete beginner. Is this too hard? You should know basic SELECT, WHERE and GROUP BY. The guide explains the rest, but it is not an "introduction to SQL" course.
Can I put this on my resume? Yes, as a personal project with synthetic data. The kit shows how to word it honestly.
Will this get me a job? No product can promise that. It gives you a project you can explain; the rest is up to you.
Is the data real? No. It is synthetic and labelled that way.
About the author
Hi, I am Zeba, a data analyst in Pune, India. I have 3+ of experience building Power BI reports and dashboards and working with SQL, BigQuery ETL, Looker Studio and Python (including migrating data from Firestore to BigQuery). I built this kit because I know what it's like to have technical skills but struggle to turn them into a complete, presentable portfolio project. I wanted to create a practical, step-by-step resource that helps freshers and aspiring data analysts understand the process, build their own projects, and confidently explain their work in interviews.
Get the project kit: ₹99
Questions? Message me on LinkedIn -https://www.linkedin.com/in/zeba-shaikh-889255142/ / Email - zebashaikh7744@gmail.com].