Tagged: analytics

Seems anyone can create a list of people to follow – unfortunately when I see list of Top Data people or Data Scientist, it’s always male dominated, not saying they don’t deserve it because they do, but there are many ladies out there that code their butts off and glean insight like a ROCK STAR. So, to correct this, I have compiled a list of great women in Data to follow.


Please follow these users for the latest in Data Science, Analysis, and Quality!


Karen Lopez



Shelly Lucas



Big Data Gal



Dr Emily R Coleman



Jacqueline Roberts



Gwen Thomas



Melinda Thielbar



April Reeve



Sarah Schmidt



Angela Dunn



Cathy O’Neil






Isabel Elaine Allen



Beth Schultz



Emily Carter



Noreen Seebacher



Blaine Kohl



Loretta Mahon Smith



Mandi Bishop



and last but not least – ME 🙂 15 years of crunching data and gleaning insight

Carla Gentry CSPO



I hope you enjoy following these users as much as I do and if I forgot any Data Ladies, please accept my apologies – and send me a Tweet @data_nerd so I can start following you 🙂

Data Science is NOT for everyone



Everywhere you look – a new program or University is teaching data science, while I think it is great for the field…… heads up people, data science is not new and creating a bunch of book smart data people without any business experience is NOT the answer. I started college in ‘93 with a group of math friends, 6 years later I graduated with a BS in Mathematics and Economics but out of 20 who started the mathematics courses at the same time I did, only 2 including me had graduated! Not trying to show off, trying to explain that logic and science are not for everyone. It’s not something that you wake up and decide, I’m going to be a Data Scientist today. Curiosity won’t help unless you have the background or talent for gleaning insight out of terabytes of data. It isn’t as easy as you hear on Twitter of Facebook; you can’t take a course and be ready to handle dirty, unstructured, messy, server breaking data.
So, what can you do? Not everyone is as lucky as I to start right out of college working for RJKA an Econometrical Consulting Firm with DFS as a client BUT there are ways to learn. http://news.stanford.edu/news/2012/september/online-courses-fall-090712.html and http://classweb.gmu.edu/kborne/ are just a couple of example, take courses, learn about MDM http://en.wikipedia.org/wiki/Master_data_management and Data Mining http://www.dataminingarticles.com/data-mining-101.html as well as Data Mining Tools http://www.theiia.org/intAuditor/itaudit/archives/2006/august/data-mining-101-tools-and-techniques/ and please, learn statistics http://search.barnesandnoble.com/Statistics-for-Business-and-Economics-James-T-McClave/e/9780132409353 and learn to write your own code (SQL will always be around) http://beginner-sql-tutorial.com/sql-joins.htm then learn about load balancing quick before you crash a multi-million dollar server and get your butt canned, giggle https://devcentral.f5.com/weblogs/macvittie/archive/2012/10/01/load-balancing-101-active-active-in-the-cloud.aspx – As you see, for those who want to invest their time and talent there are resources out there AND the BIGGEST ONE IS (ta da) Kaggle – a great place to play data scientist but please keep in mind you HAVE TO KNOW how to talk to and present findings to the C suite and or board of directors, Sheldon is a genus but self admits that he CHOKES at the thought of presenting to humans. Last but not least, find a job that works with data and learn as much as you can, I started as a junior analyst and now I own Analytical Solution! Good luck in your adventure but don’t fool yourself, it isn’t easy and if it was EVERYONE would be doing it 🙂

Push verses Pull – are you marketing or spamming

