The Analytics of Project Measurement

Peter Drucker perfectly summed up why big corporations rely so heavily on analytics when he said “What gets measured, gets managed.”

A successful analyst is able to remove the noise when analyzing data and isolate what matters to his or her organization.

With most companies collecting large amounts of data, you need to be both talented and disciplined to pinpoint key insights that can yield value.

In the corporate world, business analytics is widely use to track, analyze and report Key Performance Indicators (KPIs).

KPIs are rolled up to senior leadership to drive business strategy, identify and mitigate risk and to optimize operational productivity.

This approach is very similar to the way projects in the Measurement and Evaluation are tracked, analyzed and reported.

I would define measurement simply as the act of measuring to ascertain the impact, size, level of success, etc. of a specific data set.

There are many components to measuring projects making sure the project is on schedule, stays in scope, is not over budget, the quality of work is up to par, the end goal of the project remains relevant, and finally if the project is ultimately deemed a success.

A foundation in analytics will contribute to a more optimal and efficient process of measurement. Like businesses do with KPIs, you should start will identifying that are the key measurements your project will be judged on.

Once you know those data points, then figure out how to collect them, analyze them, and report them.

At each step you can look for new data, validate existing data and blend data from other sources to add value to your measurement efforts.

Once you get to the reporting phase you can look for cutting edge techniques in data visualization and interactive reporting like dashboards to help educate and empower your audience.

That is how it is done in the corporate world where business analysts boil down massive amounts of big, often unstructured data into a few bullet points that allow decision-makers to take action.

When it comes to the Measurement of Project Evaluation, understanding various analytics solutions can make all the difference.

Analytics Education – Facilitating a mastery of the fundamentals of analytics is what DMAIPH does best. All across the world, companies are scrambling to hire analytics talent to optimize the big data they have in their businesses. We can empower students and their instructors with the knowledge they need to prepare for careers in analytics. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly so we can set a guest lecturer date, On-the-Job Training experience or other analytics education solution specifically tailored to your needs.

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.

The Self-Imposed Ceilings of Two Filipino Friends

I recently had two conversations on FB that happened simultaneously. Its amazing how we can do that now days, be engaged on two (or more different topics) with different people at the same time. But that’s a conversation for another time.

Right now, I want to talk about self-imposed ceilings people put on themselves.

One conversation was centered on being stuck in their current station in life.

The other conversation was about a resistance to embracing non-traditional learning methods.

In both cases, I was in empower mode. Trying to inspire both hope and self-determination to not continue down a path that seems locked in.

I will be the first to admit that as an educated, middle class, straight, white American male, there are few ceilings in life for me to break then just about every other demographic on the planet.

And most likely, my recognition of that at an early age has thrust me forward on a lifelong quest to help others who don’t have all the privilege I enjoy.

I am convinced that the blessing I have enjoyed in life need to be paid back in the form of me trying to uplift others to achieve success in life like I have.

And through a series of circumstances (which feel like a divine plan) I have ended up focusing most of my empowerment efforts in the Philippines. I love working with students and young professionals interested in analytics careers. That is what I have devoted the 2^nd half of my life too.

And both conversations are stronger reminders that I am doing exactly what I was created to do.

Holding the ladder, or offering a hammer, or identifying a new approach to breaking through self-imposed ceilings for Filipinos has over the years become my great cause.

My Analytics Story – My passion is solving problems by bringing together the best talent, cutting edge technology and tried and true methodologies. DMAIPH is all about empowering people towards better Decision-Making through the use Analytics and business Intelligence. This is what I do best. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly for a free consultation about getting more analytics into your career and your business.

Survey Results: Devote More Time For Data Analysis

Most Analysts Spend 50% of Their Time Finding Data

%	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

Most analysts spend most of their time finding data.

Among other thing this can mean they are setting up data mining or data gathering process to look for the data or it can mean they reviewing their data for relevancy.

My experience is that when you spending this much time on the finding the right data phase it reflects a poorly structured data environment or a unfamiliarity with the data needed.

