Filtering SQL Data When complex conditions lead to incorrect results? The ‘middle column’ design is the answer
Filtering is a technique for extracting only the exact rows you need from a large amount of data. SQL data...
A Data Analyst's Guide to SQL Data Transformation: Calculating Business Key Metrics (pCVR, CPO) and Utilizing WITH Clauses
As I studied data analytics, I naturally came across key business metrics...
A complete guide to handling car accidents in New Zealand, from police reports to insurance claims
Being involved in a car accident can be a panic-inducing experience. Especially when you're in a foreign country like New Zealand...
The Complete Guide to SQL GROUP BY Aggregation Functions to Unlock Key Business Insights in Data Analytics
Now that you've learned the basic concepts of SQL basic queries and databases, it's time to start using business insights...
A quick, non-technical introduction to SQL in a nutshell From database fundamentals to writing queries.
To become a data analyst, many people start with SQL. SQL...
How Queenstown rents will affect business owners and investors (2026)
Queenstown is New Zealand's leading tourist city and is heavily influenced by people working in the tourism industry....
Why Hong Gil-dong's name is on New Zealand's version of McKenzie Coffee
Queenstown's Mackenzie coffee is named after a sheep thief who...
Data analyst job hunting cheat sheet Power BI dashboard GitHub A complete guide to uploading a portfolio
While studying data at Queenstown QRC, I created a lot of Power BI dashboards. My...
Data Entity Relationships (ERD) Fundamentals: A Non-Chef's Lesson in the Importance of Data Design
The Queenstown, New Zealand QRC data analysis course is coming to a close. Non-majors...
An introduction to data analytics in New Zealand: A non-chef unveils his first dashboard in Tableau
Hands-on Tableau skills learned at QRC in New Zealand and data created by non-technical people...
