English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 4 Hours | 660 MB
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.
This course will help you get hands-on with Business Intelligence best practices in a step-by-step way.
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
Table of Contents
Setup and Installation of SQL Server Environment
1 The Course Overview
2 Preparing Your Computer for SQL Server
3 Step by Step Procedure on Properly Installing SQL Server
4 Setting Up Your Report Server for SQL Server Reporting Services
5 Installation of SSDT
Get Familiarized and Create SSIS
6 SSIS Introduction
7 Familiarization of SSIS Environment
Implement and Execute SSIS
8 How to Implement the Use of Control Flow and Looping
9 How to Implement Data Flow and Data Flow Transform
10 How to Implement Functions
11 How to Execute SSIS Package with SQL Server Agent
Get Familiarized and Create SSAS
12 SSAS Introduction
13 MDX
Implement and Execute SSAS
14 Calculations, Dimension, and Cube Designs
15 Perspective, Actions and Security Implementation
Get Familiarized and Create SSRS
16 Planning a Report and Design Tips(Data Source, Data Sets and Report)
17 Creating a Basic Report with Header, Footer, Matrix, Charts, and Data Bars
18 Creating a Basic Report with Gauge, Indicators, and Maps
19 Creating Sub Reports with Report Parameters
Implement and Execute SSRS
20 Implementation of Custom Code and Calculated Fields
21 Implementation of Drilldown Matrix Reports and Lookup
22 Executing Report using Report Manager to Deploy Reports Using BIDS and Subscriptions
Resolve the captcha to access the links!