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

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 ...