John Lyu

After graduating with a Bachelor of Applied Finance, John discovered his fascination with data. Motivated by this passion, he decided to pursue a career as a data analyst, furthering his education with a Master of Commerce, majoring in Business Analytics.

John is deeply passionate about data and firmly believes in its transformative power, especially in areas like Machine Learning, Data-Centric AI (DCAI), and Storytelling with data.

He is extremely excited about opportunities to test his knowledge and expand his industry insights, such as Kaggle competitions and visualization contests. John thrives on collaboration, enjoying the experience of working alongside talented colleagues and learning from their expertise.

In his free time, John enjoys playing basketball, hitting the gym, and hanging out with friends. He is also a trading cards collector. He enjoys making new friends, so be sure to come say hi.

Dashboard Week #Day 4 – NHL Challenge

Dashboard Week #Day 4 – NHL Challenge

Challenge background Day 4! Very exciting as this is our penultimate day in the Dashboard week. The dataset is very fun, we are digging a story from the National Hockey League data using Power BI!   The data source Today’s data source is probably the best one we...

Dashboard Week #Day 3 – NSW Public Library Challenge

Dashboard Week #Day 3 – NSW Public Library Challenge

Challenge background It is already the 3rd day of the Dashboard Week, cannot believe how time have passed this fast. With back to back and almost endless challenges and presentation, our task today is to build a dashboard in Tableau with NSW Public Library data....

Dashboard Week #Day 1 – IGDB x Twitch API Challenge

Dashboard Week #Day 1 – IGDB x Twitch API Challenge

Challenge background Towards the end of the Data School training, there is a unique challenge that awaits where everyone will produce a dashboard with a different dataset every day for a week. This is the first day of the challenge, our task for the day is to connect...

Passing the Torch: Insights for New Project Leaders

Passing the Torch: Insights for New Project Leaders

Navigation Guide Intro The responsibilities My tips for project leaders Tips #1: Things to think about for the requirements Tips #2: Project life Cycle Tips #3: Scrum Outro   Intro In this blog, I am going to share some of the lessons I have learned during the...

Client Week Chronicles: A Retrospective

Client Week Chronicles: A Retrospective

Navigation Guide: Intro Recap of the week The challenges What could have been done better Outro Intro Starting week 6 (08/01/2024) the DSAU24 is transiting from the learning phrase into the next keenly anticipated stage of their training program – client project...

Everything Database!

Everything Database!

Navigation Guide Intro What is a database? Types of databases Relational Database Database structure Fact and Dimension tables Example Tools References Intro Today’s topic is about databases, where I am using a real-life metaphor instead of talking in technical terms...

Data Modeling 101: A Beginner’s Guide to Success

Data Modeling 101: A Beginner’s Guide to Success

Navigation Guide Intro What is data modeling? Three levels of data abstraction Conceptual Data Model Logical Data Model Physical Data Model Keys Relationship (crows) Types of data modelling Benefits of data modelling Data modelling tools Limitations Of Data Modeling...

Deep Dive into LOD: Step-by-Step Mastery

Deep Dive into LOD: Step-by-Step Mastery

Navigation Guide Quick Note Fixed, Include, and Exclude OLDs INCLUDE LOD EXCLUDE LOD Compare EXCLUDE and INCLUDE FIXED LOD Conclusion Useful Resource References   Quick Note Welcome to the continuation of our series following the last blog post Unpacking LOD: The...

Unpacking LOD: The Basics

Unpacking LOD: The Basics

Navigation Guide What is LOD? Granularity Tableau order of operations Outro References Key words: LOD, level of detail, dimension, Granularity, Aggregated, FIXED LOD, INCLUDE LOD, EXCLUDE LOD What is LOD? In Tableau, LOD stands for Level of Detail. For simplicity, we...

So this is where it all begins: John’s Origin Story

So this is where it all begins: John’s Origin Story

Table of contents: Intro Week1 Overview Challenge What I enjoyed Intro My name is John Lyu, I joined the Data school down under on the 27th of September in 2023. As a new data schooler, I cannot tell you how excited I am to be a part of this organization, and a member...