Tableau vs MongoDB — Which Should Beginners Learn First?

Tableau — your first dashboard (step by step)

1. CONNECT DATA
   Connect → Text file → sales.csv
   Tableau detects column types.

2. IDENTIFY DIMENSIONS AND MEASURES
   Dimensions (blue):  region, category, month
   Measures (green):   revenue, units, margin

3. BUILD THE FIRST CHART
   Drag "month" to Columns.
   Drag "revenue" to Rows.
   Tableau creates a line chart.

4. ADD A SECOND DIMENSION
   Drag "region" onto Color.
   Now you have one line per region.

5. FILTER
   Drag "category" to Filters.
   Choose "Electronics".

6. ADD A KPI
   Drag "revenue" to Text in the Marks card.
   You get a big total number.

7. ASSEMBLE A DASHBOARD
   Click "New Dashboard".
   Drag both sheets onto the canvas.
   Add a title.

8. PUBLISH
   Server → Tableau Public → Save.
   Copy the public link.

Rules:
- Every chart answers a question
- No chart without an axis label
- Colors are for meaning, not decoration
- Maximum 5 charts per dashboard
- If you can't explain it in 30 seconds, simplify

# Calculated fields you'll use constantly

# Margin %
SUM([Revenue]) - SUM([Cost])
------------------------------
       SUM([Revenue])

# Year over year growth
(SUM([Revenue]) - LOOKUP(SUM([Revenue]), -1))
---------------------------------------------
        LOOKUP(SUM([Revenue]), -1)

# Running total
RUNNING_SUM(SUM([Revenue]))

# Rank by revenue (top 10 in a filter)
RANK(SUM([Revenue]))

# Conditional bucket
IF SUM([Revenue]) > 100000 THEN "High"
ELSEIF SUM([Revenue]) > 20000 THEN "Medium"
ELSE "Low"
END

# Days since last order
DATEDIFF('day', MAX([Order Date]), TODAY())

# Null handling
IFNULL([Region], "Unknown")

# Recommended order:
1. Write it in plain English first
2. Convert to Tableau syntax
3. Test with a filter you know the answer to
4. Then add it to a chart

// mongosh — basic CRUD and aggregation

// 1. Insert
db.orders.insertMany([
  { customer: "Asha",  city: "Noida", total: 2400, items: 3 },
  { customer: "Rahul", city: "Delhi", total: 1800, items: 2 },
  { customer: "Asha",  city: "Noida", total: 900,  items: 1 }
])

// 2. Find with filter + projection
db.orders.find(
  { city: "Noida" },
  { _id: 0, customer: 1, total: 1 }
).sort({ total: -1 })

// 3. Index for speed
db.orders.createIndex({ city: 1, total: -1 })

// 4. Explain the query (is it using the index?)
db.orders.find({ city: "Noida" }).explain("executionStats")

// 5. Aggregation — revenue per customer
db.orders.aggregate([
  { $group: {
      _id: "$customer",
      orders: { $sum: 1 },
      revenue: { $sum: "$total" }
  }},
  { $sort: { revenue: -1 } }
])

// 6. $lookup — join with another collection
db.orders.aggregate([
  { $lookup: {
      from: "customers",
      localField: "customer",
      foreignField: "name",
      as: "customerInfo"
  }},
  { $unwind: "$customerInfo" },
  { $project: { _id: 0, customer: 1,
                city: "$customerInfo.city",
                total: 1 } }
])

// app.js — MongoDB from Node.js
const { MongoClient } = require("mongodb");

async function main() {
  const client = new MongoClient("mongodb://localhost:27017");
  await client.connect();
  const db = client.db("shop");
  const orders = db.collection("orders");

  // Insert
  const insertResult = await orders.insertOne({
    customer: "Asha",
    city: "Noida",
    total: 2400,
    items: 3,
    createdAt: new Date(),
  });
  console.log("inserted:", insertResult.insertedId);

  // Find with filter
  const noida = await orders
    .find({ city: "Noida" })
    .sort({ total: -1 })
    .limit(10)
    .toArray();

  // Aggregate — revenue per customer
  const perCustomer = await orders
    .aggregate([
      {
        $group: {
          _id: "$customer",
          orders: { $sum: 1 },
          revenue: { $sum: "$total" },
        },
      },
      { $sort: { revenue: -1 } },
    ])
    .toArray();

  console.log(perCustomer);
  await client.close();
}

