Complete Business Intelligence with SSIS, SSAS and SSRS

Name: Complete Business Intelligence with SSIS, SSAS and SSRS
Rating: 4.2 (371 reviews)

Master Microsoft BI by solving Real-Life Problems. Learn ETL, Integration, Analytics, Reporting and Visualization!

Created byIkram Haq

Last updated 11/2017

English

What you'll learn

Perform file system tasks
Perform FTP tasks
Create dynamic properties with variables
Perform ETL jobs (Extraction, Transformation and Loading)
Perform Aggregates, Sorting and Conditional Splitting of data
Create analytic cube in SSAS
Design the Cube Dimensions and Measures

Course content

5 sections • 38 lectures • 2h 52m total length

Downloading the right file for installation2:34
Installation guide for SQL Server Management Studio 20144:01
Learn how to install and configure SQL Server Express on your PC from start to finish
Installing Visual Studio SSDT-BI2:29
Setup Adventure Works DW 2012 for Analytic Services Practice2:17
Create a new database and a new table in ssms3:10
How to Insert, truncate and drop a table?4:41

FTP Server File download using SSIS5:55
Create your first FTP task to get data from the server to a destination server or your local machines.
Creating new package and a look around the interface2:48
Look around the visual studio interface and get accustomed to the numerous window panes that will help you through out the course to navigate.
Move files using a File System Task6:31
Create and Configure the File system task to move a file internally from a source folder or server to a destination folder or server.
Creating a table in SSMS using a Execute SQL Task4:40
Learn how to create a table using an Execute SQL task from SSIS itself in SQL Server Management Studio. Use the script provided in additional resources. You can also write your own script for practice.
Inserting into the new table and truncate the old table using Execute SQL Task6:32
Use the same Execute SQL Task to insert and truncate into a table in a sequential manner by making use of the precedence constraints( green arrows).
Take Backup of Database using the Backup Database Task3:51
Lear how to take a Back up of your Databases by using the Backup Database Task.
Variables: Create a new user defined variable3:58
Learn about user defined variables, how to create and configure them.
Variables: Create a new file system task2:45
Create a File system task to help us understand the concept of variables.
Variables: Establishing a logical connection between Variables and File Sys Task3:35
Learn how to establish a logical connection between the User Defined Variable and the File System Task with the help of Properties.
Copy 'n' number of files using the Foreach Loop container4:04
Want to move or copy numerous files without knowing the exact number and by avoiding to create multiple connection managers. Foreach loop helps us to do exactly this. Learn how to in-cooperate it with Variables and Files system task.

Introduction to Data Flow Tasks and its components3:13
Learn the basic difference between Control flow and Data Flow. Get accustomed to the Data Flow task and its components.
Transfer Data from a Flat File Source to an OLE-DB Destination7:54
Performing Aggregates.4:03
Storing aggregated data in a table using OLEDB Destination3:06
Performing a Conditional Split6:42
Sorting data in ascending or descending order3:10
Creating a Derived column6:15
Performing data merge with two ways to sort the data7:17

Creating a new project and configuring a Data source for SSAS Cube5:06
Creating and Understanding the Data Source View7:51
Creating a Cube by assigning Dimensions, Measures and changing column names8:08
Deploying and viewing the cube5:30
Browse the cube before Deployment2:18
Dimension Designing 1: Gathering required columns and renaming them7:16
Dimension Designing 2: Creating Named calculated columns4:05
Dimension Designing 3: Named Column-Getting underlyinng data of a key4:34
Dimension Desingning 4: Grouping dimensions into logical categories6:14
Creating a Hierarchy2:24

Requirements

Basic SQL and Data warehousing concepts

Description

*** This course includes LIFETIME access, More content is being developed,quality of lectures are a 100% satisfaction guarantee ***

Reviews from some of our students

"I had little knowledge about Business Intelligence. But after attending this course and practising the examples. I can now do BI solutions on my own."

-Edwin Molapo

"Great course. I am in College currently getting my BA in Data Analytics and this course has help solidify my learning and also helped me with projects we had in our classes. I would highly recommend for and Business Intelligence seekers "

-Jared Rentz

"Easy to follow and very understandable"

-Dilli Sharma

As data volumes are exploding, more data has been created in the past two years than in the entire previous history of the human race. With an estimate of 4.1 zettabyets of data available today, the numbers just keeps increasing every second. Organizations today estimate that only a fraction of recorded data can be analyzed, and IT professionals who can work with data by Data Integration, Data Analyzation, Data Visualization etc. in short a 'Data Geek' are becoming increasingly popular.

In Simpler terms, there is enormous amount of data and not enough professionals to manage it.This course aims to close that gap with SQL Server Management Studio and SQL Server Data Tools for Business Intelligence (BI).

We will Learn from the basics of creating a Microsoft Business Intelligence (MS BI)ecosystem, Sql server Integrating services(SSIS), Sql Server Analysis Services (SSAS), Sql Server Reporting Services (SSRS) and putting all of them together to learn the Complete Microsoft Business Intelligence (MS BI)

Learn and Master Microsoft Business Intelligence(MS BI) in this Comprehensive course.

SSIS(Sql Server Integrating Services)

Extracting Data from Source.
Transforming the Data in a staging area
Loading the data onto a destination
Managing different types of sources and destinations
Implementing aggregates and transformations
Managing data flow and control flow tasks
SSAS(Sql Server Analysis Services)

Configuring analysis services
Creating a cube
Managing data in the data source view
Designing and deploying Cube dimensions and meassures
SSRS(Sql Server Reporting Services)

Creating reports and visualizations
With 6 years of experience in the BI, Data analytics and Big Data, be sure to get rich content to help you succeed. Although it is still in the beginning phase but more in depth and quality lectures are being added regularly.

Who this course is for:

Fresh graduates looking for a job as a BI developer
Any working individual willing to switch career path to BI and looking for that breakthrough
BI developers who are willing to learn a new tool

Complete Business Intelligence with SSIS, SSAS and SSRS

What you'll learn

Explore related topics

Course content

Setting up your Microsoft BI environment6 lectures • 19min

SSIS Control Flow Tasks10 lectures • 45min

SSIS Data Flow Tasks8 lectures • 42min

SSAS : Designing Cubes for Analysis10 lectures • 53min

SSRS: Understanding report creation, management and deployment4 lectures • 14min

Requirements

Description

Who this course is for: