---
title: Videos
description: Videos
tableOfContents: false
---

import { MediaPlayerComponent } from "../../../components/video-player";
import RunScript from "../../../components/RunScript.astro";

# Videos

## Infoveave Modules

<MediaPlayerComponent video="Customize-Visualisations-On-Your-Infoboard.mp4"
chapters=
{[ { "start": 0, "end": 5, "text": "Click create Infoboard", "description": "From the Infoveave home screen, click the Insights dropdown menu, select Infoboards, then click Create Infoboard to begin." }, { "start": 5, "end": 10, "text": "Select Designer Layout", "description": "In the Select a template dialog, click Use Designer Layout to start with a blank canvas." }, { "start": 20, "end": 30, "text": "Adding a Data Source", "description": "In the Add Datasource dialog, type Revenue Growth, select it from the suggestions, and click Save." }, { "start": 30, "end": 34, "text": "Naming the Infoboard", "description": "In the Infoboard name field on the right, enter Infoboard Visualization as the title." }, { "start": 34, "end": 57, "text": "Adding and Configuring a Column Chart", "description": "Click Column in the Charts panel to add it to the canvas. Set Revenue Growth as the source, Revenue as the value, and Product Type as the axis." }, { "start": 57, "end": 89, "text": "Customizing Column Chart Axis", "description": "Select the column chart, open the Customization tab, expand Categorical axis, and enter Product Type for both axis name and label fields." }, { "start": 89, "end": 110, "text": "Adding and Configuring a Pie Chart", "description": "Click Pie in the Charts panel to add it to the canvas. Set Revenue Growth as the source, Customers as the measure, and Account Type as the dimension." }, { "start": 110, "end": 140, "text": "Customizing Pie Chart Series", "description": "Select the pie chart, open the Customization tab, expand Series, enable Show labels, set Apply to as Insurance, position as Inside, and pick a custom color." }, { "start": 140, "end": 158, "text": "Saving the Infoboard", "description": "Click the Save button at the top right. A success message confirms the infoboard is saved, displaying both visualizations." } ]
}
poster="/images/introduction-poster.png"
posterText="Infoveave Modules"
client:load/>

## Introducing Insights

<MediaPlayerComponent video="insights-menu.mp4"
chapters={[
  {
    "start": 0,
    "end": 2,
    "text": "Insights Menu",
    "description": "Access the Insights menu by clicking the Insights option at the top of the screen. This menu provides access to pre-built or shared Infoboards, Reports, and Lists."
  },
  {
    "start": 2,
    "end": 3,
    "text": "My Organization",
    "description": "My Organization allows users to access the organization's resources. As seen in the video, Infoboards, Reports, and Lists are available for use."
  },
  {
    "start": 3,
    "end": 8,
    "text": "My Workspace",
    "description": "My Workspace is a personal area for each user, allowing them to manage and access personal items. The video shows folders such as Digital Marketing, Reconciliation, Healthcare, Visualization Options, and Created by Me available."
  },
  {
    "start": 8,
    "end": 9,
    "text": "Create Infoboard",
    "description": "Create Infoboard offers users a way to create new Infoboards. As shown in the video, Create Infoboard allows users to add a grid or designer-based infoboard, and Create Infoboard with AI makes it possible to use GenAI to create an infoboard."
  },
  {
    "start": 9,
    "end": 15,
    "text": "Chat with Fovea",
    "description": "Chat with Fovea offers users a way to create new Infoboards using AI."
  }
]
}
poster="/images/introduction-poster.png"
posterText="Introducing Insights"
client:load/>

## Catalogues

<MediaPlayerComponent video="Catalogues.mp4"
chapters={[
{ start: 0, end: 8, text: "Click on Catalogue", description: "From the Infoveave menu click the Catalogues icon." },
{ start: 8, end: 14, text: "Click Domains", description: " Click on Domains in the left navigation panel. Domains act as high-level business categories (like 'Finance' or 'Sales') to group related data assets, helping you organize and manage data according to your business structure." },
{ start: 14, end: 19, text: "Click Projects", description: "Next, select Projects from the left panel. Projects provide a way to group various data assets that are used together for a specific purpose or initiative, like a 'Sales Analysis' project. You can view project documentation and see all linked assets in one place." },
{ start: 19, end: 49, text: "Click Assets", description: "Use the left-side navigation panel to explore the different kinds of assets you have. You can click on categories like Connections, Datasources, Infoboards, Lists, Workflows, Alerts, and others to see a filtered list of only those items in the main view." },
{ start: 49, end: 51, text: "Click Tiers", description: "Go to the Tiers section in the left navigation menu. This is where you can define different levels of data sensitivity, such as 'Critical,' 'Sensitive,' or 'Public,' to classify and apply governance policies to your data assets." },
{ start: 51, end: 53, text: "Click Tags", description: "Navigate to the Tags section. This area allows you to create and manage custom tags that can be applied to your data. Tags help with organization, search, and can be linked to specific behaviors, like automatically obfuscating data tagged as sensitive." },
{ start: 53, end: 57, text: "Click Glossary", description: "Finally, select Glossary from the left panel. The business glossary is a central dictionary for defining key business terms. This ensures everyone in your organization uses a consistent vocabulary, improving clarity and data understanding." },
]}
poster="/images/introduction-poster.png"
posterText="Catalogues"
client:load/>

## Creating A Datasource Using Delimited File

<MediaPlayerComponent video="Create-A-Datasource-Using-Delimited-File.mp4"
chapters={[
  {
    "start": 0,
    "end": 8,
    "text": "Click Datasources under Studio",
    "description": "From the Infoveave menu, click 'Studio', then click 'Datasources' from the dropdown menu. Wait for the datasources list to load."
  },
  {
    "start": 8,
    "end": 13,
    "text": "Create New Datasource",
    "description": "Click the 'New Datasource' button to begin creating a new data source."
  },
  {
    "start": 13,
    "end": 18,
    "text": "Select Delimited File Type",
    "description": "Under the 'Files' section, click the 'Delimited' card to select this file type for your new datasource."
  },
  {
    "start": 18,
    "end": 20,
    "text": "Upload CSV File",
    "description": "Click the 'Please select file' area and choose 'Acme banking.csv' from your local files to upload it."
  },
  {
    "start": 20,
    "end": 32,
    "text": "Review Basic Configuration",
    "description": "Verify that the uploaded file (Acme banking.csv) and the connection details are correct. The default delimiter (Comma) and other settings should typically be auto-detected correctly. Click Next to proceed to the preview stage."
  },
  {
    "start": 32,
    "end": 38,
    "text": "Name the Datasource and Table",
    "description": "On the Preview screen, enter Acmbanking loan data CSV into the Datasource name field. Click the Edit icon next to the table name (ocme_banking by default) and change it to loan_data_CSV."
  },
  {
    "start": 38,
    "end": 41,
    "text": "Add Upload Date Column",
    "description": "Check the Add upload date box to include a column that records when the data was uploaded. The Column name will automatically populate as upload_date."
  },
  {
    "start": 41,
    "end": 51,
    "text": "Review Table Schema",
    "description": "Click the Edit icon next to the table name (loan_data_CSV) to open the Table schema dialog. Scroll through the columns to confirm that data types and other properties are correctly inferred. Click Save when done."
  },
  {
    "start": 51,
    "end": 63,
    "text": "Add 'Loan Amount' as a Measure",
    "description": "Right-click on the 'loan_amount' column, click 'Add measure'. In the 'Add measure' dialog, set 'Aggregation' to 'Sum', then click 'Add measure' to confirm."
  },
  {
    "start": 63,
    "end": 72,
    "text": "Add 'Loan ID' as a Dimension",
    "description": "Right-click on the 'loan_id' column, click 'Add dimension'. In the dialog, click 'Add dimension' to confirm adding 'loan_id' as a dimension."
  },
  {
    "start": 72,
    "end": 76,
    "text": "Add 'Loan Application Date' as a Dimension",
    "description": "Locate the loan_application_date column and click on ellipsis and add dimension. In the Add dimension dialog, keep the default settings and click Add dimension to define it. A success notification will confirm the addition."
  },
  {
    "start": 76,
    "end": 85,
    "text": "Save the Datasource",
    "description": "Finally, click the Save button in the top-right corner of the screen to save the new Acmbanking loan data CSV datasource with all its configured measures and dimensions. A notification will appear, confirming that the datasource has been saved successfully."
  }
]
}
poster="/images/introduction-poster.png"
posterText="Creating A Datasource Using Delimited File"
client:load/>

## Creating A Datasource Using IOT

<MediaPlayerComponent video="Create-A-Datasource-Using-IOT.mp4"
chapters={[
  {
    "start": 0,
    "end": 8,
    "text": "Click Datasources under Studio",
    "description": "From the Infoveave menu, click 'Studio', then click 'Datasources' from the dropdown menu. Wait for the datasources list to load."
  },
  {
    "start": 8,
    "end": 10,
    "text": "Create New Datasource",
    "description": "Click the New Datasource button in the top right corner. This will display various datasource types."
  },
  {
    "start": 10,
    "end": 14,
    "text": "Select IoT Datasource Type",
    "description": "Scroll down or go to the Others section and click IoT to begin configuring a new IoT datasource."
  },
  {
    "start": 14,
    "end": 18,
    "text": "Upload JSON File and Connect",
    "description": "Click Please select file and choose your JSON file. Verify the connection settings, then click Next."
  },
  {
    "start": 18,
    "end": 27,
    "text": "Name the Datasource and Configure Table",
    "description": "In the Datasource name field, enter IOT Temperature data. Click the Edit icon next to the table name, rename it to IOT_Temp_Data, check Add upload date, then click Update."
  },
  {
    "start": 27,
    "end": 37,
    "text": "Add Calculated Column",
    "description": "Click Add calculated column, name it event_date, and paste the JavaScript formula to extract the date from time_stamp. Click Validate, then Add column."
  },
  {
    "start": 37,
    "end": 45,
    "text": "Review and Save Table Schema",
    "description": "Click the Table schema icon, review all columns including calculated ones, then click Save."
  },
  {
    "start": 45,
    "end": 55,
    "text": "Define Measure",
    "description": "Right-click on time_stamp, select Add measure, set Aggregation to Sum, and click Add measure."
  },
  {
    "start": 55,
    "end": 64,
    "text": "Define Dimension (Device ID)",
    "description": "Right-click on dev_id, select Add dimension, and click Add dimension to categorize by device."
  },
  {
    "start": 64,
    "end": 68,
    "text": "Define Dimension (Location)",
    "description": "Right-click on location, select Add dimension, and click Add dimension to categorize by location."
  },
  {
    "start": 68,
    "end": 76,
    "text": "Final Save of Datasource",
    "description": "Click the Save button in the top right corner. A confirmation message will confirm the IoT datasource was saved successfully."
  }
]
}
poster="/images/introduction-poster.png"
posterText="Creating A Datasource Using IOT"
client:load/>

