Please ensure Javascript is enabled for purposes of website accessibility
Power BI Essentials: An Introduction To Microsoft Power BI

Master data sourcing in Power BI Desktop & Service! Elevate your skills with our Microsoft Power BI Tutorial. Unlock Power BI Essentials now! Read more.

5.0( 5 REVIEWS )
3964 STUDENTS
7h 4m
Students
3964
Course Skill Level
Beginner
Time Estimate
7h 4m

Grant Gamble is an IT trainer, consultant and author specializing in Microsoft Power BI, VBA, web development and Adobe software automation.

About This Course

Who this course is for:

  • This course caters to individuals seeking proficiency in Microsoft’s Power BI product, be it for professional, academic, or career advancement purposes.

What you’ll learn: 

  • Discover how to effectively harness the capabilities of Power BI Desktop to seamlessly import, model data, and craft insightful reports.
  • Dive into the world of the Power BI service, mastering the art of creating dynamic dashboards, fostering collaboration, and effortlessly sharing content.

Requirements: 

  •  A basic understanding of PC operation and a grasp of fundamental computing concepts, including tasks like copying and pasting.

Course Overview: In today’s data-driven world, organizations rely on business intelligence to steer their decision-making processes. Traditionally, Business Intelligence (BI) was synonymous with Enterprise Business Intelligence, an arena reserved for large budgets, intricate technical know-how, and protracted project timelines.

However, Microsoft Power BI revolutionizes this landscape by ushering in true Self-Service BI. With Power BI, business users gain the power to interact with corporate data, extract invaluable insights, and create reports without being tethered to IT specialists. It empowers users to access reports and dashboards through familiar tools and devices.

Self-service BI has never been more user-friendly, and our Microsoft Power BI Introduction course is your gateway to harnessing its full potential. You’ll learn how to craft compelling visualizations and reports that delve deep into your data.

By the course’s end, you’ll possess confidence in navigating the three core components of Power BI:

  1. Power BI Desktop: Unlock the ability to connect to a diverse array of data sources, utilizing both Power BI Desktop and the Power BI Service.
  2. Power BI Service: Master the Query Editor to seamlessly transform and manipulate data into the ideal format for your reporting objectives.
  3. Power BI Mobile Apps: Gain proficiency in performing intricate data modeling operations, including managing relationships, crafting calculated columns, implementing measures, and employing DAX expressions.

Furthermore, you’ll discover how to share your dashboards and reports with colleagues, business partners, and prospective clients. You’ll wield Power BI’s advanced security features to precisely control the content your audience can access.

In essence, the Microsoft Power BI Introduction course equips you with the comprehensive skill set necessary to confidently navigate the world of Power BI. Join us on this enlightening journey, and unlock the potential to transform data into actionable insights.

Our Promise to You
By the end of this course, you will have a clear understanding on Power BI essentials.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about Power BI essentials!

Course Curriculum

Section 1 - Welcome
Welcome To Microsoft Power BI Introduction 00:00:00
Downloading The Course Files 00:00:00
Section 2 - Getting Started
Power BI Editions 00:00:00
The Three Key Elements Of Power BI 00:00:00
Understanding Dashboards, Reports And Datasets 00:00:00
Exploring The Power BI Desktop Interface 00:00:00
Exploring The Power BI Service Interface 00:00:00
Editing A PBIX File In The Power BI Service 00:00:00
Creating a PBIX file in the Power BI service 00:00:00
Connecting to GitHub in the Power BI Service 00:00:00
Connecting to Google Analytics (Service and Desktop compared) 00:00:00
Updating Power BI Desktop 00:00:00
Section 3 - Connecting To Data Sources
Connecting To CSV Files 00:00:00
Connecting To Excel Data 00:00:00
Connecting To A Folder Of Data 00:00:00
Connecting To A Web URL 00:00:00
Connecting To Web Page Content 00:00:00
Connecting To A Microsoft Access Database 00:00:00
Section 4 - Cleaning Up And Transforming Data
Trim, Clean And Case 00:00:00
Renaming And Adding Metadata 00:00:00
Splitting Columns 00:00:00
Removing Rows 00:00:00
Replace Values 00:00:00
Unpivot Columns 00:00:00
Rearranging Columns 00:00:00
Creating Custom Columns 00:00:00
Append Queries 00:00:00
Merge Queries 00:00:00
Grouping Data 00:00:00
Section 5 - Data Modelling
Adding Data To The Data Model 00:00:00
Examining The Data Model 00:00:00
Creating Relationships Automatically 00:00:00
Creating Relationships Manually 00:00:00
Creating A Composite Primary Key 00:00:00
Creating A Date Table 00:00:00
Creating Calculated Columns 00:00:00
Creating Measures 00:00:00
Using The SUMX Function 00:00:00
Using Related And Relatedtable 00:00:00
Creating A Calculated Table 00:00:00
Section 6 - Creating A Power BI Report
Overview Of Report 00:00:00
Backgrounds, Logos And Images 00:00:00
Working With Themes 00:00:00
The Card Big-Picture Visual 00:00:00
Using Visual Filters 00:00:00
Using The Format Painter 00:00:00
Gauges And Targets 00:00:00
Creating Bar Charts 00:00:00
Editing Visual Interactions 00:00:00
Using Slicers 00:00:00
Using The Treemap Visual 00:00:00
Creating A Map Visual 00:00:00
Date Hierarchies And Drill-Down 00:00:00
Using Time Intelligence Functions 00:00:00
Section 7 - Sharing And Collaborating
Creating Users In The Power BI Service 00:00:00
Creating Groups For Collaboration 00:00:00
Creating Groups For Distribution 00:00:00
Dashboards And Q&A 00:00:00
Sharing Dashboards With Your Organization 00:00:00
Creating Content Packs 00:00:00
Publishing Reports To The Web 00:00:00
Row Level Security 00:00:00

