Power BI 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
5/5

Duration :  30 Days

About Course

Dell Boomi understands the need for a quality training curriculum along with real-time implementation exposure as it forms the very essence of your future career in Boomi Certification. Our well-structured online training course in Dell Boomi Training extensively covers all the core aspects of classes with an emphasis on live scenarios. Access to expert trainers and instructor-led training sessions ensures that you can easily clear your doubts and get the exact guidance that is expected from Dell Boomi Online Training sessions.

Upcoming Live Online Classes

 
10-SEP-2022 TO 05-DEC-2022

 08:00 AM

 
10-SEP-2022 TO 05-DEC-2022

 08:00 AM

Can't Find Your Convenient Batch?

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
  1. Power BI Desktop Installation
  2. Building Blocks of Power BI
  3. Datasets, Visualizations, Reports, Dashboards, Tiles
  4. Power BI Desktop User Interface
  5. Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas
  6. Overview of Power Query / Query Editor – Extract, Transform & Load Data
  7. Connecting to Data Sources, Establish connection to the Excel source
  8. Importing Data into Power BI or Query Editor
  9. Transforming the Data using Power Query
  10. Model the Data using Power Pivot – Relationship View
  11. Creating New Measures and New Columns using DAX – Data View
  12. Visualizing the Data using Power View and Power Maps – Report View
  13. Saving and Publishing the Visuals or Reports
  14. Logon to Power BI Service
  15. 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

Course Details

  • Live Instructor Based Training
  • Real-Time Oracle Certified Trainer
  • 1 Yr. Membership to Multiple Batches
  • Live Recorded Videos Access
  • Latest Instance Access for 5 Months
  • Study Material Provided
  • Sample Resumes & Preparation
  • Interview Questions with Ans

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Corporate Training

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

Self-Paced Learning

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

Live Virtual Training

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

Happy Students Reviews

Dami
Dami@dami
Read More
The trainer who taught me was very good. The total journey went great. He used to teach me from the beginner level to the advanced…
Surekha
Surekha@Surekha
Read More
The training experience and throughout the duration of course was excellent.I took SAP ABAP couse here which has covered all the topics from beginner to…
Vikram Kumar
Vikram Kumar@Vikram_Kumar
Read More
Best training in Java Script and Angular JS. Recording classes are very good. Focused on every concept with practical approach. This institute gives best training…
Yaswanth
Yaswanth@Yaswanth
Read More
Trainer was good in understanding the requirements and trained the topics with relevant examples for a better understanding. The training was interactive and content was…
Abey
Abey@Abey
Read More
Nice institute with very good facilities for trainer and trainee. Highly recommend it for SAP S4 Hana Basis training. Rajendra Prasad is very helpful and…
Abdhul Mohammad
Abdhul Mohammad@Abdhul_Mohammad
Read More
I had a good experience with VISWA Technologies My trainer was Pradeep sir, he is a good trainer. I completed python course successfully with deep…
Previous
Next

More Courses You Might Like

Dell Boomi

AWS Course

Oracle

Linux

Quick Links