{"title":"基于Power BI的大数据分析在销售预测中的应用","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":"{\"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}","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}
Application of Big Data Analysis Based on Power BI in Sales Forecasts
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.