Effortless approach to determine what is in the BigQuery dataset and which tables are useful for analysis with INFORMATION_SCHEMA and TABLES
Stepping up your SQL query game with these 2 advanced SQL concepts is easier than you think. Don’t miss out!
It's time to take your queries up a notch with Date Partition, Analytic Window Functions and WITH clause!
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?
What does database partitioning mean? How does it help to get answer from data faster, easier and cheaper?
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
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
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.
How to handle Excel data with multiple sheets and different levels of granularity
Who says financial statement has to always be in tabular format?