UrbanPro
true

Microsoft Power BI

LIVE
18 Hours

Just Pay ₹2,000 to Register

- OR -

Course offered by Anil Dhawan

67 reviews

Module 1:- Introduction to Power BI

  • What is Data Analytics & Data Visualization
    • Introduction to Data Analysis
    • Introduction to Data Visualization
    • What is Business Intelligence?
    • Overview of Self-Service Business Intelligence (SSBI) Tools
    • Leading Self-service tools
    • Comparison of Leading Visualization Tools
  • Getting Started with Power BI
    • Introduction to Microsoft Power BI
    • Why Power BI
    • Power BI Elements
    • Basic Components of Power BI
    • Building Blocks of Power BI
    • Key Benefits of Power BI
  • Hands-On
    • Power BI Installation
  • Skills Gained
    • Understanding of Data Analysis & Visualizations
    • Concepts of Business Intelligence
    • Installing Power BI on the System
    • Elements and Building Blocks of Power BI

Module 2:- Getting Data from Different Data Sources

  • Power Bi Desktop (Getting Data)
    • What is Power BI Desktop
    • Quick Walk-through Power BI Interface
    • Views in Power BI Desktop
    • Report View
    • Data view
    • Model view
    • Understanding ETL Concepts: Extract, Transform & Load
    • Data Sources in Power BI Desktop
    • Connecting and Getting data from different sources in Power BI
    • Getting data from Excel, CSV, Access, etc
    • Saving Workfile
  • Hands-On
    • Identifying and retrieving data from different data sources
    • Extracting and Loading data into Power BI
    • Preparing Data
  • Skills Gained
    • Concepts of ETL tool
    • Getting data from multiple sources

Module 3:- Clean, Transform and Load the Data

  • Shaping Data using Power Query
    • Loading data into Power BI Desktop
    • What is Query Editor
      • Cleaning Data with Query Editor
    • Transforming Data with Query Editor
      • Unpivoting Columns
      • Eliminating Rows / Columns
      • Changing / Modifying Data Types
      • Adding Custom Columns
      • Replacing Values / NULL
      • Promoting / Demoting Row as Header
      • Modifying and managing existing ‘Steps’
    • Extracting Date Components from Date-Time
    • Introduction to “M Query”
    • Combining Data
      • Append Merge / Joins, Transpose & Formatting Data Operations
    • Hands-On
      • Cleaning Data using Power Query Editor
      • Shaping the data
      • Transforming and cleaning the data
      • Merging Rows / Columns from multiple tables
      • Joins / Append activities
    • Skills Gained
      • Data Transformation using Query Editor
      • Loading the data
      • Understanding of “M Query”

Module 4:- Design a Data Model

  • Introduction to Data Modeling
    • Understanding of Relationship
      • What is Relationship?
      • One to Many Vs One to One Relationship
    • Auto-Detect Relationship during Load
    • Dimension Table Vs Fact Table
    • Cardinality in Data Modeling
    • Creating Relationship Manually
    • Managing Data Relationship
    • Editing Relationship
    • Creating Calculated Columns
    • Creating Measures
    • Optimizing Data Models for Better Visuals
    • Cross Filter Direction
    • Defining Hierarchies
  • Hands-On
    • Creating Model Relationships
    • Managing Relationships
    • Creating Measures
    • Creating hierarchies
  • Skills Gained
    • Understanding the basics of data modeling
    • Defining relationships and their cardinality
    • Understand star schema and its’ importance
    • Managing relationships

Module 5:- DAX Formulas & Calculations

  • Introduction to Data Analysis Expression (DAX)
    • Importance of DAX
    • Data Types in DAX
    • Defining Calculation Type
      • Calculated Column Vs Calculated Measures
      • Adding New Measures to Report
      • Creating Calculated / DAX Tables
    • DAX Syntax & Operators
    • Most Important & Common Basics & Advanced DAX Functions
      • Aggregate Functions
      • Logical Functions
      • Time-Intelligence Functions
      • Information Functions
    • DAX Variables
    • Formatting DAX Code
    • Handling Errors in DAX Expressions
  • Hands-On
    • Creating Calculated Tables
    • Creating Calculated Columns and Measures
    • Writing DAX calculations to perform Data Analysis
    • Beautifying DAX
    • Creating Variables
  • Skills Gained
    • Understanding DAX
    • Create Calculated Columns, Measures & Tables
    • Working with Advanced functions e.g. Time-Intelligence, Filter contexts etc.

Module 6:- Data Visualization & Creating Reports

  • Introduction to Visuals in Power BI
    • Creating Visualization
    • How to use Visual
    • Exploring Visualizations’ List
    • Exploring Most Common & Important Visualizations
      • Bar, Column, Line and Area Charts
      • Pie, Donut, and Gauge Charts
      • Single Number Cards and Multi Row Cards
      • Table & Matrix Visuals
      • Combo Chart, Funnel and Treemap Charts
      • Slicer, KPI and Custom Visuals
      • Map & Filled Map Visuals
    • Modifying Color Properties of Charts and Visuals
    • Shapes, Text Box, Buttons, and Images
    • Types of Filters
    • Slice and Dice Data in Power BI
    • Drilling-Up/Down
    • Understanding Custom Visuals & How to add them
    • Customizing Canvas
      • Setting up Canvas & Must Know Global Fonts
      • Page Layout & Formatting
    • Bookmarks in Power BI
    • Reports in Power BI
    • Conditionally formatting tables/matrixes
    • Activity: Creating Sales Report
  • Hands-On
    • Creating visual and charts
    • Designing a report
    • Managing visual fields and format properties
  • Skills Gained
    • Creating and selecting effective visualizations
    • Designing report page layout and Visual modification
    • Adding report navigation & basic functionalities
    • Creating visually stunning reports

