Skip to main content

Improving Data Quality

Our customer address information is inaccurate and it contributes to delayed deliveries and frustrated customers. What general resources are available to improve the quality of our data?

Backup Horror Story

A business associate just spent two weeks in turmoil trying to recover data that was permanently lost. Their backup process was flawed. I've got a gnawing sense that this could happen to us too? What can I do to ensure my backups are occurring when they should and that they will be usable if I actually need them?

Using R to Evaluate College Scorecard

Our company acquired a data file containing over 15,000 rows and 300 columns. We are trying to identify patterns in the data. Where do we begin evaluating such a large dataset? Would Using R be helpful?

Microsoft Access Member Directory

Our organization produces member directories every year. They are tedious to create and prone to typos / inaccuracies. How can I use a database to create a member directory or product catalog?

Microsoft Professional Program in Data Science

A database analysts experience with the Microsoft Professional Program in Data Science. This page is an index of 10 blog entries describing coursework included in this new curriculum aligned with Microsoft data science tools. This entry concerns the overview course.

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.