The Macrosite for News, Analysis and Opinion about the Future of the Internet
Lillian Pierson

Analytics Solutions for a Modern Business Problem

Written by Lillian Pierson
4/29/2013 34 comments
no ratings
DISCUSS     Email This

A lot of organizations operate with very limited insights into their clients’ relationship with the business itself. Even in this data-driven era, they aren’t using analytical capabilities to develop products and channels for their clients. They want to build strong relationships with their clients, but their understanding of customer needs and preferences is underdeveloped or even non-existent.

Other businesses struggle with developing homogeneity across the diverse channels through which customers seek to access the business. As technology changes and customers look to contact the business through new channels, organizations must develop and homogenize these channels so customers receive the same level of service across whichever channel they prefer. Now, more than ever, customers are demanding self-service access to the goods and services they wish to procure. These self-service channels must be in place and well developed.

Not only are customers demanding self-service access to the business, but they want a custom-tailored experience; an experience that is uniquely designed to meet their needs and values. Businesses have to offer services, state policies, and activate business procedures according to the specific needs and problems of each customer, on a customer-by-customer basis.

Pablo More is a senior business intelligence ERP programmer who has assisted many clients in overcoming these types of obstacles. In a recent interview, Pablo More generously offered the following strategies and solutions for meeting your clients’ analytical and channel development needs in 2013.

Getting your data act together
In order to get a complete and accurate 360-degree view of your client, you will need to collect and aggregate your data from all channels and points of contact through which the client reaches the business. To ensure the accuracy of deductions that you will later draw from the dataset, you must acquire, migrate, and aggregate all client data into one datamart. This datamart will house all current and historical client data in one central repository.

To do this, start by defining your project scope and solution. Next, locate your data sources and begin carefully mapping them to their respective targets in the datamart. Before actually moving your data anywhere, you will want to be careful to set up the correct business rules for the migration. After applying these rules, the data can be migrated to a staging area and transformed using your choice of ETL (Extract Transform and Load) tools. Lastly, after migrating your separate sources to a consolidated data warehouse, you will want to profile your data to verify the accuracy of the business rules you applied.

Analytics solutions for the modern business
Whether your business uses SAS or a different business intelligence analytics tool, the next step is to select your metrics and point your tool to the datamart that you have created. Once you have constructed and configured this system, trained business users and analysts can use their analytics tools to begin generating metric insights about each customer’s needs and preferences. With all data aggregated in one datamart for the analyst to access, it should be quite easy to start deducing specific customer needs, preferences, and values.

By looking at the business systems and channels through which customers are choosing to access the business, analysts can also begin deducing points of needs in the channels and areas where levels of service need upgrading to better serve the client. Most of these analyses should be automated and scalable so they can be applied across the entire system of services, channels, and clientele on a daily basis. Building a consolidated datamart will allow analysts to deliver integrated insights about channel activity and metrics that are key to customer-service by allowing them to publish relevant and timely data analytics and reports about evolving client and system needs.

Related posts:

— Lillian Pierson is a data analytics engineer at Orange County Government, Florida. She also specializes in environmental engineering, GIS, world travel, tech journalism, and would-be digital humanitarianism. You can follow her on Twitter at @lillianpierson

DISCUSS     Email This
Current display:       newest comments first       display in chronological order
Page 1 of 4   Next >
pcharles
IQ Crew
Friday May 17, 2013 12:57:34 AM
no ratings

I know. But you should be in love with the results of what the data produces, not the data itself.

Lillian Pierson
Thinkernetter
Monday May 13, 2013 8:22:48 PM
no ratings

I know exactly what you mean. Good for you, that you got to a stopping point :) I guess I would just like to know what are some of the major differences in how you would approach a BI implementation for B2B vs B2C. Thanks!

B. Krafte
IQ Crew
Monday May 13, 2013 2:56:08 PM
no ratings

Lillian - Sorry for the delay in replying to your comment. I've been buried the past couple of weeks and am just now coming up for air.

I'd love to share what I've learned from my experiences. However given the breadth of the possibilities, can you zero-in on a more specific subset?

Lillian Pierson
Thinkernetter
Wednesday May 1, 2013 8:26:27 PM
no ratings

I thought they sort of had the visualization packages available for that... the problem is more the lack of skils in handling the data and "boiling it down". GoodData and Tableau can handle the visualization for small businesses... but the business will need to hire a skilled programmer to handle the data streams. I bet Pentahoo would have a great Big Data solution for a SBE....

Lillian Pierson
Thinkernetter
Wednesday May 1, 2013 8:22:23 PM
no ratings

I would love to learn more of what your experiences have taught you!

mhhfive
IQ Crew
Wednesday May 1, 2013 7:04:02 PM
no ratings

"You can't change what you can't measure."

Hmm. But some things that you can measure, you also can't change! I can measure the speed of light, but it doesn't mean I can change it arbitrarily.... 

Also, getting measurements on things you *can* measure might also blind you to all the factors that you *can't* measure -- and which might actually be more important.

B. Krafte
IQ Crew
Tuesday April 30, 2013 11:40:25 PM
no ratings

Lillian – Thanks for your comment. Having had roles in both worlds, I agree there are differences. However, they also share a large number of the same or parallel considerations.

sarahp
IQ Crew
Tuesday April 30, 2013 10:48:24 PM
no ratings

I don't think many modern businesses (especially in the tech field) will have too many big data issues. I think the main ones will be the smaller based brands that won't have the big dollars for it or the man power. Maybe someone should create a water downed version of analytic solutions for those who are just starting or don't have the kind of money on big analytic solutions?