## Creating Datasource Using Microsoft Excel

<MediaPlayerComponent video="create-excel-datasource.mp4"
chapters={[
{ start: 0, end: 10, text: "Click Datasources under Studio", description: "From the Infoveave menu, click 'Studio', then click 'Datasources' from the dropdown menu. Wait for the datasources list to load" },
{ start: 10, end: 18, text: "Create New Data Source", description: "Click the New Data Source button." },
{ start: 18, end: 24, text: "Select Excel", description: "Choose the Excel option from the Files section to proceed." },
{ start: 24, end: 31, text: "Select and Upload the File", description: "Select the Excel file from your device and click Next to proceed." },
{ start: 31, end: 42, text: "Name the Data Source and Table", description: "Enter a name for the data source and then click the edit icon next to the table name to assign a name to the data table." },
{ start: 42, end: 51, text: "Add a Calculated Column", description: "If you'd like to add a new column, click Add calculated column." },
{ start: 51, end: 57, text: "Specify the Table Schema", description: "In the table schema, modify the column names as needed and click Save." },
{ start: 57, end: 79, text: "Add Dimensions and Measures", description: "Add measures and dimensions to your data source to create the necessary relationships." },
{ start: 79, end: 86, text: "Save the Data Source", description: "Click Save to persist the data source" },
 ]
}
poster="/images/introduction-poster.png"
posterText="Creating Datasource Using Microsoft Excel"
client:load/>

 ## Creating A Datasource Using Oracle

<MediaPlayerComponent video="Create-Datasource-Using-Microsoft.mp4"
chapters={
    [
  {
    "start": 0,
    "end": 6,
    "text": "Click Datasources under Studio",
    "description": "From the Infoveave menu, click 'Studio', then click 'Datasources' from the dropdown menu. Wait for the datasources list to load."
  },
  {
    "start": 6,
    "end": 9,
    "text": "Create New Datasource",
    "description": "On the Datasources page, click the New Datasource button, typically located in the top-right corner of the screen, to begin the process of adding a new data source."
  },
  {
    "start": 9,
    "end": 15,
    "text": "Select Oracle Database Type",
    "description": "In the New Datasource window, scroll down to the Databases section. Click on Oracle to select it as your database type."
  },
  {
    "start": 15,
    "end": 20,
    "text": "Select Oracle Connection",
    "description": "In the Edit Connection dialog, choose your existing Oracle connection (e.g., Oracle Akash Kottur) from the dropdown. Click Save to apply the connection."
  },
  {
    "start": 20,
    "end": 24,
    "text": "Select Oracle Table",
    "description": "In the search bar on the left, type ACME_SALES and select the table from the search results. This will load the schema of the ACME_SALES table."
  },
  {
    "start": 24,
    "end": 28,
    "text": "Name the Datasource",
    "description": "In the right-hand panel, locate the Datasource name field and enter Oracle Sales data to give your new datasource a clear, descriptive name."
  },
  {
    "start": 28,
    "end": 36,
    "text": "Add 'Order ID' as a Measure",
    "description": "Hover over the ORDER_ID column in the loaded table schema and click on ellipsis and add measure. In the Add measure dialog, select Sum for Aggregation. Click Add measure to define it. A success notification will confirm the addition."
  },
  {
    "start": 36,
    "end": 43,
    "text": "Add 'Order Priority' as a Dimension",
    "description": "Hover over the ORDER_PRIORITY column and click on ellipsis and add dimension. In the Add dimension dialog, accept the default settings and click Add dimension. A success notification will confirm the addition."
  },
  {
    "start": 43,
    "end": 50,
    "text": "Add 'Order Date' as a Dimension",
    "description": "Hover over the ORDER_DATE column and click on ellipsis and add dimension. In the Add dimension dialog, accept the default settings and click Add dimension. A success notification will confirm the addition."
  },
  {
    "start": 50,
    "end": 65,
    "text": "Save the Datasource",
    "description": "Finally, click the Save button in the top-right corner of the screen to save the newly configured Oracle Sales data datasource with all its defined measures and dimensions. A notification will appear, confirming that the datasource has been saved successfully."
  }
]

}
poster="/images/introduction-poster.png"
posterText="Creating A Datasource Using Oracle"
client:load/>

## Creating Infoboard Using A Query

<MediaPlayerComponent video="Create-Infoboard-Using-A-Query.mp4"
chapters={[
  {
    "start": 0,
    "end": 5,
    "text": "Click Insights",
    "description": "From the Infoveave menu, click 'Insights'."
  },
  {
    "start": 5,
    "end": 6,
    "text": "Create New Infoboard",
    "description": "Click the 'Create Infoboard' card to begin creating a new infoboard."
  },
    {
    "start": 6,
    "end": 10,
    "text": "Select Designer Layout",
    "description": "In the 'Select a template' dialog, click 'Use Designer Layout' to start with a blank canvas."
  },
  {
    "start": 10,
    "end": 27,
    "text": "Choose SQL Query as Infoboard Source",
    "description": "The Infoboard Source dialog will appear. Choose Use query as the source type."
  },
  {
    "start": 27,
    "end": 44,
    "text": "Configure SQL Query Source",
    "description": "In the Infoboard Source dialog, select Acme Banking Dataset as the Datasource. Name the source Loan Data. In the Sql Query box, enter SELECT * from acmebanking. Click Validate to preview the data, then click Save."
  },
  {
    "start": 44,
    "end": 48,
    "text": "Name the Infoboard",
    "description": "In the right-hand panel, set the Infoboard name to Loan Analysis Dashboard."
  },
  {
    "start": 48,
    "end": 62,
    "text": "Add and Configure Bar Chart",
    "description": "From the Charts section on the left, drag and drop the Bar chart onto the canvas. Set its Source to Loan Data, Value to loan_amount, and Axis to branch."
  },
  {
    "start": 62,
    "end": 83,
    "text": "Customize Bar Chart Appearance",
    "description": "With the bar chart selected, go to its General settings. Enable Title and set the Label to Loan Amount By Branch. Make the text bold. Under Heat map, set Label font size to 18, make it bold, and set Position to Right."
  },
  {
    "start": 83,
    "end": 93,
    "text": "Save Infoboard",
    "description": "Click the Save button in the top-right corner to save your Loan Analysis Dashboard. A success notification will appear."
  }
]
}
poster="/images/introduction-poster.png"
posterText="Creating Infoboard Using A Query"
client:load/>

## Creating Infoboard Using API

<MediaPlayerComponent video="Create-Infoboard-Using-API.mp4"
chapters={[
 {
    "start": 0,
    "end": 4,
    "text": "Click Insights",
    "description": "From the Infoveave menu, click 'Insights'."
  },
  {
    "start": 4,
    "end": 5,
    "text": "Create New Infoboard",
    "description": "Click the 'Create Infoboard' card to begin creating a new infoboard."
  },
  {
    "start": 5,
    "end": 12,
    "text": "Select Designer Layout",
    "description": "In the 'Select a template' dialog, click 'Use Designer Layout' to start with a blank canvas."
  },
  {
    "start": 12,
    "end": 29,
    "text": "Choose API as Infoboard Source",
    "description": "From the 'Infoboard Source' options, click 'Use API' to define an API endpoint as your data source."
  },
  {
    "start": 29,
    "end": 36,
    "text": "Configure API Source Details",
    "description": "Enter 'product' in the 'Name' field and 'https://dummyjson.com/products' in the 'Url' field. Ensure the 'Content Type' is 'application/json' and 'Type' is 'GET'."
  },
  {
    "start": 36,
    "end": 38,
    "text": "Validate API Source",
    "description": "Click the 'Validate' button to test the API connection and ensure the data source is correctly configured."
  },
  {
    "start": 38,
    "end": 43,
    "text": "Save API Source",
    "description": "After successful validation, click the Save button to add the API as a source for your infoboard."
  },
  {
    "start": 43,
    "end": 48,
    "text": "Name the Infoboard",
    "description": "In the Infoboard name field on the right panel, type API Sales Analysis Dashboard to give your new infoboard a descriptive name."
  },
  {
    "start": 48,
    "end": 52,
    "text": "Add a Bar Chart",
    "description": "From the Charts section on the left-hand side, click and drag the Bar chart icon onto the main canvas. This will add a new bar chart component to your Infoboard."
  },
  {
    "start": 52,
    "end": 62,
    "text": "Configure Bar Chart",
    "description": "In the right-hand configuration panel for the bar chart, select product as the Source. For Value, choose products_discountPercentage. For the Axis, select products_category to display discount percentages across different product categories."
  },
  {
    "start": 62,
    "end": 77,
    "text": "Customize Chart Title",
    "description": "Click the 'Customization' icon on the right panel. Expand the 'Title' section, enable the title, and type 'Discount by Products category' into the 'Label' field."
  },
  {
    "start": 77,
    "end": 87,
    "text": "Adjust Series Label Font Size",
    "description": "Scroll down and expand the 'Series' section. In the 'Labels' subsection, change the 'Font size' to '18'."
  },
  {
    "start": 87,
    "end": 94,
    "text": "Save the Infoboard",
    "description": "Click the Save button in the top-right corner of the screen to save your newly created and customized API Sales Analysis Dashboard. A success notification will appear at the bottom right."
  }]}
poster="/images/introduction-poster.png"
posterText="Creating Infoboard Using API"
client:load/>

## Creating Workflow in Infoveave

