Home > Data management / BI News > BJ's IT overhaul lays groundwork for BI, MDM
Data management / BI News:
EMAIL THIS

BJ's IT overhaul lays groundwork for BI, MDM

By Barney Beal, News Director
12 Jan 2009 | SearchDataManagement.com

News on data management trends and technology
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

BJ's Wholesale Club Inc. is in the early stages of a five-year plan to overhaul its aged IT systems as part of a CEO-led growth plan. In Part 1 of our coverage, CIO John Polizzi explained how the company established the plan and began the project with its operational systems, warehouse management, point of sale, gas, and payroll, all of which will lay the groundwork for a new ERP implementation.

As BJ's systems are being overhauled, the company is now taking a close look at product and data management -- pursuing a master data management (MDM) initiative. There are two separate components to the initiative, Polizzi said -- a business and a tactical project.

"When you talk about data governance and data quality, the master data management approach is the foundation piece," he said.

It's a step that demands careful consideration lest it undermine the investments made in software. Legacy systems tied to specific applications, and software packages without the right data quality processes and standards, mean that an organization can wind up with incorrect data tied directly to the functional applications, Polizzi said.

"You wind up with data that can get bastardized very easily or corrupted very easily because of application requirements," he said. "That is why we chose the membership and product data management system as the first two areas where we are going to look to externalize our master data from any application. Then, as we choose an ERP system, that will be the data source that feeds the ERP data.

"For years, everybody said, 'Well, you just tie the application into the application databases.' The restrictions with that, especially in a retail environment, are as you get into multiple channels, the data requirements for products are a lot different than the data requirements you traditionally use for merchandising or for your clubs," Polizzi said. "The attributes around that data build on what you have but go quite extensively in other ways. So this idea that the data has to be tied to the specific application hasn't made sense for a while. We're going in the MDM direction at least in the first two data areas -- membership and product."

Not to be left out, an updated enterprise architecture and an integration architecture are both in the planning stages as well.

"It's critical we establish that early on and [understand] how we are going to leverage integration technology," Polizzi said.

Banking on business intelligence

Meanwhile, Polizzi is also keeping his eye on business intelligence (BI).

"What we're realizing is that it is going to be three years before we seriously look at ERP solutions, and we have, like most companies, a large number of siloed data sources used by different divisions to do analytics and reporting," he said. "We have the problem where one division will run one report off of one data source, and another will run what they think is the same solution, or the same questions are being answered of another, and we'll get two different answers."

Built into BJ's five-year plan is a BI road map evaluating the current and future analysis needs and how the company will establish the right combination of people, process and technology to reach its milestones.

"We're also in the process of getting approved quick wins to improve critical data sources to support merchandising and finance," Polizzi said. "Because ERP is three to four years out, we need to make sure we're providing the right information to support the business in the interim."

More on business intelligence software
Find out why a data warehouse appliance proved to be a winning bet for Foxwoods

Read about Microsoft's recently announced self-service business intelligence tools
Spearheading the BI planning is a team made up of key people in the finance and merchandising operations. They have identified four key reports that are needed to drive analytics at BJ's.

"It's great to say you have all these roadmaps, but in the interim you have to get some of the work done," Polizzi said. "That's why we split into two initiatives. We do need to do the longer-term work and say how we're going to get to an enterprise view data warehouse, the proper data stewardship and data governance and what are the right processes and approaches we should be taking -- everything from dashboards to analytical reporting."

Like many organizations, BJ's has multiple data warehouses across the organization and multiple tools for accessing that data favored by different departments.

"We're not going to get into religious wars over the tools," Polizzi said. "We're going to figure out over time how to rationalize it so we can do an effective job of training and making the right tools available to the right groups."

Planning for the short term, preparing for the long term

An IT initiative, especially BJ's, is not a one-and-done process but rather an evolution.

"The reality is when you're building a five-year strategy, you're re-looking at it every year and saying, 'OK, what am I going to do in the next 12 to 18 months, and does that tie into what I plan to do in the next 36 months, and then what does that do to the overall program I established,' " Polizzi said. "Is it still reasonable? Have the business priorities changed?"

Organizations need to match business objectives with the framework of the IT plan at least annually. Events like an acquisition or new competition may also demand an adjustment in strategy. For BJ's, it's so far, so good. The company has not yet made any changes to the plan, Polizzi said, despite the recent economic news.



Tags: Business intelligence best practicesBusiness intelligence technology platformMDM best practicesProduct information management softwareData quality techniques and best practicesData governance strategyVIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Business intelligence best practices
Five technology trends for improved business intelligence performance
In-database analytics demystified
Choosing BI software: Use your ERP vendor or go with third-party BI?
Understanding in-database analytics technology: Benefits, uses and ROI
Is in-database analytics an emerging business intelligence (BI) trend?
Trends and tips for using business intelligence and analytics in retail
Trends and tips for using business intelligence in financial services
BT taps open source BI software, homegrown DW to unlock customer data
Data integration for Software as a Service business intelligence software evolves
The importance and benefits of operational decision making

Business intelligence technology platform
Five technology trends for improved business intelligence performance
Choosing BI software: Use your ERP vendor or go with third-party BI?
Data integration for Software as a Service business intelligence software evolves
SAP inks another partnership to enhance NetWeaver BW
Yearbook publisher finds BI reporting, data integration tools from same vendor
A rash of business intelligence acquisitions making waves
What is Enterprise 2.0?
Should we use traditional or agile software development processes?
IBM releases Cognos business intelligence suite aimed at midmarket
Gartner: Take a parallel approach to migrate business intelligence reports

MDM best practices
Master data management adoption 'broad but shallow' across industries
Six criteria for master data management (MDM) tool evaluation
Is it better to have a centralized or decentralized master data structure?
What's the cost of developing PIM software internally vs. externally?
What exactly is data governance and what falls under this category?
Can we leverage existing data quality tools for an MDM program?
Keys to planning an enterprise information management (EIM) initiative
Why is managing change challenging for master data management initiatives?
What is business change management for MDM?
Tips for aligning business and IT teams during MDM implementations

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
corporate performance management  (SearchDataManagement.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Data Management: Business Intelligence, Data Integration, Data Compliance
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts