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
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
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
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 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 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
