COMM391 Section 103 Phase 4

Get Started. It's Free
or sign up with your email address
Rocket clouds
COMM391 Section 103 Phase 4 by Mind Map: COMM391 Section 103 Phase 4

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. Group 307 Van Realty

2.1. Objective

2.1.1. Optimal customer care with lowest possible brokers fee

2.2. Technologies to succumbing objective

2.2.1. Database Website + App That highlights the customer' s needs to the agents framework For convenience, this can even be platformed through facebook Inventory folder Linking the agent to all the marketable propery

3. Group 303

3.1. what type of information technologies need to be in place

3.1.1. TPS to get information about all of our transaction because it is the most important of revenue model find out best properties location and specific target market's demand(such as prices)

3.1.2. Text Mining analyze customers' feedback, demand, testimonials, reviews

3.1.3. DSS need of information system to analyze our customers coming from use TPS information to generate DSS information about demand forecasting

3.2. What else needs to be in place to be able to use the systems?

4. Group 310

4.1. TPS-Routine Operational

4.1.1. Payroll collected to distribute to employees

4.1.2. Payroll tracking to gather from employers

4.1.3. Standard wages for typical jobs

4.2. MIS-Summary

4.2.1. sales (number of connections made)

4.2.2. Back-up system in case of downtime

4.2.3. Current available supply and demand

4.3. DSS-Decision Analysis

4.3.1. Forcasting of the demand for employees

4.3.2. Analyze resumes, skills, and preferences of employees and employers Possible of using text mining

4.3.3. Forcasting of number of people actively looking for short-term work

4.3.4. Give ratings for the compatibility between employers and employees

4.4. EIS- High Level Decisions

4.4.1. Which areas are growing and will require more investment to develop

4.5. Security system to guard against privacy breaching and theft

4.6. Data Warehouse

4.6.1. Keep a large numbers of data since it is one of the essential pilars of this company

5. Group 302

5.1. MIS

5.1.1. To collect data regarding our decision making process 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 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

5.2. DSS

5.2.1. uses data from the past to generate predicted date from the future 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 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. Demand forecasting for food --> helps us provide appropriate supplies on particular days to maximize efficiency Which products have a high demand and which don't.

6. Group 301 MoveIT

6.1. Our Information Needs

6.1.1. Trends and Preferences of our Customers

6.1.2. Cost of doing a move depending on weight, distance moved

6.1.3. Which areas in Vancouver need the most housing transactions

6.1.4. The demographics of our customers (Number of Immigrants and students moving in)

6.2. Technology Needed

6.2.1. TPS To collect operational data (customer info, moving locations)

6.2.2. MIS Pair the right employees with the right customers depending on employee skill, preferred language of the customer System could automatically schedule moving times to optimize costs Analyze cost of each move, depending on dist. travelled, weight to mark better pricing in the future

6.2.3. EIS Predict which areas would have the highest moving demand from our data warehouse and allocate the right amount of resources to those areas With immigrant data, create the right marketing material Economic fluctuation data - ex. Gas price

6.2.4. OLTP Keep track of moving progress, can always update how much work has been completed Update employee profiles, can be used to analyze what employee skills are maximizing efficiency and what other skills are needed

6.2.5. Data Warehouse Storing customer information for future references Obtain data from the housing markets New node Statistics of immigration rates in the vancouver area, percentage of different ethnicities in the population,

7. Group 308

7.1. MIS

7.1.1. Inventory Control System 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

7.1.2. Delivery Logistics 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

7.2. TPS

7.2.1. Inventory Management Point of sale counters to track inventory levels. How much stock do we have right now? 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)

7.2.2. Payroll Systems tracking when employees clock in/ clock in accordingly , (stat pay or overtime pay)

7.2.3. Simple Processing Updating and storing information about our customers and cater our products to suit their needs

7.2.4. Loyalty 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

7.3. DSS

7.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.

7.3.2. Analyzing loyalty program 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

7.3.3. Using data from TPS to

7.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)

8. Group 304

8.1. MIS

8.1.1. Mapping performance Data Mining finding profitability returns on investments

8.2. TPS

8.2.1. (operational data, and transactions)Keep track of how much and where the money is invested

8.2.2. # of trades made of investments etc

8.2.3. # of visits to advisors

8.3. DSS

8.3.1. To decide the rate of fees charged etc.

8.3.2. To decide where to invest funds

9. Group 316

9.1. What information technologies need to be in place

9.1.1. Online transaction processing (OTLP) Data mining Finding patterns between customers Data visualisation See income raise/falls and growth rates of cities to predict which city is better to target Text mining How customers feel about moving and what their general problems are

9.1.2. Online analytical processing (OLAP) Data warehouse Can use to take a birds eye view of the industry then drill down into company statistics

9.1.3. TPS Processing business transactions Payroll of Employees Billing/Invoices of Moves Accounts Payable Date and Booking services

9.1.4. MIS summary reports Sales management systems

9.1.5. DSS Forecasting New housing built in area Recession Use to be adaptable in industry

9.2. What else needs to be in place to be able to use the systems

9.2.1. Microsoft Access

9.2.2. Computers Internal servers

10. Group 317

10.1. MIS

10.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. 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. 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.

10.2. DSS

10.2.1. Predict successfulness of job "match" in specific fields Help to match worker with company based on Text mining and information from MIS

10.3. Text Mining: go through resumes and cover letters to extract information that may be useful to employers

10.3.1. Rate worker on experience, education, "fit" to job post

10.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.

11. Group 318

11.1. TPS

11.1.1. Staff payroll

11.1.2. Patient billing

