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