Video walkthrough of the content covered in this guide

Video walkthrough of the content covered in this guide

🏆 Objective

This guide outlines the steps to upload a CSV file and analyze data using the Alkemi DataLab interface. You can download the CSV we use in this guide from data.gov here.

🔑 Key Steps

1. Accessing Alkemi DataLab 0:00

<aside>

generated-image-at-00:00:00

• Log In to Alkemi DataLab.
• Familiarize yourself with the layout:
  • Left sidebar: Chat history and API endpoints.
  • Main chat input area for queries and commands.
  • Right sidebar: Credit balance, integrations, and current data slices. </aside>

2. Preparing to Upload a CSV File 1:11

<aside>

generated-image-at-00:01:11

• Ensure you have a CSV file ready for upload (e.g., consumer price index historical data). </aside>

3. Uploading the CSV File 1:22

<aside>

generated-image-at-00:01:22

generated-image-at-00:02:11

• Use the upload functionality in Alkemi DataLab to upload your CSV file.
• Review the columns in your CSV file, noting important attributes. </aside>

4. Creating a New Table from the CSV Data 2:11

<aside>

generated-image-at-00:02:50

• Construct a query to filter and group data:
  • Filter by the attribute column (e.g., midpoint of prediction interval).
  • Group by consumer price index item.
  • Calculate a new column for forecast percent change. </aside>

5. Querying Results 2:50

<aside>

generated-image-at-00:03:06

• Send the query to the Alkemi agent.
• Wait for the results to be assembled and saved as a data asset. </aside>

6. Accessing and Reviewing the Results 3:06

<aside>

generated-image-at-00:04:00

• Use the mentioning functionality to reference the new table in chat threads.
• Click to expand and view the data, or download it as a CSV. </aside>

7. Cleaning and Sorting the Data 4:00

<aside>

generated-image-at-00:04:37

• Remove any irrelevant categories (e.g., 'all food').
• Sort the results by total increase in descending order. </aside>

8. Visualizing the Data 4:37

<aside>

generated-image-at-00:05:16

• Request a visualization of the data (e.g., as a bar chart or pie chart).
• Interact with the chart to view details and download it for presentations. </aside>