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
-
Latest Reviews43"Brilliant course"
A. Kookaburra, Microsoft Power BI Desktop
"great course and content great trainer"D.J. Public course, Microsoft Power BI Desktop
"excellent clear training"G.T. Public course, Microsoft Power BI Desktop
"Covered at an appropriate pace to accommodate all learners in the group"G.T. Public course, Microsoft Power BI Desktop
"An excellent course and [the trainer] was very help and patient when addressing group questions."G.T. Public course, Microsoft Power BI Desktop
"Great facilities and really helpful trainer"V.P. MGL, Microsoft Power BI Desktop
Which part of the course did you find particularly valuable? "How it was very interactive, using the software rather than just watching the trainer is much more useful"H.S. Durham County Council, Microsoft Power BI Desktop
"I will be putting the new skills I have learned into practice immediately "H.S. Durham County Council, Microsoft Power BI Desktop
"Absolutely loved this course, I've been working with PowerBI for a couple of months, so great to have a better understanding of the power of the app and all it has to offer."A.F. PX Limited, Microsoft Power BI Desktop
"Not used Power BI before but now have ideas on where we can use it, so will start implementing."R.W. PX Limited, Microsoft Power BI Desktop
"It's improved my overall perception of Power BI, and has given me a good foundation to explore further, as well as hopefully help others."C.B. PX Limited, Microsoft Power BI Desktop
"Understanding how the data feeds into PowerBI was most useful."R.B. NOCN, Microsoft Power BI Desktop
"Brilliant session, great trainer."S.H. NOCN, Microsoft Power BI Desktop
Following this training what are you going to do differently? "Be more confident to build my own reports making me more self-sufficient. Be more strategic in my methods."L.B. NOCN, Microsoft Power BI Desktop
"All aspects of the course were very valuable."G.S. Northern Power Grid, Microsoft Power BI Desktop
"Following this course, the reports that we will create will be more robust and interactive"G.S. Northern Power Grid, Microsoft Power BI Desktop
"I now understand how to use PowerBi and feel confident that I will be able to create my reports through this system"P.H. Northern Powergrid, Microsoft Power BI Desktop
"The course was fabulous"A.R. NOCN Group, Microsoft Power BI Desktop
"[The trainer] covered the basics of using Power BI in a really accessible manner which was easy to understand."L.C. NOCN Group, Microsoft Power BI Desktop
"As someone who had never used power BI previously this was an interesting introduction and an impressive tool that will produce good quality and informative management information."Z.B. NHSBSA, Microsoft Power BI Desktop
"This will help in our reporting so firstly I am going to have a practice with our own data sets and have no doubt we will use Power BI regularly as the reporting is much more impressive and I am sure the visuals will be very well received by budget managers."Z.B. NHSBSA, Microsoft Power BI Desktop
"I very much enjoyed the training and hope I can now put it into practice."Z.B. NHSBSA, Microsoft Power BI Desktop
"Very happy with the whole thing"S.D. Nexus, Microsoft Power BI Desktop
"I was a beginner at course start and found it to be an excellent introduction to all aspects of the program."T.W. Network Rail, Microsoft Power BI Desktop
Following this training what are you going to do differently? "Will be leading the effort to replace a large number of reports currently done in Excel with Power BI variants to better present the data, and make reproduction far faster."T.W. Network Rail, Microsoft Power BI Desktop
"Il was a good pace and well explained"S.H. Macmillan Cancer Support, Microsoft Power BI Desktop
"One of the best courses I have ever attended. The pace was good and their were not any questions that the trainer could not answer."K.H. LDEUTC, Microsoft Power BI Desktop
Which part of the course did you find particularly valuable? "As a new user to Power BI I found the whole course really valuable but Stuart's explaining of the 7 steps to setting up a report was especially valuable."J.H. NHSBSA, Microsoft Power BI Desktop
Any other comments or recommendations? "Being able to do this course remotely was a huge advantage"J.H. NHSBSA, Microsoft Power BI Desktop
"For me, this was one of the best training courses I have attended, in my whole career. It was pitched at exactly the right level and covered all of the things I need to know to get me up and running with Power BI. The trainer was excellent. I'll be recommending this course to other BI colleagues."P.M. NHS North Tyneside CCG, Microsoft Power BI Desktop
"The whole course was extremely useful and applicable to my role."L.S. Northumbria Healthcare NHS FT, Microsoft Power BI Desktop
Following this training what are you going to do differently? "Now feel confident to try out DAX in calculations and to make alterations to layouts, etc."A.R. Durham County Council, Microsoft Power BI Desktop
Following this training what are you going to do differently? "I will share my reports more widely "A.L. Proctor & Gamble Product Supply UK Ltd, Microsoft Power BI Desktop
Which part of the course did you find particularly valuable? "All of it - the data part was particularly valuable in understanding how the data is structured and related. The visuals and presentation part was really useful in understanding how to share. Also was really useful to be able to look at our own data."E.W. northumbria university, Microsoft Power BI Desktop
"Looking forward to putting what I've learnt into practice!"C.G. Northumbria University, Microsoft Power BI Desktop
Which part of the course did you find particularly valuable? "Being able to extract multiple bits of data from multiple data sources in such little time "N.Y. Broker Network, Microsoft Power BI Desktop
Which part of the course did you find particularly valuable? "I found the information on bookmarks and page navigation to be particularly helpful. I had previously used Power BI however as I was self taught I had never explored this before. I also found the terminology to be very useful, for example 'Content Pack' - it is important to work to the true standards after all."J.I. NHS BSA, Microsoft Power BI Desktop
Following this training what are you going to do differently? "I am going to be incorporating the standards I have learned and produce more comprehensive content packs."J.I. NHS BSA, Microsoft Power BI Desktop
Following this training what are you going to do differently? "Perform the majority of data manipulation within Power BI rather than within the data source itself."C.L. Paragon Customer Communications, Microsoft Power BI Desktop
Which part of the course did you find particularly valuable? "DAX language, manipulating the data, creating visuals, how to export data into PowerPoint"L.B. NEPO, Microsoft Power BI Desktop
"[The trainer] was very patient, and very helpful"L.F. Durham County Council, Microsoft Power BI Desktop
"Would recommend to others in performance reporting posts"L.F. Durham County Council, Microsoft Power BI Desktop
"Really enjoyed the training and found it useful."K.M. Durham County Council, Microsoft Power BI Desktop
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:3/28/2024 4:35:40 PM