​
Working with Tables and Views

Understanding Tables Tables in Elementum are dynamic, real-time data views that automatically stay synchronized with your data sources. They transform raw data into actionable business insights through an intuitive interface. Data Sources for Tables:
  • CloudLinks - Connect to external data warehouses (Snowflake, BigQuery, etc.)
  • Apps - Data from your custom applications
  • Elements - Shared data across teams and departments
  • Tasks - Workflow steps and progress tracking

​
Why Tables Matter for Your Business

​
Single Source of Truth

  • Everyone works with the same, current data
  • No more emailing spreadsheets around
  • Updates happen in real-time
  • Eliminate data copy-paste errors

​
Custom Views for Different Needs

  • Sales team sees revenue metrics
  • Support team sees customer issues
  • Finance sees payment status
  • Leadership sees high-level summaries
  • All from the same underlying data

​
Configuring Data Sources

​
Snowflake View Configuration

When connecting to Snowflake or other data warehouses, you’ll configure: Database Selection
  • Choose your target database from available options
  • Example: ACME_ANALYTICS_PROD
Schema Selection
  • Select the appropriate schema within your database
  • Example: DATA
View Name
  • Define a meaningful name for your view
  • Example: DET (Deal Execution Table)
Proper naming conventions help team members quickly identify and locate the right data views.

​
Table Features

​
1. Joins - Combining Data Made Easy

Elementum provides four join types with visual representations to help you understand how data will be combined. Each join type serves different business needs: Join Configuration:
  • Source Field: Select the field from your primary table
  • Joined Object Field: Select the matching field from the secondary table
  • The system guides you through field selection with dropdown menus
Choosing the right join: Start by asking yourself: “Do I need ALL records from my primary table, or only the ones that have matching data?” This will help you decide between inner joins (matches only) and outer joins (keep everything).

​
2. Table Details and Configuration

General Settings:
  • Table Name: Define a clear, descriptive name
  • Category: Organize tables by type (Data, Analytics, etc.)
  • Source: Links to your original data source
Cloud Details:
  • Cloud Provider: Shows connected service (Porter, Snowflake, etc.)
  • Connection Status: Verify active data connections
Business Intelligence:
  • Snowflake View: Configure and manage your BI connections
  • Performance Monitoring: Track query performance and usage
Snowflake View for External BI ToolsThe Snowflake View feature allows you to expose your Elementum data to external business intelligence tools like PowerBI, Tableau, or Looker. Here’s how it works:
  1. Create your Elementum table from any data source (Apps, Tasks, Elements, or CloudLinks)
  2. Configure the Snowflake View in the Business Intelligence section
  3. Connect external BI tools directly to your Snowflake view
  4. Build dashboards and reports using your Elementum data in familiar BI platforms
This is particularly useful when you need to:
  • Combine Elementum data with other enterprise data sources
  • Create executive dashboards in existing BI infrastructure
  • Enable self-service analytics for business users
  • Maintain data governance while providing external access
The view automatically stays synchronized with your Elementum data, ensuring your BI reports always reflect the latest information.

​
3. Column Management

Visible Columns
  • Show/hide columns based on user needs
  • Drag and drop to reorder columns
  • Search through available columns
  • Lock important columns in place
Hidden Columns
  • Store additional data without cluttering the view
  • Quick toggle to show/hide groups of columns
  • Maintain data integrity while optimizing display
Column Features:
  • Calculated Columns: Create formulas like Total Revenue = Quantity × Price
  • Data Types: Automatic detection and formatting
  • Sorting: Click column headers to sort data
  • Filtering: Use advanced filters for precise data selection

​
Calculated Columns - Advanced Data Transformation

Understanding Calculated Columns Calculated columns are one of the most valuable features in Elementum tables. They allow you to create new data columns based on existing table data using Excel-like formulas. This transforms your static data into dynamic insights. What You Can Do:
  • Mathematical Operations: Revenue = Quantity × Price
  • Date Calculations: Days_Open = TODAY() - Created_Date
  • Conditional Logic: Risk_Level = IF(Amount > 10000, "High", "Low")
  • Text Manipulation: Full_Name = CONCAT(First_Name, " ", Last_Name)
  • Aggregations: Total_Orders = COUNT(Orders.ID)
Column Configuration:
  • Column Name: Give your calculated column a descriptive name
  • Function: Enter your formula using Excel-like syntax
  • Format Options:
    • Format as percentage
    • Format as percentage and multiply by 100
    • Format as currency
    • No formatting (default)
Available Functions: Elementum supports a comprehensive set of calculation functions similar to Excel, including:
  • Mathematical: SUM, AVERAGE, MIN, MAX, ROUND, POWER, SQRT
  • Logical: IF, AND, OR, NOT
  • Date/Time: DATE, NOW, DATEDIF, WEEKDAY, YEAR, MONTH, DAY
  • Text: CONCAT, LEFT, RIGHT, MID, UPPER, LOWER, TRIM
  • Lookup: VLOOKUP, COUNTIF, SUMIF, SEARCH, FIND
