Home Course home Curriculum Learner dashboard Skill tree Business projects Datasets Final project
🧭 Module 0 · Data Analytics & Power BI Orientation Beginner LESSON 01 / 72

What Is Data Analytics & Business Intelligence?

22 min 5 quiz questions 1 practical challenge 4 syllabus topics

Most people start a Power BI course by opening Power BI. That is a mistake. The tool is easy; knowing what question you are answering is the hard part, and it is the part that separates an analyst from someone who makes charts. This lesson gives you the mental model everything else in the course hangs from.

Lesson 1 of 72 · Data Analytics & Power BI Orientation 1%
01

Learning Objective

Before touching any software, you need to be able to place a business question into the right analytical category — because the category determines the technique, the data you need, and how confidently you are allowed to speak about the answer.

By the end of this lesson you will be able to
  • Define data analytics and business intelligence, and explain precisely how they differ
  • Classify any business question as descriptive, diagnostic, predictive or prescriptive
  • Explain what each analytic type can and cannot legitimately tell you
  • Identify where Power BI operates on that spectrum — and where it does not
  • Describe the analyst's role in the chain from raw data to a changed decision
02

Why This Matters

Consider two analysts handed the same file of sales data.

The first builds twelve charts, arranges them on a page, and sends it out. It is colourful. Nobody acts on it, because nobody asked a question it answers.

The second asks: “Why did margin fall last quarter when revenue rose?” She builds four visuals, finds that a discount campaign on Electronics drove volume at near-zero margin, and recommends capping the discount at 15%. Someone changes what they do. That is analytics.

The uncomfortable truth about dashboards
Industry surveys consistently find that a large share of BI dashboards are opened once and then abandoned. The cause is almost never the tool. It is that the dashboard answered no question anybody actually had. Getting the question right is the highest-leverage thing you will do on any project.

This matters commercially too. Job descriptions say “Power BI Developer”, but interviews test analytical thinking: given this business problem, what would you measure and why? You can learn every DAX function and still fail that question. Module 14 comes back to this directly.

03

Concept

Data analytics: turning observations into answers

Data analytics is the discipline of examining data in order to answer a question or support a decision. That definition has three load-bearing parts: there is a question, there is data, and there is a decision that could go differently depending on the answer. Remove any one and you are not doing analytics.

The four types of analytics

Every analytical question falls into one of four types. They form a ladder: each rung is more valuable and more difficult than the one below, and you cannot skip rungs — you cannot credibly predict what you cannot yet describe.

Business intelligence: analytics as an operating system

Business intelligence is the practice and infrastructure that makes analytics repeatable and shared. A one-off analysis in a spreadsheet is analytics. A governed semantic model that 400 people query through a refreshed report, where “revenue” means the same thing to everyone, is business intelligence.

The distinction is not academic — it changes what you build:

AspectOne-off analysisBusiness intelligence
LifespanAnswers one question, then it is doneRuns continuously for years
AudienceUsually you, or one stakeholderMany people, often across departments
DataA file someone sent youA governed, refreshing source of record
DefinitionsWhatever you decided that dayAgreed, documented, enforced in the model
Failure modeWrong answer, onceWrong answer, silently, to everyone, for months
ToolingExcel, Python notebookPower BI, a semantic model, a refresh schedule
Why the failure mode matters
A broken one-off analysis embarrasses you in a meeting. A broken BI model quietly feeds wrong numbers into hundreds of decisions until someone notices. This is why so much of this course is about modelling discipline and validation rather than about making charts — the stakes are genuinely different.

Where Power BI sits

Power BI is a business intelligence platform that is strongest at the descriptive and diagnostic rungs, has real but limited predictive features, and leaves prescriptive work to you. Being honest about that boundary is part of being good at this job.

Analytics, BI and data science

These three overlap and the labels are used loosely in job adverts. A workable distinction:

  • Business intelligence — building the shared, governed reporting layer. Power BI, SQL, data modelling. Answers: what happened, and why.
  • Data analysis — investigating specific questions, often ad hoc, often deeper than a dashboard goes. Overlaps heavily with BI; the same person frequently does both.
  • Data science — statistical modelling and machine learning to predict and classify. Python/R, experimentation, model deployment. Answers: what will happen, and what drives it, with quantified uncertainty.
