The NFL season may have come to end, but analytics for associations is like a year-round sport! All industries are recognizing the value analytics in optimal decision-making, and professional sports is no different.
Out of the box, Power BI gives you access to many common data visualizations. Sometimes the basic charts don’t get you to where you need to go. Luckily, Microsoft and the Power BI community created custom visualizations that will be available to you. I am going to give you a quick primer on how to access those and then let you know what my favorite visualizations are.
The October 2017 release of PBI Desktop includes a much-anticipated feature that makes data storytelling easier: Bookmarking. Bookmarking in combination with the spotlight, drillthrough and what-if features allows you to create very compelling stories about your data. It's currently in "preview" mode, so you have to turn it on by going to the options page. After a restart of PBI, there will be a new Bookmarks Pane available via the View tab.
Power BI was launched almost 3 years ago. It includes a free desktop application for authoring reports and a cloud service for publishing and sharing reports. Since day one Microsoft promised to deliver an updated version of the PBI Desktop application each month - and they have honored this commitment, which is rare in the space. Each release includes exciting new features that have been voted on by the PBI community. Last week the Sept version (26th release!) arrived with a number of key improvements which helps associations understand and access data quickly. Click here to view the Sept feature summary.
DAX stands for Data Analysis eXpressions and it is the formula language used in Power BI. It's similar to Excel formulas and it's an extremely powerful language for creating measures and calculated fields within your Power BI data model. The downside is that it requires a bit of a learning curve to get up to speed. There are a lot of great resources out there for learning DAX and to help us along the April release of Power BI Desktop included a preview feature called Quick measures.
Creating a report or dashboard in Power BI is quite easy. A few mouse gestures and a couple of clicks and voila, we have a report!
I am often asked, “Which tool is better: Power BI or Tableau?”
Analyzing dates in Power BI is quick and easy. There are just a few things you need to know to format dates.
Building Key Performance Indicator (KPI) visualizations in Power BI is a breeze. KPI visualizations allow you to view a specific measure against a target. The target might be last year’s totals or it could be your goal for this year. The easiest way to accomplish these in Tableau is using a bullet cart which is a very effective way of looking at the data but falls short when your audience just wants to see the numbers big and clear. Let’s look at some out of the box visualization types in Power BI.
During development or enhancements to a Power BI solution, you may encounter this message: "An error occurred while processing the data in the dataset. The 'handouts_path' column does not exist in the rowset." You probably received this message via email if you published the dataset.