QI Macros SPC Add-in for Excel Features

Data quality consists of deduplication, cleansing, and appending your marketing database.

Allows users to select samples of data for defined procedures.

Share data across your organization.

Allows users to manage data from a number of sources

Receive data and information in real time

Statistical methods to assist with and maintain quality control of processes

Communicate complex information clearly and effectively through advanced graphical techniques.

Supports evaluation of durations, events, and reliability in relation to statistical analysis

Identify risk data attributes such as description, category, owner, or hierarchy.

Tools to analyze financial data in order to gain usable insights.

Analysis of data sets that contain more than one variable

Provides varying estimates based on different scenarios

Apply statistical/mathematical models to sets of data

A statistical method, based on Bayesian inference, that expresses unknown parameters as probability statements

Review data from past periods to reveal recurring tendencies and predict future performance

Analysis to understand which of the independent variables are related to the dependent variable

Supports analysis of variance (ANOVA) to determine observed variance.

Supports various regression methods such as ordinary least squares (OLS), weighted least squares (WLS), or generalized linear model (GLM).

Supports the analysis of time series data for predictive analytics and exploratory analysis.

Allows users to generate text based on a text prompt.

Condenses long documents or text into a brief summary.

Use AI to generate content in the form of text, images, videos, etc.

Generate production schedules based on demand and inventory availability

Create work orders and dispatch them based on availability of personnel and work stations.

Deploy work orders on the shop floor to personnel and equipment.

Automatically create schedules based on business needs or employee availability and qualifications

Schedule predetermined or ad hoc maintenance services and labor requests

Track the movement of raw materials and components between the warehouse and the shop floor.

Implement quality control checks to comply with industry standards and regulations.

Monitor work orders execution to identify non conformity with scheduling.

Identify and assess hazards to ensure the well-being of employees, assets, and the environment

Material list of manufacturing parts and associated costs

Analyze production operations to identify bottlenecks and opportunities for improvement.

Allow for bidirectional data transfers between the software and industrial equipment.

Manage documents related to production and quality such as engineering drawings.

Gather manufacturing data from multiple sources (software, equipment, and sensors).

Allow for bidirectional data transfers between the software and industrial equipment.

Integrate with other manufacturing solutions such as ERP, quality management and asset management.

Synchronize manufacturing data with IoT networks and devices.

Use machine learning to predict production output or equipment downtime.

Identify deviations from optimal performance and recommend corrective actions in real-time.

Generate intelligent production plans that can adapt to changes in real time.

Active monitoring of systems, applications, or networks

Works across multiple software systems or databases

Set up connections to third-party platforms to improve business processes

Track and report regulatory data to either internal management or external stakeholders

Active reporting of data and metrics

Assess the performance of a method by picking a random sample from a normal distribution

Form predictions based on past and present data/trends

A classification and/or predictive modeling technique used for data analysis

Interact with data visualization elements, such as charts and graphs, to drill down into data

Define levels of authorization for access to specific files or systems

Connect to big data sources

Alter the layout and content of reports

Assemble applications and processes by dragging over and arranging pre-built components

Access, combine, transform, and store data without the help of an IT department

A set of indicators that tracks the performance of networks, applications, systems, teams, etc.

Translate EDI formats into data suitable for use with company applications.

Dashboard to view the status of ongoing processes, identify current incidents and track past activities

Automatically retrieve and pull information from documents, websites, images, data sets, and other sources

View and track pertinent metrics to find patterns and gain insights from data

Predict future data based on historical data sets

Application programming interface that allows for integration with other systems/databases

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

Machine learning method, based on rules, to find interesting relationships between variables in large databases

Generate one-off reports that meet information requirements

Collection, analysis, and representation of numerical data and generation of reports to understand various patterns

Set up connections to third-party platforms to improve business processes

Create labels for products that contain required information such as colors, sizes, dates, etc.

Search and filter data across systems to locate required information by entering keywords or certain criteria

Observe and track the demand, usage, progress or quality of a system, product, or user

Clustering or grouping objects based on data similarities

Import and export data to and from software applications

Security protocol that ensures secure, encrypted communication over the internet, safeguarding sensitive data from unauthorized access

Store and access documents, forms, and photos in one centralized place

Support tool that enables users to progress through a series of steps to solve a problem

Create multiple models or equations for generating scores

Dashboard to view the status of ongoing processes, identify current incidents and track past activities

Manage and control operations that take place on the shop floor or factory floor

Generate quotes or estimates for customers

Track and monitor inventory items, such as raw materials, unfinished goods, and ready-to-sell items

Assign available resources to various projects and tasks

Focuses on improving processes by collecting data and spotting bottlenecks or other challenges.

Accounting functionality within the system, not requiring integration with third-party tools

Manage all supplier data and operations

Create, send, and track purchase orders and their statuses

Collection, analysis, and representation of numerical data and generation of reports to understand various patterns

Create, design and manage workflows for repetitive tasks

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

Store, manage, and track all electronic documents in a centralized location

Import product information from third party sites or create your own, adjust descriptions and make other changes as required

Plan and coordinate all the resources, costs and time needed to execute assignments

Graphical representation of data

Manage the planning and execution of supply chain activities

Manage and track orders being shipped to customers

Create, manage and track all task activities and progression

Manage and support multiple locations

Use AI to generate content in the form of text, images, videos, etc.

A set of indicators that tracks the performance of networks, applications, systems, teams, etc.

Manage and track customer orders for goods, investments, or any other purchases

Process of gathering, measuring, and analyzing accurate data

