Microsoft Power BI Tutorial 2024 - Beginners / Professional

Focused View

Ahmed Hamood

8:18:14

112 View

1 - Beginner

1 - Introduction.mp4

05:15

2 - Data Analytics and licensing options.mp4

04:51

3 - Products and Services.mp4

02:09

4 - Getting Data from Multiple Resources.mp4

05:36

5 - Savings.mp4

02:33

6 - Touring View.mp4

09:32

7 - Starting New Instances of Power BI Desktop.mp4

01:43

8 - Splash Screen.mp4

03:20

9 - Getting Data from Access Database.mp4

07:10

10 - Table Relationships and Settings.mp4

04:28

11 - Web URL.mp4

09:55

12 - Excel Files and Pivot Data Model.mp4

09:51

13 - Resolving Data Errors.mp4

12:26

14 - Implications of Locally Stored Vs Cloud Based Excel Files.mp4

16:07

15 - Conclusion.mp4

00:49

2 - Intermediate

16 - Data Shaping.mp4

13:50

17 - Enhancing Data Structure.mp4

07:26

18 - Data Profiling Recap.mp4

04:46

19 - Introduction to a Data Model.mp4

01:06

20 - Working With Tables.mp4

05:54

21 - Fact Vs Dimension.mp4

01:26

22 - Breaking Down Tables.mp4

06:39

23 - Creating Hierarchy.mp4

02:16

24 - Relationships AKA Cardinality.mp4

01:53

25 - Creating Relationships.mp4

06:05

26 - Reviewing The Model Interface.mp4

03:44

27 - Creating RLS Roles In Desktop.mp4

04:24

28 - Assigning Users to RLS Roles In Service.mp4

02:38

29 - Conclusion.mp4

00:26

3 - Advanced

30 - Introduction.mp4

00:34

31 - Creating Calculated Tables and DATEDIFF.mp4

08:55

32 - RANKX Lowest.mp4

05:56

33 - RANKX Highest.mp4

03:22

34 - RANKX DENSE.mp4

01:50

35 - Creating Quick Measures.mp4

06:13

36 - Creating Measures.mp4

04:43

37 - Creating Data Tables.mp4

10:21

38 - Time Intelligence Functions.mp4

04:14

39 - Key Performance Indicators.mp4

03:46

40 - Additional Key Performance Indicators.mp4

03:45

41 - DAX Recap.mp4

00:56

42 - Introduction To Optimizing Model Performance.mp4

02:35

43 - Publishing Dataset to Service.mp4

02:32

44 - Using Direct Query on Power BI Dataset.mp4

01:57

45 - Direct Query vs Import File Size Comparison.mp4

03:22

46 - Importance of Variables.mp4

02:02

47 - Building a Measure to Use in A Measure.mp4

01:55

48 - Building a Measure with Variables and Comments.mp4

07:52

49 - Adding Measures to MultiRow Card.mp4

02:54

50 - Other Optimization Techniques.mp4

01:29

51 - Conclusion.mp4

01:13

4 - Expert

52 - Introduction.mp4

02:08

53 - Creating Reports with Pie Charts.mp4

01:55

54 - Adding Tooltips to Reports.mp4

02:20

55 - Formatting Reports with Pie Charts.mp4

04:08

56 - Filtering and Sorting Reports.mp4

07:42

57 - Sync Slicers.mp4

07:01

58 - Creating Drill Through Pages.mp4

03:09

59 - Creating Source Reports with Slicers.mp4

04:13

60 - Using Drill Through.mp4

03:11

61 - Formatting Drill Through Pages.mp4

05:01

62 - Formatting Two Objects at Once.mp4

01:52

63 - Conditional Formatting.mp4

05:02

64 - Bookmarks.mp4

03:25

65 - Accessibility Features.mp4

01:47

66 - Accessibility Alt Text Data Table Focus View.mp4

05:07

67 - Accessibility Tab Order.mp4

02:01

68 - Accessibility Colorblind Friendly.mp4

01:08

69 - Adding the Histogram Visualization.mp4

02:37

70 - Creating Histograms.mp4

07:22

71 - Copy Visual.mp4

02:41

72 - Reports Recap.mp4

00:33

73 - Introduction to Creating Dashboards.mp4

02:25

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

07:35

75 - Introduction to RealTime Dashboards.mp4

02:45

76 - Creating Push Datasets.mp4

04:36

77 - Creating Reports for RealTime Dashboards.mp4

04:20

78 - Creating Forms for Pushing Data.mp4

05:43

79 - Creating Dashboards for Streaming Data.mp4

02:16

80 - Accessing Power Automate.mp4

