Assignment Preparation: Management of Data for Organizations

Task

Task:

Assignment Preparation: You have been selected to run a major project for management of data at one of a number of organizations, with the organizations and their projects described in separate attachments. (Select one of the three projects: Individual Assignment A, Individual Assignment B, or Individual Assignment C) Note. Your course facilitator may select certain choices or create his or her own. Therefore, do not assume that the organizations and projects available in one section of this course are the same in all sections. You may create your own organization based on an organization and project with which you are familiar, but if you do so, you must provide materials covering each of the following areas described for the provided examples:

Description of the organization Description of information the organization needs to track to support its daily business, and how it will be used by the organization Description of the most common or urgent activities that will access this information, how often they occur, and the expected response time Description of the organization's needs for investigating trends in this information over time (optionally, include information collected in other existing databases) Description of other data sources available to the organization, internally or externally, including some sources of data that are unstructured Week 1 Scenario You have a challenge in your project: you do not have a team, a process for development, or any tools for data management with which to do the job. You need to develop a plan for them.

Write a 1- to 2-page paper that addresses the following points: Define at least five key roles for members of your team involved in the definition, creation, and maintenance of the database and applications that use it. Give a job description of each role, with the skills and levels of education or certification you expect in each role, along with the major tasks that each team member will be expected to perform. Use salary information from referenced sources to suggest a range of possible salaries.

Describe the major tasks that the team will perform, and the natural order of doing those tasks the first time. Explain key tools and software that team members must have to perform this job.

Historical Reporting

We will need to investigate a lot of different possibilities, not all of them predictable. These might include:
1. How profitable are the different locations over time (individual locations, locations in particular cities, locations of particular sizes, ones with and without solar panels)?
2. How much electricity are we getting from solar panels? How does this vary across time and location?
3. How do grid electrical rates vary over time? Currently, we do not charge customers varying amounts based on the varying rates, because of the complexity and public relations challenges. Are we losing money on some customers because of this?
4. How often are the locations at capacity for one kind of service or other?
5. How often are the quick charge spaces full? How does this vary by locations?
6. How often do cars remain in spaces of either type after they are fully charged?
7. Where did casual and continuous reservation customers hear of us?