ArchiTech IT

Course information

MSBI: stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for MSBI Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server

It empowers users to gain access to accurate and up-to-date information for better decision making in an organization. It offers different tools for different processes that are required in Business Intelligence (BI) solutions.

MSBI is divided into 3 categories:

1. SSIS – SQL Server Integration Services – Integration tool. This tool is used for integration like duping the data from one database to another like from Oracle to SQL Server or from Excel to SQL Server etc.
2. This tool is also used for bulk transactions in the database like inserting lacs of records at once. We can create the integration services modules which will do the job for us. 
3. SSAS – SQL Server Analytical Services -Analysis tool: This tool is used to analyse the performance of the SQL Server in terms of load balancing, heavy data, transaction, etc. So it is more or less related to the administration of the SQL Server using this tool. This is a very powerful tool and through this, we can analyse the data inserting into the database like how many transactions happen in a second, etc.
4. SSRS – SQL Server Reporting Services – Reporting tool: This is a very efficient tool as it is platform-independent. We can generate the report using this tool and can use it in any type of application. Nowadays this is very popular in the market.

SSIS: SQL Sever Integration Services
1.    About SSIS
2.    ETL procedures
3.    About DTS Packages
4.    About Business Intelligence Projects
5.    About SQL Server Data Tools (SSDT)
6.    Elements of a SSIS project
a.    Data Sources
b.    SSIS Packages
7.    Elements of a Package
a.    Connection Managers
b.    Control Flow Items
c.    Dataflow
d.    Event handlers
e.    Package explorer
8.    Creating a SSIS Project using SQL Server Data Tools
9.    Creating a new Package
10.    Executing a package
11.    Logging ETL operations
12.    Handling errors (exception handling)
13.    Adding an existing package to the Project
Planning an SSIS project
 
14.    Understanding the tasks
15.    Planning control flow operations
16.    Planning data flow operations
 
Optimizing an SSIS Project
 
17.    Running and monitoring
18.    Optimizing
 
Deploying & Running SSIS Projects
 
19.    Deployment procedure
20.    Manual Execution
21.    Scheduling

SSRS: SQL Server Reporting Services
 
22.    Importance of Reporting Servers & Services
23.    About SSRS
24.    Installing SSRS
25.    Stopping and starting SSRS services
26.    Using reporting services tools
27.    Logon to SSRS
 
SSRS Projects
 
28.    Elements of SSRS projects
a.    Data sources
b.    Reports
c.    Report designer
29.    Report planning/modeling
30.    Creating a SSRS project
31.    Formatting reports
32.    Adding/Removing data sets
33.    Adding calculated values to the reports
34.    Using parameters and filters
35.    Using Parameter 
36.    Executing reports
 
Publishing reports
 
37.    Publishing reports onto a SSRS Server
 
Report Subscriptions

38.    About Report Subscriptions
39.    Creating Report Subscriptions
40.    Managing Report Subscriptions

 

SSAS: SQL Server Analysis Services
1.    Importance of Analytical systems and solutions in business development
2.    Introduction and About SSAS
Building SSAS Projects
 
3.    Elements of SSAS Projects
a.    SSAS Database (OLAP database)
b.    Data sources
c.    Data source views
d.    Dimensions & Facts
e.    Measures
f.    Cubes
g.    Mining structures
4.    Creating a SSAS Project (Multidimensional Analysis Solution)
5.    Creating a cube
6.    Planning Dimensions and facts (tables/views) 
7.    Dimension hierarchies
8.    Sorting an Grouping attributes
9.    Configuring Measures & Measure groups
10.    Building KPI (Key Performance Indicators)
11.    Building Actions
12.    Building Partitions
13.    Building Perspectives
14.    Building Translations
 
MDX Queries
 
15.    MDX Fundamentals
16.    Writing MDX queries
17.    Adding MDX Calculations to a Cube 
Deploying a SSAS Package
 
18.    Debugging a SSAS Project
19.    Deploying a SSAS Database (Project)
20.    Securing SSAS database services using Roles