InetSoft Product How-To: Creating Report Scorecards

InetSoft's reporting software allows users to create report scorecards with the purpose of key metric monitoring in real-time. View the information below to learn more about the Style Intelligence solution.

A scorecard is used to keep track of certain parameters (e.g., Sales Revenue). Multiple users can monitor these parameters from the Report Portal. These parameters (metrics) can also be measured at regular intervals (triggers).

They can be checked against certain conditions (thresholds, time comparisons, custom business logic etc.) to which they must comply. If they don't, specified actions can be automatically taken (email notifications, etc.). The metric, trigger, conditions and other settings are collectively handled as a target. A scorecard is thus a collection of one or more targets.

The following are the basic steps involved in setting up a scorecard. (Each step is explained in detail in the following sections).

Note: The Scheduler must be running in order to use score­cards.

Reporting Dashboard Example
View 2-min Dashboard Demo
Register for Pricing
#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More

1. Create a data asset in the data worksheet, which retrieves the data to be monitored.

2. Create a metric: Specify one of the numeric fields in the asset as the metric.

3. Assign a detail report for the metric.

4. Create a target based on this metric.

5. Specify a trigger for the target. A trigger specifies when the metric is evaluated. A custom trigger can be also added to the system.

6. Specify a condition, which can be a threshold, time based compari­son, or custom script function.

7. Specify an action, such as notification email, print, save to disk, etc.

8. Specify permissions to this target and publish the target to different users.

9. Add more metrics and targets to your scorecard as desired.

Note: Targets can be created by the end user as well as by an administrator. Metrics can only be created by an administrator.

Case Study: SolarNext - Leveraging Report Scorecards for Performance Improvement in Photovoltaics Manufacturing

SolarNext is a leading manufacturer of photovoltaic (PV) panels, specializing in producing high-efficiency solar cells for residential, commercial, and industrial use. Founded in 2005, the company has grown significantly, expanding its operations globally. SolarNext prides itself on innovation, sustainability, and quality, aiming to provide affordable solar energy solutions to help combat climate change.

Despite its success, SolarNext faced challenges related to maintaining operational efficiency, managing quality control, and ensuring timely delivery amid increasing competition and a rapidly evolving market. To address these challenges, the company decided to implement report scorecards as part of its performance management strategy. This case study explores how SolarNext used report scorecards to optimize its manufacturing processes, improve quality control, and enhance overall business performance.

Challenges Faced by SolarNext

  1. Operational Efficiency: SolarNext struggled with maintaining consistent production levels, leading to delays in fulfilling orders. The company needed a way to monitor and optimize its manufacturing processes.

  2. Quality Control: As SolarNext expanded, maintaining high-quality standards across multiple production facilities became increasingly challenging. Defects in photovoltaic panels could result in significant losses and damage to the company's reputation.

  3. Supply Chain Management: Managing the supply chain for raw materials, especially silicon, a key component in PV panels, became more complex as the company scaled up. Delays in the supply chain led to production bottlenecks and delayed deliveries.

  4. Environmental Compliance: As a company committed to sustainability, SolarNext needed to track its environmental impact, including energy consumption, waste management, and carbon footprint.

  5. Financial Performance: SolarNext needed to ensure profitability while investing in new technologies and expanding its production capacity. Keeping track of financial metrics was essential for making informed business decisions.

Solution: Implementation of Report Scorecards

To address these challenges, SolarNext implemented report scorecards across its operations. These scorecards provided a visual representation of key performance indicators (KPIs) and metrics, allowing managers to monitor performance in real-time and make data-driven decisions. The scorecards were customized to track various aspects of the company's operations, including manufacturing efficiency, quality control, supply chain management, environmental impact, and financial performance.

