The Warehouse

BLOG & NOTES

Dec
28
FOUR ENGAGEMENT MODELS PANDATA GROUP OFFERS TO OUR CLIENTS

Pandata Group works with clients all over the Midwest who have begun the journey of being data-driven. These clients each have different needs, require different resources, and expect different levels of control and responsibility in their relationships with us.



To meet the requirements of each unique client, Pandata Group offers four distinct engagement models, which are frameworks that define collaboration between us and our clients for projects such as data mart implementation or BI application development. We call these engagement models Extended Team, Specialized Team, Managed Product and Managed Services. All four models ensure the right mix of expertise and transparency during the dev...


Jun
22
YOUR GUIDE TO POWER BI PREMIUM

Who is Power BI premium meant for, does your organization need Power BI premium, and what are the benefits of Power BI premium compared to Power BI Pro?


First, let's cover what doesn't change with Power BI Premium, and the existing options for Power BI users. Power BI Pro Licenses are still $10 a month, and will meet the needs of about 99% of all organizations. Power BI Pro Licenses are necessary for users to share a dashboard and reports. So, if you have 5 business analysts creating Power BI reports and dashboards, and 5 C-level executives and managers who will also be consuming it, you'll need 10 Power BI Pro Licenses.


There are two different User Tiers:


temp-post-image


Now, a quick reference guide to the r...


Apr
25
PANDATA GROUP EXPANDS WITH CHICAGO OFFICE

temp-post-image

Pandata Group is proud to announce the opening of its new office in Chicago’s West Loop, one of the fastest growing neighborhoods in the city.


The new space is located at 220 N. Green Street, and will be home to Pandata Group team members who support clients across the Chicago market. Shay Rao, Managing Consultant, is a Chicago-native who will lead the growth and operation of the office.


Rao says “It’s a very exciting time for Pandata Group. This office allows us to expand our services into the Chicago market as well as grow our team, and the new location will facilitate collaboration with some of the hottest tech players in the Chicago market. I’m looking forward to a ...


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


Jul
12
MEET JOSH ERHARDT, SR. CONSULTANT - INFORMATION ARCHITECTURE

Pandata Group is happy to announce that Josh Erhardt has joined the company as a Senior Consultant. His expertise is in Information Architecture and he is influential in guiding our clients to adopt a successful foundation for data integration and data warehousing.





Josh will be leading Pandata Group’s practice in Enterprise Information Architecture. Our audience is hit with waves of market analysts’ perspectives and technology vendors’ promises. The Enterprise Information Architecture practice helps cut through the noise to design successful platform for your business that is based on best practice and, most important, experience.


We think you should get to know Josh and hi...


Jul
11
MEET SHAY RAO, MANAGING CONSULTANT

Pandata Group is happy to announce that Shay Rao has joined the company as a Managing Consultant. With his history as a contributor to and point person on many SAP data and analytics projects across a wide variety of industries, he is a natural choice to head Pandata Group’s SAP practice and keep us at the forefront of thought leadership in the space.





Shay is a rare leader who is also tasked with growing our footprint in Chicago. He will guide market development and account management for local clients, and will be responsible for the growth and direction of Pandata Group’s Chicago office.


We think you should get to know Shay and his role at Pandata Group. We’ve included a ...


Jul
10
WHAT'S IN A NAME?

The first half of 2016 has quickly passed us and we’re heading into the final half of the year at a staggering pace! We’ve enjoyed much success in the first part of 2016 with the addition of new clients, new team members, and even our first office in Madison, WI. It’s no small feat, and we thank all those who trust us to help in their data and analytics initiatives.


I joined the company in January of this year to help with crafting our business strategy and also executing our market development. Our initial existence centered on our expertise with SAP EIM and SAP BusinessObjects software. Since the two founders of the company each possess nearly 20 years of experience with S...


Pandata GroupLessLess
Pandata GroupLess

Madison

Pandata Group, LLC

316 W. Washington Avenue

Suite 525

Madison, WI 53704

Madison

Pandata Group, LLC

316 W. Washington Avenue

Suite 525

Madison, WI 53704

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