Data Analyst Persona + LEDOW

Overview Demo

Bigeye for Data Analysts

BI Extensions

Part 1: In-App Dashboard Health

Dependency Driven Monitoring, Autometrics, Autothresholds

Part 2: Scaling Data Quality Automation

Lineage
lineage search
Help for search patterns
Close right hand pane

Lineage | Bigeye

Get started with monitoring. Automatically deploy Nulls, Duplicates, Freshness, Volume, Min, Max, and Average metrics on all upstream connected columns.

Custom Rules

Part 3: Custom Business Rules

All Sources | Bigeye

snowflake_warehouse | Bigeye

SQL run successful. This would have alerted with given conditions.
Set up monitoring by pasting in or writing SQL.
Learn more
Rule name
SQL
1
2
3
⌄
select *
from tooy_demo.prod_repl.orders
where price_per_unit < 1
Preview query
row 0: "ORDER_ID": "42610", "CUSTOMER_ID": "4527", "PAYMENT_METHOD_ID": "11225", "PRODUCT_TYPE": "CD", "QUANTITY": "13", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "3901 West End Avenue", "SHIPPING_ADDRESS_2": "#902", "SHIPPING_CITY": "Nashville", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "37205", "ORDER_TIMESTAMP": "2024-11-08 02:22:23.0"
row 1: "ORDER_ID": "42603", "CUSTOMER_ID": "4202", "PAYMENT_METHOD_ID": "10439", "PRODUCT_TYPE": "EIGHT_TRACK", "QUANTITY": "19", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "116 Queens Lane", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Nashville", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "37218", "ORDER_TIMESTAMP": "2024-11-08 00:22:48.0"
row 2: "ORDER_ID": "42575", "CUSTOMER_ID": "2550", "PAYMENT_METHOD_ID": "6370", "PRODUCT_TYPE": "VINYL_LP", "QUANTITY": "25", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "7420 Bearfoot Circle", "SHIPPING_ADDRESS_2": "#APT 000003", "SHIPPING_CITY": "Anchorage", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "99502", "ORDER_TIMESTAMP": "2024-11-08 02:24:58.0"
row 3: "ORDER_ID": "42617", "CUSTOMER_ID": "4626", "PAYMENT_METHOD_ID": "11470", "PRODUCT_TYPE": "VINYL_LP", "QUANTITY": "4", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "9302 West 58th Avenue", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Arvada", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "80002", "ORDER_TIMESTAMP": "2024-11-08 02:06:45.0"
row 4: "ORDER_ID": "42543", "CUSTOMER_ID": "1063", "PAYMENT_METHOD_ID": "2666", "PRODUCT_TYPE": "VINYL_LP", "QUANTITY": "25", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "109 East 64th Street", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Savannah", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "31405", "ORDER_TIMESTAMP": "2024-11-08 00:09:59.0"
row 5: "ORDER_ID": "42604", "CUSTOMER_ID": "4324", "PAYMENT_METHOD_ID": "10731", "PRODUCT_TYPE": "VINYL_LP", "QUANTITY": "16", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "521 McGregor Court", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Montgomery", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "36117", "ORDER_TIMESTAMP": "2024-11-08 00:25:27.0"
row 6: "ORDER_ID": "42564", "CUSTOMER_ID": "2124", "PAYMENT_METHOD_ID": "5289", "PRODUCT_TYPE": "CD", "QUANTITY": "12", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "5721 Frank Hough Road", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Panama City", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "32404", "ORDER_TIMESTAMP": "2024-11-08 01:39:21.0"
row 7: "ORDER_ID": "42596", "CUSTOMER_ID": "3966", "PAYMENT_METHOD_ID": "9872", "PRODUCT_TYPE": "EIGHT_TRACK", "QUANTITY": "20", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "6123 West Marlette Avenue", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Glendale", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "85301", "ORDER_TIMESTAMP": "2024-11-08 01:45:38.0"
row 8: "ORDER_ID": "42666", "CUSTOMER_ID": "7248", "PAYMENT_METHOD_ID": "18087", "PRODUCT_TYPE": "CASSETTE", "QUANTITY": "14", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "313 Wiley Street", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Nashville", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "37115", "ORDER_TIMESTAMP": "2024-11-08 01:37:15.0"
row 9: "ORDER_ID": "42699", "CUSTOMER_ID": "9192", "PAYMENT_METHOD_ID": "22928", "PRODUCT_TYPE": "EIGHT_TRACK", "QUANTITY": "9", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "201 East 9th Avenue", "SHIPPING_ADDRESS_2": "#APT 000102", "SHIPPING_CITY": "Anchorage", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "99501", "ORDER_TIMESTAMP": "2024-11-08 02:17:14.0"
row 10: "ORDER_ID": "42649", "CUSTOMER_ID": "5854", "PAYMENT_METHOD_ID": "14570", "PRODUCT_TYPE": "CASSETTE", "QUANTITY": "22", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "225 Kennedy Road", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Manchester", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "06042", "ORDER_TIMESTAMP": "2024-11-08 00:47:00.0"
row 11: "ORDER_ID": "42533", "CUSTOMER_ID": "376", "PAYMENT_METHOD_ID": "953", "PRODUCT_TYPE": "CASSETTE", "QUANTITY": "20", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "5836 Red Barn Road", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Montgomery", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "36116", "ORDER_TIMESTAMP": "2024-11-08 01:36:01.0"
row 12: "ORDER_ID": "42664", "CUSTOMER_ID": "6837", "PAYMENT_METHOD_ID": "17060", "PRODUCT_TYPE": "VINYL_LP", "QUANTITY": "7", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "903 East 20th Avenue", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Anchorage", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "99501", "ORDER_TIMESTAMP": "2024-11-08 00:55:14.0"
row 13: "ORDER_ID": "42648", "CUSTOMER_ID": "5854", "PAYMENT_METHOD_ID": "14570", "PRODUCT_TYPE": "CD", "QUANTITY": "25", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "269 Park Street", "SHIPPING_ADDRESS_2": "#1", "SHIPPING_CITY": "North Reading", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "01864", "ORDER_TIMESTAMP": "2024-11-08 00:19:19.0"
row 14: "ORDER_ID": "42647", "CUSTOMER_ID": "5854", "PAYMENT_METHOD_ID": "14570", "PRODUCT_TYPE": "CD", "QUANTITY": "25", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "5715 Saint Matthew Drive", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Newark", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "94560", "ORDER_TIMESTAMP": "2024-11-08 01:40:21.0"
row 15: "ORDER_ID": "42593", "CUSTOMER_ID": "3788", "PAYMENT_METHOD_ID": "9444", "PRODUCT_TYPE": "EIGHT_TRACK", "QUANTITY": "27", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "125 Summer Street", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Manchester", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "06040", "ORDER_TIMESTAMP": "2024-11-08 02:04:36.0"
row 16: "ORDER_ID": "42561", "CUSTOMER_ID": "1828", "PAYMENT_METHOD_ID": "4558", "PRODUCT_TYPE": "CASSETTE", "QUANTITY": "29", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "1345 G Street Southeast", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Washington", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "20003", "ORDER_TIMESTAMP": "2024-11-08 00:25:44.0"
row 17: "ORDER_ID": "42628", "CUSTOMER_ID": "5060", "PAYMENT_METHOD_ID": "12567", "PRODUCT_TYPE": "EIGHT_TRACK", "QUANTITY": "29", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "103 Edgewater Road", "SHIPPING_ADDRESS_2": "A", "SHIPPING_CITY": "Severna Park", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "21146", "ORDER_TIMESTAMP": "2024-11-08 01:27:51.0"
row 18: "ORDER_ID": "42549", "CUSTOMER_ID": "1429", "PAYMENT_METHOD_ID": "3556", "PRODUCT_TYPE": "CD", "QUANTITY": "1", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "128 East Oak Street", "SHIPPING_ADDRESS_2": "#3", "SHIPPING_CITY": "Louisville", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "40203", "ORDER_TIMESTAMP": "2024-11-08 00:30:06.0"
row 19: "ORDER_ID": "42538", "CUSTOMER_ID": "887", "PAYMENT_METHOD_ID": "2227", "PRODUCT_TYPE": "EIGHT_TRACK", "QUANTITY": "30", "PRICE_PER_UNIT": "0", "SHIPPING_ADDRESS_1": "4235 Phelan Court", "SHIPPING_ADDRESS_2": "", "SHIPPING_CITY": "Montgomery", "SHIPPING_STATE": "NM", "SHIPPING_ZIP": "36116", "ORDER_TIMESTAMP": "2024-11-08 00:41:23.0"
Alert conditions
Alert on rows returned
Alert on no rows returned
Alert if single value outside of range
Range
Lower threshold
Upper threshold

