Method for seamless connection of functional tools to publish a business intelligence dashboard

A system of a telecommunications network for publishing a Business Intelligence (BI) dashboard that includes a status of a project of a service provider of the telecommunications network, the system comprising:

• at least one hardware processor;
• and
• at least one non-transitory memory storing instructions, which, when executed by the at least one hardware processor, cause the system to:
• initiate a first computer script stored in a non-transitory, computer-readable storage medium,
• wherein the first computer script is configured to query at least one database of a software defect-tracking tool regarding a status of a software defect, and
• wherein the first computer script is configured to export a result of the query to a spreadsheet;
• process, using at least one spreadsheet formula, a first Visual Basic Application (VBA) macro, a second computer script, or any combination thereof, the result of the query exported to the spreadsheet,
• wherein processing the result of the query exported to the spreadsheet includes representing the result as at least one table, at least one chart, at least one graph, or any combination thereof;
• create at least one BI dashboard,
• wherein creating the at least one BI dashboard comprises initiating at least a second VBA macro stored in a non-transitory, computer-readable storage medium,
• wherein the at least a second VBA macro is configured to open a template of a slide presentation and enter the at least one table, at least one chart, at least one graph, or any combination thereof into at least one slide of the presentation,
• wherein the at least a second VBA macro is configured to predict a future status of a project of the telecommunications network by performing a predictive analysis,
• wherein performing the predictive analysis comprises creating a software defect burndown chart,
• wherein creating the software defect burndown chart comprises calculating a rate at which software defects were resolved in at least one preceding month and dividing a sum of a count of remaining software defects and a count of new software defects created in a current month by the calculated rate,
• wherein the at least a second VBA macro is configured to initiate at least a third VBA macro, and
• wherein the at least a third VBA macro is configured to save the at least one BI dashboard to a non-transitory, computer-readable storage medium;
• publish the at least one BI dashboard,
• wherein publishing the at least one BI dashboard comprises initiating at least a fourth VBA macro,
• wherein the at least a fourth VBA macro is configured to compose at least one email based on an email template and include the at least one BI dashboard as at least one attachment in the email, and
• wherein the at least a fourth VBA macro is configured to send the email to at least one recipient.

A non-transitory, computer-readable storage medium comprising instructions recorded thereon, wherein the instructions, when executed by at least one data processor of a system of a telecommunications network, cause the system to:

• initiate a first computer script stored in a non-transitory, computer-readable storage medium,
• wherein the first computer script is configured to query at least one database of a software defect-tracking tool regarding a status of a software defect, and
• wherein the first computer script is configured to export a result of the query to a spreadsheet;
• process the result of the query exported to the spreadsheet,
• wherein processing the result of the query exported to the spreadsheet includes representing the result as at least one table, at least one chart, at least one graph, or any combination thereof;
• create at least one Business Intelligence (BI) dashboard,
• wherein creating the at least one BI dashboard comprises initiating at least a second computer script stored in a non-transitory, computer-readable storage medium,
• wherein the at least a second computer script is configured to open a template of a slide presentation and enter the at least one table, at least one chart, at least one graph, or any combination thereof into at least one slide of the presentation,
• wherein the at least a second computer script is configured to predict a future status of a project of the telecommunications network by performing a predictive analysis,
• wherein performing the predictive analysis comprises creating a software defect burndown chart,
• wherein creating the software defect burndown chart comprises calculating a rate at which software defects were resolved in at least one preceding month and dividing a sum of a count of remaining software defects and a count of new software defects created in a current month by the calculated rate,
• wherein the at least a second computer script is configured to initiate at least a third computer script, and
• wherein the at least a third computer script is configured to save the at least one BI dashboard to a non-transitory, computer-readable storage medium;
• publish the at least one BI dashboard,
• wherein publishing the at least one BI dashboard comprises initiating at least a fourth computer script,
• wherein the at least a fourth computer script is configured to compose at least one email based on an email template and include the at least one BI dashboard as at least one attachment in the email, and
• wherein the at least a fourth computer script is configured to send the email to at least one recipient.