The Warehouse

BLOG & REsources

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

https://community.powerbi.com/t5/Data-Stories-Gallery/Retail-Analysis-Dynamic-Measure-amp-TopN-Selection/m...


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

Takeaways:


- Matt Ryan and Aaron Rodgers accuracy helps Yards/Dropback


- Ben Roethlisberger and Tom Brady have much better p...


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


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


Pandata GroupLessLess
Pandata GroupLess

Madison

Pandata Group, LLC

316 W. Washington Avenue

Suite 525

Madison, WI 53704

(877) 350-5192

Madison

Pandata Group, LLC

316 W. Washington Avenue

Suite 525

Madison, WI 53704

(877) 350-5192

Less

Pandata Group © 2020

Pandata Group © 2020

Less


Chicago

WeWork/ Fulton Market

220 N. Green Street

Second Floor

Chicago, IL 60607


Chicago

WeWork/ Fulton Market

220 N. Green Street

Second Floor

Chicago, IL 60607

Less

London, UK
Snap Analytics, LTD.
5th Floor
Trinity Quay, Avon Street Bristol, BS2 OPT

Less

London, UK
Snap Analytics, LTD.
5th Floor
Trinity Quay, Avon Street Bristol, BS2 OPT