Data Science

Data Science VC follow up: Intro to R and Statistics for the Rookie Part 1

I've decided to hold a five week introductory statistics and R course. Here, I am sharing the slide deck and the code. The video will go up on our YouTube Data Science Virtual Chapter channel, which is accessible from here. In the first week, we talked about the relationship between statistics and data visualisation, and… Continue reading Data Science VC follow up: Intro to R and Statistics for the Rookie Part 1

Data Science, Data Visualisation

Visualising Data with R: HTMLWidgets for R

I'm interested in analyzing and visualizing data with R, as you know. Thanks to Jen Underwood, she pointed me at this cool series of widgets, called HTMLWidgets, that allows you to do some interesting visualisations with R. I must admit I haven't touched JavaScript for years, ever since I helped to build websites for well known entertainment… Continue reading Visualising Data with R: HTMLWidgets for R

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?

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

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

The Data Analysts Toolkit Day 2: Installing R and R Studio

In this topic, we will look at the installation of R and RStudio as part of our R and Power BI Data Analysts Toolkit.Why use RStudio as well as R?Simply put, it is suitable for the enterprise and it is also open-source. It makes R easier to use and to troubleshoot.RStudio is a tool which… Continue reading The Data Analysts Toolkit Day 2: Installing R and R Studio

Community, Data Science, PowerBI, PowerPivot, SQLServerPedia Syndication

What do you need for my SQLBits R and PowerBI session? Nothing!

What do you need for my SQLBits R and PowerBI session? Nothing! I am not expecting people to have installed anything in advance, hence I have made no requests for the event. I will cover it during the session. Usually people never do it in advance because they are hassled in work, trying to clear their desks before… Continue reading What do you need for my SQLBits R and PowerBI session? Nothing!

Big Data, Data Science, PASS BA Conference, SQLServerPedia Syndication

PASS BA Conference: Announcing my R and Hadoop session

I'm delighted to announce that I will be presenting at the PASS Business Analytics Conference in May 5 - 7 in San Jose, California.If you are looking for a discount, here is a code to get $150 dollars off: BASF2O and to Register click here: My session is called: R AND HADOOP: FROM DATA SOURCES TO SECRET… Continue reading PASS BA Conference: Announcing my R and Hadoop session

Business Intelligence, Data Visualisation, PowerBI, SQLServerPedia Syndication, Tableau

How do you choose the right data visualisation in Power BI to show your data?

How do you choose the right visualisation to show your data? Usually the customer wants one thing, the business user want something else, the business sponsor wants something flashy.... and it's hard to tease out the requirements, and that's before you've even opened up Power BI such as Power View, Excel, Tableau or whatever your… Continue reading How do you choose the right data visualisation in Power BI to show your data?

Business Analytics, Business Intelligence, Data Visualisation, PowerBI, SQLServerPedia Syndication, Tableau

Data Visualisation: lifting the curse of Cassandra

Information is the new currency, the lifeblood of organisations. However, it has to be explored, and evangelised throughout the organisation before it can have any real impact. SQL Server 2012 now helps business users to access the data; a real paradigm shift in the 'umbrella' of users who touch SQL Server.However, does that mean that… Continue reading Data Visualisation: lifting the curse of Cassandra

Business Analytics, Community, Data Relish Services, Mobile Business Intelligence, PowerPivot, Tableau

SQLUniversity: PowerPivot, Tableau and Jedi Knights

This blog will show an overview of how I mobilised PowerPivot using Tableau. I've previously given this session at SQLBits, NEBytes Microsoft Technology User Group, and SQLServerDays in Belgium but thought it would also be useful to supply the files for you. The steps are very simple since I intended to show the end-to-end solution… Continue reading SQLUniversity: PowerPivot, Tableau and Jedi Knights