Published June 30, 2022
| Version v1
Journal article
Open
Visualization of Relational Databases
Creators
- 1. Kyiv National University of Culture and Arts, Ukraine
- 2. National Transport University, Ukraine
Description
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.
Files
Visualization_of_Relational_Databases.pdf
Files
(1.6 MB)
| Name | Size | Download all |
|---|---|---|
|
md5:03fde70bf7f5c74255d76362290d7fb7
|
1.6 MB | Preview Download |
Additional details
References
- Bulyha, O.A., 2022. Zghurtovane simeistvo prohram MS Power BI [Cohesive family of MS Power BI programs]. Kyiv: Foliant.
- Ohliad zvedenykh tablyts i zvedenykh diahram [Overview of summary tables and summary charts]. [online] Available at: <https://support.microsoft.com/uk-ua/office/%D0%BE%D0%B3%D0%BB%D1%8F%D0%B4-%D0%B7%D0%B2%D0%B5%D0%B4%D0%B5%D0%BD%D0%B8%D1%85-%D1%82%D0%B0%D0%B1%D0%BB%D0%B8%D1%86%D1%8C-%D1%96-%D0%B7%D0%B2%D0%B5%D0%B4%D0%B5%D0%BD%D0%B8%D1%85-%D0%B4%D1%96%D0%B0%D0%B3%D1%80%D0%B0%D0%BC-527c8fa3-02c0-445a-a2db-7794676bce96> [Accessed 15 January 2022].