From the course: Excel: Analytics Tips

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Data modeling 101

Data modeling 101 - Microsoft Excel Tutorial

From the course: Excel: Analytics Tips

Start my 1-month free trial Buy for my team

Data modeling 101

“

I'd like to introduce you to a very powerful concept in Excel. We're going to talk about how to build and analyze relational data models in Excel. Now, Excel's Data Model is used for a number of different purposes. For one, you can compress extremely large amounts of data, hundreds of millions of rows, if not more. And third, you can add brand new calculated columns and measures using a formula language called DAX or data analysis expressions. So there are few ways to get data into the data model. The most common way is to create a new connection to a data source using a tool like Power Query, also known as Get Data or Get and Transform. It loads straight from that connection into the model. A simpler way to add data to the model, especially for the sake of demonstration, is to take a table from a worksheet, which is generally a much smaller table, and click the Add to Data Model button within the Power Pivot tab. Now, this is a good point to pause and let you know that some versions…

Contents