My name is Shirui from Nations Info Corp (in short NIC). I'm currently working for NIC as a business intelligence analyst.
Our company is a middle-sized company with 8 major departments in Internet industry. We provide information of properties for both people who want to buy house and people/agent who what to sell house.
The business challenge is that as a BI analyst I need to prepare and provide profit and loss table to our Marketing Department for each partner and each brand in each month.
In order to provide this table, the raw data to be queried are over millions of records in 8 big joined tables with 4 major data types, such as Date-Time, Integer, Big Integer, Text. Since the nature of these tables are very complex, we have to generate this report by our BI analyst. This means BI analyst has to repeatedly work on that in each month and business stakeholders need to wait for querying large amount of data even they only need small changes sometimes.
Before, we used traditional methods: writing queries and changing the code for all partners and all brands in every month. We usually spent at least 3 days on this project to prepare queries and wait for querying data. There is extra working hours if business owners have other requests and again extra hours for waiting the query. It's not scalable, so we decide to pull SiSense in so that every business stakeholder can play with the table and find other insights by themselves. After we implemented this project with SiSense, for our BI department, we save at least 3 days for each month. For business owners, they are able to query data whenever they need and to focus more on their analysis part.
Please sign in to leave a comment.