Complete Business Intelligence with SSIS, SSAS and SSRS
4.4 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
564 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Complete Business Intelligence with SSIS, SSAS and SSRS to your Wishlist.

Add to Wishlist

Complete Business Intelligence with SSIS, SSAS and SSRS

Master Microsoft BI by solving Real-Life Problems. Learn ETL, Integration, Analytics, Reporting and Visualization!
4.4 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
564 students enrolled
Last updated 8/2017
Curiosity Sale
Current price: $10 Original price: $100 Discount: 90% off
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
  • Basic SQL and Data warehousing concepts

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.

We will Learn from the basics of creating a Business Intelligence 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

Learn and Master Microsoft Business Intelligence 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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
34 Lectures
Setting up your Microsoft BI environment
6 Lectures 19:12
SSIS Control Flow Tasks
10 Lectures 44:39

Create your first FTP task to get data from the server to a destination server or your local machines.

FTP Server File download using SSIS

Look around the visual studio interface and get accustomed to the numerous window panes that will help you through out the course to navigate.

Creating new package and a look around the interface

Create and Configure the File system task to move a file internally from a source folder or server to a destination folder or server.

Move files using a File System Task

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.

Creating a table in SSMS using a Execute SQL Task

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).

Inserting into the new table and truncate the old table using Execute SQL Task

Lear how to take a Back up of your Databases by using the Backup Database Task.

Take Backup of Database using the Backup Database Task

Learn about user defined variables, how to create and configure them.

Variables: Create a new user defined variable

Create a File system task to help us understand the concept of variables.

Variables: Create a new file system task

Learn how to establish a logical connection between the User Defined Variable and the File System Task with the help of Properties.

Variables: Establishing a logical connection between Variables and File Sys Task

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.

Copy 'n' number of files using the Foreach Loop container
SSIS Data Flow Tasks
8 Lectures 41:40

Learn the basic difference between Control flow and Data Flow. Get accustomed to the Data Flow task and its components.

Introduction to Data Flow Tasks and its components

Transfer Data from a Flat File Source to an OLE-DB Destination

Performing Aggregates.

Storing aggregated data in a table using OLEDB Destination

Performing a Conditional Split

Sorting data in ascending or descending order

Creating a Derived column

Performing data merge with two ways to sort the data
SSAS : Designing Cubes for Analysis
10 Lectures 53:26
Creating a new project and configuring a Data source for SSAS Cube

Creating and Understanding the Data Source View

Creating a Cube by assigning Dimensions, Measures and changing column names

Deploying and viewing the cube

Browse the cube before Deployment

Dimension Designing 1: Gathering required columns and renaming them

Dimension Designing 2: Creating Named calculated columns

Dimension Designing 3: Named Column-Getting underlyinng data of a key

Dimension Desingning 4: Grouping dimensions into logical categories

Creating a Hierarchy
About the Instructor
Business Data analyst Ikram Haq
4.5 Average rating
8 Reviews
1,947 Students
3 Courses
Business data analyst, BI Consultant

I am a Business and Data analyst  and a Business Intelligence consultant with over five years of experience in telecom, customs,finance, retail, transport and other industries. I was trained by the best analytics mentors at at top Multi national Companies, today I leverage Big Data to drive business strategy, revamp customer experience and revolutionize existing operational processes.