Power BI Certification Training

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration :  30 Days

About Course

Power BI is a Business intelligence tool or a Business analytics solution developed by Microsoft. It unifies data from multiple sources to create interactive reports and dashboards that provide actionable insights and drive business results.​ It provides us with three ways to consume & build our reports – Power BI desktop, Power BI Service, and Power BI Mobile. Enroll now and get certified in it.

Power BI Training Course Syllabus

✔ Data Visualization, Reporting
✔ Business Intelligence(BI), Traditional BI, Self-Serviced BI
✔ Cloud-Based BI, On-Premise BI
✔ Power BI Products
✔ Power BI Desktop (Power Query, Power Pivot, Power View)
✔ Flow of Work in Power BI Desktop
✔ Power BI Report Server, Power BI Service, Power BI Mobile
✔ Flow of Work in Power BI / Power BI Architecture
✔ A Brief History of Power BI

✔ Power BI Desktop Installation
✔ Building Blocks of Power BI
✔ Datasets, Visualizations, Reports, Dashboards, Tiles
✔ Power BI Desktop User Interface
✔ Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
✔ Overview of Power Query / Query Editor – Extract, Transform & Load Data
✔ Connecting to Data Sources, Establish connection to the Excel source
✔ Importing Data into Power BI or Query Editor
✔ Transforming the Data using Power Query
✔ Model the Data using Power Pivot – Relationship View
✔ Creating New Measures and New Columns using DAX – Data View
✔ Visualizing the Data using Power View and Power Maps – Report View
✔ Saving and Publishing the Visuals or Reports
✔ Logon to Power BI Service
✔ View the Reports in PBI Service and Share the reports

✔ Data Transformation, Benefits of Data Transformation
✔ Shape or Transform Data using Power Query
✔ Overview of Power Query / Query Editor, Query Editor User Interface
✔ The Ribbon (Home, Transform, Add Column, View Tabs)
✔ The Queries Pane, The Data View / Results Pane, The Query Settings Pane,
✔ Formula Bar
✔ Advanced Editor – Complete ETL Code
✔ Saving Your Work – Appling ETL Changes – Loading into Power Pivot Model
✔ Power Query Conceptually

✔ Datatypes, Changing the Datatype of a Column
✔ Filters in Power Query  Auto Filter / Basic Filtering
✔ Filter a Column using Text Filters
✔ Filter a Column using Number Filters
✔ Filter a Column using Date Filters
✔ Filter Multiple Columns

✔ Header Row or Use First Row as Headers
✔ Keep Top Rows, Keep Bottom Rows
✔ Keep Range of Rows
✔ Keep Duplicates, Keep Errors
✔ Remove Top Rows, Remove Bottom Rows, Remove Alternative Rows
✔ Remove Duplicates, Remove Blank Rows, Remove Errors
✔ Group Rows / Group By

✔ Append Queries
✔ Append Queries as New
✔ Append 2 or more files individually with different queries
✔ Appending multiple files of same type from a folder using single query
✔ Query Options
✔ Copy Query, Paste Query
✔ Delete Query, Rename Query
✔ Enable Load, Include in report Refresh
✔ Duplicate Query, Reference Query
✔ Move to Group, Move Up, Move Down

✔ Merge Queries, Merge Queries as New
✔ Default Types of Joins / Join Kinds / Merge Type

✔ Left Outer (all from first, matching from second)
✔ Right Outer (all from second, matching from first)
✔ Full Outer (all rows from both)
✔ Inner (only matching rows)
✔ Left Anti (rows only in first)
✔ Right Anti (rows only in second)
✔ Cartesian Join or Cross Join

✔ Data Modeling Introduction
✔ Relationship, Need of Relationship
✔ Relationship Types / Cardinality in General
✔ One-to-One, One-to-Many (or Many-to-One), Many-to-Many
✔ AutoDetect the relationship, Create a new relationship, Edit existing relationships
✔ Make Relationship Active or Inactive
✔ Delete a relationship
✔ Cross filter direction (Single, Both), Assume Referential Integrity

✔ What is DAX, Calculated Column, Measures
✔ DAX Table and Column Name Syntax
✔ Creating Calculated Columns, Creating Measures
✔ Implicit Vs Explicit Measures
✔ Calculated Columns Vs Measures
✔ DAX Syntax & Operators
✔ DAX Operators
✔ Types of Operators
✔ Arithmetic Operators, Comparison Operators, Text Concatenation Operator,
✔ Logical Operators

✔ Date and Time Functions
✔ Logical Functions  Text Functions
✔ Math & Statistical Functions
✔ Filter Functions
✔ Time Intelligence Functions

✔ YEAR, MONTH, DAY
✔ WEEKDAY, WEEK NUM
✔ FORMAT (Text Function)
✔ Month Name, Weekday Name
✔ DATE, TODAY, NOW
✔ HOUR, MINUTE, SECOND, TIME
✔ DATEDIFF, CALENDAR
✔ Creating Date Dimension Table

✔ LEN, CONCATENATE (&)
✔ LEFT, RIGHT, MID
✔ UPPER, LOWER
✔ TRIM, SUBSTITUTE, BLANK

✔ IF
✔ TRUE, FALSE
✔ NOT, OR, IN, AND
✔ ERROR, SWITCH

✔ INT
✔ ROUND, ROUNDUP, ROUND DOWN
✔ DIVIDE
✔ EVEN, ODD
✔ POWER, SIGN
✔ SQRT, FACT
✔ SUM, SUMX
✔ MIN, MINX
✔ MAX, MAXX
✔ COUNT, COUNTX
✔ AVERAGE, AVERAGEX
✔ COUNT ROWS, COUNTBLANK

✔ CALCULATE
✔ ALL
✔ RELATED

✔ Time Intelligence Introduction
✔ TOTALMTD, TOTALQTD, TOTALYTD
✔ PREVIOUS DAY, PREVIOUS MONTH, PREVIOUS QUARTER, PREVIOUS YEAR
✔ NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR
✔ SAMEPERIODLASTYEAR
✔ YOY Growth
✔ MOM Growth

✔ Report View User Interface
✔ Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
✔ Visual Interactions
✔ Interaction Type (Filter, Highlight, None)
✔ Visual Interactions Default Behavior, Changing the Interaction

✔ Filter Types

✔ Visual Level Filters, Page Level Filters, Report Level Filters, Drill Through Filters

✔ Filter Sub Types

✔ Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering Numeric field filters, Text field filters, Date and Time field Filters

✔ Grouping and Binning Introduction
✔ Using grouping, Creating Groups on Text Columns
✔ Using binning, Creating Bins on Number Column and Date Columns
✔ Sorting Data in Visuals
✔ Changing the Sort Column, Changing the Sort Order
✔ Sort using column that is not used in the Visualization
✔ Sort using the Sort by Column button

✔ Hierarchy Introduction, Default Date Hierarchy
✔ Creating Hierarchy, Creating Custom Date Hierarchy
✔ Change Hierarchy Levels
✔ Drill-Up and Drill-Down Reports
✔ Data Actions, Drill Down, Drill Up, Show Next Level, Expand Next Level
✔ Drilling filters other visuals option

✔ Visualizing Data, Why Visualizations
✔ Visualization types, Field Wells
✔ Visuals for Filtering, Visualizing Categorical Data, Visualizing Trend Data
✔ Visualizing KPI Data, Visualizing Tabular Data, Visualizing Geographical Data
✔ Leveraging Power BI Custom Visuals

✔ Slicer Visualization
✔ When to use a Slicer
✔ Create and format Slicer Visualization
✔ Hierarchy Slicer (Custom Visualization)
✔ When to use a Hierarchy Slicer
✔ Create and format Hierarchy Slicer
✔ Advantages of Hierarchy Slicer

✔ Create and Format Bar and Column Charts
✔ Create and Format Stacked Bar Chart Stacked Column Chart
✔ Create and Format Clustered Bar Chart, Clustered Column Chart
✔ Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart
✔ Create and Format Pie and Donut Charts
✔ Create and Format the Tree Map Visual
✔ Create and Format Scatter Charts

✔ Line and Area Charts
✔ Create and Format Line Chart, Area Chart, Stacked Area Chart
✔ Combo Charts
✔ Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart
✔ Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

