Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
4 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
4 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- Best Practice of Creating Cards, Data Flow, Dashboards
- Learner will be able to Create alert, Domo Stats
- Learner will be able to Create Cards, Dashboard, PDP
- Learner will be able to create DataFlow based on requirement using SQL and ETL
Course Overview
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.
Pre-requisites
- Basic SQL Is required
Target Audience
- 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
Curriculum 93 Lectures 06:51:52
-
Section 1 : Introduction
- Lecture 2 :
- What is Domo
-
Section 2 : Basic SQL
- Lecture 1 :
- Basic SQL Statement
- Lecture 2 :
- Where Clause with and, or Operator
- Lecture 3 :
- Where Clause with Exist, IN, Not Exist
- Lecture 4 :
- Where clause with Is Null, Is Not Null
- Lecture 5 :
- Where Clause with Like
- Lecture 6 :
- Where Clause with Not Like
- Lecture 7 :
- Where Clause with Greater than , Less Than
- Lecture 8 :
- Where Clause with Equal, Not Equal
- Lecture 9 :
- Union and Union All
- Lecture 10 :
- Intersection
- Lecture 11 :
- Except
- Lecture 12 :
- Sub Query
- Lecture 13 :
- Nested Sub Query
- Lecture 14 :
- Sub Query With Exist and Not Exist
- Lecture 15 :
- Sub Query with Any and All
- Lecture 16 :
- Co-Related Sub Query
- Lecture 17 :
- Subquery in Expression
- Lecture 18 :
- Subquery in From Clause
- Lecture 19 :
- Function in SQL
- Lecture 20 :
- String and Date Function
- Lecture 21 :
- Join in SQL
- Lecture 22 :
- Rank and Window Function
- Lecture 23 :
- Lead and Lag
- Lecture 24 :
- First and Last
- Lecture 25 :
- NTILE Function
- Lecture 26 :
- CUM Distributive Function
-
Section 3 : Connect Data Source in Domo
- Lecture 1 :
- Connect Data Source in Domo
- Lecture 2 :
- File Upload in Domo
- Lecture 3 :
- Workbench Domo
- Lecture 4 :
- Export Data Using Workbench
- Lecture 5 :
- Federated Data Source in Domo
- Lecture 6 :
- Domo Job Scheduling Using Window Task Scheduler
-
Section 4 : Transforming Data into Domo
- Lecture 1 :
- SQL Transformation
- Lecture 2 :
- Data Blending
- Lecture 3 :
- Domo ETL Introduction
- Lecture 4 :
- Text Transformation - Combine Column
- Lecture 5 :
- ETL-Date and Number Transformation
- Lecture 6 :
- ETL-Utility Transformation
- Lecture 7 :
- ETL-Group By Transformation
- Lecture 8 :
- ETL-Pivot Transformation
- Lecture 9 :
- Split Transformation
- Lecture 10 :
- Replace Text Transformation
- Lecture 11 :
- String Operation
- Lecture 12 :
- Text Formatting
- Lecture 13 :
- ETL-Number Transformation
- Lecture 14 :
- ETL-Filter Transformation
- Lecture 15 :
- ETL- Unpivot Transformation
- Lecture 16 :
- ETL-Dynamic Unpivot Transformation
- Lecture 17 :
- ETL-Join Transformation
- Lecture 18 :
- ETL-Append Transformation
- Lecture 19 :
- ETL-Remove Duplicate Transformation
- Lecture 20 :
- ETL-Rank and Window Transformation
- Lecture 21 :
- Data Flow Project
-
Section 5 : Alerts on Data Flow
- Lecture 1 :
- Create Alert on Data Flow
-
Section 6 : Personalized Data Permission
- Lecture 1 :
- Personalized Data Permission
-
Section 7 : Cards and Dashboard
- Lecture 1 :
- Domo Card InterFace
- Lecture 2 :
- Card Design
- Lecture 3 :
- Chart Types in Domo
- Lecture 4 :
- Filter in Domo Report
- Lecture 5 :
- Chart with Date Dimension
- Lecture 6 :
- Create Report with tooltips
- Lecture 7 :
- Create Page and Dashboard in Domo
- Lecture 8 :
- Best Practice For Dashboard Design
- Lecture 9 :
- Segment in Domo
- Lecture 10 :
- Variable in Domo
- Lecture 11 :
- Card Editing
- Lecture 12 :
- Card Editing with Chart Property
- Lecture 13 :
- Move
- Lecture 14 :
- Copy
- Lecture 15 :
- Saves As
- Lecture 16 :
- The differences between Move/Copy and Save As
- Lecture 17 :
- Linking and locking cards
- Lecture 18 :
- Introducing Domo Stories
- Lecture 19 :
- Add Cards in Domo
- Lecture 20 :
- Card and Dashboard Project Part 1
- Lecture 21 :
- Card and Dashboard Project Part 2
- Lecture 22 :
- Card and Dashboard Project Part 3
- Lecture 23 :
- Card and Dashboard Project Part 4
-
Section 8 : Report Scheduling
- Lecture 1 :
- Report Scheduling
-
Section 9 : Regex in Domo
- Lecture 1 :
- Regex in Domo
-
Section 10 : Domo Task and Project
- Lecture 1 :
- Domo Task and Project
-
Section 11 : Sumo Table
- Lecture 1 :
- Sumo Table
- Lecture 2 :
- Sumo table Column View
- Lecture 3 :
- Sumo Table Pivot View
-
Section 12 : Choose Chart Type
- Lecture 1 :
- Choose Chart Type
- Lecture 2 :
- Chart Type For Comparative questions
- Lecture 3 :
- Chart Type For Relationship questions
- Lecture 4 :
- Chart Type For Trending questions
- Lecture 5 :
- Chart Type For Composition questions
- Lecture 6 :
- Chart Type For Distribution questions
-
Section 13 : View
- Lecture 1 :
- View
Our learners work at
Frequently Asked Questions
-
How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time. -
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic. -
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on. -
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want. -
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly. -
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
-
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions. -
Is there any free trial?
Currently, we do not offer any free trial. -
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
