Power BI is a suite of business analytics tools that deliver insights throughout your organisation. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. This course is designed to give users an understanding of the Power BI Desktop, the Power BI service and Power BI Mobile and give users the essential skills for creating complex datasets and reports from data taken from a variety of sources.
Description:
The Power
BI course covers: Getting data, Modeling, Visualisations, Exploring data, Power BI and Excel, Publishing and sharing, and an Introduction to DAX.
Introducing Power BI
Using Power BI
The
building blocks of Power BI
A quick look at the Power
BI service
Review and what's next
Overview of Power BI Desktop
Getting started with
Power BI Desktop
Connect to data sources in Power BI
Desktop
Clean and transform your data with the Query
Editor
More advanced data sources and transformation
Cleaning irregularly formatted data
Introduction to modeling your data
How to manage
your data relationships
Create calculated columns
Optimizing data models
Create calculated measures
Create calculated tables
Explore your time-based data
Introduction to visuals in Power BI
Create and
customize simple visualizations
Combination charts
Slicers
Map visualizations
Matrixes and tables
Scatter charts
Waterfall and funnel charts
Gauges
and single-number cards
Modify colors in charts and
visuals
Shapes, text boxes, and images
Page layout
and formatting
Group interactions among
visualizations
Duplicate a report page
Show
categories with no data
Summarization and category
options
Z-order
Visual hierarchies and drill-down
R integration in Power BI Desktop
Introduction to the Power BI service
Quick
insights in Power BI
Create and configure a dashboard
Ask questions of your data with natural language
Create custom Q&A suggestions
Share dashboards with
your organization
Display visuals and tiles
full-screen
Edit tile details and add widgets
Get
more space on your dashboard
Install and configure a
personal gateway
Introduction to using Excel data in Power BI
Upload Excel data to Power BI
Import Power View and
Power Pivot to Power BI
Connect OneDrive for Business
to Power BI
Excel in Power BI - summary
Introduction to content packs, security, and groups
Publish Power BI Desktop reports
Print and export
dashboards and reports
Manually republish and refresh
your data
Introducing Power BI Mobile
Create
groups in Power BI
Build content packs
Use content
packs
Update content packs
Integrate OneDrive for
Business with Power BI
Publish to web
Completion
of Power BI Guided Learning
Introduction to DAX
DAX calculation types
DAX
functions
Using variables in DAX expressions
Table
relationships and DAX
DAX tables and filtering
Contact us for further information, to check available dates or to book a course.