4 12, 2017

SQL Server 2016 Machine Learning Services: A Work Around for Single Value Outputs of the Raw data type in R

By | 2017-12-04T17:46:18+00:00 December 4th, 2017|Advanced Analytics, Data Science, SQL Server|0 Comments

SQL server 2016 (and 2017) enables SQL developers to write in database analytics in the form of stored procedures. The ideal flow of events is described in the below visual. Please note that the stored procedures in the visual insert results directly into the tables.   The key step that I would like to [...]

23 11, 2017

Mastering R: Deploy R Scripts Using Microsoft Machine Learning Server

By | 2017-11-27T19:37:13+00:00 November 23rd, 2017|Advanced Analytics, Artificial Intelligence, Data Science, R|0 Comments

https://www.youtube.com/watch?v=P-R1grd_X9o&t=107s Microsoft Machine Learning Server (formally Microsoft R Server) is an enterprise class server for hosting and managing R and Python workloads. In this demonstration we focus on R workloads. The server provides an execution engine for solutions built using Microsoft R for statistical analysis and machine learning scenarios. The final step of [...]

5 09, 2017

Using R Inside of Microsoft’s Power BI

By | 2017-09-05T13:42:14+00:00 September 5th, 2017|Advanced Analytics, Data Science, R, Reporting|0 Comments

Machine learning can enhance your reports so end users can gain deeper and more valuable insights from the data. While the value can be tremendous, implementing automated machine learning for reports can be challenging so many organizations choose to run scripts manually before importing the data into a reporting tool.  Power BI makes it easier [...]

16 08, 2017

Parallel Computing in R

By | 2017-08-16T14:51:12+00:00 August 16th, 2017|Advanced Analytics, Data Science, Microsoft R Server|0 Comments

Historically R has been a single threaded programming language, however, with Microsoft R many basic operations have been optimized to run in parallel for larger datasets. Additionally, Microsoft R enables developers to easily write parallel solutions using the RevoScaleR package. Please note that the code below is written and executed on my desktop, therefore, execution time [...]

25 07, 2017

Azure Storage R Package

By | 2017-07-25T09:13:34+00:00 July 25th, 2017|Advanced Analytics, Data Science, Microsoft R Server, R, SQL Server|0 Comments

A week ago, I came across a blog suggesting that R developers write their own personal R package to eliminate the need to copy and paste common functions into different scripts and workspaces. A personal R package would allow the developer to simply load the library and start developing using the functions they already use every [...]

15 05, 2017

Deploying Your First Web Service with Microsoft R Server

By | 2017-05-15T17:25:10+00:00 May 15th, 2017|Advanced Analytics, Data Science, Microsoft R Server|0 Comments

Incorporating advanced analytics in software allows developers to build intelligent applications tailored to the individual user. The easiest way to include machine learning in an application is by calling an API that returns a prediction. Using a standalone Microsoft R Server, organizations can write custom machine learning solutions that are hosted as web service APIs, [...]

3 05, 2017

Advanced Analytics with Microsoft R Server and SQL Server Machine Learning Services

By | 2017-05-03T08:45:27+00:00 May 3rd, 2017|Advanced Analytics, Data Science, Microsoft R Server, SQL Server|0 Comments

At Northwest Cadence, we believe that every organization should leverage machine learning in their software, reporting, and business workflows. We help companies learn about the various technologies available, and assist in implementing custom advanced analytics solutions. Incorporating predictive analytics within software or real-time dashboards can enable a company to revolutionize their business by providing a [...]

20 04, 2017

Machine Learning—too good to be true?

By | 2017-04-20T12:54:16+00:00 April 20th, 2017|Azure Machine Learning (AML)|0 Comments

A successful day at Olympia going over the wonders and practicality of machine learning! Developers create software to solve problems. Fixed problems can be solved with fixed solutions. But what happens when we run into dynamic problems? We need dynamic solutions! That’s where machine learning comes in. Machine learning is a method of data [...]

19 04, 2017

Soon I’m Going to be Out of a Job…

By | 2017-04-19T10:03:30+00:00 April 19th, 2017|Advanced Analytics|0 Comments

Advanced analytics is becoming easier and easier to implement in the cloud. Microsoft has made many of its machine learning models available to you through API calls. In fact, you can spin up a Microsoft Cognitive Services API from your Azure Portal in minutes. There is no overhead to manage or model to re-train, just [...]