O'Reilly logo

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel by Chris Sorensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 2Model data

Data modeling is one of the most important, yet often overlooked, tasks that needs to be undertaken when building any analytical solution or using any tool. How a model is designed from the ground up is one of the largest contributing factors to driving usability and ultimately adoption from an end-user community. The more intuitive a model is, the greater the likelihood that the model will be used—and will be used correctly and predictably by your users. The focus of this chapter is to review the methods used to create a data model that not only performs well but is easy to understand and use from an end-user perspective. In this chapter, we look at creating an Excel data model and then iteratively enhancing the model to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required