Chapter 44. The Data Model

Questions answered in this chapter:

  • What is the Data Model feature and why do I need to learn about it?

  • How can I add data to the Data Model?

  • How can I create relationships within the Data Model?

  • How can I use the Data Model to create PivotTables?

  • How does the Quick Explore option work?

  • How can I add new data to a Data Model?

  • How can I remove data from the Data Model?

  • How can I use the Data Model to create a new PivotTable?

  • How can I edit or delete relationships?

  • How does the DISTINCT COUNT function work?

Answers to this chapter’s questions

This section provides the answers to the questions that are listed at the beginning of the chapter.

What is the Data Model feature and why do I need to learn about it?

The Data Model feature is ...

Get Microsoft Excel 2013: Data Analysis and Business Modeling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.