Country: Philippines
You are in the Philippines edition. Type your country to switch.
Nigeria
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
You are learning in the Philippines edition, with examples in pesos and from the Philippines.
Your learning profile
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.
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: Defining measures before collecting anything, not started
- Step 2: Collecting and cleaning the data, not started
- Step 3: Descriptive analysis in outline, not started
- Step 4: Evaluating options with a scoring matrix, not started
- Step 5: Proof of concept and pilots, not started
- Step 6: Acceptance and evaluation after go-live, not started
About 12 min of reading
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.
Popular this week: Basics: BeginnerPhilippine markets: Beginner