For MBA (Supply Chain & Marketing) & B.Com Students

Digital Marketing & Business Data Analytics Internship

A practical, mentor-reviewed internship — digital marketing, Excel-based data analytics, market research and supply chain research, built around a real capstone study of QDCODEX. No coding, no React, no Python.

View Full Curriculum

30

Days, day-by-day

5

Modules

100

Point evaluation

1

Capstone study

Digital MarketingDays 2–10
Data AnalyticsDays 11–20
Market ResearchDays 21–25
Supply ChainDays 26–28
Capstone StudyDays 29–30
Certificate IncludedTheory + Practical DailyOnline & OfflineMentor-Reviewed

Jump to a day

Day 1: Orientation & Company IntroductionDay 2: Digital Marketing FundamentalsDay 3: Website AnalysisDay 4: SEO BasicsDay 5: Keyword ResearchDay 6: Competitor Analysis (Digital)Day 7: Social Media AnalysisDay 8: Content StrategyDay 9: Google Business Profile & Campaign AnalysisDay 10: Digital Marketing ReportingDay 11: Excel FundamentalsDay 12: Data CleaningDay 13: Sorting & FilteringDay 14: Formulas & VLOOKUP / XLOOKUPDay 15: IF, SUMIF, COUNTIFDay 16: Pivot TablesDay 17: ChartsDay 18: KPI AnalysisDay 19: Marketing Performance DashboardDay 20: Business InsightsDay 21: Target Customer IdentificationDay 22: Competitor Research (Market)Day 23: Pricing / Service ComparisonDay 24: Market Trends & Customer SegmentationDay 25: SWOT & Opportunity IdentificationDay 26: Supplier & Vendor ResearchDay 27: Service Delivery Process MappingDay 28: Cost Analysis & Improvement SuggestionsDay 29: Capstone AssemblyDay 30: Final Presentation & Submission
1

Day 1

Orientation & Company Introduction

Understand QDCODEX as a business, and how this internship connects to your MBA in Supply Chain & Marketing.

Theory

What This Internship Covers

  • Five modules: Digital Marketing, Business Data Analytics (Excel), Market Research, Supply Chain & Business Research, and a Capstone Study.
  • No coding, no React, no Python — every skill here is one you'll use directly in a marketing, research or operations role.
  • You will treat QDCODEX itself as the live business you research and analyse throughout.

How a Service Business Works

  • QDCODEX sells web development, SEO, digital marketing and business software — a service, not a physical product.
  • Its 'customers' are other businesses (B2B); its 'supply chain' is the vendor and tool ecosystem it depends on to deliver.

Practical Task

  • Read QDCODEX's About and Services pages; note its core services, target industries, and locations served.
  • Write a one-page company snapshot: what QDCODEX sells, to whom, and how it positions itself.

Key Takeaways

  • Every task in this internship maps to a real deliverable, not a theory exercise.
  • Understanding the business you're analysing always comes before analysing it.
2

Day 2

Digital Marketing Fundamentals

The core channels and the marketing funnel — the vocabulary the rest of the module builds on.

Theory

The Core Digital Channels

  • SEO — getting found on Google for free (organic search).
  • SEM / Google Ads — paid placement on search results.
  • Social Media — Instagram, Facebook, LinkedIn for reach and engagement.
  • Content Marketing and Email Marketing — attracting and nurturing an audience directly.

The Marketing Funnel

  • Awareness: a prospect discovers the brand (SEO, social, ads).
  • Consideration: they compare options (content, reviews, case studies).
  • Conversion: they enquire or buy (landing pages, offers, calls-to-action).

Practical Task

  • Map QDCODEX's current channels onto the three funnel stages — where is it strong, where is it thin?

Key Takeaways

  • Every marketing activity should map to a funnel stage — if it doesn't, question why it exists.
  • Digital marketing is measurable by design; that's its core advantage over traditional marketing.
3

Day 3

Website Analysis

Reading a website the way both a customer and a search engine do.

Theory

What a Customer Notices

  • Load speed — most visitors leave a site that takes more than 3 seconds to load.
  • Mobile experience — the majority of B2B research now starts on a phone.
  • Clarity of the call-to-action — can a visitor tell what to do next within 5 seconds?

What a Search Engine Notices

  • Site structure — clear navigation and internal linking.
  • Page titles and headings that describe the content accurately.

Practical Task

  • Audit qdcodex.in and one competitor site on speed, mobile view, structure, and calls-to-action.
  • Score both sites 1–5 on each criterion and note the biggest gap.

