Data Analysis and Visualization of Road Accident Using Power BI

Abstract

Power BI has taken the world of business intelligence, data visualization and analytics by storm. Power BI is an online service that enables searching data, transforming it, visualizing it, and sharing the developed reports and dashboards with other users in the same or different department/organizations or even with the general public. As of February 2017, more than 200,000 organizations across 205 countries are using Power BI. Power BI is having a free option that has adequate features and functionality , it has become a serious contender for use as a business intelligence platform in small and medium organizations. One of the innovative features of Power BI is its Quick Insights feature (Michael Hart, 2017) that is built on a growing set of advanced analytical algorithms. After uploading a dataset to Power BI, a click of a button can be used to invoke this feature that automatically builds many reports based on its analysis of the data, without any human intervention being required. This also helps reduce human errors, in calculations and statistical techniques, which lead to un-verifiable research. Accepting even Excel spreadsheets as input, Power BI is easy to use and ripe for adoption as a platform for Research Data Analysis. In this paper, an attempt has been made to show how easily a dataset of research data can be transformed by Power BI into a set of analytical reports and dashboards, and which can be shared with ease.

Introduction

I. INTRODUCTION

Road accident is world main problem. Every day we watch the news of road accident on the TV, Internet. The main causes of road accident are human behavior. The major causes of road accident are human carelessness in our country. Under the causes of road accident the carelessness is one of the most important factors in road accident. In road accident cause include breaking the traffic rules, using the mobile phone when driving .the another causes of road accident is inexperience driver and untrained drivers. At night time most of the driver drives the vehicle under the influence of alcohol it is also main factors which contribute in road accident.

High speed, increasing no of vehicles, carelessness among road user and many other reasons are said to be linked to road accident. The problem of deaths and injuries as a result of accidents is to be a global phenomenon.  Traffic safety has been a serious concern since the start of the automobile age, almost one hundred years ago. It has been estimated that over 300,000 persons die and 10 to 15 million persons are injured every year in road accidents throughout the world.  Statistics have also shown that mortality in road accidents is very high among young adults that constitute the major part of the work force.  In order to overcome this problem there is need of various road safety strategies, methods and counter measures. The survey was conducted on different causes of death due to injury.

II. METHODOLOGY

Power BI Apps are the crucial components at user side where viewing and accessing of dashboard through some applications such as Power Apps, Mobile Power BI...etc., Power BI connectors leads crucial role in getting data from the database and other sources using connector application such as database engines, Azure Consumption Insight Connector…etc. The general operations of Microsoft Power BI are as follows: 1) Get the Data from Required Data Source2)  Analyse the data by means of connectors and gateways of organization3) Build the Report by means of Different Visuals and Filters4) Publish the Report into web through Power BI Desktop5) Edit the report if any changes are needed and make shareable by means of publishing on to web option for creating embed URL 6)Access the report data from different applications of Microsoft such as Power Apps, Mobile Power BI 7) Refresh the data using different gateways of Organization for updating the dashboard. In this paper, we discussed on process model and Visuals of the Power BI tool and interactive data visualization technique for analysis and design of educational institution data visualization using Microsoft Power BI tool.

1. Data Collection: Data Collection is the process of gathering and measuring information on targeted variables in an established systems, which then enables one to answer relevant questions and evaluate outcomes.
2. Data Storage: Power BI uses two primary repositories for storing and managing data: Data that is uploaded from users is sentto excel sheet.
3. Data Cleaning­: Once the data is stored into power BI it is important to clean and transform data before you build any visualizations or reporting .This is essential step in building quality visualization. Cleaning and transforming data enables to build visualizations from sound and clean data. If it is not done diligently visualization will not behave as we except
4. Data Analysis: Data analysis is a process of inspecting, cleaning, transforming and modelling data with the goal of discovering useful information, informing conclusions and supporting decision making We use DAX (Data Analysis Expressions) for Data Manipulation and working on the data.
5. Visualization: In this process we convert manually data into visualization is to visually display collected data by using various charts, graphs or other visualization types.

V. RESULTS

Total CY Casualties 182.6k decreases -11.9% Total CY Accident 144.4k decreases -11.7%  CY Fatal Casualties 2.9k decreases -32.5%   CY Serious Casualties 27.0k decreases -16.2%  CY Slight Casualties 165.8k decreases -10.6%

Conclusion

Overall, the objectives of this research were met. Through visualization, data analysis aids pupils in comprehending concepts. Various technologies are available to undertake corporate data analysis, however the Power BI visualization technique is the most popular technique for learning the fundamentals of data analysis. With the help of the visualization technique, data interpretation and data representation may be done quickly and easily. This strategy is highly useful for stronger conceptual design.

References

[1] Sonia Singla, “Getting Started with Data Analysis using Power BI” [Online]. Available: [2] https://www.analyticsvidhya.com/blog/2021/11/getting-started-with-data-analysis-using-power-bi/Effective Businesss Intelligence Solutions, “BUSINESS INTELLIGENCE TRENDS IN 2022” [Online]. Available: https://ebisgroup.com/business-intelligence-trends-in-2022/ [3] Adamala, S. & Cidrin, L. (2011). Key Success Factors in Business Intelligence. Journal of Intelligence Studies in Business, Vol. 1(1) [4] Microsoft Documentation, 2017, “What is Power BI”, Accessed online at https:// powerbi.microsoft.com/en-us/what-is-power-bi/ [5] Priyanka A. Nandurge & Nagraj V. Dharwadkar “Analyzing Road Accident Data Using Machine Learning Paradigms”, 2017 IEEE pp. 604-610. [6] Microsoft, 2017, “Guided Learning”, Accessed online at https://powerbi.microsoft.com/en-us/ guided-learning/ [7] Michele Hart, 2017, “Create a new Power BI report”, Accessed online at https:// powerbi.microsoft.com/en-us/documentation/ powerbi-service-create-a-new-report/

Copyright

Copyright © 2023 Omer Abdullah, Mohd Yousuf . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.