Data Analysis Using Domo
Data Analysis and BI Reporting Using Domo BI Tool
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.
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.
What You Will 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
- Domo API
- Domo Embedding
- Domo Sandbox
- DDX Card
Who Should Attend!
- 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.