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
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 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! 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!
Four things a woman should know: How to look like a girl, How to act like a lady, How to think like a man, and how to work like a dog.I attended an event recently at which I was speaking. I met a few nice attendees who were new to the SQL Server scene, and… Continue reading Four years an MVP: what I’ve been doing, and what’s next?
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
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?
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.