Analyse and Visualise Data with Power BI
by Mark WilcockLanguages: English
Price (from): €1,500 / day
About the trainer:
Mark provides training courses to improve your data literacy and data visualizations. His most popular courses help anybody who works with data to become smarter and savvier with data and to create engaging charts to communicate their message. He runs specific courses; Power BI and Power Platform at both beginner and advanced levels; and popular data languages and tools: SQL, R and Python, and of course Excel. In 2019, Mark trained over 500 people - customers in finance, hospitals, universities, charities, and the public sector.
Please login to send a message
Analyse and Visualise Data with Power BI by Mark Wilcock
About the training
1-day in-house course
The course is an introduction to Power BI, a suite of products from Microsoft to go from data to insights in minutes This course is aimed at people who analyze and report data in their day-to-day job using either Power BI.
The objective is that after the course attendees have a broad understanding of how to use Power BI to explore, analyze and visualize data and then share those results with colleagues – or with the world.
This is a practical course split into several 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 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 mainly from public (open) datasets.
During the sessions, we may look at the daily share prices of oil companies, the performance of triathletes, the popularity of baby names in England over the last 100 years. We will investigate why passengers survived or perished on the Titanic; analyze the text of a BBC News article.
Objectives
At the end of the course, participants will have a good understanding, and some practical experience, of the modern techniques for transforming, analyzing and visualizing data-producing reports and dashboards, and distributing these to an audience.
Datasets Used in The Course Exercises
The course uses a variety of public datasets because datasets differ a great deal and require different techniques to extract value from them. They are drawn from the health, economics, finance, and transport. The datasets mentioned are either public data or completely fictitious.
Learning outcomes
GET DATA
Data comes from a large variety of sources. We look at techniques to extract data from these sources with examples using both Power BI Desktop and Excel. This will cover extracting data from the following sources including: - Excel spreadsheet, - CSV files, - relational databases and - web pages
PREPARE AND CLEAN DATA
Our data rarely starts life in clean and tidy shape. We need to prepare the data so it is ready for analysis and visualization. We look at techniques such as: - clean and tidy data: pivot and unpivot, filter datasets, handle missing values, group, and sort data; - transform data: filter, sort, calculate new results to enrich the value of the data; - merge and append datasets
VISUALISE DATA – create reports and dashboards
Once our data is clean and ready for visualization, we can create interactive reports. This section covers: - the basic chart types: line-chart, bar and column charts, scatter plots, and when it is appropriate to use which; - improve these charts and making them appealing and attractive; titles, axes, fonts and good use of colour, - configure several charts to interact well on a single report page to help guided analysis (e.g. drill from summary to detail)
ANALYSE DATA
This covers several analytic techniques: - group data - add analytical results to charts; for example, reference, average and trend lines
Program
Introduction to the Course:
Introduction to the course – structure, objectives, goals, tools, datasets, exercises
Overview of Power BI
Get started with Power BI
Getting Started Lab Exercise (Football):
This will be a step-by-step follow the trainer instruction format so that users gain basic familiarity with Power BI Desktop
Lab Exercise (Triathlon):
Transform a source dataset e.g. unpivot
Transform a source dataset e.g. unpivot
Practice with scatter and bar charts
Lab Exercise (Baby Names)
Transform a source dataset e.g append datasets, add new columns
Practice with scatter and bar charts
Practice with interactions between visuals, conditional formatting
Add slicers and filters e.g. build a Top N filter
Configure the interaction between visuals on a report
Lab Exercise (Titanic)
Cleaning data in the Query Editor
Exploratory data analysis
Group and bin data
Drill-through pages
The Key Influencers Visual
Main benefits
- #Wide collection of the biggest experts
- #Filters for all kinds of needs
- #User friendly platform
- #Fast and cheap
- #Highest level of proficiency
More trainings of the trainer