Reports and Dashboards with Microsoft Power BI

  • Duration – 15 hour

 

In this course we are going to teach you the following:

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

ALL POWERBI COURSES BUNDLE

$40

Powerful Reports and Dashboards with Microsoft Power BI

Introduction

 

 Introduction to PowerBI

 

 Download the Training Data Files and Learner Guide

 

 Practical Activity

 

 Signing up for PowerBI

 

The Power BI Desktop Designer

 

 Download the Power BI Desktop Designer

 

Creating Reports in Power BI Desktop

 

 Introduction to Reports in Power BI

 

 Tables and Metrics Practical Activity (Challenge )

 

 Answers to Tables and Metrics Practical Activity

 

 Table Styles, Formatting and Conditional Formatting

 

 Changing the Method of Aggregation

 

 Challenge

 

 Challenge  Completed

 

 Tables and Cards

 

 Challenge

 

 The Quick Calc Option

 

 Filtering Data – Using Slicers

 

 Filtering Data – Visual Filters

 

 Filtering Data – Page Filters

 

 Challenge

 

 Challenge  Completed

 

 New Feature – New Tables and Matrix Visualizations

 

 New Feature – DrillThrough Filter

 

 New Feature – Quick Measures

 

Graphs and Visualizations

 

 Column Graphs

 

 Stacked and % Graphs

 

 Challenge

 

 Graph Options

 

 Trend Analysis Graphs

 

 Additional Graphs

 

 Scatterplots

 

 Bubbleplots

 

 New Feature – Ribbon Chart

 

Interactive Dashboards

 

 Creating Interactive Dashboards

 

 Publishing Dashboards

 

 Pinning and Q & A

 

 Sharing Dashboards

 

 Power BI on Mobile

 

 New Feature – Themes

 

 New Feature – Change in Custom Visuals

 

 New Feature – Creating Power BI Apps

 

 New Feature – Relative Filters

 

DAX Formulas

 

 DAX Formulas

 

 Time Intelligence

 

 Formatting Dates

 

 Date Master Tables

 

DAX Measures

 

 Introduction to DAX Measures

 

 The Calculate Formula

 

Relationships

 

 Creating and Managing Relationships in Power BI

 

 Using Custom Visualizations in Power BI

 

 Using the Related Formula

 

Enhancing Power BI

 

 Transforming Data with Power BI

 

 Aggregating Data

 

Analyze Data with Excel

 

 Introduction to Analyze Power BI Data with Excel

 

 Creating Measures for Excel Analysis

 

 Additional Measures for Excel

 

 Conclusion

 

300+ Courses

After your course completion, we provide course completion certificate as well.

Lifetime Access

All courses are for lifetime access.

l

Priority Support

All queries are answered 24/7.

What People Are Saying

Abhilash -

A very good match. i am enjoying every bit.

Sonal-

Experience was quite good and it was very useful and well elaborated course.

Karan-

I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-

I find that the explanation is good and also understandable.

Seyed-

Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-

I really like this course, it was a good match for me :))

Mahesh-

Standard process and hands on covered nicely.

 

Emily-

Perfect, with complete hands on. Well structured and nicely covered.

Kevin-

Great Content, nice and up to the mark course.

Mayuresh-

 

Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-

A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-

 

Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-

This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -

A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-

Yes lessons are very good. Not so fast, well explained

Kishore-

Worth course for the beginner to invest their time to learn this demanding skills.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us