Big Data Analytics > The Art of Presenting Big Data



It has been my experience that presenting Big Data requires quite a bit of artistic ability.

I will be talk about the Art of Presenting Big Data among other topics at an event this coming February 21 in Ortigas.

For me there is a clear need to Apply a Process to Present Big Data Clearly
. This process has 3 parts.

  1. Selecting the Appropriate Presentation Format to Communicate Your Findings Effectively to Your Audience
  2. Mastering the Power of Enchantment
  3. Sharing Findings from Big Data to Drive Decisions Within Your Organization

Knowing How to Select the Appropriate Presentation Format to Communicate Your Findings Effectively to Your Audience is where we will stat.

To that end I have a checklist I use before every presentation I share involving Big Data:

  • Know Your Audience
  • Consider Time Constraints
  • How Will The Data Be Consumed?
  • Can The Data and Analysis Be Accessed?
  • Make it Interactive

DMAIPH offers a wide range of analytics centric training solutions for professionals and students via public, in-house, on-site, and academic settings. We tailor each training event to meet the unique needs of the audience. If you need empowerment and skills enhancement to optimize the use of analytics in your organization, we are here to help. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to set up a free consultation on which of our DMAIPH analytics training solutions is best for you.

 

Can Analytics Help a Sari Sari Store?

I had this interesting conversation earlier about analytics.

I started explaining to the person I was sitting next to what I do and he asked can analytics really help any business?

Of course I said yes.

He asked even a Sari Sari store?

For those of you who don’t know much about Sari Sari stores, let me tell you a bit about them.

By far the most common form of self-employment in the Philippines are small, family operated convenience stores. Called Sari-Sari stores, there are an estimated 1 million Sari Sari stores across the Philippines. Per wikipedia, this counts for an estimated 30% of all retail sales in the Philippines.

Sari-Sari, which is Tagalog for variety, are an important economic and social pieces of just about every Filipino community. Most are privately run, family owned and are operated from the front of the owners house.

Commodities are displayed behind a large mesh screen to both allow customers to see what is available and to prevent shoplifting. The most common goods sold are candy, snacks and other non-perishable food items. Cigarettes and mobile phone cards are also popular items for sale. Household needs like soap, detergent and cleaning supplies are also common. Some stores have small refrigerators to offer cold drinks like soda and beer.

Sari-sari stores generally have higher prices when compared to supermarkets which is a tradeoff for proximity to their customers. It is also common to buy single units of a product versus an entire package as paying more to meet a quick need is valued over planning and budgeting bulk purchase over the long term.

Some Sari Sari stores also offer credit to neighbors. Micro lending of this scale is wide spread and generally done under the rule that if the credit is not repaid, the store owner will report this to the local government officials.

Some Sari Sari stores barter goods and services with farmer, fishermen and other businesses.

Most Sari Sari store proprietors buy their goods at supermarkets then mark up the prices for resale (on the average 20%). In some areas, businessmen make act a middle man offering bulk products to the Sari Sari store.

It is my belief that most Sari Sari stores can benefit from a simple strategic business plan and some very basic analytics.

My understanding is that Sari Sari stores operate on a very tactical level with little long term planning and operate with little market awareness.

If I ever to consult with the owner of a Sari Sari store, my initial approach would be to develop a business strategy plan and build a basic analytics process to gather data and provide a proof of concept.

This approach would be broken into the following steps:

  1. Business Strategy Assessment – How do they conduct business?
  2. Competitive Landscape – Who do they compete with?
  3. Demographic Profile – Who are their customers?
  4. Market Assessment – How much upside is in their market?
  5. Inventory Analysis – How to they optimize inventory?
  6. Facilities Assessment – Are they getting the most of their location?
  7. Risk & Security Assessment – What risks do they face?

I will flesh out each of these steps in upcoming blog posts.

Once I have complied data from these 7 steps, I can develop a business strategy plan unique to the individual Sari Sari store.

After my presentation of the business plan, I can make a determination if they Sari Sari store will enter Phase Two of the plan.

I would work with the proprietor store for a set period of time in a consulting role to determine viability of operations and if they meet our program standards (detailed later in this document).

