Beyond Excel II.

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. 

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

 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

Previous courses

Microsoft Excel – Advanced Methods and Functions [MSEX3]

Beyond Excel [MSEXNL]

Related courses

Microsoft Excel – Data Analysis and Statistic Calculations [MSEXST1]