SQL Server Machine Learning Services – Part 1: Python Basics

Image result for microsoft machine learning services images

With the release of SQL Server 2017, Microsoft changed the name of R Services to Machine Learning Services (MLS) and added support for Python, a widely implemented programming language known for its straightforward syntax and code readability. As with the R language, you can use Python to transform and analyze data within the context of a SQL Server database and then return the modified data to a calling application.

Here it is again “Python” being used for the programming language of data.  This series will introduce you to the renamed “R” now called “Machine Learning Services”.  MLS is a simple recipe, take the “R” stats engine, add a pinch of Python, add a cup of training.  This might be an interesting concept.  Guess I need to break out the Python in 30 Days book again.

 

Top 9 JavaScript Charting Libraries — DZone Web Dev Zone

Since you’re reading this, it surely would be no news to you that data visualization has become a very critical part of the IT world today. The huge amount of data being generated by different web technologies needs to be properly refined and visualized for the world to use and gain insights from it. The…

The question here is now how hard is it to do data visualization using JavaScript.  The real question is which of the many options is the one to use.  I use a combination of D3 and C3 (One of the libraries in this article.) with some amount of success.  Not everything is free but for good information in a visual format, a few bucks is a good investment.

The nice thing about this article is it has code examples for each of the libraries to give you an idea of how they function.

via Top 9 JavaScript Charting Libraries — DZone Web Dev Zone

Data Visualization Basics for Data Scientists

“A picture is worth a thousand words”, the old saying goes, and in some cases, a picture is worth even more than that. The human eye is composed of some 30 or more discrete components, and along with the optical nerves and the brain functions that process sight, can take in a contrast ratio of around 100,000:1 (over time) and can distinguish about 10 million colors. That sight-brain-pathway is a pattern-matching wonder and has “regions of interest” that the eye/brain connection focuses on (http://www.cambridgeincolour.com/tutorials/cameras-vs-human-eye.htm).

Making up one of our primary senses, sight is immeasurably important to conveying information, and it’s vital to the Data Scientist to understand how to best use various visualizations to display and discuss data.

There is a book reference in this article from 2013 that still is a must-read for anyone attempting data visualization at any level.  The best lesson is to look through other people eyes to appreciate how the information must “Look”.  I go by a simple rule, “If my wife, who is not technical or a data scientist, can’t understand the visual it probably needs more work”

Via: Microsoft Developer, Buck Woody

Data Driven Documents (D3), API Server (Cdata) Generate REST Server 80+ Data Sources.

2017-08-22_8-45-24

2017-08-22_8-45-52

D3.js is a JavaScript library for producing dynamic, interactive data visualizations in Web browsers, using the widely implemented SVG, HTML5, and CSS standards. The CData API Server enables you to generate REST APIs for 80+ data sources, including both on-premises and cloud-based databases. This article walks through setting up the CData API Server to create a REST…

I have used D3 in concert with C3 to create a data visualization front end to a data warehouse.  D3 has a ton of features but is difficult to use out of the box for the novice user.  The C3 library puts a layer of smarts on top of D3 making it much easier to get started in graphic visualizations.  I’ve also used CData product to get an ODBC connection to Google sheets in order to analyze and transfer results from a Google form survey to a data warehouse.  CData products are very good just be willing to pay for that excellence.

This article is a good read because it combines the two to assemble a REST service and use it to provide the data feed to D3.

via Building Dynamic D3.js Web Apps With Database Data — DZone Web Dev Zone

Business Intelligence comparisons done dirt cheap

The proliferation of business intelligence platforms, tools, and software stacks is dizzying. It seems that not a week goes by in which a new product isn’t introduced to the market, which grows ever more fragmented and confusing. Specialized business intelligence tools for cloud-based data visualization, Hadoop, text analytics, and other specific solutions for certain analyses…

It’s official I’m doing any more BI comparison posts.  I just can’t keep up.  I swear there is either new BI tool every week or a “New Features” post on an existing one.  Recently I did a comparison of a specific set of BI Tools requested by a State Agency.  The problem was the selected set of tools to review didn’t provide the best solution.  Now there are 19 websites with comparisons out the Yazoo and you don’t have to pay a consultant, or do you?   This week I have 2 favorites Tableau and Microsofts Power-BI.  I’m fickle so next week it may be something different.

via 19 Websites for Business Intelligence Tools Comparison — DZone Big Data Zone

Is it modern art or is it data?

2017-08-14_12-50-11

Data visualizations on acid.  A researcher with R programming language and mortgage rates for the last 30 days took data and turned it into some form of modern art.  The whole package is available on GitHub.

Via: Database Weekly

 

 

Dashboards on the cheap, DIY with Gridster

Recently, I published an article on various JavaScript libraries for Dashboards. In this article, I am going to demonstrate how we can create a dashboard with drag-and-drop visuals and export it using JavaScript. I am going to use the Gridster library to create the dashboard. I have used this library in my projects and found it…

It takes a few libraries to create dashboards that look like

screen-shot-2017-04-02-at-20-21-09.png

Gridster.JS is a jQuery plugin that when combined with Chart.JS to create the charts and jsPDF to snapshot the page into a PDF file you can build a custom dashboard quickly.  If you have used Tableau or Microsofts Power BI and wondered, “Could I write something like this in code for a specific solution”, me thinks the answer is “Yes”.

via Dashboard: Drag and Drop Visuals and Export Using JavaScript Libraries — DZone Web Dev Zone

4 Useful JavaScript Libraries for Data Analysis and Visualization

2017-02-21_13-10-03Businesses from all around the globe, irrespective of the industry vertical, have realized the importance of data-driven decision making. Data Analytics is currently one of the most trendy topics in the world and businesses across different verticals are increasingly focusing on deriving meaningful insights from data in order to understand both past and future trends. There…

I have used the first of these libraries D3 along with C3.  I think the others are worth a little research time.

  • Data-Driven-Documents (D3.js)
  • Aperture JS
  • InfoVis
  • Cytoscape.js

via 4 Useful JavaScript Libraries for Data Analysis and Visualization — DZone Web Dev Zone