Microsoft Power BI Tutorial 2024 – Beginners / Professional

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

The Full and Thorough Power BI Course: A Step-by-Step Guide with Practical Demonstrations Using Power BI.

1 - Beginner

1 - Introduction

2 - Data Analytics and licensing options

3 - Products and Services

4 - Getting Data from Multiple Resources

5 - Savings

6 - Touring View

7 - Starting New Instances of Power BI Desktop

8 - Splash Screen

9 - Getting Data from Access Database

10 - Table Relationships and Settings

11 - Web URL

12 - Excel Files and Pivot Data Model

13 - Resolving Data Errors

14 - Implications of Locally Stored Vs Cloud Based Excel Files

15 - Conclusion

2 - Intermediate

16 - Data Shaping

17 - Enhancing Data Structure

18 - Data Profiling Recap

19 - Introduction to a Data Model

20 - Working With Tables

21 - Fact Vs Dimension

22 - Breaking Down Tables

23 - Creating Hierarchy

24 - Relationships AKA Cardinality

25 - Creating Relationships

26 - Reviewing The Model Interface

27 - Creating RLS Roles In Desktop

28 - Assigning Users to RLS Roles In Service

29 - Conclusion

3 - Advanced

30 - Introduction

31 - Creating Calculated Tables and DATEDIFF

32 - RANKX Lowest

33 - RANKX Highest

34 - RANKX DENSE

35 - Creating Quick Measures

36 - Creating Measures

37 - Creating Data Tables

38 - Time Intelligence Functions

39 - Key Performance Indicators

40 - Additional Key Performance Indicators

41 - DAX Recap

42 - Introduction To Optimizing Model Performance

43 - Publishing Dataset to Service

44 - Using Direct Query on Power BI Dataset

45 - Direct Query vs Import File Size Comparison

46 - Importance of Variables

47 - Building a Measure to Use in A Measure

48 - Building a Measure with Variables and Comments

49 - Adding Measures to MultiRow Card

50 - Other Optimization Techniques

51 - Conclusion

4 - Expert

52 - Introduction

53 - Creating Reports with Pie Charts

54 - Adding Tooltips to Reports

55 - Formatting Reports with Pie Charts

56 - Filtering and Sorting Reports

57 - Sync Slicers

58 - Creating Drill Through Pages

59 - Creating Source Reports with Slicers

60 - Using Drill Through

61 - Formatting Drill Through Pages

62 - Formatting Two Objects at Once

63 - Conditional Formatting

64 - Bookmarks

65 - Accessibility Features

66 - Accessibility Alt Text Data Table Focus View

67 - Accessibility Tab Order

68 - Accessibility Colorblind Friendly

69 - Adding the Histogram Visualization

70 - Creating Histograms

71 - Copy Visual

72 - Reports Recap

73 - Introduction to Creating Dashboards

74 - Creating Dashboards Editing Published Reports and Pinning to a New Dashboard

75 - Introduction to RealTime Dashboards

76 - Creating Push Datasets

77 - Creating Reports for RealTime Dashboards

78 - Creating Forms for Pushing Data

79 - Creating Dashboards for Streaming Data

80 - Accessing Power Automate

81 - Creating a Flow to Push Form Data into Dataset

82 - Respond to Survey

83 - Viewing RealTime Dashboards

84 - Enhancing Dashboards with Custom Themes

85 - Enhancing Dashboards with Videos

86 - Configuring Dashboard Tile Alerts

87 - Using Q and A and Quick Insights and Add to Dashboardmp4

88 - More Dashboard Features

89 - Conclusion

5 - Master

90 - Introduction

91 - Loading Sample Data and Making Workspace Premium

92 - Downloading Report Builder and Creating Paginated Reports

93 - Sorting Reports in Design View

94 - Adding Report Headers and Making Them Repeat Across Pages

95 - Making Column Headers Repeat Across Pages and Publishing Reports

96 - Reviewing Paginated Reports Print Preview and Export Options

97 - Paginted Reports Recap

98 - Introduction to Performing Advanced Analytics

99 - Accessing a Sample Desktop File from the Service

100 - Advanced Analytics Grouping

101 - Advanced Analytics Binning

102 - Advanced Analytics Drill Down and Up

103 - Advanced Analytics Analyze Feature

104 - Data Insights Through AI Visuals

105 - Creating Animated Scatter Charts

106 - Using Visuals to Forecast Values

107 - Creating Custom Analytics Visuals

108 - Conclusion

6 - Professional

109 - Introduction

110 - Sharing Dashboards

111 - Revoking Sharing Privileges

112 - Sharing Reports

113 - Copying Reports to Other Workspaces and Workspace Roles

114 - Creating and Publishing Apps

115 - Managing Wokspaces Recap

116 - Introduction to Managing Datasets

117 - Creating Parameters

118 - Editing Parameters in the Service and Refreshing Datasets and Visuals

119 - Refresh Options

120 - Managing Datasets Recap

121 - Conclusion

7 - Exercise Files

122 - Customer Data.html

122 - Customer-Data.xlsx

123 - Dates.html

123 - Dates.xlsx

124 - Goals.html

124 - Goals.xlsx

125 - Histogram.html

125 - Histogram.xlsx

126 - IT Spend Analysis Sample.html

126 - IT-Spend-Analysis-Sample.xlsx

127 - Sample Superstore.html

127 - Sample-Superstore.xlsx

128 - Power BI.html

128 - Power-BI.pptx

129 - Retail Analysis Sample.html

129 - retail-analysis-sample.zip

130 - Northwindaccdb.html

130 - northwind.zip

131 - Website Links for More Info.html

131 - Website-Links-for-More-Information.docx

139,000 تومان

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

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

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

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