Reports and Dashboards with Microsoft Power BI

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.

lIFETIME ACCESS

INR 999

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

 

More than 20000 students on Udemy

  • 4.1 Instructor Rating
  • Best Seller Course
  • Highest Rated Course
  • Courses used by udemy for business clients.

210K students on our platform

  • Unlimited access to all courses.
  • Top Courses for every trending technologies.
  • 4.5 Average ratings for all the courses.
  • Certificate Internationally accepted.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us