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
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.
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.
Instructor
I have 6+ Year of experience IT experience. I worked on Various BI Tools Like Power BI, SSIS, SSRS, Domo, Python and SQL like SQL server, My SQL, Redshift and Snowflake. Currently, I am working as Sr Data Analyst at First America India and also Providing On demand Training. Apart From Work I do create Training Videos on You Tube.