Hellooo I’m back with my journal to keep track on online courses and studies after I took a break since Nov, that’s 2 months hiatus haha! Plus, I have an aspiration this year to not only take an online course, but also reading a textbook as well. Here IIII go!

Btw, since I received a scholarship to study Google certificate track for free on coursera last year (Click), so I took many courses in a short span of time. This year, I will give myself some slack thus I wouldn’t have too much pressure LOL

---

Datacamp

[2 Feb 2024] Course 1-2 — Understanding Cloud Computing, Introduction to GCP

An introduction course to the cloud computing world. What are the major cloud service providers out there in the market? Which job position related to the cloud domain? What exactly is IaaS, Paas, SaaS. There are sequel courses which are Introduction to GCP, AWS, Azure for those who wanna delve more into each providers architecture.

[14 Feb 2024] Course 3 — Introduction to Data Warehouse

Hey! this is a good introduction course to cover the basic of Data Warehouse concept

It covers

ETL vs ELT
Top-down (Inmon)/Bottom-up(Kimball)
On-premise vs Cloud
Star vs Snowflake schemas

[17 Feb 2024] Course 4 — Communicating Data Insights

The course introduced why communication using data matters. Distil the raw data into an insight and display them in a visual to a specific audience group in order to resolve business problem. It includes what audience needs to know, which visual type fits for each data.(very brief overview) What do you need to construct in the storytelling i.e. Narrative – Data – Visual

[19 Feb 2024] Course 5 — Data Storytelling Concepts

The extension course of Communicating Data Insights. Now, it dag deeper in Storytelling section. What your visual can be improved. How many data should include in a single page (50-60%: Data Density theory)

Storytelling framework: Freytag’s Pyramid

Type of insight i.e. Strategic, Operational insight

Type of reasoning: Inductive (From observations to form a theory), Deductive reasoning (Test on existing theory, requiring facts)

[19 Feb 2024] Course 6 — Introduction to Power BI

Since I’m kinda experienced in Tableau, probably a high time to have a hands-on Power BI as well. This introduction covers why we need to use Power BI. The course covers the surface of the interface and its features.

[23 Feb 2024] Course 7 — Introduction to DAX in Power BI

DAX is the formula component of Power BI. Its syntax and logic are way different than Tableau calculation syntax (and more similar to Excel) The course gave me a glimpse of DAX e.g. CALCULATE,SUM,AVERAGEX,FILTER

The difference between new column & measures

Still, There are further course to dive deeper in DAX fields.

[29 Feb 2024] Course 8 — Understanding Modern Data Architecture

This course was so TOUGH. Not my thing at all😭😭 It explains the terms such as Data Mesh, Data Fabric, Virtual Private Cloud… so many things all at once. Perhaps, I never get a glimpse of this concept before. It’s super new for me. I probably get it more once I’m familiar to this concept… but until then..hard pass for me.

[24 Mar 2024] Course 9 — Data Visualization in Power BI

The course that walked you through some of the visualization e.g. Clustered bar chart, Tornado Chart, KPI Chart. How to configure the chart format and applying DAX to the chart. With a little bit of dashboard theory. If there is too much visualization interpretation on a dashboard (cognitive load), don’t add it.

[11 Apr 2024] Course 10 — Data Preparation in Power BI

This one taught me how to do the data transformation in the Data Transform menu.

It can do multiple things such as replace the value, fill null value up,down, convert letter case, remove the duplication

Use the Column Distribution, Data Profile, Data Quality features.

[22 Apr 2024] Course 11 — Data Modeling in Power BI

TBC

---

Related blog posts

Most of my blogs are in Thai but there is an Google Translate option inside the blog:

✏ My Datacamp Course Journal in 2023 | 2022

📚 รีวิว/สรุป จักรกลพยากรณ์ Prediction Machines อธิบายวงการ AI ในฉบับภาษาชาวบ้านๆ + แนะนำคอร์สเรียน

📚 รีวิว Datacamp เว็บไซต์เรียน Data แบบจับมือพิมพ์

📚 รีวิว UI Fundamentals คอร์สพื้นฐาน User Interface บน Skooldio

[How to] Clean Date Format inconsistency using Regex in Presto SQL

[How to] Tableau Start-End Date Calculation to auto compare MOM on parameter

📊 Data Analytics — Tech, Programming Tutorial blog

🏀 Sport | 📺 Anime Review |🎧 Music | 🎬 Film Series | 📚 Book Review | 🔮 Divination