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

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

Big Data, Business Analytics, SQLServerPedia Syndication

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

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!

Data Relish Services, Microsoft, PASS Board of Directors

Four years an MVP: what I’ve been doing, and what’s next?

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?

Community, Data Relish Services, Diversity, SQLServerPedia Syndication, Women In Tech

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?

PASS Board of Directors, SQLServerPedia Syndication

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.