01:59

81 - Creating a Flow to Push Form Data into Dataset.mp4

06:36

82 - Respond to Survey.mp4

00:57

83 - Viewing RealTime Dashboards.mp4

03:10

84 - Enhancing Dashboards with Custom Themes.mp4

03:09

85 - Enhancing Dashboards with Videos.mp4

02:23

86 - Configuring Dashboard Tile Alerts.mp4

02:44

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

06:32

88 - More Dashboard Features.mp4

05:59

89 - Conclusion.mp4

01:15

5 - Master

90 - Introduction.mp4

02:46

91 - Loading Sample Data and Making Workspace Premium.mp4

04:39

92 - Downloading Report Builder and Creating Paginated Reports.mp4

06:34

93 - Sorting Reports in Design View.mp4

03:23

94 - Adding Report Headers and Making Them Repeat Across Pages.mp4

04:21

95 - Making Column Headers Repeat Across Pages and Publishing Reports.mp4

05:59

96 - Reviewing Paginated Reports Print Preview and Export Options.mp4

05:49

97 - Paginted Reports Recap.mp4

00:52

98 - Introduction to Performing Advanced Analytics.mp4

01:12

99 - Accessing a Sample Desktop File from the Service.mp4

03:40

100 - Advanced Analytics Grouping.mp4

03:30

101 - Advanced Analytics Binning.mp4

04:23

102 - Advanced Analytics Drill Down and Up.mp4

08:56

103 - Advanced Analytics Analyze Feature.mp4

03:44

104 - Data Insights Through AI Visuals.mp4

06:09

105 - Creating Animated Scatter Charts.mp4

03:15

106 - Using Visuals to Forecast Values.mp4

07:34

107 - Creating Custom Analytics Visuals.mp4

06:05

108 - Conclusion.mp4

01:20

6 - Professional

109 - Introduction.mp4

00:42

110 - Sharing Dashboards.mp4

01:40

111 - Revoking Sharing Privileges.mp4

01:35

112 - Sharing Reports.mp4

02:51

113 - Copying Reports to Other Workspaces and Workspace Roles.mp4

03:50

114 - Creating and Publishing Apps.mp4

06:52

115 - Managing Wokspaces Recap.mp4

00:40

116 - Introduction to Managing Datasets.mp4

01:25

117 - Creating Parameters.mp4

00:37

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

05:21

119 - Refresh Options.mp4

04:18

120 - Managing Datasets Recap.mp4

03:31

121 - Conclusion.mp4

01:10

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

Description

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

What You'll Learn?

Discover Business Intelligence tool for crafting impressive reports and dashboards.
Discover effective methods for visualizing data in a profound manner, unveiling unparalleled insights into your business operations.
Delve into the expansive capabilities of Power BI, seamlessly connecting to a diverse array of data sources such as SQL Server, Excel, CSV, JSON, XML, Web
Master the art of employing basic DAX to construct robust calculations and comparisons across multiple data tables.
Explore the depths of advanced DAX measures and calculated columns, delving into intricate calculations and sophisticated analysis techniques.
Acquaint yourself with Dataflows, the latest iteration incorporating CDM base and Azure Lake gen2, comprehending its functionality and database configuration
Utilize a diverse range of visual elements including column, line, pie, combo, scatter, treemap, funnel, gauges, and KPIs to create engaging
Effortlessly clean up disorganized data, customize your data model to fit your requirements, and enhance your reports for a polished and presentation
Become proficient in utilizing text boxes, shapes, images, maps, and various other visual elements
Turn raw data into actionable insights and dynamic visualizations that effectively convey a compelling narrative.
Access advanced functionalities such as Report page tooltips and Bookmarks to elevate the quality and effectiveness of your reports.
Harness the potential of Custom Visualizations and Themes within Power BI.
Enhance your data modeling skills and automate data cleansing processes.
Facilitate collaboration and content sharing on Microsoft's robust platform.
Begin your Dashboard-in-a-day training, customized to suit your schedule and preferences, whether you're working from home or at the office.
Acquire insights into Power BI best practices, and tricks for optimal utilization.
Foundational Concepts of building queries and prepping data for analysis.
Build relationships across multiple databases with Power Pivot

Who is this for?

Business analysts, data analysts, and professionals at every level seeking to advance their expertise in data processing and visualization.

What You Need to Know?

No Experience Needed.

More details

Description
By the end of this Course, I guarantee you that you can mention Power BI in your resume.
Course Sections:
This course is divided into Seven comprehensive sections, each unlocking a new layer of Power BI proficiency:
Section 1:Â Beginner:Â
Section 2: Intermediate:
Section 3: Advanced:
Sections 4: Expert:
Section 5: Master:
Section 6: Professional:
Section 7: Exercise files:

