Centaline Group (the Group) is the parent company that owns Centaline Property Agency and Ricacorp Properties Ltd. The agent services provided covers residential, industrial and commercial property, shops, large-scale projects and developer projects. The Group deployed SQL Server 2014 CTPv2 and leveraged power BI in Excel 2013 and Office 365, a complete self-service BI solution. Through enabling power query, the data architecture team now can import corporate data tables from their SQL server database into excel. Together with users' participation, they create sophisticated data models using millions of rows of real estate transactions in power pivot and analyze the data directly on user's desktop, leveraging the in-memory technology.