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

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

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

The Data Analysts Toolkit Day 1: cleaning and importing your data using Power Query

What does the Data Analyst need for a Toolkit?Power BI - Excel, Power Query, Power ViewRPower BI - cleanse, model, visualiseR - check, check, check, explore, statistics.In this series, we will look at:Power BI - cleanse dataSome basic R scriptsanalysing and visualising data in RAccessing data in the Hortonworks Sandbox  for analysis with RPower BI … Continue reading The Data Analysts Toolkit Day 1: cleaning and importing your data using Power Query

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!

Steampunk SQLBits tshirt follow up

Firstly I wanted to say a big thank you to everyone who reads this blog. I was totally overwhelmed by the number of people who got in touch, from every part of the world.I am really sorry but I simply could not buy everyone a tshirt. There were simply too many requests and I do … Continue reading Steampunk SQLBits tshirt follow up

Interested in helping SQLBits to craft the first ever SQLBits Wikipedia page?

Exciting DitBits news from the SQLBits camp today.  We will be hosting a 'Wikipedia Edit-A-Thon' which will focus on gathering budding community authors, editors and reviewers together to create the first ever Wikipedia SQLBits page!I'm looking for photos for the SQLBits photo album, which we will be posting online. Please send your photos, or links to … Continue reading Interested in helping SQLBits to craft the first ever SQLBits Wikipedia page?

Got questions over PASS Summit Selection? I’m happy to try and help.

I hold the PASS Board seat for Europe, so I would like to give Europeans in particular the chance to ask questions in their own time zone. I'm also happy to answer other people who may be awake very early or very late! The official post is here:  http://www.sqlpass.org/Community/PASSBlog/tabid/1476/year/2014/month/7/Default.aspx   Therefore I would like to … Continue reading Got questions over PASS Summit Selection? I’m happy to try and help.

Focus on the Global Spanish Virtual Chapter

I love that the PASS Virtual Chapters have a global impact for Microsoft data platform learners around the world. The VCs are my portfolio for my role on the PASS BoD. In case you haven't seen the VCs, PASS offer free learning in a variety of languages, including Hebrew, Spanish, Portugese, Italian and so on. … Continue reading Focus on the Global Spanish Virtual Chapter

Note to Self: Here is a group of cloud videos to watch

Happy Viewing!Here is a group of Cloud OS videos for your viewing. Enjoy! I'm particularly looking forward to 'pants versus shorts', for example!·        Introducing the Master of Mobility from Microsoft ·        Hybrid Identity:  Master of Mobility, Part 2 ·        Mobile Device Management: Master of Mobility, Part 3 ·        Sliding Window Data Partitioning on Microsoft Azure … Continue reading Note to Self: Here is a group of cloud videos to watch

PASSBAC 2014: Empowering the Data Citizen; datacapability on any device

The main theme here is that Microsoft are opening up their data tools to any device. Bringing the power of data to everyone in the organisation. The journey for the data culture starts today!How successful is it? Over at Copper Blue, we are big Power BI users. As a small organisation, the setup suits us … Continue reading PASSBAC 2014: Empowering the Data Citizen; datacapability on any device

The Law of Two Feet: Why you should attend the PASS Business Analytics Unconference

An unconference is a conference organized, structured and led by the people attending it. And we are having one at the PASS Business Analytics Conference!Unconferences are founded upon The Law of Two Feet, which states that:If during the course of the gathering, any person finds themselves in a situation where they are neither learning nor contributing, … Continue reading The Law of Two Feet: Why you should attend the PASS Business Analytics Unconference