Power BI Essentials: An Introduction to Microsoft Power BI

5/5 (2 ratings)
See all reviews

This course is designed for those interested in learning about power BI essentials.

Watch Free For 30 Days

start free access

-or-

buy single class $199
  • On Demand Video Lessons
  • Course Certificate
  • 24/7 Support

About This CourseBeginner

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.

What am I going to get from this course?

  • 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.

Who is the target audience?

  • This course is suitable for anyone who needs to become familiar with Microsoft’s Power BI product, whether for work, study or career.

What are the requirements?

  • Ability to use a PC and familiarity with general computing concepts and techniques, such as copying and pasting.

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

30 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

Course Sections

Welcome To Microsoft Power BI Introduction

Downloading The Course Files

Power BI Editions

The Three Key Elements Of Power BI

Understanding Dashboards, Reports And Datasets

Exploring The Power BI Desktop Interface

Exploring The Power BI Service Interface

Editing A PBIX File In The Power BI Service

Creating a PBIX file in the Power BI service

Connecting to GitHub in the Power BI Service

Connecting to Google Analytics (Service and Desktop compared)

Updating Power BI Desktop

Connecting To CSV Files

Connecting To Excel Data

Connecting To A Folder Of Data

Connecting To A Web URL

Connecting To Web Page Content

Connecting To A Microsoft Access Database

Trim, Clean And Case

Renaming And Adding Metadata

Splitting Columns

Removing Rows

Replace Values

Unpivot Columns

Rearranging Columns

Creating Custom Columns

Append Queries

Merge Queries

Grouping Data

Adding Data To The Data Model

Examining The Data Model

Creating Relationships Automatically

Creating Relationships Manually

Creating A Composite Primary Key

Creating A Date Table

Creating Calculated Columns

Creating Measures

Using The SUMX Function

Using Related And Relatedtable

Creating A Calculated Table

Overview Of Report

Backgrounds, Logos And Images

Working With Themes

The Card Big-Picture Visual

Using Visual Filters

Using The Format Painter

Gauges And Targets

Creating Bar Charts

Editing Visual Interactions

Using Slicers

Using The Treemap Visual

Creating A Map Visual

Date Hierarchies And Drill-Down

Using Time Intelligence Functions

Creating Users In The Power BI Service

Creating Groups For Collaboration

Creating Groups For Distribution

Dashboards And Q&A

Sharing Dashboards With Your Organization

Creating Content Packs

Publishing Reports To The Web

Row Level Security

Reviews

5
2 student reviews
  1. Terry says:

    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!!!

  2. George Cascio says:

    Power BI
    Gives a good foundation of Power BI functions and uses.