1. Need data in regards to what drugs/suppliers are most commonly needed on hand, when they are needed and in what quantity in order to have good service
1.1. MIS: with provide a summary report of what was needed in the past - shows fluctuation depending on time of year and age of patient
1.1.1. Linked with TPS - TPS provides the patient data for the summar
1.2. DSS - help doctors and staff make decisions about what drugs and vaccinations to have on hand
1.2.1. DSS - can also inform clinic when clinic will be most busy - when they need to have the most staff on hand in order to have good and efficient service
1.2.2. Use data from TPS and MIS in order to make decisions with DSS
1.2.3. Past medical history of each patient
1.2.4. Can have data about riskiness of certain drugs - if doctor should do the procedure or refer them to someone else
1.3. Group 315
1.4. Data regarding hiring of doctors - what to look for and where to look to have doctors that will provide the best service - well rounded doctors
2. To support the information needs you came up with in Phase 3, what type of information technologies need to be in place. What else needs to be in place to be able to use the systems?
3. Group 316
3.1. What information technologies need to be in place
3.1.1. Online transaction processing (OTLP)
3.1.1.1. Data mining
3.1.1.1.1. Finding patterns between customers
3.1.1.2. Data visualisation
3.1.1.2.1. See income raise/falls and growth rates of cities to predict which city is better to target
3.1.1.3. Text mining
3.1.1.3.1. How customers feel about moving and what their general problems are
3.1.2. Online analytical processing (OLAP)
3.1.2.1. Data warehouse
3.1.2.1.1. Can use to take a birds eye view of the industry then drill down into company statistics
3.1.3. TPS
3.1.3.1. Processing business transactions
3.1.3.1.1. Payroll of Employees
3.1.3.1.2. Billing/Invoices of Moves
3.1.3.1.3. Accounts Payable
3.1.3.1.4. Date and Booking services
3.1.4. MIS
3.1.4.1. summary reports
3.1.4.1.1. Sales management systems
3.1.5. DSS
3.1.5.1. Forecasting
3.1.5.1.1. New housing built in area
3.1.5.1.2. Recession
3.1.5.1.3. Use to be adaptable in industry
3.2. What else needs to be in place to be able to use the systems
3.2.1. Microsoft Access
3.2.2. Computers
3.2.2.1. Internal servers
4. Group 311
4.1. TPS
4.1.1. Used for the daily record of sales information requires tremendous categorization.
4.1.2. Record invoices, accounts receivable, accounts payable.
4.1.2.1. Balance current assets and liabilities.
4.1.3. Manage specific orders from customers.
4.2. Data mining
4.3. MIS
4.3.1. Analyze the organization of TPS and DSS modules to produce performance reviews.
4.3.2. Produce reports based on raw data to make business decisions for the future.
4.4. DSS
4.4.1. Compare the sales of certain products with availability and make adjustments according to consumer demand.
5. Group 314
5.1. Information Technology Needs
5.1.1. TPS and MIS
5.1.1.1. In order to produce detailed portfolio reports to give customers their informational needs, TPS will be recording all transactions generated between the portfolio and investments as well as the company [portfolio] and the clients.
5.1.1.2. Accurate and efficient way to generate managerial or in-company decisions to maintain good customer relationships.
5.1.2. DSS
5.1.2.1. Market trend based decisions make investments more reliable and accurate
5.2. Addt'l Tecnology
5.2.1. Data Mining
5.2.1.1. To study the trends in the market and past investment decisions
5.2.2. Text Mining
5.2.2.1. To analyze customer feedback and market news/updates efficiently
5.2.3. OLAP and Data Warehouse
5.2.3.1. To be able to make accurate decisions based on acquired detailed and reliable data
6. Group 312
6.1. DSS
6.1.1. Demand forecasting (seasonal, into the future )
6.1.1.1. Knowing this we could allocate funds appropriately, choosing to focusing on different areas such as growth marketing etc. EX. Rapid growth would require us to buy more trucks to meet future demand
6.1.2. Helps provide decision analysis in terms of transportation scheduling + route planning
6.1.3. What needs to be in place: payment/transaction-record system (PayPal? Credit Card? Cash?), truck management system (trucks available, truck routes, how many are needed...)
6.2. TPS
6.2.1. Record transactions of each move that we perform
6.2.2. Invoice/ billing system for each transaction we complete
6.2.3. Scheduling System for employees and trucks
6.2.4. What needs to be in place: scheduling system (developing an electronic system could increase efficiency)
6.2.4.1. Customer Reservation System: Maybe a website or IPhone Apps
6.2.5. Create reports that would outline how long on average it takes to complete a job within a certain area
6.3. MIS
6.3.1. What needs to be in place:
6.3.1.1. A database of historical records cataloguing the start and end times of different competed jobs
7. Group 319
7.1. Text mining from resumes, key words: skills, qualification, etc. And from job posts: skills, requirements, etc.
7.1.1. Store this in the Op. DB.
7.1.2. keyword matching analysis between job post and resumes for correlation.
7.2. TPS: billing clients, payroll, reports.
7.3. MIS: generate the CRM info from our clients. historical analysis: ratings, job matching, etc. Takes tps data and it analyzes profitability of companies within the range of hire ability. look at sales people/managers (in our company)
7.4. DSS: will determine where do we have to look for skills, evaluate trends,.
8. Group 317
8.1. MIS
8.1.1. MIS will help the company to extract the features of the customers who's using the Cityworkforce to find employers/jobs. Through this customer analysis, cityworkforce will find out what attract its customers to choose them as the external HR agent.
8.1.1.1. fro example, through MIS record and analysis the customer information, they will know which type of corporation will choose cityworkforce, big companies or small business? In which area they are working for: finance? food industry? etc.
8.1.1.1.1. After use get the major features of the main customer source, we can develop specific segment marketing based on the size of the customer or the industry they are in.
8.2. DSS
8.2.1. Predict successfulness of job "match" in specific fields
8.2.1.1. Help to match worker with company based on Text mining and information from MIS
8.3. Text Mining: go through resumes and cover letters to extract information that may be useful to employers
8.3.1. Rate worker on experience, education, "fit" to job post
8.4. Use of Data Warehouse to store information about past "matches" between workers and employers as well as past job posts and if they were matched with a worker or not.
9. Group 320
9.1. Operational (TPS)
9.1.1. - Billing system for suppliers and cx (to record financial transactions) - payroll systems - inventory management system
9.2. Management Control (MIS/DSS)
9.2.1. inventory control system
9.2.1.1. - since part our products are to be fresh we need daily inventory activity records and for the non-pershable inventory we can have bi-weekly inventory activity records - need separate inventory records for our different stores
9.2.2. Sales management system
9.2.2.1. - MIS monitor sales instore and online and then we can use DSS in order to make decisions about the info about the level of inventory to have
9.2.2.2. historical data analysis about sales to make predictions about trends
9.3. Data mining
9.3.1. run correlations between sales and cx profile
9.4. Data warehouses
9.4.1. collection of our data from different sources
9.4.2. create data cubes in order to categories the data according to the 3 dimensions (store, product catagory, date)
10. Group 318
10.1. TPS
10.1.1. Staff payroll
10.1.2. Patient billing
10.1.3. medical supply inventory
10.1.4. patient booking
10.1.5. staff hours
10.1.6. payments to suppliers/partners
10.2. MIS
10.2.1. Productivity reports
10.2.2. Patient retention statistics
10.2.3. Peak hours of operation
10.2.4. Management of perishable inventory
10.3. DSS
10.3.1. Financial management (investments)
10.3.2. analysis of historical trends e.g. flu shot in winter, approximate supply
10.3.3. Calculation of staff bonuses based on efficiency and patient retention statistics
10.4. EIS
10.4.1. summary of productivity
10.4.2. summary of efficiency
10.4.3. correlations between locations, seasons, staffing levels and profitability
10.5. Data Mining
10.5.1. Analyze global trends in disease from news articles and other medical databases
10.5.2. use data mining to calculate patients preference of branded pharmaceutical drugs
10.6. Please note, we had some technical difficulties accessing the mind map. Our information is not as complete as we would like. Thanks!
11. New node
12. New node
13. New node
14. Group 309 - MoveIT
14.1. CRM and text mining for customer feedback
14.2. DSS for scheduling workers and trucks
14.3. MIS for ranking employee skills,
14.4. MIS preliminary quotes for customer
14.5. TPS - invoicing and billing
14.6. data mining for analyzing industry trends
14.7. TPS for tracking vehicle mileage, and other expenses
14.8. DSS to forecast demand during changing seasons
15. New node
16. Group 301 MoveIT
16.1. Our Information Needs
16.1.1. Trends and Preferences of our Customers
16.1.2. Cost of doing a move depending on weight, distance moved
16.1.3. Which areas in Vancouver need the most housing transactions
16.1.4. The demographics of our customers (Number of Immigrants and students moving in)
16.2. Technology Needed
16.2.1. TPS
16.2.1.1. To collect operational data (customer info, moving locations)
16.2.2. MIS
16.2.2.1. Pair the right employees with the right customers depending on employee skill, preferred language of the customer
16.2.2.2. System could automatically schedule moving times to optimize costs
16.2.2.3. Analyze cost of each move, depending on dist. travelled, weight to mark better pricing in the future
16.2.3. EIS
16.2.3.1. Predict which areas would have the highest moving demand from our data warehouse and allocate the right amount of resources to those areas
16.2.3.2. With immigrant data, create the right marketing material
16.2.3.3. Economic fluctuation data - ex. Gas price
16.2.4. OLTP
16.2.4.1. Keep track of moving progress, can always update how much work has been completed
16.2.4.2. Update employee profiles, can be used to analyze what employee skills are maximizing efficiency and what other skills are needed
16.2.5. Data Warehouse
16.2.5.1. Storing customer information for future references
16.2.5.2. Obtain data from the housing markets
16.2.5.2.1. New node
16.2.5.3. Statistics of immigration rates in the vancouver area, percentage of different ethnicities in the population,
17. Group 302
17.1. MIS
17.1.1. To collect data regarding our decision making process
17.1.1.1. This is particularly useful in inventory control; in terms of our company, it is good to keep track of inventory flow from suppliers to the company itself
17.1.1.2. It also helps us manage sales. Keeping track of sales is important in Good Food's because we can track which product is purchased more, which products do we need supplies on
17.2. DSS
17.2.1. uses data from the past to generate predicted date from the future
17.2.1.1. This is significant to Good Foods because one of our main concerns and major external factors that will affect the company is the changes in the economy and fluctuations in the weather
17.2.1.1.1. Naturally, during economic recessions, it will be good to be able to predict the future to see how it will affect sales. Organic foods won't be in high demand during economic difficulties.
17.2.1.2. Demand forecasting for food --> helps us provide appropriate supplies on particular days to maximize efficiency
17.2.1.2.1. Which products have a high demand and which don't.
18. Group 303
18.1. what type of information technologies need to be in place
18.1.1. TPS
18.1.1.1. to get information about all of our transaction because it is the most important of revenue model
18.1.1.2. find out best properties location and specific target market's demand(such as prices)
18.1.2. Text Mining
18.1.2.1. analyze customers' feedback, demand, testimonials, reviews
18.1.3. DSS
18.1.3.1. need of information system to analyze our customers coming from
18.1.3.2. use TPS information to generate DSS information about demand forecasting
18.2. What else needs to be in place to be able to use the systems?
19. Group 304
19.1. MIS
19.1.1. Mapping performance
19.1.1.1. Data Mining
19.1.1.1.1. finding profitability
19.1.1.1.2. returns on investments
19.2. TPS
19.2.1. (operational data, and transactions)Keep track of how much and where the money is invested
19.2.2. # of trades made of investments etc
19.2.3. # of visits to advisors
19.3. DSS
19.3.1. To decide the rate of fees charged etc.
19.3.2. To decide where to invest funds
20. Group 305:VANRealty
20.1. TPS
20.1.1. Operational
20.1.1.1. commission/payroll systems
20.1.1.2. A/R & A/P for Houses/Apartments purchases
20.1.1.3. Reservation systems for making appointments
20.2. DSS
20.2.1. financial planning: helping customers forecast how they will pay for their property
20.2.2. demand forecasting: trying to foresee trends in the market that can help/hurt the company
20.3. MIS
20.3.1. Inventory of Houses: keeping track of number of houses in the market (as well as number of offers)
20.3.2. Monthly/Weekly reports for sales
20.4. Data Visualization:
20.4.1. to show where houses are available
20.4.2. to show areas with the most income
20.5. OLTP
20.5.1. show on our website which properties are available in specific areas, for certain prices, and how many offers there have been
20.6. Data Mining
20.6.1. to show where people are currently buying houses
20.6.2. show people losing/gaining jobs
21. Group 306 City Workforce
21.1. MIS Database
21.1.1. Text mining
21.1.1.1. Resumes
21.1.1.2. Applications
21.1.1.3. Job Postings
21.1.1.4. Personality Report
21.1.2. Data mining
21.1.2.1. feedback survey systems
21.1.2.2. statistics of what type of people matched to which company
21.2. Support System
21.2.1. Security
21.2.2. Privacy/Firewall
21.3. TPS
21.3.1. get info from MIS
21.3.2. secure online transaction system
21.4. DSS
21.4.1. Find matches because value proposition is based on matching correct data
21.5. Data Warehouse
21.5.1. important to keep all profiles
21.5.2. back up system required
22. Group 307 Van Realty
22.1. Objective
22.1.1. Optimal customer care with lowest possible brokers fee
22.2. Technologies to succumbing objective
22.2.1. Database
22.2.1.1. Website + App
22.2.1.1.1. That highlights the customer' s needs to the agents framework
22.2.1.1.2. For convenience, this can even be platformed through facebook
22.2.1.2. Inventory folder
22.2.1.2.1. Linking the agent to all the marketable propery
23. Group 308
23.1. MIS
23.1.1. Inventory Control System
23.1.1.1. Linking inventory orders to our suppliers so they know when to deliver, making it atutomatically, assigning each product what a low quantity is. Also supplying them sales information so they know which one sells faster, and if you link them together then you can ensure a proper inventory control system
23.1.2. Delivery Logistics
23.1.2.1. Ensuring that delivery systems are in place, maybe using IT to tell us the estimated arrival date, and linking it to the inventory control sytem to ensure that the delivery will be on time based on forecasting demand at the DSS level
23.2. TPS
23.2.1. Inventory Management
23.2.1.1. Point of sale counters to track inventory levels. How much stock do we have right now?
23.2.1.1.1. Use RFID tags to track what is coming in, what is coming out. Track exactly where each product is in the store (probably not by individual fruit, but by crate)
23.2.2. Payroll Systems
23.2.2.1. tracking when employees clock in/ clock in accordingly , (stat pay or overtime pay)
23.2.3. Simple Processing
23.2.3.1. Updating and storing information about our customers and cater our products to suit their needs
23.2.4. Loyalty
23.2.4.1. Allowing us to track what people are purchasing and will allow us to use it as a MIS trying to understand what people buy and when, allowing us to identify customer trends and in the future maybe also allow us to mine data which we may not be aware of. See DSS
23.3. DSS
23.3.1. Taking data from the inveotry management and control system, to try and recreate historical demand and forecast for the future. Understand past historical trends to better plan for future periods.
23.3.2. Analyzing loyalty program
23.3.2.1. With the information from the loyalty program, understanding customer needs, patterns, and trends. Understanding consumer segments to sell them the products they want, at the correct time, and appropriate price
23.3.3. Using data from TPS to
23.3.4. Taking data from an external source and analyzing it to try and understand future growth in the industry as organic food is a growing market and linking it to our inventory management or control system to try and create a new forecast of demand which includes this. Links to the other point in DSS (the first one at time of writing)
24. Group 310
24.1. TPS-Routine Operational
24.1.1. Payroll collected to distribute to employees
24.1.2. Payroll tracking to gather from employers
24.1.3. Standard wages for typical jobs
24.2. MIS-Summary
24.2.1. sales (number of connections made)
24.2.2. Back-up system in case of downtime
24.2.3. Current available supply and demand
24.3. DSS-Decision Analysis
24.3.1. Forcasting of the demand for employees
24.3.2. Analyze resumes, skills, and preferences of employees and employers
24.3.2.1. Possible of using text mining
24.3.3. Forcasting of number of people actively looking for short-term work
24.3.4. Give ratings for the compatibility between employers and employees
24.4. EIS- High Level Decisions
24.4.1. Which areas are growing and will require more investment to develop
24.5. Security system to guard against privacy breaching and theft
24.6. Data Warehouse
24.6.1. Keep a large numbers of data since it is one of the essential pilars of this company