Skip to content

Count

Count is a collaborative data analytics platform combining notebook-style analysis with visualization capabilities. In Data Team we use it for ad-hoc analysis.

Overview

Count combines features of:

  • 📓 Digital Whiteboards - Flexible canvas for analysis
  • 📊 BI Tools - Create charts and dashboards
  • 💻 Notebooks - SQL and Python cells
  • 🤝 Collaboration - Real-time teamwork

Access

Count Platform

Ask Data Team for access.

Resources

Data Architecture

[TODO] move the architecture to the documentation repo View our data warehouse architecture and data flow diagrams:

Data Architecture Canvas

Best Practices

  • aggregate early
  • prefix SQL cells with c_ when caching
  • prefix parameters with p_ (easier to find)

Create clickable links to Hydra user profiles:

concat('https://hydra.majority.com/user/', user_id) as hydra

Link to KYC attempts in Hydra:

concat('https://hydra.majority.com/kyc/', user_id, '/', attempt_id) as hydra_kyc

Link to Alloy evaluations:

concat('https://app.alloy.co/entities/', entity_token, '/evaluations/', evaluation_token) as alloy_evaluation

Example Usage

SELECT
    user_id,
    user_name,
    concat('https://hydra.majority.com/user/', user_id) as hydra,
    kyc_status
FROM users
WHERE kyc_status = 'pending'

This creates a clickable hydra column that opens the user profile directly.