There have been a lot of articles over the years; going into great depth about “Push verses Pull Marketing” therefore I am not going to over kill the subject by regurgitating what has already been written. What I will add is that marketing has changed with the introduction of social media into our daily regimen, analysis and reporting. We try various things when we, break into the world of social media, i.e. “push verses pull” marketing, do we blast our message to the world or do we provide great content and let them come to us? In my time on social media, I have seen links stolen and articles cloned, “how many likes for this” (what?) Facebook post, pins redirected to unintended sites and auto-posting gone mad with old articles from 2010 passed around like “hot news” because no one even bothered to read the article they just wanted to re-tweet someone with high Klout. So, push marketing has definitely taken on a new aspect, it is not just about spitting out your product news to anyone out there, it about misdirection and un-professional behavior. Followers and fans figure this out pretty fast so any sales they make are a single purchase and not about building a loyal clientele. I guess if that is your purpose, you have succeeded but businesses are built on longevity not tricks. I have seen great social media campaigns which made me think, giggle, scratch my head and lean into with anticipation of their next tweet so I know there are many companies that are doing it right. Hats off to the social media teams out there that create great content that goes viral and circles the world, you inspire us to turn it up a notch! Companies like Kellogg’s want to be part of your family, they don’t blast their message to unexpected recipients or beg you to “like” their page, they drip, drip, drip, with their messages, until one days, boom, you need cereal and without even thinking, you are buying corn pops.
It takes time to build a following, good marketers know this and slowly build a loyal following through likes, re-tweets, pins, discussion on LinkedIn groups and providing thought provoking content and ads. Occasionally ads go viral but the norm is to engage and be the 1st product or service that pops into someone minds. Take me for example, I am not unique by any means, they are lots of great people out there to follow. I started my Twitter account in 2010 but didn’t bring in the business aspect until March 2011, since then I have added over 5,000 followers, not because I have a high Klout score, beg for followers or talk about my business every 5 minutes. I spend hours a day searching for relevant content to share with my fans and friend on social media, to educate, inform, entertain and spread the word about analysis, data mining, mathematics as well as good habits in analytics and social media marketing. Not because I want to just give away good content but to form a relationship, to imprint my name, whether it be @data_nerd, Carla Gentry or Analytical Solution, into your mind so when you need research, sentiment or text analysis, social media campaign and analytical marketing you’ll head over to my site and give me a call.
In conclusion, when you are creating your social media marketing plan, keep this in mind, do you want to be a household name or a spammer who “gets and loses” followers on a daily basis, the choice is yours. Blast your message to anyone who will listen or target your message, create relevant content, respect your followers, and follow up with leads in a dignified manner. Engage and show potential clients why they should do business with you, if you have expert knowledge, share with others and promote your field. No matter what strategy you use (push verse pull), showing you and your businesses character might not make you a millionaire but I guarantee it will lengthen your business career and lifetime earning potential. Thanks for taking the time to read this article and have a great day of marketing!

Big Data – reduced to a buzz word



A “buzz word”, that is what data has been reduced too. “Big Data” is now a common phrase used to describe numerous counts of different types of data, social media data, point of sale data, financial data, digital and visual data…. Arg, make it stop. But what is it “really” and what makes it useful versus noise?

Over the course of my career, I have worked for companies of all sizes, with some handling data better than others; the best was actually one of the smallest (go figure). Most companies struggled to figure out what to do with the data they have versus how to get more. Retail and CPG companies that can afford all the latest and greatest BI and data mining tools usually collect and use their data very well since it’s REALLY their bread and butter and without it the competition would eat them alive. Unfortunately they aren’t usually able to “house” the data, making “real time” almost impossible. Smaller companies that have jumped into the data pool (per sae) purchase large amounts of data or gather their own live data but rarely have the insight to know what “is” or “isn’t” important. Example, I sell a 250 dollar yard trimmer, now 250 bucks is a bit steep so I know the average person is not going to buy. So, I would need someone who owned (the norm) or rented and really cared (the outliner), and someone who made above average income (the norm) or someone who saved to make the purchase (since it’s a yard trimmer, we’ll say that this is an outliner) but I only have name and email address, what can I do? Honestly, not a whole lot really, except maybe a mailing list. Say I have name, complete address and email, a little better… you could use the addresses to overlay with federal, state and local data or census data from that neighbor. That would tell you median income, average home price, etc. but without more demographic and financial data, it would still not be sufficient to deduce too much insight. So the kind of data you collect becomes more important than ever, if you want to target your customers think about what it would really take for you to get the best insight.

Next issue, when working with data, one needs to think about its quality, what do I mean by that? Is it accurate and clean data? Take a look at the number of duplicate rows of information and incomplete or N/A data fields, these are very important to note and take action on. Next, how your data is labeled and defined, the “metadata” or data dictionary of your database, it tells you if the data field is a character or numeric, the length (max 255 so watch out for those “NOTE” sections), and if applicable a short description of what the variable actually is. A unique quantifier is preferred, when working with FICA/FICO, we used SSN# but in other cases usually a client ID or purchase id, which may not be unique is used. If multiple purchases or visits, with a non-unique way of labeling, occurs this can be a headache especially when working with live data and adding into the master database. Updates in a data warehouse involve data dumps or extraction, transformation and load to merge new data in with existing data (segmentation is based on some type of quantifier, a hopefully unique variable), sounds easy (not) but it gets worse, the bigger the data the longer this process takes and we haven’t even started talking about unstructured data yet, whew. How are incomplete rows beneficial, if you are looking at web data or basket sales, it can show you were someone abandoned their shopping carts, if it’s a loan application, it can tell you where they stopped, see where I’m headed? Data entry is VERY important, a few fat fingered data sets add up fast when you are talking terabytes of data, especially when they are keys in but a multitude of people.

