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

سرفصل های دوره

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

1 - 01Advanced Data Connections

1 - 0100aWelcome

2 - 0100bDownload the Course Files.html

2 - power-bi-advanced.zip

3 - 0101Navigating Data Structures

4 - 0102Connecting to JSON Files

5 - 0103Connecting to XML Files

6 - 0104Connecting to Files in a SharePoint Library

7 - 0105Connecting to SharePoint Folders

8 - 0106Accessing SharePoint SubFolders

9 - 0107Understanding Storage Modes

10 - 0108Using PBIDS Files

2 - 02Advanced Power Query

11 - 0201Optimizing Data Types

12 - 0202Grouping Data

13 - 0203Column Profiling

14 - 0204Column Profile Statistics

3 - 03Examining M Language Code

15 - 0301TableCombine

16 - 0302TableNestedJoin

17 - 0303TableRemoveColumns vs TableSelectColumns

18 - 0304TableUnpivotOtherColumns

19 - 0305TableReplaceValues

20 - 0306TableTransformColumnTypes

21 - 0307TableRenameColumns

22 - 0308Writing an M Function

4 - 04Data Centralisation

23 - 0401Disabling Data Export

24 - 0402Creating a Dataflow

25 - 0403Creating a Shared Dataset

26 - 0404Promoting and Certifying Datasets

27 - 0405Granting Access to Datasets

28 - 0406Using Microsoft Dataverse

5 - 05Advanced Data Modelling

29 - 0501ManytoMany Relationships

30 - 0502CrossFilter Direction

31 - 0503Setting Table Properties

32 - 0504Setting Field Properties

6 - 06Advanced DAX

33 - 0601RELATED and RELATEDTABLE

34 - 0602Using ADDCOLUMNS

35 - 0603Using SUMMARIZE

36 - 0604SemiAdditive Measures

37 - 0605DAX Path Functions

7 - 07DAX Time Intelligence

38 - 0701DATESYTD and DATESMTD

39 - 0702SAMEPERIODLASTYEAR

40 - 0703DATEADD

41 - 0704PARALLELPERIOD

42 - 0705Running Total

43 - 0706DATESINPERIOD

8 - 08Role Playing Dimensions

44 - 0801Connecting to the data

45 - 0802Performing Basic Transformations

46 - 0803Connecting to an External Date Table

47 - 0804Overview of Relationships

48 - 0805Engineering a OnetoMany Relationship

49 - 0806Handling multiple significant dates

50 - 0807Active and Inactive Relationships

51 - 0808Using the Default Relationship

52 - 0809The USERELATIONSHIP Function

53 - 0810Calculating Key Metrics

9 - 09Advanced Visualization Practice

54 - 0901Visualizing our Data

55 - 0902Displaying Top 5 Customers

56 - 0903Sources of Business

57 - 0904Displaying the Sales Funnel

58 - 0905Converted and Lost Business

59 - 0906Displaying Target vs Actual

60 - 0907Sales Opportunities by Month

61 - 0908Displaying Sales Managers

62 - 0909Displaying Sales People

63 - 0910Dynamically Showing a Chart

64 - 0911Optimizing Visual Interactions

10 - 10Advanced Dashboard Tiles

65 - 1001Creating Hyperlinks in a Text Box

66 - 1002Creating Image Tiles

67 - 1003Creating WebContent Tiles

68 - 1004Creating Video Tiles

69 - 1005Streaming RealTime Data Tiles

11 - 11Power BI AI Capabilities

70 - 1101The Key Influencers Visual

71 - 1102The Decomposition Tree Visual

72 - 1103The QA Visual

73 - 1104Quick Insights

74 - 1105AI Insights

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training