• Home
  • Services
  • Samples
  • About
  • Blogs
  • Contact
Select Page

Power BI Tips: Filter ALL, Filter VALUES and KEEPFILTERS

by gene connolly | Nov 26, 2018

Mastering filter arguments with CALCULATE is critical to having success building measures with DAX in Power BI. In the most fundamental case, you need to know the difference between how FILTER(ALL()) and FILTER(VALUES()) on a single column produce...

read more

Tool Agnostic Analytics: Effective Dashboards and the Last Mile

by gene connolly | Nov 26, 2018

You are going to build a dashboard. You’ve got the question you need to answer...check! And you have the data to build the required calculations...check check! But if you don’t walk that last mile with your target end users about *how* they want to see and...

read more

Tool Agnostic Analytics: Building Effective Dashboards

by gene connolly | Oct 26, 2018

I recently came across a good Tableau white paper entitled “10 Best Practices for Building Effective Dashboards” by Ellen Nadelhoffer, Senior Technical Writer at Tableau. (You can find it here...

read more

Tool Agnostic Analytics: Yield, Speed and Outliers

by gene connolly | Sep 19, 2018

What goes into a business process? What comes out? What doesn’t? And why? How fast does your process move inputs to outputs with desired outcomes? With undesired outcomes? What speeds it up or slows it down? Are there outliers or one-time events that skew...

read more

Power BI Tips: Calculate 102 – Filter ALL or Filter VALUES?

by gene connolly | Aug 20, 2018

If you are in Marketing and trying to understand the productivity of various sources of Leads that do or do not convert to Opportunities for Sales, using a tool like Power BI for that analysis can be a great choice. But knowing how to use filter arguments in a...

read more

Power BI Tips: Pivot Table from Name/Value Pairs with “M”

by gene connolly | Dec 8, 2017

When the data you “Get” in Power BI doesn’t come in nicely organized rows and columns, sometimes you need to do more with “Edit Queries” than just using the functions available on the ribbon. And that’s when you need bust out some “M” code to get the job done. In what...

read more
« Older Entries

Got Questions? Let’s Talk

info@connollyconsultants.com

Designed by Elegant Themes | Powered by WordPress