_SLIDE_1_
MIS
For 120 Dasan call center
_SLIDE_2_
Index
Introduction
Problem
Solution
Effect
Conclusion
_SLIDE_3_
Introduction-Current situation
120 Dasan call center
Opened in Seoul, in 2007 by Seoul city hall.
Centralized center used for the purpose of dealing with
a large volume of civil complaints.
Settle a civil complaints through telephone, text message and
home page.
_SLIDE_4_
Introduction-Business system
Citizen
Free service for inquiries
Civil complaints
Advertiser
What(»óÇ°³»¿ë)
What effect (±¤°íÈ¿°ú)
Which medium(±¤°í¸Åü)
Advertising expense
_SLIDE_5_
Problem
1. 120 Dasan call center Free service for inquiries
Call center is operating at deficit.
Call center does not know changes in revenues and expenses.
2. Counselor arrangement is not efficient
-¡¦(»ý·«)
3. Complaints processing speed is slow
4. User satisfaction rate is generally low.
|
now what relations exist among several tables
- Able to know primary keys and foreign keys
Make a database using MS-Access
Remove version problem among departments
_SLIDE_12_
Solution 2 Specifying profit with XL MIner
Discrimination between used or unused 0 / 1
_SLIDE_13_
Solution 2 Specifying profit with XL MIner
Association Rules foundation of classifacation tree
_SLIDE_14_
Solution 2 Specifying profit with XL MIner
Classification Tree
- Divided by Step
_SLIDE_15_
Solution 3 Esitimation profit with XL-Sim
To analyzing Finacial report Using Profit Simulation
_SLIDE_16_
Solution 3 Esitimation profit with XL-Sim
_SLIDE_17_
Solution 3 Esitimation profit with XL-Sim
¡æ This Graph able to figure out what is the worst profit in the worst situation up to the best situation with the best profit as well
_SLIDE_18_
Conclusion
Management by database
- Recording customer¡¯s data immediately
- Improving Efficiency of Data handling