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

Gathering data


This part is going to be easy because the data has already been gathered, and it is available in the folder named Chapter 05. It contains three CSV files, and each file represents a specific table in the database.

Open each of the three files and familiarize yourself with the columns and data found inside:

  • Pmthistory.csv

  • Rateplan.csv

  • Users.csv

Note that in order to get this data out of the database, we will have to either perform steps similar to the ones in Chapter 2, Connecting to Databases, or use some other means. So, how did I get this data? The data is present in the Postgres database, and I used Python to retrieve the data and save it in CSV files. It is also important to mention that I own and run this website.