Data Analysis and BI Reporting Using Domo BI Tool
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:
What you’ll learn
- Learner will be able to bring data into Domo through Various resource like File, Cloud, Database.
- 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.
Course Content
- Introduction –> 2 lectures • 10min.
- Domo Task and Project –> 1 lecture • 8min.
- Connect Data Source in Domo –> 6 lectures • 27min.
- Transforming Data into Domo –> 22 lectures • 1hr 40min.
- Domo Data Ware House –> 1 lecture • 2min.
- Data Flow Project –> 1 lecture • 15min.
- View in Domo –> 1 lecture • 5min.
- Alerts on Data Flow –> 1 lecture • 5min.
- Personalized Data Permission –> 1 lecture • 2min.
- Choose Chart Type in Domo –> 6 lectures • 11min.
- Sumo Table –> 2 lectures • 18min.
- Cards and Dashboard –> 21 lectures • 1hr 58min.
- Project Card and Dashboard –> 4 lectures • 45min.
- Report Scheduling –> 1 lecture • 2min.
- Assignment –> 0 lectures • 0min.
- DOMO Interview Questions –> 1 lecture • 6min.
- Beast Mode Calculation –> 5 lectures • 25min.
- Domo Buzz –> 1 lecture • 4min.
- Domo Admin –> 1 lecture • 8min.
- Basic SQL –> 30 lectures • 2hr 27min.
- Bonus –> 8 lectures • 29min.
- Domo App –> 5 lectures • 20min.
Requirements
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.