This paper introduces various techniques needed to create large-scale, highly available online analytical processing (OLAP) sites. It also provides step-by-step instructions that demonstrate how to use OLAP and Real-time System analysis processing mechanism of stock website. This paper introduces various techniques needed to create large-scale, highly available online analytical processing (OLAP) sites. It also provides step-by-step instructions that demonstrate how to use OLAP and Real-time System analysis processing mechanism of stock website.