Data warehouse is used to integrate your database. Data mining is an analysis tool that enables organizations to determine relationships between internal and external factors. The question for this map has two parts. You did not answer the first part which was at what level of organization will the data be used. Your map has identified the information that is being used in management control and strategic management. How about operational level? Relevance: Weak. Content: Adequate. Reasoning: Adequate +. Overall: Adequate
A data transaction information system would make the data more accessible. It would increase speed and efficiency for the company.
Data Matching, Data Transaction Processing System: it would help us with our payroll systems, invoicing and billing system, accounts payable and receivables.
Data Mining, Find jobs that are popular for each month. Find trends in the general industry to help us in finding new jobs from the industry., We can get this from data from past years through websites like Stats Canada. For example information like sales by type of services, types of jobs, permanent placements, etc., Data Warehouse used to analyze the datas. For example we can make a slice-and-dice view of the data with the different provinces in the bottom and the different types of jobs. For example: Administration, Construction, etc., Recruiters, Recruiters would use this to forecast what types of workers to hire and which companies to advertise the workers.
So this types of data would be used at the administrative level of the general organizations of the workers and the clients.
Would have liked to have seen more detail, such as applications of the types of systems that you now know from class. Relevance: Adequate; Content: Weak; Reasoning: Weak Overall: Weak+
The data will be used to plan company objectives and long term goals
Using location from customers to introduce strategic marketing that's specific to location
Forecasting customer demand throughout the year by using the previous year's records as example and also seeing competitors schedules
Most efficient route to take during moving by using addresses and a system that calculates the route
Keep in contact with customer base with their phone numbers and email addresses
Database of shipment information, used to keep track of previous and current moves
Schedule employee schedules and trucks based on assignments
Data warehouses simply store your data, you will need data mining technologies to translate it into information. Would like to have seen an application of the types of systems you learned in class as well. Relevance: Adequate; Content: Adequate; Reasoning: Adequate Overall: Adequate
This information will be used to predict market conditions in the future as well as which current trends will continue. Based on these predictions, the analysts will be able to make effective decisions on how to manage their clients' portfolios., Based on the performance of brokers using this information, higher management can decide how to use HRM to incentivize good performers and retrain underperformers, Helps determine whether a trading strategy or practice is effective or not, based on the portfolio's and the broker's performance and returns.
This data would be made available using operational databases as well as data warehouses. The operational databases exist primarily to store and process these huge amounts of data whereas the data warehouses will translate this data into information for our analysts to use in decision-making tasks
Great job using the mind map to link all the levels of the organization where the data/information will be used. Relevance: Adequate+; Content: Good+; Reasoning: Good Overall: Good
The information is used at the strategic management level, Personalization: Also used by our staff to know more about clients' needs and improve and be efficient for the client's time at the clinic, The information gathered about medical details can be used by our doctors and staff, All of this is the for the long term strategic goal in improving customer service which we hope will give us a competitive advantage in the industry
Information from Phase 3 that can be used, Basic Patient contact information, E.g. Address, Emergency contact, relatives, etc., There may be correlations between certain information and transactions. E.g. People from a certain may be more inclined to demand a specific service or doctor. As such, the clinic might want to tailor certain package or promotions for an area., Medical Records, Specific preference, Services can be tailored to specific preference to make the service much more personalized. Eg. Food preference after surgery, etc., We aim to differentiate through personalization, and make customers feel that they are well taken care of. With this, we aim for retention of customers
How will it be used, Customer perspective, o Improving specific operations that have the highest numbers o Reduced appointment times before meeting with patients, more effiecient o Higher quality operations, more funds being allocated to the most popular procedures o Improvements to facilities that o Integration of popular communication devices/technology • Skype, SMS, email o Analyzing the most popular appointment times data to have more efficient hours of operation, Business Perspective, Using common prescription info to focus funds on highest selling drugs, Using personalized patient data for doctors to create more effective appointments, Allowing doctors to prepare for their multiple patients to develop more efficient
We will create a database which will keep a record of all our clients' confidential medical records and personal details
Very good detail about what info is being used for what purpose. Identifying industry’s trends is more in the strategic management level. The second part of the question was how to use the data? To answer this part you need to identify the information systems that are needed to help you get the information that require need (TPS, MIS, DSS, ESS) Relevance: Good. Content: Adequate+. Reasoning: Adequate. Overall: Adequate +
Operational Database, Moving details (eg. addresses), Truck and movers delivery schedule, Keeping an inventory of the boxes and equipment we moved
Managerial Database, Industry Trends: so that we will know which audience to reach out to, Age and background of people will help us to focus on the changing trends in the industry and allocate our sources more effectively to the changing demand (Eg. for students there is seasonal demand, highest number of moves in September and April), Forecast Demand of trucks and movers, ensure that demand meets supply, Demographics of potential client base, Understand the needs of the consumer (Eg. The location will help us to determine the type of houses which helps us estimate the number of movers and type of trucks to allocate to the move), we can tap on the data from property agents to gauge the frequency of moves in certain regions in vancouver and target the regions with the highest frequency., We can get the data from various institutions. For example, we can get the number ot students living in residence from the universities., Increase effectiveness of advertising once we have identified the target market
Good job on identifying of what level in the organization is going to use data. Need more detail about how DSS is helping to analyze what data! To analysis your data you need data mining system. Data warehouse as you mentioned is only used to store data Relevance: Good. Content: Good. Reasoning: Adequate +. Overall: Good
Sales: provide customers with a comprehensive moving package with updated information using TPS. It would be a routine transaction between employees and customers. Using TPS we would be able to update our files based on customer needs and provide them with a personalized service
Operations-Logistics: to track the truck at all times, relay the information to customers (TPS system) In that way we can monitor where trucks are and how many trucks in storage etc.
Logistics: Use MIS to seek information and summary reports on popular regions, and average distances travelled so we can make adjustments to inventory, cost analysis, and employees needed based on data from the TPS
Logistics: use DSS to analyze data from TPS/MIS to forecast for route planning, transportation scheduling
We would store new customer information on operational databases such as the MIS and TPS ones that we mentioned before, and we could later store these to a data warehouse to be analyzed.
Operational database should be used to carry out specific dat-to-day tasks. Building customer relationship and identifying the trends in the market are more managerial jobs and in the strategic management and management control levels. Relevance: Weak. Content: Weak +. Reasoning: Weak. Overall: Weak +
Analytical Database: Consumer trend Budget of housing Whether financial assistance is required by customers
Operational Database, Availability of Housing, Housing price, Multidimensional Data View through cube: to indicate which customers are important for us based on the value of business we have with them. This will be used to build customer relationship with them, DSS: This will be used to set up a marketing strategy for us, for example: keeping in touch with our customers. Predict the economic environment, Data Mining: to identify trends between economic conditions and property transactions that takes place
TPS: we use this to set up a good payroll system, commission system, New node
Good job outlining all the areas of datamed where the systems would lie. The only issue is that it might take awhile to implement it all, in the later phases start thinking of how you plan on implementing them. Relevance: Adequate; Content: Good; Reasoning: Good Overall: Good-
Operations: TPS, At the lower level, information would be gathered by patient's RFID tags, Store + record patient appointments, and patient records. Input will be created by doctors, Doctor schedule for the day; where they are, if they are on time, which rooms are usable
Operational Control: TPS, The data here would be used by doctors and receptionists - lower level employees. They would be provided with information to showcase their strengths/weaknesses and where they could improve efficiency (this would primarily come from patient interaction data). They would also be provided information on their schedules based on logistical information gathered from the appointment database and clinic overall schedule., Patient demographic trends could also present patterns such as which doctors are preferred by certain age groups and genders., Inventory management; for surgical and clinical supplies. This would allow us to anticipate needs based on inventory patterns., Each patient's records would be stored in a individual file, updated in the operational database after each appointment. Therefore when patients arrived doctor's could easily access their previous records, diagnoses, and how often they have been to the clinic.
Management Control: MIS, Patient Interaction records would be used to gather an idea of the most common diagnosis, and the symptoms these usually present with. This would allow doctors to more efficiently anticipate patient illness., Average appointment times based on symptoms at time of appointment would allow for efficient scheduling. If patients who commonly present with headache usually take a 20 minute appointment, we can ensure that when future patients present with the same symptom they are allocated 20 minutes., Strengths/Weaknesses of doctors would allow for quality and efficiency management. If one doctor can perform a surgery more efficiently then another then he should be scheduled to perform that type., Logistical information could be aggregated to determine which rooms are used most often, which cleaning rotation would be most effective (based on which rooms need cleaning when)
Very good detail about what information you need and why you need them. What information systems do you need to get those information? (TPS, MIS, DSS, ESS)? Relevance: Good.Content: Adequate.Reasoning: Good.Overall: Adequate +
collection of data pertaining to the stock market from sources such as Bloomberg and customer transactions while collecting information that is an aggregation of facts that is useful in management and decision making, information will be analyzed by primarily upper management, analyst and broker levels of the organization, upper management will be able to analyze the information they are provided to make strategic decisions decisions for the company. things such as:, through the use of data, analyzing and determining specific marketing strategies dependant on things such as varying demand in various locations, analyzing customers demand, this is possible through the tracking of different customers previous investment preferences and past transactions to effectively analyze our high and low demand products and which target markets are using those different products, The analysts will use the data to analyze the capital market updates, and essentially create the products that vanalyst provides, i.e. certain stocks we are reccommending, certain bonds, mutual funds that we have put together etc., Brokers recieve data from the analysts in form of products, and it is their job to analyze the clients they are dealing with in order to provide clients with products that are directly suited for their investment preferences, brokers play a critical role in the process as they are in direct contact with the clients and can understand their client prefences and be able to provide different clients with possible investment opportunities that tailor to thier investment preferences
Great detail about what information is needed and how you are getting it. You can also use DSS, MIS and ESS to help you make more efficient decisions. Relevance: Good. Content: Good +. Reasoning: Good. Overall: Good +
Supply Chain Data, Logistics Management, Data Mining willl provide us with information on where there are time lags and discrepancies in the system, and thus we can make implications as to where there is room for improvements., Operations/ Inventory Management, Insuring there is a constant communication between those that receive information on what products are needed and when ( as determined from the market research) and those who are in charge of getting the products from point a (farmers) to point b (the store), RFID- provides the inventory managers information, directly from the products being transported, that will allow them to monitor and better predict when products will be received, Will not need as much money tied up in inventory, Suppliers, Having clear communication between the company and the suppliers will allow the farmers to better predict when they need to have their crops and dairy products ready, have more reliable delivery system
Market Research will be used by Management and Sales Team, Management will use the market research in order to better understand the target market and how to better serve this market, We can keep a data warehouse that connects the date from all three locations and our online store- using Transaction Processing Systems that keep track of the routine transactions online and instore= OPERATIONS, This will provide management, business decision makers, and the customer service team with a well rounded view on the consumers demand, By knowing who we are serving, and what they are buying, we are able to provide the best possible service- from the top down., Management/ Decision Makers, Manage Inventory- Know the amount of inventory needed, and when, and who to get it from (a farmer, factories etc.)., Buying Trends- what products are popular at what points in the year. How much consumers are willing to pay., Know when to have more staff working. -scheduling, Set prices according to the consumer's willingness to pay and implement sales and discounts accordingly, Sales Team, Maximize their customer services by: Personalizing the shopping experience. Become educated on the most popular products. Provide advice and information., We are able to better predict trends for the future by analyzing this data. We are able to construct timelines and what is expected of us and when, easily accessible information that is organized according to sales volumes of specific products and the dates in which they are purchased
Good detail about the information that are needed for a smooth operation. But in order to find the trends in the market and predict some certain behavior of your customers, you need more strategic information systems such as ESS and EIS. However, the question is that what exactly do you need to know about your customers and industry? If there is a pattern in your past records, such as the increase in the demand for your service in summers and decrease in winter, you don’t need neither DSS nor ESS/EIS. Relevance: Good. Content: Adequate. Reasoning: Good. Overall: Adequate+
Value Proposition: MoveIt offers a personalized and fast moving service by using a detailed scheduling system that gathers and records customer moving preferences and needs prior to the move., Information: information about customers’ moving preferences and needs, The Data: The number of movers/trucks required for a certain move, the goods that we are moving, specific supplies required for the move, the time it takes for the move to be completed, Strategic Decision Making: Knowledge about past customer moves will help MoveIt better plan the resources required for future moves. EXample. Gathering data on the number of movers and trucks required for past moves, moveIT can make changes so that it can know the number of employees required, how to allocate employees across moves, and schedule an appropriate nnumber of moves that the company can actually fulfill, In order to collect this data MoveIT should use DSS. Customers can input the products that they are moving and where they are moving to. The DSS can suggest the number of employees and size of truck required. This will help better plan the moving process, therefore resulting in a faster move, Management Control: By monitoring past data on factors such as the time required to move, the number of movers required, MoveIT can make adjustments to it's future moves so that they can occur faster, In order to collect this data MoveIT should use TPS. This will help MoveIT keep a past record of data allowing them to forecast future demand/moving patterns, Operational Decision making: Data will help the data perform it's day to day tasks more efficiently and quickly. More specifically by knowing the products that are being moved beforehand and the layout of the house that the customers are moving into, this pre-planning will help make the move faster
Great map with good detail. Seems you have understood the importance of role of information in the success/failure of your business. The only comment would be that you can use more information systems (MIS, DSS, ESS/EIS) to help your business run smoothly and help your manages make more efficient decisions. Relevance: Good. Content: Good +. Reasoning: Good. Overall: Good +
Operational Control, We will use this control to figure out when to order new products, Up-to-date inventory database will be used to keep track of this, TPS, Will provide useful data for management decisions, Keeps track of customer orders. This is important because we need to ensure that orders are delivered to the customers on time and in a timely matter, Inventory-tracking, This is mentioned above with the up-to-date inventory database. However it is absolutely critical that we have a very easy to follow and update tracking system for our goods because we are pushing for quality on expired goods., Days/Weeks of delivery, The day/week of delivery that the customer wants is crucial to work exactly with our inventory-tracking system. If a customer wants a certain good to be delivered at the end of the week and we only have stock that expires at the end of the week than we are in trouble.
Strategic Management, Sales Data, Using past sales data on how much of each product is being bought/sold is a good indicator of trends that are occuring in the market. Using this information to buy a bigger supply of a very high demand product will satisfy our customers., ie. if data shows that "organic apples" were very high-in-demand for February 2012, we can expect the same high-demand for February 2013 and potentially make certain combos or deals to make them more appealing, Delivery Addresses, Delivery addresses are a great for strategic management because we are a delivery-based company. By checking if certain areas have higher-turnout than other areas can help us establish better routes as well as potential new warehouses, Demographic Information from our Customers, This will help with our marketing and branding for the future. By finding out what demographics are responding to our sales, we can easily focus on a much more targeted market that will have a higher success rate than other markets.
Management Control, Sales Performance, Though our company is not based on commission, sales performance based on which products are in high-demand at the moment can help us manage our warehouse team to manage our goods much more efficiently, Also, performance due to our expired goods (some may expire sooner than others) will give us a better system on which products need to get to certain deliveries sooner than others., High-Demand Goods/ Low-Demand Goods/Expiring Goods, All this data is derived from the inventory-tracking system above as well as the sales data from our website or from our store., This information would be used as a marketing technique to show on the website current TODAY DEALS on the front page. With regards to low-demand goods we can put them at a lower-price than usual (and keep this up-to-date). With high-demand goods we can place them in packages with other low-demand goods for a cheaper price as well
Operations, Employee Work-schedules, Self Explanatory, Needed for all day-to-day operations.
Great mind map, the only issue is that you have a LOT of systems. If you can justify the costs of their implementations than that's fine, but just keep it in mind that it might be better to focus on less technologies but that are needed for your core activities. Relevance: Adequate+; Content: Good+; Reasoning: Good Overall: Good
Information on quality of suppliers e.g. info on freshness, organic certification, appearance, taste etc., Strategic, EIS, This system would be set up to allow strategic management to determine quality objectives based upon the availability of quality attributes and their related prices., They should also relate this to customer info. in how customers responds (purchasing decisions) to products of different quality, and market data on consumer preferences., Operational, TPS, Implement decisions on which suppliers to accept based upon the objectives set by strategic management., Implement a quality control program, observing quality of products that come into store on a regular basis, and reporting it, so that there is up to date information about supplier quality, and the store's overall quality., This will be useful for strategic management.
Information about pricing (to ensure they are "reasonable" e.g. competitors prices, customers' willingness to pay etc., Management, MIS, Survey competitor pricing to compare with the Good Foods pricing., Measure differences in purchasing decisions related to pricing to determine price-elasticity of demand., Use this to set profit maximising prices.
Supplier Location, Management, MIS, Record location to determine cost of transport, length of time to transport (to determine effect on freshness/damage due to transport)., Use this info to help select suppliers, Operational, TPS, Use this info to determine distances to provide advice to customers on how far away produce is, for the environmentally conscious customers.
Customer info., Strategic, EIS, Observe information collected by operational level, use data mining to identify correlations which can be used for marketing decisions., Use information on purchasing frequencies to identify when there will be high demand for particular products, so that we can determine when to order products, ensuring they are as fresh as possible., Operational, TPS, Recording customer information through market/customer surveys or a loyalty programme, which could correlate customer attributes with purchasing habits (e.g. time of day/week/year, items purchased, frequency of purchases etc.
I would like to remind you that the mind map this week was to identify the levels of the organization where the data/information will be used, and so that should have been the starting point of your mind map branches. Relevance: Adequate; Content: Weak+; Reasoning: Adequate Overall: Adequate
Two main uses of the data, Operational accounting/scheduling purposes, Using data collected from each user of the system (temp employees and employers), will match available workers to job positions based on schedule compatibility., As scheduling is handled electronically, billing of companies and payment of employees can be performed by the system at the same time., Our extensive data on worker/workplace characteristics and worker/employee ratings will be mined to find correlations between these characteristics and job satisfaction and performance.
Two main methods of data collection, Applications of temp workers are done online. There are specific data fields that workers are required to select as part of registration (e.g., education, years of past experience in various industries, interests, personality characteristics, etc.). Companies communicate their requirements to us using a similar web-based system., Temps and employers complete surveys after temp assignments are completed. These surveys aim to measure overall satisfaction (worker's satisfaction with the jobs that they had, and employer's statisfaction with the
Good use of the mind map to branch out your ideas, just lacked a bit of detail in the branches but otherwise solid thought pattern. Relevance: Adequate; Content: Good; Reasoning: Good- Overall: Good-
The information from Phase 3 will be used in the Operational level, Inventory Management (Restock purposes), Controlling inventory--know when to submit orders, Demand forecasting (eg: different seasons, holidays, etc.), Keeping track of what products are most popular & in season, In order to help operations with their use of information, we will look to implement a data warehouse to store all the necessary customer data., Keeping systems/files up to date for current information, Data creation will be through the use of IT systems such as RFID which will provide us with the necessary information to operate on a daily basis, We will also look to use TPS to help us log transactions which will create valuable data for us to use not only for operational purposes but also aid management in decision making, Track online sales - most popular locations customers are ordering from, Offer discounts to customers in those specific locations (eg. sales data), Average distance for delivery
Management Level: Use data from operations to do secondary research in order to better understand customer trends and how to increase demand for organic products., Use of MIS (weekly summary reports of our organic food inventory), Data taken from TPS, Management level can observe demand of specific products and order more of the popular products, Sales reports, Track online sales - most popular locations customers are ordering from, Offer discounts to customers in those specific locations
How does the data from the surveys get transferred to management control? I think you need to redefine management control, because you seem to link everything from forecasting demand/supply, performance appraisal, pairing future employees with clients with it. Describe the Wiki's more in detail and what you mean by networked collective intelligence. Relevance: Adequate Content: Weak+; Reasoning: Weak+ Overall: Adequate-
Information such as graphic rating scales would be used in order to monitor performance of our employees, Data would be gathered from clients in the form of surveys and this data would go into management control in order for City Workforce to make adjustments in pairing future employees with clients., Performance Appraisal would be determined through computerized programs that keeps a track of a client's opinion on a employee based on the Behaviorally Anchored Rating scale (BARS) that is provided by City Workforce
Information about the industry, or the current economic trends would be sent to management control in order to allow City Workforce to adjust to the fluctuations in demand and supply., Information will be gathered from Stats Canada and stored at this level in order to ensure that there is no excess or lack of supply of employees., There will be personnel who focus on economic and market trends in order to better find statistics and prepare for changes in the market
City Workforce also wants to focus on Management by Objectives and then sending that data over to Management control in order to further future goals set between City Workforce and clients., Collaborative goal setting between manager and employee as well as manager and City Workforce in order to better keep records of goals or progress that employees have made as well as what is to be expected by the clients.
Data on individuals skills and aptitudes in the form of skills inventories would be collected and given to operational levels of decision making in order to properly divide employees into different target markets., This information will be gathered through computerized records summarizing employee's skills and so on, so that day to day computerized selection processes of employees to clients are not inaccurate
City Workforce wants to create personal "Wiki's" through the Networked Collective Intelligence, This allows for a high and effective way to store employee records
Your CRM solution conflicts with your performance mointoring of customers, to either keep serving them or not. Another issue was that you want to forecast data using a DSS, which could be problematic if you are a small company and will not have enough information to justify the implementation of a DSS as of yet. Relevance: Adequate; Content: Adequate; Reasoning: Adequate Overall: Adequate
Monitoring performance of employees and customers, make dedisions about whether to keep serving the customer or not, CRM - establishing effective relationships with customers. Activity level of agents, follow ups, referrals, coldcalls, walk ins, lead generation, TPS: TPS can help us process routine business transactions and minimize information lag time. VanRealty can use TPS to record routine and administration activities. This can help update storage and summarization of paper work. TPS processes cheques for commission payments to our agents. TPS also helps prepare necessary documents prior to when its needed to ensure minimization of lag time and hassle
Strategic: Forecasting demand and trends (economic, pricing, immigration, mortgage rates, demographics) to decide what type of people to recruit, and to provide effective training, Data will be collected through StatsCan, banks, economic and industry reports, customer profile tracking (CRM), MLS,, DSS: trying to anticipate the future of the of the market, economy, and customer trends. Using data from the past as a basis for our prediction. We want to be able to make quick flexible changes to adapt. DSS can help us analyze our decisions. We would like Demand Forecasting. VanRealty can use this system to decide what kind of training is needed for agents to adapt to the changing market.
Great job outlining all the areas that would be effected by your information and the systems that will ensue. One issue I found was how your plan to pre-screen applicants according to recruitment directives, what directives exactly? How does It come into play there? Relevance: Adequate; Content: Good+; Reasoning: Good Overall: Good
DSS: Executive management - Forecast supply to interpret trends in which fields there has been an increase/decrease of demand, Accordingly, make changes to recruitment and screening directives for all regional offices. Alter the organizational structure to, Alter organizational structure (transfer employees from one office to another, promote in key groups under development), Set/update company-wide goals, create the criteria for how corporate goals are being met., Seasonality of some kinds of positions?
MIS Textmining: Regional and bureau recruiters, Pre-screen applicants according to recruityment directives, Interpret changes in supply in different ares of specializations, Reference checks, Match employees to positions in a fast and efficient manner, Understand in which areas the applicant can improve and continue to develop their skills in those areas
MIS Textmining: Line workers, Interpret the job descriptions to match them with the best qualified candidates, Prioritize the needs of different employers, Match availabilities of candidates with employers
TPS: Line manager/Finance dept., Determine salaries for employees, Performance measure for employees, Refine revenue model (entail transfering information to the executive level), Breaking even?
DDS: Executive/branch manager level, Using industry data on subscription and readership (web vs. print) to gain insight on which employers are gaining market share and the areas they would like to develop, Work with company's in house HR department to determine their new hiring directives, and predicted demands