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