Complete Business Intelligence with SSIS, SSAS and SSRS

Complete Business Intelligence with SSIS, SSAS and SSRS, available at $44.99, has an average rating of 4.35, with 41 lectures, based on 363 reviews, and has 2247 subscribers.

You will learn about 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 This course is ideal for individuals who are Fresh graduates looking for a job as a BI developer or Any working individual willing to switch career path to BI and looking for that breakthrough or BI developers who are willing to learn a new tool It is particularly useful for Fresh graduates looking for a job as a BI developer or Any working individual willing to switch career path to BI and looking for that breakthrough or BI developers who are willing to learn a new tool.

Enroll now: Complete Business Intelligence with SSIS, SSAS and SSRS

Summary

Title: Complete Business Intelligence with SSIS, SSAS and SSRS

Price: $44.99

Average Rating: 4.35

Number of Lectures: 41

Number of Published Lectures: 38

Number of Curriculum Items: 41

Number of Published Curriculum Objects: 38

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Setting up your Microsoft BI environment

Lecture 1: Downloading the right file for installation

Lecture 2: Installation guide for SQL Server Management Studio 2014

Lecture 3: Installing Visual Studio SSDT-BI

Lecture 4: Setup Adventure Works DW 2012 for Analytic Services Practice

Lecture 5: Create a new database and a new table in ssms

Lecture 6: How to Insert, truncate and drop a table?

Chapter 2: SSIS Control Flow Tasks

Lecture 1: FTP Server File download using SSIS

Lecture 2: Creating new package and a look around the interface

Lecture 3: Move files using a File System Task

Lecture 4: Creating a table in SSMS using a Execute SQL Task

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

Lecture 6: Take Backup of Database using the Backup Database Task

Lecture 7: Variables: Create a new user defined variable

Lecture 8: Variables: Create a new file system task

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

Lecture 10: Copy 'n' number of files using the Foreach Loop container

Chapter 3: SSIS Data Flow Tasks

Lecture 1: Introduction to Data Flow Tasks and its components

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

Lecture 3: Performing Aggregates.

Lecture 4: Storing aggregated data in a table using OLEDB Destination

Lecture 5: Performing a Conditional Split

Lecture 6: Sorting data in ascending or descending order

Lecture 7: Creating a Derived column

Lecture 8: Performing data merge with two ways to sort the data

Chapter 4: SSAS : Designing Cubes for Analysis

Lecture 1: Creating a new project and configuring a Data source for SSAS Cube

Lecture 2: Creating and Understanding the Data Source View

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

Lecture 4: Deploying and viewing the cube

Lecture 5: Browse the cube before Deployment

Lecture 6: Dimension Designing 1: Gathering required columns and renaming them

Lecture 7: Dimension Designing 2: Creating Named calculated columns

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

Lecture 9: Dimension Desingning 4: Grouping dimensions into logical categories

Lecture 10: Creating a Hierarchy

Chapter 5: SSRS: Understanding report creation, management and deployment

Lecture 1: What is SSRS?

Lecture 2: Life Cycle of a Report

Lecture 3: Getting started and looking at the Reporting Services interface

Lecture 4: Connecting to a Data Source using Embedded Connection

Instructors

Ikram Haq
Data analyst and BI Consultant

Rating Distribution

1 stars: 22 votes
2 stars: 21 votes
3 stars: 70 votes
4 stars: 116 votes
5 stars: 134 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu