Instructions

There are two steps to this challenge.

1. Query the data to understand the dimensions and measures.
2. Conduct exploratory data analysis and produce visualizations.

Bonus points:

Create a synthetic data set that has similar characteristics as the original data set. There are no specific methods that you need to use. You can choose a single variable to reproduce (e.g. clicks).

The original and the synthetic data should have similar-looking distributions and descriptive statistics.

Step 1

The data you'll be working with is synthetic advertising performance data. It represents daily summarized data for ad accounts across six different channels.

<aside> 🔑 You can access & query the data here: sqliteonline.com

</aside>

Or you can download the SQLite database locally if you prefer:

2020_ad_data.db

Take screenshots of each SQL queries and the results.

Paste them in a word or google document.

For example:

Example screenshot of sqliteonline.com UI.

Questions