Dirty data is also a big time waste.

Experience is the best solution for challenges with finding data. The fact the finding phase % is so high speaks to both the explosion in the 3 V’s of Big Data (Velocity, Volume and Variety) as well as the number of analytics newbies.

To me this should be no more than 20% of your time.

I expected finding data would be the biggest chunk, but was surprised that over 50% of my analyst connections using at least 40% of their time finding data.

If you have one day to answer a key business question, this means you are using your entire morning just finding the data.

When you get back from lunch you haven’t even started the actual analysis yet and the clock is ticking.

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.

Quick Analytics Career Question

Greetings to You My Valued LinkedIn Connection,

I was talking with a young professional just getting started in his analytics career. During our conversation we discussed what is most important to being a great analyst. With that in mind, I’d ask you to share your thoughts.

In your opinion, of the following ways to learn about analytics, which one has been the most important in your career path?

Formal Education – A degree or certificate in an analytics related field.
Self-Learning – Using trial and error and online resources.
Subject Matter Experts – Being trained/mentored by an expert.
Seminars/Workshops – Attending events to acquire new knowledge.
Technical Training – Attend training on specific technical areas.

Thanks for sharing. As always I will roll up all the replies I get and blog about it.

Dan Meyer, Analytics Champion, http://www.dmaiph.com

How Does a Foreigner Become a Successful Speaker in the Philippines?

“As a foreigner, how do you market and sell yourself as a speaker in the Philippines.”

A good friend of mine asked me that a little while ago.

After letting it rattle around in my head a bit, I came up with this reply.

As cliché as it sounds you have to be yourself. Although high powered, dynamic speakers can come to the Philippines to speak and make money, the ones who keep coming back are the ones who are authentic.

I also understand the heart of the Filipino. I am just one of a network of maybe several dozen Philippines based, non-Filipino speakers who routinely are asked to speak at conferences and seminars. The fact that we have expertise in our fields of specialty is important, but I think what’s more important is that we all have chosen to live in the Philippines. That makes a significant difference.

To a person not familiar with the Philippines, who is just visiting to be a speaker, it will be much harder to really understand the heart of the Filipino. And therefore you would have to work much harder to be an impactful speaker. There will always be a lot of value in sharing knowledge and being a subject matter expert, but if you can’t put that in context of what it means to live and work in the Philippines, you will likely not succeed long term.

That said, I can point out a few things that I think would help a visitor who really wants to learn what it takes to know be successful in the Philippines.

Get outside the comfort zones. Most foreigners stay in relatively rich, safe and easy to get around areas in Metro Manila. To really get to know the Philippines you need to go to the palengke (market place), ride a Jeepney (local transit) and eat some street food (I love BBQ pork on a stick). Now, I recommend you go with a local your first time, but if you can talk about these experiences, you audience will be able to relate to you and have much more respect for you.

Traffic congestion is horrible in Metro Manila. Its an easy target for a shared experience. Saying you were worried you might be late because “Traffic sa Edsa” (traffic was bad on EDSA, the major north-south traffic artery in Manila) will also help. Actually just learning and using a few Tagalog phrases will make a huge difference.

Another suggestion I would make is don’t use up most of your time talking. Breaking into small groups discussions and having interactive learning activities will take the burden off of the audience having to always listen to having a fast-talking and intelligent, foreigner. It can be very intimidating for the audience when that happens. They end up getting, what Filipinos humorously refer to as “nosebleed”. Too much English, too fast and with too much information being the cause. So building in breaks from you speaking is another key to success.

The final suggestion I’d offer my friend, would be to be social. Mix with the audience before the event starts. Be ready to say Maghanda Umaga (Good Morning) when they come in. After the first session and you are on AM break while everyone is having snacks, be ready to mingle some more. And at the end, build in time to take a group photo and group pics. The Philippines is proud to be the most Social Media driven country in the world. Selfies reign. Embrace that fact and you will win a lot of support.

