Call us Today ! 9590800200 |

In this course you will learn Power BI from beginner to advance. Power BI Course enables you to perform Simple Data Analysis as well as Complex Business intelligence scenarios and advanced dashboarding. This power BI course will cover five major components of power BI: Power Pivot and Power Query. The other two are for data visualization: Power View and Power Map.

Power BI  is one of the newest additions to Office 365. In this course you will learn Power BI from beginner to advance. Power BI Course enables you to perform Simple Data Analysis as well as Complex Business intelligence scenarios and advanced dashboarding. This power BI course will cover five major components of power BI: Power Pivot and Power Query. The other two are for data visualization:  Power View and Power Map.

About Excel Power BI

Excel is most important Tool for Self-Service Business Intelligence (BI) activities.

There are four components to Power BI, and all are delivered via Excel.  Microsoft is capitalizing on the fact that a huge percentage of business users are most comfortable in an Excel environment.  Meanwhile Excel has emerged as the primary mechanism for creation and delivery of Self-Service BI solutions.power bi training bangalore


Two of the Power BI components are for data preparation:  Power Pivot and Power Query.

The other two are for data visualization:  Power View and Power Map.

Power Pivot

Imports and integrates data from various sources for the purpose of creating an in-memory data model.  PowerPivot has significant performance advantages over older pivot tables, however.  PowerPivot tables can take advantage of far more memory and handle much greater worksheet sizes than previous versions of Excel.  On 64-bit workstations, massive amounts of memory can be utilized and enormous data sets manipulated. The PowerPivot interface also includes some useful new capabilities, such as the “slice” capability that allows real time drilldown into subsets of the data.  Furthermore, PowerPivot allows the combination of multiple views of the data on a single dashboard-like page.  Data Analysis eXpressions (DAX) includes more powerful functions for BI type data manipulations, including iterative expressions, grouping, linking, and filtering.

Power Query

It allows you to do things like merge data, rename columns, replace values and other data modifications in a step-by-step process.  A very big deal here is that the step-by-step data cleansing and shaping process is savable and therefore repeatable.  You can also view the state of the data before and after each step.  Optionally, you can bring the data into your Power Pivot model to continue working with the data even further.

Power View

Power View is an interactive data visualization tool.  It does certain things like highlighting and cross-filtering really well with very little learning curve.  Working with data in Power View bears similarities to working with Excel Pivot Tables as well as to PowerPoint.  In addition to charts, graphs, and table data, Power View also supports maps which pan and zoom via integration with Bing Maps.  The naturally interactive behavior of Power View is what makes it a very big deal.

Power Map

Power Map is a 3D mapping tool.  What makes it unique is the ability to save scenes and play them over time in a tour. Power View is Purely an Alternative to the Excel Visualization Layer. In other words, ideally view Power View is new type of Excel Chart with several enhanced capabilities.that would make an Analyst life so simple.

6 + 6 =

Course Curriculum

SECTION-1 Learning PowerPivot
What is PowerPivot for Excel? 00:00:00
Importing Your Data PowerPivot 00:00:00
Creating a PowerPivot Data Model 00:00:00
Creating PivotTables with PowerPivot 00:00:00
Creating a Date Table 00:00:00
Using Slicers to Filter Data 00:00:00
Connecting Slicers to more than one PivotTable 00:00:00
Using Charts and Slicers to create interactive Dashboards 00:00:00
Using DAX in powerpivot 00:00:00
Creating Calculated Columns 00:00:00
Creating Calculated Fields 00:00:00
Implicit and Explicit Calculated Fields 00:00:00
Using DAX aggregate functions in a PowerPivot PivotTable 00:00:00
Using CountRows and DistinctCount Functions 00:00:00
The difference between evaluations using Row Context and evaluations using Filter Context 00:00:00
Advanced DAX functions: SUMX and CALCULATE 00:00:00
Time Intelligence Functions 00:00:00
Creating Key Performance Indicators 00:00:00
Using PowerPivot Sets 00:00:00
Adding Data to Power Query from various data sources 00:00:00
Creating a Query, the Query Editor Window 00:00:00
Load to Worksheet and Load to Data Model 00:00:00
Remove Duplicate Data in Columns 00:00:00
Split and Merge Columns of Data 00:00:00
Group data to create summary Queries 00:00:00
Merge and Append Queries 00:00:00
Transpose Data to swap Rows and Columns 00:00:00
Filling data Down to populate missing values 00:00:00
Unpivot Columns: flatten a “cross tab” table 00:00:00
Duplicate Columns, Creating Custom Columns and Additional Date Columns 00:00:00
Working with Applied Steps 00:00:00
Importing Data From a Folder 00:00:00
The Power View Field List 00:00:00
Using Text Boxes 00:00:00
Creating Tables 00:00:00
Changing Table Visualisations 00:00:00
Using a Matrix and Enable Drill Down 00:00:00
Using Cards; Setting up Titles and Pictures for Cards 00:00:00
Creating Chart Visualisations and Interactive Charts 00:00:00
Creating Power View Slicers 00:00:00
Using Tiles 00:00:00
Using Power View Filters 00:00:00
Working with interactive Bubble Charts using the Play Axis 00:00:00
Creating Power View Maps 00:00:00
Create a Power Map and Plot Geographic Data 00:00:00
Creation Visualisation; Column, Bubble, Heatmap, Regions 00:00:00
Using the 3-D Environment 00:00:00
Using Charts with Power Maps 00:00:00
Working with Layers and adding Scenes 00:00:00
Adding Annotations 00:00:00
Visualising Data over Time 00:00:00
Playing the Tour 00:00:00