Lillian Pierson
Thinkernetter
Tuesday April 30, 2013 10:18:50 PM
no ratings

I totally agree, but it needs to be tested throughly as well. As we all know, assumptions can be very dangerous.

Lillian Pierson
Thinkernetter
Tuesday April 30, 2013 10:17:12 PM
no ratings

Certainty should be established for predictive models, but even with that - we cannot predict the random variables. It is always those random variables that break the system.

Page 1 of 4   Next >
The ThinkerNet does not reflect the views of TechWeb. The ThinkerNet is an informal means of communication to members and visitors of the Internet Evolution site. Individual authors are chosen by Internet Evolution to blog. Neither Internet Evolution nor TechWeb assume responsibility for comments, claims, or opinions made by authors and ThinkerNet bloggers. They are no substitute for your own research and should not be relied upon for trading or any other purpose.
previous posts from Lillian Pierson
Lillian Pierson
Understanding social graphs helps us to form better social strategies by informing us who the key players are and how they function.
Lillian Pierson
In a blog on my personal website, I once mentioned losing 60 followers from a single post about yoga-wear. Today, I'm going to reveal the free tools that I used to tell me this information.
IETV: the thinkerNet on film
5
of
Kim Davis
Big-Data Can’t Always Sell Wine

5|21|13   |   2:23   |   No comments


Whole Foods Global Wine Purchaser Doug Bell told me about some of the constraints on using analytics in the US wine market.
Paul J. Fleuranges
Digital Signage Keeps NYC Subway Straphangers on Track

5|6|13   |   3:51   |   No comments


New York's Metropolitan Transit Authority is conducting a pilot test of digital kiosks to guide subway users to where they want to go more efficiently and at lower cost.
Kim Davis
Fast Forward to the Future

4|23|13   |   2:29   |   20 comments


A look back at tech writing in the 90s makes us wonder where enterprise IT will be 20 years from now.
Mitch Wagner
Google Launches Its Most Depressing Service Yet

4|15|13   |   2:59   |   10 comments


Google's new Inactive Account Manager lets you control how Google disposes of your accounts when you die.
Second Shooter
Argument Over Top-Level Domains Is 'Stupid'

4|11|13   |   2:07   |   3 comments


The whole Amazon.reader debate is a double-stupid. It's stupid to think that there's any e-book buyer who doesn't know Amazon's URL, and it was stupider to let ICANN launch the whole free-form TLD initiative to start with.
Kim Davis
Ladies, Your Tablet Awaits

3|21|13   |   2:22   |   37 comments


ePad Femme is the world’s first tablet “made exclusively for women.”
Wisdom of the Big Chair
NFC Moves Into the Mainstream

3|20|13   |   2:16   |   No comments


While NFC's original goal was to enhance mobile commerce applications, it is finding its way into a number of other uses, which is creating both opportunity as well as challenges for IT departments.
Wisdom of the Big Chair
Integrating Security Into Your Cloud Contract

3|19|13   |   3:35   |   No comments


Enterprises would like to move to cloud computing but are hesitant because they are concerned about providers’ ability to secure company data. Here are some tips that help to ensure that if breaches occur, the business is not left holding the bag.
Brian Baron
How Edmunds.com Collects Customer Information

3|18|13   |   1:15   |   No comments


Edmunds separates customers into segments based on the info it collects on its site and from partners, and uses that to push out custom content, said Brian Baron, director of business analytics for Edmunds.com, at Predictive Analytics Innovation Summit.
Brian Baron
How Edmunds.com Uses Analytics to Customize Site

3|14|13   |   0:47   |   No comments


The automotive website uses propensity modeling to target ads and customer registration forms, said Brian Baron, director of business analytics for Edmunds.com, at Predictive Analytics Innovation Summit.
an IBM information resource
sponsored content
big blue blog
Todd Watson
Todd Watson   5/21/2013   Post a comment
Sometimes business travel can be a royal pain in the you-know-what, and sometimes all things go well with the planes, trains, and automobiles.
an IBM information resource
sponsored content
Expert Integrated Systems: Changing the Experience & Economics of IT
In this e-book, we take an in-depth look at these expert integrated systems -- what they are, how they work, and how they have the potential to help CIOs achieve dramatic savings while restoring IT's role as business innovator.

READ THIS eBOOK
your weekly update of news, analysis, and
opinion from Internet Evolution - FREE!

REGISTER HERE
Wanted! Site Moderators
Internet Evolution is looking for a handful of readers to help moderate the message boards on our site – as well as engaging in high-IQ conversation with the industry mavens on our thinkerNet blogosphere. The job comes with various perks, bags of kudos, and GIANT bragging rights. Interested?

Please email: moderators@internetevolution.com
Internet Evolution – not for thickies
Keep Critical Data With a Knowledge Management System
Taimoor Zubair
Fortune 500 companies lose at least
$31.5 billion a year by failing to share knowledge. A Knowledge Management System (KMS) can help companies significantly reduce these costs.

CLICK FOR MORE
Yahoo Needs to Break Tumblr in Order to Fix It
Joe Stanganelli
As
Mitch Wagner discussed today, Yahoo is acquiring Tumblr. The big Internet debate at the moment is whether Tumblr will be good or bad for Yahoo. Regardless of their stances on the future of Yahoo itself, many claim that Yahoo will somehow ruin Tumblr.

CLICK FOR MORE