No schedule
5 minutes
15 minutes
30 minutes
60 minutes
3 hours
6 hours
12 hours
24 hours

check proper prices | Bigeye

Lineage Plus, Root Cause Analysis, Impact Analysis, Incident Management

Part 4: Automatic Root Cause Analysis

The average value is too low on PRICE_PER_UNIT

ORDERS | Bigeye

The average value is too low on PRICE_PER_UNIT | Bigeye

The average value is too low in 1 of 17 groups on PRICE_PER_UNIT | Bigeye

Has issues — View 10 issues for PRICE_PER_UNIT
PRICE_PER_UNIT
Has issues — View 1 issue for ORDER_TIMESTAMP
ORDER_TIMESTAMP
orders
Has issues — View 2 issues for orders
Issues: 2
Expand node orders
orders
Root cause — View 13 issues for orders
Root causes: 2
Expand node orders
ORDERS
Has issues — View 11 issues for ORDERS
Issues: 11
View options for ORDERS
Collapse node ORDERS
PRICE_REPORTING
At risk - View issues for PRICE_REPORTING
At risk
Expand node PRICE_REPORTING
SALES_DASHBOARD
Has issues — View 3 issues for SALES_DASHBOARD
Issues: 3
Expand node SALES_DASHBOARD
ORDER_ANALYTICS
Has issues — View 3 issues for ORDER_ANALYTICS
Issues: 3
Expand node ORDER_ANALYTICS
s3_lake
AwsDataCatalog.tooy_demo_db_iceberg
Tables: 1
Has issues — View 2 issues for AwsDataCatalog.tooy_demo_db_iceberg
Issues: 2
Collapse node AwsDataCatalog.tooy_demo_db_iceberg
pg_webapp
tooy_demo_db.prod
Tables: 1
Root cause — View 13 issues for tooy_demo_db.prod
Root cause: 1
Collapse node tooy_demo_db.prod
snowflake_warehouse
TOOY_DEMO.PROD_REPL
Tables: 1
Has issues — View 11 issues for TOOY_DEMO.PROD_REPL
Issues: 11
Collapse node TOOY_DEMO.PROD_REPL
snowflake_warehouse
TOOY_DEMO.CONFORMED
Tables: 3
Has issues — View 6 issues for TOOY_DEMO.CONFORMED
Issues: 6
Collapse node TOOY_DEMO.CONFORMED
Demo-demo_cloud
Retail Analytics Workbook
Nodes: 4
At risk
Expand node Retail Analytics Workbook

price_per_unit | Bigeye

Topics covered: autometrics,  BI extensions. Please book a custom demo to see how we can help your team reduce analytics downtime and prove higher trust/ROI with your business team.