Before connecting to your data, you need to do a few things. First, you must look for data that will answer your questions. Once you have validated that it exists, where it is stored and how to acquire access/permissions (if necessary). In most cases, you will be connecting directly to a database using a username and password. However, you can also connect to files such as Excel workbooks on your local machine. You can even use a combination of both if needs be.
Initial preparation
The Global Superstore dataset
The Global Superstore dataset is data from a fictional global retail chain that sells office supplies. In the real world, you will most likely be connecting to databases; however, working with Excel files is similar...