<script type="text/javascript">
<!--
document.write('<div id="oa_widget"></div>');
document.write('<script type="text/javascript" src="https://www.openaire.eu/index.php?option=com_openaire&view=widget&format=raw&projectId=undefined&type=result"></script>');
-->
</script>

COPY SCRIPT

For further information contact us at helpdesk@openaire.eu

Visualization of Relational Databases

Name: Visualization of Relational Databases
Keywords: Pivot Table, pivot chart, MS Excel, Power Pivot, database, Power Query, data scheme

descriptionPublicationkeyboard_double_arrow_right Article 30 Jun 2022Publisher:Kyiv National University of Culture and ArtsJournal:Digital Platform: Information Technologies in Sociocultural Sphere, volume 5, pages 83-89 (issn: 2617-796X, eissn: 2618-0049,

Authors: Bulyha Kostiantin; Bulyha Olena; Huzii Mykola;

doi: 10.31866/2617-796x.5.1.2022.261292

Visualization of Relational Databases

- Summary
- Subjects
- Metrics

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.

Related Organizations

National Transport University
Ukraine
Kyiv National University of Culture and Arts
Ukraine

Keywords

Pivot Table, pivot chart, MS Excel, Power Pivot, database, Power Query, data scheme

Impact byBIP!

	citations This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).	0
	popularity This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.	Average
	influence This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).	Average
	impulse This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.	Average

Usage byUsageCounts

visibility	views	20
download	downloads	8

20
views
8
downloads
Powered by

Found an issue? Give us feedback

visibility

download

Average

Green

gold