Track and manage adherence to policies for any service, product, process, or supplier

Search and filter data across systems to locate required information by entering keywords or certain criteria

Import and export data to and from software applications

Scan barcodes to ensure accurate pricing and label tracking

Process to track, record, and analyze expenses that occurred over the entire duration of a given project

Form predictions based on past and present data/trends

Estimate expected cost based on various factors before a project begins

Application programming interface that allows for integration with other systems/databases

Track and manage inventory levels to maintain proper supply

Manage the end-to-end production process for manufacturing operations

Manage and track operations and inventory within warehouses

Route documents and other data through one or more stakeholders for review and approval

Import and export data to and from software applications

Discover patch statuses and vulnerabilities

Provides a channel for team members to share media files, communicate, and work together

Receive data and information in real time

Process of identifying, evaluating, mitigating, addressing and reporting on potential risks or uncertainties

Monitor product stock levels

Estimate expected cost based on various factors before a project begins

Scan barcodes to ensure accurate pricing and label tracking

Track parts inventory levels and manage re-stocking

Identify and track items using barcode tags or RFID (radio-frequency identification) tags

Creating, assign, and track jobs and/or tasks for work orders

Ensure that quality requirements and standards are met across production processes

Form predictions based on past and present data/trends

Use AI to generate content in the form of text, images, videos, etc.

Manage the end-to-end production process for manufacturing operations

A virtual assistant that uses AI to pursue goals and complete tasks on behalf of users

An organized inventory of all data assets

Addition of necessary external data, applications, tools, or features

Collection, analysis, and representation of numerical data and generation of reports to understand various patterns

Process to track, record, and analyze expenses that occurred over the entire duration of a given project

Create, manage, and share one level of an assembly with the entire product team

Store, manage, and track all electronic documents in a centralized location

Also known as indented BOM, a hierarchical representation of components, assemblies, and subassemblies needed to manufacture a product

Search and filter data across systems to locate required information by entering keywords or certain criteria

Track and monitor efficient handling of all changes/transitions

Calculate rule-based prices for a product/service

The process of identifying, quantifying, and prioritizing the vulnerabilities in a system.

Dashboard to view the status of ongoing processes, identify current incidents and track past activities

Capture, organize and track product-specific data and information in a centralized location

Track and manage adherence to policies for any service, product, process, or supplier

Application programming interface that allows for integration with other systems/databases

A record of all activities within the system, including user access, changes made, etc.

Collect, organize, and track inventory/product data including item numbers, descriptions, etc.

Create, send, and track purchase orders and their statuses

Customize data fields to support various needs and use cases

Manage and handle various international currencies

Enables creation, management, and tracking of product requirements & features during product production/development

Create bills of materials

Manage and support multiple locations

Information to prevent, understand and identify cyber threats

Active reporting of data and metrics

Track and monitor inventory items, such as raw materials, unfinished goods, and ready-to-sell items

Analyze and gain insights into data in real-time

Manage and track orders being shipped to customers

Manage the planning and execution of supply chain activities

Create, design and manage workflows for repetitive tasks

Material list of manufacturing parts and associated costs

Integrate with a third-party accounting system

Generate quotes or estimates for customers

Manage and track customer orders for goods, investments, or any other purchases

Automatically create schedules based on business needs or employee availability and qualifications

Built-in accounting to manage ledger, accounts payable/receivable, financial reports, etc.

Track and manage inventory levels to maintain proper supply

Identify and assess hazards to ensure the well-being of employees, assets, and the environment

View and track pertinent metrics to find patterns and gain insights from data

Calculate total itemized costs, including initial costs and any changes

Focuses on improving processes by collecting data and spotting bottlenecks or other challenges.

An order generated by a seller to a customer, containing details about products or services

Financial management for all distribution-related activities, including inventory, warehouse, purchasing, sales, etc.

Plan and schedule the use of production resources

Manage inventory, communication, marketing, orders & more across warehouses, stores and online channels

Plan, manage, and track the financial activities of an individual or organization

Manage all supplier data and operations

Manage, maintain and track the performance of assets and equipment

Track the production of materials and items over certain periods or seasons

Track the status over time for a request, process, asset, or transaction

Manage and track operations and inventory within warehouses

Track and document the history, application, or location of an item or activity

Observe and track the demand, usage, progress or quality of a system, product, or user

Create, manage, and send invoices or bills to customers

Maintain and control the stock level of inventory

Plan and coordinate all the resources, costs and time needed to execute assignments

Active monitoring of systems, applications, or networks

Investigate and take action at root cause or error in processes to prevent recurring issues

Graphical representation of data

Apply statistical/mathematical models to sets of data

A set of indicators that tracks the performance of networks, applications, systems, teams, etc.

Manage and track all job information and associated tasks

Create labels for products that contain required information such as colors, sizes, dates, etc.

Statistical methods to assist with and maintain quality control of processes

Notifications that are delivered to users as soon as an event occurs

Intended to be used by manufacturers

Ability to handle large datasets

Collating information from different sources in order to create a more valuable and helpful data set.

Alter the layout and content of reports

The process of entering information or updating records in a computer system or database

Plan availability and assign specific time slots for tasks and resources

Import, collect, and capture data from multiple sources

Securely stores data to prevent data loss or breaches

Review data from past periods to reveal recurring tendencies and predict future performance

Process of tracking logged defects (errors) in a product or service to create new versions to fix the error

Set up connections to third-party platforms to improve business processes

Interact with data visualization elements, such as charts and graphs, to drill down into data