When copy pasting powerpoint slides become tedious and you are just changing a few numbers every time, automating the process with Python can be a massive time saver. With Python and python-pptx (a python library), you’ll be able to use code to identify the elements that change across different files and everything can be generated in a click of a button.

We like to categorise the solutions in the market for two types of users - data analysts and developers. Popular options in the market for the former are PowerBI (Microsoft), Tableau, Looker Studio (Google). All these solutions are effective at it’s core and the difference lays in the building the dashboard to display your data.

For the more technical user (developers), options are limitless using Python and various libraries (Matplotlib, Streamlit).

A database is simply a storage mechanism for all data. The reason why this concept is important in technology is that these storages will have rules on how it’s data is stored and how data is retrieved.

An analogy:

• Think of a library (This would be a database)
• The library stores books (Tables)
• In these books you have pages (Rows)
• The library also has a librarian helps you find the book(s) that you may request. (Querying the data)
• During your research you may source many books and cross-reference each other. (Joining Data)

Google Analytics is a free solution which tracks your website traffic and gives you information to better understand your users. Once an account is made, Google Analytics gives you a piece of code to run on every page of your website. So every time a user loads your page, information on the user is sent to Google and reported back to you in Google Analytics.

To take it a step further you can:

• Create custom audiences and retargeting in your Google Ads Suite (Search Ads, DV360)
• Set up custom events on your website to track purchases, form submits and button clicks