Map Out The Best BI Tool And SPC Software For A Case Company

https://drive.google.com/open?id=1Dy_vBhqlAgw0fFOeAhZMqn9DkLCesi2T&usp=drive_fs

Business Intelligence (BI) is about delivering relevant and reliable information to the right people at the right time to make better decisions faster. To do this, I require methods and programs to collect unstructured data, convert it into information, and present it to improve business decisions. There are many types of BI tools available on the market that perform these tasks. On the other hand, Statistical Process Control (SPC) is used to control the process with the help of statistical tools and techniques. It helps me monitor and control the process, reduce variations in the process, improve product quality, and so on. In this thesis, my main goal is to find the best BI tools and SPC software for Valmet Automotive, a Finland-based automobile manufacturing company. Valmet Automotive is one of the world's top producers of automobiles and batteries. Our organization uses BI and SPC tools for data analysis, visualization, and processing. Nevertheless, we have faced challenges in employing these instruments at various periods. I started this thesis to find possible BI and SPC technologies for our organization so that we can solve the problem. Every software must satisfy ISO 9000-3, an international software development and quality assurance guideline. Furthermore, every software must maintain ISO-9126, a quality model that determines the evaluation of software quality. My software selection processes are based on ISO 9000-3 and ISO-9126. My first goal was to find the best BI tools and SPC software for our organization based on its specific needs. Therefore, to map out potential BI and SPC tools, I picked 30 BI tools and 13 SPC software from the huge amount of similar software in the market. At this point, all the needed map-out criteria and software names were organized in Excel, and I evaluated each tool on a scale of 5 for each criterion. I used math to get the total weighted score for each tool. Furthermore, I used mathematical computation methods to complete the procedure. After completing the whole procedure in Excel, I enlisted the assistance of code. Consequently, I used the Python programming language to calculate the overall score. After computation, using Python visualization libraries, I identified the top five BI tools out of thirty and the top three SPC tools out of thirteen SPC software. In the case study, I also found the best BI tool and SPC software for our company by using visualizations. In the findings, Microsoft Power BI was the best BI tool, and SPC for Excel was the best SPC software for our case company. Therefore, our case company, Valmet Automotive, chose Microsoft Power BI as its leading BI solution. In addition, the research involved a comprehensive statistical analysis, including descriptive statistics, correlation analysis, hypothesis testing, and regression analysis, to examine the selection process of SPC tools and BI tools in the case company. Mostly, the methods and calculations are done for our case company's best tool selection. However, in the future, any company that needs good quality BI tools or SPC software can follow my methodology and calculation methods to select the best BI tools and SPC software available on the market at that time for their needs