Domo BI

Business Intelligent

Created by : Rated :4.5 1093 views

Last Updated: 2023-07-12 05:07:27 English Course Type: Self Learning

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

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.

Basic SQL Is required

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

Section 1 : Introduction 2 Lectures 00:10:47
Lecture 1 :
Data Analysis Preview
Lecture 2 :
What is Domo
Section 2 : Basic SQL 26 Lectures 01:47:53
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 6 Lectures 00:27:18
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 21 Lectures 01:26:19
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 1 Lectures 00:04:43
Lecture 1 :
Create Alert on Data Flow
Section 6 : Personalized Data Permission 1 Lectures 00:02:24
Lecture 1 :
Personalized Data Permission
Section 7 : Cards and Dashboard 23 Lectures 01:57:56
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 1 Lectures 00:02:19
Lecture 1 :
Report Scheduling
Section 9 : Regex in Domo 1 Lectures 00:08:38
Lecture 1 :
Regex in Domo
Section 10 : Domo Task and Project 1 Lectures 00:07:41
Lecture 1 :
Domo Task and Project
Section 11 : Sumo Table 3 Lectures 00:19:06
Lecture 1 :
Sumo Table
Lecture 2 :
Sumo table Column View
Lecture 3 :
Sumo Table Pivot View
Section 12 : Choose Chart Type 6 Lectures 00:11:27
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 1 Lectures 00:05:21
Lecture 1 :
View

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?