Editorial – Dec 2009

December 17th, 2009

Hi there,

Welcome to the Dec 2009 edition of BI Insight newsletter!

While the economy still faces some significant challenges, there are a number of reasons to feel optimistic about 2010: "The momentum is building." In a changing economy, businesses explore ways to streamline processes and reduce costs. It is essential to focus on innovation to spur recovery and long-term growth.

The latest statistics reveal that the top technologies for enhancing competitiveness over the next five years at high-growth, midsize organizations are business intelligence, analytics and self service portals. Recognizing the value of delivering competitive insights that are often hidden in data, Systech’s R&D groups and client engagements have given us an excellent test bed to explore deep analytics to target various industry verticals.

http://www.systechusa.com/solutions/

The solution provides valuable insights to help organizations to make evidence-based decisions, measure business objectives, drive sustainable growth and manage change.

This month’s highlights:

  1. Systech’s project success in Global Credit Management Reporting for a leading provider of financial advisory services and international banking services.
  2. A featured report on Data Warehouse Appliance.
  3. And, of course, 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.

Cheers,
Vaishnavi Gollapudi
The Editor

Editor's Note

Global Credit Management Reporting

December 17th, 2009

Background

In this case study we describe how a leading provider of financial advisory services and international banking services benefitted from Systech’s innovative solution and also saved more than $7 million in logistical costs.

Our client provided a variety of products and services, including the Credit Card, the Optima Card and other consumer and corporate lending products, stored value products, corporate and consumer travel products and services, magazine publishing and merchant transaction processing, point of sale and back office products and services.

The client was looking to enhance their customer satisfaction. They wanted to act as a Global Credit Management source and needed a reporting system to manage this efficiently and cost effectively.

Solution

Systech initially established security access for web and created a data collection process. The data collection process included the gathering of report profile information and corresponding MIS data as requested

Systech then enabled a web based reporting system that helped their clients gain easier access. This proved to be a comprehensive method of viewing their statements. The data from current reports such as Industry Reports, Card member Reports and Client Hierarchy Reports was made available. The solution gave their clients the functionality and accessibility to view their corporate accounts in the categories of air, hotel and rental. This allowed for more cost effective methods of negotiating travel patterns for companies. It helped companies track their expenses world-wide.

It thereby, provided the client with a tool to leverage customer data for more complex analysis through the use of filters and interactive access to detailed information. The system also gave a highly summarized report on items such as global spending, and where and how money is being spent. This provided a value-added service to their customer. The modification of the data warehouse allowed for access of reporting on the web with guaranteed, data level security – an important issue for the users. The system could also report on multiple currencies.

Benefits

The web based reporting system provided the benefits of:

  • Improved timeliness of the Corporate Purchasing Card data
  • Reduced purchase order costs
  • Better strategic procurement decisions through increased analytical capabilities
  • Enhanced Customer Satisfaction

Featured Article ,

Data Warehouse Appliance – The Next Generation Appliances

December 17th, 2009

Fast emerging and dynamic global economy have made quick and easy access to information. It has become mandatory that organizations understand and respond quickly and appropriately to unanticipated changes in operations and marketplace. Data warehouse appliances make data warehousing simple and powerful. They enable high performance data warehousing at a lower TCO. Using DW appliances businesses can build BI projects that were previously not possible. Many new data warehouse appliance vendors are now extending their products to support more complex workloads that offer additional capabilities and utilities for BI application and are changing the way that business thinks about data warehousing.

This research paper describes the nature, importance and benefits of “Data warehouse (DW) Appliances” and its use for business intelligence (BI) and data warehousing (DW). It also highlights a variety of other aspects concerning DW appliances such as the differentiators among DW appliance products, Total Cost of Ownership, things to remember while reaching a buy decision for DW appliances etc. The report also includes a note on the future of Data Warehouse Appliances in ever changing, dynamic BI industry.

Register here to request the white paper.

Systech Corner , ,

Industry News – Dec 2009

December 17th, 2009


Fordham University and IBM Launch Business Analytics Curriculum to Prepare Students for Careers

Fordham University and IBM are collaborating on a new business analytics curriculum to help prepare college students for careers in key industries such as energy and utilities, healthcare, education, transportation and public service that are expected to benefit from $1.8 trillion in global stimulus investments.

Businesses and governments are now driving transformation projects including smart grids that lower energy consumption, sensors that help reduce traffic congestion, electronic medical records for personalized healthcare and RFID tags that trace food and medicine for consumer safety. The digital infrastructures supporting these projects will generate enormous amounts of data requiring a skilled workforce to make sense of it in a meaningful way. For example, computing systems today are generating 15 petabytes of new information every day — eight times more than the combined information in all the libraries in the U.S.