Module 7:- Power BI Service and Managed Workspaces

  • Introduction to Power BI Service & Workspaces
  • What is Power BI Service
    • Exploring Interface of Power BI Service
    • Understanding the Admin Portal settings
  • What is Power BI Workspace
    • Understanding of “Workspace”
    • My Workspace Vs New Workspace
    • Creating New Workspace
    • Sharing and Managing Workspaces
  • Roles in workspaces in Power BI
  • Exploring Power BI Licensing
    • Power BI Free Vs Power BI Pro Vs Premium
  • Hands-On
    • Publishing reports on Power BI Service
    • Creating workspaces
    • Sharing and Managing Reports
    • Moving important assets to App and Publishing app in Power BI
  • Skills Gained
    • Knowledge of Power BI Service (Cloud)
    • Workspaces in Power BI
    • Creating and managing a workspace

Module 8:- Creating Dashboard in Power BI

  • Dashboard in Power BI
    • Introduction to Dashboard
    • Difference between Report Vs Dashboard
    • Preparing and Creating Dashboard
      • Configuring a Dashboard
      • Pinning Visuals to Dashboard
    • Dashboard Tiles
      • Pinning Tiles
    • Dashboard Widgets
    • Introduction to Power BI Q&A
      • Asking questions about data
      • Fetching results using Q&A
      • Using Q&A to create a dashboard tile
    • Quick Insights in Power BI
      • Data Analysis using Quick Insights
    • Sharing and Collaborating Dashboard with Business Users
  • Hands-On
    • Creating a Dashboard
    • Pinning visuals to Dashboard
    • Adding text/video widgets to Dashboard
    • Sharing and Moving Dashboard to distributed app
    • Use of Power BI Q&A to question your data
  • Skills Gained
    • Dashboard creation from report
    • Enhancing dashboard usability
    • Importance of Q&A and Quick Insights

Module 9:- Data Gateway, Security & Schedule Refresh

  • Report Security in Power BI
  • Introduction to Row-level Security (RLS)
    • Setting up and Enforcing Row-level security
    • Implementing Row-level security
  • Data Gateway & Report Scheduling
    • What is Data Gateway
    • Types of Gateway
      • On-premises data gateway (personal mode)
      • On-premises data gateway (standard mode)
    • Installing Data Gateway
    • Data Gateway System Requirement
    • Benefits of Data Gateway
    • Scheduled Refresh & Refreshing Data
    • Managing Data Source
      • Adding and removing a Data Source
    • Hands-On
      • Configuring & Implementing RLS
      • Managing datasets
      • Setting up On-Premise Data Gateway
      • Connecting Reports on Power BI Cloud with Local Data Files
      • Schedule dataset refresh
    • Skills Gained
      • Dashboard creation from report
      • Enhancing dashboard usability
      • Importance of Q&A and Quick Insights

Bonus Module:- In-Class Project

  • In-Class Project: Building Sales Report & Dashboard from Scratch
    • Extracting Data from the Local Source
    • Transforming Data using Power Query
      • Cleaning, Shaping and Preparing the data if necessary
    • Loading Data to Power BI Desktop
    • Building Data Model
    • Visual and Charts
    • Row-level Security
    • Publishing Reports
    • Power BI Service
    • Creating Dashboard
  • Hands-On
    • Analyzing Sales data
    • Derive conclusions from the patterns and trends shown in the visualization
  • Skills Gained
    • Report and Dashboard creation
    • Publishing, sharing and collaborating it with Business users

Gallery (49)

+42 more

About the Trainer

4.9 Avg Rating

67 Reviews

151 Students

7 Courses

Anil Dhawan

BA and MCA*

7 Years of Experience

A professional Excel Trainer and having 10+ years of experience as MIS/Data/Business Analyst and have been training since last 4-5 years. I have various applications knowledge i.e. Excel, SFDC, Business Object, Google Analytics, Webmaster, DFP, AdSense, VBA out of which I have strong grip over Excel/VBA/Google Analytics. I have trained over 50+ working professionals and given On Job Training during my stay at Google, Alcatel Lucent and couple of Real-Estate firms.

Courses that I have designed are especially for corporate people and freshers who want to appear for Excel/MIS/Data Analyst profiles. The examples, situations and material have been used from my past working experience that I tried collaborating it in one place for you to Make You Good in Excel and Informative. Post every session you get study material and session study material to practice and "Make Excel Your Power".

Students also enrolled in these courses

LIVE
13 reviews
10 Hours
10,000 Group Class (max 5)
10,000 1-on-1 Class

Course offered by Vinod

59 reviews
LIVE
7 reviews
Mon, Tue, Wed, Thu, Fri, Sat 08:00pm-08:40pm
15 Hours
6,000 Group Class (max 5)
20,000 1-on-1 Class

Course offered by Sanjay singh

432 reviews
LIVE
2 Hours
5,000 Group Class (max 5)
1,500 1-on-1 Class

Course offered by Anand

0 review
LIVE
20 Hours
8,000 Group Class (max 5)
10,000 1-on-1 Class

Course offered by Rajinder Kumar

13 reviews

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Microsoft Power BI by Anil Dhawan

Anil Dhawan picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Microsoft Power BI by Anil Dhawan

Anil Dhawan picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free 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

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

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