£105.39

Data Visualisation for Analytics Professionals - Power BI

Event Information

Share this event

Date and Time

Location

Location

Birkbeck, University of London

Malet Street

London

WC1E 7HX

United Kingdom

View Map

Refund Policy

Refund Policy

Refunds up to 1 day before event

Event description

Description

Learn Power BI – a powerful cloud-based service that helps analytics professionals visualise and share insights from their data.

Looking for new ways to find and visualize data and to share your discoveries?

Power BI is quickly becoming the platform of choice for analytics professionals seeking to easily visualize and share insights from their organizations’ data.

In this one-day course, led by a Microsoft MVP, you’ll learn how to use Power BI to explore, analyse and visualise your data, and then how to share those results with your colleagues – or with the world.

Through a series of interactive talks, discussions and practical exercises, you'll learn how to use Power BI to:

  • Import, Clean, and transform your data for Business Intelligence (BI)
  • Create engaging visualizations that resonate and get shared by your target audience including; bar charts, line charts, scatter plots, matrix and table visuals, maps, bullet charts and others
  • Tell stories with data; use bookmarks, spotlight, create drill-though pages
  • Distribute and share content with colleagues - or with the world

You’ll leave with the foundational knowledge you need to explore, analyse and visualise your data using Power BI.

Course Leader

Mark Wilcock is a two-time Microsoft Most Valuable Professional (MVP) specialising in data analytics and visualisation, with particular expertise in Power BI using the Microsoft Data Platform.

Mark’s background is in banking, especially in risk, and some of his previous clients include Barclays, Credit Suisse, Nomura, and BNP Paribas. He provides bespoke training courses to a wide range of audiences on data analytics and visualisation in general and Power BI and R in particular. He is the organiser of the very popular data & analytics meetup group in London.

100% Money Back Guarantee

We guarantee an excellent learning experience, so if you are not fully satisfied, we'll refund you 100% of your money.

Learning Objectives

This course is aimed at business professionals and people who analyse data in their day-to-day job. The objective is that after the course they have a broad understanding of how to explore analyse and visualise data and then share those results with colleagues – or with the world.

We will use Power BI Desktop, a free tool from Microsoft to go from data to insights in minutes. We’ll provide download details and other information and the public datasets we’ll use in the joining instructions we’ll send out a week or so before the course.

Course Structure

This is a practical course split into several short sessions. Each session will start will a quick introduction and objectives, followed by a short demo, then most time is for guided exercises. Attendees will be provided with a step-by-step set of instructions and a worked solution in case they get stuck.

Each session will use a different dataset so attendees have lots of variety and because datasets differ a great deal and require different techniques to extract value from them. They are drawn from health, economics, finance. During the sessions, we may look at the sales and revenue of a trading company, how much people in different countries drink – and how long they live; investigate why passengers survived or perished on the Titanic; analyse the text of a BBC News article; visualise the risk and revenue of a (fictitious) bank.

Content

The course will teach how to analyse and visualise data in several themes:

• Import data from common sources (CSV, Excel, databases and other sources).
• Clean and transform data - replace or remove bad values, filter the rows, group, summarise, pivot and unpivot data, calculate results
• Model data; create relationships between datasets, create hierarchies and groups
• Calculate useful quantities e.g. sums, averages, rolling sums, year-to-date values.
• Build helpful and insightful visuals; bar charts, line charts, scatter plots, matrix and table visuals, maps, bullet charts and others plots; choose how one visual affect others (as a filter, highlight)
• Explore and explain data: drill to detail, show data, add basic analytics (averages, trends, clusters, reference lines)
• use slicers (filters) , what-if parameters and other methods to explain the data and help your audience draw insight
• Tell stories with data; use bookmarks, spotlight, create drill-though pages
• Improve and polish reports: add text, images and other non-data elements to enhance the report; apply conditional formatting e.g. data bars; configure titles, axes, colours, labels; design for a phone / mobile device
• Discussion of best practices; guidelines and examples
• Distribute and share content with colleagues or with the world

Share with friends

Date and Time

Location

Birkbeck, University of London

Malet Street

London

WC1E 7HX

United Kingdom

View Map

Refund Policy

Refunds up to 1 day before event

Save This Event

Event Saved