This class is designed for BI Specialists who want to get deeper knowledge in the field of business intelligence (BI) solutions and who want to get familiar with the BI in SQL Server 2017 suite, Power BI, and Microsoft Modern Cloud BI Solutions. The course will go trough a  case study which will be implemented from the begininng until the end. Such an approach will help attendess to get trought all the BI components and to obtain deeper knowledge of the overal BI Solution.

• BI Developers with some experience in any BI or relational database tool
• DB Developers who want to extend their knowledge in the area of developing BI solutions
• Data Engineers who need to design and architect a BI Solution

• Re-call 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
• Asses the need for advanced analyses with data mining and / or machine learning
• Deliver a simple BI solution
• Define the architecture, the design, and the tools for a more advanced BI solution

Module 1.  MS BI Data Platform on Premise and In the Cloud. Traditional and Modern DW

Module 2. Data warehousing with SQL Server. Design approaches and a case study

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. On-line analytical processing (OLAP) with SQL Server Analysis Services (SSAS) Multidimensional and tabular

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

Module 7. PBI dashboards

Module 8. Modern Cloud DW Platform Services overview

Module 9. Relational DW in the Cloud

Module 10. An introduction to ADLS, Azure Databricks and ADF

Mastering MS Business Intelligence Solutions