Data Toolkit
by oh22
Just a moment, logging you in...
Extend Excel to a complete self-service ETL tool.
Extracting, preparing, cleaning, standardizing, generally transforming and then saving data - these are classic steps in an ETL (Extract - Transform - Load) process. No matter how and where you want to process your data, in over 90% of all work that has to do with data, such tasks arise. Today, these steps are often referred to as Data Wrangling, Data Munging or Data Massage.
With Power Query – already integrated in Excel – and our oh22is Data Toolkit, you can now transform Excel into a full self-service ETL tool. Load data from any data source and transform it directly in Excel using Power Query and then save the processed data in a target of your choice.
- With the Data Toolkit it is possible to store data in various destinations, such as Microsoft SQL Server, Power BI, Azure Data Lake Store or SAP HANA
- Data can be exported to various file formats, such as Apache Avro, JSON or T-SQL
- With the Queries & Connection function you can directly access Power Query Connections and Queries created in the Excel Workbook