<MediaPlayerComponent video="Creating-Workflows.mp4"
chapters={
[
  {
    "start": 0,
    "end": 7,
    "text": "Click on Workflows under Automation",
    "description": "From the Infoveave home screen, navigate to the Automation menu in the top bar. From the dropdown, select Workflows to manage and create automated processes."
  },
  {
    "start": 7,
    "end": 11,
    "text": "Create New Workflow",
    "description": "On the Workflows page, click the New Workflow button in the top right corner. In the new workflow configuration panel, name the workflow Acme Banking ETL Flow and add an appropriate description."
  },
  {
    "start": 11,
    "end": 20,
    "text": "Add FTP Download Activity",
    "description": "In the right-hand search bar, type FTP and drag the FTP activity onto the workflow canvas. In its configuration, select phoenix connection as the Connection and set the Working directory to /SFTPtest/Acme. Set Get files for to All."
  },
  {
    "start": 20,
    "end": 39,
    "text": "Add Read Excel Files Activity",
    "description": "Search for Read Excel files in the right-hand panel and drag it onto the canvas, connecting it after the FTP activity. Ensure Read files from previous activity is enabled."
  },
  {
    "start": 39,
    "end": 47,
    "text": "Add JavaScript Transformation Activity",
    "description": "Search for Transform using javascript and drag it onto the canvas, connecting it after the Read Excel activity. Enable Include original. Add a Column map for Loan_ID and apply the transformation (Loan_ID).substring(0, 8)."
  },
  {
    "start": 47,
    "end": 54,
    "text": "Add Round Numbers Transformation",
    "description": "Search for Round numbers and drag it onto the canvas. Connect it after the JavaScript transformation. Configure it to round the revenue_amount column with a RoundingMethod of Round and Precision of 2."
  },
  {
    "start": 54,
    "end": 60,
    "text": "Add Remove Duplicate Rows Activity",
    "description": "Search for Remove duplicate rows and drag it onto the canvas, connecting it to the previous activity. Select customer_id as the column to identify duplicate rows."
  },
  {
    "start": 60,
    "end": 66,
    "text": "Add Drop Columns Activity",
    "description": "Search for Drop columns and drag it onto the canvas. Connect it. Select Loan ID from the Columns to drop list to remove this column."
  },
  {
    "start": 66,
    "end": 76,
    "text": "Add Rename Columns Activity",
    "description": "Search for Rename columns and drag it onto the canvas. Connect it. Add a column map to rename Loan Term (Months) to loan_term__months__."
  },
  {
    "start": 76,
    "end": 84,
    "text": "Add Upload to Datasource Activity",
    "description": "Search for Upload to Datasource and drag it as the final activity in the workflow. Connect it. Select Acme Banking Dataset as the Datasource and Acmebanking as the Table."
  },
  {
    "start": 84,
    "end": 85,
    "text": "Save Workflow",
    "description": "Click the Save button in the top right corner of the screen to save the complete Acme Banking ETL Flow workflow."
  },
  {
    "start": 85,
    "end": 86,
    "text": "Run Workflow",
    "description": "Click the Play icon in the top toolbar to initiate the workflow execution. Confirm by clicking Yes in the prompt."
  },
  {
    "start": 86,
    "end": 129,
    "text": "Monitor Workflow Execution",
    "description": "Observe the 'Workflow logs' panel on the left."
  },

]


}
poster="/images/introduction-poster.png"
posterText="Creating Workflow in Infoveave"
client:load/>

## Workflow Execution Status

<MediaPlayerComponent
  video="Workflow-Execution-Status-video.mp4"
  chapters={[
       {
      start: 0,
      end: 4,
      text: "Click Workflow Execution icon",
      description:
        "Click on the Workflow Execution Status icon in the Infoveave, located at the top right navigation menu.",
    },
    {
      start: 4,
      end: 11,
      text: "Toggle View Modes",
      description:
        "On the Workflow Execution page, click the Gantt chart icon to switch to the Gantt chart view. To return to the default table view, click the Table icon.",
    },
    {
      start: 11,
      end: 32,
      text: "Filter by Workflow Status",
      description:
        "To filter workflows by their execution status, click the All dropdown. Select Success to view only successful workflows, Failure to see failed ones, or Running to display workflows currently in progress.",
    },
    {
      start: 32,
      end: 36,
      text: "Filter by Date",
      description:
        "Click the calendar icon to open the date picker. Select a specific date to filter the displayed workflows to that particular day.",
    },
    {
      start: 36,
      end: 42,
      text: "Search for a Specific Workflow",
      description:
        "Use the search bar to find a specific workflow. Type the workflow's name into the search field to quickly locate it in the list.",
    },
  ]}
  poster="/images/introduction-poster.png"
  posterText="Workflow Execution Status"
  client:load
/>

## What-If Analysis

<MediaPlayerComponent video="what-if-analysis.mp4"
chapters={[

{ "start": 0, "end": 1, "text": "Click What-If Analysis under Analysis", "description": "From the Infoveave menu, click Analysis in the top navigation bar. Select What-If Analysis from the dropdown menu to proceed" },
{ "start": 1, "end": 8, "text": "Create a New Analysis", "description": "Click the New Analysis button. In the dialog, provide a name for your analysis (e.g., Loan Analysis) and select the formula you wish to use (e.g., Loan Analysis Formula) from the dropdown. Click Save" },
{ "start": 8, "end": 14, "text": "Execute Initial Analysis", "description": "Click the play icon to run the analysis. Choose Without pagination in the prompt. The system will process and display the initial results" },
{ "start": 14, "end": 35, "text": "Configure Analysis Parameters", "description": "Click the Manage parameters icon. Click Add parameter. Select a key (e.g., Total Loan Amount (a)), choose a dimension (e.g., state), change the operator to multiplication, and enter a value (e.g., 2) to define how the measure will change. Click Add parameter to confirm" },
{ "start": 35, "end": 42, "text": "Re-execute Analysis with Parameters", "description": "Click the Analyze button within the Manage parameters dialog. The analysis will re-execute with the newly defined parameters, and the updated results will display in the table" },
{ "start": 42, "end": 48, "text": "Save Analysis Scenario", "description": "Click the Save scenario icon. Enter a descriptive name for your scenario (e.g., What-if the monthly interest rates doubles-how will it impact the annual interest rate). Click Save to store this specific scenario" },
{ "start": 48, "end": 52, "text": "Run Saved Scenario", "description": "To apply a saved scenario, click the Load scenario icon. Select the scenario you want to run from the list. The analysis will automatically update to reflect the scenario's parameters" },
{ "start": 52, "end": 65, "text": "Export Analysis Results", "description": "Click the Export icon. Choose your desired export format (e.g., Loan Details Format) from the options provided to download the analysis results" }
]}

poster="/images/introduction-poster.png"
posterText="What-If Analysis And Formula"
client:load
/>

## What-If Formulae

<MediaPlayerComponent video="What-if-formulae.mp4"
chapters={[
{ "start": 0, "end": 5, "text": "Click on What-If Formulae under Analysis", "description" : "From the Infoveave menu, click Analysis in the top navigation bar. Select What-If Formulae from the dropdown menu to navigate to the formula section." },
{ "start": 5, "end": 10, "text": "Create a New Formula", "description" : "Click the New Formula button, provide a descriptive name, select the data source and save."},
{ "start": 10, "end": 16, "text": "Define the First Formula Element" , "description" : "Click Add New to define a formula element. Assign a unique Key, provide a Name , select a relevant Measure, and choose appropriate Dimensions. Ensure Value type is Value and then click Save." },
{ "start": 16, "end": 20, "text": "Define the Second Formula Element", "description" : "Click Add New again. Assign a Key, provide a Name, select another relevant Measure, and choose applicable Dimensions. Keep Value type as Value and click Save." },
{ "start": 20, "end": 24, "text": "Define the Third Formula Element" , "description" : "Click Add New. Assign a Key, provide a Name, select a third relevant Measure, and choose applicable Dimensions. Keep Value type as Value and click Save."},
{ "start": 24, "end": 26, "text": "Define a Value-Based Formula Element" , "description" : "Click Add New. Assign a Key, provide a Name, and set an Initial value. Ensure Value type is Value and click Save."},
{ "start": 26, "end": 29, "text": "Define a Calculated Formula Element (Expression 1)" , "description" : "Click Add New. Assign a Key, provide a Name, select Standard for Expression type, and enter a relevant expression using previously defined keys. Click Save."},
{ "start": 29, "end": 32, "text": "Define a Calculated Formula Element (Expression 2)" , "description" : "Click Add New. Assign a Key, provide a Name, select Standard for Expression type, and enter another relevant expression. Click Save."},
{ "start": 32, "end": 35, "text": "Define a Calculated Formula Element (Expression 3)" , "description" : "Click Add New. Assign a Key, provide a Name, select Standard for Expression type, and enter a relevant expression. Click Save."},
{ "start": 35, "end": 41, "text": "Define a Conditional Formula Element" , "description" : "Click Add New. Assign a Key, provide a Name, select Standard for Expression type, and enter a conditional expression based on your analysis needs. Click Save."},

]}
poster="/images/introduction-poster.png"
posterText="What-If Analysis And Formula"
client:load
/>

## Managing Export Format

<MediaPlayerComponent
  video="Manage-export-format.mp4"
  chapters={[
  {
    "start": 0,
    "end": 3,
    "text": "Click on Manage Export Format icon",
    "description": "From the 'My What-if Formulae' page, click manage export icon next to the title 'What-if Formulae' to open the 'Manage export format' view."
  },
  {
    "start": 3,
    "end": 5,
    "text": "Create New Export Format",
    "description": "On the Manage export format page, click the New button in the top right corner to define a new export format."
  },
  {
    "start": 5,
    "end": 7,
    "text": "Name the Export Format",
    "description": "In the Name field, type Loan Details Format for your new export configuration."
  },
  {
    "start": 7,
    "end": 20,
    "text": "Select Columns for Export",
    "description": "Systematically check the Export box next to each column you wish to include in the exported file. Select loan_approval_date, gender, education, property_area, branch, state, applicant_income, and loan_amount."
  },
  {
    "start": 20,
    "end": 21,
    "text": "Save Export Format",
    "description": "After selecting all desired columns, click the Save button in the top right corner of the screen to save your Loan Details Format."
  },
  {
    "start": 21,
    "end": 25,
    "text": "Verify Saved Export Format",
    "description": "The system will redirect you back to the Manage export format page, where your newly created Loan Details Format will be visible, confirming it has been saved."
  }
]
}
  poster="/images/introduction-poster.png"
  posterText="Managing export format"
  client:load
/>

## SciPYR

<MediaPlayerComponent video="SciPyR-Create.mp4"
chapters={[
    {
      start: 0,
      end: 6,
      text: "Click on SciPyR under Analysis",
      description:
         "From the Infoveave menu, click 'Analysis', then click 'SciPyR' from the dropdown menu. Wait for the SciPyR Books page to load."
    },
    {
      start: 6,
      end: 10,
      text: "Create a New SciPyR Book",
      description:
        "Click the New SciPyR Book button, provide a name (e.g., Loan SciPyR Book), select a language (Python), then save.",
    },
    {
      start: 10,
      end: 12,
      text: "Enter Python Code",
      description:
        "Enter Python code into the SciPyR Book editor.",
    },
     {
      start: 12,
      end: 17,
      text: "Run Python Code",
      description:
        "Click the Run button to execute the code.",
    },
     {
      start: 17,
      end: 20,
      text: "Save Python Code",
      description:
        "Click the Save button to save the code.",
    },
    {
      start: 20,
      end: 24,
      text: "View Summary Panel",
      description:
        "Comments are displayed in the Summary panel. Clicking a comment navigates to the corresponding code line.",
    },
    {
      start: 24,
      end: 27,
      text: "View Variables Panel",
      description:
        "The Variables panel displays all defined variables, their type, and associated data from the executed code.",
    },
    {
      start: 27,
      end: 43,
      text: "View PDF Export of Book",
      description:
        "Click the View PDF menu bar to download or print the SciPyR book as a PDF file, saving it to your local storage.",
    },
]}
poster="/images/introduction-poster.png"
posterText="SciPYR"
client:load/>

