Datameer Blog

Tag: Data Transformation

From Spreadsheet wizard to Data Transformation Maestro: My Journey With No-SQL Tools as a Data Analyst

Hello! If you’re reading this, chances are good that you share my enthusiasm for data analysis. I’m NDZ Antony, and I’ve worked in the data analysis industry for a while. B...

  • Ndz Anthony
  • August 31, 2023
data democratization blog

How Data Transformation Tools Can Help You Democratize Your Data

Data democratization isn’t a term that was popular prior to a few years ago. Back then, data analytics was a technical skill reserved for a selected few who had learn...

  • Jeffrey Agadumo
  • August 3, 2023
Fivetran and Datameer

How to Integrate Datameer with Fivetran for Simple Data Transformations

Extract Load Transform (ELT) is a vital process for businesses looking to extract value from their data. However, traditional ELT methods require significant coding experti...

  • Ndz Anthony
  • June 29, 2023
collaboration tools

How Can I Share My Transformation Projects with My Team?

Snowflake Data and Insight Sharing: Why and How? Sharing and collaboration tools are at the heart of any truly data-driven organization. To successfully drive business tran...

  • Ndz Anthony
  • June 21, 2023

How to Perform Union In Snowflake (Disparate Tables with Diverse Structures)

There may be times when you need to merge data from different tables with diverse structures or schemas. For instance, two tables might store customer information, but one ...

  • Ndz Anthony
  • May 17, 2023

A Step-by-Step Guide to Connect Excel to Snowflake

This article will guide you through the steps to connect Excel to Snowflake and get you on your way to becoming a data analytics pro. Snowflake is a cloud-based data wareho...

  • Jeffrey Agadumo
  • March 10, 2023
data catalog usecases

Data Catalog Use Cases to Accelerate Data Transformation Decisions

Are you looking to make smarter, faster decisions when it comes to data transformation? Of course you are — who isn’t in the modern data age? Worry no more. A well-ma...

  • Stephen Butts
  • March 1, 2023
Data Wrangling

Data Wrangling for Data Analysis: How Clean Data Can Improve Your Analysis Results

This article will discuss data wrangling, why it’s essential, and the prevalent differences between data wrangling and analysis. I remember trying to solve Rubix puzz...

  • Ndz Anthony
  • January 26, 2023

dbt Snowflake: When dbt Isn’t The Best Tool for Your Analytics

This article explores the features of dbt in data transformation, the dbt-Snowflake integration, and when dbt might not be the best tool for the job. If you’re a data pract...

  • Jeffrey Agadumo
  • December 28, 2022

Ad-hoc Analytics Requiring 100+ Lines of Complex SQL? No-code Tools to the Rescue

When repeatable reports are produced, SQL is used to combine the data into the right data model, and the query is continuously reused when the report is generated.  Hence, ...

  • John Morrell
  • August 7, 2022

How Great Data Documentation Helps Your Analytics Process

Data documentation is a new term used to describe the capture and use of information about your data.  It is used mainly in the context of data transformation, whereby data...

  • John Morrell
  • August 5, 2022

Benefits of No-Code Tools to the SQL Data Engineer

The market for no-code tools is growing dramatically.  Whether in mobile development, application development, digital transformation, process re-engineering, or other area...

  • John Morrell
  • July 6, 2022