Data Analysis with Power BI and SQL Server

3 days /24 hours | online / onsite

Advanced Analytics with Power BI and Excel with more emphasis on data warehousing and the ETL process, which people tend to neglect when dealing with Power BI.

What Does this Course Cover?

Business intelligence (BI) and even advanced analytics (AA) are the key influencers from the IT area on all main business types. We turn data into information which helps us towards better results. This course introduces two key BI components from the infrastructure and services point of view – SQL Server and Power BI. However, unlike the majority of courses, presentations and texts, this course does not focus on the glorious pars of a BI project only. It teaches the attendees also about the dirty work that is commonly hidden, but enormously important.

The course introduces the theoretical background for data warehousing (DW) and the logical data models used. However, the course dwells deeply also in the dirty work. The delegates learn about the extract – transform – load (ETL) process and explains how to optimize in in SQL Server and on Power Query side. Then the course explains how to create an efficient Power BI data model. The attendees also learn how to create reports and publish them in Power BI Service. A long module is dedicated to AA in Power BI. The course wraps up with a holistic view on end-to-end performance from source queries through DW and ETL to Power BI data models and reports.

Next Dates

27/05/2024 – 29/05/2024; Vienna, onsite; EUR 2.390,00  register

Prerequisites

Attendees should be familiar with Excel and have at least basic T-SQL knowledge.

Course Outline

  1. Introduction to business intelligence (BI)
  2. Data modeling for analytical applications
  3. Data warehousing with MS SQL Server
  4. Columnar storage advantages analysis
  5. Introducing Power BI
  6. Extract – transform – load (ETL) process with T-SQL and Power Query
  7. Using Excel for BI
  8. Data model in Power BI
  9. Creating reports with Power BI Desktop
  10. Publishing reports with Power BI Service
  11. Administering a Power BI solution
  12. Data science in Power BI
  13. Power BI model and reports optimization

Dejan Sarka

Trainer & Author

Dejan Sarka focuses on database & business intelligence application development. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of nine books on databases and SQL Server (including training kits for Microsoft exams 70-461 and 70-463). Dejan Sarka also developed several courses for Lucient. As an MCT, Dejan Sarka speaks at many local and international events. International events include conferences such as PASS, TechEd, and DevWeek. He is also indispensable at regional MS events. In addition, he is a co-organizer of the high-profile technical conference Bleeding Edge.