In addition to offering a consulting solution, through my company, I can also offer additional services including cash management, accounting, marketing, inventory and fulfillment assistance, and other solutions as they arise.

Its my experience that the busiest Sari Sari stores offer something unique. Some might have an ice cream maker, or a special dish they prepare, or some have home baked goods. Regardless, they generally have something that sets them apart from a store that just offers traditional goods.

So, the final piece of my involvement would be cross selling our unique products to Sari Sari stores in need of a unique product to build their business around.

After that consultation, I would expect that three things would happen:

  1. the Sari Sari store proprietor would have a better grasp of a strategic business strategy.
  2. the Sari Sari store would increase profits and
  3. the Sari Sari store would expand its customer base and build up loyalty with existing customers.

So, to get back to the question… how can analytics help a Sari Sari store?

By applying some lessons from the corporate world.

Dr. Data_Analytics in the Philippines

Analytics in the Philippines – The Philippines is at the center of the action when it comes to solutions to the global need for analytics. Blessed with a solid foundation of young, educated and English speaking workforce, companies around the world are look for Filipino analytics talent to fill analytics positions. DMAIPH was set up to facilitate these solutions and bring the talent and the business together. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly so we can help you take advantage of this unique global opportunity.

 

The 3 Pillars of Small Business Analytics

When I consult with small business owners, there are 3 areas where my guidance generally has the most impact. I call these areas the 3 Pillars of Small Business Analytics.

The first pillar is a Competitive Landscape. I have found that very few small business owners really have a handle on the competition.

A competitive landscape analysis will reveal threats and opportunities that generally are not obvious to a business owner who focuses most of his/her energy on running the business itself.

Some of the data points you can capture and analyze include pricing, location, business size, quality, scope of business, diversity of product offering and of course revenue.  You would be surprised to find how easy it is to gather all this info.

Knowing where your products and services stack up against your competition is a key to prosperity. To achieve this understanding you need to use analytics.

The second pillar is a Demographic Profile. I have also found that very few small business owners really understand the demographics around their business.

A demographic profile analysis will illustrate how closely your customer base mirrors the actual population around your business. In many cases small businesses are not positioning their services correctly based on the opportunity in their market.

11709268_10153506561077425_1608720566061502683_n

Data to include would be traditional demographic markers like age, race, sex, family status, financial status, economic state, etc. There is a ridiculous amount of data on the internet that can be mined free and easy.

Making sure your business is properly positioned to take advantage of your arket will ensure more long term success. The data is out there; you just need to know how to bring it into your analytics process.

The third pillar is Customer Insights. With the boom in social media, most small businesses have not figured out how to capture and analyze all the information being published and shared about their business.

Customer Insight analysis allows a business owner to stay on top of problems and identify how customers feel about their business quickly.

We all know how quickly things can go viral and having a good tool to capture customer sentiment in social media is generally the most overlooked aspect of running a small business.

Positive and negative reviews, trending items, number of likes, follows and shares, are all items that can be rolled into customer insights. You can combine this with surveys, focus groups and loyalty programs among other things to get a full picture of your business.

If you are a small business owner, decision-maker or analyst then focusing on these analytics pillars will make all the difference in the world.

And the best part, is they are all free and easy to bring into your business.

Small Business Analytics – The field of small business analytics is just starting to blossom as companies are looking for more data-driven decision-making to prosper in the age of Big Data. DMAIPH is at the fore front of providing analytics training, consulting and outsourcing options to small businesses. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to set up a free consultation on how to get more analytics in your small business.

 

 

 

 

Analytics for the Small Business

Analytics is about looking for patterns in data to help answer questions. Most businesses use analytics to help ensure more data-driven decision-making.

No matter the size, scale or scope, every business generates a wealth of business data. Every business has an opportunity to uses that data to drive more intelligent decisions.

The primary people responsible for conducting analytics on the massive amounts of data we have today are analysts. Analysts are skilled in using various technologies and methodologies to identify, inventory and integrate large amounts of data quickly.

The term analytics can often be used interchangeably with statistics and data science. What separates analytics from disciplines like statistics and data science is generally the speed of the analysis and the focus on solving business problems.

