by Matt Allington | Feb 28, 2019 | Excelerator BI
I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including: Extract the...
by Paul Hansen | Feb 27, 2019 | Power BI
A new whitepaper authored by Peter Myers presents a comprehensive body of knowledge covering all aspects of deploying, scaling, troubleshooting and managing a Power BI Premium deployment in an enterprise. The whitepaper provides both background information explaiing ...
by Melissa Coates | Feb 27, 2019 | SQL Chick
A couple of people have asked me recently about how to ‘bone up’ on the new data lake service in Azure. The way I see it, there are two aspects: A, the technology itself and B, data lake principles and architectural best practices. Below are some links to...
by Paul Hansen | Feb 27, 2019 | Power BI
To ensure employee productivity and satisfaction with Power BI, enterprise organizations develop comprehensive product training, bolster their help desks, and invest in helping their user communities with internal forums to share ideas and best practices. But it can...
by Justin Mannhardt | Feb 26, 2019 | PowerPivotPro
Business Problem: In a recent project with one of our clients, we were attempting to categorize website visit logs, based on the visitor’s landing page. The client had been maintaining a table of KeyPhrases that correspond with Categories. If the… This post first...