- 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
salesbycategoryandyear? - What are the total
profitbycategoryandyear? - Which
citieshave generated the highestsales? - What are the
marginsbysegment? - 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:
- 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
Profitand y-axis isSub-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 isRegion
1:30 pm: data.gov.my
-
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-warningon 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["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
- 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