Power BI


Coolest New Power BI Features Revealed!

30

Aug 2018

Recently the Microsoft Business Applications Summit 2019 highlighted new Power BI features and these are the coolest features to note IMO: 1. New Power BI App Workspace Experience in Preview Power BI App Workspaces were introduced to enable collaboration amongst the data/business analysts within an organization. The new experience introduces numerous improvements to better enable a data-driven culture including: •   Managing access using security...

Read More...

Read More


Custom Visuals in Power BI

25

Oct 2017

Custom Visuals in Power BI

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

Read More...

Read More


Data Storytelling Gets Easier: Power BI Desktop Oct 2017

18

Oct 2017

Data Storytelling Gets Easier: Power BI Desktop Oct 2017

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

Read More...

Read More


Power BI: New Drillthrough and Insights Features from Sept 17

05

Sep 2017

Power BI: New Drillthrough and Insights Features from Sept 17

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

Read More...

Read More


DAX the Way – with Power BI

17

Jul 2017

DAX the Way – with Power BI

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

Read More...

Read More


How To Choose the Right Visualization

25

Jun 2017

How To Choose the Right Visualization

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! Creating a report that tells a story at a glance, however, is hard.  The ultimate test of a good report/dashboard is if someone without any prior knowledge can quickly understand it. Our audience should be able to see what the...

Read More...

Read More


Power BI vs Tableau

13

Jun 2017

Power BI vs Tableau

I am often asked, “Which tool is better: Power BI or Tableau?” Microsoft has done a great job with Power BI over the last two years. The features in Power BI have evolved so much that we’re now recommending it first to our clients. Microsoft identified the most important and useful features for a data visualization tool set and embedded them within Office 365. Power BI now...

Read More...

Read More


Using Dates in Power BI

24

Apr 2017

Using Dates in Power BI

Analyzing dates in Power BI is quick and easy. There are just a few things you need to know to format dates. When you drag a date field to an axis, it will automatically default to show year. However, you will have the option to drill down on your date field. In the top right of your visualization, you should see two down arrows. If...

Read More...

Read More


Build Power BI KPI Visualizations

24

Apr 2017

Build Power BI KPI Visualizations

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

Read More...

Read More


Resolve Power BI Column Discrepancy

03

Apr 2017

Resolve Power BI Column Discrepancy

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. What Column Discrepancy Means The message means that since the dataset was published, the actual data source (SQL Server, Redshift, Excel, etc.)...

Read More...

Read More