559 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 Introduction to Power BI 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 | Gauges |
14.2 | KPIs |
14.3 | Cards |
Section | Title |
---|---|
15.1 | What are Custom Visuals? |
15.2 | Adding Custom Visuals |
15.3 | Using a Custom Visual |
15.4 | Removing Custom Visuals |
Section | Title |
---|---|
16.1 | What is Drill-Down? |
16.2 | Using Drill-Down |
16.3 | Drill-Down in a Matrix |
16.4 | Showing Data Tables |
Section | Title |
---|---|
17.1 | Slicer Basics |
17.2 | Number and Date Slicers |
17.3 | Sync Slicers |
17.4 | Hierarchical Slicers |
Section | Title |
---|---|
18.1 | How Filters Work |
18.2 | The Filters Pane |
18.3 | Applying and Removing Filters |
18.4 | Sorting Filters |
18.5 | Formatting Filters |
18.6 | Controlling Filters for End Users |
Section | Title |
---|---|
19.1 | What are Drill-Through Filters? |
19.2 | Creating a Drillthrough Filter |
19.3 | Extra Drillthrough Options |
19.4 | Buttons for Drill-Through |
Section | Title |
---|---|
20.1 | What are Queries? |
20.2 | Working with Queries |
20.3 | Transforming Data |
20.4 | Creating New Columns |
20.5 | Conditional Columns |
Section | Title |
---|---|
21.1 | Introduction to Calculated Columns |
21.2 | Creating Calculated Columns |
21.3 | Conditional Functions |
21.4 | The RELATED Function |
21.5 | Blanks |
21.6 | Testing for Errors |
Section | Title |
---|---|
22.1 | Overview of Maps |
22.2 | Choosing a Mapping Tool |
22.3 | Creating Maps |
22.4 | Geocoding |
22.5 | Latitude and Longitude |
22.6 | Drilldown in Maps |
Section | Title |
---|---|
23.1 | Overview of Publishing |
23.2 | An Infinite Number of Variables |
23.3 | Logging on to Power BI Service |
23.4 | Creating Workspaces |
23.5 | Publishing a Report |
23.6 | Viewing and Editing Reports |
23.7 | Dashboards and Tiles |
23.8 | Sharing and Exporting Reports |
Section | Title |
---|---|
24.1 | What are Apps? |
24.2 | Creating Apps |
24.3 | Installing Apps |
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.