Power BI Advanced: Take your Power BI Skills to a New Level

Focused View

Grant Gamble

7:10:34

99 View

1 - 01Advanced Data Connections

1 - 0100aWelcome.mp4

02:31

2 - 0100bDownload the Course Files.html

2 - power-bi-advanced.zip

3 - 0101Navigating Data Structures.mp4

03:12

4 - 0102Connecting to JSON Files.mp4

05:54

5 - 0103Connecting to XML Files.mp4

07:12

6 - 0104Connecting to Files in a SharePoint Library.mp4

05:06

7 - 0105Connecting to SharePoint Folders.mp4

05:08

8 - 0106Accessing SharePoint SubFolders.mp4

03:21

9 - 0107Understanding Storage Modes.mp4

11:06

10 - 0108Using PBIDS Files.mp4

03:36

2 - 02Advanced Power Query

11 - 0201Optimizing Data Types.mp4

07:31

12 - 0202Grouping Data.mp4

06:04

13 - 0203Column Profiling.mp4

09:42

14 - 0204Column Profile Statistics.mp4

04:10

3 - 03Examining M Language Code

15 - 0301TableCombine.mp4

02:20

16 - 0302TableNestedJoin.mp4

02:30

17 - 0303TableRemoveColumns vs TableSelectColumns.mp4

03:37

18 - 0304TableUnpivotOtherColumns.mp4

02:56

19 - 0305TableReplaceValues.mp4

02:13

20 - 0306TableTransformColumnTypes.mp4

01:27

21 - 0307TableRenameColumns.mp4

08:48

22 - 0308Writing an M Function.mp4

14:11

4 - 04Data Centralisation

23 - 0401Disabling Data Export.mp4

02:38

24 - 0402Creating a Dataflow.mp4

08:14

25 - 0403Creating a Shared Dataset.mp4

06:47

26 - 0404Promoting and Certifying Datasets.mp4

05:20

27 - 0405Granting Access to Datasets.mp4

03:16

28 - 0406Using Microsoft Dataverse.mp4

07:36

5 - 05Advanced Data Modelling

29 - 0501ManytoMany Relationships.mp4

11:55

30 - 0502CrossFilter Direction.mp4

16:54

31 - 0503Setting Table Properties.mp4

06:44

32 - 0504Setting Field Properties.mp4

04:27

6 - 06Advanced DAX

33 - 0601RELATED and RELATEDTABLE.mp4

14:25

34 - 0602Using ADDCOLUMNS.mp4

05:11

35 - 0603Using SUMMARIZE.mp4

08:37

36 - 0604SemiAdditive Measures.mp4

05:43

37 - 0605DAX Path Functions.mp4

09:54

7 - 07DAX Time Intelligence

38 - 0701DATESYTD and DATESMTD.mp4

05:31

39 - 0702SAMEPERIODLASTYEAR.mp4

06:42

40 - 0703DATEADD.mp4

03:21

41 - 0704PARALLELPERIOD.mp4

06:18

42 - 0705Running Total.mp4

03:41

43 - 0706DATESINPERIOD.mp4

07:04

8 - 08Role Playing Dimensions

44 - 0801Connecting to the data.mp4

04:07

45 - 0802Performing Basic Transformations.mp4

05:19

46 - 0803Connecting to an External Date Table.mp4

10:47

47 - 0804Overview of Relationships.mp4

06:06

48 - 0805Engineering a OnetoMany Relationship.mp4

10:03

49 - 0806Handling multiple significant dates.mp4

07:14

50 - 0807Active and Inactive Relationships.mp4

02:41

51 - 0808Using the Default Relationship.mp4

02:47

52 - 0809The USERELATIONSHIP Function.mp4

06:13

53 - 0810Calculating Key Metrics.mp4

06:27

9 - 09Advanced Visualization Practice

54 - 0901Visualizing our Data.mp4

03:21

55 - 0902Displaying Top 5 Customers.mp4

03:44

56 - 0903Sources of Business.mp4

02:51

57 - 0904Displaying the Sales Funnel.mp4

03:13

58 - 0905Converted and Lost Business.mp4

07:07

59 - 0906Displaying Target vs Actual.mp4

06:54

60 - 0907Sales Opportunities by Month.mp4

04:43

61 - 0908Displaying Sales Managers.mp4

05:23

62 - 0909Displaying Sales People.mp4

04:09

63 - 0910Dynamically Showing a Chart.mp4

07:58

64 - 0911Optimizing Visual Interactions.mp4

04:02

10 - 10Advanced Dashboard Tiles

65 - 1001Creating Hyperlinks in a Text Box.mp4

04:00

66 - 1002Creating Image Tiles.mp4

01:12

67 - 1003Creating WebContent Tiles.mp4

01:59

68 - 1004Creating Video Tiles.mp4

00:59

69 - 1005Streaming RealTime Data Tiles.mp4

07:57

11 - 11Power BI AI Capabilities

70 - 1101The Key Influencers Visual.mp4

08:10

71 - 1102The Decomposition Tree Visual.mp4

05:10

72 - 1103The QA Visual.mp4

09:57

73 - 1104Quick Insights.mp4

05:18

74 - 1105AI Insights.mp4

07:50

Description

Hone your Power BI Expertise by Learning Advanced Power BI Skills and Techniques

What You'll Learn?

Advanced features of Microsoft Power BI
Extend your knowledge of Power Query
Advanced insights into Power Query and the M language
Advanced data modelling and visualization techniques

Who is this for?

Existing users of Power BI looking to extend their knowledge

More details

Description
The G Com Solutions Power BI Advanced course is designed to give experienced Power BI users the opportunity to hone their expertise in Power BI by tackling a series of challenging and useful Power BI techniques.

This course assumes that you are already familiar with Power Query and so we dive straight into advanced topics like the optimizing Data Types, column Profiling and writing M language code, as well as discussing advanced data connection techniques used when working with JSON, XML and SharePoint libraries and folders.

The course also provides further practice on data modelling, discussing such topics as role-playing dimensions and use of inactive relationships to cater for multiple significant dates within a main fact table. And, naturally, you will get plenty of additional practice in all aspects of DAX: calculated columns, calculated tables, DAX measures and time-intelligence functions.

As an advanced Power BI report developer, it is also important that you build and utilize datasets in the most efficient manner. In this course, you will learn how to implement data centralization by using PBIDS Files, disabling the export of static data from your reports, creating dataflows and shared Datasets and how to promote and certifying your centralized datasets.

The course also provides advanced visualization practice, and you will be given the opportunity to create a sophisticated sales pipeline dashboard, starting from scratch and using such techniques as dynamic chart titles and colors and Dynamically Showing a Chart.

Then, back in the Power BI service, we discuss the finer points of dashboard tiles: Creating Hyperlinks in a Text Box, working with Image Tiles, Web content tiles, Video Tiles, and Streaming Real-time data by integrating Power Automate functionality.

We then turn our attention to visualizing our data, we look at using the form of visual as well as displaying a hierarchy of images in slices, which enable the user to track the performance of sales managers, as well as individual salespeople. We also look at a useful technique for creating a chart which only becomes visible when a slicer selection is made by the user.

In short, this course will offer Power BI users who are familiar with all of the fundamentals a challenging hands-on workshop, which will expand their familiarity with Power BI best practices, data modelling, visualization and report creation.
Who this course is for:
Existing users of Power BI looking to extend their knowledge

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Grant Gamble

Instructor's Courses

Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes. His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI, VBA, web development and Adobe Creative Suite automation.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.