This chapter is one of my favorites because it brings so many concepts from the previous chapters together and shows you how everything fits together with the help of a simple example. We had to gather data, prepare data, and analyze data. Hopefully, you are beginning to see that analyzing data means that you need to ask lots and lots of questions. You also need to remember that domain knowledge is very important. You need to know the background of the data you are working with and how it fits into the bigger picture. You also realized that having a good eye for bad data is a skill that you need to tune over time. We also made use of pivot tables and charts to get more insights into our data. We also covered the steps needed to automatically generate descriptive statistics about our data in detail. These statistics helped us look deeper into our data and get a better feel of what we are working with. By the end of the chapter, you need to know your data inside and out. In Chapter...
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