Skip to main content

DAT213 - Analyzing Big Data with Microsoft R Server

This course teaches exploratory data analysis skills using the Microsoft R Server implementation known as RevoScaleR. This product is in most ways functionally equivalent to the open source CRAN-R. RevoScaleR offers three significant benefits over its open source brother: the ability to run analyses in parallel across different servers, the ability to "chunk" data for evaluation and bypass the in-memory limitation of R, and the ability to read more natively from data sources like SQL Server, Hadoop, and Spark.

DAT209 - Programming with R for Data Science

Programming R for Data Science is taught by Anders Stockmarr (on the faculty of Technical University of Denmark.) For US audiences, his accent requires some getting used to. He places emphasis on unexpected syllables and has a unique way of pronouncing many things. I found it helpful to use headphones and to adjust the playback speed of the recordings. It is worth making the effort to understand Dr.

DAT203 - Data Science Essentials

Data Science Essentials (DAT203) marks the point where we have enough foundation that we can start forming a bigger picture of data science. To that goal, the course provides this definition:

Data Science is the exploration and quantitative analysis of all available structured and unstructured data to develop understanding, extract knowledge, and formulate actionable results.

DAT204 - Intro to R for Data Science

SQL developer notes about the Intro to R for Data Science within the Microsoft Professional Program in Data Science. Great language, great course...

DAT222x - Essential Statistics for Data Analysis using Excel

Call me a nerd, but statistics are fascinating and useful. I'd had quite a bit of course-work years ago in school, and was looking forward to "Essential Statistics for Data Analysis using Excel" as a refresher course. Unfortunately, the experience of this edX course might be tag-lined "Sadistics." Completing this was a painful experience.

DAT207x - Analyzing and Visualizing Data with PowerBI

The course "Analyzing and Visualizing Data with PowerBI" is devoted to showing the capabilities of this Microsoft tool. For those who have worked previously with Excel, Microsoft Access or SQL Server Reporting Services -- the video demonstration of PowerBI capabilities will cause you to repeatedly think "wow -- that is slick." As an example, pictured below is one of the dashboards created as part of the course.

 

DAT201x - Querying with Transact-SQL

A database analyst's experience taking the "Querying with Transact-SQL" online class that is part of the Microsoft Professional Program in Data Science. This is the 2nd class in the series and participants should consider auditing it initially unless they've used T-SQL in the past. This is an altogether excellent course.