There is more than meets the eye to data, everyone wants it but if you want it just for the sake of having data, make sure it’s not just noise, what do I mean by noise. Data experts usually take different stances on this one; I’m the, make a mental note but remove for the sake of immediate insight, (null data does not make a pretty spreadsheet) kind of person. I take special note at the end of the evaluation or data analysis but don’t freak out trying to figure out why I have 87 records that indicate the person was over 90 years old or they made 123 dollars a year, mis-entries, errors, fat fingers… no time for them now but will contact IT to correct records later (this part is very important as well, if not corrected that is 87 wasted records and they keep coming up with each analysis).
Unstructured data, what do I mean by unstructured, all data has some type of structure… yes, but take Twitter and Facebook data, it doesn’t fit into a tabular form or model but if you manipulated it (using whatever method you choose) you can still infer insight but it’s messy and sometimes a lot of useless information i.e. Joe ate a sandwich and boy was it good, giggle. Lots to think about, tools for collection of data, tools for extraction and updating data, tools for converting unstructured data into usable information, talent to glean insight out of data. Storage used to be a big deal, but now a terabyte is 50 dollars but a data warehouse or data mart will require multiple servers or a mainframe, now there’s some money. But this is enough for you to think about for now, do you still want to build that database or start a data warehouse, if so please don’t shrug it off as begin a piece of cake, to gain insight the corrects steps are to think first, collect second. Happy Mining!


Social Media ROI

60 years ago some thought TV commercials were a waste of time and money. Is history repeating itself with social media?

I know comparing commercials to social media is not apples to apples but its close enough for my purposes. Flash forward to 2011: with over 300 million Twitter users, it offers an even bigger audience than TV did back in the day.

So why isn’t everyone advertising on social media? The reasons range from lack of staff or time to lack of analysis or return on investment (ROI).

1. Let’s tackle a commercial’s ROI
As humans, we are generally skeptical of new things. No one believed that advertising on television would be as successful as it is now, nor did the Internet grow by leaps and bounds when it first started. Advertising on social media (e.g., Twitter, Facebook, etc.) is relatively new, but it is no more an instantaneous lift than a burger commercial: no one runs out to buy the burger right then.

Like planting a seed, one must wait for social media advertising to grow and mature. Unless your product, service or advertising sucks, you will realize traffic, and in turn sales. Do not become a slave to the peaks and trends of your Twitter analytics. Instead, use your energy to establish yourself.

2. Have a strategy
Gather a strong group of followers by posting for a few weeks before you start selling yourself or your product, and repost subject matter that interests you. You now have a foothold to build on, and should learn from mom-and-pop stores:

a) Treat each customer with respect and you can count on their return business.
b) Show you have nothing to hide and your honesty by settling complaints immediately and publicly.

Track your social media efforts with tools like Google Analytics Social or Twitalyzer. Paid versions are available, but if you are a small business why spend money when it’s not necessary?

Tools like Crowdbooster will tell you the best times to post or tweet to increase engagement. What you post is up to you, but ensure it is not garbage that leaves readers wanting more (you know what I mean). If you present yourself in a professional manner, respect others, engage and share great content, you won’t have any problems attracting followers and making sales.

If you follow thousands, have thousands of followers without sales, you made some errors in judgment on who to follow; you need to find your target audience.

3. Did you do your research?
No way, research!?
Yes, way. Topsy, Kurrently and even Twitter have sentiment search capabilities: see who comes up in a search for your service and/or product, and follow or engage them.
Snow shovels don’t sell in Florida, so don’t follow ‘robots’ and expect to run up your sales. Be logical and market smart – if you have a niche, follow it. Analytics, search sentiment, good curation of relevant stories to share and timing may be the difference between open for, or out of business.

Bottom line
Consider what was going through Joseph Bulova’s mind when he signed a contract for the first-ever TV commercial. Did people think he was wasting his time? Bulova went on to become a household name and the man himself was considered a great business mind…

Be a pioneer – do not let lack of ROI stop you when you see potential value, but always do your homework. The great ones always had a well thought out business plan even when the value was unknown.

Think of those who, at the time, reached millions through little-known channels like billboards, magazines and direct mail. Look at Jay Baer and Peter Cashmore, who make great livings from advertising on relative newcomer social media. I am sure they both would say they treated social media as a business capable of great profits because they saw value.

Thank you for your interest, please keep in mind the above article is comparing analysis of social media now to television commercials 60 years ago, I AM NOT comparing it to our ability to run analysis on commercials today.