Key Takeaways

  • A website audit is a checklist exercise, not a design opinion — score against fixed criteria.
  • The biggest gaps are usually the same for the customer and the search engine: clarity.
4

Day 4

SEO Basics

On-page, technical and off-page SEO — what each one actually controls.

Theory

The Three Types of SEO

  • On-page: content, titles, meta descriptions and headings on the page itself.
  • Technical: site speed, mobile-friendliness, indexing and structured data.
  • Off-page: backlinks and mentions from other websites, which build authority.

Title Tags & Meta Descriptions

  • The title tag is the blue clickable link in Google results — it should include the main keyword and stay under ~60 characters.
  • The meta description is the summary below it — it doesn't affect ranking directly, but it affects whether people click.

Practical Task

  • Review the title tags, meta descriptions and headings on three QDCODEX pages.
  • Note whether each one clearly states what the page is about, and rewrite one if it doesn't.

Key Takeaways

  • On-page SEO is the fastest lever to pull — no developer needed to fix a title tag.
  • A page can rank well and still get few clicks if its title/description doesn't sell the click.
5

Day 5

Keyword Research

Finding the exact words customers type before they ever see your website.

Theory

Search Intent

  • Informational: "what is SEO" — the searcher is learning, not buying yet.
  • Commercial: "best SEO company Nagercoil" — the searcher is comparing options.
  • Transactional: "SEO company near me contact" — the searcher is ready to act.

Where Keywords Come From

  • Free tools: Google Keyword Planner, Google Autocomplete, "People also ask", Ubersuggest.
  • Competitor pages — the keywords they're already ranking for are a strong starting list.

Practical Task

  • Build a 30+ keyword list around "web development company Nagercoil" and related services.
  • Tag each keyword by intent (informational / commercial / transactional) and note estimated search volume.

Key Takeaways

  • Intent matters more than volume — ten transactional searches can outperform a thousand informational ones.
  • A keyword list is only useful once it's tagged by intent; a flat list is just words.
6

Day 6

Competitor Analysis (Digital)

Comparing how rivals actually show up online, not just what they claim to offer.

Theory

What to Compare

  • Positioning — the one-line promise each competitor leads with.
  • Services shown — what's listed, and in what order (it signals priority).
  • Pricing visibility — is pricing public, quote-only, or hidden entirely?

Practical Task

  • Compare three competitor websites on positioning, services shown, and pricing visibility.
  • Note one thing each competitor does better than QDCODEX, and one thing QDCODEX does better.

Key Takeaways

  • A useful competitor analysis names specific gaps, not general impressions like "their site looks nicer."
  • Pricing visibility itself is a strategic signal — hiding pricing is a deliberate choice, not an oversight.
7

Day 7

Social Media Analysis

Auditing a social presence properly — frequency, engagement and content mix, not follower count alone.

Theory

What Actually Matters

  • Posting frequency and consistency — sporadic posting signals a low-priority channel.
  • Engagement rate (likes + comments ÷ followers) — a more honest signal than raw follower count.
  • Content mix — is it all promotional, or a mix of educational, behind-the-scenes, and social proof?

Practical Task

  • Audit QDCODEX's Instagram and LinkedIn on posting frequency, engagement, and content mix.
  • Identify the single highest-performing post and note why it likely worked.

Key Takeaways

  • Follower count is a vanity metric; engagement rate and content mix tell the real story.
  • The best-performing post is usually the most specific one, not the most polished one.
8

Day 8

Content Strategy

Planning content deliberately around the funnel and a realistic calendar, instead of posting ad hoc.

Theory

Content by Funnel Stage

  • Awareness content: educational posts, tips, industry trends.
  • Consideration content: case studies, comparisons, client results.
  • Conversion content: offers, service pages, direct calls-to-action.

Practical Task

  • Draft a two-week content calendar for one QDCODEX channel, tagging each post by funnel stage.

Key Takeaways

  • A content calendar that's all awareness content, and never asks for the sale, will build reach without building revenue.
9

Day 9

Google Business Profile & Campaign Analysis

The single highest-leverage local SEO asset, plus reading an ads report the way a marketer does.

Theory

Google Business Profile (GBP)

  • It's often the first thing a local searcher sees — before the website itself.
  • Category, photos, business hours, and reviews all directly affect local ranking.

Reading a Campaign Report

  • CTR (click-through rate): impressions that turned into clicks — measures ad relevance.
  • CPC (cost per click): what each click cost — measures efficiency.
  • ROAS (return on ad spend): revenue generated per rupee spent — measures whether it's worth it.

