{"title":"Application of Big Data Analysis Based on Power BI in Sales Forecasts","authors":"Yitong Liu, Xi Chen","doi":"10.1145/3569966.3571272","DOIUrl":null,"url":null,"abstract":"Microsoft Power BI is a business analysis tool based on big data. It compiles single view, multi-panel displays for interrogation of data and quick decision-making. With the help of Power Bi software, according to the historical sales amount, this paper uses the rolling forecasting method to determine the sales growth rate and make sales forecasts. On this basis, measures such as ForecastAccuracy, ForecastAccumulation and SalesAccumu-lation are created. By making visual charts in Power Bi, analyze the trend of the accuracy rate of sales forecasts, and compare the cumulative difference between the sales forecasts and the actual sales, so as to help enterprise carry out budget management more scientifically and effectively.","PeriodicalId":145580,"journal":{"name":"Proceedings of the 5th International Conference on Computer Science and Software Engineering","volume":"17 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-10-21","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 5th International Conference on Computer Science and Software Engineering","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3569966.3571272","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
Abstract
Microsoft Power BI is a business analysis tool based on big data. It compiles single view, multi-panel displays for interrogation of data and quick decision-making. With the help of Power Bi software, according to the historical sales amount, this paper uses the rolling forecasting method to determine the sales growth rate and make sales forecasts. On this basis, measures such as ForecastAccuracy, ForecastAccumulation and SalesAccumu-lation are created. By making visual charts in Power Bi, analyze the trend of the accuracy rate of sales forecasts, and compare the cumulative difference between the sales forecasts and the actual sales, so as to help enterprise carry out budget management more scientifically and effectively.