Nowadays, Enterprises are seeking to leverage each market’s data to be more insight driven in its operations. They intend to achieve this by implementing a consolidated data lake to centralize the information from core systems (ERP, DMS, CRM and excel; extending to market data, demographic data, marketing analytics, social media, mobile apps and others in the future) and integrating visualization capability longer term there is a vision to extend this into predictive analytics and automation (BI). The true power of a business intelligence system which relies upon a data warehouse comes from using conformed data dimensions to help analyze and drive business decisions. For example, one system may refer to a customer as someone who has purchased goods within the past twelve months. Another system may define a customer as any company who has ever been in contact about services. By understanding the needs and importance of data analysis, We have built a Data Warehouse based on MS Azure Data Warehouse. It is a modern data warehouse lets you bring together all your data at any scale easily, and to get insights through analytical dashboards, operational reports, or advanced analytics for all your users. The following is our approach how to organize a successful implementation of a DW/BI project. Key factors to implement a data warehouse project success: Focus on the business’s needs, present dimensionally structured data to users, and tackle manageable, iterative projects. In the below diagram we propose a best practice lifecycle roadmap for a DW/BI project, all these factors are reflected in this diagram.
SAMPLE OF BI DASHBOARD
Some BI Dashboard Templates that HQsoft has built and developed for DMS are based on the data aggregation and processing according to the DW & BI model as above:
Sell-out Analytic Dashboard
Sell-in Analytic Dashboard
Inventory Analytic Dashboard