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
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?
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
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
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!
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
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?
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
I was recently asked how to connect Tableau to a Microsoft Tabular model. The concept itself is straightforward in Tableau. In my opinion, tabular models will become more prevalent, so I will start to look at them more detail.It turns out that the individual who questioned me was struggling, unfortunately. The resolution was that he… Continue reading Tabular models and Tableau
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