Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




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.

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

Power BI at this time connects almost to 60 software solutions that business already uses and pulls data into the centralized server. It has ease of implementation as very little or small engineering resources are required to implement it. It has a robust access control and security. The access control is provided through Active Directory (AD). One of the best advantages of this tool is that it has a simple learning curve as everyone uses the Microsoft product, so the user interface elements are already familiar to the trainees. With getting exposure to this training course trainees will get a high value addition to their skills and can get the job in top fortune companies. Hence, this course is more application focused as compared to theory focused in order to give the trainees a profound usability experience and procedures.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright © 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.