Beyond Excel II.

Who is the course for

The course is intended for all users who are already familiar with main Power BI (self-service BI) tools - PowerQuery and PowerPivot and want to knows, what are the possibilities of the visualization of PowerBI data analysis. And they also want to learn the specifics of solution based on SQL Server & Analysis services - data cubes and data mining algorithms. 

Required skills

Knowledge of PowerQuery a PowerPivot addins in the scope of MSEXNL - Beyond Excel I.

Teaching methods

Professional explanation with practical samples and examples.

Teaching materials

Printed PPT handouts.

Course outline

 Advanced functionalities of PowerQuery

• Parametrized queries
• Parametrized functions

Advanced functionalities of PowerPivot

• Advanced date & time functions

SQL Server as data provider

• OLAP cubes
• Concepts
• OLAP cube creation
• Additional Actions
• Writeback from Excel to cube

Information visualisation

• PowerView
• PowerMap
• Custom PowerMap

Power BI Desktop application

• Comparison to PowerPivot
• DAX table functions
• Standard visualisation tools
• Custom Visuals
• Access to another data model

DaxStudio

• Advantages over functions coding in PowerPivot

Office 365, Power BI section

• Data model querying in natural language
• Power BI Tiles

Datamining in Excel

• What is datamining
• Basic principles of datamining
• Different algorithms & their applications