Category: Business Intelligence

For me, one of the most valuable features of Power BI is the ease with which I can mashup data from a variety of different data sources. This, of course, requires importing data into Power BI’s internal xVelocity engine. For many others, however, it is critical to create Power BI reports and dashboards that reflect […]

R Server is dead! Long live Machine Learning Server! The introduction of Microsoft R Server with SQL Server 2016 was tremendously exciting for data scientists and analysts working with “Big Data”. When SQL Server 2017 was released, many were shocked to see that R Server was gone. They were, however, relieved to discover that R […]

Its name is Power Query Formula Language. But if you call it that, no one will know what you are talking about. The original informal language name M seems to have stuck, and even the Microsoft documentation refers to M. Every time you create a query in Power Query, whether in Excel or Power BI, […]

Logistic regression is one of the most important techniques in the toolbox of the statistician and the data miner. In contrast with multiple linear regression, however, the mathematics is a bit more complicated to grasp the first time one encounters it. We’re going to gain some insight into how logistic regression works by building a […]

Several authors have described how to use the M function Diagnostics.Trace to monitor the performance of queries built with Power Query. In this installment, we will look at how to use the same function to record row-level error information in the trace log. Regardless of how we intend to use Diagnostics.Trace, nothing at all can […]