In this module we will first look at the three different ways in which business intelligence can be viewed. Then, we’re going to look at the services SQL 2012 provides us and how they apply to business intelligence. We will then move to SharePoint 2013 and look at the SharePoint services to examine their relevance and how we can use them in business intelligence to surface data. In this section we will also cover the new business intelligence features available within the SharePoint 2013 release. Finally, we will take a brief look at PowerPivot, examining the new features and their significance. PowerPivot is covered in more detail in a later module.
- Business Intelligence in Three Ways
- SQL 2012 Business Intelligence
- New 2013 SharePoint Business Intelligence Features
- New 2013 PowerPivot in Excel Features
Lab : The Business Intelligence Stack
After completing this module, students will be able to:
- SQL 2012 Multidimensional Model Basics
- SQL 2012 Tabular Model Basics
- Browse the data within the cube using SQL Server Management Studio.
- Browse data using Visual Studio 2013.
- Connect to a tabular source, import tables, and explore the data.