1000+ Unique Technologies Delivered | 300+ Corporate Customers Worldwide | 35000+ Professionals Trained on 40+ Domains in Over 30 Countries | Just Launched B2C Offerings | Live, Instructor-led

Power BI

This web-based training course on Power BI functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.


Reviews , Learners(390)



Course overview

This course is designed to provide insights on different tools in Microsoft BI suite such as SQL server, integration server, SQL server reporting services and SQL server analysis services. Power BI transforms company’s data into rich visuals which helps trainees to collect what matters to them. With this course trainees will also get the practical knowledge on DW concepts and also its effect in developing robust end-to-end BI solution. This course covers some most important aspects such as introduction to Power BI and all its components, PowerPivot, PowerQuery, knowledge about three components such as the Desktop, service and Mobile apps. The prerequisites for this course are awareness on RDBMS (Related Database Management System), data discovery. This course is beneficial for both beginners and intermediate professional to enhance their knowledge and skills.

Introduction

  • Power BI
  • Introduction to Excel
  • Relationship between Power BI and Excel
  • To understand Excel BI add
  • The need of power BI
  • To Download and install Power BI
  • Power BI Services and Power BI Desktop
  • Building blocks of Power BI

Query Editor

  • Various External data source
  • To fetch data from different files
  • To work with import and direct query
  • To create custom table in the Power BI
  • Merging Queries and Appending Queries
  • To Remove columns and split columns
  • To choose required columns in the data
  • To work with different transformations
  • Various applied steps in query editor
  • To work with hierarchies and measures
  • Working with Pivot & Unpivot columns
  • To create index and custom columns
  • Group By functionality in Query Editor

Groups, Pivots, Filters

  • To create and work with groups
  • To manage the null values and errors
  • Manage different data types in Query editor
  • To work with dynamic parameters.
  • Dynamic parameters to filter

DAX functions with Power BI

  • To work with DAX Functions
  • Calculated Measures by using DAX
  • Various Parameters with DAX
  • Dynamic Report Filters and Expressions

Power BI Desktop

  • To connect to Data sources
  • To work with different visualizations
  • Importing custom visualizations
  • Working with table and matrix visuals
  • To work with different level of filters
  • Data Visualizations with Power BI
  • Single row & multi row cards
  • To define relationships between tables
  • To create a custom table with range
  • Publishing a report to Power BI Services

Power BI Views & KPIs

  • To work with Power BI Views
  • To work with Data Hierarchies
  • custom slicers and In-built slicers
  • To work with reference lines
  • Working with Power pivot data model
  • To work with data modeling
  • Developing KPIs and Measures

Power BI Services

  • Data from multiple Data Sources
  • Reports from various data sets
  • Dashboards from multiple reports
  • To work with MY WORK SPACE group
  • To create Groups & Working
  • To manage Gateways & Content Packs
  • To add tiles to the Dash Boards
  • Adding YouTube videos to dashboards
  • To add images to the dashboards
  • Working with all visualizations
  • To use natural language Q&A to data
  • Reading & Editing Power BI Views
  • To manage report in Power BI Services
  • Scheduling refresh to the Datasets
  • Sharing dashboards to Client
Live Instructor-led & Interactive Online Sessions


Regular Course

Duration : 40 Hours


Capsule Course

Duration : 4-8 Hours


Enroll Now

Training Options

OPTION 1

Weekdays- Cloud Based Training

Mon - Fri 07:00 AM - 09:00 AM(Mon, Wed, Fri)

Weekdays Online Lab

Mon - Fri 07:00 AM - 09:00 AM(Tue, Thur)


OPTION 2

Weekend- Cloud Based Training

Sat-Sun 09:00 AM - 11:00 AM (IST)

Weekend Online Lab

Sat-Sun 11:00 AM - 01:00 PM


Enroll Now

Our Clients

Corporate Training Programs Delivery


Read More