Dan Hartshorn


Dan Hartshorn is Principal Consultant at Hartshorn Associates. He is a leading BI, Data and SharePoint Enterprise Architect. Passionate advocate in using enterprise data as an asset to drive business results.

By training Dan is actually statistician and is a real numbers and data geek.

He is experienced in Azure, SQL Server, .Net, Web Development, Power BI, SharePoint, Office 365, Big Data, and major BI tools. A recognized expert in SharePoint, SQL Server and Business Information design, development, deployment and governance. Specialties include Managing data as a corporate asset, SharePoint, development, Database Development, Data Warehousing, Business Information and Reporting, Big Data, Cloud Applications, Collaboration, Project and Program Management, Business Development, Corporate Performance Management, Organization Planning.

Data Visualization and Reporting in R

Saturday, February 25th, 2017 at 1:30 pm

R is growing to be the standard for advanced data analytics. It provides great flexibility for analytic visualizations and reporting. This session will demonstrate how to get started with data visualization in R and some of the approaches and packages to use. (Included will be how to use R with Power BI.) We will also give a quick guide on which visualizations to use and when.

This session will be heavy on demonstrations.

Rev up in R – A One Day Introduction to R

Friday, February 24th, 2017 at 8:30 am

R is growing to be the standard tool for Data Analytics. Microsoft has deeply embraced R and has included it as a component in SQL Server, Azure and Cortana. R is the standard language for Data Science. This session will provide an overview of R, its uses and how you can continue your learning. Bring your laptop and we will set up R with you.

Key Topics include:

Implementation – How is it implemented and what is required for its use. This includes a basic set up and larger scenarios.

Data Wrangling – How do you get at data and structure it for your use.

Statistical Analysis and Packages – How can you use the analytic features that are important to you. (We will also do a brief refresher on what statistics are and why they are important.)

Introduction to Machine Learning – Machine Learning is currently a hot button topic. You will see some use cases and how R fits into them.

Visualization and Reporting in R – One of the key features is the robust levels of visualizations included and how they can be customized for your use.

Resources – Where to find additional info on R to continue your journey

Introduction to R

Saturday, October 22nd, 2016 at 8:30 am

R is the key language for Data and Statistical Analysis. It has been around for some time but is now going to be included in SQL Server 2016. This is a big deal as it provides an integrated set of analytical and data manipulation tools into the SQL environment and simplifies programming over what is available in TSQL and .NET extensions. (Updated for the release of SQL Server 2016).

This session will provide some use cases and an overview of R, the development process and how to get about learning the tools. This session will be heavy on examples.

What is the Deal about R?

Wednesday, July 20th, 2016 at 6:00 pm

R is one of the hottest languages around. It has gained greater currency with its inclusion in SQL Server. If you wondered what it is, what is used for and how to get started we will cover the highlights and do a real quick demo.

Introduction to R

Saturday, April 9th, 2016 at 8:30 am

R is the key language for Data and Statistical Analysis. It has been around for some time but is now going to be included in SQL Server 2016. This is a big deal as it provides an integrated set of analytical and data manipulation tools into the SQL environment and simplifies programming over what is available in TSQL and .NET extensions.

This session will provide some use cases and an overview of R, the development process and how to get about learning the tools. This session will be heavy on examples.

Building BI in SharePoint

Saturday, October 10th, 2015 at 1:30 pm

Microsoft’s investment in BI has been huge.  There have been tons of new options added to the toolbox.  This session will review the options available and describe the options for developers to integrate BI into their applications and their organizations.  This session will focus on Power BI and Datazen as well as how they compare with older technologies.  We will have a number of examples as well as point to resources for future learning.

SharePoint Term Stores, Taxonomies and Managed Metadata are key resources within the SharePoint Environment

Saturday, March 21st, 2015 at 8:30 am

Term Stores expose a wealth of information including user data, organization structure and enforce consistency. This session will cover how to manage and leverage this resource within applications. Term stores are key for managing navigation, search and data consistency. It is a hierarchical repository that allows for a place to manage information. Included will be examples for managing and using term stores programmatically.