MLDM Monday -- Large Scale Data Series

Chia-Chi (c3h3) 0988209252

Wush Wu 0973687970

在這系列的演講中，第二場，我們很高興能邀請到台灣 Yahoo EC Team 分享在 2013 Hadoop Summit (http://hadoopsummit.org/) 所演講的題目 - Big Data Easy BI ，投影片連結 (http://www.slideshare.net/Hadoop_Summit/big-data-easy-bi)。

本次的聚會的議程為：

1910 ~ 1920 Warm Up

1930 ~ 2000 Big Data Easy BI (Tim, Giivee and Neal)

Abstract:

the Yahoo EC Taiwan team provides business performance matrix to users by acquiring data from the Web production and Back office ERP systems. The reporting system is built using traditional BI technologies such as RDBMS, ETL tools, OLAP tools, home-made reporting tools, store procedures, web pages,?. With increasing usage growth of the user browsing data in the business decision on daily basis, The ability to provided data analytics on these Big Data is getting more and more important and needed. The traditional RDBMs have reaching its limit in process big data while connecting to OLAP tool. We started with the feasibility of connecting MicroStrategy with Hive 0.9 and created a prototype system to test in two scenarios – ad-hoc query to Hive and performance test of the predefined MicroStrategy Intelligent Cube for ad-hoc analytics. We did the performance test on Ad-hoc query via HiveQL and query from MicroStrategy cube, and will share the result in the session. Based on our test results, we will be able to provide the following applications to different types of users. A) Ad-hoc query running against Hadoop can allow well trained data analyst or power users to have deeper analysis on data within Hadoop. OLAP reports running against MicroStrategy Intelligent Cube can provide quicker response time on ad-hoc analytics with predefined data in Cube.