Designing sales data mart system for ease of analysis and developing data mining model to enhance the promotional strategies for gamma pizza hut

Abstract

Making effective business decisions with the data is the key to succeeding in today's competitive environment. Organizations are now looking to improve their decision-making ability with their current data, but unfortunately operational systems have limited features and various ad-hoc reports for same data. This unsatisfactory & frustration lead the managers and IT industry to find new level of applications. These applications focused on ease of analysis on the single screen to make effective decisions at the time and mining techniques help to generate new business opportunities by providing prediction oftrends and behaviors as well as discovery of previously unknown or hidden patterns. The DSS/B1 systems should have more analyzing features and structured data. But current OLTP data and its database design not give much more analyzing power. In order to that OLAP architecture has built from various database vendors to make to use by DSS /BI systems. The developing of a data warehouse database and Data Mart database with suitable schema and approaching with relevant architecture is make a foundation for DSS/BI systems The Data warehouse database makes on available history data as possible of getting last update record. The fact and dimension structure are used when designing database schema for Data Warehouse. ETL process generate a data to warehouse from various data sources. The Data Marts are used for holding various subject areas like sales, purchase, production, finance, etc. But here only considering about sales and delivery data only. The Data Cube Technology (OLAP technology) is used for end user to viewing data with various dimensional and drill-down drill-up processes within the application. Finally those data are used to mining frequent patterns, Associations and Correlations between items in menu orders by using apriori algorithm (Microsoft Association algorithm) and forecasting Predictive sales for each item by using ARIMA algorithm (Mircosoft Time Series) The data warehouse solution can be made from by integrating various database technologies in the middle; those technologies include SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Server (SSAS), SQL Server Report Service (SSRS) and SQL Server Data Tools for Visual Studio used to create Analyzing project and Data mining project. C# language, DMX and MDX queries are used to build the simple mining application.