Archive

Archive for November, 2009

Editorial – Oct 2009

November 4th, 2009
Welcome to the October Edition of BI Insight! This month’s newsletter highlights Systech’s project success in “Store and Merchandising Analysis” for a leading specialty retailer of premium pet food and supply stores. In this case study you would see how a customer achieved an insight into sales & margins through Systech’s store analysis. The ‘Systech corner’ article features a report on Operational BI. This whitepaper includes an in-depth report on Operational BI. The main aim of this paper is to introduce the reader to “Operational Business Intelligence” and make him familiar with the characteristics and capabilities of Operational BI. And of course, this issue also includes BI news articles from reputed sources. We hope that you find the newsletter to be a valuable resource and we encourage you to share it with your peers!

Editor's Note

A white paper: Operational BI

November 4th, 2009

Operational BI represents one of the fastest growing areas of business intelligence. It has the potential to inflate the benefits of BI usage throughout the organization to a user audience that has been unable to benefit from BI technology. It can provide noteworthy benefits, however operational BI must be implemented carefully. It requires a sound and robust underlying infrastructure and database processing environment.

It is important to remember, that most operational BI applications do not call for close to real-time operations, and to facilitate most users would be quite happy if action times can break the 24-hour barrier and help them make intra-day decisions.

Hence a well selected operational BI project will perk up the responsiveness of the organization, whereas at the same time it will also deliver measurable results that produce a sound return on investment.

Register here to request the white paper.

Systech Corner , , , , , , , ,

Store and Merchandising Analysis

November 4th, 2009

Background

In this case study we describe how a leading provider of specialty retailer of premium pet food and supply stores, achieved enhanced sales, improved margins and better tracking of products and services and through Systech’s Business analytical solution for Retail Industry – Store Analysis, Merchandising Analysis, Promotion Analysis, Market Basket Analysis and Vendor Management .

The client needed a solution that would make it possible for them to obtain company information in a quick and accurate manner. They needed a store analysis to get an in-depth look at the sales & margins section among store contribution and the base stores performance for a two year period. They also wanted to access inventory levels at all times in order to accommodate customers with the appropriate products and services offered.

Challenges

Identification of store uniqueness was needed to allow for pricing and store assortment for proper product placement and sale. A suitable solution needed to be put into practice in order to properly target their market and track down customers to evaluate their specific buying habits. Promotional, product and vendor divisions also needed to be analyzed to gain full interpretation of the business.

Solution

Systech delivered an enterprise Business Intelligence solution, which aided ad-hoc detail merchandising and allowed reporting of data based on specific merchandising units and also in overall store analysis across all reporting components. The primary platform and framework was built for the data warehouse to completely function.

Another important solution that Systech implemented was Market Basket Analysis which helped the client understand their customer’s buying habits and enabled them to implement suitable cross-sell and up-sell to their customers.

Result

The solution enabled the client to perform effective store and merchandising analysis. This resulted in better tracking of products and services. The vendor management helped to evaluate vendor performances and helped them to identify vendors who gave better and faster service. This also allowed the client to have all the necessary products in stock to provide better customer service. Promotional Analysis effectively helped the client enhance their sales and improve their margins.

Featured Article , , , , , , , , , , , , ,

Industry News – Oct 2009

November 4th, 2009

Systech Solutions’ CFO nominated for best CFO Awards in San Fernando Valley’s Business Journal

Ashish Parikh, Chief Financial Officer for Systech Solutions Inc. was nominated for the best CFO Award in San Fernando Valley Business Journal.

San Fernando Valley Business Journal recognized the region’s financial professionals for their outstanding performance as company’s financial stewards. This annual event also recognized the importance of financial executives in the region who positively impact the business community.

Click to see Ashish’s profile.

Systech Solutions Inc. was twice awarded the fastest growing company in the region by San Fernando Valley Business Journal previously in 2001 and 2006.

Fashion Institute of Design & Merchandising Selects Talend and Smart i to Enhance Business Intelligence Capabilities

Talend today announced that the Fashion Institute of Design & Merchandising(FIDM), a private college dedicated to educating students for careers in fashion, graphics, interior design and entertainment industries, has chosen the

