In this video, explore the role of a data analyst and what data analysis can mean.
- [Instructor] As you will soon discover, there's a growing need for data analysis and data analysts. So what is data analysis? There are lots of definitions but ultimately, it's the process of inspecting, cleaning, transforming and modeling data for business decision-making. You might then ask the obvious, what's a data analyst and let me assure you, it's not one size fits all. Data analysts work with any one of those processes or all of them. I'm constantly working with my team showing them the results of those processes or just setting up data for the decision-making that needs to happen on a project by project basis.
Data analysts' work is as diverse as the job descriptions you'll read while looking for data jobs. The data analysts will work with data in all shapes and fashion and the tools are as diverse as the data we encounter. Data analysts might often start with lines of data in databases, spreadsheets or even CSV files. They turn those records into more meaningful results for others to interpret. Remember, a picture is worth a thousand words or in the case of data, a chart is worth a thousand lines. Data analysts have the great fortune of sometimes creating powerful visualizations of data.
The shortage is real and it was predicted many years ago. The IDC predicts by 2018 a need for 181,000 people with deep analytical skills and for the data analyst jobs that require basic data management and interpretation, the need is five times greater. As a data analyst in the making, you do the math. Today, the demand way outnumbers the supply. You're off to a great start just by learning the basics as you start your path towards a data career or as a data scientist.
- Define data analysis and data analyst.
- List roles in data analysis.
- Explain data fields and types.
- Define syntax.
- Explain how to interpret existing data.
- Describe data best practices.
- Repurpose data.
- Create a data dictionary.
- Compare and contrast linking versus embedding charts and data.
- Build pivot charts with slicers.