In short
A data analyst takes raw data that makes no sense on its own and turns it into insight a business can act on. In this lightning talk, Amadikwa Joy N, a data analyst at Data Science Nigeria, explains the role, lists the skills and tools a beginner needs, and shows a dashboard she built from a dataset of 320,000 records. Her message: start with the basics, build up your toolkit, and never forget that analysis only has value when you can communicate it.
Key takeaways
- Who is a data analyst
From raw data to business decisions
Amadikwa Joy N opens with something familiar: most people have seen graphs and charts throughout school and work, accepted that they make sense, and moved on without asking how they were produced. That question is the starting point of the data analyst role. Her definition is direct:
"I'm permitting to say that a data analyst is someone that have the ability, the capability, the tendency of getting a raw data and actually makes sense from that little, from that raw data that doesn't make sense." (1:29)
She frames the purpose of that work in business terms. Analysts exist so that companies can understand their own information, and act on it:
"To help businesses to make sense of their data so that they can grow and effectively compete with other companies in the market." (1:59)
She adds that as companies grow, they often discover that much of the data stored in their databases is not relevant to current operations. An analyst is brought in to work out where data has been useful and what the business needs to do to make it more useful.
A simple example: who buys what, where
To make the idea concrete, the speaker describes an online store selling to women in different countries. The business holds purchase data from customers in many locations. An analyst studies which goods are bought most in which places, so the company can direct the right products to the right markets.
"So with that, they will know, okay, let's send this particular product to Nigeria or let's send this particular product to UK or let's send this particular product to India." (3:26)
The example shows how the role connects numbers to decisions about stock, logistics and growth.
The skills a beginner needs
Amadikwa Joy N then lists the basic skills she considers essential, noting that the list may grow over time. A data analyst should have analytical skill and be a critical thinker, have a good sense of visualization, and be comfortable with statistics and mathematics, without needing to be a pure statistician. She also stresses personal habits:
"be organized because you can't actually organize a data if you are not organized as a person" (4:13)
Two further skills round out her list. The first is communication, so that findings reach stakeholders and the business. The second is decision making: knowing whether a result is the right one to present, or the right one to treat as final.
A starter toolkit
On tools, the speaker recommends starting with the spreadsheet most people already know. Basic Excel knowledge, she says, can get a newcomer started even without Python. From there, she suggests building up in layers:
- SQL, because analysts work with databases and need to query them for the information that supports their analysis.
- A programming language, such as Python or R.
- Visualization tools such as Tableau and Power BI, which help present analysis effectively and professionally.
- SAS or SPSS, statistical analysis software she describes as a plus for strengthening analytical skills.
Seeing it work: a Tableau Public dashboard
The demo is the clearest illustration of her definition. She found a crime dataset online with, as the speaker cited, about 320,000 records, so large she could only screenshot its last rows. To a layperson, or someone with what she calls data phobia, the raw table is meaningless. Using Tableau Public, she turned it into a dashboard showing the highest number of incidents, total incidents, weapons used and a map of where crimes were committed. The visual depends on her slides, but the point is clear: the analyst's job is to make the data speak to people who cannot read it raw.
Where data analysts work, and why communication matters
The speaker lists areas open to data analysts: business intelligence, data assurance, data quality, finance, higher education, marketing and sales, among others. In business, analysts help decide which information is valuable and how to allocate company resources, usually as part of a team. She notes that data analysts and data scientists are often mentioned interchangeably, though they are different skill sets.
She returns to communication as the skill that holds the rest together. Analysts need attention to detail and organization, but they must also present insights through clear visual, written and verbal communication:
"because you cannot analyze data and maybe unable to communicate it to the people and that data you analyze is actually nothing" (9:41)
She closes by restating her view that data analysts serve as the brain behind organizational data, helping stakeholders understand it and use it well.
Watch the talk
"The beauty of data analyst" by Amadikwa Joy N (about 12 minutes): https://www.womentech.net/video/beauty-data-analyst
About the speaker
Amadikwa Joy N is a Data Analyst at Data Science Nigeria, as well as a software engineer, tech evangelist, community builder and advocate for more women in tech. She is a Computer Science graduate of Federal Polytechnic Nekede Owerri in Imo State, Nigeria.
Questions this talk answers
- Who is a data analyst?
- What skills does a beginner data analyst need?
- Which tools should I learn to start a data analyst career?
- Where can data analysts work?
- Why does communication matter for a data analyst?
Drafted with AI from the talk transcript. Editor review pending.