Join Ron Davis for an in-depth discussion in this video What you should know before watching this course, part of Excel: Power Pivot DAX.
- You should have a good knowledge of Excel. After all, this is an Excel course. It's really an Excel course designed for business users. Within Excel, you need to understand pivot tables. We're going to be using a lot of pivot tables, and I assume that you know how to do them. You should be working with, or have worked with Excel functions, so that when I reference an Excel function, you understand what I mean. Not necessarily the internal wiring of that function, but how you work with functions in Excel.
You do need a basic knowledge of how relations work in relational database management systems. And you should have an understanding of what I mean by the PowerPivot data model. You will not create any PowerPivot data models in this course, as they're already created for you. But when I go into the data model, so that you're not lost in it, you should have a knowledge of it. Alright, here's some of the resources you can use to learn what I just talked about.
Here we have Pivot Tables in Depth. This is an excellent course. All the courses that I'm going to recommend are on Lynda.com's online library. I suggest if you don't feel that you have a knowledge that is required for the course, that you go through and look at these courses. So here's Pivot Tables in Depth. Here's Advanced Formulas and Functions. You're really not going to be working with advanced formulas and functions, but this course will give you a good understanding of how to code out formulas and functions.
Relational Database Fundamentals, and particularly within that course, this Preventing Data Anomalies. Because preventing data anomalies is one of the goals, one of the major goals, of a relational database system and if you understand how to prevent anomalies, insertion, deletions, and modification anomalies, than you will understand how tables relate to each other within databases. You understand a little bit about normalization and a little bit about de-normalization.
Finally, there's Data Modeling with Excel Power Pivot. And that's a course that I put out. This will explain to you how you do data models. And when you're done with this, you'll understand what the data model is for power pivot in Excel. It's not really necessary that you look at this course before you do the Dax course, but I would strongly suggest that if you do the Dax course first, then you go over into the Data Modeling so you'll know how to work those together.
You're certainly going to need the data modeling course when you go into wherever it is you work and you actually start to work with PowerPivot and Dax, because you're going to need to create your data models based on your data.
- Exploring DAX syntax and data types
- Using functions
- Understanding evaluation contexts
- Using CALCULATE to change evaluation context
- Working with dates
- Utilizing many-to-many relationships
- Implementing banding