Call us Today ! 9590800200 | training@gitsacademy.com

ABOUT COURSE:
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

FOUR COMPONENTS TO POWER BI

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.

FAQs

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.

3 + 1 =

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
SECTION-2 POWER QUERY
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
SECTION-3 POWER VIEW
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
SECTION-4 POWER MAPS
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

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE9 SEATS LEFT
  • Rs.15,000 Rs.11,500
  • 1 Days
  • ,
  • 10 SEATS
  • Course Certificate
  • CAll : 9590800200
  • Email : Training@gitsacademy.com
26 STUDENTS ENROLLED
  • Profile photo of admin
For individuals For business

Quick Enquiry

Please provide as much informaton as possible for us to help you with your enquiry...

Looking For

ClassRoom InstructorLed Self-Paced

Thank You

Your submition has been received

Avail exclusive group discounts on enrolling in groups of 3 or more

Refer your friends / colleagues

Quick Enquiry

Please provide as much informaton as possible for us to help you with your enquiry...

Message Sending...

Popular Courses

GITS Academy. All rights reserved.