Skip to content

Documentation

Get up and running with Prospector Studio in minutes.

Create your account and start your 14-day free trial. No credit card required.

Use our 500+ pre-built connectors or upload files directly.

Use our intuitive interface to explore, visualize, and analyze.

Create dashboards and reports to share with your team.

Start Free Trial →

🎥

Platform Overview

15-minute introduction to core features and capabilities.

🎥

Building Your First Dashboard

Step-by-step guide to creating interactive dashboards.

🎥

Advanced Analytics

Deep dive into ML models and predictive analytics.

  • Databases: MySQL, PostgreSQL, Oracle, SQL Server, MongoDB, Cassandra
  • Cloud Storage: S3, Azure Blob, Google Cloud Storage
  • SaaS Applications: Salesforce, HubSpot, Google Analytics, Shopify
  • Files: CSV, Excel, JSON, Parquet, Avro
  • Streaming: Kafka, Kinesis, Event Hubs, Pub/Sub
  1. Navigate to Data Sources
  2. Select your source type
  3. Enter connection credentials
  4. Test connection
  5. Configure sync settings
  • Handle missing values
  • Remove duplicates
  • Fix data types
  • Standardize formats
  • Validate data quality
  • Create calculated fields
  • Apply filters and conditions
  • Join and merge datasets
  • Aggregate and summarize
  • Pivot and unpivot data
  • Line, Bar, and Area charts
  • Scatter and Bubble plots
  • Heatmaps and Treemaps
  • Sankey and Network diagrams
  • Geographic maps
  • Custom D3.js visualizations
  • Descriptive statistics
  • Correlation analysis
  • Regression modeling
  • Time series analysis
  • Hypothesis testing
  • A/B testing
  • Classification (Random Forest, XGBoost, Neural Networks)
  • Regression (Linear, Polynomial, Ridge, Lasso)
  • Clustering (K-Means, DBSCAN, Hierarchical)
  • Time Series (ARIMA, Prophet, LSTM)
  • Anomaly Detection (Isolation Forest, Autoencoders)
  1. Select your dataset
  2. Choose target variable
  3. Select algorithm
  4. Configure parameters
  5. Train and validate
  6. Deploy to production
Terminal window
curl -X POST https://api.strike48.com/auth/token \
-H "Content-Type: application/json" \
-d '{"api_key": "your_api_key", "api_secret": "your_api_secret"}'

Get Datasets

Terminal window
GET /api/v1/datasets

Execute Query

Terminal window
POST /api/v1/query
{
"dataset_id": "ds_123",
"query": "SELECT * FROM sales WHERE date > '2024-01-01'"
}

Create Dashboard

Terminal window
POST /api/v1/dashboards
{
"name": "Sales Dashboard",
"widgets": [...]
}
Terminal window
pip install prospector-studio
from prospector_studio import Client
# Initialize client
client = Client(api_key="your_api_key")
# Load dataset
dataset = client.get_dataset("ds_123")
# Run analysis
results = dataset.query("SELECT * FROM sales")
# Create visualization
chart = results.plot(kind="bar", x="month", y="revenue")

Interactive GraphQL playground available at api.strike48.com/graphql

query GetDashboard($id: ID!) {
dashboard(id: $id) {
name
widgets {
id
type
config
data
}
}
}
  • Use appropriate indexes
  • Limit data scanned
  • Leverage caching
  • Partition large datasets
  • Use incremental refresh
  • Limit widgets per dashboard
  • Use aggregated data
  • Implement lazy loading
  • Optimize refresh intervals
  • Cache computed metrics
  • Implement least privilege principle
  • Use role-based permissions
  • Enable MFA for all users
  • Regular access audits
  • Separate dev/prod environments
  • Encrypt sensitive data
  • Mask PII in non-production
  • Implement data retention policies
  • Regular security training
  • Monitor for anomalies
  • Tableau: Native connector with live query
  • Power BI: Direct query and import modes
  • Looker: LookML generation support
  • Qlik: Associative model integration
  • Jupyter: Native notebook integration
  • VS Code: Extension for query development
  • Git: Version control for queries and configs
  • CI/CD: Jenkins, GitHub Actions, GitLab CI
  • Slack: Alerts and notifications
  • Teams: Embedded dashboards
  • Email: Scheduled reports
  • Confluence: Documentation sync
  • Verify network connectivity
  • Check firewall rules
  • Validate credentials
  • Review IP whitelisting
  • Test with minimal permissions
  • Check query complexity
  • Review data volumes
  • Monitor resource usage
  • Optimize indexes
  • Consider caching strategies
  • Validate source data
  • Check transformation logic
  • Review data types
  • Verify join conditions
  • Test with sample data
  • Prospector Fundamentals: 2-day introductory course
  • Advanced Analytics: 3-day deep dive
  • Administration: 2-day admin training
  • Developer Workshop: 3-day API/SDK training
  • Certified User: Basic platform proficiency
  • Certified Analyst: Advanced analytics skills
  • Certified Administrator: Platform administration
  • Certified Developer: API and integration expertise

Need More Help?

Our support team is here to help you succeed with Prospector Studio.