Smart i Appliance-powered by Talend Integration Suite’s Extract, Transform, Load (ETL) tool-to boost its business intelligence (BI) capabilities. The Smart i Appliance, collaboration between Talend, Key Information Systems, Systech Solutions and IBM, is a plug-and-play BI appliance based on IBM’s System I (AS/400) platform. Under the terms of the agreement, FIDM uses Talend’s transformation components-such as mapping, normalizing, sorting and aggregating-to cleanse, transform and load data into a new data warehouse.

“FIDM executives need to access up-to-date, reliable data from our systems to be able to make key business decisions,” said Roxanne Reynolds-Lair, chief information officer, FIDM. “Talend’s tool within the Smart i Appliance expedited our ETL processing, making it two to three times faster than before. This is a huge benefit for us, and it enables our team to retrieve accurate, timely reports that make a significant business impact.” FIDM’s previous ETL tool often experienced failed data transitions, proving it to be unreliable, leaving the organization’s CFO with day-old data and manual calculations. In addition, the support for the solution was lacking due to the vendor’s overseas location. When FIDM needed to expand its BI reporting functionality and make data processes more efficient, it turned to the Smart i Appliance, which includes Talend’s ETL tool running native on the IBM i. FIDM uses Talend to extract and load data as well as integrate all Talend jobs and control the overall data process flow. With Talend, FIDM’s BI reports are available much earlier, without any manual interface. In turn, updated information gathered through the system provides executives with accurate and timely reports, enabling them to make better informed business decisions.

“We are very excited to work with FIDM on its Smart i project. It truly leverages the benefits of Talend Integration Suite-an open, user-friendly solution that can make data processes more efficient for the leading fashion institution,” said Vincent Pineau, Talend’s vice president and general manager, Americas. “Organizations such as FIDM need consistent information in order to make strategic decisions. This is another example of how companies across any vertical industry can benefit from a scalable, cost-effective and enterprise-class data integration platform such as Talend.”

For implementation of the Smart i Appliance, FIDM relies on Systech Solutions, a business intelligence solutions provider and Talend partner. Systech, one of the leading U.S. professional services firms delivering customer-focused business intelligence solutions, entered a strategic partnership within the Talend

Alliance Program in early 2008. As a part of the agreement, Systech leverages Talend’s software to help develop and implement robust solutions for clients with extensive data integration needs.

Click learn more about Smart i

How Mobile Devices Change BI

The marriage of business intelligence to smartphones, mobile Internet devices (MIDs), netbooks, and other devices smaller than laptops will enable the industry to play an even greater role in how organizations handle their data. At the same time, however, mobilization of BI in general (and on small form factor devices in particular) raises key challenges and even forces a rethinking of precisely what BI is.

Mobilization to small devices changes BI in two ways: Sending large volumes of BI data to and from the field suggests that a broader range of employees are using BI, and these road warriors almost certainly have different job descriptions and responsibilities than the traditional “stationary” consumers of BI.

Although the democratization of BI benefits the enterprise, there is a contradictory reality in how this actually gets done. BI is data-intensive, but the mobile environment, even in the age of 3G and 4G networks, is based on scarce resources. Mobile networks pass data more slowly than corporate LANs. The spigot sporadically is turned off entirely. Even more significantly, smartphones, MIDs, and related devices have tiny screens. Throw in lower processing power and less memory than desktops and a world of challenges – and vendor opportunities – are born.

The importance of the trend even goes beyond the mobilization itself. Mobile devices serve as a conduit through which BI, in a general sense, more completely permeates the enterprise. “Research I conducted shows that companies both large and small are looking for ways to deliver BI and analytical functionality to more functions in their organizations and more roles in each function,” says Mike Lock, a research analyst for BI at the Aberdeen Group.

Santiago Becerra, the chairman of MeLLmo Inc., says that adjustments are necessary on three fronts: The user interface (i.e., the screen and how the user interacts with it), the backend infrastructure, and the connectivity between the two. MeLLmo offers a family of applications that bring BI to Apple’s iPhone.

