With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published.
This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.
This course does not cover MS Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.
-
- Please note that this course is not suitable for new Excel or database users
- Ability to create, format chart outputs
- An understanding of basic data concepts
- Excel Level 3 and above knowledge and experience required
- Please note that this course is not suitable for new Excel or database users
-
- Power BI Desktop Concepts and Main Features
- Data Sources compatible with Power BI Desktop
- Connecting to Data with Power BI Desktop
- Explore Data Visualizations
- Apply Common Query Tasks to Shape Data in Power BI Desktop
- Create and publish Reports
-
- Anyone who is an experienced user of Microsoft Office applications and who needs to work with data in order to connect to, process, analyse in order to produce suitable output at all levels within an organisation.
- It is assumed that attendees on the course are already familiar with charts and PivotTable concepts.
-
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
- Telephone and Email Support
-
Getting Started with Power BI DesktopPower BI Concepts and Overview
Introduction to Main Features
Report View
Data View
Relationship View
Query Editor
Using and interacting with reports -
Connecting to Data Sources with Power BI DesktopTypes of Data Sources in Power BI Desktop
Get Data
Connecting to Excel, CSV, Text
Connecting to web data
Connecting to databases (Access, SQL etc)
Connecting to multiple sources
Refresh connections -
Getting Started with Data VisualizationsOverview of Data Visualizations
Tables and Matrix Views
Simple Charts
Pie, Columns and Bar Charts
Tree Maps
Simple Geo Maps
Interactive Data and Date Slicers
Drill Visualizations to see underlying data
Adding Titles
Adding Data Labels
Setting Font and Colour Formatting
Applying Conditional Formats
-
Querying and Cleaning DataSetting Data Types and calculation types
Geocode Data
Query Editor
Replace Values
Fix Errors
Remove, Duplicate and Move Columns
Filter out unneeded data
Split Columns
Pivot and UnPivot
Creating Custom Columns
Adding Conditional Columns
Columns by Example
Merge Queries
Append Queries -
Modelling DataConnecting to multiple tables
Adding relationships to data
AutoDetect
Types of relationships
Creating Date Table to add functionality -
Introduction to DAX calculationsDAX Expressions
Calculated Columns
Measures
Time Intelligence
Year on Year comparisons
Year to date calculations
Same Period last year comparison
Quick Measures
-
Reports and Output OptionsReport Elements and Options
Working with Pages
Adding Graphics
Visual and Filter Settings
Export Power BI Data to CSV
Publishing options -
Advanced Visualisations and Report optionsMapping Data
ArcGIS Maps and options
Combo Charts
Gauge Charts
Funnel Charts
KPI’s
Custom Visuals
Word Clouds
Record Grouping and Binning in Visualizations
Drill Visualizations with using Dates
Analytics and Forecast Lines in Visualizations
A. Kookaburra, Microsoft Power BI Desktop
D.J. Public course, Microsoft Power BI Desktop
G.T. Public course, Microsoft Power BI Desktop
G.T. Public course, Microsoft Power BI Desktop
G.T. Public course, Microsoft Power BI Desktop
V.P. MGL, Microsoft Power BI Desktop
H.S. Durham County Council, Microsoft Power BI Desktop
H.S. Durham County Council, Microsoft Power BI Desktop
A.F. PX Limited, Microsoft Power BI Desktop
R.W. PX Limited, Microsoft Power BI Desktop
C.B. PX Limited, Microsoft Power BI Desktop
R.B. NOCN, Microsoft Power BI Desktop
S.H. NOCN, Microsoft Power BI Desktop
L.B. NOCN, Microsoft Power BI Desktop
G.S. Northern Power Grid, Microsoft Power BI Desktop
G.S. Northern Power Grid, Microsoft Power BI Desktop
P.H. Northern Powergrid, Microsoft Power BI Desktop
A.R. NOCN Group, Microsoft Power BI Desktop
L.C. NOCN Group, Microsoft Power BI Desktop
Z.B. NHSBSA, Microsoft Power BI Desktop
Z.B. NHSBSA, Microsoft Power BI Desktop
Z.B. NHSBSA, Microsoft Power BI Desktop
S.D. Nexus, Microsoft Power BI Desktop
T.W. Network Rail, Microsoft Power BI Desktop
T.W. Network Rail, Microsoft Power BI Desktop
S.H. Macmillan Cancer Support, Microsoft Power BI Desktop
K.H. LDEUTC, Microsoft Power BI Desktop
J.H. NHSBSA, Microsoft Power BI Desktop
J.H. NHSBSA, Microsoft Power BI Desktop
P.M. NHS North Tyneside CCG, Microsoft Power BI Desktop
L.S. Northumbria Healthcare NHS FT, Microsoft Power BI Desktop
A.R. Durham County Council, Microsoft Power BI Desktop
A.L. Proctor & Gamble Product Supply UK Ltd, Microsoft Power BI Desktop
E.W. northumbria university, Microsoft Power BI Desktop
C.G. Northumbria University, Microsoft Power BI Desktop
N.Y. Broker Network, Microsoft Power BI Desktop
J.I. NHS BSA, Microsoft Power BI Desktop
J.I. NHS BSA, Microsoft Power BI Desktop
C.L. Paragon Customer Communications, Microsoft Power BI Desktop
L.B. NEPO, Microsoft Power BI Desktop
L.F. Durham County Council, Microsoft Power BI Desktop
L.F. Durham County Council, Microsoft Power BI Desktop
K.M. Durham County Council, Microsoft Power BI Desktop
-
Course Options
Please contact us to discuss options for this coursePublic ScheduledPublic ScheduledFixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!BespokeBespokeBespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.PrivatePrivateFlexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.VirtualVirtualThese courses can be attended from anywhere.
- Virtual Training
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/28/2024 7:02:43 AM