We are finally at that step of the process for which we've been waiting for: the analysis step. This is the step where we put our inquisitive hat on and start to get to know the data we are working with. This is the step where you can uncover new information and possibly find more data issues. We will go through the actual data from a website called Fast Forms. This is a website for people who rent property and for those who are looking to rent their property. What kind of data does this website have? Is it the data that tracks web visitors? No, the data does not consist of those who have visited the site; the data comes from the web application's own database. You will have to continue to read this chapter to find out more information. Note that we will be going through the same steps we have already covered in addition to introducing basic statistics and plotting. This is one of the chapters that will utilize a lot...
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