About This Course

Who this course is for:

  • This course caters to individuals seeking proficiency in Microsoft’s Power BI product, be it for professional, academic, or career advancement purposes.

What you’ll learn: 

  • Discover how to effectively harness the capabilities of Power BI Desktop to seamlessly import, model data, and craft insightful reports.
  • Dive into the world of the Power BI service, mastering the art of creating dynamic dashboards, fostering collaboration, and effortlessly sharing content.

Requirements: 

  •  A basic understanding of PC operation and a grasp of fundamental computing concepts, including tasks like copying and pasting.

Course Overview: In today’s data-driven world, organizations rely on business intelligence to steer their decision-making processes. Traditionally, Business Intelligence (BI) was synonymous with Enterprise Business Intelligence, an arena reserved for large budgets, intricate technical know-how, and protracted project timelines.

However, Microsoft Power BI revolutionizes this landscape by ushering in true Self-Service BI. With Power BI, business users gain the power to interact with corporate data, extract invaluable insights, and create reports without being tethered to IT specialists. It empowers users to access reports and dashboards through familiar tools and devices.

Self-service BI has never been more user-friendly, and our Microsoft Power BI Introduction course is your gateway to harnessing its full potential. You’ll learn how to craft compelling visualizations and reports that delve deep into your data.

By the course’s end, you’ll possess confidence in navigating the three core components of Power BI:

  1. Power BI Desktop: Unlock the ability to connect to a diverse array of data sources, utilizing both Power BI Desktop and the Power BI Service.
  2. Power BI Service: Master the Query Editor to seamlessly transform and manipulate data into the ideal format for your reporting objectives.
  3. Power BI Mobile Apps: Gain proficiency in performing intricate data modeling operations, including managing relationships, crafting calculated columns, implementing measures, and employing DAX expressions.

Furthermore, you’ll discover how to share your dashboards and reports with colleagues, business partners, and prospective clients. You’ll wield Power BI’s advanced security features to precisely control the content your audience can access.

In essence, the Microsoft Power BI Introduction course equips you with the comprehensive skill set necessary to confidently navigate the world of Power BI. Join us on this enlightening journey, and unlock the potential to transform data into actionable insights.

Our Promise to You
By the end of this course, you will have a clear understanding on Power BI essentials.

10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about Power BI essentials!

Course Curriculum

