Here is my latest blog on the PASS BA Conference website: Data and Rethinking Universal Assumptions. Learn more with me – catch mysession, “Pulling Back the Green Curtain: Data Forensics, Power BI, and Dataviz,” at the PASS Business Analytics Conference in Santa Clara, CA, April 20-22.
In case you haven't seen it, we have some of the sessions up on the PASS BA Conference website now. Here's the link so please do go and take a look. Announcing PASS BA Conference Sessions.
In the Wizard of Oz, Toto pulls back the green curtain to expose that the Wizard of Oz is a fraud. We can peep behind the 'green curtain' of the data visualisation to learn how to 'poke holes' in the data that you are given, both in business and in everyday news headlines.
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
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?
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
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
** Update at 11th March: This is not an advert for PivotStream and I am not endorsing their services or solution. To show that this blog post is not an advert for PivotStream, I will explore alternatives, which I will follow up in a future post.In the meantime, you could look at PowerBI and Office 365 with … Continue reading Business Intelligence Barista: Mixing your choice of BI Coffee with Tableau, Power BI or Qlikview?