Portfolio Projects/Executive Ecommerce Dashboard
₹99data analyst · Core Skillintermediate · ~12 Hours

Executive Ecommerce Dashboard

Most of dashboard work isn't SQL or charts - it's stakeholder iteration. A CEO asks for something vague. You translate into a concrete plan, ship a rough first draft, get reactions, iterate, polish. This project drops you into that loop. The reviewer plays the exec: their feedback on your first draft IS the stakeholder reaction you'll respond to. The deliverable is a portfolio piece that shows you can build dashboards *and* survive the conversation around them.

DatabasePostgreSQL
ToolchainTableau Desktop / Tableau Public
Milestones5 Guided Stages
Recruiter OutputVerified GitHub Repo
View 5 Milestones
Full project workspace, live database credentials, AI mentor & verified certificate
Project Deliverables

What You Will Ship to GitHub

Hiring managers don't want to see another cookie-cutter Titanic or Iris tutorial. You will build a professional repository with modular scripts and executive business memos that demonstrate commercial analytical maturity.

github.com/your-username/ecommerce-executive-dashboardPortfolio Structure
├── sql/
01_exploratory_profiling.sql // Schema audits, table volume, date ranges
02_revenue_trends.sql // Monthly GMV, order volume & AOV evolution
03_customer_concentration.sql // Pareto 80/20 distribution, repeat buyer cohorts
├── findings/
00_executive_summary.md // 3 core business takeaways for executive stakeholders
01_business_health.md // Detailed breakdown of margins, cancellations, and seasonality
03_customer_segments.md // Customer lifetime spend & cohort concentration
├── README.md // Professional project front-door with data schema diagram
Outcomes

What You Will Master

Translate vague exec asks ('I want to know if we're growing') into measurable KPIs
Ship a fast, ugly first version on purpose - and resist polishing prematurely
Engage analytically with stakeholder feedback: address most of it, push back on some of it
Defend visual and analytical choices in writing, with rationale
Ship a portfolio that demonstrates dashboard skill *and* the analyst-stakeholder conversation
Curriculum

5 Guided Project Milestones

M1

Set up your project repo

Before any analytical work: create a public GitHub repository, push the standard skeleton, and paste the URL into your workspace.

~30 mins
M2

Requirements interview - translate the ask

Turn a vague exec ask into a concrete, signed-off KPI plan. No analysis yet, no charts - just the plan.

~90 mins
M3

Rough first draft - ship ugly to the exec

Core Milestone

Build the *rough* version. Don't polish. Submit for review and treat the feedback as the exec's reaction.

~90 mins
M4

Iterate - engage with the exec's feedback

Read the M3 review as if it came from the CEO. Revise the dashboard. Defend what you're keeping; change what's worth changing.

~90 mins
M5

Polish + portfolio

Review Pass Required

Final pass for recruiters. README, polished screenshots, optional public URL, executive summary.

~60 mins
Career Value

ATS Keywords & Resume Ready Bullets

Tools
PostgreSQLTableau Desktop / Tableau PublicGit/GitHubMarkdown
Methods
Common Table Expressions (CTEs)Window FunctionsTime-Bucket AggregationsCohort AnalysisData Profiling & Auditing
Business Concepts
AOV (Average Order Value)Customer ConcentrationRepeat Purchase BehaviorCohort RetentionRevenue Health Metrics
Pre-Written Resume Bullet (Copy & Paste)

"Authored an end-to-end data analytics project on Executive Ecommerce Dashboard utilizing PostgreSQL, Tableau Desktop / Tableau Public, Git/GitHub — delivered production-grade queries, cohort distributions, and an executive stakeholder summary published as a portfolio GitHub repository."

Preparation

Reading & References

Pre-flight setup: VS Code + database + Tableau
setup guide · Premium Access
Dashboard design principles (Stephen Few)
article
ecom Schema Data Dictionary
article · Premium Access
What an executive actually wants from a dashboard
article · Premium Access
Ecommerce KPIs every analyst should know
article
Writing readable SQL
article
Why ship rough first drafts
article · Premium Access
How to receive feedback critically
article · Premium Access
Tableau Public publishing guide
article
Anatomy of a great portfolio README
article

Ready to build and ship Executive Ecommerce Dashboard?

Instant access to cloud database credentials, milestones, and starter queries.

Project Overview

Free Executive Ecommerce Dashboard portfolio project — with AI review

Build a real executive ecommerce dashboard project for your data analyst portfolio in your own public GitHub repo — free brief, starter template, and milestone guides. When your code is ready, the ₹99 pass gets every milestone reviewed against a fixed rubric (ecommerce executive dashboard walkthrough included) and issues a verifiable certificate on completion.

Is the Executive Ecommerce Dashboard project free?

The full project brief, milestone guides, and starter template are free to audit. The AI-powered review pass and verified certificate unlock at ₹99.

Can I add the Executive Ecommerce Dashboard project to my resume and GitHub?

Yes — that is the point. You build in your own public GitHub repo, every milestone is reviewed against a fixed rubric, and the certificate links to the repo employers can inspect. Only list what is visible in your repo.

How long does the Executive Ecommerce Dashboard project take?

Most students finish the 5 milestones in 2–4 weekends. Milestones unlock in order, and you can re-submit any milestone that needs work.

Rubric-reviewed · Plagiarism-checked · Verifiable certificate

Build your portfolio & get certified

Want more projects like this? Join our Data Analyst Work Experience Program to complete 5+ guided industry projects, gain real experience, and earn an internship certificate.

Access
₹99