Book Image

Data Democratization with Domo

By : Jeff Burtenshaw
Book Image

Data Democratization with Domo

By: Jeff Burtenshaw

Overview of this book

Domo is a power-packed business intelligence (BI) platform that empowers organizations to track, analyze, and activate data in record time at cloud scale and performance. Data Democratization with Domo begins with an overview of the Domo ecosystem. You’ll learn how to get data into the cloud with Domo data connectors and Workbench; profile datasets; use Magic ETL to transform data; work with in-memory data sculpting tools (Data Views and Beast Modes); create, edit, and link card visualizations; and create card drill paths using Domo Analyzer. Next, you’ll discover options to distribute content with real-time updates using Domo Embed and digital wallboards. As you advance, you’ll understand how to use alerts and webhooks to drive automated actions. You’ll also build and deploy a custom app to the Domo Appstore and find out how to code Python apps, use Jupyter Notebooks, and insert R custom models. Furthermore, you’ll learn how to use Auto ML to automatically evaluate dozens of models for the best fit using SageMaker and produce a predictive model as well as use Python and the Domo Command Line Interface tool to extend Domo. Finally, you’ll learn how to govern and secure the entire Domo platform. By the end of this book, you’ll have gained the skills you need to become a successful Domo master.
Table of Contents (26 chapters)
1
Section 1: Data Pipelines
7
Section 2: Presenting the Message
12
Section 3: Communicating to Win
17
Section 4: Extending
21
Section 5: Governing

Setting alerts on a dataset

Setting alerts at the dataset level is more flexible in some ways than setting the alert at the card level. In fact, dataset alerting was created to address several limitations of setting alerts at the card level. Those card-level limitations included only having one criterion and only being able to include the triggered value and not additional information in the alert. Let's create an alert using the dataset alert feature and see how some of these limitations were overcome. Let's make an alert for the West Region to alert the sales manager, which triggers immediately when each account in the region drops 50% or more below the prior year's sales and creates a task for the manager to follow up.

Creating a supporting materialized view for the alert

We need to create an account aggregate view and then create a materialized dataset from the view to support the alert.

Important Note

Views, fusions, and beast modes are not supported...