Job titles do not respect these boundaries. A “Data Analyst” role may be 90% Power BI, or may be 90% SQL and Python. Read the responsibilities, not the title. Module 14 covers how to read a job description properly.
04

Visual Explanation

The four analytic types applied to a single real number. Below is monthly revenue from the course dataset — the same figure you will build in Power BI in Module 6. Watch how the question you ask of it changes completely at each rung of the ladder.

The same chart, read four different ways
RungThe questionWhat this chart saysHonest limit
DescriptiveWhat happened to revenue?Revenue grew from about $98K in Jan 2024 to about $473K in Dec 2025, with a November peak in both years.Tells you nothing about why.
DiagnosticWhy is November always the peak?Needs decomposition: is it more orders, larger orders, or a specific category? The chart alone cannot say.Finds associations; proving cause needs an experiment.
PredictiveWhat will next November look like?Two seasonal cycles is a thin basis. You could extrapolate, with wide uncertainty.Two years of history is not enough for a confident seasonal forecast — say so.
PrescriptiveShould we increase November stock?Requires the diagnostic answer plus holding cost, stockout cost and lead time — data not in this chart at all.This is a judgement call, not an output.
The discipline this builds
When someone shows you a chart, ask which rung it is on. Most disagreements in analytics meetings happen because one person is making a descriptive statement and another is hearing a prescriptive one. Naming the rung out loud defuses that instantly.

Where the value is — and where the effort goes

That split is an illustration of a well-known pattern, not a measured industry statistic — treat it as a rough expectation, not a citation. The pattern itself is real and consistent: data preparation dominates, and the chart-making that beginners imagine is the job turns out to be the smallest slice.
05

Power BI Demonstration

There is nothing to click in Power BI yet — but there is something important to see: where each rung of the ladder actually lives in the product. Keep this map in mind as you go through the course.

Which Power BI feature serves which analytic type
Analytic typePower BI features that serve itCovered in
DescriptiveMeasures (SUM, COUNT), cards and KPIs, bar/line/matrix visuals, slicersModules 5, 6, 7
DiagnosticDrill-down and drill-through, cross-filtering, Decomposition Tree, Key Influencers, period-over-period measuresModules 6, 7, 9, 13
PredictiveLine-chart forecasting, Key Influencers, Q&A; external models via Python/R visualsModules 7, 13
PrescriptiveNone — this is analyst judgement, communicated through report narrative and designModules 8, 14
A note on honesty
Notice that the prescriptive row says “none”. Any tool that claims to automate the recommendation is either solving a narrow, well-defined optimisation problem, or overselling. Being the person who knows the difference is worth a great deal.
06

Example Dataset

This lesson is conceptual and needs no download — it uses the sample data shown inline above. The next lesson that requires a file will link it here.

You can still browse every dataset in the course from the dataset library.

07

Step-by-Step Exercise

This exercise takes about ten minutes and needs no software — a notepad is enough. It is the single most transferable skill in the course, so do it properly rather than skimming.

Pick a real context you know
Your workplace, a business you use often, a club, a side project — anything where decisions get made. Concrete beats hypothetical.
Write four questions, one per rung
One descriptive, one diagnostic, one predictive, one prescriptive. Force yourself to write all four, even if some feel awkward — the awkwardness is the learning.
For each, name the data you would need
Be specific: not “sales data” but “order lines with date, product, quantity, price and discount”. This is how you learn to spot when a question is unanswerable with what you have.
Mark which ones Power BI could actually answer
Refer to the table in section 05. Be strict with yourself on the predictive one.
Identify the decision behind each question
If you cannot name a decision that would change based on the answer, the question is not worth building. Cross it out. This step eliminates more dashboard ideas than any other.
Worked example — a coffee shop
Descriptive: What were sales by hour of day last month? (Needs: transaction timestamps and amounts. Power BI: yes.)
Diagnostic: Why is Tuesday afternoon consistently our weakest slot? (Needs: the above plus staffing, weather, local events. Power BI: partly — it can show the pattern; explaining it needs external data.)
Predictive: How many pastries will we sell next Saturday? (Needs: 1–2 years of daily sales with seasonality. Power BI: a rough forecast line, yes; a reliable number, no.)
Prescriptive: Should we cut Tuesday afternoon staffing by one person? (Needs: all of the above plus labour cost and service-level tolerance. Power BI: it informs the call; it does not make it.)
08

