Implementing Business Intelligence with SQL Server 2019 [Video]

More Information
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
About

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.

Style and Approach

This course will help you get hands-on with Business Intelligence best practices in a step-by-step way.

Features
  • Understand basic Data Warehousing, OLTP, and OLAP.
  • Use SSDT (SQL Server Data Tools) to develop SSIS packages and design reports.
  • Learn about SSIS, SSAS, and SSRS architectures and their components.
Course Length 3 hours 43 minutes
ISBN 9781789804843
Date Of Publication 31 Jan 2019

Authors

Jess Dale Dela cruz

Jess Dale Dela cruz has more than a decade of experience in C#, .NET, and SQL. After obtaining his master’s degree in computer science, Jess has worked as a professor, trainer, project manager, and tech lead in various organizations. For the last five years, he has worked as a team lead for a team that specializes in SharePoint and .NET Development. He specializes in AWS and Microsoft SQL Server.