Power bi Training

Powerbi Training in Dilsukhnagar Hyderabad

5 Ratings (245 Reviews)

TMS Data Science Offers Power BI Course in Dilsukhnagar Hyderabad.  

Power Bi Course Content

Preparing for Power BI

  • Version of Excel needed
  • Installing add-ins
  • Basic multi-table pivot tables

PowerPivot data models

  • Importing SQL Server tables
  • Filtering rows & also columns
  • Data and also diagram view
  • Hiding from client view
  • Relationships

Pivot tables using PowerPivot

  • Drill-down vs Quick Explore
  • Slicers and also timelines
  • Controlling what you see

Using Excel tables

  • Creating and also naming tables
  • Adding to data models

Using other data sources

  • Importing Access and also Excel
  • Importing cubes
  • Pasting from the clipboard

Power Query sources

  • Querying databases
  • Web pages and also XML files

Transforming data in Power Query

  • Splitting columns
  • Merging and also inserting columns
  • Other transforms

Calculated columns

  • Creating calculated columns
  • Using the RELATED function
  • BLANK and also SWITCH

Calculated fields (measures)

  • The all-important query context
  • Implicit calculated fields
  • AutoSum fields
  • Creating in Excel and also PowerPivo

DAX basics

  • The DAX Studio add-in
  • Calculating ratios
  • Aggregate X functions

The CALCULATE function

  • Replacing filters
  • Using ALL
  • Using VALUES to edit filters

More advanced DAX functions

  • Using FILTER to filter tables
  • Ranking
  • The EARLIER function

Calendars

  • Creating in Excel or SQL
  • Linking to calendars
  • Sorting months & also weeks
  • Multiple date tables

Date functions

  • Period to date
  • Fiscal year calculations
  • Parallel periods
  • Semi-additive measures

Hierarchies

  • Creating hierarchies
  • Pros and also cons

KPIs

  • Relative KPIs
  • Absolute KPIs

Power View basics

  • The data model again
  • Creating visualisations

Power View Filters

  • Slicers
  • Using tiles
  • Filtering data

Other visualisations

  • Creating matrices and cards
  • Chart multiples
  • Chart drill-down
  • Scatter and also bubble charts

The Power View maps

  • Assembling your data
  • Creating maps
  • Drill-down in maps

The Power Map (GeoFlow)

  • Creating maps
  • Scenes, tours and also layers
  • Creating videos
  • Reasons not to use

Power BI Course Training Institute in Dilsukhnagar Hyderabad