Expected Result

You should now have four written questions where each one names a rung, names the data it needs, and names a decision it would influence. If any question fails the decision test, that is a successful outcome too — you have just saved yourself from building something nobody would use.

Check your work against these criteria
✓ Each question names a specific metric, not a vague topic
✓ The descriptive question could be answered by a single well-built visual
✓ The diagnostic question names something you would decompose by (category, region, time, customer type)
✓ You were honest that the predictive question needs more history than you probably have
✓ Every surviving question has a named decision-maker and a named decision

Keep this sheet. In Module 14 you will turn a set of questions exactly like these into a portfolio project brief, and having done the thinking now will make that far easier.

09

Common Mistakes

Starting with the data instead of the question
You receive a file, open it, and start making charts to “see what's in there”. Exploration is a legitimate first step, but it is not analysis, and a dashboard built this way is almost always a collection of visuals nobody asked for.

Fix: Explore freely for twenty minutes, then stop and write down the two or three questions worth answering. Build only those. Everything else goes in a notes file.
Presenting a diagnostic finding as a proven cause
“Margin fell because of the Electronics discount.” The data shows the discount coincided with the margin fall and is large enough to account for it. That is strong association, not proof — something else may have driven both.

Fix: Use language that matches your evidence: “the Electronics discount accounts for roughly 80% of the margin decline” is defensible. “Caused” usually is not, unless you ran an experiment.
Overclaiming what a forecast means
Power BI will happily draw a forecast line from very little history, with a confidence band that looks authoritative. Two seasonal cycles cannot support a confident seasonal forecast, however smooth the line looks.

Fix: State the basis and the uncertainty whenever you show a forecast: “based on 24 months, so treat the seasonal component as indicative.” Never present a forecast without its band.
Confusing “more data” with “better analysis”
Adding fifteen more columns and three more years rarely fixes an analysis that was aimed at the wrong question. It usually just makes it slower.

Fix: Ask what would change in your conclusion if you had the extra data. If the answer is “nothing”, you do not need it.
Building for an audience you have not spoken to
Assuming what a finance director wants to see is how you end up with an abandoned dashboard. Their actual question is often narrower and more specific than you imagine.

Fix: Ask one question before you build: “what decision will you make differently depending on what this shows?” The answer reshapes the whole project.
10

Professional Tip

The one-sentence brief
Before any project, force yourself to complete this sentence:

“This report helps [specific person or role] decide [specific decision] by showing [specific metric] broken down by [specific dimension].”

If you cannot complete it, you are not ready to build — and the honest, valuable move is to go back and ask. Experienced analysts do this instinctively. Writing it down until it becomes instinct is the fastest way to get there.

Two further habits worth adopting early:

  • Name the rung out loud in meetings. “That's a diagnostic question — I can show you what correlates, but I can't prove causation from this data.” It sets expectations correctly and it reads as competence, not as hedging.
  • Write the conclusion first. Draft the sentence you expect the report to support before you build it. Then build honestly and see whether the data agrees. If it doesn't, that disagreement is your most interesting finding.
11

Knowledge Check

Knowledge Check

5 questions. Answer each one to see why the right answer is right.

You have order-line data with product, price, discount and cost for the last three years.

A retail director asks: “Our margin dropped 3 points last quarter — what happened?” Which type of analytics does this question call for?

What is the clearest single difference between a one-off analysis and business intelligence?

Power BI draws a forecast line on your 24-month revenue chart, complete with a confidence band. What is the responsible way to present it?

Which of these project briefs is ready to build?

Purely observational data — you did not change any store's hours to test this.

You find that stores with longer opening hours have higher revenue. What can you legitimately claim?

12

Practical Challenge

Practical Challenge

Write a defensible one-page analysis brief

You are handed the course retail dataset — 15,067 order lines, 7,607 orders, 896 customers, two full years. The commercial director says only: “Something's wrong with our margins. Have a look.” That is all you get. Turn it into a brief you could actually build from.

