Using Power BI for Managing Personal Fitness
In the summer of 2011, Matthew Roche joined the SQL Server team, moved his family across the country to Redmond. Over the next 15 months, inundated with the demands of a new role, move-related family stress, and an abundance of great food, Matthew managed to gain over 20 kilograms – and he realized that he needed to make a change. That change involved many healthy habits, but centered around weight training pushing his limits and abilities week after week. And of course, data and business intelligence were at the heart of how Matthew reversed his downward spiral and embarked on a fitness journey of epic proportions. In this session Matthew will present a custom solution for managing personal fitness data, implemented in Excel using Power Query, Power Pivot, and Power View. The session will focus on the real-world solution Matthew developed to measure and guide his fitness progress, including data sources, data modeling, and data visualization, and may or may not include shirtless progress photos. If you’re motivated by data, and want to see how you can reach your fitness goals while letting Excel do the heavy lifting, this is the session you’ve been waiting for.
Matthew Roche is a Senior Program Manager on the SQL Server product team, working on Enterprise Information Management (EIM) in SQL Server Integration Services (SSIS), Master Data Services (MDS) and Data Quality Services (DQS). Before joining Microsoft in 2008, Matthew was a business intelligence consultant and trainer and a Microsoft SQL Server MVP. In addition to implementing small- and large-scale BI solutions with SQL Server, Matthew has presented on SQL topics at major technical conferences, code camps, and user groups across the US and in Europe.