Blog Feed

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?

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