How do you become a data scientist?

Modern Day Data Scientist

Modern Day Data Scientist

I have read several articles on the subject, but none of the authors were really “Data Scientist” and they admit that, so I thought it was time that something was written by an actual Data Scientist.

First off, let’s make sure you understand that there’s lots of college involved, no way around that one. If you noticed a lady in the 2nd row, 3rd from the left had a mole on her nose in the last commercial you watched, you might have what it takes, even if you hadn’t thought of Mathematics, Engineering or Econometrics as a field of study. What I am implying is that it’s take someone who is VERY observant to be successful in Data Science. Why, because you deal with such large data sets and large outputs/results, your ability to absorb lots of information quickly and exactly, is your best friend. I can scroll a million records in minutes or run a small SQL script, analyze the results and tell you if that data is bad or corrupt in minutes. Cleansing data is always the 1st step, if this part is left out, I can guarantee you will have lots of N/A’s or characters where number should be, etc… so make QA your friend not your enemy.

What major or course work produces the best Data Scientist? Econometrics and Mathematics as long as they have an additional major in Business, why, because of the logic involved as well as the classic theory of Left Brain people and numbers. Creative is great for making power point presentations but when you have 10 terabytes of raw data, pretty is not the 1st things on your mind. Minor or actively engage in courses that will teach you programming, you don’t need hard core Pearl but you will need SQL skills at the very least. Microsoft Visual Studio, SSAS, SSIS, SSRS package, SAS, SPSS, SQL, Cognos, Macros, Visual Basic are all not only good to know but vital when you have multiple client who use different CRM, BI and ETL tools.

Once the schooling ends, the real world begins. My 1st boss said, “forget everything you learned in College, there is no “bell curve” here; meaning, statistics, programming, mathematics, logics and common sense are only the start. Practice on cleansing data, extracting data, normalizing data, segmenting data, loading data, trending data, modeling…. in other words data data data data data. Never assume your results, never ignore anomalies, do keep a unbiased mind and never scrimp on tools, software or classes. Yes, that’s right I still attend webinars and read like crazy to stay sharp on my tools and technic.

We need more people desperately in Science, Technology, Engineering and Mathematics (STEM) so please consider Data Science as a career. According to the latest study we’re in high demand and considered rock stars according to some.
What can your data do you for? @Data_Nerd :o)

More information doesn’t mean correct information: Do you really know?

