UrbanPro
Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

true
true

Power BI Training

No Reviews Yet

M G Road 1, Bangalore

Course ID: 342428

M G Road 1, Bangalore

Students Interested 0 (Seats Left 0)

₹ 28,500

No Reviews Yet

About the Course

POWER BI COURSE OUTLINE

 

Power BI Desktop:

1)    Introduction (2 hr)

  • 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
  • Power BI vs. SSRS Report
  • Installation – Power BI Desktop
  • Configure tools

 

2)    Getting and Shaping Data (3 hr)

·         Using databases as a Power BI data source

a)    SQL Server Database

b)    Microsoft Access Database

  • Using Excel as a Power BI data source

·         Using databases as a Power BI data source

·         The Power BI service

  • Import data into Power BI
  • Data Clean up
  • Transforming Data
  • Append Operation
  • Merge Operations

·         Lab :

a)    Import data into Power BI

b)    Data Clean up

c)    Transforming Data

d)    Append Operation

e)    Merge Operations

 

3)    M Language: (2hr)

The Power Query M formula language is optimized for building highly flexible data mashup queries. It's a functional, case sensitive language similar to F#.
Power Query statements are made up of individual language elements such as functions, variables, expressions, and primitive and structured values that together define the logic necessary to shape the data. In this module, we will share

·         Quick tour of the Power Query M formula language

·         Commonly used functions

a)    let expression

b)    RemoveColumns function

c)    PromoteHeaders function

d)    RenameColumns function

e)    SelectRows Function

f)     ReplaceValue function

g)    TransformColumns function

h)    Adding a Calculated column

 

4)    Power BI Model (3 hr)

·         Creating Relationships

a)    Append

b)    Merge

·         Joins

a)    Left, Inner, Join, Full Outer Join, Left Anti Joins, Right Anti Join

·         Extracting Columns From XML

·         Setting Datatypes

·         Transforming Columns

·         Splitting Columns

·         Defining New Columns

·         Concatenating Columns

·         Performing Lookup

·         Translating

·         Adding Date Table

·         Lab:

a)    Creating Relationships

b)    Defining New Columns

c)    Concatenating Columns

d)    Performing Lookup

e)    Translating

f)     Adding Date Table

 

5)    Enhancing Power BI Model (3hrs)

·         Defining Hierarchies

·         Configuring Properties e.g. Data Categories , Formatting

·         Creating Measures

·         Creating Parameters

·         Import from Reports

·         Lab

a)    Creating Measures

b)    Creating Parameters

c)    Import from Reports

 

6)    Data Flows (1 hr)

·         What is Data Flow

·         Why /When to use Data Flow?

·         Lab:

a)    Implementing Data Flow

 

Here-in the data will be uploaded to Power BI Service, and different visualizations /reports will be created, and

7)    Visualizing (3hrs)

·         Visualizing Data

·         Adding Visuals

·         Filtering

·         Slicer Filtering

·         Highlighting

·         Setting Properties

·         Drilling within the Hierarchy

·         Creating Bookmarks

·         Power BI Mobile

·         Custom Visuals

 

8)    Security (1 hr)

·         Data Storage Security

·         Row Level Security

·         Demo: Security

 

 

9)    Refreshing Data (2hrs)

·         Publishing DataSets

·         Refreshing Data

·         Power BI Mobile Apps

·         Using Power BI Gateway - Personal

·         Understanding Power BI Gateway – Enterprise

·         Power BI Pro vs. Free

·         Publishing To Power BI

·         Setting Up Auto-Refresh

·         Content Packs

·         Sharing Within the team /with organization

·         Creating Dashboards

·         Sharing Reports /Dashboards

 

                                                                                

DAX

a)    Introducing DAX  (1 hr)

i)      Understanding DAX Calculations

ii)     Understanding Calculated Columns And Measures

iii)    Variables

iv)   Handling Errors In DAX Expressions

v)    Formatting DAX Code

vi)   Common DAX Functions

 

b)    Using Basic Table Functions (2 hrs)

i)      Introducing Table Functions

ii)     Evaluate Syntax

iii)    Using Table Expressions

iv)   Understanding Filter

v)    Understanding All, Allexcept, And Allnoblankrow

vi)   UNDERSTANDING VALUES AND DISTINCT

 

c)    Understanding Evaluation Contexts  (2 hrs)

i)      Introduction To Evaluation Contexts

ii)     Testing Your Evaluation Context Understanding

iii)    Creating A Row Context With Iterators

iv)   Understanding Filter, All, And Context Interactions

v)    Working With Many Tables

vi)   Evaluation Contexts Recap

vii)  Creating A Parameter Table

 

d)    Understanding CALCULATE And CALCULATETABLE  (2 hrs)

i)      Understanding Calculate

ii)     Calculate Examples

iii)    Understanding Context Transition

iv)   Variables And Evaluation Contexts

v)    Understanding Circular Dependencies

vi)   Calculate Rules

vii)  Introducing Allselected

 

e)    DAX Examples (2 hrs)

i)      Computing Ratios And Percentages

ii)     Computing Cumulative Totals

 

f)     Optimizing Data Models and Strategy (1 hr)

i)      Gathering Information About The Data Model

ii)     Denormalization

iii)    Columns Cardinality

iv)   Calculated Columns

v)    Choosing The Right Columns To Store

vi)   Optimizing Column Storage

 

 

Date and Time

Not decided yet.

About the Trainer

Avg Rating

0 Reviews

0 Students

181 Courses

10 years of industry experience

Reviews

No reviews currently Be the First to Review

Discussions

Uplatz Trainer picture

Uplatz Trainer

No Reviews Yet

Students Interested 0 (Seats Left 0)

₹ 28,500

Post your requirement and let us connect you with best possible matches for ETL Training Post your requirement now

Enquire

Submit your enquiry for Power BI Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Uplatz

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Register for Free Master Class

tickYou have successfully registered

Class Scheduled at

hour

To join, click

Add to Google Calendar
How to join a Class?
  • For Mobile phone, download the UrbanPro app for Learners

    The UrbanPro Learner app is your study app for this course. You can attend the Demo Class on the app and also get access to the course material, course schedule and ability to communicate with the Tutor. To learn more, watch this video.

    Play Store App Store
  • For Laptop, download the Zoom app

    Download the Zoom app for your laptop. The link to join the class will launch the meeting with the tutor on this Zoom app. To learn more, watch this video.

Verify you Mobile Number

Please verify your Mobile Number to continue and book a FREE Demo class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more