Posted in: Microsoft SQL
NOAA Radar and Severe Weather Data Inventory
After I finished evaluating the Storm Events Database from NOAA, I was convinced we needed to look for machine recorded events. When you start poking around the
microsoft sql
Posted in: Microsoft SQL
Data Quaity Issues
This entry picks up the story behind my first data science project predicting hail damage to farms. In this article we identify data quality issues in our first
Posted in: Microsoft SQL
Data Science Project 1: Predicting Hail Damages
Early on in my new role I was asked to find out how risky it was to offer hail insurance for a given property. If you haven't worked with insurance before
microsoft sql
Becoming a Data Scientist
In my latest professional change I've moved into a role with a bright and shiny title: Data Scientist. I've heard all the hype around Data Science, Machine
Posted in: Microsoft SQL
Data Analysis…can we automate this?
As some of you know, I've made a move from consulting back into a full-time employee for Crop Pro Insurance. There was so much opportunity in this role. First
Posted in: Microsoft SQL
Metadata Model Update
As I began learning Biml, I developed my original metadata model to help automate as much of my BI development as I could. This model still works today, but as
Posted in: Microsoft SQL
Data Warehouse Efficiency
How quickly do you get from the business coming to you with "we need a data warehouse" to delivering that warehouse? If you've sat through any Biml talk, you've
Posted in: Microsoft SQL
Building our Alexa Skill Function
In putting together the demo for this blog, I found there is an issue when saving data to the Alexa Session data. I can't reliably write to this collection in
Posted in: Microsoft SQL
Building our Alexa Skill
Currently, there are two ways we can construct our skill. You can use the Amazon developer portal, or you can use the Alexa Skills Kit Command Line Interface
Posted in: Microsoft SQL
Alexa Design Process
Let's start designing our Receptionist skill. The purpose of this skill will be to help visitors who come in for meetings alert the employee they're meeting
Posted in: Microsoft SQL
U-SQL: Automating Schema on Read
Moving to U-SQL for your ETL can feel like a step back from the drag and drop functionality we have in SSIS. But there is one great thing about your ETL being
Posted in: Microsoft SQL
Data Warehouse Automation is for Data Lakes too!
Last week you might have seen a tweet about a day in the life of a Data Platform Consultant. To say the least, my days are varied.This day, in particular, I was