As for marketing, social media and mobile are of paramount importance. You have to push a lot of mobile friendly content through social media to really draw attention to you and your training. And the more that you do to show your interest in empowering Filipinos the more success you will have.

Hope that helps!

Big Data Analytics:Big Data—It’s Not Just Size > 2/21/17

I will be speaking on February 21, 2017 at Discovery Suites, Ortigas Center, Pasig City on Big Data Analytics and Business Intelligence.

With that in mind, I wanted to go into a little more detail about each section, starting with…

Enabling Your Business to Make Smarter Decisions Section 1 : Big Data—It’s Not Just Size

Participants will learn to Describe the Importance of Effectively Analyzing Big Data in Business Today . Being able to explain analytics to non-technical people is very important for any analytics solution to work.

We will also come up with a Data Map to Analyze the Big Data in your business. A data map allows you to see how data comes into the business, where it is stored and how it is accessed. Knowing you data environment is key to having clean and valid data in your analysis.

Another goal will be Establish Clear Objectives When Analyzing Big Data. Knowing exactly what your end user needs, how they want your reports and what will happen to the fruits of your analysis will allow you to be much more value to the business.

I will show attendees how to Recognize and Apply Various Data Collection Methods . Way to often we get stuck by not having documented are process clearly. Having an easily traceable and repeatable process will make your analytics life much easier.

In addition, we will talk about how to Identify and Resolve Problems Associated with Data Collection . Not all data is good data. In fact cleaning data can eat up a lot of time, but it’s a better alternative to reporting based on bad data.

We will discuss the difference between Data Warehouses and Data Lakes. Knowing how data is used in your organization, who has access to it and what they do with it goes a long way in making sure your entire organization becomes more data-driven.

Finally, we will determine when to use Data Blending in your analysis. How to take all of the Big Data you have both inside and around your business and bring them together to give you a 360 degree view of things is also very important to success.

Thats section one… i’ll over the next 3 sections over the next few days.

If you are interested in attending this training, I can connect you with my good friends at Ariva Events Management who will be facilitating the program.

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 Spend 50% of Their Time Finding Data

Most analysts spend most of their time finding data.

%	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

In fact, most analysts I know spend 50% of their time finding data.

Among other thing this can mean they are setting up data mining or data gathering process to look for the data or it can mean they reviewing their data for relevancy.

My experience is that when you spending this much time on the finding the right data phase it reflects a poorly structured data environment or a unfamiliarity with the data needed.

Dirty data is also a big time waste.

To me this should be no more than 20% of your time.

I expected finding data would be the biggest chunk, but was surprised that over 50% of my analyst connections using at least 40% of their time finding data.

If you have one day to answer a key business question, this means you are using your entire morning just finding the data.

When you get back from lunch you haven’t even started the actual analysis yet and the clock is ticking.

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.

The Analytics of Measurement and Evaluation

By taking inspiration from the way corporations use business analytics to optimize their Big Data, our Program Measurement and Evaluation processes can be greatly enhanced.

To understand the connection, let’s start with the mission of the Measurement & Evaluation program.

“The ability to effectively evaluate projects, programs and processes is becoming increasingly essential to organizational success today. American University’s online Master of Science (MS) in Measurement & Evaluation provides you with the knowledge to lead these evaluation efforts and the technical skills needed for analytically demanding roles in upper management.” ¹

A good analytics solution constructs a universal framework for collecting, analyzing and utilizing data to determine project effectiveness and efficiency.

Likewise, an efficient measurement and evaluation of projects, programs and policies using analytics should ensure success. An analytics centered approach will likely work with corporate, non-profit and governmental organizations across various sectors and industries.

We can look specifically to two key business analytics concepts I have used in my twenty plus years of analysis work; Key Performance Indicators (KPIs) and Data Visualization. The key to my success was my ability to answer important business questions using analytics.

Analytics is generally defined as the discovery of patterns in data that provides insight and identifies opportunities. As Carly Fiorina, former CEO of HP said about analytics, “The goal is to turn data into information, and information into insight.” ²