Requirements
  • State the one descriptive question you would answer first, and why that one
  • State two diagnostic questions that would decompose the margin problem
  • For each question, name the specific columns you would need from the dataset
  • Write the one-sentence brief from section 10 for the whole project
  • Name one thing you would refuse to claim from this data, and explain why
You have not learned any Power BI yet — that is deliberate. This challenge tests analytical framing, which you can do with the dataset documentation alone. Look at the column list in the dataset library if you want the exact field names.

Margin is Profit / NetSales. Anything that moves either number moves margin. There are only four levers, and every margin problem is one or more of them:

  • Price — are we selling at lower unit prices?
  • Discount — are we discounting more heavily or more often?
  • Cost — has unit cost risen?
  • Mix — are we selling proportionally more of the low-margin categories? This one is the most commonly missed, and it is often the answer.

The dataset has a column for each of the first three. Mix you derive by comparing each category's share of revenue across periods. Note that the categories in this dataset have very different margins — Electronics is around 13% while Beauty is around 44% — so mix shifts move total margin hard.

13

Solution

Try the challenge properly before opening this. Reading a solution you have not attempted feels like learning, but it is not.

A model answer

The first descriptive question

“How has profit margin % moved by month across the two years?”

Why this one first: the director's claim is unverified. Before investigating a cause you must confirm the effect exists, establish its size, and locate it in time. If margin has actually been flat and one bad month spooked them, the entire project changes — and finding that out in an hour rather than a fortnight is a real result.

Columns needed: OrderDate, NetSales, Profit.

Two diagnostic questions

  1. “Is the margin movement driven by mix — are low-margin categories taking a larger share of revenue over time?”
    Columns: OrderDate, ProductKey → Category, NetSales, Profit. In this dataset Electronics is by far the largest category by revenue but carries the thinnest margin, so a shift toward it would drag total margin down even with every individual product's margin unchanged. That distinction — total margin falling while no product got less profitable — is the single most valuable thing you can show a commercial director.
  2. “Is discounting deepening, and is it concentrated in particular categories or months?”
    Columns: Discount, OrderDate, Category, NetSales. Compare average discount rate and discounted-revenue share over time. The November promotional period is the obvious place to look first.

The one-sentence brief

The brief
“This report helps the commercial director decide whether to change our discounting policy or our category mix targets, by showing profit margin % broken down by month, category and discount band.”

What you would refuse to claim

You would refuse to claim that reducing discounts would raise profit. The dataset shows what was sold at what discount; it cannot show what would have been sold at a different discount. Cutting a discount may simply lose the volume. Establishing that requires a controlled test — a genuine price experiment — not historical data, however much of it you have.

Why this answer is strong
It confirms before explaining, it names mix as a candidate driver before touching the data, it ties every question to specific columns, and it draws an explicit line around what the data cannot support. In an interview, the refusal-to-claim paragraph is frequently the part that gets you the job — it demonstrates you will not quietly mislead your stakeholders.

If you are self-assessing, score against these weights. The same rubric shape is used for every project in Module 10.

Question framing30%
Correct rung used20%
Data specificity20%
Decision linkage20%
Stated limits10%
14

Lesson Summary

Key takeaways
  • Data analytics needs three things: a question, data, and a decision that could go differently. Missing any one of them and you are making charts, not analysing.
  • The four rungs — descriptive, diagnostic, predictive, prescriptive — each answer a different question and carry different limits. You cannot skip rungs.
  • Business intelligence is analytics made repeatable, shared and governed. Its failure mode is worse than a one-off's, which is why modelling discipline matters so much.
  • Power BI is strongest at descriptive and diagnostic work, has real but limited predictive features, and leaves prescriptive judgement to you.
  • Observational data supports association, not causation. Match your language to your evidence.
  • The one-sentence brief — person, decision, metric, breakdown — is the fastest test of whether a project is worth building.

Syllabus topics delivered

What is Data Analytics?What is Business Intelligence?The four analytic typesAnalytics vs BI vs Data Science
15

Progress

Marking a lesson complete stores your progress in this browser and updates your BitWithBite learner dashboard. Nothing is uploaded anywhere.

Lesson complete — 1% of Power BI Mastery done
Progress saved. Keep the momentum: the next lesson builds directly on this one.