- This is how my career is progressing so far
- Here's some information about career paths in data
- What problems do you want to solve?
- 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
bycategory
andyear
? - What are the total
profit
bycategory
andyear
? - Which
cities
have generated the highestsales
? - What are the
margins
bysegment
? - Make your dashboard look better using a color palette generator
- What are the total
- 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?
- Source: Superstore sample data from Tableau
- 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:
- Practice:
1:30 pm: data.gov.my
-
Using either your new Google account or your personal account, sign up for Postman, then log in
-
Open data.gov.my using another tab on your browser >> API Docs
-
Scroll to Realtime APIs >> Weather API
-
Try the Forecast API Endpoint
GET https://api.data.gov.my/weather/forecast
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)
toresponse.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['location.location_name'] == 'Langkawi']
- Output into a CSV file, then download and open in Excel
- Now try the Transport API (GTFS-R) and output the locations of Prasarana buses on Google My Maps
- What other questions can you answer?
- Don't forget to try using the Weather API
- Convert json output into a dataframe using
- 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