SQL Server 2012 Business Intelligence The content in this unit covers SQL Server 2012 improvements related to Business Intelligence, including Reporting Services, Analysis Services, PowerPivot and Power View. Hands-On Labs Developing a SQL Server 2012 Tabular BI Semantic Model with Visual Studio 2010 (RTM Update) In this lab, you will develop a Tabular BI Semantic Model based on the AdventureWorksDW2012 sample database. Specifically it will allow the sales analysis of the reseller sales against sales quota. You will work with the entire development lifecycle including the creation of the project, the importing of data from both Microsoft SQL Server and a data feed data source, the enhancement of the model, and the definition of measures and a Key Performance Indicator (KPI). Once you have explored and tested the model you will enhance it with perspectives, partitions and a security role. Finally you will deploy the project to a Tabular instance of Analysis Services. Creating a SQL Server 2012 Tabular BI Semantic Model with PowerPivot (RTM Update) In this lab, you will create a PowerPivot workbook that will import data from a SQL Server database and an Excel file. The PowerPivot model will then be enriched with calculated columns, hierarchies, a Key Performance Indicator (KPI), and a perspective. Exploring Data Alerts with SQL Server 2012 Reporting Services (RTM Update) In this Hands On Lab you will learn how to define a data alert to notify you when salespeople do not achieve at least the 1% profitability target. Optimizing a SQL Server 2012 Tabular BI Semantic Model for SQL Server 2012 Reporting Services Power View (RTM Update) In this lab, you will optimize a PowerPivot tabular BI Semantic model for Power View. This will involve unhiding columns used in hierarchies, defining reporting properties, and removing explicit measures. Exploring SQL Server 2012 Reporting Services Power View (RTM Update) In this lab, you will explore SQL Server 2012 Reporting Services Power View. Power View is a Web browser-based report authoring tool targeted at everyone to enable them to create compelling, interactive and rich data visualizations based on Tabular BI Semantic Models. You will create a report based on a PowerPivot workbook published to a PowerPivot Gallery, and this report will consist of three different, yet related, interactive data exploration experiences. You will explore the model data using the tables, column and bar charts, and an animated scatter chart. Creating Excel 2010 Reports Based on a SQL Server 2012 Tabular BI Semantic Model (RTM Update) In this Hands On Lab you will learn how to create a report in Excel 2010 based on a tabular BI Semantic Model. You will then publish the workbook to SharePoint Server and then explore the report rendered by Excel Services in the Web browser. Creating a SQL Server Reporting Services Report Based on a SQL Server 2012 Tabular BI Semantic Model (RTM Update) In this lab, you will author a report in Report Builder 3.0 using the Map Wizard. The map analytic data will be retrieved from the Sales Analysis tabular BI Semantic Model. Creating a PerformancePoint Services 2010 Dashboard Based on a SQL Server 2012 Tabular BI Semantic Model (RTM Update) In this Hands On Lab you will learn how to create a PerformancePoint Services dashboard based on the Sales Analysis Tabular BI Semantic Model deployed in a previous lab. Videos Presentation: Introducing SQL Server 2012 Analysis Services Improvements SQL Server 2012 Analysis Services introduces an impressive array of improvements designed to expand the reach a broader user base. SSAS brings together the existing multi-dimensional model with the new tabular model pioneered by PowerPivot under a single unified platform – the BI Semantic Model. Presentation: Exploring SQL Server 2012 Analysis Services Tabular Modeling The SQL Server 2012 Analysis Services release embraces tabular model development. The tabular development approach, introduced with SQL Server 2008 R2 PowerPivot, is now available to the IT Professional, and extends beyond the features available in PowerPivot. PowerPivot has been enhanced with new model designer features and improved SharePoint integration, and Data Analysis Expressions (DAX) is available to both model development approaches, and has been enhanced. Demo: Developing a SQL Server 2012 Analysis Services Tabular Project This demonstration develops a basic tabular project in Visual Studio. The project will be enhanced in the following demonstration (SQL11UPD06-DEMO-02) by adding new Data Analysis Expressions (DAX) functionality. Demo: Exploring SQL Server 2012 Analysis Services DAX Improvements This demonstration explores two topics related to Data Analysis Expressions (DAX) improvements in SQL Server 2012. Presentation: Introducing SQL Server 2012 Reporting Services Improvements SQL Server 2012 Reporting Services has been upgraded with new features and capabilities, including an exciting new self-service visual design experience named Power View, increased end-user productivity with data alerts, and improved better integration with SharePoint. Demo: Configuring Data Alerts with SQL Server 2012 Reporting Services This demonstration creates a shared data source, uploads an existing report definition, and then relates the report’s data source to the newly created data source. Then it proceeds to create a new data alert. The data alert is tested to first send no notification. Then data is modified to ensure a notification is sent. Presentation: Exploring SQL Server 2012 Power View SQL Server 2012 Reporting Services introduces Power View, an interactive data exploration, visualization, and presentation experience which provides intuitive self-service reporting for business users against data exposed through the BI Semantic Model. Demo: Enabling Self-Service Reporting with SQL Server 2012 Power View This demonstration uploads an Excel workbook to the SharePoint PowerPivot Gallery library, and then uses it to produce a Power View report.