Data Analyst Portfolio Kit: SQL + Power BI with zeba shaikh

Best Seller

Data Analyst Portfolio Kit: SQL + Power BI

zeba shaikh

zeba shaikh

Hi! 👋 I’m a Data Professional with 3+ years of experience.

2 ratings and 29 bookings across all services

Digital Product
1Sales

About this product

A complete data analyst portfolio project: Sales Performance Analytics using SQL + Power BI, built on an Indian retail dataset

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.

Who this is for

  • Freshers, final-year students and career switchers who know some SQL or Excel but have no project to show
  • Anyone whose portfolio is a generic Titanic or Superstore notebook and wants something that looks like a real business problem
  • People who want to *understand* an end-to-end analysis, not just copy a dashboard

Who this is NOT for

  • Anyone looking for a shortcut to a job. This is a project kit, not a guarantee. You still have to learn it, change it and explain it.
  • Mac-only users who cannot run Power BI Desktop (it is Windows software). You can still use the SQL and analysis parts.
  • Advanced analysts who already have strong end-to-end portfolios.

What's inside

  • Dataset: a Python generator plus ready CSVs: 8,000 customers, 62 products, ~50,000 orders, ~80,800 order lines, ~4,450 returns (synthetic, seed 42)
  • 8 BigQuery SQL scripts (data-quality checks, monthly growth with LAG, top customers, category profitability, RFM segmentation, cohort retention, returns analysis, Power BI reporting view), each with the business question, the skills used and the insight to find
  • BigQuery setup guide (free sandbox, no credit card)
  • Power BI build guide: star schema, date table, relationships, 5 dashboard pages + a drill-through page, and a design checklist
  • DAX cheat sheet: ~40 measures (time intelligence, ranking, repeat-customer logic, Indian-style ₹ lakh/crore labels)
  • Custom Power BI theme
  • Tie-out table: the exact numbers your dashboard should show, so you know your build is right
  • Insights and executive-summary template, with five worked business findings
  • GitHub README template, resume bullets, 3 LinkedIn post templates
  • 15 interview questions and answers written specifically for this project, plus a 2-minute walkthrough script
  • Finished `.pbix` file (Power BI)

The problem

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.

What you will build

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?

What you will be able to do after

- 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

About the data (honest disclosure)

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.

FAQ

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].

What are people saying

Thank you
Anonymous
Oct 2026
₹99