Microsoft Power BI: Latest 2020 Beginner to Expert Modules

Transform, analyze & visualize data with Microsoft Power BI Desktop: hands-on demos, projects & 1-on-1 Power BI support

Rating: 3.8 out of 5

3.8   (910 ratings)

63,353 students

Created by : William McGuffey Academy

Last updated 8/2020

English : English [Auto]

What you'll learn

1. Understand the business intelligence workflow from end-to-end
2. Blend and transform raw data into beautiful interactive dashboards
3. Connect Microsoft Power BI to data sources
4. Create Barcharts, Treemaps, Donut Charts, Waterfall Diagrams & Piecharts
5. Showcase your skills with three full-scale course projects (with step-by-step solutions)
6. At the end of this course students will be able to analyse data from different data sources and create their own datasets

This course includes:

3.5 hours on-demand video

1 article

Full lifetime access

Access on mobile and TV

Certificate of completion

Enroll now

        

Description

In this course we are going to show you how to SUPERCHARGE your Power BI skills, and learn to create INTERACTIVE Dashboards and INCREDIBLE reports.

Using the Table and Matrix visualizations for cross-filtering and drill-downs

Creating Drill through between different sheets. For example you could be reviewing a list of Products and want to select one Product to view a summary of this product

Themes - Learn how to add Power BI Themes from the Community Theme Gallery

Changes in Custom Visuals - We look at how to easily add Custom Visualizations from the new Microsoft Office Store

Creating Apps - Learn how to easily share your dashboards and reports using Power BI apps and App workspaces

Relative Date Filters - In this lesson we show how to easily create a dashboard displaying Microsoft stock data. Easily filter your data to display the last 7 days, last 14 days, last month or previous 3 months using relative date filters

Drill Through - Create drill throughs between different pages in a report

Ribbon Chart - Learn to use the new Ribbon Chart to visualize the ranking of items across dates ranges or other categories.

Microsoft Power BI is the easiest to use reporting, data analysis and interactive dashboard tool available today! Microsoft Power BI is available for free - all you need to do is sign up!

There is no coding required! Power BI allows you to do that but it's not necessary.

In this guided learning course you will start form zero to hero in 6 hours and you will learn:

the ETL capabilities of Microsoft Power BI ("get messy data easily into the right format")

Master simple and very advanced DAX (Power BI language, similar to like excel formulas) calculations

Create outstanding visualizations and reports

Derive valuable highly profitable insights

In this course I will teach you how to easily turn your data into powerful intelligence and insight to drive your business decisions. Power BI uses simple drag and drop techniques that make it a breeze to create reports and dashboard. I will also show you how easy it is to publish your dashboards and to access them through your smartphone, tablet or laptop.

This course is for anybody who works with data and wants to learn how to quickly and easily get to speed with the cloud version of Power BI or learn the more powerful Power BI Desktop Designer.

The course has the following topics:

Introduction to Power BI and how to signup

How to create your first online report and dashboard

How to download the Power BI Desktop Designer

Loading, transforming and filtering data in Power BI

Creating tables and reports

Using filters and slicers

Learning how to use a wide range of graphs and visualizations

Creating relationships between tables of data

Creating powerful calculations, key metrics, and key performance indicators

Creating interactive dashboards

Publishing dashboards to Power BI

Who this course is for:

• Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
• Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
• Anyone looking to pursue a career in data analysis or business intelligence
• Learners who want to prepare themselves for Microsoft Exam 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI

Course content

24 sections • 81 lectures • 3h 23m total length

Instructor : William McGuffey Academy

4.0 Instructor Rating

6,880 Reviews

346,196 Students

21 Courses