Skip to main content

MSBI Architecture with Detail Explanation



Why MSBI (Microsoft BI):
  
MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools, which help in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio (BIDS) 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, which are required in Business Intelligence (BI) solutions.







SQL Server makes business intelligence available to everyone through deep integration with Microsoft Office, providing the right tool, to the right user, at the right price. Employees at all levels of an organization can see and help to influence the performance of the business by working with tools that are both easy to use and powerful.



Microsoft SQL Server includes several features that make it easy and inexpensive to implement business intelligence (BI) and data warehousing. These features include reporting, data management, analytic data storage.


Create high-performance Analysis Services solutions with improved cube designers.


Implement more responsive Reporting Services solutions through enhancements to on-demand processing and instance-based rendering.


Build flexible and effective reports with the new Tables data structure and rich formatting capabilities.


Enable business users to build ad hoc reports and create reports with any structure by using the powerful report designer.


Provides customers with user-friendly tools whose complexity remains on the cutting edge.


Deliver reports in the format preferred by most end users by using the new and enhanced Reporting Services (example: you can have used Microsoft Office Word as a format for reports)



MSBI Components: 
 
SSIS - Integration tool
SSAS - Analytical Tool / Analysis tool
SSRS - Reporting tool / Data View Tool

SSIS (SQL Server Integration Services):



Microsoft's SQL Server Integration Service tool (SSIS). SSIS is useful in collecting information / data in different formats from various locations and gathering it to the centralized location. It performs three important tasks "Extraction", "Transformation" and "Loading". It is an enterprise tool for data integration, data transformation and data migration.







SSAS (SQL Server Analytical Services):



SSAS is the second step after SSIS, to analyze the centralized stored data we need to use SQL Server Analysis Services. Analysis service uses OLAP (Online Analytical Processing) component of MS SQL Server and data mining capabilities. SSAS helps to create OLAP CUBES (multi-dimensional array of data) using data from data warehouse and also to build mining models for deeper and faster analysis.





SSRS (SQL Server Reporting Services):



SQL Server Reporting Services (SSRS) is a graphical generating software system from Microsoft. After analyzing data properly as we saw in second step [SSAS] now it’s time to present data graphically in our final step [SSRS]. Graphically presented data is necessary for an organization to make an effective decision. Use of SSRS tool develop, design, test, and generate reports.









Comments

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope