The Data Analysts Toolkit: Microsoft Power BI & R

The takeaways will focus on:
Module 1: Introduction to Data Visualisation and Dashboarding Theory
In this module, we will look at an overview of theory and scientific evidence about data visualisation. Understanding the 'why' can help to make us better at the 'how', regardless of the technology.We will also look at an overview of the Power BI suite of tools.

Module 2: Introduction to R for Business Analysis
In this module, we will look at an overview of R for business analysis and data analysis. We will look at its most commonly used features for implementing statistical and data analysis.

Module 3: The Big Picture: Putting Microsoft Power BI and R together
Delegates will have different degrees of experience with different tools, so it is important to paint broad brush strokes to show off the technology working together. We will look at the following technologies in an end-to-end environment:
Power Pivot
Power Query
Power View
Module 4: Further Data Visualisations 
Learn about visualisations in accordance to theory and practice put forward by gurus such as Stephen Few and Edward Tufte. We will cover the complexities of displaying multivariate data since is potentially more complex by visualisations. 
Module 5: Putting it all together - Dashboards
We will look at creating dashboards in Power View and Excel.To summarise, this precon aims to deliver a breadth of data visualisation knowledge, underpinned by cognitive psychology theory to provide deeper understanding of data visualisation, translated into Microsoft Power BI functionality.
Presented by Jennifer Stirrup at SQLBits XII
Tags BI
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Jen Stirrup is an award-winning, world recognised Business Intelligence and Data Visualisation expert, author, data strategist, MVP, and technical community advocate who is repeatedly honoured with peer recognition as one of the top 100 most global influential tweeters on Big Data topics. Jen has over 16 years experience in delivering BI and dataviz projects for companies of various sizes around the world. Jen is an elected member of the Board of Directors for the Professional Association of SQL Server, holding the seat for Europe and holder of the Virtual Chapters portfolio worldwide. Jen has presented at TechEd North America and Europe, Summit, SQLBits, as well as at SQLSaturday and other SQL events in the UK, in the US and on many occasions across Europe such as Hungary, France, Belgium, Germany, Portugal, Poland, Sweden, Norway, Switzerland, Ireland, Denmark, Bulgaria, Austria and the Netherlands. Therefore she works hard! She has proven evidence of being extremely involved in the SQL Community across the UK, Europe and the US, and has been for a number of years now. She has also presented preconference sessions in Microsoft Business Intelligence and Data Visualisation for SQLPass, SQLSummit and at various countries around Europe. When she is not working for the SQLFamily, Jen jointly runs a Copper Blue Consulting based in Hertfordshire with Allan Mitchell, where they helps business leaders derive value from their Microsoft SQL Server, SharePoint and Office365 investment both here in the UK, Europe and the US, and more recently in Africa. Jen has also won awards for her blog and community work, most notably from SQLServiaPedia as runner-up for best Business Intelligence blog. She is a former Awardee of PASS's prestigious PASSion Award in 2012.
  • Video
    The video is not available to view online.