The most common form of analytics is business analytics that are generally used by owners, senior leaders and decision-makers to investigate problems, validate assumptions and to guide strategic planning. As a generalist, business analysts can help in a number of areas of the business.

Business analysts are therefore the most common type of analyst, especially in a small business. If you do a job search on the title analyst, as many as half the posting will likely be business analysts. However, analytics can be used in an almost limitless number of business functions in specific areas like HR, recruitment, marketing, finance, and so on. Each one can have its very own analyst.

Analysts have been around a long time, but recent technological advances have both allowed us to produce and capture more data as well as give us the ability to analyze immense data sets quickly. Thus we are amidst a huge boom in the applications of analytics and the need for analytics talent across the globe. Analytics is something just about every business leader is trying to figure out how to use more effectively in their business. To add to our challenge, the demand for good analysts is booming just as fast as the explosion in big data.

As a result, there is a huge shortage of people who are skilled in working with data to answer questions and solve problems. This is why you have seen the number of analyst job postings increasing at an amazing rate. In the first few chapters of the book we will discuss the quickening demand for analytics talent and why it is so hard to find good analysts, especially at the small business level.

If you are a business leader, manager, owner, and/or executive are not actively trying to surround yourself with analysts and if you are not infusing an analytics centric culture in your business, you will most likely soon see your business fail.

1075177_10151826941667425_1417094118_n

A small business needs analysts to make sense of big data, manage the storage of the data, and know when to use which of the 3 types of analytics (descriptive, predictive, and prescriptive). To be effective, analysts need to have business intelligence tools to create data visualizations and build business dashboards.

If you need an analyst or want to be trained in analytics, connect with me and I can show you how to get started.

Small Business Analytics – The field of small business analytics is just starting to blossom as companies are looking for more data-driven decision-making to prosper in the age of Big Data. DMAIPH is at the fore front of providing analytics training, consulting and outsourcing options to small businesses. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to set up a free consultation on how to get more analytics in your small business.

Big Data Analytics: Using Business Intelligence Tools – 7/11/17 in Ortigas

A good analyst uses Business Intelligence Tools like Batman uses devices stored in his utility belt.

Per Wikipedia, business intelligence (BI) tools are “a type of application software designed to retrieve, analyze, transform and report data for business intelligence. The applications generally read data that have been previously stored, often, though not necessarily, in a data warehouse or data mart.”

Knowing what business intelligence tool to employ to what data set in order to conduct analysis and present your findings requires a thorough understanding of what tools are available and what they can do.

The key general categories of business intelligence applications include:

  • Spreadsheets
  • Reporting and querying software: applications that extract, sort, summarize, and present selected data
  • Online analytical processing (OLAP)
  • Digital dashboards
  • Data mining
  • Process visualization
  • Data warehousing

By far the most common business intelligence tool used is MS Excel. Having at least a intermediate masterly of Excel is a good start in understanding how business intelligence tools work.

Learning to run formulas, insert pivot tables and produce simple visualizations using charts and graphs give a foundation in how to take data and do something with it to inspire analysis.

Using Excel also teaches you how data needs to be structured, formatted and managed. You can’t run even basic analysis activities if your data is not encoded in a way that your tools can make sense of.

Once you have mastered the use of Excel then the logical next step is using BI tools that pull data from Excel. For example, Tableau is a BI tool that can extract data from Excel to build more powerful data analysis and visualizations.

BI tools can also be used to mine data from large data storage systems like data warehouses, data lakes and data marts. Again, understanding how data is structured in important. Knowing how queries are written (for example in SQL) to extract data is important.

If you are looking to get a better understanding of what tools you should be using to analysis the data in your business, you can join my next training seminar (July 11, 2017) in Ortigas.

jobspicture2

Analytics Training – DMAIPH offers a wide range of analytics centric training solutions for professionals and students via public, in-house, on-site, and academic settings. We tailor each training event to meet the unique needs of the audience. If you need empowerment and skills enhancement to optimize the use of analytics in your organization, we are here to help. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to set up a free consultation on which of our DMAIPH analytics training solutions is best for you.

Most Analysts Are Spending Only 20% of Their Time on Reporting

In many cases reporting is either something that is set and stone and just needs to be filled or there is a time crunch forcing quick and dirty reporting.

