Book Image

Data Analysis and Business Modeling with Excel 2013

Book Image

Data Analysis and Business Modeling with Excel 2013

Overview of this book

Table of Contents (18 chapters)
Data Analysis and Business Modeling with Excel 2013
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
10
Creating Interactive Spreadsheets Using Tables and Slicers
Index

Chapter 6. Link Your Data Using Data Models

This chapter will take us back to the data preparation stage. Sometimes, your data is in multiple places, and it will make your life easier if the data was present in one sheet. We will use Excel's data model feature to combine data from multiple sources into one. We will also discuss the database concepts but nothing too advanced. In terms of Excel, this new data model replaces the use of the well-known VLOOKUP function in some instances. We will merge the three datasets from the Fast Forms website that we learned about in Chapter 5, Analyzing Data Using Descriptive Statistics and Charts. Fasten your seat belts as the next few sections will come and go in a flash.