{"id":29972,"date":"2026-03-30T09:00:00","date_gmt":"2026-03-30T13:00:00","guid":{"rendered":"https:\/\/michigan.it.umich.edu\/news\/?p=29972"},"modified":"2026-04-02T15:42:34","modified_gmt":"2026-04-02T19:42:34","slug":"michigan-medicine-cop-develops-free-dashboard-tool-that-challenges-expensive-bi-platforms","status":"publish","type":"post","link":"https:\/\/michigan.it.umich.edu\/news\/2026\/03\/30\/michigan-medicine-cop-develops-free-dashboard-tool-that-challenges-expensive-bi-platforms\/","title":{"rendered":"Michigan Medicine CoP Develops Free Dashboard Tool That Challenges Expensive BI Platforms"},"content":{"rendered":"
\n
\"Home
DataLaVistaTM<\/sup>: AI-assisted open source solution born from real medical campus infrastructure constraints.<\/figcaption><\/figure>\n<\/div>\n\n\n

Researchers and staff across campus face a common frustration: valuable data sits locked in SharePoint lists, Excel files, and CSV exports, inaccessible to the people who need it most. Traditional business intelligence tools require expensive licenses, dedicated IT staff, and months of deployment cycles. A new open source tool developed at Michigan Medicine aims to eliminate those barriers entirely.<\/p>\n\n\n\n

DataLaVistaTM<\/sup>, created by members of the \u201cAutomators Anonymous\u201d Community of Practice (CoP) from the Eisenberg Family Depression Center (EFDC), Patient Safety, and Internal Medicine\/Pulmonary, runs entirely in your browser with no servers, databases, or IT support required. The single-file dashboard designer transforms data into interactive visualizations instantly.<\/p>\n\n\n\n

“We built DataLaVistaTM<\/sup> out of necessity,” said Gabriel Mongefranco, mobile data architect at the Depression Center. “Colleagues in Patient Safety and Pulmonary needed critical dashboards for SharePoint list data \u2014 everything from EFDC’s CRM to pulmonary nursing schedules to quality and safety outcomes \u2014 but dashboard licenses were unavailable. We explored how far we could push AI technology to rapidly build fully-functional prototypes, iterating across Claude, Gemini, and ChatGPT over two weeks. Fine-tuning still required extensive manual coding, but we chose to release it as open source because it solves very common problems: fast dashboard creation without expensive infrastructure, and easier access to SharePoint data.”<\/p>\n\n\n\n

DataLaVistaTM<\/sup> connects to SharePoint lists, Excel files, CSV data, and REST APIs. Users can build queries visually with a point-and-click interface, or write SQL directly in an advanced editor with autocomplete and validation. The tool generates essential visualizations including KPIs, tables, charts, pivot grids, and custom widgets.
Because DataLaVistaTM<\/sup> runs purely client-side JavaScript, it requires zero infrastructure investment. Drop the single HTML file into SharePoint, a shared drive, or any website, and start building dashboards immediately.<\/p>\n\n\n\n

The tool is currently in beta testing across Patient Safety, the Depression Center, Pulmonology, Neurology Sleep Clinic, and diabetes-related research projects at the Medical School.<\/p>\n\n\n\n

DataLaVistaTM<\/sup> is available now under the GNU GPL v3 license. Try the live demo<\/a> or explore the GitHub repository<\/a>.<\/p>\n\n\n\n

For more information, contact the Eisenberg Family Depression Center Mobile Technologies Core at: efdc-mobiletech@umich.edu<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Researchers and staff across campus face a common frustration: valuable data sits locked in SharePoint lists, Excel files, and CSV exports, inaccessible to the people who need it most. Traditional business intelligence tools require expensive licenses, dedicated IT staff, and months of deployment cycles. A new open source tool developed at Michigan Medicine aims to eliminate those barriers entirely.<\/p>\n","protected":false},"author":227,"featured_media":29974,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_umich_oidc_access":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_ef_editorial_meta_date_first-draft-date":"","_ef_editorial_meta_paragraph_assignment":"","_ef_editorial_meta_checkbox_needs-photo":"","_ef_editorial_meta_number_word-count":"","footnotes":""},"categories":[4],"tags":[942,1209,402],"class_list":["post-29972","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-features","tag-artificial-intelligence","tag-data-visualization","tag-michigan-medicine"],"uagb_featured_image_src":{"full":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco.png",1243,856,false],"thumbnail":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco-400x266.png",400,266,true],"medium":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco-300x207.png",300,207,true],"medium_large":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco-768x529.png",665,458,true],"large":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco-600x413.png",600,413,true],"1536x1536":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco.png",1243,856,false],"2048x2048":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco.png",1243,856,false],"excerpt-thumbnail":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco-200x140.png",200,140,true],"themonic-thumbnail":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco-60x42.png",60,42,true],"ioslider-thumbnail":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco-658x300.png",658,300,true],"post-thumbnail":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco-665x458.png",665,458,true],"400x250-crop":["https:\/\/michigan.it.umich.edu\/news\/wp-content\/uploads\/2026\/03\/datalavista-screenshot-2-Gabriel-Mongefranco-400x250.png",400,250,true]},"uagb_author_info":{"display_name":"Gabriel Mongefranco, Mobile Data Architect, Eisenberg Family Depression Center","author_link":"https:\/\/michigan.it.umich.edu\/news\/author\/mongefrg\/"},"uagb_comment_info":0,"uagb_excerpt":"Researchers and staff across campus face a common frustration: valuable data sits locked in SharePoint lists, Excel files, and CSV exports, inaccessible to the people who need it most. Traditional business intelligence tools require expensive licenses, dedicated IT staff, and months of deployment cycles. A new open source tool developed at Michigan Medicine aims to…","_links":{"self":[{"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/posts\/29972","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/users\/227"}],"replies":[{"embeddable":true,"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/comments?post=29972"}],"version-history":[{"count":8,"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/posts\/29972\/revisions"}],"predecessor-version":[{"id":30002,"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/posts\/29972\/revisions\/30002"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/media\/29974"}],"wp:attachment":[{"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/media?parent=29972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/categories?post=29972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michigan.it.umich.edu\/news\/wp-json\/wp\/v2\/tags?post=29972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}