Module 1 Introduction to Business Intelligence and Data

Module 1 Introduction to Business Intelligence and Data Modeling

Module Overview • Introduction to Business Intelligence • The Microsoft Business Intelligence Platform

Lesson 1: Introduction to Business Intelligence • Business Intelligence Scenarios • Trends in Business Intelligence • Business Intelligence Project Roles • Data Models

Business Intelligence Scenarios Reporting Data Analysis Collaboration

Trends in Business Intelligence • Self-service reporting and analysis • Increasing adoption of BI by a wider range of organizations • Availability of out-of-the- box solutions

Business Intelligence Project Roles • Business advisors • Project manager • BI architect • BI developers • Report authors • Information workers • Testers • BI administrator

Data Models • Semantic models § Present data to users as meaningful information § Add context and structure to data • Data modeling § Requires knowledge of business and technical aspects of the solution § Is an iterative process § Helps to ensure that solutions meet the stated requirements

Lesson 2: The Microsoft Business Intelligence Platform • Microsoft Business Intelligence Technologies • BI Semantic Models in SQL Server 2012 Analysis Services • Installation Requirements for Common Scenarios • Considerations for Share. Point Configuration

Business Intelligence Data Warehousing Microsoft Business Intelligence Technologies Microsoft SQL Server Integration Services Microsoft SQL Azure and the Windows Azure Marketplace SQL Server Database Engine 1011000110 SQL Server Data Quality Services SQL Server Master Data Services SQL Server Analysis Services SQL Server Reporting Services Microsoft Power. Pivot Technologies is ys a iv t In t ac er e t da a l na Microsoft Excel • • • Data Mining Add-In Power. Pivot Add-In MDS Add-In ns alizatio ta visu a d e v ti Interac Reports, KPIs, and Dashboards Power View Microsoft Share. Point Server

BI Semantic Models in SQL Server 2012 Analysis Services • A single logical model • A choice of data models to suit different BI requirements Power View Excel Power. Pivot Third-Party Applications Share. Point Insights BI SEMANTIC MODEL Data Model Multidimensional Tabular Business Logic and Queries MDX DAX Data Access ROLAP MOLAP Verti. Paq Direct Query

Installation Requirements for Common Scenarios • Desktop BI § Data analysis in Power. Pivot for Excel workbooks • Departmental BI § Departmental reporting § Analysis of data in Analysis Services databases • Enterprise BI § Share. Point integration § Power View reporting § Collaboration

Considerations for Share. Point Configuration • Reporting Services in Share. Point Integrated mode § Select Reporting Services – Share. Point and Reporting Services Add-in for Share. Point installation options § Install Reporting Services Share. Point service § Create a Reporting Services service application • Analysis Services in Share. Point Integrated mode § Select the SQL Server Power. Pivot for Share. Point setup role § Configure the server by using the Power. Pivot Configuration Tool

Lab Scenario This lab is an overview lab, designed to show the BI capabilities you will explore in greater depth in the rest of this course Business users and executives at Adventure Works Cycles need to be able to view reports that show sales figures, and perform interactive analysis of sales data in Excel and Share. Point Server

Lab 1: Reporting and Analyzing Data • Exercise 1: Exploring a Reporting Services Report • Exercise 2: Exploring a Power. Pivot Workbook • Exercise 3: Exploring a Power View Report Logon information Virtual machine MIA-SQLBI User name ADVENTURWORKSStudent Password Pa$$w 0 rd Estimated time: 30 minutes

Module Review and Takeaways • How do the BI implementations in your place of work use Microsoft technologies? • Does your organization use Share. Point in a BI context?