How do you obtain business insights when all you have on hand is raw unprocessed data scattered everywhere?
Data Warehouse: Basic Concepts You Need to Know in 2021
Author: Skye Tran
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
The Digital Skye 