Since 2007, China Trust has been issuing charity lottery. Taiwan Lottery is responsible for the actual lottery channels operation in order to accurately control distributors lottery sales, after careful assessment, MicroStrategy is the core platform of their decision supporting system.
For more than seven years since the very first issue lottery in Taiwan, no matter is Lotto, scratch or other lottery products are welcomed by lottery fans. Since 2007, the public warfare lottery distribution rights turned to China Trust, in order to fulfill contract commitments to the Ministry of Finance, Taiwan Lottery is responsible for the lottery operation, channel stations equipments and really need to accurate control lottery distributors and channels ranking, marketing activities and sales results analysis for flexibly adjusting marketing strategy and planning to launch better product or activity for lottery fans.
Therefore, Taiwan lottery needs one set of quick analysis in massive data volume decision supporting system in the shortest time, for providing real-time monitor of area sales points, channels revenue, consume material, expenditure ratio analysis for different level staffs, ; management level can also use dashboard system to monitor sales amount to confirm if reaching sales targets, and based on this result to adjust marketing strategies; strategy department is also able to control all types of lottery sales status, so that to introduce different combinations of products to stimulate sales revenue.
In the initial planning, Taiwan Lottery specially emphasized best efficiency and communication between systems in Metadata, and in need of ETL tools to support data upload to analysis system, and the most important requirement is the functions and reports in this analysis platform are user friendly or not. Among several vendors' competition, Taiwan Lottery chose MicroStrategy BI platform finally, main reasons were SolventoSOFT's implementation experiences and MicroStrategy product advantages. MicroStrategy is a complete business intelligence application IT platform, supporting for large data mining (VLDB) data processing and technology integration, MicroStrategy is a BI application in design to handle enterprise level massive data; IT departments can meet the requirements from marketing business in smallest human resource and time, and marketing business people are able to create required reports on their own with user friendly web interface by different security access and also creating dynamic multi-dimensional report analysis.
Lottery sales analysis is responding to different requirements from different levels of users, this analysis must equip high query performance, and also is capable to process frequent and massive data. MicroStrategy can easily handle large number updating data and also quick response to query; users retrieve reports at a very short time. After using MicroStrategy as the core of decision support system platform, Taiwan Lottery Company is able to accurately control distribution channels status to launch more popular products and activities successfully reaching planning objectives.
