Build Insightful Domo Cards and Dashboards

This skill provides expertise in creating Domo cards, data visualization, and dashboard design, with deep knowledge of Domo card types, Beast Mode calculations, data transformation, and visualization best practices, helping build compelling, performant, and actionable cards that deliver business insight. Core card creation principles cover data foundation (starting from clean, properly structured datasets, ensuring date fields are properly formatted and recognized by Domo, using DataFlows or Magic ETL for complex transformations rather than Beast Mode where possible, and implementing proper data governance with meaningful column names and descriptions) and card type selection (Bar Charts for category comparison, Line Charts for time-series and trend analysis, Tables when exact values matter more than visual trends, Single Value for KPIs needing immediate attention, Maps for geographic analysis, Funnel for process flow and conversion tracking).

Beast Mode calculation patterns cover core SQL patterns - running totals via windowed SUM(SUM(...)) OVER (ORDER BY ...), period-over-period growth percentage, conditional aggregation with CASE-based SUM, a 30-day moving average using ROWS BETWEEN 29 PRECEDING AND CURRENT ROW, ranking with ROW_NUMBER() OVER (PARTITION BY ...), and dynamic date-range filtering via CASE against CURDATE() intervals - and advanced patterns including cohort analysis (concatenating year and zero-padded month from a first-purchase date), statistical outlier detection using mean plus/minus two standard deviations, and dynamic revenue bucketing using PERCENTILE() thresholds.

Card configuration best practices cover visual design guidance (limiting color palettes to 5-7 colors, using Domo brand colors or a custom palette, conditional formatting for immediate insight recognition, appropriate chart scales, sparing use of data labels) and performance optimization (limiting dataset size through filters rather than loading all data, using summary datasets for high-level dashboards, proper DataFlow indexing on frequently filtered columns, avoiding overly complex Beast Mode calculations that scan entire datasets). Interactivity setup covers logical drill-down paths (category to subcategory to individual items) and consistent field naming across cards for dashboard-level global and date-range filters.

Dashboard design patterns cover an executive dashboard layout (top row of 3-4 Single Value KPI cards, second row trend line charts, third row detailed bar charts or tables, bottom row supporting detail cards) and an operational dashboard structure (real-time status indicators, exception reporting cards showing only items needing attention, process flow visualization, resource utilization metrics). Advanced capability implementation covers custom date ranges (fiscal year calculation via CASE on month, ISO-standard week-over-week via YEARWEEK(date, 1)) and alert configuration (meaningful thresholds based on historical data, percentage-based alerts for scalable metrics, tuned alert frequency to avoid fatigue, and context included in alert messages).

Use this skill when building Domo cards or dashboards - selecting card types, writing Beast Mode calculations, designing dashboard layout, or configuring alerts and drill-downs. It is well suited to Domo-based BI work needing performant, well-designed cards backed by clean datasets. It is not meant for non-Domo BI platforms, or for ad hoc one-off data pulls with no ongoing dashboard or card requirement.

Input: the Domo dataset(s) and the business metrics or KPIs the card/dashboard needs to surface.

Output: Beast Mode calculations, card type selections, and dashboard layout recommendations. Example Beast Mode period-over-period growth calculation:

(SUM(`Current Period Sales`) - SUM(`Previous Period Sales`)) / SUM(`Previous Period Sales`) * 100

Works within the Domo platform - Beast Mode SQL calculations, DataFlows/Magic ETL, and Personalized Data Permissions (PDP) for data security.

BI analysts and Domo dashboard builders creating performant, well-designed cards, and teams that need optimized Beast Mode calculations and governed dashboard layouts rather than ad hoc card creation. Also covers troubleshooting - null-value handling with COALESCE()/IFNULL(), inconsistent date formatting, duplicate-record grouping, slow-loading and memory/timeout issues from overly complex Beast Mode, mobile-optimized card layouts, and Personalized Data Permissions for sensitive data with approval workflows for production dashboards.