Power BI Courses

Compare courses
    • Overview: Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.

      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.
      View Full Outline
      Public Scheduled Dates:
      Public scheduled prices per delegate. All prices +VAT
      <
      >
      Private Courses:
      Private courses start from £1690 for up to 8 delegates
    • Overview: This course is split into 3 main areas:

      1. Get and Transform (Power Query)
      2. Power Pivot - Data Models and DAX calculations
      3. Dashboard Creation with Pivot Tables, Charts and Slicers

      It is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.
      This course will be delivered on Excel 2016 or above and using generic data files that aim to appeal to a wide audience.
      View Full Outline
      Public Scheduled Dates:
      Public scheduled prices per delegate. All prices +VAT
      <
      >
      Private Courses:
      Private courses start from £745 for up to 8 delegates
    • Overview: This course is available on a private course basis only.
      We run the Microsoft Power BI Desktop course as a public scheduled event and also as a private course.

      This 4-day course is intended for anyone who is new to designing and implementing self-service Business Intelligence (BI) solutions using Microsoft Power BI Desktop and the Power BI Service. It is ideal for anyone who needs a total immersion in the subject matter as the course structure is very comprehensive. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience. Due to the very comprehensive nature of this course, the content delivered may vary depending on new and updated features, delegate requirements, and course objectives.

      This course is also commensurate with the “PL-300 Microsoft Power BI Data Analyst” course and serves as ideal preparation for the Microsoft PL-300 exam. In addition to providing the knowledge required for this exam, this course takes a broader and more practical approach to Power BI, demonstrating useful techniques that will prove extremely helpful in the workplace.

      The first part of the course introduces the capabilities and components of Power BI Desktop before delving into the realms of discovering and loading data from a variety of sources. Primarily focussed on using Power Query to create queries for implementation in data models, students will learn how to shape and transform loaded data, mashup data from various sources by merging and appending data, and manage, structure, and parameterise queries. Delving behind the scenes, students will also be introduced to the M language, highlighting ways in which existing code can be tweaked and how user defined code and functions can be implemented.

      Part two of the course introduces students to tabular data modelling concepts, preparing the data in readiness for use in reports and dashboards. The importance of implementing relationships is also covered. In order to enhance the data model, students will be introduced to the DAX expression language to enable them to implement calculated columns, measures, and tables. Consideration is also given to implementing time intelligence in the design of data models.

      In part three, you will learn how to create and design reports and implement visualisations. We will first look at text-based visuals before moving on to graphical components like charts, gauges and KPIs (Key Performance Indicators). The implementation of maps in reports is also given coverage. To create interactivity in reports, students will also learn how to implement various types of filters and slicers.

      Finally, in part four, we turn our attention to the Power BI Web Service. Attendees will learn how to publish reports to the Power BI Service and how to organize and secure content. The creation and use of dashboards will be considered, and the sharing of content will also be given coverage. We will look at user accessibility issues and consider how users, including mobile users, can interact with report content. Managing and refreshing datasets in the Power BI Service is also included.

      Additionally, with the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.

      View Full Outline
      Private Courses:
      Private courses start from £3980 for up to 8 delegates
    • Overview: Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.

      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.
      View Full Outline
      Private Courses:
      Private courses start from £845 for up to 8 delegates
Ask us a question:
I would like IT Training solutions Ltd to keep me informed with offers and news it believes would interest me*
By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Ask A Question
    I would like IT Training solutions Ltd to keep me informed with offers and news it believes would interest me*
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
"I always find training on Teams quite difficult, but I really enjoyed this one and felt that I gained a lot from it. "

S. HMP Isle of Wight, Minute Taking

"Thank you very much very helpful training. Great environment and lovely lunch. "

S. DTV CRC, Microsoft Project Essentials

"All of it is going to be really useful. "

L.O. Labour Party, Excel Level 2

Following this training what are you going to do differently "Create more accurate project plans. "

M.C. Taylormade Timber, Microsoft Project Essentials

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

Any other comments or recommendations "Great course, great environment. "

B.K. Renolit Cramlington Ltd, Interviewing Skills

Which part of the course did you find particularly valuable "Isolating my key tasks and how to field some of the distractions. "

V.W. North East Business Innovation Centre, Time Management

"Enjoyable and very useful day course, Excel confidence has improved markedly already! "

P.T. South Tyneside Council, Excel Level 2

What were the most useful aspects of the course "Personal adaption of course content to make it relevant to your situation "

J.M. Welwyn Components Ltd, Conflict Management

Following this training what are you going to do differently "Use shortcuts more effectively "

W.O. S Sheard Son Limited, Excel Level 3

"I felt it was the right level and right information "

E.H. , Word Essentials

Following this training what are you going to do differently "Use many tips and tricks, use IF more, use function library within Excel. "

S.B. Education Development Trust, Excel Level 2

"All aspects of the training were valuable "

D.T. Watmos, Outlook Overview and MS Teams for Hosts

"Great facilities and trainer "

C. The Auckland Castle Trust, Photoshop Level 1

Following this training what are you going to do differently "Enhance current Visio charts and use multiple pages "

S.P. Direct Rail Services, Visio Essentials

Virtual Training: What is it? Watch the video:
Welcome to IT Training Solutions!Expert trainers, courses delivered online or in person, small class sizes, flexible content, course materials included and available via your personal training account or in printed form.