Domo Course - Session IV - Data Transformation - Part 2

This is the fourth part of our Domo training session. Aside from Magic ETL, Domo offers a variety of powerful ways to transform your data. In this lesson, we are going to tackle how to use SQL Transforms, and Dataset Views. A SQL Dataflow lets you run custom SQL queries in Domo. Compared to the Magic ETL, it is a lot more technical, but it offers great depth of transformation capabilities. Let’s create a SQL Dataflow for the customer & order dataset we used in the last lesson. To create a SQL Dataflow, navigate to the data tab, click “Transform Data” and select “SQL Transforms”. Files for the exercises can be found here: https://tinyurl.com/yck2tadj