Datameer Blog

Tag: How-to

A Beginner’s Guide to Tableau

Tableau: A Beginner’s Guide

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 […]

  • Justin Reynolds
  • April 23, 2020
visual exploration

Visual Exploration For Data Preparation

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 […]

  • Adam Wealand
  • June 1, 2019
Creating an Agile Closed Loop Data Science Workflow with Datameer and Amazon SageMaker

Datameer and Amazon SageMaker Data Science Workflow

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 […]

  • John Morrell
  • February 1, 2019

How to use IF condition in SQL SELECT statement?

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 […]

  • SQL FAQs
  • February 1, 2019

How to initialize an AUTO_INCREMENT column in MySQL?

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 […]

  • SQL FAQs
  • February 1, 2019

How to add an IDENTITY to an existing column in SQL?

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 ( […]

  • SQL FAQs
  • February 1, 2019

Instant Access To Our Free Library Of Resources

Discover the Top ETL and Data Integration Platforms


Featured Blog Posts

Five Critical Success Factors To Migrate Data to Snowflake
Five Critical Success Factors To Migrate Data t...

You’ve decided to modernize your data and analytics stack and migrate analytics workloads to the ...

  • John Morrell
  • May 10, 2021
ETL++: Reinvigorating the Data Integration Market

(This article first appeared on Medium on April 6, 2021.) The definition of “++” means incrementa...

  • John Morrell
  • April 12, 2021
Spectrum ETL
Disrupting the no-code cloud ELT market: Datame...

More than just loading Data: Datameer launches Datameer Spectrum ETL++ to disrupt the no-code clo...

  • Press Release
  • February 9, 2021