Menu
CoddyTech
Start learning

What Power BI Is

Part of the Power BI Basics section of Coddy's Power BI journey. Lesson 1 of 28.

You are the new analyst of Lumen Coffee, a small chain of coffee shops. Mia, the owner, has two years of sales data and questions about it.

Power BI turns tables of data into a report: a page of charts, tables and cards. Each one is a visual.

Four skills build a report: Power Query (cleaning data), the model (linking tables), DAX (formulas) and visuals. The simplest visual is a card: one big number.

challenge icon

Challenge

Mia's first question: how many items has Lumen sold in all? Add a card and drop Quantity from the Sales table into it.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in Power BI Basics

1Meet Power BI

What Power BI IsTables, Rows and ColumnsYour First ChartSum, Count and AverageFilters and SlicersRecap - Mia's First Report

4Calculated Columns

Columns vs MeasuresIF in a ColumnText ColumnsLooking Up with RELATEDColumns Feed MeasuresProfit and MarginWhen to Use WhichRecap - Profit by Category

2Your First Measures

What a Measure IsCounting RowsAverage, Min and MaxCounting Distinct ThingsMeasures Can Do MathSafe Division with DIVIDEMeasures Use Other MeasuresRecap - The Numbers Mia Wants

3One Measure, Many Answers

Same Measure, Every BarThe Total RowSlicers Change the AnswerTwo Fields on RowsFilters Follow RelationshipsRecap - The Store Report