CREATING AND PUBLISHING INTERACTIVE DASHBOARDS WITH EXCEL POWER PIVOT, POWER BI, AND SHAREPOINT ONLINE CAIR 2016 Annual Conference - Workshop Ken Nelson MD, MS Loma Linda University [email protected] This is a Workshop Our Task Today Import data to a data model in Excel • Create a dashboard in Excel Power Pivot • Export to SharePoint • Import a data model into Power BI • Create a dashboard in Power BI • Publish Power BI to a URL that anyone can view • Everything is Free Wouldn’t that be awesome? • Actually at this workshop the software is. • Really, everything you see being used here today (for an • educational institution) is FREE!!! Content for this Workshop Data files  Dataset Census.xlsx  Dataset Demographics.xlsx  Step by step guide – CAIR2016.pdf  http://cair2016.lluh.us Dashboards being built today are basic but provide the foundation for you to develop complex reports based on your data. Be Creative Sample - Program Review Dashboard Sample - Dashboards with Hyperlinked Tiles Sample - Financial Aid – Funds are Purpose Searchable