POWER BI

For what reason should you take Power BI course ? Microsoft – A pioneer in the Gartner Magic Quadrant for BI and Analytics Platforms for 2017 Power BI experts acquire upto $114,000 every year

About the Course:

Microsoft Power BI Training will enable you to accomplish skill in business examination administrations given by Microsoft. You’ll ace the ideas about Power BI Desktop, Power BI DAX, SSRS, Power BI Q&A, Power BI Content packs, Power BI Custom Visuals, Power BI Integrations and Machine Learning in Power BI with Azure Integration

Chapter 1: Introducing Power BI

  • Introduction to Power BI
  • Getting started with Power BI
  • Power BI Installation
  • Introducing natural-language queries
  • Introducing Quick Insights
  • Introduction to Report and Report Design
  • Introducing Visual Interactions
  • Power BI Desktop & Power BI Services
  • Building blocks of Power BI
  • Understanding Desktop & Mobile Editions
  • Report Rendering Options and End User Access

Data Flow and Work Flow Architecture

Chapter 2: Creating Power BI Reports

  • Report Design using TXT, CSV, xlsx
  • Report Design using Databases & Queries
  • Repot Data Sources and Dataset Queries
  • Query Settings and Data Preloads
  • Dataset Properties and Report Fields
  • Navigation Options and Report Refresh
  • Computed Columns & Column Splits
  • Working with external data sources
  • Working with import and direct query
  • Creating custom table in the Power BI
  • Merge Queries and Append Queries
  • Remove columns and split columns

Choosing required columns in the data

Chapter 3: Report Customizations & Parameters

  • Working with Data Visualizations & Cards
  • Tables, Matrix, Charts, Bars, Sparkline, Pie, Maps
  • Creating and Working with Parameters
  • Dynamic and Dependant Parameters
  • Static and Dynamic Filters – Usage Options
  • Navigator Options and Parameter Mapping
  • Creating and Working with groups
  • Managing the null values and errors
  • Managing data types in Query editor
  • Column Delimiters and Relationships Management

Chapter 4: Report Dashboards & Data Refresh

  • Publishing Reports to PowerBI Account
  • Dashboards and Pinning Options
  • Dynamic Data Sources and Encryptions
  • Dashboards from multiple reports
  • Installing the Power BI Personal Gateway
  • Configuring automatic refresh
  • Working with MY WORK SPACE group
  • Workbooks and Alerts with PowerBI
  • Applied steps in query editor

    Chapter 5: Using Power BI Desktop

    • Cube Reports with OLAP Databases
    • DAX Expressions with Power View
    • DAX Calculations and Measures
    • Improving the report by using measures
    • Integrating from multiple objects
    • Working with Power BI Views
    • Working with Data Hierarchies
    • In-built slicers and custom slicers
    • Working with reference lines
    • Working with Power pivot data model
    • Working with data modeling
    • Using DAX in data models
    • Working with DAX Functions
    • Calculated Measures & Parameters with DAX
    • Creating high-density reports
    • Working with Pivot & Unpivot columns

    Different external data source

    Chapter 6: Data from Services & Content Packs

    • Consuming a service content pack
    • Creating a custom data set from a service
    • Working with Pivot & Un Pivot columns
    • Creating index and custom columns
    • Group By functionality in Query Editor
    • Applied steps in query editor
    • Managing Gateways & Content Packs
    • Defining relationships between tables
    • Creating a custom table with range
    • Publishing a report to Power BI Services
    • Power BI as a Service
    • Creating high-density reports
    • Creating custom visualizations for Power BI

    Pushing Real-time data to Power BI

    Chapter 7: Improving Power BI Reports

    • Data from multiple Data Sources
    • Reports from various data sets
    • Dashboards from multiple reports
    • Working with MY WORK SPACE group
    • Creating Groups & Working
    • Managing Gateways & Content Packs
    • Adding tiles to the Dash Boards
    • Adding images to the dashboards
    • Working with all visualizations
    • Reading & Editing Power BI Views
    • Managing report in Power BI Services

    Scheduling refresh to the Datasets

Chapter 8: Power BI Access & Cloud

  • Getting data from existing systems
  • Data refresh and live connections
  • Using relational databases on-premises
  • Using live connections to Analysis Services
  • Integrating Power BI with Office
  • Publish Excel data models in Power BI
  • Consume Power BI content from Excel
  • Using Power BI Tiles from Office Store
  • Managing security to access data
  • Using row-level security & User Access
  • Extending and customizing Power BI

Power BI embedded in applications

GPS INFOTECH (Software Solutions)
Url: https://www.gpsinfotech.com
Contact person: prakash
Num: 919395190232 / 9989787231 with Whatsapp
Main mail id : gpsinfotech.net@gmail.com , prakash_m@gpsinfotech.com