EMG data warehouse with excel-based visual analytics

Luka Lampret (2012) EMG data warehouse with excel-based visual analytics. EngD thesis.

Preview

Abstract

The aim of the thesis was to demonstrate that a state-of-the-art solution for management and analytical visualization of data can be implemented based on Excel 2010. We used a large and complex database of measurements of electrical activity in uterine smooth muscles during pregnancy in an animal model (pregnant sheep). The thesis comprises two parts. The first part fully exploits the functionalities of the latest version of Excel – ranging from advanced formulas through controls and VBA code to sparklines – for graphing measurements according to the user's demand. In the second part, we used the PowerPivot add-in to overcome the limitations and implement interactivity in Excel's charts, which enabled us to combine all the data in one file and manipulate them effortlessly. In this way, we produced an OLAP application that takes into account all the relations within the data and efficiently implements high-quality visual analytics using Excel's charts.

Item Type:

Thesis (EngD thesis)

Keywords:

electromyography, data display, interactive visualization, spreadsheet, VBA, Excel, PowerPivot, OLAP

Number of Pages:

Language of Content:

Slovenian

Mentor / Comentors:

Name and Surname	ID	Function
prof. dr. Blaž Zupan	106	Mentor
doc. dr. Gaj Vidmar		Comentor

Link to COBISS:

http://www.cobiss.si/scripts/cobiss?command=search&base=50070&select=(ID=00009077076)

Institution:

University of Ljubljana

Department:

Faculty of Computer and Information Science

Item ID:

1652

Date Deposited:

02 Apr 2012 22:22

Last Modified:

12 Apr 2012 22:12

URI:

http://eprints.fri.uni-lj.si/id/eprint/1652

Actions (login required)

View Item