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
Key success factors and tips for BI in ERP integration projects
BI project management tips for implementation success
When profit margins are thin, business intelligence can make the difference for retail organizations
Do you need enterprise information management software to conduct EIM?
How to create an enterprise information management (EIM) strategy
Understanding five major enterprise information management benefits
Seven secrets to business intelligence (BI) success
How to expand enterprise reporting and capitalize on benefits of BI
Atlanta YMCA turns to SaaS BI software over 'complicated' Cognos
In-database analytics demystified

Business intelligence technology platform
BI project management tips for implementation success
Oracle, SAP and IBM top Forrester's corporate performance management rankings
Microsoft details self-service business intelligence, data warehouse releases
Birst takes SaaS BI out of the cloud, battles data security fears
Hurdles for SaaS BI vendors include data integration, low recognition
IBM launches private analytics cloud
Atlanta YMCA turns to SaaS BI software over 'complicated' Cognos
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

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