564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Here are the chapters included in this course manual (we use exactly the same manuals for our classroom and online Power BI courses).
Click here to download a sample of the first two chapters of this Fast-track Power BI/DAX manual, or review how to license our courseware.
Section | Title |
---|---|
1.1 | What is Power BI Desktop? |
1.2 | Installing and Updating Power BI |
Section | Title |
---|---|
2.1 | Getting Started in Power BI Desktop |
2.2 | Working with Files |
2.3 | The Power BI Desktop Screen |
2.4 | Getting Data |
2.5 | Transforming Data |
2.6 | Creating Visualisations |
2.7 | Formatting Visuals |
2.8 | Filtering Visuals |
2.9 | Working with Report Pages |
2.10 | Themes |
Section | Title |
---|---|
3.1 | Our Example |
3.2 | Importing from Different Sources |
3.3 | Importing from Excel |
3.4 | Importing CSV or Text Files |
3.5 | Importing from SQL Server |
3.6 | Importing from a Website |
3.7 | Importing a Power BI Dataset |
3.8 | Entering Data Manually |
Section | Title |
---|---|
4.1 | Data Models |
4.2 | Model Diagrams |
4.3 | Model Properties |
4.4 | Relationships |
Section | Title |
---|---|
5.1 | Overview of Visualisations |
5.2 | Working with Visualisations |
5.3 | The Selection Pane |
5.4 | Visual Interactions |
Section | Title |
---|---|
6.1 | Basic Tables |
6.2 | Working with Table Columns |
6.3 | Aggregating Data |
6.4 | Formatting Numbers |
6.5 | Formatting Dates |
6.6 | Formatting Visuals – General |
6.7 | Specific to Formatting Tables |
6.8 | The Wonderful Format Painter |
6.9 | Images and URLs in Tables |
Section | Title |
---|---|
7.1 | Conditional Formatting |
7.2 | Applying Conditional Formatting to Fields |
7.3 | Gradient Effects |
7.4 | Rules-Based Conditional Formatting |
7.5 | Data Bars |
7.6 | Formatting Using Field Values |
7.7 | Displaying Icons |
Section | Title |
---|---|
8.1 | Overview of Matrices |
8.2 | Creating a Matrix |
8.3 | Multiple Rows, Columns and Values |
Section | Title |
---|---|
9.1 | Non-Data Visualisations |
9.2 | Images |
9.3 | Text Boxes |
9.4 | Shapes |
Section | Title |
---|---|
10.1 | The Parts of a Chart |
10.2 | Types of Chart Available |
10.3 | Creating a Chart |
10.4 | Sorting Charts |
10.5 | Formatting Charts |
10.6 | Excluding and Including Data |
10.7 | Zoom Sliders |
Section | Title |
---|---|
11.1 | What Makes a Good Small Multiple? |
11.2 | Creating Small Multiples |
Section | Title |
---|---|
12.1 | Column and Bar Charts |
12.2 | Line Charts |
12.3 | Combined Charts |
12.4 | Waterfall Charts |
12.5 | Scatter and Bubble Charts |
12.6 | Other Chart Types |
Section | Title |
---|---|
13.1 | Grouping |
13.2 | Binning |
Section | Title |
---|---|
14.1 | What is Drill-Down? |
14.2 | Using Drill-Down |
14.3 | Drill-Down in a Matrix |
14.4 | Showing Data Tables |
Section | Title |
---|---|
15.1 | Gauges |
15.2 | KPIs |
15.3 | Cards |
Section | Title |
---|---|
16.1 | Slicer Basics |
16.2 | Number and Date Slicers |
16.3 | Sync Slicers |
16.4 | Hierarchical Slicers |
Section | Title |
---|---|
17.1 | How Filters Work |
17.2 | The Filters Pane |
17.3 | Applying and Removing Filters |
17.4 | Sorting Filters |
17.5 | Formatting Filters |
17.6 | Controlling Filters for End Users |
Section | Title |
---|---|
18.1 | What are Drill-Through Filters? |
18.2 | Creating a Drillthrough Filter |
18.3 | Extra Drillthrough Options |
18.4 | Buttons for Drill-Through |
Section | Title |
---|---|
19.1 | Overview |
19.2 | Adding Clickable Shapes |
19.3 | Adding Clickable Images |
19.4 | Adding Clickable Buttons |
Section | Title |
---|---|
20.1 | Overview |
20.2 | Page Navigators |
20.3 | Simple Custom Page Navigators |
20.4 | Dynamic Page Navigation |
Section | Title |
---|---|
21.1 | What are Custom Visuals? |
21.2 | Adding Custom Visuals |
21.3 | Using a Custom Visual |
21.4 | Removing Custom Visuals |
Section | Title |
---|---|
22.1 | What are Queries? |
22.2 | Working with Queries |
22.3 | Transforming Data |
22.4 | Creating New Columns |
22.5 | Conditional Columns |
Section | Title |
---|---|
23.1 | Overview of Maps |
23.2 | Choosing a Mapping Tool |
23.3 | Creating Maps |
23.4 | Geocoding |
23.5 | Latitude and Longitude |
23.6 | Drilldown in Maps |
Section | Title |
---|---|
24.1 | Overview of Publishing |
24.2 | An Infinite Number of Variables |
24.3 | Logging on to Power BI Service |
24.4 | Creating Workspaces |
24.5 | Publishing a Report |
24.6 | Viewing and Editing Reports |
24.7 | Dashboards and Tiles |
24.8 | Sharing and Exporting Reports |
Section | Title |
---|---|
25.1 | Introduction to Calculated Columns |
25.2 | Creating Calculated Columns |
25.3 | Conditional Functions |
25.4 | The RELATED Function |
25.5 | Blanks |
25.6 | Testing for Errors |
Section | Title |
---|---|
26.1 | Using DAX Studio |
26.2 | Five Uses of DAX Studio |
Section | Title |
---|---|
27.1 | Introduction to Measures |
27.2 | Creating a Measures Table |
27.3 | Creating Measures |
27.4 | Quick Measures |
27.5 | DAX Aggregation Functions |
27.6 | Aggregating Expressions |
27.7 | Calculating Ratios |
Section | Title |
---|---|
28.1 | Our Simple Example |
28.2 | How Filter Context Works |
Section | Title |
---|---|
29.1 | Row Context for Calculated Columns |
29.2 | Iterator Functions |
Section | Title |
---|---|
30.1 | Syntax of the CALCULATE Function |
30.2 | Removing a Constraint |
30.3 | Removing Multiple Constraints |
30.4 | Replacing a Constraint |
30.5 | Using ALLSELECTED |
30.6 | Context Transition |
Section | Title |
---|---|
31.1 | Referring to Measures within Measures |
31.2 | Creating Variables |
31.3 | Lazy Evaluation and its Implications |
31.4 | Storing Tables in Variables |
31.5 | Debugging using Variables |
Section | Title |
---|---|
32.1 | The Basic FILTER Function |
32.2 | FILTER as an Iterator Function |
32.3 | Multiple Conditions in FILTER Functions |
32.4 | Using ALL and FILTER |
32.5 | FILTER and CALCULATE aren’t Equivalent |
Section | Title |
---|---|
33.1 | Introducing the VALUES Function |
33.2 | Detecting the Number of Values |
33.3 | Using VALUES to Modify Filter Context |
33.4 | Parameter Tables |
33.5 | Dynamic Titles using ISFILTERED |
Section | Title |
---|---|
34.1 | What are Calendar Tables? |
34.2 | Creating a Calendar |
34.3 | Date Granularity |
34.4 | Special Days |
Section | Title |
---|---|
35.1 | The Problem, and Two Solutions |
35.2 | Solution One: Duplicate the Calendar Table |
35.3 | Solution Two: Duplicate the Relationship |
35.4 | CROSSFILTER Function |
Section | Title |
---|---|
36.1 | Contents of the Chapter |
36.2 | Period to Date |
36.3 | Changing the Financial Year End |
36.4 | Referencing Previous Periods |
36.5 | Parallel Periods |
36.6 | Moving Averages |
36.7 | Semi-Additive Measures |
If you book a place on one of our courses you will automatically get access to the relevant courseware manual online, and also have the option to receive a paper copy of it.
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2023. All Rights Reserved.