main().catch(console.error);

// Note: for production, use a connection pool,
// a shared client, and schema validation.

Tableau vs MongoDB — one glance:

                        TABLEAU           MONGODB
Type                     BI tool           NoSQL database
Language needed          None (GUI)        Node/Python/Java
First working thing      1 day             Half a day
Hard part                Storytelling      Schema design
Fresher jobs             Many              Fewer, need stack
Solo job-ready?          Close (with SQL)  No
Best next step           SQL + Power BI    SQL + a framework
Industry use             Dashboards, BI    Backends, apps, logs

Pick Tableau if:  you want analytics / BI as a career.
Pick MongoDB if:  you're heading towards backend or full-stack.

Nobody hires a fresher for "MongoDB" alone.
They hire for "backend developer who knows a language,
a framework and MongoDB".
Nobody hires for "Tableau" alone either.
They hire for "analyst who can use Tableau and write SQL".

Choose TABLEAU first if you can tick 3+:

☐ You like business questions and visual answers
☐ You've used Excel or Power BI
☐ You want an analyst job within 3-4 months
☐ You enjoy presenting insights
☐ Analytics / BI is the target role

Choose MONGODB first if you can tick 3+:

☐ You already know one programming language
☐ You want to build apps and APIs
☐ You're comfortable with JSON
☐ You're aiming at backend or full-stack
☐ You like the idea of owning data models

Tick both lists? Learn Tableau first (faster to job),
then MongoDB if you want to build tools, not just
report on them.

Wrong choice on either side:
✗ MongoDB before a programming language —
  guaranteed frustration
✗ Tableau without SQL — you'll be blocked in
  every interview

Decision scorecard (rate yourself 1-5):

Factor                         Tableau   MongoDB
I like building dashboards        [ ]        [ ]
I like writing code               [ ]        [ ]
I know SQL                        [ ]        [ ]
I know a programming language     [ ]        [ ]
I want fastest first job          [ ]        [ ]
I want to build apps              [ ]        [ ]
I'm ok with visual design         [ ]        [ ]
I'm ok with schema decisions      [ ]        [ ]

Total:                            ___        ___

Higher total = your first pick.
Close? Start with Tableau for speed,
then MongoDB for depth.

6-week plan (works for either):

Week 1  — Install + hello world + first working thing
Week 2  — Core concepts
Week 3  — Structure (dashboards OR collections)
Week 4  — Real mini-project
Week 5  — Add a supporting tool (SQL / a framework)
Week 6  — Publish, document, present

Daily rules:
☐ 1 hour reading / docs
☐ 2 hours hands-on
☐ 1 commit to GitHub
☐ 1 note on what confused you

End of week 6 you must have:
☐ A published project (Tableau Public / a working API)
☐ A README with screenshots
☐ One thing you can explain in an interview

If you don't have those three, you're not done —
you're 6 weeks into a 10-week plan.

Goal → First tool:

Target role                       Learn first
-------------------------------   ------------------
BI analyst / MIS                  Tableau
Data analyst                      Tableau (with SQL)
Product analyst                   Tableau (with SQL)
Backend developer                 MongoDB (with a language)
Full-stack developer              MongoDB (with a framework)
Data engineer                     SQL first, then either
Analyst who wants to build tools  Tableau, then MongoDB

Never learn in isolation:
Tableau alone ≈ job with SQL. Without SQL, no.
MongoDB alone ≠ job. Add a language + a framework +
basic SQL.

The honest math:
Tableau → analyst job in 3-4 months.
MongoDB → backend job in 6-9 months (with a language).

Both lead to solid careers. They're just different
timelines and different skills.