I hope you enjoyed this chapter and all of the previous ones leading up to this point. By now, you should be very competent and able to understand the data analysis life cycle. We covered most of the stages except the presentation stage. This chapter focused on building your data preparation skills. It took us a while to get to the data models, but it was important to go through the previous steps so that you could appreciate this new functionality. There is a lot more that we could have done in this chapter, and I'm sure that we could create a book just on data models but we only had one chapter in this case. If you have one of the premium versions of Excel, there are a lot more tools that can be used in conjunction with data models, such as Power View, but I will let you discover this on your own. Being able to merge data from various sources and slice your data using data from various places is a skill that we practiced in this chapter. We were able to answer insightful questions...
Data Analysis and Business Modeling with Excel 2013
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
Free Chapter
Getting Data into Excel
Connecting to Databases
How to Clean Texts, Numbers, and Dates
Using Formulas to Prepare Your Data for Analysis
Analyzing Your Data Using Descriptive Statistics and Charts
Link Your Data Using Data Models
A Primer on Using the Excel Solver
Learning VBA – Excel's Scripting Language
How to Build and Style Your Charts
Creating Interactive Spreadsheets Using Tables and Slicers
Tips, Tricks, and Shortcuts
Index
Customer Reviews