1 / 8

Microsoft business intelligence (MSBI)

Microsoft Business Intelligence is the set of techniques and tools for the transformation of raw data into meaningful and useful information.

karyatech45
Télécharger la présentation

Microsoft business intelligence (MSBI)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MICROSOFT BUSINESS INTELLIGENCE (MSBI)

  2. CONTENT • What is MSBI ? • Difference between data and information • MSBI Tools • Main Functionality of Business Intelligence • What is SSIS ?

  3. What is MSBI ? • Microsoft Business Intelligence 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

  4. MSBI TOOLS • 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).

  5. Main Functionality Of Business Intelligence • Modeling – flexible prototyping of analytical models, • Self-Service BI – minimizing the involvement of the IT department in the process of creating reports, • Reporting – a full range of reporting functionalities, • Predictive Analysis – identifying the trends and causes of problems in the enterprise, • Integration and Data Management – full automation of extraction, transformation and loading processes (ETL) from many types of data sources, • Big Data – tracking any kind of data, regardless of its type and size,

  6. Data warehouses – fully prepared environment for the implementation of highly scalable and reliable data warehouses, • Teamwork – optimization of cooperation, information sharing, resource management and rapid data searches, • Mobile Access – remote access to reports, dashboards, and scorecards on mobile devices, • Data in the Cloud – easy usage of the cloud computing platform (MS Azure), • Availability, performance, and safety– high availability (Always On service) and performance (Columns tore indexes) of the key tasks at the optimal cost, • Flexible implementation time – solutions adapted to the size of the organization and to different user expectations – from Self-Service BI to enterprise applications.

  7. What is SSIS ? Below three important projects help to complete the business intelligence task. • SSIS: SQL Server Integration Services • SSAS: SQL Server Analysis Services • SSRS: SQL Server Reporting Services

  8. THANK YOU For More Information. Visit : https://www.karyatech.com/microsoft-bi.html

More Related