Subquerier is a platform designed to help users efficiently query, analyze, and manage data from multiple sources. This guide will walk you through the key features, functions, and best practices for using Subquerier effectively.
1. Logging In
- Open your web browser and go to the Subquerier website.
- Enter your registered email address and password.
- Click Login to access the dashboard.
- If you forget your password, use the Forgot Password link to reset it.
2. Dashboard Overview
The dashboard provides a summary of your data queries and activity. Key sections include:
- Recent Queries: Displays your latest executed queries.
- Saved Queries: Shows queries you have saved for future use.
- Analytics Summary: Provides an overview of query performance and results.
3. Creating a Query
- Click New Query on the dashboard.
- Select the data source you want to query.
- Enter your query using the provided query builder or SQL editor.
- Click Run to execute the query.
- View results in the output panel.
- Save the query for future use if needed.
4. Editing and Managing Queries
- To edit a query, select it from your saved queries list and click Edit.
- To delete a query, select the query and click Delete.
- Use tags or folders to organize queries for easier access.
5. Exporting Query Results
- After running a query, click Export.
- Choose the file format: CSV, Excel, or JSON.
- Click Download to save the results to your device.
6. Using Filters
Filters help refine your data queries:
- Add conditions such as date ranges, categories, or numerical values.
- Combine multiple filters using AND/OR operators.
- Preview filtered results before saving or exporting.
7. Collaboration
Subquerier allows team collaboration:
- Share saved queries with team members via email or platform links.
- Set permissions to allow viewing or editing.
- Comment on queries for better collaboration and discussion.
8. Tips & Best Practices
- Always save queries for future reference.
- Use descriptive names for queries and tags.
- Regularly review and clean up unused queries to keep your workspace organized.
- Test complex queries with smaller data sets first.
9. Support
- Access the Help Center from the dashboard for tutorials and FAQs.
- Contact Subquerier support through the Support link for technical assistance.