Corporate Domo Training Course

1. What is Domo?

1. Overview of Domo
2. Key features and capabilities

2. Why do we need Domo?

1. Challenges in modern business intelligence
2. How does Domo address data integration and visualization needs?

3. Pricing structure in Domo

1. Overview of pricing tiers
2. Comparison with other BI tools
3. Cost-benefit analysis for businesses

1. Domo's intelligence platform

1. Introduction to Domo's intelligence platform
2. Key components and architecture
3. Integrating with existing IT infrastructure

2. Creating Domo intelligence dashboard for end users

1. Design principles for effective dashboards
2. A step-by-step guide to creating your first dashboard

3. Successfully navigate the Domo interface

1. Overview of the Domo user interface
2. Tips and tricks for efficient navigation
3. Customizing the interface to fit your workflow

4. Database connectivity and how to add Google Sheets dataset in Domo

1. Basics of database connectivity in Domo
2. Connecting Domo to various data sources
3. Step-by-step guide to adding a Google Sheets dataset

1. Build basic cards

1. Understanding cards in Domo
2. Steps to build your first card
3. Tips for effective card design

2. The card analyzer in detail

1. Exploring the card analyzer features
2. How to use the card analyzer to gain insights?
3. Advanced analytics with the card analyzer

3. Card and dashboard design

1. Principles of card design for data visualization
2. Integrating cards into dashboards for cohesive storytelling
3. Customizing designs for different audiences

4. How to add a card to the dashboard?

1. Step-by-step process for adding cards to dashboards
2. Organizing cards on a dashboard for maximum impact
3. Managing dashboard layouts and settings

5. Sharing the dashboards and communicating in BUZZ

1. Overview of dashboard sharing options
2. Using BUZZ for communication and collaboration within Domo

6. Data visualization principles

1. Key principles of effective data visualization
2. Choosing the right chart types for your data
3. Design considerations for clarity and impact

7. Construct drill paths

1. Understanding drill paths and their importance
2. Creating interactive drill paths in Domo cards

8. Creating alerts in Domo

1. Setting up alerts for key metrics and thresholds
2. Customizing alert notifications for different users
3. Managing and responding to alerts

9. Create and subscribe to alerts

1. How to create alerts for critical data changes?
2. Subscribing to alerts for continuous monitoring

1. What is data warehousing?

1. Definition and importance of data warehousing
2. Components of a data warehouse
3. Benefits of using a data warehouse in business intelligence

2. OLTP vs OLAP

1. Differences between Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP)
2. How OLTP and OLAP contribute to business intelligence?

3. Type of OLAP – ROLAP, MOLAP, HOLAP

1. Overview of ROLAP (Relational OLAP), MOLAP (Multidimensional OLAP), and HOLAP (Hybrid OLAP)
2. Comparison of ROLAP, MOLAP, and HOLAP
3. Selecting the right OLAP type for your needs

4. What is a data mart?

1. Definition and purpose of a data mart
2. Differences between a data mart and a data warehouse
3. Implementing data marts in your organization

5. Dimension

1. Understanding dimensions in data warehousing
2. Types of dimensions and their roles

6. Fact

1. Exploring fact tables in data warehousing
2. Types of fact tables and their uses
3. Designing fact tables for efficient data retrieval

7. Star schema

1. Introduction to the star schema in data warehousing
2. Components and benefits of a star schema
3. Designing a star schema for a data warehouse

8. Snowflake schema

1. Understanding the snowflake schema and how it differs from the star schema
2. Advantages and disadvantages of the snowflake schema
3. Implementing a snowflake schema in data warehousing

9. Cube

1. The concept of cubes in data warehousing
2. Building and using cubes for data analysis

1. What is SQL?

1. Introduction to Structured Query Language (SQL)
2. Importance of SQL in data management and analysis
3. Overview of SQL syntax and structure

2. Table structure

1. Understanding the structure of tables in SQL
2. Creating tables and defining schema

3. Constraints

1. Types of constraints in SQL and their purposes
2. Implementing constraints to ensure data integrity

4. Writing select statements

1. Basics of the SELECT statement in SQL
2. Using WHERE, GROUP BY, and ORDER BY clauses
3. Advanced SELECT techniques for data analysis

5. JOINS

1. Overview of JOIN operations in SQL
2. Types of JOINS
3. Writing JOIN queries to combine data from multiple tables

6. UNION, UNION ALL

1. Understanding UNION and UNION ALL operations
2. Differences between UNION and UNION ALL

7. Aggregations, GROUP BY, HAVING

1. Aggregation functions in SQL and their uses
2. Grouping data with GROUP BY
3. Filtering aggregated data with HAVING

8. DML & DDL statements

1. Differentiating between Data Manipulation Language (DML) and Data Definition Language (DDL)
2. Common DML operations: INSERT, UPDATE, DELETE
3. Common DDL operations: CREATE, ALTER, DROP