This course is designed for those interested in learning about power BI essentials.
Read more.Instructor
Grant Gamble is an IT trainer, consultant and author specializing in Microsoft Power BI, VBA, web development and Adobe software automation.
Only want this course? Buy this course for $199 $29 and keep lifetime access.
Click here
About This Course
Who this course is for:
- This course is suitable for anyone who needs to become familiar with Microsoft’s Power BI product, whether for work, study or career
What you’ll learn:Â
- How to use Power BI Desktop to import and model data and create reports.
- How to use the Power BI service for the creation of dashboards, collaboration and sharing of content.
Requirements:Â
- Ability to use a PC and familiarity with general computing concepts and techniques, such as copying and pasting.
Organizations rely on business intelligence to make better business decisions. Traditionally, BI always referred to Enterprise Business Intelligence. Enterprise BI was always a big deal! Enterprise BI software tools were extremely expensive, technically challenging, and designed for IT specialists.And enterprise BI projects took forever!
Microsoft Power BI offers users true Self-Service BI. Power BI enables business users to interact with corporate information and to extract the reports and intel they need. Power BI allows users to access reports and dashboards using familiar tools and devices.
Self-service BI has never been so user-friendly! Microsoft Power BI Introduction will show you how to create compelling visualizations and reports which provide deep insights into your data.
By the end of the course, you will be confident in using the three main components of Power BI:
- Power BI Desktop
- Power BI Service
- Power BI Mobile Apps.
You will know how to connect to a wide variety of data sources, using both Power BI Desktop, and the Power BI Service. You will be able to use the Query Editor to transform and morph data into the right format for your reporting purposes. You will be able to perform complex data modelling operations using relationships, calculated columns, measures, and DAX expressions. You will learn how to share dashboards and reports, with colleagues, business partners and potential clients. And how to use Power BI’s sophisticated security features to control the exact content your audience is able to view.
In short, this Microsoft Power BI Introduction will equip you with all the skills you need, to start using Power BI with confidence.
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 RatingsRelated Courses
This helped me in supporting my Power BI colleagues
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.
Power BI Basics
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.
Great Overview
Great overview of Power BI and good pointers on best practices
Fabulous Course
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!!!
Power BI
Gives a good foundation of Power BI functions and uses.