✔ Create and Format Gauge Visual, KPI Visual
✔ Create and Format Card Visualization, Multi-Row Card

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

Power BI Training - Upcoming Batches

7th NOV 2022

8 AM IST

Weekday

Coming Soon

AM IST

Weekday

5th NOV 2022

8 AM IST

Weekend

Coming Soon

AM IST

Weekend

Don't find suitable time ?

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.
Preferred

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

Power BI Training FAQ'S

Power BI is a Business intelligence tool or a Business analytics solution developed by Microsoft. It unifies data from multiple sources to create interactive reports and dashboards that provide actionable insights and drive business results.​ It provides us with three ways to consume & build our reports – Power BI desktop, Power BI Service, and Power BI Mobile.

“Power BI is a business analytics tool,” according to Microsoft, “that enables you to display your data and share insights across your organization, or embed them in your app or website.” The solution consists of multiple goods and services, and the value and diversity come from combining the separate pieces and exploiting how they interact. Some of the benefits of Power BI as an effective solution are;

  • Connect to information
  • Data transformation and modeling
  • Make graphs and charts.
  • Create visual groupings for reports and dashboards.
  • Use the Power BI service to share reports with others.

A Power BI dashboard is a single page, also known as a canvas, that uses visuals to convey a narrative. A well-designed dashboard offers only the highlights of the tale since it is confined to one page. For further information, readers may look at associated reports.

Visualizations are used to represent our data in more than a tabular form. In Power BI, we have the design space where all the elements of a report, different visuals, slicers/filters, etc. These elements, when put into the design space, are called tiles. All the visuals that are available in Power BI are put under the Visualization Pane. It includes basic visuals such as bar, pie, line, column, and map with their varieties. Along with them, we do not have very common visuals like waterfalls, funnels, gauges, etc. We have a lot of custom visuals available as well. They can be imported into the report from App Marketplace. And then, we can bring them into our design view.

If one knows R or Python, then we also have the option to create visuals using code. 

Power BI is a set of software services, applications, and connections that work together to help you produce, distribute, and consume business insights in the most efficient way possible for you and your company. The SaaS (Software as a Service) component of Power BI is the Microsoft Power BI service, sometimes known as Power BI online. Dashboards in the Power BI service allow you to keep an eye on the pulse of your business. Dashboards show tiles that you may click to launch reports for additional investigation. Dashboards and reports are linked to databases, which collect all essential data in one location.

Get ahead in your career by learning Power BI through VISWA Online Trainings

Reviews

SHAIK SAJID
SHAIK SAJID
2022-11-23
Excellent institute for Online WebMethods Course and I recommend VISWA Technologies thank you For arranging such a great faculty
Madhu
Madhu
2022-11-23
Today is the last class for online RPA course i am thankful to Chaitanya sir for such a great training and I thank to admin team
Bodicherla Jagadeeswar
Bodicherla Jagadeeswar
2022-11-23
Recently completed online Microsoft Intune training course By "Rajendra Prasad" and I recommend VISWA Online Trainings for this course and also thank you admin team
Penchalakumar Ganji
Penchalakumar Ganji
2022-11-23
Best institute for Linux, AWS online course by Musab sir. I thank Chaitanya sir for arranging our classes
Konduru Akhil
Konduru Akhil
2022-11-23
Hi, Overall training classes are very good.All the instructions are kind and patient.I look forward to take more classes from Viswa online trainings.
Eswar Tech
Eswar Tech
2022-11-18
I enroll for aws solution architecture course. It was great learning with viswa technologies. Thanks team.
Manikanta Goud
Manikanta Goud
2022-11-18
I am really satisfied. Best training institute. Thanks Chaitu
S Rambabu 6228
S Rambabu 6228
2022-11-18
Best online training institute. I have more experience with java srinath trainer.
gaddam Manojkumar
gaddam Manojkumar
2022-11-12
They have a professional approach by their trainer and support team. Personally, I liked the instructor's way of teaching and also helping us if we have any doubts after the class.
Ramesh Metta
Ramesh Metta
2022-11-11
They have teachers with strong expertise. The AWS course i have taken was good and had full support from team.

Quick Links