John Lyu

User banner image
User avatar
  • John Lyu

Posts

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...

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...

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...

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...

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...

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...

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...

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...

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,...

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...