PERSPECTIVES

BLOGS & NOTES

Feb
06
POWER BI TIP: DYNAMIC TOPN REPORTS IN POWER BI

There’s no doubt that PowerBI is a powerful reporting tool. The method below outlines a pattern that can be used to meet the needs of several end users. In order to create stunning Power BI reports that can allow a user to really dive into the data, you need to know DAX (Data Analysis Expressions.) The trick I’ll outline below is how to create a Dynamic TopN report using DAX, which will take your Power BI reports to the next level. It’s one thing to look at a KPI such as Sales company wide, but what if you want to identify the stores or items that are driving that KPI?

temp-post-image

Jan
19
THE NFC CHAMPIONSHIP GAME SHOOTOUT VIZ

Last week I compared Aaron Rodger’s 2016 season to Super Bowl winning 2010 season. In both, there was a drastic improvement seen in the second half of the season. With the Packers beating the Cowboys last week, they move forward to the Conference Championship weekend to face the Atlanta Falcons. Steelers and Patriots face off in the AFC, which means there are four powerhouse quarterbacks all looking to take their team to the Super Bowl this year: Matt Ryan, Aaron Rodgers, Ben Roethlisberger, and Tom Brady.

Here’s a breakdown of their performances since week 11:

temp-post-image

Jan
13
IS AARON RODGERS PLAYING AT A 2010 LEVEL?

As a company anchored in Madison, we love most things Wisconsin. Beer, cheese, brats, Badgers, and of course our beloved Green Bay Packers. Internally, one of our Pandas, James Fassbender, is probably the biggest fan of the Green & Gold and he couldn't stop seeing the pattern of play and victory of the 2010 season. That was the year the Packers defeated the Pittsburgh Steelers to win the Super Bowl behind MVP Aaron Rodgers.

If you've been following the Packers you might recall we had a little scare mid-way through the season and questioned the play and coaching of the team (shame on us). But for James he followed the manta to R-E-L-A-X and saw something different. Included in this post is a link to the dashboard he developed in Power BI ...