SQL Master Academy works in close partnership with SolidQ in the field of Business Intelligence trainings, due to which fact we also 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.

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

• 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

Module 1.  Introduction to BI

Module 2.  Dimensional data warehouse (DW) modeling

Module 3.  SQL Server data warehousing

Module 4.  Extract-transform-load (ETL) with SQL Server Integration Services (SSIS)

Module 5.  Enhancing data quality with Data Quality Services (DQS)

Module 6.  Managing master data with Master Data Services (MDS)

Module 7.  Reporting with SQL Server Reporting Services (SSRS)

Module 8.  On-line analytical processing (OLAP) with SQL Server Analysis Services (SSAS) Multidimensional

Module 9.  Personal OLAP with Power Pivot

Module 10.  Small and medium business (SMB) OLAP and SSAS Tabular

Module 11.  Using Power Query to enhance the Power Pivot data model

Module 12.  Ad-hoc reporting with Power View and Power Map

Module 13.  Power BI new experience with Power BI Desktop and Power BI Services

Module 14.  Data mining with SSAS Multidimensional and Azure ML

Module 15.  Introduction to R

Module 16.  Machine learning with    Python

BI Fundamentals ENG