In a recent IBM Global CIO Study, 83 percent of respondents identified business analytics — the ability to see patterns in vast amounts of data and extract actionable insights — as a top priority and a way in which they plan to enhance their competitiveness. As the adoption of business analytics grows within organizations, the need for analytics skills across all functions of a business rises as well.

“Analytics can vastly improve our lives and provide new job opportunities for college students entering the workforce,” said W. Raghupathi, Professor of Information Systems, Fordham University School of Business. “Fordham has a long history of collaboration with IBM that has brought innovative new skills to our curriculum to prepare students for future jobs. With this effort, Fordham is preparing students with marketable skills for a coming wave of jobs in healthcare, sustainability, and social services where analytics can be applied to everyday challenges.”

Fordham’s Schools of Business, which offers undergraduate and graduate programs in information and communication systems, is addressing the need with a first-of-its kind Business Analytics for Managers course based on IBM analytics technology. Beginning Spring 2010, students can register and get hands-on training in business intelligence, data analytics, data warehousing, data mining and online analytical processing (OLAP) techniques. Students will also learn managerial decision making and how analytics technology can improve the effectiveness of key business functions such as marketing, sales, finance, business development, human resources and manufacturing. Additional topics include:

Reporting: Students will become proficient at authoring, using and sharing any type of report — drawing on any data source — so they can present business analytics information in a consistent and easy-to-use way.

Analysis: Students will learn how to analyze and report against online analytical processing (OLAP) and dimensionally aware relational data sources. This will help them learn how to spot trends and see business issues from a variety of dimensions.

Score carding: Students will master the art of building easy-to-use scorecards to align teams and tactics with business strategy. They can communicate business goals company-wide and let people monitor performance against their targets.

Dashboards: Students will learn how to communicate complex information quickly using dashboards, which provide a single view of information that business professional, can use to make key decisions.

Business and governments alike are using the power of analytics to better manage the information explosion and make informed decisions to better serve customers and citizens.

This BI Insight news item contains information from a recent press release by the company mentioned.

Over the years Systech continues to develop skills, knowledge, work processes and technologies to effectively deliver BI solutions across the globe.

View Systech’s Training model and road to building leaders in BI

http://www.systechusa.com/training-model/


Kaleida Health Monitors Flu Cases with Oracle

Kaleida Health, the largest health care provider in Western New York, is monitoring daily cases of patients showing flu symptoms being treated across its five- hospital system with the help of business intelligence (BI) dashboard developed using Oracle Business Intelligence Suite Enterprise Edition (Oracle BI Suite EE).

The dashboard enables a team of 35 at Kaleida Health including hospital presidents, Chief Nursing Officers, Chief of Emergency Medicine, Chief Medical Officer, and others, to understand trends related to patients with flu symptoms, and track trends related to staff with flu-like symptoms.

Additionally, the dashboard tracks how the trending information impacts staffing levels at its hospitals, and report the number of cases of patients with flu symptoms to the New York State Department of Health.

The Flu Monitoring Dashboard is updated automatically daily and replaces previously manual efforts by hospital staff to track patients showing flu-like symptoms from reports run daily.

Flu Monitoring Dashboard Part of Broad BI and Analytics System Deployed by Kaleida Health

Kaleida Health’s Flu Monitoring Dashboard highlights:

Current in-house patients with flu symptoms in aggregate, per hospital and as a percentage compared to the total number of in-house patients across Kaleida Health hospitals;

Graphs tracking trends of patient visits to Emergency Departments with flu symptoms at each of Kaleida Health’s hospitals;

In-house patient and outpatient with flu symptoms trends over the last 13 months; and,

Total number of Kaleida Health employees calling in sick with flu-like symptoms by day, by role and by hospital

The Flu Monitoring Dashboard, prototyped and developed within a week’s time in September 2009, is just one of over 25 executive dashboards available to Kaleida Health’s management team via the organization’s “Magellan” Balanced Scorecard system, which is powered by Oracle BI Suite EE.

Magellan helps Kaleida Health’s management team monitor metrics and Key Performance Indicators across five categories: Financial, Quality, Staffing, Operational, and Growth and Strategic.

In addition to offering executives an accurate overview of daily operations and finances, the system’s dashboards helps guide strategic decision-making from exploring expansion and development of new lines of business, to physician recruitment and staff retention, and beyond.

Oracle BI Suite EE runs on top of an Oracle Database-powered data warehouse that includes data from various systems running at Kaleida Health including financial, billing, payroll and clinical applications.

