关于CortexDB的数据库创建、CSV导入及数据分析图表制作的技术咨询

Hey there! I’ve messed around with CortexDB for a few months now, so I get how frustrating the vague official docs can be. Let’s walk through each of your questions step by step:

• Open the CortexDB desktop client (or web console if you’re using the cloud version) and log in with your trial license credentials.
• Look for the Databases section in the left sidebar—click the + New Database button (it’s usually a blue icon with a plus sign).
• A modal will pop up: enter a unique database name (avoid spaces or special characters), select your storage type (for trials, the default local storage works fine), and click Create.
• Wait a few seconds for the database to initialize—you’ll see it appear in your Databases list once it’s ready.

First, prep your Excel file: open your sheet, go to File > Save As, choose CSV (*.csv) as the format, and save it (double-check that columns are properly separated without extra spaces). Then:

• In CortexDB, navigate to the database you just created.
• Go to the Collections tab (CortexDB uses collections to organize data, similar to tables in SQL) and click + Import Data.
• Select CSV File as the source, then click Browse to upload your saved CSV.
• In the import wizard:
  • Confirm the column headers are detected correctly (CortexDB usually picks these up automatically, but double-check for any weird formatting glitches).
  • Choose a collection name (this acts like your table name) and adjust data types if needed (e.g., set a "transaction_date" column to Date type instead of String).
  • Click Start Import—the progress bar will show you when it’s done. Verify the data by opening the collection and checking a few entries.

Once your data is loaded, you have two main paths for analysis:

Creating Charts #

• Go to the Analytics tab in your database.
• Click + New Visualization and pick the chart type you need (bar, line, pie, etc.—the trial version has solid basic options).
• Select your target collection, then map your data fields: for example, if you want a bar chart of sales per region, set the X-axis to "Region" and Y-axis to "Sales_Amount".
• Add filters or sorting if needed (e.g., only show data from the last 6 months), then click Save to add the chart to your dashboard.

Running Deeper Analysis #

• Use the Query Editor (under the Analytics tab) to write CortexDB’s query syntax (it’s similar to MongoDB if you’re familiar with that). For example, to get the average sales per region:

  db.sales_collection.aggregate([
    { $group: { _id: "$region", avg_sales: { $avg: "$amount" } } }
  ])
  

• For quick stats, use the built-in Summary Stats tool: select your collection and a numeric column, and it’ll instantly show counts, averages, min/max values.

内容的提问来源于stack exchange，提问作者Bort54