For a complete list of functions and their syntax, see our Calculations Reference. Real-World Examples: Sales Analytics: 
Commission = IF(Deal_Value > 50000, Deal_Value * 0.05, Deal_Value * 0.03)
Days_in_Pipeline = DATEDIF(Created_Date, NOW(), "D")
Deal_Size_Category = IF(Deal_Value > 100000, "Enterprise", IF(Deal_Value > 10000, "Mid-Market", "SMB"))
Customer Analysis: 
Customer_Lifetime_Value = SUM(Orders.Total_Amount)
Last_Order_Days = DATEDIF(MAX(Orders.Order_Date), NOW(), "D")
Customer_Status = IF(Last_Order_Days > 365, "Inactive", "Active")
Financial Reporting: 
Profit_Margin = (Revenue - Cost) / Revenue * 100
Quarterly_Growth = (Current_Quarter - Previous_Quarter) / Previous_Quarter * 100
Budget_Variance = Actual_Amount - Budget_Amount
Performance Consideration: While calculated columns are flexible, creating too many complex calculations can impact table performance. Each calculated column requires processing time when the table loads. For optimal performance:
  • Limit complex calculated columns to essential business logic
  • Use simple calculations when possible
  • Consider pre-calculating values in your data source for frequently used complex formulas
  • Monitor table load times and optimize as needed
  • Increase warehouse size for better performance with complex calculations and large datasets
Excel-Like Syntax: If you’re familiar with Excel formulas, you’ll feel right at home with Elementum’s calculation syntax. The functions work similarly to Excel, making it easy to create advanced data transformations without learning new syntax.
Filter Options:
  • Field Selection: Choose any column for filtering
  • Operators: Contains, equals, greater than, less than, etc.
  • Values: Direct input or dropdown selection for known values
  • Condition Groups: Combine multiple filters with AND/OR logic
Filter Management:
  • Add Condition: Build complex filter logic
  • Condition Groups: Organize related filters
  • Clear All: Reset filters quickly
  • Save Views: Store frequently used filter combinations

​
5. Data Operations

Join Operations
  • Visual interface for combining tables
  • Real-time preview of join results
  • Field mapping assistance
  • Performance optimization suggestions
Data Cleaning
  • Fix formatting issues automatically
  • Standardize values across columns
  • Remove duplicates
  • Handle missing data gracefully

​
Real Business Examples

​
Sales Pipeline View

Tables: Opportunities + Accounts + Contacts
Join: Opportunity.AccountID = Account.ID
Calculated: Potential Revenue = Amount × Probability
Filter: Stage = "Proposal" AND Region = "West"
Result: Active opportunities with contact details and revenue potential

​
Customer 360 View

Tables: Customers + Support Tickets + Orders
Join: Customer.ID = Tickets.CustomerID = Orders.CustomerID
Calculated: Lifetime Value = SUM(Order.Total)
Filter: Last Contact < 90 days
Result: Complete customer history with support and purchase context

​
Operations Dashboard

Tables: Inventory + Orders + Shipping
Join: Orders.ProductID = Inventory.ProductID
Calculated: Stock Level = Inventory.Quantity - Orders.Pending
Filter: Stock Level < Reorder Point
Result: Real-time inventory status with reorder alerts

​
Best Practices

​
Performance Optimization

Join Strategy:
  • Start with your primary data source
  • Join only necessary tables
  • Use indexed fields for joins when possible
  • Limit joins to 3-4 tables for optimal performance
  • Increase warehouse size for better performance with complex multi-table joins
Each join multiplies data processing requirements. More than 4 joins can significantly slow down your views. Consider creating pre-joined summary tables for complex views you use frequently.
Query Optimization:
  • Apply filters before joins when possible
  • Only display columns you need
  • Use calculated columns sparingly
  • Archive old data regularly
  • Increase warehouse size for better performance with large datasets and complex operations

​
Data Governance

Naming Conventions:
  • Use clear, descriptive table names
  • Include data source and purpose
  • Example: Sales_Pipeline_Q4_2024
Access Control:
  • Configure appropriate permissions
  • Document table purposes and owners
  • Regular access reviews
Data Quality:
  • Validate join results
  • Monitor for data inconsistencies
  • Set up alerts for missing data

​
User Experience

View Design:
  • Keep views focused and simple
  • Group related columns together
  • Use meaningful column headers
  • Provide context through descriptions
Performance Monitoring:
  • Track query execution times
  • Monitor user engagement
  • Optimize frequently used views
Remember: Tables and views are your window into business data. They transform raw information into actionable insights, helping everyone make better decisions faster while maintaining data integrity and performance.