Little time is devoted to using the data for storytelling, maximizing data visualization and really providing the audience exactly what its needs.

% Finding Analyzing Reporting
10 12% 6% 33%
20 14% 10% 39%
30 20% 31% 24%
40 6% 14% 2%
50 31% 16% 2%
60 14% 18% 0
70 0% 0% 0
80 0% 2% 0
90 0% 0 0
100 0% 0 0
       

Ideally, at least a third of the time should be spent post data gathering and analysis to really give the end user of the data the things they need for intelligent decision-making.

A full one-third only spend 10% of their time on reporting, which to me means that there is a lot of the waste in their analytics process.

If you take a full 40 hour week to complete a high priority, high value report but only have Friday afternoon to boil down your finding into a report, it is highly unlikely that your report will fully capture the fruits of your labor.

However, if the time frame is even shorter… you have to do all this in one day, you are just getting to the reporting phase at around 3:30pm.

You have less than an hour and a half to summarize you methods and boil your findings into a few points.

Making sure you craft a compelling story to really influence decision-making based on intelligent data analysis is likely impossible.

Data is based on a survey I sent to 3,000 of my LinkedIn connections who are either analysts or work closely with data and analysis.

Analytics Survey – DMAIPH conducts quarterly analytics surveys to collect data on current trends in analytics. We specialize in surveys that assess analytics culture and measuring how aligned an organization is to using data and analytics  in its decision-making. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to find out more about how DMAIPH can conduct surveys to help you assess the analytics culture in your business.

 

 

DMAIPH Quick Data Survey

A few months back I sent a quick survey to 3,000 of my LinkedIn connections who are either analysts or work closely with data and analysis.

Here is the question I asked.

Greetings!  I’m hoping you can help me gather some data for a book I’m working on. If you had to breakdown the work you do into 3 buckets; finding data, analyzing data and reporting data, what would the % of each be? A quick reply with your breakdown would be hugely helpful in my research. Thanks!   Dan Meyer, Analytics Champion, www.dmaiph.com

I got back over 400 replies.

Here is how they broke down.

 

% Finding Analyzing Reporting
10 12% 6% 33%
20 14% 10% 39%
30 20% 31% 24%
40 6% 14% 2%
50 31% 16% 2%
60 14% 18% 0
70 0% 0% 0
80 0% 2% 0
90 0% 0 0
100 0% 0 0
       

The higher the %, the more each analyst spent time doing that particular phase of analytics.

Here are some of my takeaways from this simple (and very nonscientific survey)

  • I was surprised to see 45% spend half their time or more on finding data. To me this is one of the telling signs that Big Data has led to a shortage of top analytics talent.
  • Only 1 out of 4 analysts are spending 20% of less of their time finding data. These are generally senior analysts, well established in their company.
  • Only half of my analyst connections are spending 40% of more of their time on conducting analysis. With significant time spent on finding and/or reporting data you can imagine a lot of important discoveries are being missed and opportunities lost.
  • Only 1 out of 3 analysts are getting spend my recommended 50% or more of their time actually doing analysis work.
  • Based on my survey, reporting gets shortchanged a lot. All in, 96% of respondents spend 30% of their time of less on reporting.
  • My recommendation is that you spend about 30-40% of your time on the reporting aspect, and sadly only 4% of my analytics connections are able to do that.

In an ideal world, I would expect an analyst to spend no more the 30% of their time on finding data, and at least 30% on reporting their findings, leaving more or less 40% to do the actual analysis.

IMG_1310

This breakdown is based on my own experience as an analyst as well as seeing how analyst working for data-driven companies work.

Only about 30% of my 400+ analytics focused LinkedIn connections come close to meeting my recommended breakdowns.

Which means I have a lot of work to do.

Analytics Survey – DMAIPH conducts quarterly analytics surveys to collect data on current trends in analytics. We specialize in surveys that assess analytics culture and measuring how aligned an organization is to using data and analytics  in its decision-making. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to find out more about how DMAIPH can conduct surveys to help you assess the analytics culture in your business.

 

3 Tips to Maximize the Potential in Your Data

Data is the lifeblood of the 21st Century business.