I had a gentleman tell me today that he read that companies were becoming more efficient, that more was being done by fewer employees. Wow, really, are we that naive? The truth is that 84% of employees polled said that they would leave their jobs if another position became available (CNN Money). Guess what employers, the economy is getting better and companies are starting to hire again. If you haven’t already lost some of your employees, you will. So, why do stories conflict each other, because no one checks their facts or they put too much faith in what they hear from friend without verification. Recently I was told that “Person X” was an expert at a particular subject, only to find out, not only did this person not know what he was doing, he also caused a rift in the department that caused others to quit. How did this happen, the person in charge of hiring was not qualified to understand the intricacies of the position but his biggest mistake was, he assumed that the resume was 100% correct. In fact a 2010 survey suggests that 53% of perspective employees lie on their resume (click here). So, would some follow up with previous employers or checking references have changed the above scenario? Probably not, suggestions are to mandate a 90 day review and it have completed by the person working closest to the new hire. Co-workers know faster than anyone what is “really” going on. Below is from A Checklist for Success in Hiring Employees (http://humanresources.about.com/od/recruiting/a/recruitingtips.htm) Companies that select new employees from the candidates who walk in their door or answer an ad in the paper or online are missing the best candidates. They’re usually working for someone else and they may not even be looking for a new position. Here are steps to take to improve your candidate pool. • Invest time in developing relationships with university placement offices, recruiters and executive search firms. • Enable current staff members to actively participate in industry professional associations and conferences where they are likely to meet candidates you may successfully woo. • Watch the online job boards for potential candidates who may have resumes online even if they’re not currently looking. • Use professional association Web sites and magazines to advertise for professional staff. The key is to build your candidate pool before you need it. Good luck and remember to always check your facts and follow up on employee complaints.

© 2011 Analytical Solution

I am not a Social Media expert but I play one on TV

I love that one liner from movies so I thought it appropriate for what I wanted to write this morning. There are lots of people out there playing Social Media experts, they promise followers, 1,000’s of them but how are they attaining them? Are they mining for followers from your niche or are they just searching for “follow-back” or others on Twitter who automatically accepts followers? What promises “on paper” did they make you? Did they guarantee your results? Did they guarantee to increase your ROI? NO? Well then, you are just wasting your money and you also stand the chance of these “Experts” or “Guru’s” damaging your brand or your name.

When I first branched off on my own, I envisioned I would be using analytics to increase market share, increase ROI, introduce new products to the market just, as I have been doing for the last 15 years for companies like Firestone, Kraft, Hershey…etc. I never dreamed that my best avenue for introducing and spreading the world of analytics would be Social Media. I had been using social media for years as a “tool” to help keep in touch so why not branch out and use it now.

Some Businesses “get analytics”, they see its importance not only in advertising and marketing but in social media as well. They use my service and others like me, to find their “target audience” or their niche. They depend on the research we provide to get the “Big” picture of what is really going on with their business or product. They know that by using statistics and data mining, they can make a change in their social media efforts. Unfortunately, a majority of the social media marketing community has decided to stick their heads in the sand and pretend analytics isn’t important or “can’t” be done (Oh yes, it can). We have made it easy entry into social media, placing in-experienced and un-professional GURU’s in as valid Marketers. We have been invaded with back seat driving experts who, because they have a Twitter account, think they can be “your” social media guru. Thanks to people like them we now have more spam than ever, you see the same “unique” page post from different URLs (hijacking ENTIRE websites) so the true author may see his or her post from multiple sites. The latest is promises of analysis as well, I’ve seen firms profess that they can handle your data and analysis as well but don’t have the first trained expert on site to achieve this. Gurus or experts focus on quantity over quality, and those results don’t get businesses anywhere. Websites offering 1000 Facebook or other social media fans with a low price are spam that are trying to enforce the already present notion that we need to have a significant social media following to get any kind of ROI.

In conclusion, be careful out there, social media is no different than any other aspect of life, there are good and bad people out there. Research the firm you plan on hiring and ask for references, protect your brand, your company and your reputation by only using professionals (ask for a Business License). If you need analytics assistance, make sure they have a scientific or mathematical background. If you need a social media expert get a “real” one and not just someone who plays one on TV. It’s your money, spend it wisely. If you need assistance in identifying best practices on how to use analysis in Social Media give me a call at 630-673-2345

Have your data warehouse dreams died?

Have you attempted a data warehouse and failed, let experience and expertise lead the way to successfully attaining your goals – Analytical Solution.

The talent pool is short for mathematicians and data miners, and people in general who understand what it take to successfully deal with large amounts of data. Analysis and segmenting large data sets is not for the faint of heart, it require skill and experience that is only gained from day to day handling of transactional data.

Small business owners often spend a large chuck of time planning their company’s operations, with thousands of dollars spent on buildings, equipment, employees and advertising but they forget the one asset they get for free, DATA. Without data, an organization loses its record of transactions and or its ability to deliver value to its customers.

Organizations need to focus on strategic matters on a more or less continuous basis in the modern business world. Business analysts, serving this need, are well-versed in analyzing the strategic profile of the organization and its environment. Analysts are “Subject matter experts” who understand the data and are able to translate the results of data mining into actionable business information.

Data mining has found support in many areas. It has been used by companies like Kellogg’s and Kraft to find their target audience for new products; It has been used by Real Estate agents to determine the probability that a new area of town will thrive; even Police departments have used data mining to identify new crime waves by what is filed in reports.

Let data mining and analysis take your company to the “next” level of success. Don’t let this opportunity to use your free resource “data” pass you by because you don’t have “in-house” talent, Analytical Solution is up for the task!
423-552-2062 for a free evaluation.

© 2011 Analytical Solution

What is Analytical Solution?


Market Research

At Analytical Solution, we offer expertise in the design and execution of market surveys and custom market research to meet the specific needs of our individual clients. Our expert researchers will assist you in obtaining the market insights you need to grow and expand your business. We offer expertise in conducting all phases of both qualitative and quantitative research methods.

Market Research Capabilities

Analytical Solution offers a suite of consulting and market research services that enable our customers to increase market share and profitability. We provide near real-time intelligence and strategic insights to assist in making confident business decisions. We have continuous networking with customers, suppliers and competitors – thus providing you with complete visibility of the whole value chain in composites and various verticals such as automotive, construction, consumer goods, medical, and financial institutes. We have proven interviewing and data collection technique and we provide unmatched data accuracy and integrity. Some of the services offered by us in Market Research Category are:

·     Convert business problems into analytic projects with well-defined deliverables. Let your data work for you not against you. Knowledge is POWER

Market Research

·         Capability

·         Competitive Assessment

·         Concept Testing

·         Customer Analysis

·         Customer Satisfaction Survey

·         Market Segmentation

© 2011 Analytical Solution