Key Performance Indicators (KPIs) Tracked

  1. Manufacturing Efficiency

    • KPI: Production Throughput: The number of photovoltaic panels produced per hour.
    • KPI: Downtime Percentage: The percentage of time the production line is idle.
    • KPI: Overall Equipment Effectiveness (OEE): A measure of how well manufacturing equipment is performing, considering availability, performance, and quality.

  2. Quality Control

    • KPI: Defect Rate: The percentage of photovoltaic panels that fail quality checks.
    • KPI: First Pass Yield (FPY): The percentage of products that pass quality inspection the first time without requiring rework.
    • KPI: Customer Returns: The number of photovoltaic panels returned by customers due to defects or other issues.

  3. Supply Chain Management

    • KPI: On-Time Delivery Rate: The percentage of orders delivered on time to customers.
    • KPI: Lead Time for Raw Materials: The time taken to receive raw materials from suppliers.
    • KPI: Inventory Turnover Ratio: A measure of how efficiently inventory is used and replenished.

  4. Environmental Impact

    • KPI: Energy Consumption: The amount of energy consumed per unit of production.
    • KPI: Waste Reduction: The percentage reduction in waste generated during production.
    • KPI: Carbon Emissions: The total carbon emissions produced by the manufacturing process.

  5. Financial Performance

    • KPI: Gross Profit Margin: The percentage of revenue that exceeds the cost of goods sold (COGS).
    • KPI: Return on Investment (ROI): The profitability of investments in new technology and equipment.
    • KPI: Cost per Unit: The total cost of producing one photovoltaic panel.

Implementation Process

SolarNext began by identifying the key areas that required improvement. The company's leadership team collaborated with department heads to define relevant KPIs for each area. Once the KPIs were established, SolarNext implemented report scorecards across its production facilities and administrative offices. The scorecards were integrated into the company's existing enterprise resource planning (ERP) and manufacturing execution systems (MES), allowing real-time data to be captured and displayed on dashboards.

Benefits of Using Report Scorecards

  1. Improved Operational Efficiency: By tracking production throughput, downtime percentage, and OEE, SolarNext identified bottlenecks and inefficiencies in its manufacturing processes. For example, the company discovered that one of its production lines had a significantly higher downtime percentage than others. By addressing this issue through maintenance and training, SolarNext was able to reduce downtime and increase overall production.

  2. Enhanced Quality Control: The defect rate and FPY KPIs enabled SolarNext to pinpoint areas where quality issues were occurring. By focusing on these areas, the company reduced its defect rate and improved its FPY. Additionally, tracking customer returns helped SolarNext identify and rectify issues before they became widespread, leading to higher customer satisfaction.

  3. Optimized Supply Chain Management: The on-time delivery rate and lead time for raw materials KPIs allowed SolarNext to better manage its supply chain. The company worked closely with suppliers to reduce lead times and implemented just-in-time inventory practices, improving its inventory turnover ratio and ensuring timely delivery to customers.

  4. Reduced Environmental Impact: SolarNext's commitment to sustainability was reinforced by tracking energy consumption, waste reduction, and carbon emissions. The company implemented energy-saving initiatives and waste reduction programs, resulting in a smaller carbon footprint and improved compliance with environmental regulations.

  5. Increased Financial Performance: By monitoring financial KPIs such as gross profit margin, ROI, and cost per unit, SolarNext was able to make informed decisions about pricing, investments, and cost management. The company's focus on efficiency and quality led to lower production costs and higher profitability.

Challenges Encountered

While the implementation of report scorecards brought significant benefits, SolarNext faced some challenges during the process:

  • Data Integration: Integrating data from multiple sources into the scorecards required significant effort. SolarNext had to ensure that data from its ERP, MES, and other systems were accurately captured and displayed on the scorecards.

  • Change Management: The introduction of scorecards required a cultural shift within the organization. Employees needed to adapt to the new system and understand the importance of the KPIs being tracked. SolarNext addressed this challenge through training and communication, ensuring that all employees were on board with the new approach.

  • Continuous Improvement: SolarNext recognized that the implementation of report scorecards was not a one-time effort. The company needed to continuously refine its KPIs and scorecards to adapt to changing business conditions and maintain its competitive edge.

Results and Outcomes

The implementation of report scorecards had a transformative impact on SolarNext's operations:

  • Production throughput increased by 15% due to improved operational efficiency and reduced downtime.
  • The defect rate decreased by 20%, leading to higher quality products and fewer customer returns.
  • On-time delivery rate improved by 10%, resulting in better customer satisfaction and stronger relationships with clients.
  • Energy consumption per unit of production decreased by 12%, contributing to SolarNext's sustainability goals and reducing operational costs.
  • Gross profit margin increased by 8% as a result of lower production costs and better financial management.
Previous: Balanced Scorecard for Reports
We will help you get started Contact us