Analytic (Data Analyst)
Table of Contents
1 - Data Analyst vs Data Scientist
A Data Analyst sees what data he has. A Data Scientist imagines what data he is lacking.
2 - Information Analysis
Information analysis provides insight into :
- the past
- the present
- and the future
of the business.
3 - Perspective
The analyse of data is made from many perspectives. See:
4 - Analytics
Analytics is all about gaining insights from the data for better decision making.
Analytics = Statistical estimation and prediction
5 - Complex analytics
Such problems as computing covariance between daily closing prices of 15,000 the stocks for the last 10 years, usually require array operations which are very hard to do in RDBMS.
6 - Type of Analysis
- a “what” analysis: a sales revenue report
- a “how” analysis: a trend analysis showing how to improve sales in a particular region
- an ad-hoc analysis: an online analytical query created on the fly by an end user.
7 - Capabilities
- Calculated Members
- Financial Models
8 - Dashboard
Mike Drummond: An airline pilot doesn’t look out the window when he’s flying the plane. he looks at his instruments, and you guys have to do the same thing.
Rather than flooding the sunglasses with data, only relevant decisions and data are projected. No need for the helmsman to interpret the data, he needed to simply act on the decision points.