General Introduction
Ajelix is a data analytics and business intelligence focused platform that offers a variety of AI tools to simplify and enhance the use of Excel and Google Sheets. The platform features over 17 AI tools, including an Excel formula generator and data visualization tools to help users quickly generate professional reports and dashboards.Ajelix's goal is to make it easy for users to perform complex data tasks without programming knowledge by simplifying the data processing and analysis process.
Function List
- Excel Formula Generator: Generate complex Excel formulas through natural language input.
- Data visualization tools: Upload Excel files to quickly generate visual dashboards.
- Business Intelligence Platform: Easily create and share data reports without programming knowledge.
- Data preparation tools: Clean and transform data in preparation for advanced analysis.
- Multi-device support: Compatible with Mac and Windows users, edit and share dashboards online.
Using Help
Function Operation Guide
Excel Formula Generator
- input requirement: In the platform's Formula Generator screen, enter the description of the formula you need, e.g. "Calculate Gross Sales".
- Generate a formula: Click the Generate button and AI will automatically generate the corresponding Excel formula.
- Duplication of use: Copy the generated formulas to use in your Excel sheet.
Data visualization tools
- Uploading files: In the Data Visualizer interface, click the "Upload File" button and select your Excel file.
- Generate Dashboards: Once the upload is complete, the platform will automatically generate a data dashboard.
- Customizing the Dashboard: Adjust the chart type and data range as needed and click Save.
Business Intelligence Platform
- Creating Reports: In the BI platform interface, click the "Create Report" button, select the data source and upload the file.
- Editorial reports: Edit and embellish the content of the report using the tools provided by the Platform.
- Share the report: Once you've finished editing, click the "Share" button to send the report link to a team member or client.
Data preparation tools
- Data cleansing: On the Data Preparation Tool screen, upload the data files to be cleaned.
- data conversion: Adjust the format and structure of the data using the conversion functions provided by the platform.
- Advanced Analytics: Once cleaning and conversion are complete, the data is automatically ready for advanced analysis.
The Ajelix platform is designed to simplify data processing and analysis by allowing users to perform complex data tasks without programming knowledge. By following these steps, users can quickly get started and take full advantage of the platform's features to increase productivity.