Practical Task

  • Audit QDCODEX's Google Business Profile and list five optimisation fixes.
  • Review a sample Google/Meta Ads report and interpret its CTR, CPC and ROAS.

Key Takeaways

  • A GBP audit is usually the highest-ROI hour in the whole internship — it's fast to fix and directly affects local visibility.
  • A high CTR with a low ROAS means the ad is compelling but the offer or landing page isn't converting.
10

Day 10

Digital Marketing Reporting

Turning a week of scattered findings into a one-page report a manager will actually read.

Theory

What Makes a Report Useful

  • Lead with the finding, not the process — "CTR is down 12%" before "here's how I calculated it."
  • One page, one chart, three recommendations — anything longer gets skimmed, not read.

Practical Task

  • Build a one-page DM report template and populate it with this week's findings.

Key Takeaways

  • Module B complete — you've now audited a website, researched keywords, benchmarked competitors, and reported findings.
11

Day 11

Excel Fundamentals

The interface, data types and formatting habits that keep formulas from breaking later.

Theory

Data Types Matter

  • Numbers stored as text won't sum correctly — a common, invisible source of wrong totals.
  • Dates must be recognised as dates (right-aligned) for filtering and calculations to work.

Formatting Habits

  • One header row, no merged cells in the data body — merged cells break sorting, filtering and pivot tables.
  • Keep raw data on one sheet and build analysis on separate sheets, never edit raw data directly.

Practical Task

  • Format and structure a sample QDCODEX enquiry dataset: one clean header row, consistent data types, no merged cells.

Key Takeaways

  • Most Excel errors trace back to Day 1 formatting mistakes, not formula mistakes.
12

Day 12

Data Cleaning

Removing duplicates, fixing blanks, and standardising entries before any analysis begins.

Theory

The Cleaning Checklist

  • Remove exact duplicate rows (Data → Remove Duplicates).
  • Standardise text entries — "Web Dev", "web development" and "Website Dev" should become one consistent value.
  • Handle blanks deliberately: fill, flag, or exclude — never leave them ambiguous.

Practical Task

  • Clean the enquiry dataset: remove duplicate enquiries, and standardise phone number and email formats.

Key Takeaways

  • "Garbage in, garbage out" — no formula or dashboard can fix an uncleaned dataset.
13

Day 13

Sorting & Filtering

Slicing a dataset to answer a specific question, without losing or altering the source.

Theory

Sort vs. Filter

  • Sort reorders every row permanently — always sort a copy, never the raw dataset.
  • Filter temporarily hides rows that don't match a condition, without changing their order.

Practical Task

  • Sort the dataset by enquiry date, then filter it down to a single service type.

Key Takeaways

  • Filtering answers 'show me just this'; sorting answers 'what order should this be in' — they solve different problems.
14

Day 14

Formulas & VLOOKUP / XLOOKUP

Relative vs. absolute references, and matching data across two separate sheets.

Theory

Relative vs. Absolute References

  • A relative reference (A2) shifts when copied to a new cell; an absolute reference ($A$2) stays fixed.
  • Use $ to lock a reference when copying a formula across many rows that should all point to the same cell.

VLOOKUP vs. XLOOKUP

  • VLOOKUP searches a column and returns a value from a column to its right — it can't look left.
  • XLOOKUP is more flexible: it can search in either direction and handles missing matches more gracefully.

Sample formulas

=VLOOKUP(A2, Sheet2!A:B, 2, FALSE)
=XLOOKUP(A2, Sheet2!A:A, Sheet2!B:B)

Practical Task

  • Match each enquiry's source to its campaign name using VLOOKUP across two sheets.

Key Takeaways

  • The fourth VLOOKUP argument (FALSE) matters — leaving it out silently allows approximate matches.
15

Day 15

IF, SUMIF, COUNTIF

Conditional logic and conditional totals — the formulas behind almost every business report.

Theory

Conditional Formulas

  • IF tests a condition and returns one value if true, another if false.
  • SUMIF and COUNTIF total or count rows that match a condition, without a manual filter first.

Sample formulas

=IF(D2>10000,"High Value","Standard")
=SUMIF(C:C,"SEO",D:D)
=COUNTIF(E:E,"Website")

Practical Task

  • Flag high-value leads with IF; total enquiries per service with SUMIF and COUNTIF.

Key Takeaways

  • Interim checkpoint — you have now cleaned, matched and summarised a real dataset without touching a single pivot table yet.
16

Day 16

Pivot Tables

