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
546 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 Advanced Power BI (Data) manual, or review how to license our courseware.
Section | Title |
---|---|
1.1 | Splitting Columns |
1.2 | Merging Columns |
1.3 | Extracting Data |
Section | Title |
---|---|
2.1 | Ways to Create New Columns |
2.2 | Columns from Examples |
2.3 | Built-up Columns |
2.4 | Custom Columns in M |
2.5 | Special Case - Last Refresh Date/Time |
2.6 | Conditional Columns |
2.7 | Indexing Columns |
Section | Title |
---|---|
3.1 | Loading Multiple Files from a Folder |
3.2 | Appending Queries |
3.3 | Merging Data |
3.4 | Fuzzy Merging |
Section | Title |
---|---|
4.1 | Unpivoting Data |
4.2 | Grouping Data |
4.3 | Pivoting Columns |
4.4 | Transposing Data: Replacing Text |
4.5 | Transposing Data: Joining Rows Together |
Section | Title |
---|---|
5.1 | Our Example |
5.2 | Extracting Unique Lists |
5.3 | Numbering the Lists |
5.4 | Storing Id Numbers not Names |
Section | Title |
---|---|
6.1 | Showing Column Profiles |
Section | Title |
---|---|
7.1 | Removing Nulls |
7.2 | Filtering Dates |
Section | Title |
---|---|
8.1 | Default Treatment of Errors |
8.2 | Fixing Errors in a Separate Table |
8.3 | Fixing Errors In Situ |
Section | Title |
---|---|
9.1 | Creating Dataflows |
9.2 | Basing Reports on Dataflows |
Section | Title |
---|---|
10.1 | Overview of Row-Level Security |
10.2 | Roles in Power BI Desktop |
10.3 | Roles in Power BI Service |
10.4 | Dynamic Security |
10.5 | Creating Groups of Users |
Section | Title |
---|---|
11.1 | Our Example |
11.2 | Changing the Data Source Manually |
11.3 | Switching the Data Source using M |
Section | Title |
---|---|
12.1 | Parameters, Slicers and Filters |
12.2 | Working with Parameters |
12.3 | Entering Values for Parameters |
12.4 | Using Parameters |
12.5 | Using Parameters with Templates |
12.6 | Query Dependencies |
Section | Title |
---|---|
13.1 | Our Example |
13.2 | Creating a Simple List Parameter |
13.3 | Using List Queries for Parameters |
13.4 | Referencing the Dropdown Parameter |
Section | Title |
---|---|
14.1 | Overview |
14.2 | Loading Data from a Stored Procedure |
14.3 | Making Parameters Dynamic |
Section | Title |
---|---|
15.1 | SQL Server Dynamic Connections |
15.2 | Dynamic Connections to Excel |
Section | Title |
---|---|
16.1 | Overview |
16.2 | Example – Splitting Postcodes |
16.3 | Example - Combining Selected Worksheets |
16.4 | Combining Tables from Web Pages |
Section | Title |
---|---|
17.1 | Our Example |
17.2 | Extracting Text from HTML |
17.3 | Transforming JSON |
17.4 | Getting External Links |
Section | Title |
---|---|
18.1 | Introducing APIs |
18.2 | Some Simple Examples |
18.3 | A Digression: Displaying Images Properly |
18.4 | Case Study – Exchange Rates |
18.5 | Multiple Table APIs |
Section | Title |
---|---|
19.1 | Overview |
19.2 | Text Analytics |
19.3 | Tagging Images |
Section | Title |
---|---|
20.1 | Our Example |
20.2 | Creating the Button and Flow |
20.3 | Testing your Button |
Section | Title |
---|---|
21.1 | Overview |
21.2 | Embedding an App |
Section | Title |
---|---|
22.1 | Overview |
22.2 | Creating the Power BI Report |
22.3 | Creating your Dashboard |
22.4 | Showing the Live Page in Power 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 2024. All Rights Reserved.