## Adding A New User In Infoveave

<MediaPlayerComponent video="Add-A-New-User-In-Infoveave.mp4"
chapters={[

  {
    "start": 0,
    "end": 4,
    "text": "Click Users under Administration",
    "description": "To begin, navigate to the Administration menu. From the dropdown, select Users to view the existing user accounts."
  },
  {
    "start": 4,
    "end": 5,
    "text": "Create a New User",
    "description": "Once the Users page loads, locate and click the New User button, typically found in the top-right corner of the user list, to open the user creation form."
  },
  {
    "start": 5,
    "end": 8,
    "text": "Define User Role",
    "description": "In the Role field, click the dropdown and select the appropriate role for the new user. For this example, choose Creator."
  },
  {
    "start": 8,
    "end": 17,
    "text": "Enter User Details",
    "description": "Fill in the required user information: enter peter for User name, Peter for First name, Doe for Last name, and peterdoe@infoveave.com for Email."
  },
  {
    "start": 17,
    "end": 19,
    "text": "Assign Datasource Access",
    "description": "In the Datasources section, select the datasources this user should have access to. Check the box next to Employee Dataset to grant access to that specific data."
  },
  {
    "start": 19,
    "end": 27,
    "text": "Add Context Filter",
    "description": "Under the Context section, click + Add filter. From the dropdown, select Name. In the value field, type Alice Brown and select it from the suggestions to add a context filter for the user."
  },
  {
    "start": 27,
    "end": 34,
    "text": "Save New User",
    "description": "Finally, click the Save button in the top-right corner to create the new user account. The system will process the request and add the user to the list."
  }


]}
poster="/images/introduction-poster.png"
posterText="Adding A New User In Infoveave"
client:load/>

## Creating A Custom Calendar

<MediaPlayerComponent video="Create-A-Custom-Calendar.mp4"
chapters={[
  {
    "start": 0,
    "end": 6,
    "text": "Click Custom Calendar under Administration",
    "description": "From the Infoveave menu, click 'Administration', then click 'Custom Calendars' from the dropdown menu. Wait for the custom calendars page to load."
  },
  {
    "start": 6,
    "end": 8,
    "text": "Create New Custom Calendar",
    "description": "On the Custom Calendar page, click the New Custom Calendar button, located in the top-right corner of the screen, to open the custom calendar creation form."
  },
  {
    "start": 8,
    "end": 14,
    "text": "Define Calendar Properties",
    "description": "In the New custom calendar dialog, type Financial Calendar into the Name field. Enter 2025 for the Year. Set the Start date to 2025-04-01 and the End date to 2026-03-31 to cover a full financial year."
  },
  {
    "start": 14,
    "end": 34,
    "text": "Select Calendar Type (Month-wise)",
    "description": "Choose Month wise as the calendar type. Then, click Continue. This will generate the monthly breakdown of your custom financial calendar."
  },
  {
    "start": 34,
    "end": 51,
    "text": "Adjust Month and Quarter Names",
    "description": "Review the generated monthly entries. Adjust the Month name and Quarter name fields as necessary to align with your organization's financial reporting structure, ensuring they are ordered correctly within your custom calendar year."
  },
  {
    "start": 51,
    "end": 63,
    "text": "Save Custom Calendar",
    "description": "Finally, click the Save button in the top-right corner of the screen to save your new Financial Calendar. A success notification will appear, confirming that 'Year 2025 added successfully.'"
  }
]
}
poster="/images/introduction-poster.png"
posterText="Creating A Custom Calendar"
client:load/>

## Creating Data Quality

<MediaPlayerComponent 
video="Data-Quality-Help-Updated-Flow.mp4"
 chapters={[
{ "start": 0, "end": 11, "text": "Click on Catalogue", "description" : "Click on Catalogue in the top menu, then select Assets from the sidebar. After that, click on Datasource to view available datasources." },
{ "start": 11, "end": 27, "text": "Search for Datasource", "description" : "Click on Search Assets, type the datasource name, and choose the respective datasource from the filtered results."},
{ "start": 27, "end": 36, "text": "Add Documentation to Asset" , "description" : "Click the New documentation button. Enter the content and then click Save." },
{ "start": 36, "end": 41, "text": "Click on Data Quality under Automation", "description" : "Click on Automation and select Data Quality" },
{ "start": 41, "end": 58, "text": "Create New Data Quality Setup" , "description" : "On the Data Quality page, click New Data Quality. In the pop-up, confirm the connection, click the Select table dropdown, select the table, and click Next."},
{ "start": 58, "end": 71, "text": "Generate AI-Powered Data Quality Rules", "description" : "Click Generate Data Quality Rules. Wait for the AI to analyze and list suggested rules. Once visible, click Generate Data Quality to proceed." },
{ "start": 71, "end": 79, "text": "Review and Save Rule Configuration", "description" : "Review the generated rules, make adjustments, or explore options like Schedules. Click Save in the top right corner."},
{ "start": 79, "end": 86, "text": "Execute Data Quality Rules" , "description" : "Click the Execute button in the top right. Confirm by clicking Execute again. The system will run the defined data quality rules against your data." },
{ "start": 86, "end": 89, "text": "View Data Quality Summary", "description" : "The summary page will display progress and initial results. Then, click the Data Quality breadcrumb link to go back to the Data Quality page." },
{ "start": 89, "end": 98, "text": "View Detailed Data Quality Report" , "description" : "Click View Summary on the card to see the full data quality report."}, 
]}
poster="/images/introduction-poster.png"
posterText="Creating Data Quality"
client:load/>

## Creating Excel Report Using Infoveave Plugin

<MediaPlayerComponent
  video="Create-A-Powerpoint-Report-Using-Infoveave-Plugin.mp4"
   chapters={[
{ "start": 0, "end": 27, "text": "Introduction"},
{ "start": 27, "end": 40, "text": "Install the Infoveave Plugin", "description" : "First, open your PowerPoint presentation. To get the plugin, go to the Home tab, click Add-ins, search for Infoveave, and then click Add to install it."},
{ "start": 40, "end": 49, "text": "Log In to Your Account" , "description" : "Once the plugin is installed, a login panel will appear on the right. Enter your Infoveave instance details, username, and password, then click Login to connect your account." },
{ "start": 49, "end": 76, "text": "Insert a Widget", "description" : "Click Insert Widget. In the new window, select the Infoboard and the specific widget you want to add. Configure the widget by selecting a date range, adjusting its width and height, and clicking Insert Image to add it to your slide." },
{ "start": 76, "end": 92, "text": "Upload the Report Template" , "description" : "Now, go to your Infoveave web portal. Navigate to Studio > Reports and click New Report. Give your report a name, upload the PowerPoint file you just prepared, and click Save."},
{ "start": 92, "end": 120, "text":"Download the Final Report", "description" : "To generate the final report with live data, find your uploaded template and click the Download icon. In the pop-up window, set your desired date range and apply any necessary filters, then click Download Report." },
{ "start": 120, "end": 139, "text": "Review the Updated Report", "description" : "Open the newly downloaded PowerPoint file. You will see that the charts and data have been automatically updated based on the date range and filters you selected during the download process."},
]}
  poster="/images/introduction-poster.png"
posterText="Create Excel Report Using Infoveave Plugin"
  client:load
/>

## Setup Common Dimensions On Your Infoboard

<MediaPlayerComponent video="Setup-Common-Dimensions-On-Your-Infoboard.mp4"
chapters={[
     {
    "start": 0,
    "end": 2,
    "text": "Open Infoboard in Designer View",
    "description": "The video starts showing the 'Risk & Compliance' Infoboard open in designer view, ready for modifications."
  },
  {
    "start": 2,
    "end": 5,
    "text": "Click Filters Section",
    "description": "On the right-side panel, click the 'Filters' section to expand it and view filter options."
  },
  {
    "start": 5,
    "end": 8,
    "text": "Add Common Dimension Filter",
    "description": "Click '+ Add common dimension' to add a new filter field to the Infoboard."
  },
  {
    "start": 8,
    "end": 13,
    "text": "Name the Filter as 'Branch'",
    "description": "In the Name field for the new common dimension, type Branch."
  },
  {
    "start": 13,
    "end": 16,
    "text": "Select Dimension Field",
    "description": "Click the dropdown menu next to Dimensions and select Branch_Location to link this filter to the geographical branch data."
  },
  {
    "start": 16,
    "end": 22,
    "text": "Save Infoboard",
    "description": "Ensure the filter is correctly configured, then click the Save button in the top-right corner to save the infoboard with the new filter."
  },
  {
    "start": 22,
    "end": 33,
    "text": "Click 'Branch' Filter",
    "description": "After the infoboard reloads, click the newly added Branch filter dropdown located at the top of the dashboard."
  },
  {
    "start": 33,
    "end": 41,
    "text":"Apply Multiple Branch Filters",
    "description": "From the list of available branches, select Bakersfield, Brooklyn, Dallas, and Houston by checking their respective boxes."
  },
  {
    "start": 41,
    "end": 49,
    "text": "Observe Filtered Data",
    "description": "Observe how the charts, specifically Non-Performing Assets by Branches, Operational Loss, and Data Breach Incidents by State, dynamically update to display data only for the selected branches."
  }

]}
poster="/images/introduction-poster.png"
posterText="Setting up Common Dimensions On Your Infoboard"
client:load
/>

## Perform Exploratory Data Analysis Using Scipyr

<MediaPlayerComponent
  video="Perform-Exploratory-Data-Analysis-Using-Scipyr.mp4"
  chapters={[
{ "start": 0, "end": 12, "text": "Introduction"},
{ "start": 12, "end": 35, "text": "Navigate to SciPyR and Create a New Book", "description" : "To start, go to the Analysis menu and select SciPyR. Click the New SciPyR Book button. In the pop-up window, enter a name for your workbook, choose the programming language (e.g., Python), and click Save."},
{ "start": 35, "end": 87, "text": "Explore the Workbook Interface" , "description" : "Get familiar with the layout. The Tasks panel on the left helps you navigate your analysis. The Setup panel on the right shows installed packages and variables. The top bar provides controls to run code, manage cells (Code or Markdown), and restart the kernel." },
{ "start": 87, "end": 102, "text": "Import Data Using a Query	", "description" : "First, import your necessary Python libraries. In a new code cell, click the Insert Query icon at the bottom. Select your desired Datasource, and the corresponding SQL query will appear. Click Save to load the data into a Pandas DataFrame." },
{ "start": 102, "end": 112, "text": "Perform and Visualize Data Analysis" , "description" : "Write and run Python code to clean, transform, and analyze your data. You can generate visualizations like plots and charts, which will appear directly below the code cells. You can also view any created variables, like DataFrames, in the Setup panel on the right."},
{"start": 112, "end": 126, "text": "Export Your Analysis as a PDF" , "description" : "Once your analysis is complete, click the View PDF button at the top right of the screen. This action will generate and open a PDF version of your entire notebook, including all code, text, and visualizations, ready for sharing or saving."}
]}
  poster="/images/introduction-poster.png"
  posterText="Perform Exploratory Data Analysis Using Scipyr"
  client:load
