Data Visualization Introduction
Data visualization, also known as “data viz”, is an interdisciplinary field that deals with the graphic representation of […]
Blog
T-SQL Tables and Row Count
You are exploring a database in SQL Server using SSMS. You need a script that simply reports the […]
Chinook Database
The Chinook Database is a sample database available for several database products, including SQL Server, PostgreSQL, MySQL, Oracle, […]
Dashboards Introduction
Dashboards are great tools to tell your data story. There are two main ways to tell your story: […]
Data Interpretation and Ethics
The goal of all data analysts is to use data to draw accurate conclusions and make good recommendations. […]
SQL Select Into
The SELECT INTO statement copies data from one table into a new table. Here’s the syntax for copying […]
SQL Update From Another Table
We want to add a new column to our Orders table and put the product name into that […]
SQL Add Column
What is the SQL statement that adds a column to an existing table? The SQL statement is the […]
SMART Questions
Data Analysts ask the right questions to make sure everyone is on the same page about the plan […]
Problem Types of Data Analysts
Data analytics is about solving problems. Right in the first step where we Ask, we want to understand […]
Data Analysts in Different Industries
There are all kinds of jobs in different industries available for data analysts. Every industry has specific data […]
SQL Update Statement
The UPDATE statement is used to modify the existing records in a table. The syntax is as follows. […]