Book Image

Implementing Business Intelligence with SQL Server 2019 [Video]

By : Jess Dale Dela Cruz
Book Image

Implementing Business Intelligence with SQL Server 2019 [Video]

By: Jess Dale Dela Cruz

Overview of this book

<p>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.</p> <p>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.</p> <p>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.</p> <h1>Style and Approach</h1> <p>This course will help you get hands-on with Business Intelligence best practices in a step-by-step way.</p>
Table of Contents (7 chapters)
Chapter 2
Get Familiarized and Create SSIS
Content Locked
Section 1
SSIS Introduction
Data extraction, transformation and loading can be difficult. SQL Server make it easier. So, what exactly is SSIS? - Deploy Integration Services Project - Create a successful Database Connection under server - Convert and transform data