The three are interrelated. For instance, data must be organized at the backend and sent in a manner that is optimal for devices’ limited horsepower, storage, and small display. This involves changes to every leg of the stool. Ways must be found to trim the transmission to the salient data. Because connectivity is not guaranteed, the system must be able to store necessary data and allow field forces to work offline and accomplish goals even in the absence of connectivity. New and creative ways must be found to display data and let users interact with it.

Mobile BI systems also must integrate with traditional functions found in mobile environments. For instance, the system must be designed to alert end users of updates through a variety of multimedia tools. In addition, mobilized employees are likely to be more action oriented and be dealing with issues that require immediate attention from different members inside and outside the organization, many of whom likely will be mobilized as well. Thus, there is a nascent tie between mobile BI and mobile unified communications.

Becerra says that the emphasis on action means that operational data that now often bypasses the BI platform must be routed through it. “In addition to delivering information, organizations are going to have to expand the system and create an interface for more operational BI for the rest of the organization,” he says. “This is a blurring a little bit of the traditional line between what is considered BI and what is reporting. Most of the information in companies ironically doesn’t flow through the BI system. The distribution of those reports typically is done in simple formats like .pdfs and Excel.”

Clearly, truly mobilizing BI involves far more fundamental changes than putting a new front-end on existing platforms. However, a complete change-out of existing systems – a “rip and replace” scenario – isn’t likely for those firms with substantial platforms in place. Conversely, it is important that companies just getting serious about BI plan their infrastructures with mobility in mind.

The bottom line is that the advent of small mobile devices is an important step in the evolution of BI, and incremental changes must be made to accommodate the new approach. “We are entering a whole new world,” Becerra says.

Healthcare Providers Expect IT to Improve Patient Care-Not Just Business, CompTIA Survey Finds

Healthcare providers realize that new technologies have to be adopted to improve their business, but the medical benefits of technology also are clearly in their sights, according to CompTIA’s Healthcare IT Market: Insights and Opportunities study.

The CompTIA study finds that 59 percent of healthcare providers are somewhat to very excited about the prospect of telemedicine and 79 percent are interested in portable tablet PCs for point-of-patient care. The survey, which was fielded during September 2009, included healthcare providers and IT firms that offer IT services to healthcare providers.

According to the study, three in four (74 percent) IT firms believe their healthcare clients are eager to incorporate new technologies into their practices and two in three (67 percent) believe that better care for patients is a major factor in their healthcare clients’ decision to adopt new technologies.

“As business owners, it comes as no surprise that healthcare providers are interested in the time savings and improved efficiencies offered by advanced IT,” said Tim Herbert, vice president of research, CompTIA. “However, among the study’s more significant findings is that both the healthcare and healthcare IT industries expect emerging technologies, such as electronic medical records, to better serve patients.”

Of the healthcare providers currently using electronic medical records (EMR) 82 percent cite better patient care as a major factor in their decision to adopt the technology. The other top factor, saving time/improving efficiency, rates almost identically at 83 percent. Fifty-seven percent of the healthcare providers using EMR say that compliance with regulations is a major factor in their adoption decision, 40 percent are motivated by cost savings and 37 percent are trying to keep pace with their competition.

CompTIA’s Healthcare IT Market: Insights and Opportunities study was conducted in two phases. Part one was conducted among a sample of 200 IT firms that do business in the healthcare market. Part two was conducted among a sample of 300 healthcare providers, including doctors, dentists, office managers and other healthcare practice staff. Both studies were fielded during September 2009. The full report will be available at no cost to CompTIA members. Go to the member area of CompTIA.org or contact research@comptia.org for more details.

Companies Maximize ERP by Integrating BI, Aberdeen Report Finds

The need to trim costs in these uncertain economic times is, in part, driving the adoption of enterprise resource planning (ERP) strategies. From managing financials and human resources to capital and inventory, ERP’s value has been tied to standardized business processes as well as information centralization.