Buffalo, New York-based Kaleida Health went into production with Oracle BI Suite EE in August 2009.

Magellan will be rolled out to over 600 employees across Kaleida Health in 2010.

“With the flu season starting up in early September, we were able to pull together all of the necessary information on a single dashboard page in about a week’s time,” said Dan Gerena, Director of Business Intelligence and Corporate Analytics, Kaleida Health. “It’s a very different paradigm for reporting now with Oracle BI Suite EE. It was a very quick process in terms of building the Flu Monitoring Dashboard, getting new users up and running, educating them on what the metrics are, and showing them how to access the dashboard.”

This BI Insight news item contains information from a recent press release by the company mentioned.

Systech offers a number of innovative solutions based on Oracle Business Intelligence Enterprise Edition. Partnering with Oracle, Systech continues to help companies manage customer, workforce and financial information.

View Systech Solutions as a leader in the implementation of Oracle based Business Intelligence solutions

http://www.systechusa.com/oracle-bi/

Systech’s Healthcare Analytics solution helps integrate patient data across the enterprise and makes it available at the point-of-service to help providers improve customer service, reduce medical errors, improve productivity and enable patient-centric processes – the prerequisite for improving the care delivery process.

View various applications and benefits of Healthcare Analytics developed at Systech.

http://www.systechusa.com/healthcare-analytics/


Sunny Delight Leverages Trade Promotion Management to Strengthen Customer Profitability

Consumer Goods (CG) manufacturers rely heavily on trade funds to proactively shape demand, influence retailers and to collaborate on marketing programs that help drive consumer behavior. While the average shopper may not be aware of it, virtually every product placement, price reduction, and end cap has been funded by the manufacturer. For the average CG manufacturer, trade spending ranks second only to the cost of goods on the balance sheet and regardless of the recent recession trade spending has not decreased in most companies.

As a result, most consumer goods companies have implemented trade promotion management (TPM) solutions with the idea of improving trade spend, automating antiquated spreadsheets or creating a better planning and forecasting process. For Sunny Delight Beverages Co. (Sunny D), a leading producer of juice-based drinks in North America and Western Europe , it was all about customer profitability.

A Sunny New Direction

After spinning off from CG giant Proctor & Gamble, Sunny D suddenly found themselves a small fish in a big pond. As a new small-to-medium-sized business (SMB), it was imperative that Sunny D not only implement new technologies, but rather use them in a way that could exploit their position as a smaller CG manufacturer and help them to better compete with their much larger competitors.

The first step in the process for Sunny D was to integrate its TPM system with its broker’s network. In order to make this happen as quickly and as seamlessly as possible, Sunny D knew they needed to adopt the right trade promotion management solution – one that would tie into the broker network while improving synergies between TradeLync and Sunny D’s financial system. Sunny D also realized, like many other CG companies, that Excel spreadsheets were not the optimum way to communicate trade promotion and/or sales and reporting activities between the Company and its broker, Acosta. Consequently, and on the recommendation of Acosta who already uses MEI for trade promotion management, Sunny D began an intensive look at this TPM solution.

Customer Profitability Will Quench Your Thirst

After a fast implementation, Sunny D’s order management and ERP systems were feeding data to the new TPM application. However, they soon began to realize that there was a lot more to trade promotion management than improving and tracking overall trade spend, so they quickly shifted their overarching goal to improving customer profitability. If they could map revenue, trade promotions, cost of goods sold, logistics and any other variable customer-related costs to finance, they could also improve the overall efficiency and revenue of the Company. To do so, this model would require them to extend the use of the TPM solution throughout all of finance, product supply and logistics.

“By gaining small wins with the MEI trade system and then multiplying those wins on an enterprise-wide level, we could really drive change across the company,” commented Chris Miller, Sales Finance Manager. “We knew that combining various data and customer touch points would allow us to identify spend by customer and see how effective we are at driving specific financial contributions at the customer level.”

Managing cash is always a priority for SMBs and Sunny D is no exception. They needed to be specific when it came to incremental trade and be able to analyze which programs could be more profitable to the business. Miller stated, “When allocating incremental trade funding, we can analyze the data to determine the appropriate investment. We recently analyzed two very similar customers with slightly different profitability to determine why there was a delta. Using the MEI TPM suite across internal groups, we identified the difference in profitability was due to logistics; not necessarily in shipping costs, but in ‘lumper’ fees and late fees. After some discussions, the customer now picks up their orders saving both Sunny D and the customer a significant amount of budget. Being able to see trade spend and revenue per customer enabled the groups to perform an accurate analysis of the situation. This resulted in a win for Sunny D and the customer.”

