MSBI stands for Microsoft Business Intelligence. The powerful suite tool developed by Microsoft which offers best solutions for BI (Business Intelligence and Data-Mining Quries. This tool uses microsoft visual studio data tools + sql server. It provides different processes for different tools for BI solutions.
Business Intelligence is techniques for transforming data into information. This information helps to make quick decisions.Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes. BI technologies are capable of handling large amounts of unstructured data to help identify, develop and otherwise create new strategic business opportunities.
The difference between data and information
Data is row material for analysis. Data is always related to transactions or events. Once the data is analysed it’s considered to be meaningfull information.
Microsoft provides some tools to transform your business data into information. We can use these tools with the interface of Visual Studio.
With the release of SQL Server 2012, Business Intelligence Development Studio (BIDS) was renamed to SQL Server Data Tools (SSDT).
Definition of Database
A database is an organized collection of data. The data are typically organized to model aspects of reality in a way that supports processes requiring information.
Database Management Systems (DBMSs) are specially designed software applications that interact with the user, other applications and the database itself to capture and analyse data. A general-purpose DBMS is a software system designed to allow the definition, creation, querying, update and administration of databases.
ETL (Extracts, Transform, Load) Tools
ETL means that its takes the data from various source locations, maybe as a different data format (for example SQL, txt, xls and so on) and store this data into a destination (Data Warehouse).In computing, Extract, Transform and Load (ETL) refers to a process in database usage and especially in data warehousing that:
Extracts data from homogeneous or heterogeneous data sources.
Transforms the data for storing it in a proper format or structure for querying and analysis purpose.
Loads it into the final target (database, more specifically, operational data store, data mart, or data warehouse).
1. Micrsoft SQL Server
i. Microsoft SSIS Overview
What is DBMS and RDBMS
Types of Normalization
Constraints in Sql Server
Relationships in Sql Sever
ii. Sql Statements
String Datatypes and Functions
Joins and SubQueries
Views In SqlServer
Indexes in SqlServer
Triggers In Sql Server
2.Micrsoft SQL Server 2005 Integration
i. Microsoft SSIS Overview
SSIS: SQL Server Integration
DTS & its Limitation
ii. Getting familiar to Business Studio Development Environment
Launch Business Intelligence Development Studio (BIDS).
Use Package Designer.
Use Solution Explorer.
Use Properties Window.
Use Variable Window.
iii. Creating a Package
Using the SSIS Import and Export Wizard
Using the SSIS Designer
iv. Introduction to Control Flow
Control Flow Overview.
Execute SQL Task.
Bulk Insert Task.
File System Task.
Send E-mail Task.
v. Introduction to Data Flow
Data Flow Overview
• The Copy Column Transformation
• The Derived Column Transformation
• The Data Conversion Transformation
• The Conditional Split Transformation
• The Aggregate Transformation
• The Merge Transformation
• The Merge Join Transformation
• The UnionAll Transformation
• The Look up Transformation
• The SCD Tranformation
• The Pivote and UnPivote Transformations
vi. Adding Looping, Using Breakpoints, Checkpoints and Transactions
vii. Error Handling and Logging
Handling Errors in Data.
Configuring Package Logging.
Built-in log providers.
Key Features of SoftBloom Corporate Training
♪ Real Time & Expertise Faculty
♪ Job Oriented real-time Training
♪ Project Guidance
♪ Resume & Interview Guidance
♪ Complete Guidance from training to placement
♪ 100% Placement Assistance
♪ One stop Solutions for Getting job
Short Term Course: Available (30 Days )
3. Microsoft SQL Server Reporting Services
Reporting Services Scenarios
Reporting Services Features
Reporting Services Concepts
ii. Reporting Services Tools
Reporting Services Configuration Tool
Report Designer and Model Designer
Creation of reports
Table and Matrix Reports
Filters in Reports
Drill Down Reports
Drill Through Reports
Adding Row and Coloumn Grouping
iv. Publishing reports
v. Report Server Administration
Snap Shot Reports
4. Micrsoft SQL Server Analysis Services
i. Introduction to Data Warehousing and Analysis Services 2008R2
OLTP & OLAP
SQL Server Analysis services 2008R2(SSAS)
ii. First Look at Analysis Services 2008R2
Business Intelligence Studio(BIDS)
Creating a Project using BIDS
SQL Server Management Studio
iii. Introduction to MDX
Manipulating data with MDX
iv. Working with Data Sources and Data Source Views
Data Source View
Working with DSV
Adding / Removing Table from a DSV
Create / Delete Relationship
Adding Named Queries
Multiple Data Sources within a DSV
v. Dimension Design
Dimension and Dimension Properties.
Dimension Creation using Dimension Wizard.
Creating a Time Dimension
Translations in Dimensions
Defining Linked Dimensions
Defining Write-Enabled Dimensions
vi. Cube Design
Unified Dimensional Model
♪ 100% Placement Assistance
♪ Real Time Overview
♪ Interview Tips
♪ Resume Preparation
♪ SDLC Overview
♪ Agile Project Methodology
♪ SQL Tuning Techniques
♪ Performance Tuning