Business Analytics, Data Relish Services, PASS BA Conference

BA Marathon – what is it, and who is it for?

On Your Mark. Get Set. Go! Join us on February 3, 2015 for a preview of what's to come at the PASS Business Analytics Conference in April. The BA Marathon features 6 back-to-back live webinars with leading experts from around the world. Register for all sessions to take advantage of this free, live educational experience! I'm… Continue reading BA Marathon – what is it, and who is it for?

Business Analytics

Please deregister from SQLSaturday London Business Analytics edition if you’re not coming

SQLSaturday London Business Analytics Edition is a community-run, no-frills event. It's free to you, the community member. How does it work? I raise sponsorship funds to cover costs of the food, venue and so on in order to make the day happen for you all. It's been hard work, but lots of fun too! Speakers give up… Continue reading Please deregister from SQLSaturday London Business Analytics edition if you’re not coming

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, 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

Business Analytics, PASS BA Conference

Wondering how to train your team for the Analytics you want in your organisation? Look at PASS BA Conference

Whether you're starting up an Analytics team in your organisation, there are more available positions than ever – and not enough people to fill them! Todd Nevins, cofounder and director of marketing and media relations at job site icrunchdata, noted the site's "Big Data Jobs Index" surpassed half a million last week.How do you get people… Continue reading Wondering how to train your team for the Analytics you want in your organisation? Look at PASS BA Conference