ePrints.FRI - University of Ljubljana, Faculty of Computer and Information Science

EMG data warehouse with excel-based visual analytics

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

Download (2668Kb)


    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: 41
    Language of Content: Slovenian
    Mentor / Comentors:
    Name and SurnameIDFunction
    prof. dr. Blaž Zupan106Mentor
    doc. dr. Gaj VidmarComentor
    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