Brief History of Msbi | Msbi Training in Hyderabad

Msbi Training In Hyderabad

Business intelligence (BI) is the set of techniques and tools. The transformation of raw data into meaningful and business analysis purposes. The BI technologies are capable of handling large amounts of unstructured data. To provide identify, develop and otherwise create new strategic business opportunities.


 The difference between data and information


Data is raw material for analysis. Data is always related to transactions or events. Once the data analyzed it's considered to be meaningful information.


MSBI Tools


Microsoft provides some tools to transform your business data into information. We can use these tools with the interface of Visual Studio.


 The release of SQL Server 2012, Business Intelligence Development Studio (BIDS). It renamed to SQL Server Data Tools (SSDT).


 SQL Server Data Tools (SSDT)


 Definition of Database


 A database is an organized collection of data. The data organized to model aspects of reality in a way. That supports processes requiring information.


Database Management Systems (DBMSs) designed software applications. Those interact with the user. Other applications and the database itself to capture and analyze data. DBMS is a software definition, creation, querying, update and administration of databases.


ETL (Extracts, Transform, and Load) Tools


ETL means that it takes the data from various source locations. as a different data format, for example, SQL, text, xl and so on and store this data into a destination (Data Warehouse).
 In computing, Extract, Transform and Load (ETL) refer to process usage data warehousing.


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 operational data store, data mart, or data warehouse).


  SSIS, SSAS, and SSRS


these are the three tools we are using for ETL, Analysis and reporting in MSBI.


 SQL Server Integration Service


SSIS is the ETL tool from Microsoft Integration Services. It is a platform for building high-performance data integration and workflow solutions. It including extraction, transformation, and loading (ETL) operations for data warehousing.


 The data from various locations and various formats and save. The data into a centralized repository as a Data Warehouse/Data Mart.


It includes graphical tools and wizards for building and debugging packages.


Data Warehouse and Data Mart


this is use for reporting and business analysis purposes. This system is an output of data from many sources and stored in a centralized repository. The Data warehouse stores the current and historical data. So it is easy to generate trend reports, predictive analysis, and quick decisions.


A Data Mart means a small part of a Data Warehouse and indicates only a single part. It always holds more summarized information.


SQL Server Analysis Service (SSAS)


this is the process of converting two-dimensional data into the multi-dimensional data model. This will help you to analyze the large volume of data.


Some of the advantages:


  Multi-dimensional analysis


  Key performance Indicator (KPI)


  Scorecard


  Slice, dice, drill down functionalities


  Good performance


  Security and so on.


 The differences between On-line Transaction Processing (OLTP) and On-line Analytical Processing (OLAP).


SQL Server Reporting Service

Microsoft SQL Server Reporting Services is an enterprise reporting platform. It supports traditional and interactive reports. Delivered over the web or through custom applications. It supports various data sources like two-dimensional and multi-dimensional data.


 
 Report builder helps to customize the reports for the end user.


  Easy subscriptions options.


  Export functionality with lots of formats.


  Display reports in various ways like tabular, chart, Gauge and so on.

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email