Introduction to Microsoft Business Intelligence

Course Summary

Training levelBI Course
Duration3 days / 24 Hours
Delivery methodIn Class
List price490 Euro VAT Excl.

Click Tabs for Detailed info

Get understanding of the components of a business intelligence solution from an enterprise to a personal level, from simple to the most advanced types of analyses, and get familiar with the Microsoft tools.

Attendees should have basic understanding of data analysis and relational data models. They should have experience with at least some of the following tasks:

  • Reporting from a line of business system
  • On-line analytical processing
  • Data warehousing
  • Data quality
  • Describe data warehousing components of the SQL Server Database Engine
  • Understand benefits and limitations of reporting with SQL Server Reporting Services
  • Define the role of SQL Server Integration Services in the extract-transform-load procedures
  • Evaluate the data quality issues and possible resolutions
  • Make a decision when to switch from reporting to on-line analytical processing
  • Find the role of personal business intelligence in their ecosystems
  • Asses the need for advanced analyses with data mining and / or machine learning
  • Decide upon the direction of their education and about next courses they want to take
  • Module 1: Introduction to business intelligence
  • Module 2: Data warehousing with SQL Server
  • Module 3: Extract-transform-load (ETL) with SQL Server Integration Services (SSIS)
  • Module 4: Enhancing and maintaining data quality with Data Quality Services (DQS) and Master Data Services (MDS)
  • Module 5: Reporting with SQL Server Reporting Services (SSRS)
  • Module 6: On-line analytical processing (OLAP) with SQL Server Analysis Services (SSAS) Multidimensional
  • Module 7: Small and medium business (SMB) and personal OLAP with SSAS Tabular and Power Pivot
  • Module 8: Personal ETL and EIM with Power Query and Excel with MDS and Fuzzy Lookup Add-ins
  • Module 9: SMB and personal ad-hoc reporting and creating dashboards with Power View, Power Map, Power BI Services, and Power BI Desktop
  • Module 10: Data Mining and machine learning with SSAS Multidimensional, Excel, R, and Azure ML

Next planing dates:

Trainer: Dejan Sarka


Reserve your seat

Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date