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

Azure, Big Data, Business Intelligence, Hortonworks

Note to Self: A roundup of the latest Azure blog posts and whitepapers on polybase, network security, cloud services, Hadoop and Virtual Machines

Here is a roundup of Azure blogs and whitepapers which I will be reading this month. This is the latest as at June 2014, and there is a focus on cloud security in the latest whitepapers, which you can find below..·         PolyBase in APS - Yet another SQL over Hadoop solution? ·         Desktop virtualization deployment… Continue reading Note to Self: A roundup of the latest Azure blog posts and whitepapers on polybase, network security, cloud services, Hadoop and Virtual Machines

Big Data, PowerBI, SQLServerPedia Syndication

Democratization of Data: From Ideas to Decisions with Power BI

"Don’t worry about people stealing an idea. If it’s original, you will have to ram it down their throats.” Howard Aiken, Founder of Harvard’s Computing Science Program.Data is moving so fast these days, and there is a shift whereby people are paying for value, not technology. This is where cloud computing comes in: it is… Continue reading Democratization of Data: From Ideas to Decisions with Power BI

Big Data, Data Science, PASS BA Conference, SQLServerPedia Syndication

PASS BA Conference: Announcing my R and Hadoop session

I'm delighted to announce that I will be presenting at the PASS Business Analytics Conference in May 5 - 7 in San Jose, California.If you are looking for a discount, here is a code to get $150 dollars off: BASF2O and to Register click here: My session is called: R AND HADOOP: FROM DATA SOURCES TO SECRET… Continue reading PASS BA Conference: Announcing my R and Hadoop session

Big Data, Community, Data Relish Services, PowerBI, SQLServerPedia Syndication

Analysing Data with Hive and Power BI Slides from SQLRally Amsterdam

Here are my slides from SQLRally Amsterdam. A major thanks to the SQLRally Amsterdam crew, lead by Andre Kamman, for all their hard work in putting together this great community event! Sql rally amsterdam Aanalysing data with Power BI and Hive from Jennifer Stirrup I hope that helps!Kind Regards,Jen

Big Data, Community, Data Relish Services, Hertfordshire User Group for SQL Server (HUGSS), SQLServerPedia Syndication

Microsoft is coming to Hemel Hempstead for a free of SQL Server, Windows Server and System Center training!

SQLRelay and Cloud OS Relay are joining forces at Hemel Hempstead for a great, free day of training! This will be held on 15th November at Shendish Manor, which is in Hemel Hempstead.As featured on TechNet, we will be having a SQL Server track and a separate Infrastructure track, which is dedicated to Infrastructure specialists.… Continue reading Microsoft is coming to Hemel Hempstead for a free of SQL Server, Windows Server and System Center training!

Big Data, Community, Data Relish Services, Data Visualisation, Hortonworks, Microsoft, PowerBI

Data Visualisation with Hadoop, Hive, Power BI and Excel 2013 – Slides from SQLPass Summit and SQLSaturday Bulgaria

I presented this session at SQLPass Summit 2013 and at SQLSaturday Bulgaria.The topic focuses on some data visualisation theory, an overview of Big Data and finalises the Microsoft distribution of Hadoop. I will try to record the demo as part of a PASS Business Intelligence Virtual Chapter online webinar at some point, so please watch… Continue reading Data Visualisation with Hadoop, Hive, Power BI and Excel 2013 – Slides from SQLPass Summit and SQLSaturday Bulgaria

Big Data, Business Intelligence, Community, PowerBI, SQLServerPedia Syndication

Eating the Elephant: Totally free videos showing an introduction to Visualising Big Data for Business Intelligence Professionals

Continuing my 'eating the Elephant, one bite at a time' series, which focuses on Microsoft Business Intelligence and Hadoop, I've put together a series of totally free videos, to help people who are interested in visualising Big Data using familiar tools in Microsoft. The purpose is to take data from various data sources, including SQL… Continue reading Eating the Elephant: Totally free videos showing an introduction to Visualising Big Data for Business Intelligence Professionals

Big Data, Business Analytics, Data Relish Services, Hortonworks

Hadoop Summit Europe 2014 Call for Abstracts is now open

Hadoop Summit Europe 2014 Call for Abstracts is now openIf you are interested in registering, please click here. Good luck! The call for Abstracts for the EMEA Hadoop Summit is now officially open. FYR the closing date is 31st October 2013.Who should submit? If you are a developer, architect, administrator, data analyst, data scientist, IT or… Continue reading Hadoop Summit Europe 2014 Call for Abstracts is now open

Big Data, Community, SQLServerPedia Syndication

Big Data preconference at SQLSaturday Cambridge

I'm pleased to be holding a precon entitled 'Big Data for the Business Intelligence Professional' at SQLSaturday Cambridge on 27th September. We still have a few places left. To register, please contact sqlsaturday228@sqlsaturday.com Why would this benefit you? Well, let's face it; Big Data is coming. It is something that Business Intelligence professionals are going to… Continue reading Big Data preconference at SQLSaturday Cambridge

Big Data, Hortonworks, SQLServerPedia Syndication

Eating the elephant, one bite at a time: Loading data using Hive

In the previous 'Eating the elephant' blogs, we've talked about tables and their implementation. Now, we will look at one of the ways to get data into a table. There are different ways to do this, but here we will look only at getting data into an external Hive table using HiveQL, which is the… Continue reading Eating the elephant, one bite at a time: Loading data using Hive