Skip to content
Edition NigeriaGlobal
Country: Malta

You are in the Malta edition. Type your country to switch.

Set up your profile

You are learning in the Malta edition, with examples in euros and from Malta.

Business analysis · Lesson 7 of 8

Data analysis and solution evaluation

Analysts prove things with data, not opinions. This lesson covers defining measures that mean the same thing to everyone, collecting and cleaning the data behind them, and the basics of descriptive analysis. It then shows how to evaluate solution options against weighted criteria with a worked scoring matrix, when to run a proof of concept or a pilot, and how to evaluate the solution after go-live.

Intermediate14 min read6 steps

This lesson is complete in writing. A video for it is on its way.

What you will learn

  • By the end you can define a measure so that everyone counts the same thing in the same way.
  • You can collect and clean a data set and record the decisions you made along the way.
  • You can describe a data set with counts, averages and spread, and spot what the summary hides.
  • You can evaluate solution options with a weighted scoring matrix whose totals add up, and test its sensitivity.
  • You can explain when to run a proof of concept or a pilot, and how to evaluate a solution after go-live.

Key terms in this lesson

Key performance indicator
One of the few measures that drive or best show a company's performance, such as subscribers for a telecom or net interest margin for a bank. Often shortened to KPI.
Data cleaning
Preparing raw data for analysis by removing duplicates, correcting formats, handling missing values and recording every decision made along the way.
Outlier
A value far away from most of the others in a set, which can distort averages and charts.
Descriptive analysis
Summarising data to show what happened, using counts, averages, spreads and simple charts, without yet explaining why or predicting what comes next.
Mean
The sum of a set of values divided by how many values there are. Often just called the average.
Median
The middle value when a set of values is sorted in order. Half the values are above it and half below.
Scoring matrix
A table that rates each option against each decision criterion, multiplies the rating by the criterion's weight and adds the results into a total per option.
Proof of concept
A small, limited build or trial that tests whether an idea or technology can work at all, before any commitment to a full solution.
Pilot
A live trial of a solution with a limited group of real users or sites, run to learn what works before a wider rollout.

Step 1 of 6

Defining measures before collecting anything

Opening this step…

Step 2 of 6

Collecting and cleaning the data

This step opens when you finish the one above.

Step 3 of 6

Descriptive analysis in outline

This step opens when you finish the one above.

Step 4 of 6

Evaluating options with a scoring matrix

This step opens when you finish the one above.

Step 5 of 6

Proof of concept and pilots

This step opens when you finish the one above.

Step 6 of 6

Acceptance and evaluation after go-live

This step opens when you finish the one above.

Key takeaways

The key takeaways open when you finish every step.

Lesson quiz

6 questions. You need 85% to pass.

The quiz opens when you finish every step.

Read first

Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.

Up next

Projects, consulting & analysisSupporting implementation and ch…Read nowSupporting implementation and changeProjects, consulting & analysis · Intermediate · 15 minProjects, consulting & analysisWhat a project is and the projec…Read nowWhat a project is and the project lifecycleProjects, consulting & analysis · Intermediate · 15 minProjects, consulting & analysisInitiation: the business case an…Read nowInitiation: the business case and the project charterProjects, consulting & analysis · Intermediate · 15 minProjects, consulting & analysisScope and the work breakdown str…Read nowScope and the work breakdown structureProjects, consulting & analysis · Intermediate · 15 minProjects, consulting & analysisBuilding the business case and r…Read nowBuilding the business case and realising benefitsProjects, consulting & analysis · Intermediate · 15 minProjects, consulting & analysisStructuring problems: issue tree…Read nowStructuring problems: issue trees and MECEProjects, consulting & analysis · Advanced · 15 minProjects, consulting & analysisWhat business analysis isRead nowWhat business analysis isProjects, consulting & analysis · Intermediate · 15 minProjects, consulting & analysisDocumenting and prioritising req…Read nowDocumenting and prioritising requirementsProjects, consulting & analysis · Intermediate · 15 minProjects, consulting & analysisHypothesis-driven analysisRead nowHypothesis-driven analysisProjects, consulting & analysis · Advanced · 15 minProjects, consulting & analysisGathering evidence: interviews, …Read nowGathering evidence: interviews, data and benchmarksProjects, consulting & analysis · Advanced · 15 minProjects, consulting & analysisStakeholder analysis and require…Read nowStakeholder analysis and requirements elicitationProjects, consulting & analysis · Intermediate · 15 minProjects, consulting & analysisWhat consultants do and how the …Read nowWhat consultants do and how the industry worksProjects, consulting & analysis · Advanced · 15 min
English