11.1.3. medical supply inventory

11.1.4. patient booking

11.1.5. staff hours

11.1.6. payments to suppliers/partners

11.2. MIS

11.2.1. Productivity reports

11.2.2. Patient retention statistics

11.2.3. Peak hours of operation

11.2.4. Management of perishable inventory

11.3. DSS

11.3.1. Financial management (investments)

11.3.2. analysis of historical trends e.g. flu shot in winter, approximate supply

11.3.3. Calculation of staff bonuses based on efficiency and patient retention statistics

11.4. EIS

11.4.1. summary of productivity

11.4.2. summary of efficiency

11.4.3. correlations between locations, seasons, staffing levels and profitability

11.5. Data Mining

11.5.1. Analyze global trends in disease from news articles and other medical databases

11.5.2. use data mining to calculate patients preference of branded pharmaceutical drugs

11.6. Please note, we had some technical difficulties accessing the mind map. Our information is not as complete as we would like. Thanks!

12. Group 314

12.1. Information Technology Needs

12.1.1. TPS and MIS 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. Accurate and efficient way to generate managerial or in-company decisions to maintain good customer relationships.

12.1.2. DSS Market trend based decisions make investments more reliable and accurate

12.2. Addt'l Tecnology

12.2.1. Data Mining To study the trends in the market and past investment decisions

12.2.2. Text Mining To analyze customer feedback and market news/updates efficiently

12.2.3. OLAP and Data Warehouse To be able to make accurate decisions based on acquired detailed and reliable data

13. Group 320

13.1. Operational (TPS)

13.1.1. - Billing system for suppliers and cx (to record financial transactions) - payroll systems - inventory management system

13.2. Management Control (MIS/DSS)

13.2.1. inventory control system - 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

13.2.2. Sales management system - 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 historical data analysis about sales to make predictions about trends

13.3. Data mining

13.3.1. run correlations between sales and cx profile

13.4. Data warehouses

13.4.1. collection of our data from different sources

13.4.2. create data cubes in order to categories the data according to the 3 dimensions (store, product catagory, date)

14. Group 312

14.1. DSS

14.1.1. Demand forecasting (seasonal, into the future ) 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

14.1.2. Helps provide decision analysis in terms of transportation scheduling + route planning

14.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...)

14.2. TPS

14.2.1. Record transactions of each move that we perform

14.2.2. Invoice/ billing system for each transaction we complete

14.2.3. Scheduling System for employees and trucks

14.2.4. What needs to be in place: scheduling system (developing an electronic system could increase efficiency) Customer Reservation System: Maybe a website or IPhone Apps

14.2.5. Create reports that would outline how long on average it takes to complete a job within a certain area

14.3. MIS

14.3.1. What needs to be in place: A database of historical records cataloguing the start and end times of different competed jobs

15. Group 311

15.1. TPS

15.1.1. Used for the daily record of sales information requires tremendous categorization.

15.1.2. Record invoices, accounts receivable, accounts payable. Balance current assets and liabilities.

15.1.3. Manage specific orders from customers.

15.2. Data mining

15.3. MIS

15.3.1. Analyze the organization of TPS and DSS modules to produce performance reviews.

15.3.2. Produce reports based on raw data to make business decisions for the future.

15.4. DSS

15.4.1. Compare the sales of certain products with availability and make adjustments according to consumer demand.

16. Group 319

16.1. Text mining from resumes, key words: skills, qualification, etc. And from job posts: skills, requirements, etc.

16.1.1. Store this in the Op. DB.

16.1.2. keyword matching analysis between job post and resumes for correlation.

16.2. TPS: billing clients, payroll, reports.

16.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)

16.4. DSS: will determine where do we have to look for skills, evaluate trends,.

17. 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?

18. Group 305:VANRealty

18.1. TPS

18.1.1. Operational commission/payroll systems A/R & A/P for Houses/Apartments purchases Reservation systems for making appointments

18.2. DSS

18.2.1. financial planning: helping customers forecast how they will pay for their property

18.2.2. demand forecasting: trying to foresee trends in the market that can help/hurt the company

18.3. MIS

18.3.1. Inventory of Houses: keeping track of number of houses in the market (as well as number of offers)

18.3.2. Monthly/Weekly reports for sales

18.4. Data Visualization:

18.4.1. to show where houses are available

18.4.2. to show areas with the most income

18.5. OLTP

18.5.1. show on our website which properties are available in specific areas, for certain prices, and how many offers there have been

18.6. Data Mining

18.6.1. to show where people are currently buying houses

18.6.2. show people losing/gaining jobs

19. Group 306 City Workforce

19.1. MIS Database

19.1.1. Text mining Resumes Applications Job Postings Personality Report

19.1.2. Data mining feedback survey systems statistics of what type of people matched to which company

19.2. Support System

19.2.1. Security

19.2.2. Privacy/Firewall

19.3. TPS

19.3.1. get info from MIS

19.3.2. secure online transaction system

19.4. DSS

19.4.1. Find matches because value proposition is based on matching correct data

19.5. Data Warehouse

19.5.1. important to keep all profiles

19.5.2. back up system required

20. New node

21. New node

22. New node

23. Group 309 - MoveIT

23.1. CRM and text mining for customer feedback

23.2. DSS for scheduling workers and trucks

23.3. MIS for ranking employee skills,

23.4. MIS preliminary quotes for customer

23.5. TPS - invoicing and billing

23.6. data mining for analyzing industry trends

23.7. TPS for tracking vehicle mileage, and other expenses

23.8. DSS to forecast demand during changing seasons

24. New node