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)
Section 1: Data Pipelines
Section 2: Presenting the Message
Section 3: Communicating to Win
Section 4: Extending
Section 5: Governing

Using pivot tables

Domo's pivot table implementation lets you pivot on any Domo dataset. In Domo, Pivot Tables are implemented through something called a Sumo Card. The sumo card is a special card type that has been built to pivot table data. So, we need to create a new card using the Sumo Table card type. Let's go through an example:

  1. From the Sales dashboard, click on the + icon in the page header and then click on + Create new card.
  2. Click on the VIEW MORE button, and then click on the SELECT button under Sumo Table. Then, choose the dataset by selecting Opportunity CH7 in the DataSet: box, and click on CHOOSE DATASET.
  3. Let's pivot on the sales amount by type and date. Click on the pivot table icon just underneath the pencil icon on the left-hand side. Click, drag, and drop the Type field under the CATEGORIES section to the rows area that is directly above CATEGORIES.
  4. Under the VALUES list, click, drag, and drop the Amount field into the DRAG VALUES...