This one-day QAD end-user advanced report writing training course is designed to showcase the robust charting engine and infographics capabilities of Enterprise Cyberquery. Students should be users of QAD ERP.
To Register call (303)745-3900 X6120 or email training@us.cyberscience.com
Registration closes January 3, 2025
This two-day QAD end-user advanced report writing training course is designed to give experienced Cyberquery users the skills and knowledge needed to effectively develop advanced reports using Cyberquery. Students should be users of QAD ERP.
To Register call (303)745-3900 or email training@us.cyberscience.com
Registration closes January 3, 2025
This two-day QAD end-user report writing training course is designed to give new Cyberquery users the skills and knowledge needed to effectively develop their own reports using Cyberquery. Students should be users of QAD ERP.
To Register call (303)745-3900 or email training@us.cyberscience.com
Registration closes January 3, 2025
by Tom Oldham
Joe McMahon of AmSafe, Inc. spoke with me about how they have benefitted from using Cyberquery and what their employees value most.
“Cyberquery adds value by allowing me to relate, connect and consolidate data within my ERP system that is ordinarily generated across multiple reports.” Patrick Blackstock – Accountant
AmSafe is the global leader in aviation and defense restraints. They manufacture and service safety restraints in 2 factories and 6 services centers for 600 airlines and 40 aircraft manufacturers worldwide. They recently upgraded their ERP system from QAD 2007SE to 2022EE and needed a reporting and data analytics solution.
AmSafe selected Cyberquery for their Daily, Weekly, Period, Monthly Reporting as well as data mining solution. One of the main requirements from the executive team was that reports from QAD 2022EE must include prior history data from their QAD 2007SE database. The QAD2022EE financial module changed the schema completely from 2007SE requiring new mapping. Also, as with other ERP updates, prior history does not get imported into the new ERP system. The Cyberscience consultants were asked to do their magic and consolidate the two systems’ data and build out a financial, sales, and inventory data warehouse. Now the AmSafe teams can run one report instead of two to report across both systems and be able to compare results to prior periods.
Another important feature was the ability for Cyberquery to work with Excel. Many AmSafe employees felt most comfortable working in Excel. Cyberquery has the ability to run queries from Excel and refresh the spreadsheet with the data requested with a simple click.
“Cyberquery makes it so I can get exactly the information I need, in the format I need, when I need it.” Scott Shillito – Procurement Specialist
Cyberquery’s Excel functionality is used throughout the organization. Excel workbooks have been built for department specific roles. The employee selects what parameters they need to review and Cyberquery imports the requested fields. This ability to build queries into Excel has made decision making much easier. Scott in procurement highlighted, “now I have reports that can be refreshed whenever I want, or need, to make a decision.”
As supplier to the aerospace and defense industries, AmSafe must comply with numerous codes and perform audits. They follow the highest standards and regulations in the aviation industry, such as AS9100, ISO 9001, and FAA Part 145. The team has automated a number of standard audit requests using Cyberquery and schedule the reports using QDirector.
AmSafe values the expertise of the Cyberscience Professional Services Group. The depth of knowledge of the ERP database and standard reporting requirements of a manufacturer exceeded their expectations. They were also impressed by the speed of response from the team. These qualities they said has made Cyberscience one of their best business partners.
Just like AmSafe, manufacturers should look to solutions that enable a comprehensive view – quote to cash – to give team members the information they need for better decision-making. By adopting a powerful BI solution like Cyberquery, your manufacturing and repair facilities can enter a new era of informed decisions.
AmSafe Inc. is the undisputed world leader in the design and manufacture of restraint systems for use in all fields of aviation and defense. The company has designed and manufactured millions of seatbelts, airbag systems, multipoint restraints and other products that help move millions of people safely and securely in the air.
If you have a need for a new business intelligence solution that provides benefits as Joe describes, contact Cyberscience for a demo or test drive. – info@cyberscience.com
Author: Tom Oldham, Product Manager – Manufacturing Solutions
by Rob Little
Bob Templeton of John B. Sanfilippo & Son, Inc. spoke with me about implementing Cyberquery and the benefits.
“Cyberquery has empowered our ERP user community to access
information easily while enabling IT to provide more value-added services.”
Manufacturing organizations are under increasing pressure to provide users with easy-to-use analytical reporting tools. Faced with this challenge, John B. Sanfilippo & Son, Inc, headquarted in Elgin, IL, selected Cyberquery as their corporate business intelligence and report writing solution.
Bob Templeton, Senior Programmer/Analyst at JBSS stated, “The reports that come with the ERP application do not satisfy everyone’s individual needs. Users required more analytical reporting, and every request required costly programming intervention. This created a large backlog of requests and pulled resources away from other, sometimes more critical projects.”
Templeton went on to say, “Our return on our Cyberquery investment has been significant. The savings are substantial because users are now creating their own reports and data exports, freeing up IT resources to focus on more critical issues. Cyberquery has conservatively saved one third of my time, if not more, by eliminating 15-20 hours of analysis and programming per week.”
One of the many successful uses of Cyberquery at JBSS is creating charts and graphs that analyze production efficiency. These graphs are designed to measure machine, department and shift efficiencies and are posted on the shop floor weekly.
“With the use of Cyberquery data visualization functionality we are able to better analyze and present our data.”
“We make business decisions faster due to the availability of timely, accurate and accessible information. The efficiency reports we created allow us to quickly identify gaps in production and act on them immediately.”
“One of the biggest selling points of Cyberquery is how easy it is to use” stated Templeton. “With a little logical thinking a user can sit down and pick it up very easily on their own. We have end users across all functional areas of our organization creating their own reports. Some of these areas include Production, Accounting, A/P, A/R, Inventory Management and Customer Service.”
“The level of service Cyberscience provides is excellent” added Templeton. “The product really doesn’t require much support, and upgrades have been a breeze.”
JBSS’s requirements are not unique; many organizations today are facing increasing pressure to supply critical information to those who need it. By using Cyberquery, organizations can have the information they need to gain useful business insight.
John B. Sanfilippo & Son, Inc. (JBSS) is an in-house sheller, processor, packager, marketer, and distributor of shelled and in-shell nuts and was founded in Chicago in 1922 by Gaspare Filippo and his son John. Today the company’s main production and distribution facility is in the Chicago suburb of Elgin, Illinois. JBSS sells its products under a variety of private labels and under the company’s Fisher, Evon’s, Flavor Tree, Sunshine Country and Texas Pride brand names. The company also markets, distributes, and manufactures or processes a diverse product line of food and snack items including peanut butter, candy, natural snacks and trail mixes.
If you have a need for a new business intelligence solution that provides benefits as Bob describes, contact Cyberscience for a demo or test drive. – info@cyberscience.com.
Author: Rob Little is a Cyberquery Consultant.
Recent Comments