Power BI Training

Analyzing Data with Power BI training imparts skills and knowledge to analyze, visualize and report data using Microsoft Power BI. Power BI is a suite of tools for Business Analytics that allows corporate users to analyze data and get insights that can help in making right business decisions. This Power BI training covers the latest tools to monitor business growth and quickly get answers on any device through rich reporting features and dashboards. Learn how to connect and import your data, author reports, publish reports, create dashboards, and share with business users so that they utilize the business intelligence gathered in dashboards through the web as well as mobile devices. This Power BI training is best suited for Business Intelligence professionals who are required to generate reports and analyze data using Microsoft Power BI.

Dates

August 3rd & 4th (Saturday & Sunday)

August 10th & 11th (Saturday & Sunday)

Time

9.30AM – 4PM

Venue: BeCloud Technologies, Lower Ground Floor, Gold Souk Grande, Vyttila 682019

Contact Persons

Megha: 9544303399

Ahamed: 9746099966

TRAINER PROFILE

• 14 Years of Extensive experience in Business Intelligence Platform , Consulting and Training

• Presently working as a corporate trainer and Consultant at BeCloud Technologies.

• Delivered trainings on Oracle Data Integrator 11g / 12c, OBIEE , OBIA with ODI,Tableau , Informatica and Microsoft Power BI for client in India, Middle East region , APAC , West Indies , Trinidad and Tobago , US Client(Online).

• Successfully Trained more than thousands of Corporate on various Business Intelligence technologies.

SYLLABUS

1) Introduction

• Introduction to business intelligence

• Introduction to data analysis

• Introduction to data visualization

• Overview of self-service BI

• Considerations of self-service BI

• Microsoft tools for self-service BI

• Configure tools

2) Power BI Data

• Using Excel as a Power BI data source

• Using databases as a Power BI data source

• The Power BI service

• Lab : Import data into Power BI

• Transforming Data

3) Power BI Model

• Creating Relationships

• Defining New Columns

• Concatenating Columns

• Performing Lookup

• Translating

• Adding Date Table

4) Enhancing Power BI Model

• Defining Hierarchies

• Configuring Properties e.g. Data Categories , Formatting

• Creating Measures

5) Enhancing Model using PowerPivot

• Defining Hierarchies

• Configuring Properties e.g. Data Categories , Formatting

• Creating Measures

6) Visualizing

• Visualizing Data

• Adding Visuals

• Filtering

• Slicer Filtering

• Highlighting

• Setting Properties

• Drilling within the Hierarchy

• Creating Dashboards

• Power BI Mobile

7) Refreshing Data Overview

• Publishing DataSets

• Refreshing Data

• Using Power BI Gateway - Personal

• Understanding Power BI Gateway – Enterprise

• Publishing To Power BI

• Setting Up Auto-Refresh

• Securing Data

8) Introducing DAX (Data Analysis Expressions)

• Understanding Dax Calculations

• Understanding Calculated Columns And Measures

• Variables

• Handling Errors In Dax Expressions

• Formatting Dax Code

• Common Dax Functions

9) Using Basic Table Functions

• Introducing Table Functions

• Evaluate Syntax

• Using Table Expressions

• Understanding Filter

• Understanding All, Allexcept, And Allnoblankrow

• UNDERSTANDING VALUES AND DISTINCT

10) Understanding Evaluation Contexts

• Introduction To Evaluation Contexts

• Testing Your Evaluation Context Understanding

• Creating A Row Context With Iterators

• Understanding Filter, All, And Context Interactions

• Working With Many Tables

• Evaluation Contexts Recap

• Creating A Parameter Table

11) Understanding CALCULATE And CALCULATETABLE

• Understanding Calculate

• Calculate Examples

• Understanding Context Transition

• Variables And Evaluation Contexts

• Understanding Circular Dependencies

• Calculate Rules

• Introducing All selected

• Understanding Use relationship

12) DAX Examples

• Computing Ratios And Percentages

• Computing Cumulative Totals

• Computing Sales Per Day And Working Day

• Computing Differences In Working Days

• Computing Static Moving Averages