Summarising thousands of rows into a decision in a few clicks.

Theory

How a Pivot Table Thinks

  • Rows and columns group the data; Values summarise it (sum, count, average).
  • A pivot table never changes the source data — it's always safe to rebuild.

Practical Task

  • Build three pivot tables from the enquiry dataset: by service, by month, and by source.

Key Takeaways

  • A pivot table answers 'how much, by what group' faster than any formula chain.
17

Day 17

Charts

Bar, line, pie and combo charts — and choosing the right one for the question being asked.

Theory

Choosing the Right Chart

  • Bar chart: comparing categories (enquiries by service).
  • Line chart: showing a trend over time (enquiries by month).
  • Pie chart: showing share of a whole — and only when there are 5 or fewer slices.

Practical Task

  • Chart enquiry volume by month (line) and by channel (bar).

Key Takeaways

  • A wrong chart type can make correct data look misleading — the chart is part of the analysis, not decoration after it.
18

Day 18

KPI Analysis

Defining and calculating the handful of metrics that actually indicate performance.

Theory

Core Marketing KPIs

  • CTR (click-through rate), Conversion Rate, Cost per Enquiry, Engagement Rate, Response Time.
  • A KPI is only useful with a target and a trend — a single number in isolation tells you little.

Practical Task

  • Define and calculate five KPIs from the dataset: CTR, conversion rate, cost per enquiry, engagement rate, response time.

Key Takeaways

  • Pick KPIs the business can actually act on — a metric nobody will change a decision based on isn't worth tracking.
19

Day 19

Marketing Performance Dashboard

Assembling pivots, charts and KPIs into a single sheet someone can read in thirty seconds.

Theory

Dashboard Design Basics

  • Most important number top-left — that's where the eye lands first.
  • One sheet, no scrolling — a dashboard that needs scrolling has failed its own purpose.

Practical Task

  • Assemble a one-sheet dashboard from the pivot tables, charts and KPIs already built.

Key Takeaways

  • A good dashboard needs no verbal explanation — if you have to explain it, redesign it, don't caption it.
20

Day 20

Business Insights

Writing the 'so what' behind the numbers — the step most Excel exercises skip.

Theory

From Data to Insight

  • A fact: "Enquiries from Instagram grew 18% this month."
  • An insight: "Instagram is outgrowing other channels — worth reallocating ad budget toward it."

Practical Task

  • Write five insights the finished dashboard reveals, each paired with a recommended action.

Key Takeaways

  • Module C complete — you can now clean, structure, summarise and interpret real business data end to end.
21

Day 21

Target Customer Identification

Defining exactly who QDCODEX serves, in specific enough terms to act on.

Theory

What an ICP Actually Needs

  • Industry, business size, location, and the specific problem they're trying to solve.
  • "Small businesses" is not an ICP; "a 5–20 employee hospitality business in Kanyakumari with no online booking" is.

Practical Task

  • Define three ideal customer profiles — e.g. a Kanyakumari hospitality business, a Tier-2 manufacturer, an education institute.

Key Takeaways

  • A vague ICP produces vague marketing; specificity is what makes a customer profile useful.
22

Day 22

Competitor Research (Market)

Mapping who else is competing for the same customer — beyond just the digital footprint from Day 6.

Theory

Direct vs. Indirect Competitors

  • Direct: other web/digital agencies targeting the same region and customer size.
  • Indirect: freelancers, DIY website builders, and in-house teams — all competing for the same budget.

Practical Task

  • Identify and profile five competitors, covering both direct and indirect competition.

Key Takeaways

  • Ignoring indirect competitors (like DIY tools) is a common market-research blind spot.
23

Day 23

Pricing / Service Comparison

Comparing offers like-for-like, not by marketing copy.

Theory

Building a Fair Comparison

  • Compare the same service tier across competitors, not a basic package against a premium one.
  • Note what's included, not just the headline price — hidden add-ons change the real comparison.

Practical Task

  • Build a comparison matrix of services and starting prices across the competitors identified.

Key Takeaways

  • A pricing comparison is only honest if it compares equivalent scope — otherwise it's comparing apples to invoices.
24

Day 24

Market Trends & Customer Segmentation

What's changing in the market QDCODEX sells into, and grouping its customers by real differences.

Theory

Trends Worth Tracking

  • Digital adoption among Tier-2/3 India SMEs — still rising, but unevenly across industries.
  • Growing preference for mobile-first, WhatsApp-integrated business websites.

Segmentation Basics

  • Segment by industry (tourism, textile, healthcare, education, retail) and by need (visibility vs. bookings vs. leads).

