Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
549 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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 | Views in Power BI Desktop |
2.4 | Getting Data |
2.5 | Transforming Data |
2.6 | Creating Visuals |
2.7 | Three Ways to Format Visuals |
2.8 | Publishing your Report |
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 | Entering Data Manually |
Section | Title |
---|---|
4.1 | Data Models |
4.2 | Model Diagrams |
4.3 | Hiding Objects |
4.4 | Model Properties |
4.5 | Relationships |
Section | Title |
---|---|
5.1 | Overview of Visuals |
5.2 | Adding and Changing Visuals |
5.3 | Working with Visuals |
5.4 | The Selection Pane |
Section | Title |
---|---|
6.1 | Overview |
6.2 | Editing Visual Interactions |
Section | Title |
---|---|
7.1 | Finding Formatting Properties |
7.2 | Common Formats to Apply |
7.3 | Header Icons |
7.4 | Tooltips |
7.5 | Useful General Formatting Tricks |
7.6 | Themes |
Section | Title |
---|---|
8.1 | Basic Tables |
8.2 | Working with Table Columns |
8.3 | Aggregating Data |
8.4 | Formatting Numbers |
8.5 | Working with Dates in Tables |
8.6 | Specific to Formatting Tables |
Section | Title |
---|---|
9.1 | Conditional Formatting |
9.2 | Applying Conditional Formatting |
9.3 | Gradient Effects |
9.4 | Rules-Based Conditional Formatting |
9.5 | Formatting Using Field Values |
9.6 | Data Bars |
9.7 | Displaying Icons |
Section | Title |
---|---|
10.1 | Overview of Matrices |
10.2 | Creating a Matrix |
10.3 | Multiple Rows, Columns and Values |
Section | Title |
---|---|
11.1 | Overview |
11.2 | Images |
11.3 | Text Boxes |
11.4 | Shapes |
Section | Title |
---|---|
12.1 | The Parts of a Chart |
12.2 | Types of Chart Available |
12.3 | Working with Charts |
12.4 | Quick Ways to Format Charts |
12.5 | Chart Legends |
12.6 | Detail Labels |
12.7 | Background and Gridlines |
12.8 | Axes |
12.9 | Conditional Formatting |
Section | Title |
---|---|
13.1 | Overview of Small Multiples |
13.2 | Creating and Formatting Small Multiples |
13.3 | which will leave 2 extra blank cells on the bottom row. |
13.4 | Making the Background Colour Dynamic |
Section | Title |
---|---|
14.1 | Line, Combination and Area Charts |
14.2 | Pie, Donut and Treemap Charts |
14.3 | Scatter and Bubble Charts |
Section | Title |
---|---|
15.1 | Grouping |
15.2 | Binning |
Section | Title |
---|---|
16.1 | New Cards |
16.2 | Working with Cards |
16.3 | Reference Labels |
16.4 | Multi-row Cards |
Section | Title |
---|---|
17.1 | Gauges |
Section | Title |
---|---|
18.1 | Overview of KPIs |
18.2 | Creating Targets |
Section | Title |
---|---|
19.1 | What are Custom Visuals? |
19.2 | Adding Custom Visuals |
19.3 | Working with Custom Visuals |
Section | Title |
---|---|
20.1 | Drill-Down for Charts |
20.2 | Drill-Down in a Matrix |
Section | Title |
---|---|
21.1 | Introducing Slicers |
21.2 | Working with Slicers |
21.3 | Hierarchical Slicers |
21.4 | Number and Date Slicers |
Section | Title |
---|---|
22.1 | Overview of the New Slicer Visual |
22.2 | Working with the New Slicer |
Section | Title |
---|---|
23.1 | How Filters Work |
23.2 | Working with Filters |
23.3 | Formatting Filters |
23.4 | Controlling Filters for End Users |
Section | Title |
---|---|
24.1 | What are Drill-Through Filters? |
24.2 | Creating a Drill-through Filter |
24.3 | Three Ways to Drill Through |
24.4 | Adding a Context-Sensitive Title |
24.5 | Extra Drill-through Options |
Section | Title |
---|---|
25.1 | What are Queries? |
25.2 | Working with Queries |
25.3 | Common Transforms |
25.4 | Creating New Columns |
Section | Title |
---|---|
26.1 | Introduction to Calculated Columns |
26.2 | Creating Calculated Columns |
26.3 | Conditional Functions |
26.4 | The RELATED Function |
26.5 | Blanks |
26.6 | Testing for Errors |
Section | Title |
---|---|
27.1 | Overview of Maps |
27.2 | Choosing a Map Visual |
27.3 | Maps Using Latitude and Longitude |
27.4 | Maps without Latitude and Longitude |
27.5 | General Maps |
27.6 | Specific Types of Maps |
27.7 | Layers |
Section | Title |
---|---|
28.1 | Overview of Publishing |
28.2 | An Infinite Number of Variables |
28.3 | Workspaces |
28.4 | Creating Workspaces |
28.5 | Publishing Reports |
28.6 | Viewing and Editing Reports |
28.7 | Dashboards and Tiles |
28.8 | Lineage View |
28.9 | Refreshing Data |
28.10 | Sharing and Exporting Reports |
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 2024. All Rights Reserved.