I'm pleased to announce that the University of Washington are running a Foundations of Data Analysis course, starting in January 2020. In this 10-week course, you'll learn how to understand and analyze data. We’ll start with fundamental data-related concepts, terminology and ethical considerations. You’ll learn how to articulate business problems and identify required data. Using Microsoft Excel and SQL, you’ll practice gathering, cleaning and organizing data. Finally you’ll use Tableau to effectively describe, analyze and visualize data.
Nearly three years ago, I complained bitterly about the demise of Windows Datamarket, which aimed to provide free, stock datasets for any and every purpose. I was a huge fan of the date dimension and the geography dimension, since they really helped me to get started with data warehousing. So I'm glad to say that… Continue reading #MSBuild Azure Open Datasets
The European DatSci & AI Awards in collaboration with the BDVA & CeADAR are now accepting entries! I'm delighted to announce that I am on the Judging Panel this year, along with people that I admire. The Awards recognizes the gold standard for Data Science & AI in Industry, Education and Social Responsibility and connects the Data Science community… Continue reading European Data Science & AI Awards 2019 Entry details
Marketing is viewed as a key strategic participant in achieving the goals of businesses, both large and small. I thought I'd share how we started to apply marketing theory, practice, and insights from data. There are tons of 'skate on the surface' marketing soundbite books, which may sound good at the first glance with no… Continue reading Marketing as a strategic business partner: mixing theory, research and #data
Have you seen the custom modules for AzureML yet? One neat custom module that I've been using is the Create Scatterplot module, which uses ggplot2 and R in order to create a scatterplot. It's possible to do this in AzureML already but it takes a few extra steps, and it is good to be able… Continue reading Custom Modules for #AzureML
Be Insights Driven, not Data Driven, and definitely not Tool Driven. Tableau vs Power BI vs Qlik
Come and meet me at Microsoft Ignite!
I'm speaking at #ITDevConnections 2018! Join me in Dallas and learn on topics such as: Blockchain Demystified for Business Intelligence Professionals Data Analytics with Azure Cosmos Schema-less Data and Power BI R in Power BI for Absolute Beginners There is also a Women in Technology lunch and I'm excited about that, too! Join me in… Continue reading I’m speaking at #ITDevConnections 2018!
This weekend, I volunteered with DataKind UK on their Summer DataDive, which took place on the weekend of 28th and 29th July 2018 in the Pivotal London offices in Shoreditch. I had a fantastic, memorable weekend, mixing with around 200 other data scientists. I'd like to thank the DataKind team for being so inspirational, giving,… Continue reading Fun DataDive with DataKind UK
A question I often here is this: Which tool should I use, Tableau or Power BI? The truth is: They are not mutually exclusive. Tableau is great at business mysteries: ill-defined questions where you have to surf the data for results. Power BI is particularly great at modelling and cleaning the data, with clean, crisp… Continue reading Tableau Prep, Power Query and Power BI – Good together?
One of my project roles at the moment (I have a few!) is that I am architecting a major Azure implementation for a global brand. I'm also helping with the longer-term 'vision' of how that might shape up. I love this part of my job and I'm living my best life doing this piece; I… Continue reading Modelling your Data in Azure Data Lake
I am helping some people learn Data Science and we are having a ton of fun! There are lots of things to remember. So I am noting things here, in case I forget! We noted the following error message, when we saw that R was not running on our SQL Server 2017 install: 'sp_execute_external_script' is… Continue reading Issues and Resolutions in starting R and R Server on SQL Server 2017