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 ...


Sep
29
PANDATA GROUP AND MICROSOFT PARTNER FOR DATA ANALYTICS

Pandata Group’s partners help us empower our clients and deliver value from data and analytics using the best technology for their particular business needs, which is why we’re excited to announce we’ve added Microsoft to that list. Microsoft’s Power BI and SQL Server 2016 platform represent a strong approach to both the data platform and self-service analytics, and being a Microsoft partner will let us bring our clients actionable from diverse data sources across on premise systems and cloud-based applications.

Why Microsoft?

  • Use a comprehensive BI platform that works with the data, systems, and tools you already have

  • Extend your existing BI and reporting investments to the cloud

  • Provide faster insights on your data while maintaining data governance and security

  • Share insights and reports across all major mobile platforms so your business users can make decisions when and where they need it

  • Transform your data into intelligent action with built-in data modeling and advanced analytics

  • Write once, deploy anywhere—write advanced analytics models and deploy them in an on-premises database, in the cloud, or even to Linux, Hadoop, and Teradata systems

  • Access to thousands of R scripts and models in CRAN (comprehensive R archival network)

Next Steps: Pandata Group as your Microsoft partner

Put plainly, Pandata Group helps you make Power BI’s fast time to value even faster. Our levels of expertise let us support your...