Introduction to Module 3

BI tools overview — Tableau, Power BI, Looker — and hands-on dashboard building.

What this module is about

Module 3 covers Business Intelligence (BI) — the layer of analytics that people actually see. Databases store the data; BI tools turn it into dashboards, reports, and charts that a manager can read in ten seconds. For many people, a BI dashboard is the only part of the data stack they ever touch.

This module explains what BI is, how the BI market is organized, the two main types of BI tools, how a BI platform works inside (including concepts like MOLAP and ROLAP), the rules of good data visualization, and hands-on work with Tableau Desktop. Together with SQL from Module 2, this is the core skill set of a data analyst and a BI developer.

Why BI matters for your career

BI skills are one of the fastest paths into a data career. Job boards are full of postings that ask for SQL plus one BI tool — Tableau, Power BI, or Looker. Entry-level BI developer and data analyst roles often require exactly what this module and Module 2 teach, and nothing more.

There is another reason BI matters: visibility. A data engineer’s pipeline is invisible when it works. A dashboard is seen by executives every Monday morning. Analysts who build clear, trusted dashboards get noticed, and noticed people get promoted. Your BI work is also the easiest thing to show in a portfolio — a published Tableau Public dashboard is proof of skill that a resume line is not.

What you will learn

What BI is and how the market looks

BI is the practice of turning raw data into information for decisions. You will learn the main vendors and where they stand: Tableau (owned by Salesforce), Microsoft Power BI, Looker (Google Cloud), and newer players. Knowing the market helps you pick which tool to learn first based on the jobs in your region.

Two types of BI tools

BI tools split into two families. Self-service tools like Tableau and Power BI let an analyst connect to data and build a dashboard alone. Enterprise or semantic-layer platforms like Looker define metrics centrally in a model so every dashboard uses the same definitions. Real companies often run both. Understanding the split helps you answer a classic interview question: how do you make sure two dashboards show the same revenue number?

How BI works inside: MOLAP vs ROLAP

Some BI systems pre-compute results into cubes (MOLAP), others push queries down to the database live (ROLAP). This sounds academic, but it explains everyday practical questions: why is this dashboard slow, why is that extract stale, when should you use a Tableau extract vs a live connection.

The anatomy of a BI platform

Data connections, the semantic model, workbooks, dashboards, permissions, and scheduled refreshes. Once you see the anatomy, every BI tool looks familiar.

Data visualization

Chart choice is a skill. Bar charts for comparison, line charts for time, tables for exact values — and why pie charts with ten slices fail. You will learn simple rules that make dashboards readable: fewer colors, clear titles, the most important number top-left.

Tableau Desktop hands-on

You will build real visualizations in Tableau: connecting to data, dimensions vs measures, filters, calculated fields, and assembling a dashboard. The concepts transfer almost one-to-one to Power BI.

Common beginner mistakes

Making dashboards pretty instead of clear. Decoration hides the message. Every chart should answer one question.
Putting twenty charts on one dashboard. Nobody reads it. Five focused charts beat twenty vague ones.
Learning the tool but not visualization principles. Tools change; the principles of showing data honestly and clearly do not.
Ignoring performance. A dashboard that takes two minutes to load will not be used, no matter how correct it is.
Skipping the “so what”. A chart shows sales dropped. A good analyst adds where, when, and what to check next.

Which BI tool should you learn first?

A practical rule: check job postings in your city or target market and count which tool appears most. In most regions the answer is Power BI or Tableau. Power BI is cheaper and everywhere in companies that run on Microsoft. Tableau is strong in tech and larger analytics teams, and Tableau Public gives you free portfolio hosting. Looker appears mostly at companies on Google Cloud. Do not agonize over the choice — the skills transfer. A person who knows Tableau well can become productive in Power BI in a couple of weeks, because the hard parts (data modeling, chart choice, calculations) are the same.

How to work through this module

Install Tableau Public (free) so you can follow the hands-on lessons.
Rebuild every visualization shown in the lessons yourself.
Pick a public dataset you personally find interesting and build one dashboard that answers three questions about it.
Publish it to Tableau Public and put the link on your resume and LinkedIn.

Next steps

See all lessons in Module 3: Business Intelligence.
Build a portfolio dashboard with a pet project — the BI project is the most common first portfolio piece.
Read how a BI portfolio helps in Getting your first data job.