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