Power BI


  • Batch Timings :
  • Starting Date :

Course Overview

This Microsoft Power BI Desktop training course is aimed at anyone looking to use this powerful, flexible, and highly accessible tool to connect with and shape the world of data, build robust models, and craft well-structured reports, which can then be seamlessly shared through Microsoft Power BI Service with users.

COURSE FEATURES

  • Resume & Interviews Preparation Support
  • Hands on Experience on One Live Project.
  • 100 % Placement Assistance
  • Resume Preparation
  • Interview Preparation
  • Multiple Flexible Batches

At the end of Power BI Training Course, Participants will be able to:

  • Get an in-depth understanding of Power BI and how it works in different scenarios
  • Learn about the three vital components – the Desktop, service, and Mobile apps
  • Visualize and analyze data, derive insights from Excel spreadsheet or local database
  • Create compelling reports, visualizations, derive real-time insights and deploy it on demand
  • Create, share, collaborate and benefit from business information with purpose-built dashboards
  • Know how to get work done without being a Business Intelligence professional
  • Use Salesforce Data, Azure SQL Database & SQL server analysis tabular data
  • Deploy content packs to work with Quick Books online and Adobe analytics
  • Complete live Projects on Power BI to get hands-on experience.Learn to work with HDFS.

Course Duration

  • 6-8 Weekends

Prerequisites :

  • You don’t need any prior knowledge to benefit from this Power BI training.

Who Should Attend?

  • Individuals looking for jobs as Business Analysts, Business Development Manager, etc
  • Statisticians aiming to implement their statistics skill to derive business insights
  • Marketing, Finance, Sales, and other domain individuals who need extensive business intelligence.

Course

1.1 Introduction PowerPivot

  • Introduction to software Testing
  • Introducing PowerPivot
  • PowerPivot overview
  • Understanding corporate and personal BI
  • Understanding PowerPivot models
  • Creating a basic PowerPivot model Introducing PowerPivot for SharePoint
  • Sharing PowerPivot models

1.2 Data Importing

  • White Box Testing
  • Importing from multi-dimensional data sources
  • Working with Data Importing from relational data sources
  • Importing data from databases
  • Importing flat files Importing from Excel Copying and pasting data
  • Importing from reports and data feeds Lab 2: Importing from other data sources

1.3 Enhancing the Data Model

  • Enhancing the Data Model
  • Understanding PowerPivot data types
  • Performing column operations
  • Working with columns
  • Understanding table relationships
  • Understanding data refresh
  • Working with relationships

1.4 Analyzing Data Understanding

  • Analyzing Data Understanding
  • Understanding PivotTable and PivotChart
  • Understanding PowerPivot Field List
  • Creating PivotTable and PivotChart reports
  • Understanding slicers Handling metadata issue and changes Using other Excel features
  • Implementing dashboards
  • Working with dates, hierarchies, and perspectives
  • Implementing end-user features

1.5 Data Analysis Expressions 

  • Understanding Data Analysis Expressions
  • Understanding row and filter context
  • Understanding calculated columns
  • Implementing calculated columns
  • Understanding measures
  • Understanding measure functions
  • Implementing measures and KPIs
1.6  Publishing and Managing PowerPivot Models

  • Understanding PowerPivot for SharePoint Publishing to SharePoint
  • Viewing published models
  • Publishing models and authoring reports
  • Managing data refresh
  • Understanding PowerPivot Management
  • Managing PowerPivot models

1.7  Importing Data with Power Query

  • Introducing Power Query
  • Understanding Power Query elements Viewing published models
  • Importing and transforming data
  • Understanding query sharing Discovering queries
  • Sharing and discovering queries

1.8 Importing Data with Power Query

  • Introducing Power Query
  • Understanding Power Query elements
  • Viewing published models
  • Importing and transforming data
  • Understanding query sharing Discovering queries
  • Sharing and discovering queries

1.9 Analyzing Data with Power View and Power Map

  • View Understanding Power View visualizations
  • Understanding Power View filtering options
  • Implementing Power View reports
  • Introducing Power Map Preparing geospatial data
  • Understanding Power Map visualizations
  • Geospatial reporting with Power Map

FAQ

Power BI is a cloud-based data sharing environment. Once you have developed reports using Power Query, Power Pivot and Power View, you can share your insights with your colleagues. This is where Power BI enters the equation. Power BI, which technically is an aspect of SharePoint online, lets you load Excel workbooks into the cloud and share them with a chosen group of co-workers.

Classes are held on weekdays and weekends. You can check available schedules and choose the batch timings which are convenient for you.

Towards the end of the course, all participants will be required to work on a project to get hands on familiarity with the concepts learnt. This project will be reviewed by our instructors and industry experts. On successful completion, you will be awarded a certificate.

Quick Enquiry