An analysis lets you build interactive dashboards on top of your pipelines.
Choose how you want to create your analysis:
- Use the Agent for a faster, automated workflow
- Create manually for full control over the dashboard
Use the Agent
Create manually
Overview
Use the Agent to automatically generate a pipeline and analysis from a prompt.Add source data
Add a dataset to your pipeline:
- Open the Source/Target gem category.
- Click Table.
- Open the gem and select + New Table.
- Choose Seed as the type.
- Name the dataset
home_tech_transactions.
- Paste your data and click Load Data.
- Click Save.
Generate an analysis
In the Chat interface, enter a prompt:Visualize sales performance per product category in @home_tech_transactions
- Transform the data
- Create a visualization
- Generate a pipeline
- Create a linked analysis dashboard
Continue building
You can continue prompting the Agent to:
- Add new visualizations
- Modify transformations
- Expand the dashboard
Add interactive components
To add interactive components to the analysis, you’ll need to embed a pipeline parameter in the pipeline. Pipeline parameters enable dynamic behavior in pipelines by allowing values to be set at runtime. In this case, pipeline parameter values are set by the end user when they run the analysis.Create a pipeline parameter
In this section, you’ll define a pipeline parameter called region. The parameter will capture the region that the user selects, allowing the pipeline to filter transactions based on the region the user wants to see.
- Open the pipeline tied to the analysis.
- Click default in the project header to open the parameter settings.
- Open the Pipeline Parameters tab.
- In the default parameter set, click + Add Parameter.
- Name the parameter
region.
- Set the parameter type to
String.
- Click Select expression > Value.
- Enter
North as the default value to be used during interactive pipeline runs.
- Click Save.
Add a filter
Next, add a Filter gem to the pipeline. To make the filter condition dynamic, you’ll use the pipeline parameter in the gem.
-
Add a Filter gem directly after the Source gem and before the next gem (generated by the Agent).
-
Open the Filter gem configuration.
-
For the filter condition:
- Click Select expression > Column and select the
Region column.
- Click Select operator and select equals.
- Click Select expression > Configuration Variable and select the
region parameter.
This expression is equivalent to Region = {{ var('region') }} in the Code view.
-
Click Save.
Add a Text Input component
Add a Text Input component to allow the end user to enter the region they want to see.
- Open the analysis dashboard that the Agent created.
- Click Edit.
- Open the Interactive dropdown and select Text Input.
- In the Inspect tab, for the Configuration field, select the
region parameter.
- For the Label, enter
Region.
- Drag the Text Input component above the bar chart visualization.
For full configuration options, see Analysis components.Overview
Create an analysis manually to build a dashboard from an existing pipeline.Add source data
Add a dataset to your pipeline:
- Open the Source/Target gem category.
- Click Table.
- Open the gem and select + New Table.
- Choose Seed as the type.
- Name the dataset
home_tech_transactions.
- Paste your data and click Load Data.
- Click Save.
Create the analysis
- Open the Project Explorer.
- Hover over a pipeline.
- Click the Create analysis icon.
Alternatively:
- Click the + icon in the canvas header
- Select Create analysis
- Enter a name for the analysis in Analysis name. Use alphanumeric characters and underscores.
- (Optional) Enter a description in Description.
- Select a pipeline in Pipeline name.
- Choose a parameter set in Parameter set.
- (Optional) Update the location in Directory path, or leave the default.
- Click Create analysis.
Build your analysis
The analysis opens on the canvas.You can add three types of components:
- Interactive — Capture user input
- Data Integration — Display pipeline data
- Content — Add text and images
For full configuration options, see Analysis components.Add a chart
To add a visualization:
- Select a chart component.
- Choose a data table.
- Enter a label.
- Select a chart type.
- Configure:
- Category column
- Y-axis column
You can further customize chart appearance, including labels and formatting.Add interactive components
To add interactive components to the analysis, you’ll need to embed a pipeline parameter in the pipeline. Pipeline parameters enable dynamic behavior in pipelines by allowing values to be set at runtime. In this case, pipeline parameter values are set by the end user when they run the analysis.Create a pipeline parameter
In this section, you’ll define a pipeline parameter called region. The parameter will capture the region that the user selects, allowing the pipeline to filter transactions based on the region the user wants to see.
- Open the pipeline tied to the analysis.
- Click default in the project header to open the parameter settings.
- Open the Pipeline Parameters tab.
- In the default parameter set, click + Add Parameter.
- Name the parameter
region.
- Set the parameter type to
String.
- Click Select expression > Value.
- Enter
North as the default value to be used during interactive pipeline runs.
- Click Save.
Add a filter
Next, add a Filter gem to the pipeline. To make the filter condition dynamic, you’ll use the pipeline parameter in the gem.
-
Add a Filter gem directly after the Source gem and before the next gem (generated by the Agent).
-
Open the Filter gem configuration.
-
For the filter condition:
- Click Select expression > Column and select the
Region column.
- Click Select operator and select equals.
- Click Select expression > Configuration Variable and select the
region parameter.
This expression is equivalent to Region = {{ var('region') }} in the Code view.
-
Click Save.
Add a Text Input component
Add a Text Input component to allow the end user to enter the region they want to see.
- Open the analysis dashboard that the Agent created.
- Click Edit.
- Open the Interactive dropdown and select Text Input.
- In the Inspect tab, for the Configuration field, select the
region parameter.
- For the Label, enter
Region.
- Drag the Text Input component above the bar chart visualization.
Run the analysis
Let’s return to the analysis preview so we can test the new component.
- From the analysis, click Back to Preview.
- In the Region field, enter
West.
- Click the Run button.
- Review the bar chart to see the total sales by product category for the West region.
When the analysis runs, Prophecy always executes the entire underlying pipeline. This means any additional transformations, tables, or other components included in the pipeline will also run, even if they’re not exposed in the dashboard. Be mindful of how you design the pipeline to ensure your dashboard triggers only the intended logic.
Share the dashboard
Access to analyses is controlled by Prophecy’s team-based permission model. If your team owns a project, you have full edit access. This means that you can build, edit, and delete analyses in the project.
If a project is shared with your team, you cannot edit any pipeline’s or analysis’s structure. However, you can run analyses from the shared project. This ensures that your data engineering team can share pipelines they developed without exposing them to changes.
What’s next
To address your specific business requirements, leverage more complex components to construct robust analysis dashboards.
To learn about the end user experience, see consume analyses. 
