University-of-Phoenix DBM 502 Week 1 Assignment 1

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. 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 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. 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 that team members must have to perform this job. Submit your assignment using the Assignment Files tab. This project is inspired by the description of real studies done by IBM for PGE and Honda (Mayer-Schonberger and Cukier, pp.102-3). Estation has a growing number of locations around the city, each of which will appear to be a simple parking garage. Estation needs to track reserved spots for those drivers who need to be sure they can charge their cars. In some locations, all or part of the top floor will be dedicated to solar panels to collect electricity. This has the obvious advantage of cutting our electricity usage, particularly during the hot, sunny days of the summer, when electricity costs are often the highest.

At least as importantly, it is a marketing tool for our environmentally conscious potential customers, who will like the idea that their cars were being charged by solar power. This does have costs and risks. Dedicating space to solar panels means costs in the panels themselves, as well as in the opportunity cost of not having those spaces available. It may or may not actually produce much energy, if the area is often cloudy, or a neighboring building puts the top floor in shade for part of the day. We will need to track our electricity expenses, where the rates can vary from hour to hour, based on demand on the grid, and also the production of electricity from our panels. We will also need to track equipment failures, both for the routine purpose of not placing customer cars in spaces that don’t work, and to let us analyze our costs of repair, and failure rates of different models of equipment. 1. Find a location near the customer. 2. View the floors with available space during the period the customer will be there, with the available spaces indicated with their type.

3. Select a space, and then reserve it and pay for it. 4. Cancel a reservation. 6. Monthly runs to bill continuing reservations. 7. Reports to see where we have especially large amounts of available space, for use in generating promotional emails to previous casual customers. We expect about 30% of the spaces to be reserved on a continuous reservation during the day. The other 40% we anticipate filling, plus almost all off hours spaces used will be filled by people making requests of types 1, 2, and 3 each day. There will probably be at least 50% more requests than we actually get reservations. We hope cancellations will be no more than 10% of the total. We will need to investigate a lot of different possibilities, not all of them predictable. 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? We have access to information from government agencies on weather in the area, including indications of when it was sunny near each location or potential location. We have a long series of information on grid electricity rates in different locations over a few decades from our electrical company parent. We have data available from our car company parent on the amount of electricity need and maximum charging rates for the different models of cars (both the ones they manufacture and others).