Organizations that invest in analytics generally make much better business decisions then one’s that don’t. In fact, IBM found that organizations who use analytics are up to 12x more efficient and 33% more profitable. ³

In the corporate world, business analytics is widely use to track, analyze and report Key Performance Indicators (KPIs).

KPIs are rolled up to senior leadership to drive business strategy, identify and mitigate risk and to optimize operational productivity.

This approach is very similar to the way projects in the Measurement and Evaluation are tracked, analyzed and reported.

So we need to ask ourselves, what are the KPIs for the project, program or process we are measuring? What points of data need to be captured, analyzed and reported to determine success?

A successful analyst is able to remove the noise when analyzing data and isolate what matters most to his or her organization. That is what is at the heart of measurement, knowing what data is important and what is not.

Once we have the right data, we can measure what the data tells us to determine success, causality, impact… whatever the outcome may be.

A quote often attributed to management guru Peter Drucker perfectly sums up why big corporations rely so heavily on analytics when he said “What gets measured, gets managed.”

Similarly, policy decisions can be made based on what is measured. Project funding can be impacted by what is measured. Process optimization can be directed by what is measured.

Once we are able to measure what is truly important to policy-makers, managers and decision-makers, we need to make sure we present the data in a compelling way.

This is where data visualization comes in.

I often make the analogy that if a picture is worth a thousand words, then a good pie chart is worth a thousand rows of data.

We all know that most people learn more by seeing something then by reading or hearing it. Data visualization takes that a step further.

Data visualization is not only important to presenting our insights but also for exploring the data for insights. Most people find it easier to process information when it is in the form of a picture then a collection of data.

Chip & Dan Heath, Authors of Made to Stick, found that, “Data are just summaries of thousands of stories – tell a few of those stories to help make the data meaningful.”

The ability to take all of the data gathered in the measurement phase and use it in the evaluation phase will make a significant difference in the success of the project, program or process you are working on.

According to the Office of Planning, Research and Evaluation, “Program evaluation is a systematic method for collecting, analyzing, and using information to answer questions about projects, policies and programs, particularly about their effectiveness and efficiency”. ⁵

Data Visualization can be used to paint a picture of a program, project or policy that influences outcomes based on the KPIs. And by appealing to the basic human fascination with stories, a persuasive graph, chart or infographic can make all the difference in the world.

By adopting the business analytics concepts of KPIs and Data Visualization, and applying them to the world of programs, policies and projects, you can find the same level of success I found in the corporate world.

American University, “Certificate in Measurement & Evaluation” http://programs.online.american.edu/online-graduate-certificates/project-monitorin Accessed October 20, 2016
Carly Fiorina Speech from December 6, 2004 http://www.hp.com/hpinfo/execteam/speeches/fiorina/04openworld.html . Accessed October 20, 2016
Simon Thomas, Senior Analytics Consultant for IBM https://youtu.be/Zi8jTbXnamY . Viewed October 20, 2016
Chip & Dan Heath, Authors of Made to Stick, http://heathbrothers.com. Accessed October 20, 2016
OPRE, http://www.acf.hhs.gov/opre/resource/the-program-managers-guide-to-evaluation-second-edition. Accessed October 20, 2016

Big Data Analytics and Business Intelligence

Enabling Your Business to Make Smarter Decisions

Are you tired of being under constant pressure to make the right number-based decisions for your organization?

Are you too often overwhelmed by an out-of-control flood of numerical information, much of it conflicting and confusing?

Big data is booming ast as organizations devote new technology resources to tapping the terabytes (if not petabytes) of data flowing into their organizations.

Today big Data is flooding into the business both through internal processes and externally via social media.

What does this all mean for business intelligence (BI) users and systems?

With all the attention on advanced analytics for big data, what’s the play for BI?

Integrating advanced analytics for big data with BI systems is an important step toward gaining full return on investment.

Advanced analytics and BI can be highly complementary.

Advanced analytics can provide the deeper, exploratory perspective on the data.

