Microsoft Office Tutorials and References
In Depth Information
Chapter 11: Developing Your Data Model
11
Developing Your
Data Model
In This Chapter
Setting up the data, analysis, and presentation layers
Applying data model best practices
Leveraging Excel functions to deliver data
Using Excel tables that expand with data
A data model provides the foundation upon which your dashboard or report is built. When you
collect and analyze data, you’re essentially building a data model that feeds your presentation. In this
chapter, we discuss how to build and manage an efficient data model. Although you’ll discover how
to build cool dashboard components in later chapters, they won’t do you any good if you can’t
construct an effective data model. On that note, let’s get started.
Building a Data Model
Building an effective data model isn’t as complicated as you may think. The problem is that most
people spend little time thinking about the data model that supports a final presentation. If they
think about it at all, they usually start by imagining a mock-up of the finished dashboard and work
backward from there.
225
Search JabSto ::




Custom Search