Posts

Master Data Management: Are you flying blind?

How can you govern your master data without knowing your master data? For many years I’ve been saying that the one thing all MDM clients have in common is that the quality of data in their source systems is not as good as they thought.  Over the past several years I’ve found that all MDM clients have a second thing in common: they are unaware of the quality of data in their MDM hub and they don’t know how the data is changing.  This is surprising since an MDM hub contains your most critical business data that is used in real-time processes and analytics across the organization.  How can you govern your data when you don’t know its trend in quality, how it is being used and how it is changing over time?   This is flying blind. There are a few contributing factors to this issue.  The first is that MDM products don’t provide capabilities to analyze and report on data.  The second is an MDM hub is not the appropriate place to do thi...

How to access Informatica PowerCenter as a Web Service

Web Services Overview: Web Services are services available over the web that enables communication and provide a standard protocol for communication. To enable the communication, we need a medium (HTTP) and a format (XML/JSON). There are two parties to the web services, namely Service Provider and Service Consumer. A web service provider develops/implements the application (web service) and makes it available over the internet (web).  Service Provider publishes an interface for the web services that describes all the attributes of the web service. Service Consumer consumes the web service. For the Consumer to consume the web service, the consumer has to know the services available, request and response parameters, how to call the services and so on. Hence we can define Web Service as a standardized way of integrating web desk applications using XML, SOAP, WSDL and UDDI open standards over an internet protocol backbone. XML is used to tag the data. SOAP is used to transfer t...

Interpreting your data graphically

Apart from the better understanding on data, we need to pay more attention towards the basic statistics as it is the key concept of driving the data to develop interactive visualizations and convert tables into pictures. The rapid rise of visualization tools such as Spotfire, Tableau, Qlikview and Zoomdata, has gained immense use of graphics in the media. These tools currently hold an ability to transform the data into meaningful information with proper standard level principles in the statistical visualization world. They are very helpful in translating the analysis into pixels when you are ready with the cleansed data/analysis. It is quite often in everyday life, we get to see a massive amount of data crawling that is continuously increasing. Now the question is how to get better insights before making any decision for a business problem. Let us assume you are inclined towards a specific sector say sales (Or any other sector like finance, marketing & operation...

Interfacing Virtual MDM through DataStage

MDM Connector stage is a key to open the door of IBM Virtual MDM. Yes, we can manipulate the data in MDM (MDM refers to IBM Virtual MDM in this post) using the MDM Connector stage which was introduced in IBM DataStage v11.3. We know that loading data into MDM is not an easy task since it involves many tables and the relationship among the tables should be maintained properly, otherwise will end up dealing with junk not with the data. MDM Connector stage makes this task simpler by allowing us to configure everything in the single configuration window. This blog post details on how the basic operations (read/write) on data can be performed using the Connector stage in v11.5. DataStage and MDM Server Connectivity To connect to the MDM server, the following should be specified in the stage properties Host name – IP Address/Host Name of the MDM Server Port number – http Port number of the MDM Server. This can be found in the app.properties file of MDM Writing Data int...

Governed Data Lake for Customer Critical Data Analytics

Retail chains that have brick and mortar stores as well as online platforms often struggle in identifying the customers visiting their site. Even with all the information available at their disposal, the probability of identifying the customers accessing their website is a mere 30%. This blog discusses on the system used to tracking and identifying customers who interact with our client’s online portal and then shop in-store and vice-versa. Benefits Identifying the change in customer preference based on the changes in climate and geography and its impact on the customer’s buying patterns is possible only if the system can synthesize fragments of customer data existing in data lakes and create a customer 360 view. Identifying potential correlations of these factors with their buying pattern would enable our clients to target potential customers with more relevant marketing messages and customized offers. Building the Data Lake using Big Data Technology The above ...

InfoTrellis to be Acquired by Mastech Digital

Combined entity creates a unique Digital Transformation Services Company with deep Consulting and Project Delivery Capabilities in Data Management & Analytics Toronto, Ontario, Canada – July 7, 2017:   InfoTrellis, Inc., a Toronto-based  Data Management & Analytics company, today announced that it has entered into a definitive agreement under which Mastech Digital, Inc. (NYSE :   MHH), a leading Digital Transformation Services provider, will acquire InfoTrellis’ services division. The demand for Digital Transformation consulting services is growing rapidly, as more Fortune 1000 companies are funding digital transformation initiatives to reinvent how they do business.  Data & analytics is at the heart of every digital transformation strategy and our combination will bring together two differentiated companies – both with global brand recognition and complementary service offerings – and a unique value proposition to offer expertise and scalability in d...