Practical Task

  • Research digital-adoption trends among Tier-2/3 India SMEs, then segment QDCODEX's target market by industry and need.

Key Takeaways

  • A trend only matters to the business if it changes what a specific customer segment needs.
25

Day 25

SWOT & Opportunity Identification

Assessing QDCODEX's position honestly, and turning that assessment into recommendations.

Theory

A Useful SWOT

  • Strengths and Weaknesses are internal; Opportunities and Threats are external — don't mix them up.
  • Each point should be specific and evidenced from this internship's own research, not generic.

Practical Task

  • Complete a SWOT with at least three points per quadrant, then identify and justify three untapped opportunities.

Key Takeaways

  • Module D complete — a SWOT built from real research is a recommendation engine, not a classroom exercise.
26

Day 26

Supplier & Vendor Research

QDCODEX's own vendor ecosystem — the 'supply chain' behind a service business.

Theory

A Service Business's Supply Chain

  • Hosting providers, domain registrars, ad platforms, and software tools are QDCODEX's suppliers.
  • Comparing vendors uses the same criteria as comparing physical suppliers: cost, reliability, support, switching cost.

Practical Task

  • Research and list QDCODEX's likely core suppliers and tool vendors, then compare three hosting providers or SEO tools on cost and features.

Key Takeaways

  • "Supply chain" for a service business is a vendor and tool dependency map, not a warehouse — but the analysis method is identical.
27

Day 27

Service Delivery Process Mapping

A service business still has a delivery chain — mapping it surfaces exactly where it slows down.

Theory

Mapping a Delivery Flow

  • Enquiry → scoping → execution → delivery → support — each stage has an owner and a typical duration.
  • Bottlenecks usually sit at handoffs between stages, not inside a single stage.

Practical Task

  • Map QDCODEX's service delivery flow end to end, and identify three likely bottlenecks — turnaround time, third-party API limits, review cycles.

Key Takeaways

  • Process mapping turns "projects take too long" from a complaint into a specific, fixable stage.
28

Day 28

Cost Analysis & Improvement Suggestions

Understanding cost-to-serve, then recommending concrete process improvements.

Theory

Cost-to-Serve Thinking

  • Add up the real inputs to a typical project: hours, tools, hosting, ad spend if any — not just the quoted price.
  • A good improvement suggestion names the expected impact, not just the change itself.

Practical Task

  • Estimate a rough cost-to-serve for a typical website project, then recommend three process improvements with expected impact.

Key Takeaways

  • Module E complete — supply-chain thinking applies to a service business exactly as it does to a physical one.
29

Day 29

Capstone Assembly

Combining every module's findings into one integrated study of QDCODEX.

Theory

Assembling the Capstone

  • Pull together: online presence research, competitor analysis, keyword research, social audit, ICPs, competitor comparison, Excel analysis, KPIs, and the dashboard.
  • The capstone isn't new research — it's the synthesis of everything already built into one coherent story with a recommendation at the end.

Practical Task

  • Compile all prior research and analysis into a draft capstone report, dashboard, and presentation deck.

Key Takeaways

  • A capstone succeeds or fails on synthesis, not new material — the story matters as much as the data.
30

Day 30

Final Presentation & Submission

Presenting the capstone study and submitting the complete deliverable set.

Theory

Presenting to a Business Audience

  • Lead with the recommendation, then show the evidence — not the reverse.
  • Anticipate the obvious question ("how confident are you in this number?") and have the answer ready.

Practical Task

  • Present the capstone study — "QDCODEX Digital Marketing & Business Analytics Study" — to a mentor or panel, and submit every deliverable from Section G.

Key Takeaways

  • Internship complete — market research, competitor analysis, keyword research, social audit, an Excel dashboard, and 5+ prioritised business recommendations, all in your portfolio.

What You Will Get

Everything included in the internship

Internship Certificate

Certificate on completion, for your MBA record.

Capstone Study

A real QDCODEX marketing & analytics study for your portfolio.

Excel, Not Code

Pivot tables, dashboards & lookups — skills you'll use in any role.

Market & Supply Chain

Research and vendor-comparison skills tied to your MBA specialisation.

Ready to Start Your Internship?

Join the Digital Marketing & Business Data Analytics internship — 15 or 30 days, online or offline — with a certificate on completion. Built for MBA and B.Com students.

See All Internship Programs

Follow Us

@qdcodex on Instagram

Web, SEO, IoT & campus projects — see what we're building, day to day.

Follow @qdcodex