Does the raging ‘information explosion’ baffle you? Unravel the Enterprise Information Management (EIM) treasury for an assured return on information with a competitive advantage.

January 27, 2012

Cloud BI Scenarios:

Given high data volumes & their movements in BI and DWH space, ever wondered on where you will deply Cloud in BI?   I came up with some quick reference guide on the areas where we can apply Cloud.  Here are some examples (in the RCLL space):

External Data Analytics: Data from AC Nielson and IMS (medical POS data) is analysed by most of the organisations already, but mostly in silos at country level.  This way the metrics and other parameters they measure are usually country-specific, leaving very little information for sharing across countries.  Organisation-wide implementation of the external data analytics is gaining ground mainly in increasing the productivity, optimise costs and increase information sharing.  Since there is a lot of hesitation for org-wide adoption, cloud plays a very important role in providing scalable infrastructure.  Cloud also provides anywhere-access, thus making information sharing even more easy

Continue reading "Cloud BI Scenarios:" »

January 26, 2012

BI on Cloud

You must be aware that Cloud has been on the Top of CIOs Agenda these days.  Business Intelligence and Analytics were on the top 3 of CIOs Agenda till last year, but now they appear within Top 10.  If you separate them as infrastructure and applications, then BI and Analytics would still occupy the top slots. 

Business Intelligence always evolves at an organisation, hence is best described as a journey, rather than a reaching a destination.  The side effect for this evolution is that it accumulates lots of data over a period of time, and generates attention across the organisation.  Our experience shows that data accumulation has serious consequences on server scalability and slows down future developments.  Its popularity among the other functions across the organisation attracts more data usage and building extra data marts/ data pens etc.

Continue reading "BI on Cloud" »

December 9, 2011

Start up to MDM (3).....

Understanding the organisation's information / reporting needs and categorisation of the same into Subject Areas / Information Areas gives a good start into MDM structuring.  Next we need to label the subject areas with respect to the organisation parameters like business units, geography, and the hierarchy of people it is supposed to service.  

Continue reading "Start up to MDM (3)....." »

November 28, 2011

Start up to MDM (2)...

Before we jump on to the MDM bandwagon on a full-scale, we need to actually take a step back and think.  If you look at the inners of any MDM application, what do we get to see?  We see data extractions, data integrations, transformations, cleansing, standardisation, and data loading...., right? Where do we see such stuff?  We see all these in the larger picture of Business Intelligence or Information Management.  So, MDM has to fit in the overall picture of Information Management or Business Intelligence.  All these BI or IM help in Decision Support for Business Users, right? So, why not look at it from the top down and bottom up approaches in terms of information requirements at various levels or across the organisation.  You will have information / decision making needs at various levels of the organisation like: Top management, Business Unit level, Analytical level, and Operational level.  I added Operational level included here, as BI / IM is becoming omnipresent in most of the organisations.  

Continue reading "Start up to MDM (2)..." »

November 23, 2011

Start up to MDM

When an organisation takes up a Master Data Management exercise, we expect the whole organisation to adopt the new Master Data / Reference Data Codes.  How correct is this?  What happens to the part of the organisation which is still dealing with day-to-day operational activities & related challenges?  What happens to the part of the organisation that is still operating Mainframes and other legacy systems?  

Continue reading "Start up to MDM" »

September 7, 2011

BI & MDM in CPG Demand Forecasting (3). . .

This is a continuation to the blogs dated 18th and 22nd Aug2011.  We talked about the business requirements in the first blog.  Then we talked about how we plan to address the Master data hierarchy requirements in the second blog.  In this blog, I am going to cover the most important aspect of the business that is margins / profit. 

Continue reading "BI & MDM in CPG Demand Forecasting (3). . . " »

August 22, 2011

BI & MDM in Demand Forecasting . . . .

This is the continuation of the blog on "BI & MDM in CPG Demand Forecasting "dated 18Aug2011.  I am going to address the problems we saw and the solutions we offered, one by one. 

Let me start with the multiple hierarchy requirements.  The SKUs are supposed to be rolled up as per the Product Group (main one: based on type of material), Brand (different names for different customers, regions), Sub Brand (based on grade of the material), Packaging size (based on the quantity packed), Business Unit (whether selling directly to big retailers, retail consumers etc.), Category (manufactured / bought), Recipe (to indicate main ingredients), and SKU Case (trollies, packs, SKU etc.).   A huge number of hierarchies as you can see....  These are the ones recognised so far.  There are many to be defined yet.  

Continue reading "BI & MDM in Demand Forecasting . . . . " »

August 18, 2011

BI & MDM in Demand Forecasting

Demand Forecasting in CPG organisations is gaining more importance these days to forecast their customers' product off-take.  This is about one of our Retail CPG customer's decision to adopt a Demand Forecasting application to meet all their forecasting needs. 

This is about the same customer about whom I described earlier as:

Continue reading "BI & MDM in Demand Forecasting" »

May 9, 2011

Where is the missing order data?

How will you react when the business complains that there are few million dollars order information missing in the DWH?

In a typical data warehouse scenario, the data from the operational systems is loaded into the data warehouse (DWH) system on a regular basis. The data load is usually incremental, particularly when the data volume involved is huge. The DWH provides the data to reporting systems.

In a large retail enterprise, there is an enterprise DWH system, which is architected in the above manner. 

Continue reading "Where is the missing order data?" »

May 5, 2011

Enterprise 2.0 - A Promise yet to be delivered?

With the risk of sounding repetitive and stating the obvious...let me begin...by suggesting that this may NOT be a closed and sealed topic...And my recent interactions with business and IT leaders of some leading global organizations confirmed this point.

 

Right...we are living in an age where social networks play a big role in the rise and fall of political leaders, ideologies and institutions...we all vouch by the significance of this phenomenon in our daily life...we all have our virtual identity as our alter ego. But when posed with the question of Enterprise Social networking, Shakespearian style soliloquies and musings continue to live on in the minds of Senior Management..."To B(log) or Not to B(log)...that is the question..."

 

Is this too powerful to be contained within the enterprise? (Is 'contained' an old economy expression...That is yet another discussion). Does it appear to be too destructive (to the corporate fabric) and distractive (to the corporate citizens)? Is Enterprise 2.0 trying to wish away Social Networking - its very own bedrock?

 

May be it is time to take a relook into the whole phenomenon....

 

There was a time when Enterprise Social networking was all about throwing in a set of the so called "Enterprise 2.0 applications". We all have gone past those ages of infancy. We have started to appreciate the deeper facets and cultural hues of Social Networking and that is all to do with the way people communicate.

 

In this new paradigm of collaboration, an organization's "information fire hoses", transforms into "Channels of Expression". The seemingly casual, huddle formation but very relevant and useful exchange of information that normally happen at the water fountains now becomes the norm. Likeminded people flock together and start to express freely and Interesting topics attract user attention and people pour their hearts out. Discussions change course through the conversations...really interactive and participative. In this construct 'Organization' became incidental and the organizational hierarchy breakdown. Wear your creative hat for a second and try to visualize a day in this 2.0 Enterprise - You meet the CEO at the water fountain almost every day and even the newest employee get an opportunity to walk the corporate corridors. Right...in this world 'Personalities', 'Topics' and 'Need for Self Expression' take the center stage.

 

So let me go back to the earlier question...Does this appear to be too destructive (to the corporate fabric) and distractive (to the corporate citizens)? With all the perceived benefits around the "breaking down of Information asymmetries", "Employee Engagement" and "Knowledge Sharing" it IS in a way triggering off '"too many changes too soon". And this IS the cause of concerns for the wannabe Enterprise 2.0 CIOs. The organization needs to be primed to handle this cultural shift. The organization need to transition though a set of changes based on its state of affairs and priorities.

 

Social Network Model.pngIf we look at Social Networking or Enterprise 2.0 as a dynamic and synergic co-existence of 3 key entities - People, Purpose and Information (People, Intent and Content), on a framework that enables 'Self Organization' and 'Participation' the jigsaws suddenly falls in place.

 

 

This forces the CIO to ask the question, so what are we trying to achieve? What is my priority?

 

  1. In a globally distributed organization, the primary need may be to keep the employees connected...
  2. In a family run business, the priority may be to drive participation and employee engagement...
  3. In a knowledge based organization, guiding the people to the right information or to the right experts is what is required..

Thus a road map based on the organiational priorities would make this transition and transformation into a true Enterprise 2.0 organization more seamless and fruitful.

 

Enterprise Road Map.pngThis transition does not happen overnight. The tranformation is more cultural and as we always say technology is an enabler. And with the right Enterprise Social networking strategy and roadmap, the organization seamlessly matures into a Smart enterprise

 

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter