Score More with Power Platform

Eric Frisk
Eric Frisk

Don’t tell my wife, but I found a way to combine football and work through this blog titled Score More with Power Platform. This blog is a place to talk about Fantasy Football and share Power BI capabilities.

Feel free to share what you have learned about Power BI and I will do the same.

I graduated from the University of Idaho with a BS in Accounting. I became a BI solution architect for industry side customers and joined sa.global as a Data Architect in 2016. I now manage the sa.global Data Strategy Group worldwide.

Image

Yes! You can talk about Data Strategy and Fantasy Football at the same time!

Fantasy Football is a fun way to learn concepts around Microsoft Power BI, says Eric Frisk as he talks about improving data strategies for businesses.

By Eric Frisk

Welcome to a unique data strategy blog with a Fantasy Football wrapper and the Microsoft Power Platform engine. If you are a Fantasy Football veteran and want to learn more about data strategy, or if you are a data strategy veteran and want to learn about Fantasy Football, you have found the right blog. Here we will post your teams using Microsoft Power BI. We will cover a broad mix of Microsoft Power Platform examples in role-based scenarios as well.

To get us started, I am Eric Frisk, Data Strategy Manager at sa.global, a Microsoft Dynamics 365 Gold Certified and Inner Circle Partner. I have often wanted to start a blog about my experiences and perspectives over 10 years as a data professional because well, teaching is fun and the more you know, the more we can do together.

At sa.global, I lead a team of data professionals focused on the Microsoft Power Platform as our core business solution set which includes our IP products and custom development. Through this blog, I will use Fantasy Football to illustrate Microsoft Power BI as a fun way to teach concepts. Typical Sundays during this time of the year, I am busy with Fantasy Football team management, cheering the Dallas Cowboys (stick with me), and traveling with my wife to live NFL games. But now that the Cowboys are a dumpster fire and Covid is keeping me from seeing live games, I have Sundays free to wrap data strategy concepts around Fantasy Football and my wife thinks I am working!

For many years, I have blended my passion for sports with my passion for data – I think those two concepts fit nicely together. Generally, this meant building out and consuming sports data to give myself a leg up in my fantasy sports leagues. I plan to incorporate Fantasy Football into posts as much as possible, because let’s face it, solely blogging about solving business problems and data strategy is boring.

While some posts will focus on generic data strategy, most of the content will revolve around leveraging Microsoft tools. We will discuss how to form and improve data strategies for businesses of all sizes using the Microsoft Power Platform (Power BI, PowerApps, Power Automate, and Power Virtual Agent) in addition to Dynamics. To get the ball rolling, I spent last Sunday building out a data model leveraging Power BI and football statistics sourced from the web. After a day of sourcing and modeling data, I was able to get valuable insights that I will be applying to upcoming Fantasy Football matches. As a basic example, using Power BI’s Decomposition Tree visual, I can make those tough ‘who should I start’ or ‘who should I keep’ decisions based on trending player and team statistics.

Microsoft Power Platform with Eric Frisk, Manager Data Strategy sa.global

For data professionals new to Fantasy Football concepts, what you see here is the total points of every player rolled up to the team level. Total points on far left breaks up by teams, weeks, and player. This way you monitor trends of how each team is doing week by week. For example, who was the best position for that week? For Fantasy Football veterans, you recognize the grid but what you will want to understand better is how the grid is built using Microsoft Power BI.

I plan to reference this model in many future posts and eventually publish it for all to use. Feel free to send feedback here or via Twitter (@ericrfrisk).

Related Stories

Leave a comment

You are commenting as guest.

Search