/>

## Set Up A Date Filter On Infoboard

<MediaPlayerComponent video="Set-Up-A-Date-Filter-On-Infoboard.mp4"
chapters={[

  {
    "start": 0,
    "end": 5,
    "text": "Click on Configuration",
    "description": "Click the Setup icon on the right side of the screen to open the configuration panel."
  },
  {
    "start": 5,
    "end": 28,
    "text": "Set Default Date Range",
    "description": "Under Configuration, find the Date range section. Click Default, then the calendar icon. Choose Months, select start and end months, and click outside the calendar to apply."
  },
  {
    "start": 28,
    "end": 44,
    "text": "Apply Fixed Date Range",
    "description": "Click the Fixed dates tab. In the calendar picker, select Apr 2024 as the start date and Aug 2024 as the end date. Observe how the dashboard updates to show data for this specific five-month period."
  },
    {
    "start": 44,
    "end": 46,
    "text": "Apply No Date Range",
    "description": "To clear all date filters, click the No dates tab. The dashboard will refresh to display data without any date range restrictions."
  },
  {
    "start": 46,
    "end": 50,
    "text": "Save Infoboard Changes",
    "description": "Click the Save button at the top right. A confirmation message will confirm the Infoboard was saved successfully."
  }
]

}
poster="/images/introduction-poster.png"
posterText="Setting Up A Date Filter On Infoboard"
client:load
/>

## Customize Visualisations On Your Infoboard

<MediaPlayerComponent video="Customize-Visualisations-On-Your-Infoboard.mp4"
chapters=
{[ { "start": 0, "end": 5, "text": "Click create Infoboard", "description": "From the Infoveave home screen, click the Insights dropdown menu, select Infoboards, then click Create Infoboard to begin." }, { "start": 5, "end": 10, "text": "Select Designer Layout", "description": "In the Select a template dialog, click Use Designer Layout to start with a blank canvas." }, { "start": 20, "end": 30, "text": "Adding a Data Source", "description": "In the Add Datasource dialog, type Revenue Growth, select it from the suggestions, and click Save." }, { "start": 30, "end": 34, "text": "Naming the Infoboard", "description": "In the Infoboard name field on the right, enter Infoboard Visualization as the title." }, { "start": 34, "end": 57, "text": "Adding and Configuring a Column Chart", "description": "Click Column in the Charts panel to add it to the canvas. Set Revenue Growth as the source, Revenue as the value, and Product Type as the axis." }, { "start": 57, "end": 89, "text": "Customizing Column Chart Axis", "description": "Select the column chart, open the Customization tab, expand Categorical axis, and enter Product Type for both axis name and label fields." }, { "start": 89, "end": 110, "text": "Adding and Configuring a Pie Chart", "description": "Click Pie in the Charts panel to add it to the canvas. Set Revenue Growth as the source, Customers as the measure, and Account Type as the dimension." }, { "start": 110, "end": 140, "text": "Customizing Pie Chart Series", "description": "Select the pie chart, open the Customization tab, expand Series, enable Show labels, set Apply to as Insurance, position as Inside, and pick a custom color." }, { "start": 140, "end": 157, "text": "Saving the Infoboard", "description": "Click the Save button at the top right. A success message confirms the infoboard is saved, displaying both visualizations." } ]
}
poster="/images/introduction-poster.png"
posterText="Infoveave Modules"
client:load/>

## Creating Infoboards Using Design Templates

<MediaPlayerComponent video="Create-Infoboards-Using-Design-Templates.mp4"
chapters={[
  {
    "start": 0,
    "end": 5,
    "text": "Create Infoboard ",
    "description": "From the Infoveave menu, click on Insights and click on Create Infoboard to begin creating a new infoboard."
  },

  {
    "start": 5,
    "end": 15,
    "text": "Preview a Template",
    "description": "A Select a template window will appear. Scroll through the available templates and click the magnifying glass icon next to Financial Insights Dashboard to preview it."
  },
  {
    "start": 15,
    "end": 31,
    "text": "Review Template Preview",
    "description": "Examine the interactive preview of the Financial Insights Dashboard template, observing its various charts and layouts. Close the preview once you're done."
  },
  {
    "start": 31,
    "end": 38,
    "text": "Select and Use Template",
    "description": "Back in the Select a template window, click Use this template for the Financial Insights Dashboard."
  },
  {
    "start": 38,
    "end": 49,
    "text": "Generate Infoboard from Datasource",
    "description": "A Generate Infoboard using Fovea dialog will appear. Select Finance datasource from the dropdown, then click Update Infoboard. The system will analyze your data and build the infoboard."
  },
  {
    "start": 49,
    "end": 61,
    "text": "Configure Bar Chart",
    "description": "On the newly generated Order Transactions Dashboard, click the bar chart titled Avg Sales vs Orders Trend. In the right-hand configuration panel, ensure Finance datasource is selected as the Source, Sales Amount for Value, Order Id for Size, and Mode Of Payment for Axis."
  },
  {
    "start": 61,
    "end": 126,
    "text": "Configure Multi-Measure Chart",
    "description": "Click the multi-measure chart on the right side of the dashboard. In its configuration panel, select Order Transactions Dashboard as the Source. For Value, choose Transaction ID. For Axis, select Mode of Payment. Then, in the General tab, enable the Title and change the Label to Transaction Distribution by Payment. Adjust the Font size to 26."
  },
  {
    "start": 126,
    "end": 142,
    "text": "Save Infoboard",
    "description": "Click the Save button in the top-right corner of the screen to save the Order Transactions Dashboard. A success notification will confirm the save."
  },
]
}
poster="/images/introduction-poster.png"
posterText="Creating Infoboards Using Design Templates"
client:load/>

## Creating Infoboard Using Raw Datasources

<MediaPlayerComponent video="Create-Infoboard-Using-Raw-Datasources.mp4"
chapters={[
  {
    "start": 0,
    "end": 4,
     "text": "Click Insights",
    "description": "From the Infoveave menu, click 'Insights'."
  },
  {
    "start": 4,
    "end": 5,
   "text": "Create New Infoboard",
    "description": "Click the 'Create Infoboard' card to begin creating a new infoboard."
  },
  {
    "start": 5,
    "end": 18,
    "text": "Select Designer Layout",
    "description": "Click Use Designer Layout to start building a custom Infoboard from scratch."
  },
  {
    "start": 18,
    "end": 33,
    "text": "Choose Raw Data as Source",
    "description": "Click Add New Source. In the Infoboard Source dialog, select Use raw data to input your data directly."
  },
  {
    "start": 33,
    "end": 49,
    "text": "Input and Validate Raw Data",
    "description": "In the dialog, name the source sales data. Paste or type your tab-separated raw data into the text area. Click Validate, then Save."
  },
  {
    "start": 49,
    "end": 53,
    "text": "Add Bar Chart Component",
    "description": "Drag and drop a Bar chart from the Charts panel onto the canvas. Resize it as needed."
  },
  {
    "start": 53,
    "end": 60,
    "text": "Configure Bar Chart Data",
    "description": "Select the bar chart, go to the Basic section in the right panel. Set Source to sales data, then drag Quantity to Value and Category to Axis."
  },
  {
    "start": 60,
    "end": 82,
    "text": "Customize Bar Chart",
    "description": "Go to the Customization tab. Expand the Title section, enable it, set label to Total Sales by Category, and adjust font color and alignment."
  },
  {
    "start": 82,
    "end": 91,
    "text": "Save Infoboard",
    "description": "Enter Sales Analysis Dashboard as the name and click Save. A confirmation message will appear."
  }
]
}
poster="/images/introduction-poster.png"
posterText="Creating Infoboard Using Raw datasources"
client:load/>

## Creating A Powerpoint Report Using Infoveave Plugin

<MediaPlayerComponent
  video="Create-A-Powerpoint-Report-Using-Infoveave-Plugin.mp4"
   chapters={[
{ "start": 0, "end": 27, "text": "Introduction"},
{ "start": 27, "end": 40, "text": "Install the Infoveave Plugin", "description" : "First, open your PowerPoint presentation. To get the plugin, go to the Home tab, click Add-ins, search for Infoveave, and then click Add to install it."},
{ "start": 40, "end": 49, "text": "Log In to Your Account" , "description" : "Once the plugin is installed, a login panel will appear on the right. Enter your Infoveave instance details, username, and password, then click Login to connect your account." },
{ "start": 49, "end": 76, "text": "Insert a Widget", "description" : "Click Insert Widget. In the new window, select the Infoboard and the specific widget you want to add. Configure the widget by selecting a date range, adjusting its width and height, and clicking Insert Image to add it to your slide." },
{ "start": 76, "end": 92, "text": "Upload the Report Template" , "description" : "Now, go to your Infoveave web portal. Navigate to Studio > Reports and click New Report. Give your report a name, upload the PowerPoint file you just prepared, and click Save."},
{"start": 92, "end": 120, "text": "Download the Final Report" , "description" : "To generate the final report with live data, find your uploaded template and click the Download icon. In the pop-up window, set your desired date range and apply any necessary filters, then click Download Report."},
{"start": 120, "end": 132, "text": "Review the Updated Report" , "description" : "Open the newly downloaded PowerPoint file. You will see that the charts and data have been automatically updated based on the date range and filters you selected during the download process."},
]}
  poster="/images/introduction-poster.png"
  posterText="Create A Powerpoint Report Using Infoveave Plugin"
  client:load
/>

## Configure Measures And Dimensions