BI systems provide a more structured user experience through there richness in dashboard visualization, reporting, performance management metrics, and more can be vital to making advanced analytics actionable.

Recently on December 6, 2016 I was at Astoria Plaza, Ortigas Center, Pasig City for a dynamic and empowering one-day training on Big Data Analytics and Business Intelligence.

Course Description:

Make smarter business decisions using these powerful data analysis techniques

Information is supposed to make us smarter, but more often than not, it simply overwhelms us.

This program is for you if you feel like you’re drowning in data and unsure which data to use to drive your company initiatives.

The truth is that the amount of data available to help run your business is greater than ever before. To effectively use this information, managers must consider the practical side of big data…what matters to you is how do you grow and build a team to make smarter decisions.

Much of the information out there just discusses the promise of the data deluge. The challenge is not the volume of data but rather the judgment needed to use it.

This seminar goes beyond the qualitative side of data analysis to explore proven quantitative techniques and technologies for identifying, inventorying and integrating data, so that more informed and reliable business decisions can be made.

Learning Objectives  

Apply Best Techniques and Cutting Edge Technologies to Organize, Interpret, and Summarize Quantitative Data
Create a Process to Analyze Data and Identify Patterns Not Apparent at First Glance
Reduce “Analysis Paralysis” and Go from Hard Data to Well-Reasoned Conclusions in Less Time

What Was Learned

Specific skills to effectively frame the problem you’re addressing to uncover key opportunities and drive growth
Critical marketing steps of orientation necessary before engaging tools and technology
How to simply and quickly amplify decision making by separating the signal from the noise
A framework for asking the right questions, allowing the ability to link analytics to business strategy

What Was Covered

Using data and statistics effectively in business today
Improper data manipulations and their consequences
Exploring quantitative data collection methods
Improving analysis success by effectively utilizing software
Understanding regression, trend lines, and scenarios in Excel
Utilizing the power of business intelligence software
Finding and analyzing data patterns, trends, and fluctuations
Interpreting and translating data into decisions

Who Attended

Over 80 business professionals who needed to learn more about the basic tools to quantitatively and accurately analyze the mountains of data that come across their desk each minute of every day.

Section One

Big Data—It’s Not Just Size

Describe the Importance of Effectively Analyzing Big Data in Business Today
Come up with a Data Map to Analyze the Big Data in your business.
Establish Clear Objectives When Analyzing Big Data
Recognize and Apply Various Data Collection Methods
Identify and Resolve Problems Associated with Data Collection
Discuss the difference between Data Warehouses and Data Lakes
Determine when to use Data Blending in your analysis

Section Two

Analysis—Using Business Intelligence Tools

Assess Your Current Analytics Culture
Describe the Issues and Trends in Today’s Analytics Field
Optimize your use of MS Excel for Big Data analytics
Discuss the concept of Data Visualization
Utilize BI Tools like Tableau Public
Build a Business Dashboard Prototype

Section Three

Interpretation—Assessing Results

Articulate the Importance of Accurately Interpreting Data
Determine and Analyze Risk, Uncertainty, and Probability
Spot Patterns, Trends, and Fluctuations Through Correlation, Regression, and Descriptive Statistics
Understand when to employ Descriptive, Predictive or Prescriptive Analytics
Build Data Models

Section Four

The Art of Presenting Big Data

Apply a Process to Present Big Data Clearly
Select the Appropriate Presentation Format to Communicate Your Findings Effectively to Your Audience
Master the Power of Enchantment
Use Findings from Big Data to Drive Decisions Within Your Organization

Too often people dive into the data only to be lost in haze of data.

This discussion will be pragmatic and immediately applicable to analysts, professional using analytics and managers of analysts across all industries.

Analytics Training – DMAIPH in partnership with Ariva Events Management, 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.

	DMAIPH on You Don’t Build A Busine…
	Ioliveiraserpa on You Don’t Build A Busine…
	DMAIPH on The Current Analytics Talent L…
	John on The Current Analytics Talent L…
	Dominic on Outsourcing Tip > Size the…