BI Fundamentals class

SQL Master Academy works in close partnership with SolidQ in the field of Business Intelligence trainings, due to which fact we have in our portfolio a unique programme of professional trainings in the field of Data Quality, Multidimensional Design, SSAS, ETL and SSIS. The courses train BI developers and designers of BI solutions, including back end EIM, as well as front end and reporting.

In February (05-08) you can join BI Fundamentals class - 4 days, level 200.

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

In order to focus on the content of the labs, they should have some experience with at least some of the following tools:

  • SQL Server Management Studio
  • SQL Server Data Tools or Business Intelligence Development Studio
  • Microsoft Office Excel 2013 or later

On completion of the seminar, attendees are able to:

  • Understand the components of a BI solution
  • Create a dimensional model for a data warehouse
  • Use data warehousing components of the SQL Server Database Engine
  • Develop an extract-transform-load procedure with SQL Server Integration Services
  • Evaluate the data quality issues and define possible resolutions with Data Quality Services
  • Keep the quality of their most important data with Master Data Services
  • Author managed reports with SQL Server Reporting Services
  • Use on-line analytical processing solutions with SQL Server Analysis Services Multidimensional
  • Define simple cubes with SQL Server Analysis Services Tabular
  • Use Power Pivot to develop personal analytical database
  • Find and load external data with Power Query
  • Create ad-hoc reports from a Power Pivot model with Power Query
  • Develop geographic and temporal visualizations with Power Map
  • Use SQL Server Analysis Services for on premise data mining
  • Start programming in R for statistical analyses on premise and in cloud
  • Find patterns and make predictions with Azure Machine Learning


  1. Introduction to Business Intelligence
  2. Dimensional Data Warehouse Modeling
  3. SQL Server Data Warehousing
  4. Extract-Transform-Load (ETL) with SQL Server Integration Services (SSIS)
  5. Enhancing Data Quality with Data Quality Services (DQS)
  6. Managing Master Data with Master Data Services (MDS)
  7. Reporting with SQL Server Reporting Services (SSRS)
  8. On-line Analytical Processing (OLAP) with SQL Server Analysis Services (SSAS) Multidimensional
  9. Personal OLAP with Power Pivot
  10. Small and Medium Business (SMB) OLAP with SSAS Tabular
  11. Using Power Query to Enhance the Power Pivot Data Model
  12. AD-HOC Reporting with Power View and Power Map
  13. Power BI New Experience with Power BI Desktop and Power BI Services
  14. Data Mining with SSAS Multidimensional and Excel
  15. Introduction to R
  16. Machine Learning with Azure ML

About the trainer

Dejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant that focuses on development of database & business intelligence applications.  Besides projects, he spends about half of the 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 coauthor of twelve books about databases and SQL Server. Dejan Sarka also developed many courses and seminars for Microsoft, SolidQ and Pluralsight.

As an MCT, Dejan Sarka speaks on many local and international events. Some of the international events include conferences such as PASS, TechEd, DevWeek, and many PASS SQL Saturdays. He is also indispensable on regional MS events, for example on the NT Conference, relatively the biggest MS conference in Central and Eastern Europe. He spoke on SQL Server 2005, 2008, 2008R2, 2012 and 2014 launch events in many countries, including Austria, Croatia, Israel, Latvia, Romania, Serbia, Slovenia and UK.

Dates: 05 Feb – 08 Feb 2018 @SQL Master Academy

For Registration: www.sqlmasteracademy.com; office@sqlmasteracademy.com; office@inspirit.bg; 0885 113 442.

Join us

0 Коментара

Остави коментар