<MediaPlayerComponent video="Configure-Measures-And-Dimensions.mp4"
chapters={[
  {
    "start": 0,
    "end": 7,
    "text": "Click Datasources under Studio",
    "description": "From the Infoveave menu, click 'Studio', then click 'Datasources' from the dropdown menu. Wait for the datasources list to load."
  },
  {
    "start": 7,
    "end": 22,
    "text": "Open Loan Dataset",
    "description": "On the Datasources page, locate the Loan Dataset and click on it to open its configuration and view its columns."
  },
  {
    "start": 22,
    "end": 39,
    "text": "Add Measure",
    "description": "Right-click on the 'applicant_income' column within the 'loan_dataset' table. From the context menu, click 'Add measure'."
  },
  {
    "start": 39,
    "end": 46,
    "text": "Add Dimension",
    "description": "Next, locate gender in the column list and click on ellipsis and add dimension. In the Add dimension dialog, change the Dimension name to Gender. Click Add dimension to confirm. A success notification will appear."
  },
  {
    "start": 46,
    "end": 53,
    "text": "Add Date Dimension",
    "description": "Find loan_application_date in the column list and click on ellipsis and add dimension. In the Add dimension dialog, rename Dimension name to Loan Application Date. Click Add dimension to add it. A success notification will appear."
  },
  {
    "start": 53,
    "end": 61,
    "text": "Save Datasource Changes",
    "description": "After adding both the new measure and dimensions, click the Save button in the top-right corner of the screen to commit all changes to the Loan Dataset datasource. A final success notification will confirm the save operation."
  }
]}
poster="/images/introduction-poster.png"
posterText="Configuring Measures And Dimensions"
client:load/>

## Configure Drill Down

<MediaPlayerComponent video="Configure-Drill-Down.mp4"
chapters={[
  {
    "start": 0,
    "end": 1,
    "text": "Open Infoboard in Designer View",
    "description": "The video starts showing the 'Bank Transaction Analysis' Infoboard open in designer view, ready for modifications."
  },
  {
    "start": 1,
    "end": 5,
    "text": "Adjust Infoboard Height",
    "description": "Click the 'Fill Height' button to expand the Infoboard and display all its contents within the available screen space."
  },
  {
    "start": 5,
    "end": 7,
    "text": "Open Chart Configuration Panel",
    "description": "Click the 'Configuration' icon on the right-side panel to open the settings for the currently selected chart, 'Average Transaction Amount by Region'."
  },
  {
    "start": 7,
    "end": 12,
    "text": "Enable Drill and Apply Filters Interaction",
    "description": "In the chart configuration panel, scroll down to the 'Interactions' section, and then select the 'Drill and apply filters' radio button to enable drill-down functionality."
  },
  {
    "start": 12,
    "end": 13,
    "text": "Add a New Drill Level",
    "description": "Click the '+ Add drill level' button to add a new level for drilling down into the data."
  },
  {
    "start": 13,
    "end": 19,
    "text": "Configure Drill Level Axis to Age Bucket",
    "description": "In the newly added Drill Level 2 section, click the Axis dropdown. Type age_bucket and then select it from the suggested fields."
  },
  {
    "start": 19,
    "end": 23,
    "text": "Save Infoboard Changes",
    "description": "Click the 'Save' button in the top right corner of the screen to finalize the new user creation. A success message confirms the save."
  },
  {
    "start": 23,
    "end": 29,
    "text": "Fit Infoboard to Screen",
    "description": "After the Infoboard reloads in view mode, click the 'Fit Board' icon in the top right toolbar to ensure the entire dashboard is visible on the screen."
  },
  {
    "start": 29,
    "end": 33,
    "text": "Perform Drill-Down on Chart",
    "description": "Click on the 'Northeast' bar within the 'Average Transaction Amount by Region' chart. This action drills down to display the transaction amounts by 'age_bucket' specifically for the Northeast region."
  },
  {
    "start": 33,
    "end": 41,
    "text": "Reset Drill-Down View",
    "description": "Click the 'Reset Drill' icon near the top of the Infoboard to revert the chart to its original, aggregated view, removing the applied drill-down filter."
  }
]}
poster="/images/introduction-poster.png"
posterText="Configuring Drill Down"
client:load/>

## Setup Conditional Expressions In Infoboard

<MediaPlayerComponent
  video="Setup-Conditional-Expressions-In-Infoboard.mp4"
    chapters={[
  {
    "start": 0,
    "end": 4,
    "text": "Click on Configuration Panel",
    "description": "From the Customer Churn Dashboard, locate the right-hand panel and expand the Configuration section to reveal advanced options."
  },
  {
    "start": 4,
    "end": 7,
    "text": "Click on Configure expressions",
    "description": "Click on Configure expressions within the Configuration section. A new dialog box will appear to manage conditional expressions."
  },
  {
    "start": 7,
    "end": 14,
    "text": "Add First Conditional Expression",
    "description": "In the Configure expressions dialog, click Add Expression. Enter the expression: AVERAGE('Average ChurnRate'['Churn Rate']) > 0.18. This condition checks if the average churn rate exceeds 0.18."
  },
  {
    "start": 14,
    "end": 19,
    "text": "Configure Workflow Trigger Action",
    "description": "For the first expression, select Workflow Trigger from the Widget dropdown. Ensure Visibility is toggled on. Click Edit action to define what happens when this condition is met."
  },
  {
    "start": 19,
    "end": 34,
    "text": "Select Workflow to Execute",
    "description": "In the Edit action dialog, choose Execute Workflow from the Actions dropdown. Then, from the Workflows dropdown, select Download Email. Keep Ask for confirmation checked, and click Save."
  },
  {
    "start": 34,
    "end": 44,
    "text": "Add Second Conditional Expression",
    "description": "Click Add Expression again. Enter the second expression: AVERAGE('Average ChurnRate'['Churn Rate']) < 0.14. This condition checks if the average churn rate is below 0.14."
  },
  {
    "start": 44,
    "end": 54,
    "text": "Configure Green Indicator",
    "description": "For the second expression, select Green Indicator from the Widget dropdown. Ensure Visibility is toggled on. Expand the General options and set the Icon size to 18. Click Save to confirm both expressions."
  },
  {
    "start": 54,
    "end": 63,
    "text": "Save Infoboard",
    "description": "Click the Save button in the top-right corner of the Infoboard interface to apply all changes, including the newly configured conditional expressions."
  },
  {
    "start": 63,
    "end": 72,
    "text": "Apply Account Tenure Filter",
    "description": "Once the Infoboard reloads, click the Account Tenure filter dropdown in the top right. From the options, select 4-5 years to filter the dashboard data. Observe the changes in the dashboard metrics."
  },
  {
    "start": 72,
    "end": 79,
    "text": "Manually Trigger Workflow",
    "description": "Notice the Workflow Trigger button (based on the first expression) is now visible. Click it, and then click Yes on the confirmation prompt to manually execute the Download Email workflow."
  },
  {
    "start": 79,
    "end": 91,
    "text": "Change Filter and Observe Indicators",
    "description": "Change the Account Tenure filter to 3-4 years. Observe how the Churn Rate percentage changes (from 19% to 11%) and the color indicator dynamically switches from red to green, reflecting the configured conditional expressions."
  }

]}
  poster="/images/introduction-poster.png"
  posterText="Setup Conditional Expressions In Infoboard"
  client:load
/>

## Fetching Gmail Attachments and Uploading to Datasource

<MediaPlayerComponent
  video="Fetching-attachments.mp4"
    chapters={
      [
  {
    "start": 0,
    "end": 1,
    "text": "Click on Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration' and then click on 'Connections' to manage your data connections."
  },
  {
    "start": 1,
    "end": 4,
    "text": "Create a New Gmail Connection",
    "description": "Click on the 'New Connection' button to add a new connection. Scroll down to the 'Email' section and select the 'Gmail' connection type."
  },
  {
    "start": 4,
    "end": 23,
    "text": "Configure and Authenticate Gmail Connection",
    "description": "In the 'New Gmail Connection' dialog, enter a descriptive name. Click 'Connect to Gmail,' then proceed to sign in to your Google account by entering your email, completing any CAPTCHA, and entering your password. Grant infoveave.cloud access to view your email messages and settings, then click 'Continue'. 'Validate' and 'Save' to complete the connection setup."
  },
  {
    "start": 23,
    "end": 26,
    "text": "Click on Workflows under Automation",
    "description": "From the Infoveave menu, click on 'Automation' and select 'Workflows' to access the workflow management section."
  },
  {
    "start": 26,
    "end": 29,
    "text": "Create a New Workflow",
    "description": "Click the 'New Workflow' button. Enter the workflow name and add a description. Once done, save the workflow."
  },
  {
    "start": 29,
    "end": 33,
    "text": "Add Gmail Activity to Workflow",
    "description": "Use the search bar on the right-hand panel to find 'Gmail' under 'Email activities' and drag the Gmail activity icon onto the workflow canvas."
  },
  {
    "start": 33,
    "end": 53,
    "text": "Configure Gmail Activity",
    "description": "Select the newly added Gmail activity on the canvas. In the configuration panel, select the 'Gmail Account Setup' connection you previously created. Set the 'Folder name' to 'Infoveavefiles'. Adjust the 'From received date' and the 'To received date'. Finally, enable 'Download attachment' and click 'Validate'."
  },
  {
    "start": 53,
    "end": 59,
    "text": "Add Start Iteration Activity",
    "description": "Search for 'Start iteration' under 'Flow control activities' and drag it onto the canvas, connecting it after the Gmail activity. In its properties, change the 'Operation' to 'Iterate over each file' and set the 'Identifier Column' to 'File name'."
  },
  {
    "start": 59,
    "end": 64,
    "text": "Add Upload to Datasource Activity",
    "description": "Search for 'Upload to Datasource' under 'Infoveave activities' and drag it onto the canvas, connecting it after the 'Start iteration' activity. In its properties, select the 'Datasource' and enter 'Table'."
  },
  {
    "start": 64,
    "end": 67,
    "text": "Add End Iteration Activity",
    "description": "Search for 'End iteration' under 'Flow control activities' and drag it onto the canvas, connecting it after the 'Upload to Datasource' activity."
  },
  {
    "start": 67,
    "end": 88,
    "text": "Validate All Workflow Activities",
    "description": "Click the 'Validate' button for each of the 'Start Iteration', 'Upload to Datasource', and 'End Iteration' activities to ensure all configurations are correct and there are no errors in the workflow setup."
  },
  {
    "start": 88,
    "end": 93,
    "text": "Run the Workflow",
    "description": "Click the 'Run' button located at the top right of the workflow editor. Confirm that you want to run the workflow by clicking 'Yes' in the pop-up prompt."
  },
  {
    "start": 93,
    "end": 117,
    "text": "Monitor Workflow Execution",
    "description": "Observe the 'Workflow logs' to track the real-time execution status of each step. You can click on individual activities in the left panel to view their respective data outputs and ensure successful processing."
  }
]

    }
  poster="/images/introduction-poster.png"
  posterText="Fetching Gmail Attachments and Uploading to Datasource"
  client:load
/>

