Quarterly Sales Review Dashboard

Added Jul 2026 3 design docs

Every growing Indian consumer brand ends up in the same meeting once a quarter: the founder, the sales head and four zone managers in a room, arguing from four different spreadsheets. Somebody says the south is doing badly, somebody else says the south is fine and it is the marketplace channel that collapsed, and nobody can settle it because there is no single agreed view of the numbers. The quarterly business review is where growth decisions actually get made, and the person who can build the one view everyone trusts quietly becomes the most useful person in the room.

The intern builds that view for Mitti Mug, a fictional Jaipur brand selling terracotta drinkware and cookware through its own website, marketplaces and retail distributors. They derive realistic seasonality from published quarterly results of listed consumer companies, construct a documented 1,200-row four-quarter sales dataset in excel, then build a filterable dashboard of six panels driven entirely by pivot tables and SUMIFS, write a metric dictionary that pins down every definition, and turn the whole thing into a 10-slide quarterly review in powerpoint that ends with three specific decisions the leadership team is asked to take.

Completing the project teaches sales analytics, dashboard design, metric definition discipline, and the harder skill of turning a table of numbers into a recommendation someone can act on. Business analyst, sales operations and category management interviews almost always test exactly this, and a dashboard the intern can open and filter live in front of an interviewer carries far more weight than a line on a resume.

Related projects

Pricing Strategy Analysis

Most small Indian service businesses set their price once, at launch, by copying the shop across the road, and then never revisit it. A self-study hall in Mukherjee Nagar charging one flat monthly rate is a clean example of the damage: the aspirant who arrives at six in the morning and leaves at eleven at night pays exactly what the student who drops in twice a week pays, and nobody can say whether the rate is too high, too low, or accidentally correct. Because a price change costs almost nothing to implement and flows straight to the bottom line, pricing is the highest-leverage decision such a business can reopen. The intern runs a full pricing analysis for Studyloft, a fictional 120-seat study hall near Mukherjee Nagar in Delhi that charges a flat ₹2,500 a month and barely clears its costs. They rebuild the cost structure and break-even occupancy in excel, benchmark 20 competing study halls on publicly listed rates and features, run a van Westendorp price sensitivity survey through google-forms with at least 80 exam aspirants, model a three-tier price architecture with contribution margins and a price-versus-occupancy sensitivity grid, and present the recommendation as a 16-to-20 page analysis in google-docs plus a 12-to-14 slide decision deck in powerpoint. The project builds cost accounting, willingness-to-pay research, price architecture design, sensitivity analysis, and the harder skill of naming a number and defending it under questioning. Pricing work is rare on a fresher's resume and immediately recognisable to interviewers in consulting, category management, and revenue roles, because it demands quantitative discipline and commercial judgement at the same time.

business-developmentexcelgoogle-docsgoogle-forms+1

PRD · HLD · LLD includedView

BusinessEasy

Sales Funnel Design for a Coaching Institute

Every coaching institute in a tier-two Indian city collects far more interest than it converts. Parents call, students walk in after school, a hoarding near the bus stop brings twenty enquiries in a week, and then almost all of it evaporates because nobody follows up in any organised way. The names sit in a diary, the counsellor remembers the ones who seemed serious, and the rest quietly enrol somewhere that called them back. The institute concludes it needs more advertising, when what it actually needs is a funnel: a defined path from first contact to paid admission with a named action at every step. The intern designs that funnel end to end for Sankalp Study Circle, a fictional CUET and CLAT coaching centre in Vaishali Nagar, Jaipur that turned 300 enquiries into 42 admissions last season. They map a seven-stage funnel as a one-page blueprint in canva, build the enquiry capture form in google-forms with qualification fields and automatic routing, write a five-touch follow-up sequence and a 90-second counsellor call script in google-docs, produce six objection-handling cards, and build a funnel tracker in google-sheets that calculates stage-to-stage conversion, cost per admission, and where the biggest leak sits. The project teaches funnel thinking, lead qualification, conversion arithmetic, and persuasive but honest sales copy, which are the daily work of inside sales, admissions, and growth roles across edtech and services. Because the deliverables are operational rather than theoretical, the intern finishes with a system a real institute could switch on in a week, which is a far stronger interview artefact than a marketing essay.

business-developmentcanvagoogle-docsgoogle-forms+1

PRD · HLD · LLD includedView

BusinessEasy

Partnership Proposal Kit

Small Indian service businesses grow fastest when they borrow somebody else's audience. A tiffin service does not need to advertise to every hostel resident in the city if it can sign one deal with the warden of a 90-bed PG. Yet most owners never get there, because a partnership conversation needs paperwork most small firms simply do not have: a clear offer, a written split, and a document the other side can show their boss. The founder ends up pitching over WhatsApp, the partner asks for something in writing, and the deal quietly dies. The intern builds the missing paperwork as a complete partnership kit for Ghar Ka Tiffin, a fictional Nagpur home-style tiffin service with 180 subscribers at ₹2,400 a month that wants to reach 400 without spending on ads. Working in google-sheets they map 24 candidate partners across three archetypes and score each on fit, then design three partnership models and a value-exchange calculator that shows what both sides earn. In canva they produce three model one-pagers and a ten-slide proposal deck with swappable partner slides, and in google-docs they write the fill-in proposal template, a plain-language two-page term sheet, and a four-step outreach sequence for linkedin, email and in-person approaches. The project builds skill in partner prospecting, commercial structuring, value articulation, and business writing that survives being forwarded to someone senior. Alliance and channel roles across startups, edtech and FMCG distribution hire exactly for this, and a kit that a real founder could open and use tomorrow demonstrates commercial judgement in a way no coursework does.

business-developmentcanvagoogle-docsgoogle-sheets+1

PRD · HLD · LLD includedView