The 3 steps of best data warehouse model design with leaning implementation for sales transaction in franchise restaurant

Doing Data Warehouse (DW) to your business or system is not only think about the trend only, but how to understand the DW knowledge itself and how to implement it. DW as a real technology of Artificial Intelligent (AI) which show up as how to think like a human, inevitably help the human particularly in making quick decision reports. Doing DW to your systems should apply to the mother knowledge of AI which we recognized as Software Engineering (SE) where we should apply best software application in more importantly we should satisfy the user. In order to make a good DW model design as user expectation then we should apply 3 steps such as collect all the needed reporting, order all the reports start from the most needed reports and mapping all the ordered reports into fact constellation schema. In this paper the 3 steps to model DW schema is applied in sale transaction in franchise restaurant as an example data. Building franchise restaurant must supported by information technology such as Data Warehouse (DW) in order to manage and control the business process, the branch, the sale, the staff and so on.