Strategy for formation of visualized content by Power BI Desktop

Author(s) Collection number Pages Download abstract Download full text
Havrysh B. M., Durniak B. V., Tymchenko O. V., Ізонін І. В. № 1 (62) 115-121 Image Image

As it is known, data is the blood of today’s business. Data collection, processing and reporting is an important process that can involve dozens of people from different departments of the company. Such departments often generate tons of paper in which you can not only get lost, but also just drown. Microsoft allows one to unify and automate this process using a specialized cloud solution.

Microsoft Power BI is used to generate reports and visually analyse company data. The system is able to connect to a wide range of data sets, and transform information in the best way to understand.

Collection and analysis of large amounts of data is becoming an increasingly popular area. The need to find patterns in large databases complicates the non-trivial task of analysis. This situation is especially typical for businesses related to retail, telecommunications, banks, the Internet. Their databases accumulate a huge amount of information related to transactions: checks, payments, calls, logs, etc. The paper defines visualization as the transfer of information and content in the form of visual images, the transformation of raw data into ideas that can be easily interpreted and understood. The purpose and meaning of data visualization: to see your data “from above”, to see the general picture of the situation; mark global trends or unexpected deviations; look at what is happening from a different angle. The practical result of data visualization is decision-making ‒ in business, science; birth of a new idea; awareness of the situation.

In this work, data collection is carried out by developing a certain algorithm, visual analysis and data research for an industrial enterprise. A review of various types and forms of data display is performed. The algorithm for collecting and processing information from various files is implemented. The principle of the Power Bi service operation is studied. All this is relevant because of the increase of the amount of information as well as finding, displaying and analysis of certain data from the total for specific needs.

Keywords: visualization, databases, statistics, data sources, content formation.

doi: 10.32403/1998-6912-2021-1-62-115-121

  • 1. Kotturu, P. K., & Kumar, A. (2020). Data Mining Visualization with the Impact of Nature In­spired Algorithms in Big Data. 2020 4th International Conference on Trends in Electronics and Informatics (ICOEI)(48184), 664–668. doi: 10.1109/ICOEI48184.2020.9142979 (in English).
  • 2. Ahmad, A., Rahman, M. A., Sadiq, B., Mohammed, S., Basalamah, S., & Wahiddin, M. R. (2015). Visualization of a Scale Free Network in a Smartphone-Based Multimedia Big Data Environment. 2015 IEEE International Conference on Multimedia Big Data, 286–287. doi: 10.1109/BigMM.2015.48 (in English).
  • 3. Tardío, R., Mate, A., & Trujillo, J. (2015). An iterative methodology for big data management, analysis and visualization. 2015 IEEE International Conference on Big Data (Big Data), 545–550. doi: 10.1109/BigData.2015.7363798 (in English).
  • 4. Liang, T. (2020). Design and Implementation of Big Data Visual Statistical Analysis Platform, 2020 2nd International Conference on Machine Learning, Big Data and Business Intelligence (MLBDBI), 287–291. doi: 10.1109/MLBDBI51377.2020.00061 (in English).
  • 5. Ali, S. M., Gupta, N., Nayak, G. K., & Lenka, R. K. (2016). Big data visualization: Tools and challenges. 2016 2nd International Conference on Contemporary Computing and Informatics (IC3I), 656–660. doi: 10.1109/IC3I.2016.7918044 (in English).
  • 6. Kumar, O., & Goyal, A. (2016). Visualization: A Novel Approach for Big Data Analytics. 2016 Second International Conference on Computational Intelligence & Communication Technology (CICT), 121–124. doi: 10.1109/CICT.2016.32 (in English).
  • 7. Collie, R. (2016). Power Pivot and Power Bi: The Excel User’s Guide to Dax, Power Query, Power Bi & Power Pivot in Excel 2010–2016. (in English).
  • 8. Ferrari, A., & Russo, M. (2020). Analiz dannyh pri pomoshhi Microsoft Power BI i Power Pivot Dlja Excel (in Russian).
  • 9. Havrysh, B. M., Selmenska, Z. M., & Komar, S. M. (2020). Osnovy infohrafiky. Lviv : NV LPT Ukrainska akademiia drukarstva (in Ukrainian).