March 2022 - Purple Frog Systems

AutoML; How to use it and why
March 18^th, 2022 in Blog, Uncategorized
Introduction Some of you may have noticed that the Purple Frog team were at the largest community-led SQL Server and Microsoft Data Platform conference in Europe last week; SQL Bits. With all of us learning a lot, I thought I would share some of the knowledge I picked up in the Machine Learning space with you this week. I went to a session by Gavita Regunath of Advancing Analytics on the topic of AutoML, and why not just beginners in…
» Read more
Combining Queries from Multiple Sources in Power BI using Merge and Append
March 1^st, 2022 in Azure, Blog, Business Intelligence, Power BI, Power Query, SQL Server, Uncategorized
It is always good practice to do as much data preparation as close to the sources as you can before importing or connecting them to your Power BI reports, but what if there are circumstances where this isn’t possible? I had an issue recently where a third-party application had been updated and both the new and legacy versions were being used side-by-side. Logging data from both versions was being written to two separate Azure SQL databases.…
» Read more

Archive: March 2022