If you play Halo 5, then DocumentDB has already come into your life! You may have heard that Azure DocumentDB has made some new exciting developments, based on industry, customer and user feedback. Let’s have a look at the biggest news: DocumentDB now has protocol support for MongoDB. From the industry perspective, this is… Continue reading DocumentDB News: Protocol support for MongoDB Lands!
Join me in Edinburgh on 10th June for a one day Masterclass in SQL Server 2016 Business Intelligence and Data Visualisation! You'll get takeaway notes and experience hands-on labs that focus on: Power BI Excel R AzureML SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and Datazen There will be an emphasis on practical applications… Continue reading SQL Server 2016 Business Intelligence and Dataviz Masterclass
Jargogled is an archaic word for getting confused or mixed up. I'm aware that there are lots of SQL Server folks out there, who are desperate to learn R, but might be jaRgogled by R. Now that R is in SQL Server, it seems like the perfect opportunity to start a new blog series to help people to… Continue reading Learning pathway for SQL Server 2016 and R Part 1: Installation and configuration
In this series, I'm writing a bunch of very practical posts on helping you through an IoT project. There are plenty of other posts about the 'why' and the marketing buzz, but this is about the 'do'. If you are using Azure, the chances are that you might be a Microsoft Partner already. There are… Continue reading sMy handy toolkit for my Azure IoT Project – how the Microsoft Partner Network can help
SQLSaturday Edinburgh went ahead last Saturday, June 13th, and everyone had a great day. It's clear that people in the community believe in what I am doing. They voted with their feet to attend, to speak, and to sponsor. We had high quality speakers delivering world-class content - 8 MVPs, 2 Microsoft staff, and the remainder are… Continue reading Jen’s PASS Diary: SQLSaturday Edinburgh: My heartfelt thanks go to…
Counting is easy, Measuring is Hard! Dashboard Design from Jennifer Stirrup
https://www.flickr.com/photos/38953955@N07/14764024879/player/Why is analytics interesting? Well, companies are starting to view it as profitable. For example, McKinsey showed analytics was worth 100Bn today, and estimated to be over 320Bn by 2020. When I speak to customers, this is the 'end goal' - they want to use their data in order to analyse and predict what their… Continue reading Day 6: The Data Analysts Toolkit: Why are Excel and R useful together, and how do we connect them?
Hearing buzz around hybrid cloud solutions? Got some questions?For a limited time, download an eBook from Microsoft solution architects that shares their perspective on what hybrid IT is, why it’s important, and how you should determine whether a hybrid cloud is right for your business.Download a copy today!
How do R and Power BI fit together?Technically, it is about munging data around between R and Excel and the Power BI components. You can use RODBC to connect to data between R and SQL Server, or R and Excel. Alternatively you can import data in.Why else might you use R?Pivot Tables are not always enoughScaling… Continue reading The Data Analysts Toolkit Day 5: How do R and Power BI fit together?
So what actually is R? Let's take a look at running some commands, and we can talk about it as we go along.R is a powerful environment for statistical computingIt is like a calculator and its power is: … it lets you save results in variables. Let's take a look:> x > y > z =… Continue reading The Data Analysts Toolkit Day 4: Getting to know R a bit better
I have located a number of R Scripts over at my OneDrive account and you can head over there to download them. There are some other goodies over there too, so why not take a look?how do you open files? To create a new file, you use the File -> New menu.To open an existing… Continue reading The Data Analysts Toolkit Day 3: Introduction to running and understanding commands in R