Join Ron Davis for an in-depth discussion in this video Using the exercise files, part of Excel Power Pivot: Data Modeling.
- If you want to follow along and build your own data models in Excel while you're watching the course, we provided these files for you. Under Exercise Files, we have them numbered to match the numbering of the course. So we have here a Workbook Imported Data. We also have a little code snippet in there. And as you see as you come through, we have the different Workbooks. Normally, we have a Start and a Complete. If you want to actually do it, you're going to need to use these Databases. So you're going to need to restore them.
You can restore them either locally or if you have access to a SQL Server then you can restore them then. These databases were built on SQL Server 2012, so they'll restore to either a 2012 or a 2014. By the way, you can download and install an Evaluation Edition. If you do that, make sure it's a 64-bit and make sure also, that when you download and install it, that it's either Developer or Enterprise. So, let's go through and restore these, and I'm going to start SQL Server Management Studio.
This is my local server and I'll call Connect, Database right click, Restore. We go into Device, we're not restoring from another database, and I'll hit the ellipses. "...", Add, and down here on the Add, I'm going to find my files, by the way it opens by default into the Backup Directory which is normally where we restore from, but under Exercise Files, under Databases, if I select "BlueBuffaloPressSample_01" and say OK, OK, OK, that's good news.
Now if I refresh and expand this out, there it is. We do the exact same thing for the other database which is "BlueBuffaloPressSample_02". So again, it's in the Exercise Files, Databases, Sample 02, OK, OK, let it restore. This one takes a little longer, because it's bigger. Success, that's what we always like to see. Let's Refresh, and there we have the two sample databases.
- Data modeling concepts and terminology
- Exploring the Power Pivot interface
- Adding data sources
- Working with date tables
- Understanding perspectives and key performance indicators (KPIs)
- Getting started with DAX syntax
- Understanding evaluation context