--- title: "#data-transformation articles | Hashnode" description: "Explore 71 articles tagged #data-transformation on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/data-transformation" --- Tag # #data-transformation 71 posts · 4 followers [Ricky Suhanry](https://hashnode.com/@datarunner01) · [May 18](https://hashnode.com/posts/introduction-to-data-processing-and-data-transformation/6a0a9ceaf004a4e175df2f67) ### [Introduction to Data Processing and Data Transformation](https://datarunner01.hashnode.dev/introduction-to-data-processing-and-data-transformation?utm_source=hashnode&utm_medium=feed) The internet processes data for user access through a complex, multi-step process that translates human-readable web addresses into machine-readable locations, establishes secure connections, and brea 8 min read · [datarunner01.hashnode.dev](https://datarunner01.hashnode.dev/introduction-to-data-processing-and-data-transformation?utm_source=hashnode&utm_medium=feed) [Excel Logics](https://hashnode.com/@excellogicsofficial) · [May 7](https://hashnode.com/posts/connect-excel-power-query-to-sql-server-a-2026-tutorial/69fc03e6f51878fb5e14d700) ### [Connect Excel Power Query to SQL Server: A 2026 Tutorial](https://excellogics.hashnode.dev/connect-excel-power-query-to-sql-server-a-2026-tutorial?utm_source=hashnode&utm_medium=feed) Struggling to integrate your SQL Server data into Excel for analysis? This guide walks you through connecting Excel Power Query to SQL Server, transforming raw data into actionable insights. 10 min read · [excellogics.hashnode.dev](https://excellogics.hashnode.dev/connect-excel-power-query-to-sql-server-a-2026-tutorial?utm_source=hashnode&utm_medium=feed) [Mohamad Mahmood](https://hashnode.com/@mohamadrazzimy) · [Feb 18](https://hashnode.com/posts/python-fundamentals-for-citizen-data-scientist-2-data-transformation/69953495f4d7f776a7684735) ### [Python Fundamentals For Citizen Data Scientist 2 — Data Transformation](https://labworks.razzi.my/python-fundamentals-for-citizen-data-scientist-2-data-transformation?utm_source=hashnode&utm_medium=feed) Data transformation is defined as the technical process of converting data from one format, standard, or structure to another — without changing the content of the datasets — to improve the data quality (Spiceworks.com). This is one of the important ... 6 min read · [labworks.razzi.my](https://labworks.razzi.my/python-fundamentals-for-citizen-data-scientist-2-data-transformation?utm_source=hashnode&utm_medium=feed) [Ahmed Ghannam](https://hashnode.com/@ahmad-ghannam) · [Feb 16](https://hashnode.com/posts/mastering-analytics-engineering-my-journey-with-dbt-and-data-modeling/69937bacdce780a9836b8ee5) ### [Mastering Analytics Engineering: My Journey with dbt and Data Modeling](https://ahmps.hashnode.dev/mastering-analytics-engineering-my-journey-with-dbt-and-data-modeling?utm_source=hashnode&utm_medium=feed) Date: February 16, 2026Module: Data Engineering Zoomcamp - Module 4Topic: Analytics Engineering with dbt Introduction Just completed Module 4 of the Data Engineering Zoomcamp - Analytics Engineering with dbt (data build tool)! This module was transf... 14 min read · [ahmps.hashnode.dev](https://ahmps.hashnode.dev/mastering-analytics-engineering-my-journey-with-dbt-and-data-modeling?utm_source=hashnode&utm_medium=feed) [Mohamad Mahmood](https://hashnode.com/@mohamadrazzimy) · [Feb 16](https://hashnode.com/posts/transforming-data-from-html-tables/6992ce52561068f2289917ad) ### [Transforming Data From HTML Tables](https://labworks.razzi.my/transforming-data-from-html-tables?utm_source=hashnode&utm_medium=feed) Question 1: Find the source of data based on below requirement and fetch them into Power QueryQuestion 2: Find the source “public data” regarding the amount of car sales in the local market. Question 1 answer : https://web.archive.org/web/2025112111... 2 min read · [labworks.razzi.my](https://labworks.razzi.my/transforming-data-from-html-tables?utm_source=hashnode&utm_medium=feed) [Nitor Infotech](https://hashnode.com/@Nitor-Infotech) · [Jan 16](https://hashnode.com/posts/matillion-etl-tool-best-practices/696a214b4de8d045c01ee153) ### [Matillion ETL Tool: Best Practices](https://blog-matillion-etl-tool-best-practices.hashnode.dev/matillion-etl-tool-best-practices?utm_source=hashnode&utm_medium=feed) Discover best practices for optimizing Matillion ETL workflows, from handling large datasets to improving logging, security, and cost management 2 min read · [blog-matillion-etl-tool-best-practices.hashnode.dev](https://blog-matillion-etl-tool-best-practices.hashnode.dev/matillion-etl-tool-best-practices?utm_source=hashnode&utm_medium=feed) [Khushi jitani](https://hashnode.com/@khushijn) · [Jan 13](https://hashnode.com/posts/transform-your-data-effortless-xml-to-excel-conversion-for-smarter-business-decisions/696607476636ed4c5953de36) ### [Transform Your Data: Effortless XML to Excel Conversion for Smarter Business Decisions](https://cloudservicess.hashnode.dev/transform-your-data-effortless-xml-to-excel-conversion-for-smarter-business-decisions?utm_source=hashnode&utm_medium=feed) Maximize Productivity by Converting XML Files into Excel with Ease 3 min read · [cloudservicess.hashnode.dev](https://cloudservicess.hashnode.dev/transform-your-data-effortless-xml-to-excel-conversion-for-smarter-business-decisions?utm_source=hashnode&utm_medium=feed) [Khushi jitani](https://hashnode.com/@khushijn) · [Jan 9](https://hashnode.com/posts/simplifying-data-management-with-xml-to-excel-conversion/6960d7d71342ad1fd2c11df1) ### [Simplifying Data Management with XML to Excel Conversion](https://cloudservicess.hashnode.dev/simplifying-data-management-with-xml-to-excel-conversion?utm_source=hashnode&utm_medium=feed) Introduction In today’s data-driven world, organizations often work with XML (eXtensible Markup Language) to store, transport, and exchange structured information. XML is ideal for machine processing but can be cumbersome for human analysis. Converti... 3 min read · [cloudservicess.hashnode.dev](https://cloudservicess.hashnode.dev/simplifying-data-management-with-xml-to-excel-conversion?utm_source=hashnode&utm_medium=feed) [Khushi jitani](https://hashnode.com/@khushijn) · [Dec 29, 2025](https://hashnode.com/posts/text-columns-to-csv-converter-simplifying-data-transformation/6952319d89c8abab3ed5bda1) ### [Text Columns to CSV Converter: Simplifying Data Transformation](https://cloudservicess.hashnode.dev/text-columns-to-csv-converter-simplifying-data-transformation?utm_source=hashnode&utm_medium=feed) In today’s data-driven world, businesses and individuals constantly work with information stored in different formats. Text files with structured columns are common, but they often need to be converted into CSV (Comma-Separated Values) format for ana... 3 min read · [cloudservicess.hashnode.dev](https://cloudservicess.hashnode.dev/text-columns-to-csv-converter-simplifying-data-transformation?utm_source=hashnode&utm_medium=feed) [Stat Hacks](https://hashnode.com/@stathacks) · [Dec 23, 2025](https://hashnode.com/posts/save-your-analysis-the-power-of-data-transformation-f8ac68f52243/694a2f05b8d8a8cb33232f02) ### [Save Your Analysis: The Power of Data Transformation](https://data-career-starters.hashnode.dev/save-your-analysis-the-power-of-data-transformation-f8ac68f52243?utm_source=hashnode&utm_medium=feed) Note: this post is part of a series of posts about Data Analysis In The Real World Transforming your data is a crucial skill that becomes evident only after you’ve worked with data for a while. It’s only after seeing enough bad data interpretations a... 8 min read · [data-career-starters.hashnode.dev](https://data-career-starters.hashnode.dev/save-your-analysis-the-power-of-data-transformation-f8ac68f52243?utm_source=hashnode&utm_medium=feed)