Earlier in this course, we took a brief look at the stages of the database lifecycle (DBLC).
This module examines the critically important first stage in the database lifecycle which is Requirements Analysis.
After completing this module, you will be able to:
- Explain the purpose of Requirements Analysis
- Identify business objects and describe their characteristics
- Explain the importance of business rules
- Explain the purpose of interviewing users of data
- Explain the purpose of the data flow diagram
- List reasons for creating user views
- Describe the documents produced during Requirements Analysis
The next lesson explains the overall purpose of Requirements Analysis.
Collecting data is relatively easy, but turning raw information into something useful requires that you know how to extract precisely what you need. In this module, intermediate to experienced programmers interested in data analysis will learn techniques for working with data in a business environment.
You will learn how to look at data to discover what it contains, how to capture those ideas in conceptual models, and then feed your understanding back into the organization through business plans, metrics dashboards, and other applications.
Along the way, you will experiment with concepts through hands-on exercises at various points in the moule.
- Use graphics to describe data with one, two, or dozens of variables
- Develop conceptual models using back-of-the-envelope calculations, as well as scaling and probability arguments
- Mine data with computationally intensive methods such as simulation and clustering
- Make your conclusions understandable through reports, dashboards, and other metrics programs
- Understand financial calculations, including the time value of money
- Use dimensionality reduction techniques or predictive analytics to conquer challenging data analysis situations
- Become familiar with different open source programming environments for data analysis