The TPM solution helped in other ways too. For example, the Company sells to the Military though government approved distributors; consequently, they wouldn’t normally be able to track the end customer’s profitability. By leveraging the functionality of the MEI TPM solution, Sunny D is able to drill down and see how the distributors are loading their data, which – in turn – enables Miller to gain valuable insight into how the end user is buying the Company’s products.

Sunny D also uses the TPM solution to help analyze a company after an acquisition. During its recent acquisition of Veryfine, some of the product lines were considered unprofitable. However, using the MEI system, Sunny D was able to analyze the “spend per pack size” data and determine that trade spend was a lot more efficient than they initially realized. “The ability to see the details enables us to act faster to market conditions and make the best choices for the Company.”

Sunny D’s sales force is also using the TPM application. In fact, Miller stated they use contribution to maximize the efficient use of their customer’s trade funding by analyzing top-line revenue down to cost of goods sold. ”Our goal is to make our funds work as hard as possible to grow revenue for Sunny D and our retail partners.”

Since the implementation, Sunny D has seen a higher level of efficiencies across the board, and has enlisted the help of various departments to help strengthen profits. In fact, the trade promotion management application has already helped the company exceed initial goals for the implementation. Although Sunny D concentrates on customer profitability, they also reap the more standard rewards from trade promotion management technology including simplified budgeting, planning, accruals and volume- and spend forecasting. But it’s the smaller business mentality that Miller claims is the crux behind the Company’s successful use of its TPM technology. By fully utilizing all of the functionality of its TPM suite, Sunny D has successfully managed its business through a detailed view of customer profitability and by continuing to create wholesome beverages that meet the needs of their target audiences.

This BI Insight news item contains information from a recent press release by the company mentioned.

Systech provides cutting edge Cost Reduction and Profit Improvement solutions for Retail and CPG companies. Systech enables companies in uncovering hidden profit opportunities and in creating profitable revenue growth; quickly and easily.

View various applications and benefits of Profit Analytics developed at Systech.

http://www.systechusa.com/profit-analytics/

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

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 , , , , , , , , , , , , , , , ,

Editorial – Summer 2009

September 4th, 2009

Welcome to Summer 2009 edition of our newsletter – BI Insight! This month’s newsletter highlights Systech’s project success in “Productivity Analysis and Reporting for Prescription Claims”. In this case study you would see how a leading provider of Pharmacy Benefit Management Services achieved improved pricing and design strategy through Systech’s comprehensive, cost effective solution and analysis. The second article for this issue is Systech Corner, in which we feature an interview with Dr. Suresh Bangara, CEO of Hippocrates Gate, LLC. The interview examines his company’s latest application, AccessHSI that could potentially revolutionize the health care industry by providing an efficient and cost-effective solution. And apart from these we have also included BI news articles from reputed sources. We hope you find the newsletter interesting and informative. Please invite your peers to visit us and subscribe to us. Enjoy reading!

Warm Regards,

The Editor

Editor's Note

Productivity Analysis and Reporting for Prescription Claims

September 4th, 2009

Background

In this case study we describe how a leading provider of pharmacy benefit management services achieved improved pricing and design strategy through Systech’s comprehensive, cost effective solution and analytics solution.

The client needed a powerful Business Intelligence system to cut costs to analyze spending patterns across the country. An improvement in physician compliance to utilize and better manage the pharmacy dollar was needed in order to lower healthcare costs and provide better services for customers. They needed to find a cost effective, complete and comprehensive solution which would perform complex analysis quickly and efficiently.

Challenges

The principal challenge was the analysis of claims costs, profits, sales comparisons, product comparisons and overall productivity. The customer wanted a robust system that would be easy for their IT department to maintain after it was implemented and also, one that would be scalable and reliable.

Solution

As a strategic consultant Systech’s first evaluated client’s infrastructure and environment, and recommended a datawarehouse infrastructure for implementing the solution. Systech was responsible for building and maintaining a robust Business Intelligence solution. The data warehouse is used to report on a variety of information for a multitude of clients. This helped to identify the key metrics such as top prescribers, members, and drugs by medical groups among many other functions required for prescription claims analysis and fraudulent claims detection. The data warehouse also enabled accurate forecasts of the industry’s leading trends, utilization trends & patterns. It enhanced the quality and reliability of the information gathered.

Result

The solution helped our client perform accurate forecasts of pharmacy trends leading to improvements in benefit plan design and pricing, resulting in better financial decisions. It helped physicians be better informed and helped provide quality health care for patients. Fraudulent claim detection also helped save revenue leakage for the company.

Featured Article , , , , , , , , ,