Visualization of Relational Databases

Abstract

The purpose of the article is to demonstrate the relational databases visualization algorithm using MS Power BI software products in MS Excel. The research methodology is cloud information processing technologies. The novelty of the study is the implementation of the relational database visualization algorithm using MS Power BI software products in MS Excel. Conclusions. Using MS Power Query and MS Power Pivot software in MS Excel allows you to present visually summary information from databases. The example of connecting these products to the database management system (DBMS) MS Acces shows the ability to visualize the database using summary tables and charts.