SQLServerPedia Syndication

DocumentDB News: Protocol support for MongoDB Lands!

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!

Data Relish Services, SQLServerPedia Syndication

SQL Server 2016 Business Intelligence and Dataviz Masterclass

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

Community, Data Science, SQLServerPedia Syndication

Learning pathway for SQL Server 2016 and R Part 1: Installation and configuration

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

Azure, Microsoft, SQLServerPedia Syndication

sMy handy toolkit for my Azure IoT Project – how the Microsoft Partner Network can help

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

Business Analytics, Business Intelligence, Community, PASS BA Conference, SQLServerPedia Syndication

Jen’s PASS Diary: SQLSaturday Edinburgh: My heartfelt thanks go to…

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…

Business Analytics, Data Mining, Data Science, Data Visualisation, PowerBI, SQLServerPedia Syndication

Day 6: The Data Analysts Toolkit: Why are Excel and R useful together, and how do we connect them?

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?

Community, PASS Board of Directors, SQLServerPedia Syndication

Like bookclubs? Interested in learning Javascript online?

Like bookclubs? Interested in learning Javascript online? Ike Ellis is the lead for the PASS Book Readers VirtualChapter, and we're going to learn JavaScript in 8 weeks by following the recommended text and having fun discussions.  August 20th is the first session, so you have plenty of time to get the book!Sign up for the webinar… Continue reading Like bookclubs? Interested in learning Javascript online?

Big Data, Business Analytics, Community, PowerBI, SQLServerPedia Syndication

The Data Analysts Toolkit Day 5: How do R and Power BI fit together?

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?

Big Data, Business Analytics, Data Science, PowerBI, SQLServerPedia Syndication

The Data Analysts Toolkit Day 4: Getting to know R a bit better

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

Big Data, Business Analytics, Data Science, PowerBI, SQLServerPedia Syndication

The Data Analysts Toolkit Day 3: Introduction to running and understanding commands in R

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