## Creating an API Connection

<MediaPlayerComponent
  video="NewApiConnections.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 6,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 6,
    "end": 8,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to begin the process of adding a new connection."
  },
  {
    "start": 8,
    "end": 11,
    "text": "Select API Connection",
    "description": "Click the 'API' option under the 'Cloud services' section to create a new API connection."
  },
  {
    "start": 11,
    "end": 20,
    "text": "Configure API Connection",
    "description": "Enter the name for your new API connection. Set the 'API request type' and input the authentication URL. Fill in the 'Client ID' and the 'Client secret' with the appropriate password."
  },
  {
    "start": 20,
    "end": 22,
    "text": "Validate API Connection",
    "description": "Click the 'Validate' button to check if the entered API connection details are correct and establish a successful connection."
  },
  {
    "start": 22,
    "end": 25,
    "text": "Save API Connection",
    "description": "After successful validation, click the 'Save' button to finalize and add your new API connection to Infoveave."
  }
]


    }
  poster="/images/introduction-poster.png"
  posterText="Creating an API Connection"
  client:load
/>

## Creating an Azure Connection

<MediaPlayerComponent
  video="AzureConnection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to access your connection management page."
  },
  {
    "start": 4,
    "end": 7,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 7,
    "end": 10,
    "text": "Select Azure Connection",
    "description": "Under the 'File transfer' section, choose 'Azure' to configure a connection to Azure cloud storage."
  },
  {
    "start": 10,
    "end": 20,
    "text": "Configure Azure Details",
    "description": "Enter some name in the 'Name' field. Keep the 'Default endpoints protocol' as 'https' and the 'Endpoint suffix' as 'core.windows.net.' Input the 'Account name' and the corresponding 'Account key.' Finally, enter the 'Container' URL."
  },
  {
    "start": 20,
    "end": 22,
    "text": "Validate Azure Connection",
    "description": "Click the 'Validate' button to verify that the provided Azure credentials and container details are correct and that Infoveave can successfully connect to your Azure storage."
  },
  {
    "start": 22,
    "end": 26,
    "text": "Save Azure Connection",
    "description": "After the connection validates successfully, click the 'Save' button to add the new 'Azure Infoveave' connection to your list of available connections."
  }
]



    }
  poster="/images/introduction-poster.png"
  posterText="Creating an Azure Connection"
  client:load
/>

## Creating a Send Email Connection

<MediaPlayerComponent
  video="NewSendEmailConnections.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your various data and service connections."
  },
  {
    "start": 4,
    "end": 7,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new connection."
  },
  {
    "start": 7,
    "end": 9,
    "text": "Select Send Email Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Email' section and click on 'Send Email' to set up a connection for sending emails through an SMTP server."
  },
  {
    "start": 9,
    "end": 15,
    "text": "Configure Send Email Connection",
    "description": "Enter the connection name. Ensure 'Server type' is set to 'SMTP' and 'Use ssl' is enabled. Input the 'SMTP Host' and the 'Port.' Enter 'From email address' and 'Username,' and then provide the corresponding 'Password.'"
  },
  {
    "start": 15,
    "end": 20,
    "text": "Validate Send Email Connection",
    "description": "Click the 'Validate' button to check the email server settings and credentials. A successful validation confirms that Infoveave can connect to the specified SMTP server."
  },
  {
    "start": 20,
    "end": 25,
    "text": "Save Send Email Connection",
    "description": "After the connection is validated successfully, click the 'Save' button to finalize and add it to your list of connections."
  }
]
}
  poster="/images/introduction-poster.png"
  posterText="Creating a Send Email Connection"
  client:load
/>

## Creating FTP Connection

<MediaPlayerComponent
  video="FtpConnections.mp4"
    chapters={

[
  {
    "start": 0,
    "end": 6,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 6,
    "end": 9,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to initiate the process of adding a new connection."
  },
  {
    "start": 9,
    "end": 13,
    "text": "Select FTP Connection",
    "description": "In the 'New Connection' window, scroll down to the 'File transfer' section and click on 'FTP' to set up a new File Transfer Protocol connection."
  },
  {
    "start": 13,
    "end": 20,
    "text": "Configure FTP Details",
    "description": "Enter the connection name. Ensure 'Source type' is 'FTP' and 'Connection mode' is 'Active'. Input the 'Host' and the 'Port.' Provide the 'Username' and the corresponding 'Password.'"
  },
  {
    "start": 20,
    "end": 24,
    "text": "Validate FTP Connection",
    "description": "Click the 'Validate' button to check if the entered FTP connection details are correct. A successful validation confirms that Infoveave can connect to the specified FTP server."
  },
  {
    "start": 24,
    "end": 27,
    "text": "Save FTP Connection",
    "description": "After the connection is validated successfully, click the 'Save' button to finalize and add the 'FTP Infoveave' connection to your list of available connections."
  }
]
}
  poster="/images/introduction-poster.png"
  posterText="Creating a FTP Connection"
  client:load
/>

## Creating Gmail Connection

<MediaPlayerComponent
  video="GmailConnection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 2,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 2,
    "end": 4,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 4,
    "end": 8,
    "text": "Select Gmail Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Email' section and click on 'Gmail' to begin setting up a connection for accessing and managing your Gmail messages."
  },
  {
    "start": 8,
    "end": 11,
    "text": "Name Gmail Connection",
    "description": "In the 'New Connection' dialog, enter the name for your new connection."
  },
  {
    "start": 11,
    "end": 12,
    "text": "Connect to Gmail",
    "description": "Click the 'Connect to Gmail' button to initiate the Google sign-in process for authentication."
  },
  {
    "start": 12,
    "end": 16,
    "text": "Sign In to Google",
    "description": "On the Google sign-in page, enter your Gmail address and click 'Next.' Subsequently, enter your password and click 'Next' to log in to your Google account."
  },
  {
    "start": 16,
    "end": 19,
    "text": "Review Google Permissions",
    "description": "A Google security prompt will appear. First, click 'Continue' to acknowledge that the app is being tested. Then, review the requested permissions for infoveave.cloud to access your Google Account, ensuring you trust the application. If you agree, click 'Continue.'"
  },
  {
    "start": 19,
    "end": 24,
    "text": "Validate Gmail Connection",
    "description": "Back in Infoveave, click the 'Validate' button to confirm that the Gmail connection has been successfully established and authenticated."
  },
  {
    "start": 24,
    "end": 33,
    "text": "Save Gmail Connection",
    "description": "After successful validation, click the 'Save' button to finalize and add the 'Gmail Account Setup' connection to your Infoveave environment."
  }
]

}
  poster="/images/introduction-poster.png"
  posterText="Creating Gmail Connection"
  client:load
/>

## Creating Mailgun Connection

<MediaPlayerComponent
  video="MailginConnection.mp4"
    chapters={
[
  {
    "start": 0,
    "end":4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 4,
    "end": 7,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 7,
    "end": 9,
    "text": "Select Mailgun Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Cloud services' section and click on 'Mailgun' to set up a connection for downloading events and messages from the Mailgun service."
  },
  {
    "start": 9,
    "end": 16,
    "text": "Configure Mailgun Details",
    "description": "In the 'New Connection' dialog box, enter the connection name. Provide your 'Api key' in the designated field and the 'Domain name.'"
  },
  {
    "start": 16,
    "end": 21,
    "text": "Validate Mailgun Connection",
    "description": "Click the 'Validate' button to verify that the provided Mailgun API key and domain name are correct and that Infoveave can successfully connect to the Mailgun service."
  },
  {
    "start": 21,
    "end": 25,
    "text": "Save Mailgun Connection",
    "description": "After the connection is validated successfully, click the 'Save' button to finalize and add the connection to your list of available connections."
  }
]

}
  poster="/images/introduction-poster.png"
  posterText="Creating Mailgun Connection"
  client:load
/>

## Creating MSSQL Connection

<MediaPlayerComponent
  video="MssqlConnection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 4,
    "end": 6,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 6,
    "end": 7,
    "text": "Select Microsoft SQL Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on 'Microsoft SQL' to establish a connection to a Microsoft SQL Server database."
  },
  {
    "start": 7,
    "end": 17,
    "text": "Configure MSSQL Details",
    "description": "In the 'New MicrosoftSql Connection' dialog box, enter the connection name. Keep the 'Port' as '1433' and the 'Server' as 'localhost.' Provide the 'Username,' enter the corresponding 'Password,' and set the 'Database'."
  },
  {
    "start": 17,
    "end": 21,
    "text": "Validate MSSQL Connection",
    "description": "Click the 'Validate' button to confirm that the provided MSSQL server details and credentials are correct and that Infoveave can successfully connect to the database."
  },
  {
    "start": 21,
    "end": 25,
    "text": "Save MSSQL Connection",
    "description": "After the connection validates successfully, click the 'Save' button to finalize and add the 'MSSQL Connection' to your list of available connections."
  }
]


}
  poster="/images/introduction-poster.png"
  posterText="Creating MSSQL Connection"
  client:load
/>

## Creating MySql Connection

<MediaPlayerComponent
  video="MysqlConnection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 4,
    "end": 6,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 6,
    "end": 8,
    "text": "Select MySql Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on 'MySQL' to establish a connection to a MySQL database."
  },
  {
    "start": 8,
    "end": 17,
    "text": "Configure MySql Details",
    "description": "In the 'New Connection' dialog box, enter the connection name. Keep the 'Port' as '3306' and the 'Server' as 'localhost.' Provide the 'Username,' enter the corresponding 'Password,' and set the 'Database'."
  },
  {
    "start": 17,
    "end": 20,
    "text": "Validate MySql Connection",
    "description": "Click the 'Validate' button to confirm that the provided MySQL server details and credentials are correct and that Infoveave can successfully connect to the database."
  },
  {
    "start": 20,
    "end": 24,
    "text": "Save MySql Connection",
    "description": "After the connection validates successfully, click the 'Save' button to finalize and add the connection to your list of available connections."
  }
]
}
  poster="/images/introduction-poster.png"
  posterText="Creating MySql Connection"
  client:load
/>

## Creating Postgres Connection

<MediaPlayerComponent
  video="PostgresConnection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 4,
    "end": 7,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 7,
    "end": 9,
    "text": "Select Postgres Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on 'Postgres' to establish a connection to a PostgreSQL database."
  },
  {
    "start": 9,
    "end": 17,
    "text": "Configure Postgres Details",
    "description": "In the 'New Postgres Connection' dialog box, enter the connection name. Keep the 'Port' as '5432' and the 'Server' as 'localhost.' Provide the 'Username,' enter the corresponding 'Password,' and set the 'Database'."
  },
  {
    "start": 17,
    "end": 20,
    "text": "Validate Postgres Connection",
    "description": "Click the 'Validate' button to confirm that the provided Postgres server details and credentials are correct and that Infoveave can successfully connect to the database."
  },
  {
    "start": 20,
    "end": 25,
    "text": "Save Postgres Connection",
    "description": "After the connection validates successfully, click the 'Save' button to finalize and add the 'Postgres Infoveave' connection to your list of available connections."
  }
]

}
  poster="/images/introduction-poster.png"
  posterText="Creating Postgres Connection"
  client:load
