Business Intelligence

Business Intelligence

Unlock the full potential of Business Intelligence (BI) with our in-depth tutorials! We provide comprehensive guides on leveraging BI tools and strategies to turn raw data into actionable insights. Learn how to create powerful dashboards and data visualizations. Our tutorials cover everything from integrating data sources to advanced data analytics and reporting techniques.

60 posts
Seaborn - Violinplots

Seaborn - Violinplots

Introduction In this tutorial, we want to create a Violinplot. In order to do this, we use the violinplot() function of Seaborn. Import Libraries First, we import the following python modules: import seaborn as sns import matplotlib.pyplot as plt Load Data We would like to use a seaborn sample...

PostgreSQL - Lineplots

PostgreSQL - Lineplots

Introduction In this tutorial, we want to create a Lineplot. In order to do this, we use the lineplot() function of Seaborn. Import Libraries First, we import the following python modules: import seaborn as sns import matplotlib.pyplot as plt Load Data We would like to use a seaborn sample...

Seaborn - Boxplots

Seaborn - Boxplots

Introduction In this tutorial, we want to create a Boxplot. In order to do this, we use the boxplot() function of Seaborn. Import Libraries First, we import the following python modules: import matplotlib.pyplot as plt import seaborn as sns import numpy as np import pandas as pd Define Data...

Seaborn - Heatmaps

Seaborn - Heatmaps

Introduction In this tutorial, we want to create a Heatmap. In order to do this, we use the heatmap() function of Seaborn. Import Libraries First, we import the following python modules: import matplotlib.pyplot as plt import seaborn as sns import numpy as np Define Data Let's define...

PostgreSQL - SUM

PostgreSQL - SUM

Introduction In this tutorial, we want to calculcate the sum of values of a specific column. In order to do this, we use the SUM function. We have already created the table student with the following data: Example 1 We want to calculcate the sum of credit points of all...

PostgreSQL - COUNT DISTINCT

PostgreSQL - COUNT DISTINCT

Introduction In this tutorial, we want to count the number of unique values of a specific column. In order to do this, we use the COUNT function with the DISTINCT keyword. We have already created the table student with the following data: Example 1 We want to count the number...

PostgreSQL - COUNT

PostgreSQL - COUNT

Introduction In this tutorial, we want to count the number of values of a specific column. In order to do this, we use the COUNT function. We have already created the table student with the following data: Example 1 We want to count the total number of students. In order...

PostgreSQL - SELECT WHERE

PostgreSQL - SELECT WHERE

Introduction In this tutorial, we want to select data from a table that satisfy a certain condition. In order to do this, we use the SELECT Statement with the WHERE Clause. We have already created the table student with the following data: Example 1 We want to select all columns...

You’ve successfully subscribed to Deep Learning Nerds | The ultimate Learning Platform for AI and Data Science
Welcome back! You’ve successfully signed in.
Great! You’ve successfully signed up.
Success! Your email is updated.
Your link has expired
Success! Check your email for magic link to sign-in.