Sentiment Analysis & Key Phrase Detection w/ Power Query & Power BI

Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to perform sentiment analysis and key phrase extraction on surveys completed by students regarding classes and instructors, which brings me to this blog post. Using Azure ML and a free subscription to the Text Analytics API, I’m going … Continue reading Sentiment Analysis & Key Phrase Detection w/ Power Query & Power BI

Refreshing Excel Power Query & Pivot Tables with SSIS and Task Factory

With SSIS 2014 and earlier there is currently not native way to refresh an Excel workbook which include Power Query queries. Now that functionality is rumored to be included with SQL Server 2016 but if you’re currently running SQL Server 2014 or 2012 you are out of luck. But that’s why Pragmatic Works put together … Continue reading Refreshing Excel Power Query & Pivot Tables with SSIS and Task Factory

Cleaning Your #PowerBI Power Query Code

Over the weekend I found this nifty tool called Power Query Management Studio. Someone shared it on Twitter and you’ve probably seen the link to download the tool on technet. Basically this tool is a fancy Excel workbook that allows you to easily clean up your Power Query code and insert it back into your … Continue reading Cleaning Your #PowerBI Power Query Code

Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

Late last month Microsoft released the certification exam for Power BI, 70-778: Analyzing and Visualizing Data with Microsoft Power BI. The exam is currently in beta and will likely remain that way for the next eight to twelve weeks. If you were lucky enough to snag one of the 300 uses of the voucher code, … Continue reading Preparing for Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI

Setting up the Power BI Report Server Preview

Last week on May 17th the Power BI team announced the release of the Power BI Report Server preview. Power BI Report Server includes the ability to host Power BI reports, along with traditional SQL Server Reporting Services content, within the boundaries of your organization’s firewall. I put together the following video that

Another 5 Power BI Tips

If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about Power BI. Part of the reason I blog so often about Power BI is because that’s the topic of a whole bunch of conversations I’m having with my customers. The other reason is that the … Continue reading Another 5 Power BI Tips

Introduction to Power BI Desktop – Recording Now Available

Thank you to everyone that attended this past Tuesday’s webinar hosted by Pragmatic Works called Introduction to Power BI Desktop. We had a great turn out! If you missed the webinar, you can view the recording here. Check out these five Power BI tips! There were lots of great questions and far too many to … Continue reading Introduction to Power BI Desktop – Recording Now Available