Power BI: How to Save Memory for Better Performance
Apr 24,
2019
The tabular mode data storage used by Power BI, Power Pivot, and the SQL Server Analysis Services thrives on sufficient memory. Take away memory and performance plummets. You may be wasting memory and thus performance if you do not take advantage of opportunities to trim excess fat when you are first importing your data. And, […]
Turning Your AzureML Experiment into a Web Service
Apr 16,
2019
Great! You’ve created a promising machine learning model using AzureML Studio. How do you make it available to colleagues for practical use? In Microsoft-speak, how do you “operationalize” it? The AzureML Studio makes it very easy to convert an existing experiment into an Azure web service that can be accessed from any application that supports […]
Your Linear Regression Need Not Be Linear
Jan 31,
2019
Anyone who has ever done a linear regression in R has seen an R formula. R formulae are examples of the Wilkinson notation, sometimes called the Wilkinson-Rogers notation. This same notation is used by other applications including Matlab and Octave to indicate relationships between variables. In most cases, R users have seen the Wilkinson notation […]
Using .RProfile to Customize your R Environment
Jan 22,
2019
When R starts up, it looks for several files to initialize its configuration. R has its own configuration file called Rprofile.site located in the /etc folder. It is probably wise not to mess with this file unless you are very confident in your understanding. Most R users are aware that during startup, R reads an […]
Preparing SQL Data for R Visualizations Using Power Query Pivot
Jan 11,
2019
The Data Frame The fundamental data structure used by the majority of R functions and packages is the data frame. In a data frame, sets of related values constitute rows, while an individual column vector in a data frame contains comparable measures that can be summed, averaged, or subjected to any number of numerical manipulations. […]