Power BI of the newest additions to Office 365,  Power BI is a self-service Excel tool. Power BI is used in enterprise solutions. Power BI has  features with the very powerful data transformation component : Power Query and data modelling  based on xVelocity in-memory engine (Power Pivot), and great data visualization components such as Power View and Power Map, along with mobility support of this product, are rarely available in other products.

Power BI is the newest Microsoft BI tool for data preparation, data visualization: build modelling, and visualize it effectively. It supports mobile devices, it support self-service, and along with its great functionalities, it doesn’t require heavy development or production system.

Course Reviews


10 ratings
  • 5 stars8
  • 4 stars2
  • 3 stars0
  • 2 stars0
  • 1 stars0


    The courses are top rate. GITS Academy trainers are always there to answer questions, and prompt when you open an issue if you are having any trouble. I’m fully satisfied with the teaching. Thank you Gits giving a best training



    I have joined GITS Academy for Microsoft Power BI Training. I think the course is doing an excellent job of giving a comprehensive understanding of each topic and I will recommend Gits for analytics training



    I took the MS POWER BI course with GITS ACADEMY recently. It was fantastic for several reasons; the class outline and structure were clearly laid out. You knew where you were headed. 2. The class ALWAYS began and ended on time. For me this was very important due to my travelling issues. Thanks Gits.



    After completing my graduation I did Power BI training from gits academy training centre. I gained knowledge in depth I’m fully satisfied with the teaching thank you Gits giving a best training.



    I have done Power BI training here and I must say very much confident about the skills now the faculty here is too experienced and they teach very well I’m too happy I choose gits. I especially liked the fact that he also took great pains to see to it that our questions were answered. I think this is the best part of these classes. Being able to ask questions and clear up things.



    Gits Academy trainer are very dedicated about training sessions and make sure that students are understanding at fullest , this thing I liked very much. Thank you GITS for all your support.



    I have joined for MS POWER BI course with GITS ACADEMY, the quality of the sessions in terms of the sound and video was also very good. The instructor knew MS POWER BI in and out and also clearly explained things to us very well. Thanks.



    Business Analytics course was absolutely great. Instructor taught all the concepts thoroughly and he is very knowledgeable, clarified and answered all the questions. The support team at GITS ACADEMY is really good. Enjoyed the course, good hands on as well which was very helpful.



    I would definitely like to give more than 5 stars to Gits Academy, Support staff and trainers are excellent and very professional, the amount of time they spend with each of us is really appreciated. Today I registered for the business analytics course. I am sure the training will excellent.



    I was trained at GITS on MS POWER BI by one of the notable trainers named Ashutosh Sir and he helped me to complete the course with thorough understanding. The way of teaching MS POWER BI was so good , even being from a non-technical background I could learn it very fast and thoroughly. The material provided by the faculty was up-to the mark. It also helped me to move to a desired profile.

  • Rs.15,000 Rs.11,500
  • ,
  • 11 SEATS
  • Call : 9590800200
  • Email:
Quick Enquiry

Popular Courses

GITS Academy. All rights reserved.