Count
count.co
  • Getting Started
    • What is Count?
    • Count FAQ
    • Intro to your workspace
    • Example canvases
    • Getting started guides
      • Set up your workspace and projects
        • 1. Review workspace settings
        • 2. Create and organise your projects
      • Canvas orientation
      • Your first ad hoc analysis
        • 1. Examples and templates
        • 2. Build your first queries
        • 3. Create visuals
        • 4. Caching, local cells and scheduling
        • 5. Collaborating with a stakeholder
      • Your first report
        • 1. Examples and templates
        • 2. Filters and control cells
        • 3. Sharing your report
        • 4. Alerts
  • Connect your data
    • Database connection overview
      • Athena
      • Azure Synapse
      • BigQuery
      • Databricks
      • Microsoft SQL Server
      • MySQL
      • PostgreSQL
      • Redshift
      • Snowflake
    • Refresh database schema
    • Upload CSV files
    • dbt integration
      • ☁️dbt Cloud integration
      • 👩‍💻dbt Core integration
  • Import & Export
    • Import from other tools
      • Import Miro files
      • Import SQL files
      • Import Google Sheets
      • Import Jupyter notebooks
    • Export code and results
      • Export compiled SQL and Jinja-SQL
      • Export CSV files
      • Export images and PDF files
  • THE CANVAS
    • Navigating the canvas
      • Canvas tool bar
      • Data sidebar
      • Customizing the canvas
    • Canvas objects
      • Cells
      • Text and markdown
      • Shapes and tools
      • Sticky notes
      • Frames
      • Images
      • Embeds
      • Stamps
      • Grouping objects
      • Object order and alignment
      • Locking objects
      • Scaling objects
      • Shared styles
    • Overviews
    • Templates
    • Count AI
    • Alerts and subscriptions
      • Slack integration
    • Keyboard shortcuts
  • Querying data
    • Cells overview
      • Dynamic query compilation engine
    • SQL cells
      • Referencing other cells
      • Jinja templating
      • SQL formatting
    • Python cells
    • Visual and low-code cells
      • Calculations in visuals and low-code cells
      • Joins in visuals and low-code cells
    • Control cells
      • Single and multiple selects
      • Date controls
      • Text, number, and boolean controls
      • Custom control cells
    • Local DuckDB cells
      • DuckDB on the server
    • Query caching and scheduling
    • Manage queries and results
    • Troubleshooting
  • Visualizing data
    • Visualization overview
    • Templated visuals
    • Custom visuals
      • Marks
      • Facet
      • Subplots
      • Style
      • Filters
    • Formatting a visual
      • Axes
        • Secondary Axis
      • Colors and labels
      • Legends
      • Tooltips
    • Column summaries
    • Dynamic text
    • Every Visual Under the Sun
  • Presenting and Reporting
    • Reports and Slides
  • Count Metrics
    • Intro to Count Metrics
    • Build and edit a catalog
    • Views
      • Creating views
      • Customizing views
    • Datasets
      • Creating datasets
    • Save changes to the catalog
      • Catalog validation
      • Version control
    • Exposing catalogs to the workspace
    • Caching in Count Metrics
    • Using the catalog
      • Explore from cell
  • Sharing and Permissions
    • Real-time collaboration
    • Comments
    • Sharing permissions
    • Shared links
    • Embedding canvases
  • History and Versions
    • Version control
    • Duplicating and merging
    • Data snapshots
  • Settings and administration
    • Workspace settings
      • Workspace members
      • Groups
      • Tags
      • Billing
      • Single sign-on (SSO)
        • Okta
        • Entra ID
        • JumpCloud
        • Google
        • Generic OIDC
      • Brand
    • Connection settings
    • Project settings
    • User settings
    • Roles and permissions
  • Quick guides
    • Interactive control guides
      • Date ranges
      • Date groupings
      • Search
      • Select All
  • Resources
    • Join the Slack community
  • Blog
  • Security overview
  • Terms of use
  • Pricing FAQ
Powered by GitBook
On this page
  • Database connections
  • Project naming conventions
  • Project permissions
  • FAQ
  1. Getting Started
  2. Getting started guides
  3. Set up your workspace and projects

2. Create and organise your projects

Previous1. Review workspace settingsNextCanvas orientation

Last updated 7 months ago

Once your workspace is set up, you'll want to create projects. Projects house all your canvases, so you'll want to consider how to structure them effectively.

Here are three aspects to consider:

Database connections

If you've connected your database, you'll see an option to select which database connection you want associated with each project. All canvases within a project will have access to all databases connected to that project.

Project naming conventions

While you may want to have fewer projects when you initially start, keep these naming conventions in mind as you scale your usage in Count.

  1. Per-analyst projects:

    • Name examples: "Harriet's Playground" or "Harriet's Sandbox"

    • Purpose: Start exploratory work without confusing others. Move it to a shared project when ready to share.

  2. Company-wide projects:

    • Purpose: For training and MVP canvases.

    • Example: "Company Metric Tree"

  3. Department/team projects:

    • Name examples: "[Team Name] Project Name"

    • Purpose: Helps organize projects by team, making it easy to find related projects.

Here's an example of this structure in action:

Project permissions

Permissions can be set at both the project and canvas levels, offering a lot of flexibility and control.

To update your project-level permissions:

  1. Select the project

  2. Click Manage access in the right-hand side menu

  3. Set the workspace and/or individual permissions

Only projects a user has access to are visible in the sidebar (except for owners, who have access to all projects/canvases).

FAQ

How should I set up projects to restrict access to PII data?

You'll want to create separate database connections, at least one with PII data and one without.

Then create a project that connects to your database connection with PII data, and make sure the permissions for that project are restricted to only the users you want to grant access.

Read more about database connections .

Read more about project-level roles and permissions .

Read more about canvas-level permissions .

here
here
Database connections
Naming conventions
Permissions
here
Create a new project within your workspace
An example of how you can set up your projects with project for individuals, departments, and the whole company