COMM391 Section 103 Phase 4

Get Started. It's Free
or sign up with your email address
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 305:VANRealty

2.1. TPS

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

2.2. DSS

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

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

2.3. MIS

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

2.3.2. Monthly/Weekly reports for sales

2.4. Data Visualization:

2.4.1. to show where houses are available

2.4.2. to show areas with the most income

2.5. OLTP

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

2.6. Data Mining

2.6.1. to show where people are currently buying houses

2.6.2. show people losing/gaining jobs

3. Group 306 City Workforce

3.1. MIS Database

3.1.1. Text mining Resumes Applications Job Postings Personality Report

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

3.2. Support System

3.2.1. Security

3.2.2. Privacy/Firewall

3.3. TPS

3.3.1. get info from MIS

3.3.2. secure online transaction system

3.4. DSS

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

3.5. Data Warehouse

3.5.1. important to keep all profiles

3.5.2. back up system required

4. Group 307 Van Realty

4.1. Objective

4.1.1. Optimal customer care with lowest possible brokers fee

4.2. Technologies to succumbing objective

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

5. Group 303

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

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

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

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

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

6. Group 310

6.1. TPS-Routine Operational

6.1.1. Payroll collected to distribute to employees

6.1.2. Payroll tracking to gather from employers

6.1.3. Standard wages for typical jobs

6.2. MIS-Summary

6.2.1. sales (number of connections made)

6.2.2. Back-up system in case of downtime

6.2.3. Current available supply and demand

6.3. DSS-Decision Analysis

6.3.1. Forcasting of the demand for employees

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

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

6.3.4. Give ratings for the compatibility between employers and employees

6.4. EIS- High Level Decisions

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

6.5. Security system to guard against privacy breaching and theft

6.6. Data Warehouse

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

7. Group 302

7.1. MIS

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

7.2. DSS

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

8. Group 301 MoveIT

8.1. Our Information Needs

8.1.1. Trends and Preferences of our Customers

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

8.1.3. Which areas in Vancouver need the most housing transactions

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

8.2. Technology Needed

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

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

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

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

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

9. Group 308

9.1. MIS

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

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

9.2. TPS

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

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

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

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

9.3. DSS

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

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

9.3.3. Using data from TPS to

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

10. Group 304

10.1. MIS

10.1.1. Mapping performance Data Mining finding profitability returns on investments

10.2. TPS

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

10.2.2. # of trades made of investments etc

10.2.3. # of visits to advisors

10.3. DSS

10.3.1. To decide the rate of fees charged etc.

10.3.2. To decide where to invest funds

11. Group 316

11.1. What information technologies need to be in place

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

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

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

11.1.4. MIS summary reports Sales management systems

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

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

11.2.1. Microsoft Access

11.2.2. Computers Internal servers

12. Group 317

12.1. MIS

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

12.2. DSS

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

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

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

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

13. Group 318

13.1. TPS

13.1.1. Staff payroll

13.1.2. Patient billing

13.1.3. medical supply inventory

13.1.4. patient booking

13.1.5. staff hours

13.1.6. payments to suppliers/partners

13.2. MIS

13.2.1. Productivity reports

13.2.2. Patient retention statistics

13.2.3. Peak hours of operation

13.2.4. Management of perishable inventory

13.3. DSS

13.3.1. Financial management (investments)

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

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

13.4. EIS

13.4.1. summary of productivity

13.4.2. summary of efficiency

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

13.5. Data Mining

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

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

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

14. Group 314

14.1. Information Technology Needs

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

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

14.2. Addt'l Tecnology

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

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

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

15. Group 320

15.1. Operational (TPS)

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

15.2. Management Control (MIS/DSS)

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

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

15.3. Data mining

15.3.1. run correlations between sales and cx profile

15.4. Data warehouses

15.4.1. collection of our data from different sources

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

16. Group 312

16.1. DSS

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

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

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

16.2. TPS

16.2.1. Record transactions of each move that we perform

16.2.2. Invoice/ billing system for each transaction we complete

16.2.3. Scheduling System for employees and trucks

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

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

16.3. MIS

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

17. Group 311

17.1. TPS

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

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

17.1.3. Manage specific orders from customers.

17.2. Data mining

17.3. MIS

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

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

17.4. DSS

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

18. Group 319

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

18.1.1. Store this in the Op. DB.

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

18.2. TPS: billing clients, payroll, reports.

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

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

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

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