Join Ron Davis for an in-depth discussion in this video What is the BI stack?, part of Microsoft Business Intelligence Stack Fundamentals.
Personal Business Intelligence is focused on Excel. Within Excel, what you're going to be using is Power Pivot and some of the other Power add-ins. To enable Power Pivot, you're going to go into file, options, add-ins, com add-ins, and you just place a check next to Power Pivot for Excel 2013. By the way, if you have the 2010 version, it'll say just Power Pivot, but either way it's Power Pivot.
Here also you've noticed i've enabled Power View. These are free downloads from Microsoft. We'll say okay. Now I have the Power Pivot tab. If I go home, use your standard Excel, and if I want to use Power Pivot to bring data in and to create data sets that I can analyze I would do it from here. There are some other tools that are available. I can download Power Query for Excel from the Microsoft Site. I can also download Power Map which is a preview for Excel 2013.
We download it and we can install it. A litte later on in this demonstration i'm going to show you the power of Power Map. These are free downloads that you just download and enable in the same way that I showed before. If you want more information on Power Pivot and Power View, check out Excel 2013 Pivot Tables in Depth course in the Lynda.com online training library. The key to team business intelligence is thinking about sharing the information that you have created.
If we have an Excel workbook and we put together business intelligence and we have all of these visualizations, we want to share it with the team in a secured manner. Also in a manner that we can automatically refresh the data. We do that by simply taking these workbooks and saving them into SharePoint where SharePoint uses Excel services. We've shared the workbook, it's in Excel Services, people that have the permissions can go in and look at this workbook, and SharePoint will take care of automatically refreshing the data force.
Then the entire team can see what we've done. SharePoint is not the focus of this course. In this course we use SharePoint just to show the visualizations that we're doing in business intelligence. But SharePoint is well worth investigating. Lynda.com has a number of excellent courses that you might want to investigate. The Microsoft Enterprise Business Intelligence Stack. This brings all of the tools that we have. If you'll look at the diagram, what we're showing in the block at the bottom labeled "BI Platform," at the heart of BI Platform is SQL Server DBMS.
Database Management System. Those of us in the trade just call this SQL. Nothing else runs without SQL. Note that we don't say services. We just say server. That causes everything in the BI Platform in SQL to work. Wrapping around SQL Server DBMS is at the bottom SQL Server Integration Services. As I refer to as SSIS throughout the entire course.
Below that you see arrows coming off of different data sources. SQL Server Integration Services takes the source data, transforms it where necessary and then loads it into a repository. At the top of the BI Platform you see a split. SQL Server Reporting Services, which is a service that is responsible for generating reports, and then SQL Server Analysis Services.
That is the data warehouse or the data mart. Those two, Reporting Services and Analysis Services are normally the destination of Integration Services. If we move up you'll see end user tools and Performance Management Applications. Excel we already talked about. Excel can take workbooks and post them into SharePoint. Performance Point Services is a service of SharePoint Server.
We use Performance Point Services to create the things that we're showing across the top, the tabs. Such as Reports, Dashboards, Excel Workbooks, we really take the Excel Workbooks and we can post that into a dashboard. We can create Analytic Views which is a nice say of saying that we can create charts. Scorecards, scorecards are a collection of KPIs that are clustered together because they're of the same sense.
Plans in there really just means a different visualization such as a Visio Drawing that we can use. SharePoint, it's important to note, is curved at the top. The reason we curve those at the top is to try to express that the BI data starts at the bottom, moves up through the stack, and is exposed through SharePoint Server. That's the tool that the end users are going to use to look at the data, the BI data, and the BI reports that you have generated.