Implementing Business Intelligence with SQL Server 2019

Gain best practices and strategy in Business Intelligence using SQL Server

In the course, you will cover topics including Business Intelligence fundamentals, data warehousing and ETL, data governance, data visualization, Power BI, data mining, SSAS, SSIS, and Azure Data Analysis Services, with each covering a section of the Microsoft BI with SQL Server 2017. You will get more hands-on with reporting and making sense out of your business intelligence data with SQL Server.

The course will not only help you implement BI Data warehousing solutions, but will also enable you to provide data solutions with SQL Server Integration Services covering Enterprise Suite for data governance, improving data quality, and master data management. By the end of this course, you will be confident enough to create your own Microsoft BI solutions with components such as SSIS for ETL, SQL Server for Data Warehouse, SSAS for OLAP modeling and data mining, and SSRS for reporting.

The course will not only help you in implementing BI; Data warehousing solutions, but will also enable you to provide data solutions with SQL Server Integration Services covering Enterprise suit for data governance, improving data quality, and master data management. By the end of this course, you will be able confident in creating your own Microsoft BI solutions with components such as SSIS for ETL, SQL Server for Data Warehouse, SSAS for OLAP modeling and data mining, and SSRS for reporting.

What You Will Learn

Use SSDT (SQL Server Data Tools) in detail to develop SSIS packages, implement cubes using SSAS, and create reports using SSRS
Learn about SSIS, SSAS, and SSRS architectures and components
Understand different control flow tasks, containers, and precedence constraints
Understand a wide variety of data flow sources, transformations, and destinations
Learn to work with variables, data types, functions, expressions, and parameters and provide Dynamism in SSIS
Develop packages using different tasks and different transformations based on real-time requirements
Create reporting servers
Read data from dimensional models using SSAS
Create dimensions, hierarchies, and cubes
Create real-time enterprise deployment and publishing reports
Implement report manager security and permissions
Power BI implementation and application