
Build ETL Data Pipelines Even When You Don’t Know How to Code
When all you want is simple steps to get good data scattered everywhere into a single location for quick business insights, don’t let the complexities of coding and infrastructure hold you back.

Seeing The World Through Computers’ Eyes (And Why It Matters To You)
Computer vision has the potential to improve the consumer experience, reduce costs and enhance security. Understanding the fundamentals of computer vision is the first step towards unlocking a crucial competitive edge. Are you ready?

Data Warehouse: Basic Concepts You Need to Know in 2021
How do you obtain business insights when all you have on hand is raw unprocessed data scattered everywhere?

A Simple Way to Query Table Metadata in Google BigQuery
Effortless approach to determine what is in the BigQuery dataset and which tables are useful for analysis with INFORMATION_SCHEMA and TABLES

Explore Arrays and Structs for Better Query Performance in Google BigQuery
Stepping up your SQL query game with these 2 advanced SQL concepts is easier than you think. Don’t miss out!

3 Useful SQL Features You Should Start Using in 2021
It’s time to take your queries up a notch with Date Partition, Analytic Window Functions and WITH clause!

Counting unique elements faster in Google BigQuery with HyperLogLog
With HyperLogLog algorithm, we trade off some accuracy to get the job done faster. But how much faster and at the expense of what level of accuracy?

Database Partitioning Simply Explained
What does database partitioning mean? How does it help to get answer from data faster, easier and cheaper?

Dear Data Professionals, Please Never Settle for Less Than Making An Impact
How to discover problems worth solving, define meaningful scope for data project, convey insights in a way that makes people care and deliver real business value

The Conjuring Universe: My 2-day Data Visualisation Project
How the project has taught me to start where I am, use what I have, do what I can to relentlessly drive it to completion

8 Practical Guidelines for Designing Databases That Don’t Land You in Hot Water
Designing databases presents a conundrum: How are you supposed to design a database when you’ve never designed something similar? Here are 8 things you can do to conquer the task with grace and confidence.

US Monthly Retail Trade Sales
How to handle Excel data with multiple sheets and different levels of granularity
Loading…
Something went wrong. Please refresh the page and/or try again.

About Me
Hi, I’m Skye, an IT consultant. At work, I help people and business achieve their goals by translating data into knowledge for better change. Outside of work, I write to make learning my daily ritual. This blog is for my love of data and telling stories I have learned from people, business and technology with you.
Subscribe to My Blog
Get new content delivered directly to your inbox.