From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Download the course exercise files - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Download the course exercise files

“

All right. Let's take a minute to talk about our course project and our course resource files. Throughout this entire course, we'll be using sample data from a fictional super market chain called FoodMart. Now, some fine print here. This data is fake. It's provided by Microsoft. So when we talk about trends and insights and patterns, it's all just purely for educational purposes. So keep that in mind. That said, it's a great, really rich data set. In addition to daily transactional records, over a two-year period from 1997 through 1998, our data sets are going to include information about products, about customers, stores, and regions. And all of the files that we'll be working with are available for download in the course resources section of the course dashboard. So quick preview. Here's a little bit of a snapshot of some of the tables we're going to be working with for this FoodMart project. We're going to have two different data tables with transaction data and return data. And then five different lookup tables with some really interesting dimensions and attributes about different types of customers, different products and brands, store locations and types. A lot of really good stuff here. So go ahead to your dashboard, grab those files, and let's get ready to roll.

Contents