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:
R
Power Pivot
Power Query
Power View
Excel
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
    Jennifer_Stirrup.png
    Jen Stirrup is a Gigaom industry analyst, an author, SQL Server MVP, a data strategist and practitioner in Business Intelligence, Big Data and Data Visualisation. Jen is joint owner of a boutique consultancy firm that offers strategic advice and implementation in data technologies. With nearly 20 years’ experience in delivering artificial intelligence, business intelligence and data visualisation projects, Jen has focused on delivering business value for organisations of various sizes globally. 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. 
    http://www.jenstirrup.com http://www.jenstirrup.com/feeds/posts/default?alt=rss
  • Video
    The video is not available to view online.