Course code: MSEXNL2« Back

Beyond Excel II.

Family of PowerBI (self-service BI) tools is rapidly expanding (PowerMap,PowerBI Desktop, DAXStudio, BI included Office 365, ...). Each of the tools is a deep set of functionalities. As a response to feedback from participants in our training Beyond Excel I. we have created a follow-up training, which focuses on new tools and instruments, as well as on known addins (PowerPivot and PowerQuery), but in much deeper scope of view. VISIT OF PREVIOUS COURSE - MSEXNL - BEYOND EXCEL I. IS STRONGLY RECOMMENDED.

Previous courses

 DateDurationCourse priceHandbook priceCourse languageLocation 
11/18/2019 2 8 000 CZK included in course price Český jazyk GOPAS Praha
 
1/30/2020 2 8 000 CZK included in course price Český jazyk GOPAS Praha
 
4/14/2020 2 8 000 CZK included in course price Český jazyk GOPAS Praha
 
1/13/2020 2 7 200 CZK included in course price Český jazyk GOPAS Brno
 
5/6/2020 2 7 200 CZK included in course price Český jazyk GOPAS Brno
 
11/20/2019 2 250,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 8 000 CZK included in course price 0
Brno2 7 200 CZK included in course price 0
Bratislava2 250,00 EUR included in course price 0

User intensity level

Previous courses

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

Previous courses

Next courses

no following course
Tištěné nebo elektronické studijní materiály GOPAS

Price:
included in course price
The prices are without VAT.