Join Ron Davis for an in-depth discussion in this video Grid and diagram views, part of Microsoft Business Intelligence Stack in Depth.
Here we're looking at SQL Server development tools and we have tabular project open. And that tabular project is open in grid view. This should look to you just like an Excel workbook. Let me show you. Here, I'm over in Excel. And this is an Excel table. You'll notice as we come across, we have our columns, and we have our rows. So if I go back over to tools, we have our columns and we have our rows.
I'm emphasizing this because this is the familiarity that I mentioned that you have between the tools. So here we are in Grid View, and if we were going to look at like a measure. By the way, you see these are grayed, the reason this is grayed is I have this column hidden from the client tools. Let me unhide it. Because, most people, when they're looking at these columns, really don't care about the Product Key. So, that's just hidden in here. But, down below, I have a measure.
And, if I click on it, here it is. Internet distinct count sales orders equals distinct count. And we're going through, and it's going to count up how many of these we have. If go to the second one. Here I'm summing internet sales, amount summed, internet sum, discount amount. So that kind of adds to a fact. If you watched the multi-dimensional, then you know that I said facts are normally, have the ability to be, they're integers and they normally can be added or summed etc.
So, we have the same philosophy there. So, there's the idea of, of measure. A calculated column, on the other hand, would be, if we added, say a, product over here and if I had something I wanted to do. For example, I wanted to add a column in here, and I had column a that had a value and column e that added value. And I wanted this to be the difference between A and B. I would just add it in there, and would be a calculated column, and it would apply to each row. That's your Grid View.
Again, it's very similar to Excel. If we switch to the Diagram View, up here at the top, I can see all the columns, all the measures, the hierarchies and the KPIs. Let's start cleaning them out. And watch what happens, throughout the columns. Now, I can see only measures. So, the sales territory has measures, and the reseller sales, etc. If I click it, I can maximize. And all that will do for me, is give me the ability to read, what all of those measures are.
So, let's go back down. And the similarity here is, if I go over to a relational database, I'm over here in SQL Server Management Studio, and I am looking at a data diagram of a database's tables. So I have the Products table here, and you see it's related to Sales, there's the key. And its related to suppliers and it's related to categories. If I switch back over, we have the same thing here, so I have tables that are related to other tables.
So again, it's a very familiar interface. Add back in my columns and my hierarchies and my KPI's.
- Working with data sources and data views in SQL
- Understanding the star and snowflake database schemas
- Working with the SQL 2012 semantic model (aka tabular mode)
- Using Data Analysis Expressions (DAX)
- Using Excel Web Parts to connect to spreadsheets
- Building dashboards with key performance indicators (KPIs) and reports
- Understanding the Microsoft data-mining process