If you aren’t using your business data to optimize your processes, increase your profits and fuel your decision-making, then you are behind the times.

So let me give you 3 tips to maximize the potential in your business data.

Tip #1 – Map Out Your Data Environment

Tip #2 – Identify Your Data Geeks

Tip #3 – Get On the Same Page

Most businesses don’t have a good map of how their data flows through their business. Just about every employee, every team and every location is stock full of data that can be useful. But, in most businesses there is little understanding of how it is all connected.

You need to know how data is acquired, how it is stored, and how it is accessed. How often is it refreshed? How clean is it? How valid is it? If you have answers to these questions you can build a map of your business data. Like a flowchart.

As you map out the flow of data in your business, you can also identify the data geeks in your business. The ones who understand the value of using data to make decisions. The curious ones who ask a lot of questions. You need to empower these people.

Once you have a data map and you have brought together your data geeks, then you need to get them all on the same a page.

I’d suggest bringing in a consultant who can give you a new and unbiased perspective on how to deal with analytics roadblocks. Places, processes and people in the business who aren’t in synch.

IMG_6912

Another option would be to send the team to a training class facilitated by an expert… someone like me.

If you need a place for your team of data geeks to get outside the box an get on the same page, I will be facilitating a training class on February 21 in Ortigas.  Send us an email @ analytics@dmaiph.com to sign up or request more details. 

I will help you come up with a analytics action plan to help you start taking advantage of the business data you have in order to increase efficiency and grow profits.

Analytics Training – DMAIPH offers a wide range of analytics centric training solutions for professionals and students via public, in-house, on-site, and academic settings. We tailor each training event to meet the unique needs of the audience. If you need empowerment and skills enhancement to optimize the use of analytics in your organization, we are here to help. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to set up a free consultation on which of our DMAIPH analytics training solutions is best for you.

Data Analytics Training on Feb 21

Did you know that most successful businesses have solid data analytics in place across their entire organization?

Organizations that invest in data analytics generally make much better business decisions then one’s that don’t.

In fact, IBM found a few years back that companies who use data analytics are up to 10x more efficient and 33% more profitable the ones who don’t.

By bringing data together data from across the business, companies can get real-time insights into finance, sales, marketing, product development and much more.

Data analytics enables each team within the business to collaborate, achieve better results and outsell the competition.

Join us on February 21, 2017 in Ortigas, and learn how to turn your business data into insightful and actionable analysis.

img_7737

Analytics Training – DMAIPH offers a wide range of analytics centric training solutions for professionals and students via public, in-house, on-site, and academic settings. We tailor each training event to meet the unique needs of the audience. If you need empowerment and skills enhancement to optimize the use of analytics in your organization, we are here to help. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to set up a free consultation on which of our DMAIPH analytics training solutions is best for you.

Why I Know I Can Help

All my life I have enjoyed helping people.

I tutored a lot throughout my education.

In college I set out to be a teacher. To not just help, but to educate.

Being in a classroom was not enough, as I learned the whole world can be a classroom.

As my skills in analytics increased, my ability to help more people make data-driven decisions increased as well.

Now I am at a point where I know a lot about a lot.

Now I have gotten pretty good at sharing what I know in ways that empowers and inspires others.

I have been doing this for several years now.

Talking about analytics, blogging about data-driven decision-making and writing books about how to use analytics.

This is why I know I can help you too.

Everyone needs help finding the right data.

Everyone can use new perspectives on how to conduct analysis.

Everyone benefits from sharing data and analysis to drive a strategy forward or to solve problems.

14285276_10154554275492425_804549674_oBig or small. Old or new. No matter what industry. All companies need to unlock the insights in their data to be successful.

Some do it a lot better than others. A few may actually be so good at what they do that it may seem they don’t need help. But odds are you are not one of them.

Data is everywhere. We all do some sort of analytics. But we never have enough.

Being an analytics champion, striving to help people be better at what they do is what I am all about.

That is why I know I can help you.

Small Business Analytics – The field of small business analytics is just starting to blossom as companies are looking for more data-driven decision-making to prosper in the age of Big Data. DMAIPH is at the fore front of providing analytics training, consulting and outsourcing options to small businesses. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to set up a free consultation on how to get more analytics in your small business.