Power Bi Training (1)

1
Power BI Trainings

• Online Training _at_ hkrtrainings.com

2
About HKR Trainings

• HKR Trainings excel at providing you with the
  best online classes with high-quality facilities
  at a low price without any compromise on quality.
  What can you expect from us? A dedicated learning
  platform with 247 support, best in class
  training materials to help you learn advanced
  techniques and practical knowledge of all IT
  Technologies.
• Our courses are specifically curated for both
  professionals as well as job-seekers. Online
  classes conducted by the best knowledgeable and
  certified trainers help you earn certification at
  your convenience.

3
Table of contents
Power BI Intro
Objectives
02
01
Course Info
Modules
03
04
4
Power Bi Training

• Gain a 360 overview of how to use Power BI to
  create effective reports. In this Power BI
  course, our trainer helps you to explore how to
  use this business intelligence platform through
  hands-on practice. The Power BI training begins
  by covering the web-based Power BI service,
  considering how to import data, create
  visualizations and reports. Next, youll
  acknowledge Power BI Mobile and how to use data
  modeling capabilities in Power BI Desktop. Each
  analysis is designed to drive your Power BI
  skills to the next level. With live Power BI
  training classes and multiple real-time projects,
  youll acquire the skills needed to pass the
  Microsoft Power BI Certification Exam.

5
Power BI Online Training Objectives

• Who should take up take up this Power BI Training
  Course?
• What are the prerequisites for taking up the
  Power BI Training online course?
• How to start with the Power BI Training Course?
• Who issues the course certification certificate?
• Who delivers the Power BI Training Course?
• What are the benefits of the certified Power BI
  training certification?
• Do we provide job assistance for the power BI
  Training course?

6
Power BI Modules

• Starting with Microsoft Power BI
• In this Power BI training course module, you'll
  learn how to navigate this easy application and
  gain a thorough understanding of Power BI's data,
  model, and report. You'll learn how to load
  multiple data sets, construct an interactive
  visualization, and build a data model.
• What are Power BI Tools?
• Installation of Power BI Data Connection
• The "Locale" used in the curriculum
• Working with the query Editor
• Working with the data model and creating a
  visualization

7

• 2. Power BI desktop
• This Power BI training module will teach you what
  Power BI Desktop is, how it works, and how to use
  it to create robust data models and interactive
  reports that could help you boost your business
  intelligence.
• Workflow overview in power bi desktop
• Introduction to various data model views
• Examining the query editor's Interface in detail
• Settings for Power BI that are required

8

• 3. Query Editor
• Power BI's Query Editor allows you to modify and
  load data, while DAX allows you to create data
  models with functions and formulas. Through
  hands-on labs and lectures, you'll learn
  everything there is to know about Power Query and
  DAX in this Power BI online course program.
• Understanding query Editor?
• Regarding the attached data
• Using Power BI Desktop for connecting data
• Rows Editing
• What are Append Queries?
• Columns Editing
• Replacing Values
• Formatting Data

9

• Pivoting Unpivoting Columns
• Splitting Columns
• Creating a new Group for the queries
• Introduction to Star Schema
• Queries Duplicating Referencing
• Manual Data Entry
• Merging Queries
• Index Column Creation
• Duplicating Column and extracting info
• Creating Conditional Columns
• Performing Mathematical Operations at a Basic
  Level
• Improving Performance and Loading Data into Data
  Model
• Summary of the Module

10

• 4. View of data relationships
• This Power BI Certification Course module will
  teach you about the structure of modeling in
  Power BI and the relevance of relationships.
  Also, learn how to use DAX to generate customized
  calculations.
• Why is the Query Editor the data model
  different?
• Introduction to relationships
• Editing relationships
• Concepts are cardinality
• Cross Filter selection Many to many
  relationships
• Active properties
• How are M-Language DAX different?
• DAX, Measures Calculated Values
• DAX complex functions
• Calculate

11

• SUM
• SUMX
• RELATED
• ALLEXCEPT
• CONCATENATE
• LOOKUPVALUE
• IF
• SEARCH
• DATEADD
• DIVIDE, and many more.
• Categorizing Data

12

• 5. Visualizing results in report view
• Any business intelligence applications front end
  is data visualization. This online Power BI
  training module covers the most common forms of
  Power BI visualizations, such as bar charts, line
  charts, and so on. You'll also learn about some
  of the most common tools for structuring visuals,
  as well as some best practices for using Power BI
  Desktop.
• Viewing Reports interface
• Creating visuals
• Add tooltips and interactions/markings
• Data color
• Hierarchies Drill-down
• Formatting charts Sorting
• Introduction to slicers
• Treemaps Tables
• Types of filters

13

• Multi-row cards
• Combined visuals waterfalls

14
COURSE FEATURES

• 30 Hrs of instructor-led training
• Lifetime access to recorded sessions
• Certification pass guaranteed
• Real-world use-cases Certified
• Trainers 247 Support

15
Contact Info

• Ameerpet, Hyderabad
• India 919711699759
• info_at_hkrtrainings.com
• 40640 High Street Fremont, Illinois, Chicago.
• USA 1(818)665 7216
• Website https//hkrtrainings.com/power-bi-trainin
  g

16
Visit our website

• If you want to know more details about Power BI
  training, visit our website - www.hkrtrainings.com

17
Thanks!

• Do you have any questions?
• sales_at_hkrtrainings.com
• 91 9711699759
• 1 [phone]
• https//hkrtrainings.com