The problem: ERP collects a mountain of data that often goes unanalyzed. To get the most from ERP, a new study from Aberdeen Group suggests integrating business intelligence into ERP deployments. As the report notes, “ERP investments can be increased dramatically through analysis of the consolidated data captured within and around the ERP system.”

Aberdeen’s study of 990 people looked at how companies achieved best-in-class performance by combining ERP and BI efforts. David Hatch and Cindy Jutras, co-authors of the Aberdeen study, used five key performance criteria to identify Best-in-Class companies value derived from combining ERP and BI. Such companies enjoyed:

  • Operating costs reduced by 17 percent
  • Administrative costs dropped by18 percent
  • Staff reduction (12 full-time employee positions were eliminated or employees were deployed elsewhere)
  • Closing monthly financials in less time (reduced to 3.7 days)

In contrast, for example, Industry Average companies cut operating costs by just 7 percent; Laggards actually saw their operating costs increase by 2 percent.

The analysts note how “Over the past three years, Aberdeen has watched as the need to reduce costs bubbled to the top as the primary business driver behind ERP strategies. Together with growth and customer service, these three [drivers] have dominated the pressures driving ERP implementation strategies.” ERP, they point out, “is often viewed as a necessary infrastructure.”

To bring “order to the potential chaos, perhaps the most significant of the extensions to ERP is business intelligence (BI). Think of it as a layer on top of or embedded within ERP and other applications which wind up being giant repositories of data.”

Hatch and Jutras warn enterprises not to think of BI and ERP as separate initiatives. In fact, ERP and BI projects have similar goals: “The top requirement of a BI deployment … coincides with the need to extract additional value from the relevant business data which is inherent to an ERP implementation. Improving the speed of access to this data is the key to transparency, visibility, and informed decision-making.”

What were the secrets of Best-in-Class companies in achieving their exceptional results? The report notes that to reduce costs and provide transparency through speed of access to business data, best-in-class companies “provide visibility across functions and departments pervasively across the enterprise, standardize business processes, and streamline and accelerate business processes.” Best-in-Class enterprises:

  • Provide decision-makers the ability to drill down from summary data to transactions that form the fiscal and operational audit trail; 67 percent of Best-in-Class companies provide drill-down into fiscal and operational audit trails versus just 38% for Laggards
  • Offer real-time visibility of all processes from quote to cash
  • Use ROI estimates to justify ERP projects; ROI is designed to measure business value and measurement doesn’t stop after they have been achieved.
  • Integrate business intelligence with other enterprise applications
  • Provide self-service BI capabilities to stakeholders (so users are able to work with BI systems with a minimum of IT help)

“Companies that implement ERP solutions have two basic options when it comes to integrating BI capabilities”, states Hatch. “Our research has found that top performing companies are embedding BI within ERP solutions rather than deploying BI applications as separate implementations that ’sit on top’ of ERP systems.” Additional behaviors contribute to how Best-in-Class enterprises distinguish themselves. For example, they were more likely to standardize implementation of ERP across a potentially distributed enterprise (68 percent versus just 46 percent for Laggards). Best-in-Class companies have learned to maximize their use of ERP by using features familiar to them from their BI systems; they are more likely to use their ERP system to notify users in real time of exceptions occur (53 percent compared to just 33 percent of Average companies).

Based on its study, Aberdeen says its analysis of “Best-in-Class companies shows that a combination of capabilities are necessary to derive the most value from integrating and deploying BI within an ERP environment.”

The behavior of Best-in-Class companies is clearly paying off. Such companies “are achieving 100 percent (or greater) ROI faster than their peers, reaching this milestone on average within the first six months as opposed to timeframes that start at a year and go well beyond two years for Average and Laggard companies.”

The study advises all companies to take “an integrated approach to ERP and BI. Whether BI tools are currently embedded within your ERP solution, tightly integrated, bolted on after-the-fact, or non-existent, don’t treat ERP and BI as separate projects. Take the approach of using BI as a means to extract enhanced value from data within ERP (as well as other enterprise applications).”

Hatch and Jutras point out that “ERP can transform data into information but BI tools are required to complete the transformation from information to intelligence.”

Industry News , , , , , , , , , , , , , , , ,