Who it's aimed at: Novice Data Analysts: For those stepping into the realm of data analysis and visualization, this course offers a systematic approach to mastering the fundamental concepts and features of Power BI.
Business Practitioners: Managers, executives, and professionals across diverse industries will uncover strategies for harnessing Power BI to interpret data and inform strategic decision-making processes effectively.
Students and Recent Graduates: Aspiring analysts and recent graduates aiming to bolster their skill set for enhanced career opportunities will find this course indispensable.
Entrepreneurs and Small Business Owners: Discover how to utilize data-driven insights to gain deeper understanding of your market, customers, and operational dynamics for improved business outcomes.
IT Experts: IT professionals seeking to broaden their skill set with robust data analysis capabilities will find Power BI's comprehensive features beneficial.
Inquisitive Individuals: If you possess a curious mind and aspire to explore the realm of data, this course offers a gentle yet practical introduction to kickstart your journey.

What it entails: Power BI stands as Microsoftâ€™s comprehensive business analytics platform, meticulously crafted to handle extensive datasets, and efficiently organize, analyze, and visualize them through dynamic dashboards and interactive reports.

What you'll gain: Throughout this series, participants will delve into fundamental concepts pertaining to constructing queries and preparing data for analysis. They will grasp the art of establishing relationships across various databases using Power Pivot, while also acquiring proficiency in leveraging essential functions to elevate data analysis. Furthermore, they'll become adept at crafting and navigating live dashboards and interactive reports, among other invaluable skills.
Requirements:Â
Power BI Desktop: Make sure you have Microsoft Power BI Desktop installed on your computer. You'll use this tool to create insightful visualizations and analyze data.
Internet Connection: A reliable internet connection is necessary for accessing course content, including video lectures, quizzes, and practice assignments.
Basic Computer Skills: A fundamental understanding of using a computer, navigating software interfaces, and managing files will be beneficial.
Curiosity and Enthusiasm: Bring your eagerness to learn and explore the world of data analytics with Power BI. Curiosity will drive your success in this course.
Microsoft Account: You can use it to login to Power BI service. Also, having a Microsoft account can enhance your experience by allowing you to explore additional resources and connect with a broader community.
Who this course is for:
Business analysts, data analysts, and professionals at every level seeking to advance their expertise in data processing and visualization.

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Ahmed Hamood

Instructor's Courses

Ahmed Hamood, a distinguished Business Intelligence (BI) consultant, is at the forefront of empowering individuals worldwide with the transformative potential of data analytics. With a wealth of experience and expertise, Ahmed has carved a remarkable career path dedicated to unraveling the mysteries of data and guiding others towards success in the dynamic field of BI.Ahmed's journey into the realm of data analysis began with a passion for problem-solving and a keen interest in leveraging technology to drive business growth. Armed with a degree in Computer Science from a prestigious university, Ahmed embarked on his professional journey, eager to make a meaningful impact in the world of data.Throughout his career, Ahmed has honed his skills and knowledge through hands-on experience and continuous learning. From his early days as a BI analyst, where he mastered the intricacies of data modeling and visualization, to his current role as a seasoned BI consultant, Ahmed has demonstrated a steadfast commitment to staying abreast of emerging trends and technologies in the ever-evolving field of BI.Ahmed's expertise extends across a diverse range of BI tools and platforms, with a specialization in Microsoft Power BI. Renowned for his ability to translate complex data into actionable insights, Ahmed has earned accolades for his role in helping organizations harness the power of data to drive strategic decision-making and achieve tangible results.In addition to his professional endeavors, Ahmed is deeply passionate about sharing his knowledge and expertise with others. Recognizing the need for accessible and practical training in BI, Ahmed has dedicated himself to creating comprehensive online courses that cater to learners of all backgrounds and skill levels. Through his engaging teaching style and real-world examples, Ahmed strives to demystify the complexities of BI and empower his students to unlock their full potential in the field.Ahmed's impact extends far beyond the confines of the classroom. He is actively involved in mentoring aspiring BI professionals and contributing to online communities dedicated to data analytics. His commitment to fostering a culture of learning and collaboration has earned him the respect and admiration of colleagues and students alike.As a BI consultant, educator, and advocate for data-driven decision-making, Ahmed Hamood continues to inspire and empower individuals around the globe to harness the power of data for innovation and growth. With a steadfast dedication to excellence and a passion for making a difference, Ahmed is poised to shape the future of BI and leave a lasting legacy in the world of data analytics.

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.