Data Analysis Using Domo

Name: Data Analysis Using Domo
Rating: 3.7 (84 reviews)

Data Analysis and BI Reporting Using Domo BI Tool

Created bySonu Kumar

Last updated 5/2026

English

What you'll learn

Learner will be able to bring data into Domo through Various resource like File, Cloud, Database
Domo Architecture
Learner will be able to create DataFlow based on requirement using SQL and ETL
Learner will be able to Create Cards, Dashboard, PDP
Learner will be able to Create alert, Domo Stats
Best Practice of Creating Cards, Data Flow, Dashboards
Basic SQL to create SQL Transformation
How to create Task and Project in Domo
Domo App Store
Domo API
Domo Embedding
Domo Sandbox
DDX Card
Domo Stats
Domo App Studio
Domo Admin

Course content

32 sections • 197 lectures • 20h 55m total length

Course Overview3:28
Domo Platform and Architecture12:24

Connect To Data Source Introduction0:58
Connect Data Source in Domo1:19
File Upload in Domo5:10
File Upload Update Mode5:09
Install Workbench Domo3:50
Workbench Interface2:45
Work Bench Add Account2:22
Work Bench Export Job8:49
Work Bench Transformation7:56
Domo Work Bench Schedule3:31
Learn Domo Workbench scheduling by switching between local time and UTC, moving from manual to automated updates, and configuring basic and advanced frequencies, days, and monthly options.
Work Bench Notification0:50
Domo Job Scheduling Using Window Task Scheduler6:58
Create a batch file and schedule a Domo workbench job with Windows Task Scheduler. Run wb.exe with job id, set daily triggers, and review last run logs for data updates.
Federated Data Source in Domo1:55
Google Sheet Connector13:16
Azure Synapse Analytics Connector9:23
Learn to connect azure synapse analytics with domo using the sql connector, configure server name, database, and credentials, adjust firewall settings, and run custom or builder queries to export data.
Azure Data Lake Gen2 Connector7:45
Databricks Connector8:45
Connector Action2:05
Domo Connector Project17:07
Data Source Quiz

Data Transformation Overview1:17
Data Blending3:04
Magic ETL Introduction11:03
Data Inspection Before Applying Transformation12:55
Magic ETL Input Data Handling4:47
ETL-Date Transformation8:27
Utility Transformation Add Constant1:36
Learn how to apply the utility transformation in Domo to add a constant value to all rows by using add constraint, naming a flag with value zero.
Utility Transformation Add Formula6:58
Utility Transformation Alter Column and Select Column2:59
Utility Transformation Set Column Value2:14
Master the set column value transformation in Domo to replace a column with another of the same data type, such as text or fixed decimal.
Utility Transformation Value Mapper5:22
Learn how the value mapper in Domo ETL modifies a product code column, replacing hardware with hard, with options to overwrite or create a new column and handle non-matches.
Utility Limit Transformation4:56
Utility Order Transformation2:34
Utility SQL Transformation6:37
Utility Get Schema Transformation6:15
Utility Meta Select Transformation Remove Column10:55
Utility Meta Select Transformation Change Column Type7:04
Utility Meta Select Transformation Rename Column3:39
Utility Meta Select Transformation Dynamic Expression12:38
Apply a dynamic formula to decimal columns with the meta select transformation in Domo, automating round to two digits across new and existing fields via the schema and expression.
Group By Transfromation8:30
Combine Column Transformation4:26
Learn how to perform a combined column transformation in Domo ETL by merging department and product code with a chosen separator, producing a new product department column.
Split Transformation5:21
Learn how to perform split column transformation in domo by choosing a source column, selecting a delimiter (space or hyphen), and using keep extra splits to capture all tokens.
Replace Text Transformation3:34
String Operation11:29
Text Formatting2:29
ETL-Filter Transformation-Filter Rule6:15
ETL-Filter Transformation-Formula Rule2:51
Apply filter transformation with the add formula rule to customize ETL filtering, extracting the month from date and filtering for May, illustrating the greater flexibility of formula-based rules.
ETL-Pivot Transformation8:56
ETL- Unpivot Transformation4:40
ETL-Dynamic Unpivot Transformation7:06
Learn how dynamic unpivot in Domo converts multiple columns into a single value column, by designating non-pivoted columns and letting the remaining columns pivot automatically.
ETL-Join Transformation6:48
Join with Expression3:33
ETL-Append Transformation6:05
ETL-Remove Duplicate Transformation5:29
ETL-Rank and Window Transformation21:10
Bes Practice For Managing Data Set2:12
Perfomance in ETL4:54
Learn how the performance tile in Domo speeds ETL by using select and restore column to process only required columns, then restore the remaining columns for output.
Output Data Set Partition4:21
Script Activity Introduction6:49
Script Activity Join14:16
Data Transformation Integration5:16
Webform Data Set2:49
Domo AI Readiness11:49
Data Flow Scheduling4:17
Data Transformation Project Overview3:21
Data Transformation Project19:19
Transform data with Domo to clean and enrich retail data by rounding prices, extracting date components, splitting product name and color, and computing final price and profit.
Domo Transformation Quiz

Requirements

Basic SQL Is required

Description

This course is focused on teaching Domo to students and professionals who aim to attain the Domo certification exam. The objectives covered in the course are diverse and encompass a range of topics, including:

Basic SQL functions such as aggregate functions, mathematical functions, and functions to handle null values.
String and date functions that can be used for data cleaning and manipulation.
Different types of SQL joins like left, right and inner joins.
Window functions like rank, dense rank, row number, and other useful functions.
Connecting various data sources with Domo like cloud databases, files, Google sheets, and email.
Transforming and cleaning data using SQL and ETL, including data blending in Domo.
Data Science Transformation like Clustering, Outliers, Regression
AI Service Transformation like Sentiment Analysis
Creating cards and dashboards, utilizing various types of charts available in Domo and their applications.
Creating alerts on data flow, allowing for notifications to be sent via email to the primary email address as entered in the Admin Settings in Domo.
Personalizing data permissions through the creation of Entitlement Policies.
Scheduling reports in Domo.
Following best practices in Domo.

By covering these objectives, the students will gain a practical understanding of working with Domo, including connecting various data sources, cleaning and transforming data using SQL and ETL, creating visualizations in the form of dashboards and cards, and creating personalized data permissions and alerts. They will also learn how to schedule reports and follow best practices in Domo to maximize its potential.

Who this course is for:

Anyone looking to pursue a career in data analysis or business intelligence
Aspiring data professionals looking to master the #1 business intelligence tool on the market
Data analysts and users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
Anyone looking for a hands-on on DOMO BI Tool.

Data Analysis Using Domo

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 16min

Domo Login3 lectures • 14min

Domo Task and Project1 lecture • 10min

Connect Data Source in Domo19 lectures • 1hr 50min

Cloud Integration2 lectures • 13min

Transforming Data into Domo46 lectures • 5hr 3min

Data Science Transformation3 lectures • 20min

AI Transformation1 lecture • 4min

SQL Transformation5 lectures • 37min

Domo Data Ware House1 lecture • 2min

Requirements

Description

Who this course is for: