POWER BI

 

Overview

Power BI can unify all of your organization’s data, whether in the cloud or on-premises. Using the Power BI gateways, you can connect SQL Server databases, Analysis Services models, and many other data sources to your same dashboards in Power BI. It connects users to a broad range of data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life.

Microsoft Power BI has been replaced with a far more powerful version which covers Power BI Desktop, Power BI Pro which combines Power BI Services, and Mobile into a formidable business intelligence and analytics package.

Prerequisites

  • Basic knowledge of Microsoft Windows operations systems and its core functionality
  • Working knowledge of business data and its relations

Audience

  • Students
  • Business and Financial Analytics
  • Database Administrator
  • Data Analyst
  • IT Professionals

 


For More
Information

    Course  Contents

    Module 1

    Introducing to Power BI and Its Components
    Introduction to Power BI: What is Power BI?
    Power BI Desktop: The First Experience
    Power BI Website: You’ll Need Just a Web Browser
    Introduction to Power BI Components: Power Query, Power Pivot, Power View and Power Map.

    Module 2

    Connecting to data sources (Databases, CSV & XLS files)
    What is Power Query: Introduction to Data Mash-Up Engine of Power BI
    Get Started with Power Query: Movies Data Mash-Up
    Power BI Get Data From Excel: Everything You Need to Know
    Definitive Guide to Power BI Personal Gateway
    File Sources
    Folder as a Source
    Database Sources
    Analysis Services Connection
    Software as A Source

    Module 3

    Data Transformation through Power Query
    Installation, Requirements, and Configuration
    Different versions of Power Query
    Power Query Introduction
    Query Editor
    Transformation GUI
    Row Transformations
    Column Transformations
    Data Type
    Adding Column
    Text Transformations
    Number Column Calculations
    Date and Time Calculations
    Data types, Lists, Records, and tables in M
    Writing Custom Functions
    Error handling
    Advanced Data Transformations with M

    Module 4

    Data Visualizations & Modeling

    Charts, Scorecards, and other visualization items in Power View Sorting, Filtering, copying, pasting and categorization with Power View Modelling data, and relationships
    Creating calculated measures
    Power Pivot difference
    Visualizing data
    Power View difference Custom Visuals Power View for SharePoint
    Power View for Excel
    Data visualization with Map
    Power BI Report Server

    Module 5

    Sharing and Deployment dashboards

    Office 365 Power BI embedded in applications Deployment of files into Power BI websiteDeployment of files into Power BI On Premises

    Deployment of files into Power BI On CloudShare Dashboard with Mobile apps for Power BI on Apple and AndroidPower View for SharePoint

    Module 6

    Managing Security to access data and Administration

    Office 365 Administration
    Building dashboards in Power BI website
    Configuration roles and administration on Power BI website