10989 MOD Analyzing Data with Power BI

This course provides students with the knowledge and skills to analyze data with Power BI.

Difficulty
Rating
900,00 

Language: English

Or contact sales: +358 20 7776 670 or myyntipalvelu@sovelto.fi

This course requires that you meet the following prerequisites:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming concepts (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel.

These prerequisites can be achieved by attending courses :

  • 20761A – Querying Data with Transact-SQL
  • 20767A – Implementing a SQL Server Data Warehouse

Materiaali: This course is delivered as MOC on Demand.

Module 1: Introduction to Self-Service BI Solutions

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI

Module 2: Introducing Power BI

  • Power BI
  • The Power BI service
  • Power BI mobile apps

Module 3: Power BI Data

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service

Module 4: Shaping and Combining Data

  • Power BI desktop queries
  • Shaping data
  • Combining data

Module 5: Modelling Data

  • Relationships
  • DAX queries
  • Calculations and measures

Module 6: Interactive Data Visualizations

  • Creating Power BI reports
  • Managing a Power BI solution

 

Keywords:

 

Places left:
No participant limit
900,00  + VAT

Responsible person


Pekka Korhonen

Pekka Korhonen

  • pekka.korhonen@sovelto.fi

SQL Server Master, Master Certified (MCSM: Data Platform), MCSE: Data Platform, MCSE: Business Intelligence, MCSA, MCTS, MCT, MCITP.