POWER BI Desktop Training

  • Import data from diverse sources
  • Creating dashboards and reports
  • Installing Power BI desktop
  • Adding matrix, column chart and cards
  • Adding slicer
  • Adding pages
  • Renaming pages
  • Moving pages
  • Importing excel and power view items

Data sources

  • File sources
  • Databases
  • Azure and other sources

Loading data

  • Web pages
  • CSV files
  • XML files
  • Excel

Relational Databases

  • Loading related tables
  • Database options
  • Microsoft SQL Server Analysis Services data sources, tabular data sources
  • Refreshing query/all the queries in a Power BI desktop file
  • Power BI desktop queries

    • Editing data after data load
    • Transforming data

    Query editor and ribbons

    Dataset shaping

    Filtering data

    Changing datatype

    Replacing values

    Transforming column contents

    Grouping records

    Extending data

    • Duplicating columns
    • Splitting columns
    • Merging columns
    • Custom columns
    • Merging data

    Appending data

    • Adding contents of one query to another
    • Pivoting and un pivoting tables
    • Transposing rows and columns

    Managing queries

    • Grouping queries
    • Duplicating queries

    Data modeling in Power BI desktop environment

    Data modeling ribbon

    Manipulating tables and columns

    Sorting data

    Designing a data model

    • Creating relationships
    • Creating relationships manually/automatically
    • Deleting relationships
    • Measures
    • Calculated columns
    • Using different DAX functions for measures and calculated columns
    • Calculated tables
    • Aggregation functions
    • X Aggregate functions
    • Count functions
    • Logical functions
    • Divide functions
    • Text functions
    • Date functions
    • Using variables inside DAX functions
    • Table relationships like Related and Related Table
    • Generate series function
    • Basic aggregations in measures
    • Multiple measures
    • Cross table measures
    • Advanced aggregations
    • Filtering data in measures
    • Simple filters and complex filters

    Switching to report view

    Tables

    • Table granularity
    • Matrix, cards, multirow cards
    • Creating a chart
    • Chart modifications
    • Column charts, line charts and pie charts
    • Donut charts
    • Funnel charts
    • Water fall charts
    • Maps
    • Filled maps
    • Tree maps
    • Gauges
    • Visual level filters
    • Filtering different data types
    • Advanced text filters
    • Page level filters
    • Report level filters
    • Slicers
    • Formatting slicers
    • Using charts as slicers
    • Text boxes
    • Modifying Page background
    • Images
    • Adding shapes
    • Organizing visuals on the page
    • Exporting data from a visualization
    • POWER BI Dashboards
    • Reports
    • Datasets
    • Content packs
    • Work groups
    • Gateways
    • Q&A
    • Insights