Section 1 - Welcome
Welcome To Microsoft Power BI Introduction 00:00:00
Downloading The Course Files 00:00:00
Section 2 - Getting Started
Power BI Editions 00:00:00
The Three Key Elements Of Power BI 00:00:00
Understanding Dashboards, Reports And Datasets 00:00:00
Exploring The Power BI Desktop Interface 00:00:00
Exploring The Power BI Service Interface 00:00:00
Editing A PBIX File In The Power BI Service 00:00:00
Creating a PBIX file in the Power BI service 00:00:00
Connecting to GitHub in the Power BI Service 00:00:00
Connecting to Google Analytics (Service and Desktop compared) 00:00:00
Updating Power BI Desktop 00:00:00
Section 3 - Connecting To Data Sources
Connecting To CSV Files 00:00:00
Connecting To Excel Data 00:00:00
Connecting To A Folder Of Data 00:00:00
Connecting To A Web URL 00:00:00
Connecting To Web Page Content 00:00:00
Connecting To A Microsoft Access Database 00:00:00
Section 4 - Cleaning Up And Transforming Data
Trim, Clean And Case 00:00:00
Renaming And Adding Metadata 00:00:00
Splitting Columns 00:00:00
Removing Rows 00:00:00
Replace Values 00:00:00
Unpivot Columns 00:00:00
Rearranging Columns 00:00:00
Creating Custom Columns 00:00:00
Append Queries 00:00:00
Merge Queries 00:00:00
Grouping Data 00:00:00
Section 5 - Data Modelling
Adding Data To The Data Model 00:00:00
Examining The Data Model 00:00:00
Creating Relationships Automatically 00:00:00
Creating Relationships Manually 00:00:00
Creating A Composite Primary Key 00:00:00
Creating A Date Table 00:00:00
Creating Calculated Columns 00:00:00
Creating Measures 00:00:00
Using The SUMX Function 00:00:00
Using Related And Relatedtable 00:00:00
Creating A Calculated Table 00:00:00
Section 6 - Creating A Power BI Report
Overview Of Report 00:00:00
Backgrounds, Logos And Images 00:00:00
Working With Themes 00:00:00
The Card Big-Picture Visual 00:00:00
Using Visual Filters 00:00:00
Using The Format Painter 00:00:00
Gauges And Targets 00:00:00
Creating Bar Charts 00:00:00
Editing Visual Interactions 00:00:00
Using Slicers 00:00:00
Using The Treemap Visual 00:00:00
Creating A Map Visual 00:00:00
Date Hierarchies And Drill-Down 00:00:00
Using Time Intelligence Functions 00:00:00
Section 7 - Sharing And Collaborating
Creating Users In The Power BI Service 00:00:00
Creating Groups For Collaboration 00:00:00
Creating Groups For Distribution 00:00:00
Dashboards And Q&A 00:00:00
Sharing Dashboards With Your Organization 00:00:00
Creating Content Packs 00:00:00
Publishing Reports To The Web 00:00:00
Row Level Security 00:00:00

Course Review

5.0

5.0
5 Ratings
  1. Anonymous

    This helped me in supporting my Power BI colleagues

    5.0

    I work in the IT department. Our Power BI group had a leadership change. They needed help to understand how Power BI was used in our environment. I became the go-to guy for them. This course gave me the basic structural background to be able to carry on a conversation with that team and begin to know what they were talking about and how I could be of service.

    Recommended.

  2. Anonymous

    Power BI Basics

    5.0

    I enjoyed POWER BI ESSENTIALS: AN INTRODUCTION TO MICROSOFT POWER BI. The course is designed well, covering all of the topics in a much better, more intuitive and progressive learning order than another beginner course on SS, where so much time was spent on transforming data. Grant is a great communicator – very good pace and thoughtful and deliberate in language in highlighting important points. I took each section slowly and did my own examples in Power BI while also following along with his. It was great to be able to stop and replay – as again – the instructions are solid. The course is over 3 years old so some of the current features of Power BI are different from the training. Most of them were not drastically different, requiring small guesses to understand the nuanced differences. Only the security part for assigning roles, etc. was more significantly different, so I will use another newer source to learn that. Essentially, security is now all done through Workspaces directly.

  3. Anonymous

    Great Overview

    5.0

    Great overview of Power BI and good pointers on best practices

  4. Anonymous

    Fabulous Course

    5.0

    I have been working my way through various Power BI tutorials on various websites as I try to gain knowledge and skills in the product. I even took a couple of 1-day classroom courses directly from Microsoft. Had I seen this course sooner, I could have been much more productive much sooner! It is very well organized and expertly covers all the essential skills needed to create and effectively share business intelligence information. My only criticism is that in 2019 the course is 2 years old and, thus, does not cover any features added in the interim (and there are a LOT!). Even so, I highly recommend this course to anyone who wants to efficiently work through the magic of Power BI!!!

  5. Anonymous

    Power BI

    5.0

    Gives a good foundation of Power BI functions and uses.

4764597

Join our newsletter and get your first course free!

4764598

Join our newsletter and get your first course free!

Congratulations! You get one free course of your choice. Please check your email now for the redemption code

Are you interested in higher education?