Power BI Training

Learning Objective: Power BI is a set of services and applications that work in combination to turn unrelated, raw data into easy to understand visualizations. This module will give you an overview of the Power BI tool.

Topics: 

• • Introduction to Power BI tool 
  • Desktop Applications 
  • Features of Power BI workflow 
  • Data sourcing from web 
  • BI service, and file data sources
  • Publishing to Cloud 
  • Data Visualization 
  • DAX data computation,
  • Data drill-down and drill-up
  • creating columns and measures
  • Filter context, and Row context 
  •  Power Q & A 
  • Creation of column relationships 
  • Essential Power BI components like Power Map, view, Pivot, Query
  • Advanced visualization concepts

Learning Outcome:  You will gain hands-on exposure in sourcing data from various sources, building a Power BI dashboard, Power BI tabs creation, etc.

Learning Objective:  Data extraction is a process to connect with a wide range of sources to get the desired data. This module will teach you the various strategies available in Power BI for data extraction.

Topics: 

• • Introduction to Self-service ETL functionalities 
  • Fundamentals of Power Query 
  • Overview of Data Mashup 
  • Power BI Personal Gateway,
  • Working with Excel data, 
  • Data extraction from files 
  • SaaS functionalities of Power BI.
  • connect to Analysis Services 
  • Working with Azure SQL database 
  •  Folders and databases

Learning Outcome: You will gain practical knowledge in performing various tasks which include connecting to a database, connect to a SQL Server, Import data from an Excel file, connect to Hadoop, and learn to extract data from all other resources.

Learning objective: Power query is a data preparation engine that comes with a graphical interface which helps in sourcing data. This module will help you learn the role of Power Query in Power BI and its components.

Topics:

• • Power BI installation 
  • Power BI configuration
  • Introduction to Power Query 
  • Adding and filling columns 
  • Data Transformation 
  • Transpose table,  column formatting, splitting, appending, formatting data. 
  • Relational operators and Pivot & UnPivot 
  • Working with M functions
  • Advanced data transformations
  • Error handling and writing custom functions
  • Index and Conditional Columns

Learning Outcome: Upon the completion of this Power Bi module you will gain hands-on experience in installing Power BI Desktop & setting up, write a power query, working with a query editor, and Transpose a table.

Learning Objective: Power Pivot is an in-memory data modelling component that gives you a high-speed calculation and aggregation and also provides highly compressed data storage. This module will teach you the working style of Power Pivot and its components.

Topics:

• • Overview of Power Pivot 
  • Working xVelocity engine 
  • Benefits of Power Pivot 
  • Data Analysis Expressions strongly typed datasets, 
  • Different Pivot relationships and versions
  • Measures, Calculated Members, Context Interactions, 
• Filter & Evaluation Context, Schema Relations, 
• • Time Intelligence Functions,
  •  ranking and rank over groups
  • Cumulative Charts, Calculated Tables,
  • Advanced functionalities of Power Pivot 
  • embedding Power Pivot in Power BI Desktop.

Learning Outcome: You will gain hands-on experience in creating a Powerpivot,  Working with various Filters, Creating DAX queries, Embed  Power Pivot in Power BI Desktop, advanced Pivot functionalities.

Learning Objective: This module will give you a complete glance of Data visualization and data analytics in Power BI and explain to you how they are helpful in finding the patterns in data and making valuable business decisions.

Topics:

• • Get in-depth knowledge of Power BI data visualization 
  • Power BI Desktop visualization, 
  • Understanding Power View and Power Map,
  • Visualization interaction,
  • Formatting and customizing visuals, 
  • Process to deploy Power View on SharePoint and Excel, 
  • Comparison between volume and value-based analytics 
  • Using Power view to sort, filter and categorize. 
  • Working with power View to develop reports, charts and other rich formats. 
  • Top-down and bottom-up analytics,
  • Authenticate a Power BI web application
  • Customizing a visualization 
  • Embedding dashboards in applications

Learning Outcome: This module you will gain hands-on experience in the creation of Power Map and Power View,  Implement top-down and bottom-up analytics,  Deploy Power View on SharePoint and Excel, Reports creation, customizing reports,  use business hierarchies, Use date hierarchies, and resolving issues associated with hierarchy.

Learning Objective: Power Q & A is an advanced feature in Power BI which enables us to get prompt answers for the questions asked using natural language. Following are the different concepts that you are going to get through this Power Q & A module.

Topics:

• • Introduction to Power Q & A 
  • Role of Natural Language in Power BI 
  • Proces to answer tough queries with Natural Language 
  • Ad hoc analytics building,
  • data discovery methodologies,
  • Building answers in the form of graphs and charts

Learning Outcome: Upon the completion of this module, you will learn to write answers to the queries using Natural language, providing answers in the form of charts, graphs etc.

Learning objective: This module has been designed to teach you the fundamentals of Power BI Desktop and Administration.

Topics:

• • Introduction to Power BI Desktop 
  • Power Query working process in  Power BI Desktop environment 
  • Data aggregation from various sources 
  • Understanding data relationships and data modelling
  • Scheduling data refresh and deploying data gateways
  • Working with calculated measures,
  • Datasets, reports and dashboards,
  • Managing groups and row-level security, 
  • Power Pivot on Power BI Desktop ecosystem,
  • Power View on Power BI Desktop,
  • Mastering data visualization,
  • Working with real-world case studies.

Learning Outcome: Upon the completion of this module, you will learn to configure security for dashboard, process to get the data from various sources, Manage groups and row-level security, reports and dashboards, and working with calculated measures.