datacamp coursera 2024

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

The outline 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

It walked you through the basics of Database schemas e.g. what is Star, Snowflake, Their Pros & Cons and the difference. What’s Facts and Dimensions table which is apparently useful when using Power Bi since Power BI has Data Model View pane, in which, we can design the relationship across the table directly within its tool.

[10 May 2024] Course 12 — Case Study: Analyzing Customer Churn in Power BI

A workshop project to help you polishing the Power BI skills you learned in earlier courses .e.g how to write DAX code (I wasn’t so familiar with them yet, so I use Gemini+Stackoverflow on that part), filter compoenent to see the desired exact number. The course designed by examplify with one dataset that we had to analyze – digging the insight – put them into a dashboard in order to communicate with the stakeholder thereafter.

[27 May 2024] Course 13 — Introduction to Google Sheets

First course of a Google Sheets Fundamentals track. It’s apparently a short course as it teaches you to distinguish between the terms of Cells, Formalas, Reference

[28 May 2024] Course 14 — Data Analysis in Google Sheets

This one teaches how to use statistics formulas such as COUNT,AVERAGE,ROUNG. Cleaning the text formula of extract date,month from the cell, logical formula i.e. IF and using VLOOKUP

[10 Jun 2024] Course 15 — Intermediate Google Sheets

More in-depth course of the formula by understanding the idea of data type in google sheet and how to convert them. how to deal with missing/blank data and formatting the data. Explored further on conditional formulas such as IFS, SWITCH

[27 Dec 2024] Course 16 — Pivot Tables in Google Sheets

A quick course on Pivot Tables, what is Pivot Table, how to create them, the difference between Row, Column, Value, Filter. If we find any errors how to solve them (using COUNTA to find the blank cell)

---

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

📚 [pandas Tips] มาระเบิดคอลัมน์ที่ Value เป็นลิสต์ a,b,c ไปขึ้นบรรทัดใหม่กัน ! Let’s Explode a list to new row on pandas/BigQuery

📚 [SQL Tips] วิธีสร้างเทเบิลแบบขึ้นจากศูนย์ (hardcoded table) สำหรับเทสตามใจฉันบน Big Query/ SQLite/pandas

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

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

📊 [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

datacamp coursera 2024