Lower your total cost of software: Alteryx and Procurement
Does this describe the software procurement process at your company? “Anyone can pretty much buy any low cost title at anytime” Maybe those purchases fly under your management radar because of the low purchase cost...which is fine, until you realize, after the...
read morePower BI DAX for CRM: Count only Opportunities with Conditionally Related Child records
I recently needed to solve this problem, and thought it was worth sharing as a Power BI DAX “go by” for others. The Situation The situation was creating Power BI dashboards for sales pipeline data coming from a CRM system. In this CRM data model, “Opportunities” have...
read moreLearn DAX for Power BI
5 Step Plan to Learn DAX for Power BI In my as-yet-incomplete journey to master the DAX language for solving problems in Power BI, I have come across a few resources that, when consumed in the right order and at the right time, provide a good guide for learning how to...
read moreAn Example of Dynamic Row Level Security in Power BI
If you’d like to download a copy of the PBIX file from what follows, I’d be happy to provide it to you. See instructions at the end of this post. Dynamic Row Level Security Implementing dynamic row level security (RLS) for each table in a Power BI data model based on...
read moreUsing Office 365 without Power BI? C’mon, man!
Power BI with Office 365 for Business If you aren’t using Power BI with your Office 365 business subscription, you are potentially missing out on great value for your organization, without needing to buy any additional software licenses. There is a free version of...
read moreAdvanced Customer Retention with Predictive Analytics
Tell me if you see your business in what follows: You sell some type of regularly consumed product or service. You have a lot of competition, your customers have a lot of choices who to buy from, and the switching costs for them are minimal. So you aren’t necessarily...
read more