A beginner’s guide to Tableau, the leading software suite that businesses are using to visualize and understand their data. Tableau for Beginners Big data demand is stronger than ever as organizations across all industries are looking for information to gain a competitive edge. It’s easy to see why considering that data-driven companies are expected to […]
Data visualization is the principle of taking data values and converting them into a graphic. Most people see, or prefer to see, data represented as a graphic. It is the common language that captures how data values are constructed into a story. Typically, the simplest and aesthetically pleasing data visualizations require the most time and […]
Introduction If you’re going to do machine learning work right, you’re going to need well-honed data sets to build your models on. It is not just about cleaning up the data. It is also about discovering data that is relevant to the problem at hand, finding more data to increase accuracy, integration data from multiple […]
In SQL Server, we have below two options to implement IF condition in SQL SELECT statement. CASE WHEN… THEN IIF Let us consider the following ‘student’ table. CREATE TABLE student ( student_name VARCHAR(50), grade CHAR(1) ) INSERT INTO student SELECT ‘Jack’, ‘A’ UNION ALL SELECT ‘Rose’, ‘B’ UNION ALL SELECT ‘John’, ‘C’ UNION ALL SELECT […]
The value of AUTO_INCREMENT can be reinitialized using the below methods. ALTER TABLE… AUTO_INCREMENT TRUNCATE TABLE Let us consider the table below. CREATE TABLE student ( student_id INT PRIMARY KEY AUTO_INCREMENT, student_name VARCHAR(50) ); INSERT INTO student(student_name) VALUES (‘Jack’); INSERT INTO student( student_name) VALUES (‘Rose’); 1. ALTER TABLE… AUTO_INCREMENT We can […]
There is no straightforward way to add IDENTITY to an existing column. We need to follow a series of steps to achieve this. There are two ways to do this. Creating New Table Creating New Column We need to convert the ‘student_id’ column of the table below to an IDENTITY column. CREATE TABLE student ( […]
You’ve decided to modernize your data and analytics stack and migrate analytics workloads to the ...
(This article first appeared on Medium on April 6, 2021.) The definition of “++” means incrementa...
More than just loading Data: Datameer launches Datameer Spectrum ETL++ to disrupt the no-code clo...