/>

## Creating Datasource Using Custom File Parser

<MediaPlayerComponent
  video="NewCustomFileParser.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 7,
    "text": "Click Datasources under Studio",
    "description": "From the Infoveave menu, click on 'Studio', then select 'Datasources' from the dropdown menu to manage your data connections."
  },
  {
    "start": 7,
    "end": 8,
    "text": "Add New Datasource",
    "description": "Click the 'New Datasource' button located at the top right to initiate the process of adding a new datasource."
  },
  {
    "start": 8,
    "end": 12,
    "text": "Select Custom File Parser",
    "description": "Scroll down through the various options. Under the 'Others' category, select 'Custom file parser' to create a datasource from a file that requires specific parsing logic."
  },
  {
    "start": 12,
    "end": 24,
    "text": "Upload Data File",
    "description": "Click the 'Please select file' area to browse your local machine and upload the data file you wish to parse."
  },
  {
    "start": 24,
    "end": 29,
    "text": "Enter Custom Parse Code",
    "description": "Proceed to the 'File configuration' step. In the provided text area, enter the specific parse code. After entering the code, click 'Next'."
  },
  {
    "start": 29,
    "end": 36,
    "text": "Name Datasource and Table",
    "description": "On the 'Preview' screen, provide a suitable 'Datasource name.' Then, click the 'Edit' icon next to the 'Table name' field to rename the underlying table."
  },
  {
    "start": 36,
    "end": 39,
    "text": "Add Upload Date Column",
    "description": "To include metadata about when the data was ingested, check the 'Add upload date' option. This will add a new column named 'upload_date' to your dataset."
  },
  {
    "start": 39,
    "end": 67,
    "text": "Adjust Column Data Types",
    "description": "Review the automatically detected column types and adjust them as necessary. For all numerical columns, such as 'unitsold,' 'unitcost,' 'unitprice,' 'totalcost,' 'totalprofit,' and 'totalrevenue,' change their 'Column Type' to 'Decimal' to ensure correct numeric processing."
  },
  {
    "start": 67,
    "end": 78,
    "text": "Review and Save Table Schema",
    "description": "Click the 'Edit' icon near the table name to open the 'Edit Table schema' dialog, allowing a final review of all column configurations. Click 'Save' to apply any changes, then click 'Next' to move to the final datasource definition."
  },
  {
    "start": 78,
    "end": 87,
    "text": "Add Measure",
    "description": "On the data source definition page, right-click on the 'unitsold' column from the list of available fields and select 'Add measure.' In the dialog, choose 'Sum' as the aggregation type for this measure, then click 'Add measure' to confirm."
  },
  {
    "start": 87,
    "end": 96,
    "text": "Add Dimensions",
    "description": "Right-click on the 'orderpriority' column and select 'Add dimension.' Click 'Add dimension' in the subsequent dialog box to include 'orderpriority' as a categorical dimension."
  },
  {
    "start": 96,
    "end": 104,
    "text": "Save Datasource",
    "description": "Finally, click the 'Save' button located at the top right of the screen to complete the setup and save your new custom file datasource in Infoveave."
  }
]

    }
  poster="/images/introduction-poster.png"
  posterText="Creating Datasource Using Custom File Parser"
  client:load
/>

## Creating Snowflake Connection

<MediaPlayerComponent
  video="snowflake.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 5,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 5,
    "end": 6,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 6,
    "end": 11,
    "text": "Select Snowflake Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on the 'Snowflake' option."
  },
  {
    "start": 11,
    "end": 26,
    "text": "Configure Snowflake Details",
    "description": "In the 'New Snowflake Connection' dialog, enter the connection details. Type the Name, Server, Username, Password, Database, and the Schema. Ensure the Port is set to '443'."
  },
  {
    "start": 26,
    "end": 30,
    "text": "Validate Snowflake Connection",
    "description": "Click the 'Validate' button to confirm that the provided Snowflake details and credentials are correct and that Infoveave can successfully connect."
  },
  {
    "start": 30,
    "end": 34,
    "text": "Save Snowflake Connection",
    "description": "After the connection validates successfully, click the 'Save' button to finalize and add the 'Postgres Infoveave' connection to your list of available connections."
  }
]
    }
  poster="/images/introduction-poster.png"
  posterText="Creating Snowflake Connection"
  client:load
/>

## Creating Percona Connection

<MediaPlayerComponent
  video="percona-video-2.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 3,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 3,
    "end": 6,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 6,
    "end": 13,
    "text": "Select Percona Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on the 'Percona' option."
  },
  {
    "start": 13,
    "end": 36,
    "text": "Configure Percona Details",
    "description": "In the 'New Percona Connection' dialog, enter the connection details. Type 'Percona Connection' for the Name, 'localhost' for the Server, 'root' for the Username, your password in the Password field, and 'Phoenix' for the Database. Ensure the Port is set to '3306'."
  },
  {
    "start": 36,
    "end": 37,
    "text": "Validate Percona Connection",
    "description": "Click the 'Validate' button to confirm that the provided Percona details and credentials are correct and that Infoveave can successfully connect."
  },
  {
    "start": 37,
    "end": 42,
    "text": "Save Percona Connection",
    "description": "After the connection validates successfully, click the 'Save' button to finalize and add the 'Percona Connection' to your list of available connections."
  }
]
    }
  poster="/images/introduction-poster.png"
  posterText="Creating Percona Connection"
  client:load
/>

## Creating Google Analytics Connection

<MediaPlayerComponent
  video="masked-google-analytics.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 6,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 6,
    "end": 7,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 7,
    "end": 10,
    "text": "Select Google Analytics Connection",
    "description": "In the 'New Connection' window, under the 'Cloud Services' section, click on the 'Google Analytics' option."
  },
  {
    "start": 10,
    "end": 15,
    "text": "Name Google Analytics Connection",
    "description": "In the 'New Google Analytics Connection' dialog, type 'Google Analytics Connection' into the 'Name' field."
  },
  {
    "start": 15,
    "end": 17,
    "text": "Initiate Google Sign-in",
    "description": "Click the 'Sign in with Google' button to proceed with the authentication process in a new window."
  },
  {
    "start": 17,
    "end": 23,
    "text": "Enter Google Account Email",
    "description": "In the Google sign-in window, enter your Google account email, and click 'Next'."
  },
  {
    "start": 23,
    "end": 28,
    "text": "Enter Google Account Password",
    "description": "Enter your Google account password and click 'Next' to continue the sign-in process."
  },
  {
    "start": 28,
    "end": 35,
    "text": "Handle Unverified App Warning & Grant Basic Access",
    "description": "If a 'Google hasn't verified this app' warning appears, click 'Go to infoveave cloud (unsafe)'. Then, on the subsequent screen detailing access, click 'Continue' to allow infoveave.cloud to access basic information about your account."
  },
  {
    "start": 35,
    "end": 39,
    "text": "Grant Google Analytics Data Access",
    "description": "On the permissions screen, ensure 'See and download your Google Analytics data' is selected, and then click 'Continue' to grant specific access to your Google Analytics data."
  },
  {
    "start": 39,
    "end": 56,
    "text": "Validate and Save Connection",
    "description": "Back in the 'Edit Google Analytics Connection' dialog, click 'Validate' to confirm the connection is successful, and then click 'Save' to finalize and add the Google Analytics connection to your Infoveave connections."
  }
]
    }
  poster="/images/introduction-poster.png"
  posterText="Creating Google Analytics Connection"
  client:load
/>

## Creating MariaDB Connection

<MediaPlayerComponent
  video="mariadb.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 4,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 4,
    "end": 8,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 8,
    "end": 18,
    "text": "Select MariaDB Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on the 'MariaDB' option."
  },
  {
    "start": 18,
    "end": 37,
    "text": "Configure MariaDB Details",
    "description": "In the 'New MariaDB Connection' dialog, enter the connection details. Enter the Name, Server, Username, Password , and the Database."
  },
  {
    "start": 37,
    "end": 40,
    "text": "Validate MariaDB Connection",
    "description": "Click the 'Validate' button to verify that your entered MariaDB connection details are correct and establish a successful connection."
  },
  {
    "start": 40,
    "end": 44,
    "text": "Save MariaDB Connection",
    "description": "After the connection validates successfully, click the 'Save' button to create and add the new MariaDB connection to your list of connections."
  }
]
    }
  poster="/images/introduction-poster.png"
  posterText="Creating MariaDB Connection"
  client:load
/>

## Creating Oracle Connection

<MediaPlayerComponent
  video="oracle-connection.mp4"
    chapters={
[
  {
    "start": 0,
    "end": 6,
    "text": "Click Connections under Administration",
    "description": "From the Infoveave menu, click on 'Administration', then select 'Connections' from the dropdown menu to manage your data connections."
  },
  {
    "start": 6,
    "end": 10,
    "text": "Add New Connection",
    "description": "On the 'Connections' page, click the 'New Connections' button located at the top right to open the interface for adding a new datasource connection."
  },
  {
    "start": 10,
    "end": 14,
    "text": "Select Oracle Connection",
    "description": "In the 'New Connection' window, scroll down to the 'Database' section and click on the 'Oracle' option."
  },
  {
    "start": 14,
    "end": 34,
    "text": "Configure Oracle Connection Details",
    "description": "In the 'New Oracle Connection' dialog, enter the connection details. Type 'Oracle Connection' for the Name, 'localhost' for the Server, 'system' for the Username, your password in the Password field, 'FREE' for the Database, and 'SYSTEM' for the Schema. Ensure the Port is set to '1521'."
  },
  {
    "start": 34,
    "end": 36,
    "text": "Validate Oracle Connection",
    "description": "Click the 'Validate' button to verify that your entered Oracle connection details are correct and establish a successful connection."
  },
  {
    "start": 36,
    "end": 39,
    "text": "Save New Oracle Connection",
    "description": "After the connection validates successfully, click the 'Save' button to create and add the new Oracle connection to your list of connections."
  }
]
    }
  poster="/images/introduction-poster.png"
  posterText="Creating Oracle Connection"
  client:load
/>

<RunScript>
  {
    <script>
      document.body.parentNode.removeAttribute('data-has-toc');
      document.documentElement.style.setProperty("--sl-content-width", "60rem");
    </script>
  }
</RunScript>