MSBI

Course Description

This MSBI certification training provides you all skills needed to work with the Microsoft Business Intelligence stack. You will get proficiency in SQL Server analysis, integration, and reporting. This training will provide you enough knowledge about Data Warehousing, ETL Solutions, Connecting Managers, Transformations, and other operations. Further, you will also receive official course material issued by Microsoft for Analyzing Data with SQL Server Reporting Services.

Course Schedule

Enroll	Cost in USD	Trainer	Date	Mode	Week	Timings	Duration	Pattern
	Free	Siddharth Trainer Profile Rating and Review Trainer Name : Siddharth Trainer Skill Set: MSBI Personal info: Trainer Siddharth has more than 12 years of work experience in IT industry and also has 9 years of experience in online teaching profession. At present, he is working in MNC company as a team lead. Teaching experience: He completed more than 200 online training batches and corporate training programs. He is an excellent tutor in teaching MSBI and Datawarehouse concepts, SQL server - reporting services, integration services, analysis services and programming (T-SQL). Benefits of the trainer: Siddharth will provide sample project as part of the course structure, and he support you to practice on realtime scenarios. After the course completion, he assist you in certification preparation, resume guidance, interview preparation and conducts mock interviews as it's part of our training program.	Jul 11 2020	Live Demo	Saturday	11:30 AM EDT	1 Hour
	Free		Jul 12 2020	Live Demo	Sunday	11:30 AM EDT	1 Hour

Would you like to make your own schedule? Reschedule

Course Content

Download

Introduction to MSBI and Datawarehouse concepts

Definition of Data Warehouse
Why Data Warehouse
DWH Architecture
Star and Snowflake schema
Transaction Data
Dimension Table
Fact Table
OLTP(Online Transaction Processing System)
OLAP(Online Analytical Processing System)

SQL Server Reporting Services

Reporting Services Architecture
Core Components of SSRS Reports
Types of Reports
Basic SSRS Report
Data Sources and Shared Data Sources
Datasets and Shared Datasets
Report Parameters
Cascading parameters
Drill down Report
Drill Through Report
Report Formatting
Custom Expressions
Subscriptions
Report Manager and Report Server
Report Security
Improving Report Performance

SQL Server Integration Services

Getting started with SSIS

SSIS Overview
Import and Export Wizard
SSIS Architecture – Packages, Control Flow, Data Flow, Variables, Parameters, Error Handling and Logging
Creating a Solution and Project
Exploring SQL Server Data Tools
The SSIS Package Designer - Control Flow, Connection Managers, Variables, Data Flow, Parameters, Event Handlers, Package Explorer, Executing a Package
Creating Your First Package

Control Flow

What is Control Flow
Using Precedence Constraints
Manipulating Files with the File System Task
Coding Custom Script Tasks
Using the Execute SQL Task
Using the Execute Process Task
Using the Expression Task
Using the Send Mail Task
Using the FTP Task
Creating a Data Flow

Data Flow lesson

Extracting Data from Sources
Loading Data to a Destination
Changing Data Types with the Data Conversion Transform
Creating and Replacing Columns with the Derived Column Transform
Rolling Up Data with the Aggregate Transform
Ordering Data with the Sort Transform
Joining Data with the Lookup Transform
Auditing Data with the Row Count Transform
Combining Multiple Inputs with the Union All Transform
Cleansing Data with the Script Component
Separating Data with the Conditional Split Transform
Altering Rows with the OLE DB Command Transform
Handling Bad Data with the Fuzzy Lookup
Removing Duplicates with the Fuzzy Grouping Transform

Containers

Sequence Containers
For Loop Containers
For each Loop Container

Making Packages Dynamic

Making a Package Dynamic with Variables
Making a Package Dynamic with Parameters
Making a Connection Dynamic with Expressions
Making a Task Dynamic with Expressions

Configuring Packages

Using Configuration Tables to deploy SSIS package
Using Configuration Files to deploy SSIS package

Troubleshooting SSIS Package

Logging Package Data
Using Event Handlers
Troubleshooting Errors
Using Data Viewers
Using Breakpoints

Administering SSIS

Creating and Configuring the SSIS Catalog
Deploying Packages to the Package Catalog
Configuring the Packages
Configuring the Service
Securing SSIS Packages
Running SSIS Packages
Scheduling Packages

Loading a Warehouse

Dimension Load
Fact Table Load

SQL Server Analysis Services

Definition of Cube
Advantage of Cube
Star and snowflake schema
Dimensions and Dimension Types
Measures and Measure Types
Fact Table and Types
Data Source
DSV(Data Source View)
Hierarchy and Types
Cube Structure
Dimension Usage and Relationships
Calculations
Partitions
KPIs
Actions
Aggregations
Perspectives
Translations
Browser
Storage Models (ROLAP,MOLAP and HOLAP)

SQL Server Programming (T-SQL)

SQL Intro
Constrains
DDL commands
DML Commands
Joins
String Functions
Date Functions
Aggregate Functions
Temp Table, Table Variable
CTE(Common Table Expression)
Sub Queries
Operators
Case Statements
While Loop and If else Statements
Views
Stored procedures
Functions
Cursor
Triggers
Indexes
Identity
Exception Handling

MSBI Training FAQs

Download

Why Should I Learn MSBI from hachion?

This training provides you all skills needed to work with the Microsoft Business Intelligence stack. MSBI is a powerful suite of tools offering powerful data mining queries and BI capabilities through Visual Studio deployment with SQL Server. This entire course content is in line with the requirements for clearing the MCSE: Business Intelligence Certification exam. You will be working on real-time MSBI projects and step-by-step assignments that have high relevance in the corporate world, and the course curriculum is designed by industry experts. Upon the completion of the training course, you can apply for some of the best jobs in top MNCs around the world at top salaries. hachion offers lifetime access to videos, course materials, 24/7 support, and course material upgrading to the latest version at no extra fee. Hence, it is clearly a one-time investment.

What are the different modes of training that hachion provides?

We offer three modes of Training in MSBI Online Training Program.

Self Placed
Mentor-based
Instructor-Led

Can I request for a support session if I need to better understand the topics?

hachion is offering the 24/7 query resolution and you can raise a ticket with the dedicated support team anytime. You can avail of the email support for all your queries. In the event of your query not getting resolved through email we can also arrange one-to-one sessions with the trainers. You would be glad to know that you can contact hachion support even after the completion of the training. We also do not put a limit on the number of tickets you can raise when it comes to query resolution and doubt clearance.

Can you explain the benefits of the hachion self-paced training?

hachin offers self-paced training to those who want to learn at their own pace. This training also affords you the benefit of query resolution through email, one-on-one sessions with trainers, round the clock support, and access to the learning modules or LMS for a lifetime. Also, you get the latest version of the course material at no added cost. The hachion self-paced training is 75% lesser priced compared to the online instructor-led training. If you face any problems while learning we can always arrange a virtual live class with the trainers as well.

What kind of projects are included as part of the training?

hachion is offering you the most updated, relevant, and high-value real-world projects as part of the training program. This way you can implement the learning that you have acquired in real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning, and practical knowledge thus making you completely industry-ready. You will work on highly exciting projects in the domains of high technology, eCommerce, marketing, sales, networking, banking, insurance, etc. Upon successful completion of the projects, your skills will be considered equal to six months of rigorous industry experience.

Does hachion offer job assistance?

hachion actively provides placement assistance to all learners who have successfully completed the training. We also help you with the job interview and résumé preparation part as well.

Will I get a certificate in the end?

Yes. All our course are certified. As part of the course, students get weekly assignments and module-wise case studies. Based on the selected assignments and case studies (atleast 70%), the certificate shall be awarded.

Does the Job Assistance Program guarantee me of getting a Job?

Apparently, No. Our Job Assistance program is aimed at helping you land in your dream job. It offers a potential opportunity for you to explore various competitive openings in the corporate world and assists you in finding a well-paid job, matching your profile. The final decision on your hiring will always be based on your performance in the interview and the requirements of the recruiter.