Keep learning your way forward | Get courses from ₹5000 now

MSBI – MICROSOFT BUSINESS INTELLIGENCE (SSIS,SSRS & SSAS)

MSBI Course Content

File size: 146 kb

What is MSBI? 

Microsoft Business Intelligence (MSBI) is a powerful and comprehensive suite of tools and technologies designed to help organizations manage their data more effectively. The suite includes several components, including SQL Server Integration Services (SSIS), which provides an efficient way to extract, transform, and load data from various sources into a single data warehouse. SQL Server Analysis Services (SSAS) allows users to analyze and create multidimensional data models, while SQL Server Reporting Services (SSRS) enables users to create and share interactive, visually appealing reports. Together, these tools enable businesses to extract valuable insights from their data, improve decision-making, and achieve better outcomes.

  • Microsoft Business Intelligence architecture
  • Data Modeling, Representation, and Transformation for BI
  • Concepts of Multidimensional Modeling, ETL, and Transformations in SSIS
  • SSIS, SSAS, and SSRS architecture and their components
  • Sample of data flow across components
  • Building and creating charts, reports, and dashboards with SSRS
  • Generating and processing new data sources and new Cube

What are the prerequisites for learning MSBI?

  • Anybody can take up this online training course and get trained in MSBI.
  • SQL Basics would be the ideal

About Techehost 

Techehost is designed to provide high-quality, flexible and accessible learning opportunities to help you develop the skills you need to advance your career or pursue your personal interests. We offer a range of courses, taught by industry experts, that cover a wide variety of topics and are designed to fit your schedule and learning style. Our online learning environment is user-friendly and allows you to interact with instructors and other learners in real-time, enabling you to get the support you need to succeed. Whether you’re looking to learn a new skill, enhance your knowledge or take your career to the next level, our online training website is the perfect place to start.

 

 

 

MSBI introduction

1
Introduction to MSBI course – SSIS, SSRS & SSAS

Installation process

1
How to Install SQL Server 2019
2
How to install SSDT in Visual Studio 2019

SQL Server Integration Services (SSIS) - Basics

1
SSIS Terminology
2
SSIS or ETL Structure
3
Sections in SSIS Designer
4
Connection Managers in SSIS
5
Precedence Constraints in SSIS

SSIS - Data transformations

1
Union all
2
Look up
3
Data conversion
4
Conditional split
5
Derived column
6
Merge join etc.,

SSIS - Error handling

1
Control Flow -Error Handling in SSIS
2
Data Flow -Error Handling in SSIS

SSIS - Incremental loading

1
Incremental loading using Change Data Capture (CDC)

SSIS - Deployment and Scheduling

1
Deployment : SSIS Integration Services Catalog
2
Deployment : SSIS Package Deployment

SQL Server Reporting Services (SSRS) - Basics

1
Basic terminology
2
Data sources
3
Data sets

SSRS - Reports

1
Tabular reports
2
Matrix reports
3
Chart reports
4
List reports

SSRS reports - Types

1
Parameterized Reports
2
Multivalued Parameterised Reports
3
Cascaded Reports
4
Drill through and Drill down Reports
5
Sub reports
6
Actions in SSRS
7
Go To URL in SSRS
8
Paging in SSRS

SSRS Deployment and security

1
SSRS Deployment : SSRS Server and Manager Configuration
2
SSRS Deployment : SSRS Reports Deployment

SQL Server Analysis Services (SSAS)

1
Introduction to SSAS
2
SSAS Terminology
3
Cube Development
5
5 out of 5
1 Ratings

Detailed Rating

Stars 5
1
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Get course
Enrolled: 0 students
Duration: 45 hrs
Lectures: 39
Level: Intermediate
MSBI – MICROSOFT BUSINESS INTELLIGENCE (SSIS,SSRS & SSAS)
5 out of 5
5
1 review
Price:
₹15,000 ₹9,999
w

Shopping Cart

Cart is empty!

Total
₹0.00
0