Agenda:

08.30 am: Intro, career paths in data and questions

Create a Google account (you can use your personal one too, if you prefer)
Head to Looker Studio, using another tab
Download as CSV from here and upload to Looker Studio
Build a few charts and filters
- What are the total sales by category and year?
- What are the total profit by category and year?
- Which cities have generated the highest sales?
- What are the margins by segment?
- Make your dashboard look better using a color palette generator
Practice by creating another page named Customer, and using any chart/table:
- What is the name of the Customer with the Highest Sales in New York City?
- What Sub-Category did this Customer buy, and how much Sales and Profit did this Customer generate for the company?
- Open question: Is the business doing better or worse off from 2014 to 2017?

Using either your new Google account or your personal account, open Google Colab in another tab
Google Colab's interface and functions: - Tools >> Settings >>
- Editor >> Show line numbers (check if you prefer)
- Miscellaneous >> Corgi mode, Kitty mode (turn on if you like)
- Test with some basic code:
  - Click Connect at top right
  - Write simple definition
  - Test simple math problem
- Runtime settings
  - Run cells
  - Reset
- Code and text cells
- Save
More about Colab’s Markdown here
Refer to colab_intro.ipynb
Open a new notebook on Google Colab
Try out a few plots on Seaborn:
- histplot
- displot
- boxplot
- lmplot 7. Practice:
- Load the CSV into Colab
- Create a displot, where x-axis represents Region
- Create a catplot, where x-axis is Profit and y-axis is Sub-Category
- Adjust the size of charts by sns.set(rc={'figure.figsize':(25.7,8.27)})
- Create a boxplot where x-axis is Sales, and y-axis is Region

Using either your new Google account or your personal account, sign up for Postman, then log in
- Look for Workspaces (top left of the page) >> My Workspace (Click)
- Look for the + sign beside Overview
Open data.gov.my using another tab on your browser >> API Docs
Scroll to Realtime APIs >> Flood Warning API
Try the Flood Warning API Endpoint GET https://api.data.gov.my/flood-warning on Postman
- Look for the icon circled in the snapshot below
- Switch from cURL to Python - Requests
- Copy the Python code from Postman and paste into a new Colab notebook
Change print(response.text) to response.json() to see the data returned by the API endpoint
Tasks:
- Convert json output into a dataframe using pd.json_normalize()
- Store dataframe into a variable df
- Filter to include only df[(df["water_level_indicator"] == "NORMAL")] and today's date
- Output into a CSV file, then download and open in Excel and Google My Maps
- The nearest river to our current location is Sungai Gombak, spot which station_id is it
- What other questions can you answer?
- Don't forget to try using the Weather API

Need to create another Google account, if you haven't already. Remember to activate 2-Step Verification
Refer to Sending a Plain-Text Email. Look for the code section just above the Sending a Fancy Email header.
Register for an account on aciqn
Using Postman, try making an API call (documentation here
- GET https://api.waqi.info/feed/kuala%20lumpur/?token=###INSERT TOKEN HERE###
From Postman, copy the Python code into a Colab notebook
Tasks:
- Get the API readings of a few stations
- Send the email containing the API of a chosen station/a few selected locations

Data visualization and coding skills help to automate routine tasks - worth picking up to save time
- Looker Studio / Power BI
- Exam PL-300: Microsoft Power BI Data Analyst
- Python Crash Course
Get certified for cloud computing