SQL

SQL

8 Mar 2023 · 3 min read

Dividing Customers into Four Quartiles Based on Total Revenue Using SQL and AdventureWorksDW2019

Analysing customer revenue is a critical aspect of understanding the performance of any business. In this blog post, we will explore how to use SQL and the AdventureWorksDW2019 database to group customers into four quartiles based on their total revenue.

Read more

SQL

4 Mar 2023 · 2 min read

Mastering Window Functions: How to Calculate a Moving Average in SQL

Learn how to analyse sales trends with a moving average calculation in SQL. This powerful tool can help you identify growth opportunities and improve business performance.

Read more

SQL

3 Mar 2023 · 5 min read

Building a Scalable Data Pipeline: Extracting Sales Data from Navision to Snowflake

In this blog post, we will learn how to extract sales data using SQL from a database, specifically Navision. We will define a SQL query to extract the data and execute it using Python. The resulting sales data will be fetched and can be further analyzed or visualized.

Read more

SQL

12 Dec 2022 · 5 min read

Top 5 Good Practices when using SQL

Are you tired of dealing with messy, slow, and error-prone SQL queries? In this blog post, we will reveal the top five good practices that can help you avoid common pitfalls and write clean, efficient, and secure SQL code.

Read more

Business

11 Dec 2022 · 4 min read

How To Implement A Data Warehouse

If you're a business owner or IT professional looking to implement a data warehouse from scratch, you're probably wondering where to begin. In this post, we'll outline the key steps you'll need to take in order to successfully implement a data warehouse from scratch.

Read more

SQL

10 Dec 2022 · 2 min read

Basic Data Extraction Using SQL

In SQL, data extraction is the process of retrieving specific data from a database. This is typically done using SQL SELECT statements, which allow you to specify the columns and rows that you want to retrieve from the database.

Read more