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