Advertisements   
   

Power BI Intermediate Course – Beyond the Basics

Advertisements   
   

Requirements

  • A basic understanding of Power BI and its interface is essential as this is an intermediate course
  • Power BI Desktop installed on your machine is required to take the practice exercises
  • A good knowledge of MS Excel is advised but not necessary
  • It is recommended to go through the Power BI Beginner course first, but is not required

Description

**This course includes downloadable course instructor files to follow along.**

Power BI is a powerful Business Analytics service from Microsoft. It intends to provide interactive visualizations and business intelligence solutions. Power BI has a simple enough interface for users with limited technical skills to be able to create their own reports and dashboards.

Advertisements   
   

This Power BI training course starts by going over some of the Power BI basics before launching into how to utilize Power BI to visually display data. This course is focused more on some of the intermediate skills in Power BI, however, we are sure to cover off the basics before we launch into the more complex areas of this amazing Business Intelligence tool.

We start off this course by going through the data files to be used and some Power BI Desktop settings to set you up for success in learning Power BI. The latter part of the course is a big exercise where you can have a lot of practice creating reports and dashboards.

This course includes course files to follow along with your instructor and uses the Power BI Desktop version.

In this course you will learn:

  • How to Import and Transform Data in Power Query
  • Importing Excel, Text, and CSV files and combining files
  • How to enable/disable Load and Report Refresh
  • Resolving Data Import Errors
  • Data Modelling, Relationship Types, and Troubleshooting Relationship Issues
  • Measures vs Calculated Columns
  • Creating a Date Table with DAX
  • Creating Additional and Conditional Columns
  • How to use ROUNDUP and SUMX
  • Creating Quick Measures and a Key Measures Table
  • The CALCULATE Function in DAX
  • Tables vs Matrix Tables
  • Formatting Visualizations and applying Conditional Formatting
  • Using Column, Line, and Map Charts
  • Gauge and Card Visualizations
  • Using Slicers and Filter and applying Design Elements
  • Creating a Shared Workspace in Power BI Service
  • Creating Reports and Dashboards
  • Pinning Visualizations to the Dashboard
  • How to set up Scheduled Refreshes

This course includes:

  1. 6+ hours of video tutorials
  2. 68 individual video lectures
  3. Course Instructor Files to follow along
  4. Certificate of completion

Who this course is for:

  • Advanced Excel users
  • Users with basic knowledge of Power BI Desktop
  • Business Intelligence Analysts

What you’ll learn

  • How to Import and Transform Data in Power Query
  • Importing Excel, Text, and CSV files and combining files
  • How to enable/disable Load and Report Refresh
  • Resolving Data Import Errors
  • Data Modelling, Relationship Types, and Troubleshooting Relationship Issues
  • Measures vs Calculated Columns
  • Creating a Date Table with DAX
  • Creating Additional and Conditional Columns
  • How to use ROUNDUP and SUMX
  • Creating Quick Measures and a Key Measures Table
  • The CALCULATE Function in DAX
  • Tables vs Matrix Tables
  • Formatting Visualizations and applying Conditional Formatting
  • Using Column, Line, and Map Charts
  • Gauge and Card Visualizations
  • Using Slicers and Filter and applying Design Elements
  • Creating a Shared Workspace in Power BI Service
  • Creating Reports and Dashboards
  • Pinning Visualizations to the Dashboard
  • How to set up Scheduled Refreshes

 

Power BI Intermediate Course – Beyond the Basics, Free Tutorials Download

Download Power BI Intermediate Course – Beyond the Basics Free Links

Password : freetutsdownload.net

Author: Ho Quang Dai

I am Ho Quang Dai, from Vietnam – A country that loves peace. I share completely free courses from major academic websites around the world. Hope to bring free knowledge to everyone who can’t afford to buy


Related Courses

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments

Report Link Die

Please provide the most detailed information, we will re-upload as soon as possible