Courses > IT > Vendors > Microsoft > Power BI

Power BI Courses

Compare courses
    • Microsoft Power BI Desktop
      Duration: 2 Days
      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
    • Excel Business Intelligence using Excel Power Tools
      Duration: 1 Day
      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
    • Microsoft Power BI Complete
      Duration: 4 Days
      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
    • Microsoft Power BI Getting Started
      Duration: 1 Day
      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.
What were the most useful aspects of the course "To see that we all had the same issues as no formal training had been done before. These issues can with the help of the course now be sorted. "

H.D. Her Majestys Prison and Probation Service, Minute Taking

Which part of the course did you find particularly valuable "All were a good foundation to work from and give me the building blocks to do better "

P.B. Parkdean Resorts, Project Management Essentials

"The overall course was a great reminder about certain features. I particularly found data validation and conditional formatting very useful. "

A.G. Home Office, Excel Level 2

"Great course thank you! "

H.T. HKA, Excel Level 3

"Very helpful "

S.W. Community Foundation, Word intermediate

Which part of the course did you find particularly valuable "I felt there was good networking via the facilitator and group along with many hints and tips "

S.M. Health Education England, Minute Taking

"Great location very accessible "

I.M. , Redefining PowerPoint Design Create Present with Impact

"Great course and the trainer was happy to answer questions and show examples to support learning "

P.B. Community Foundation, Word intermediate

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 "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

"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

"Very helpful trainer who was always willing to answer any questions. "

J.C. NHS, Word Essentials

Which part of the course did you find particularly valuable "Working on the pivot table slicers and recording Macros. "

E.D. Tharsus, Excel Level 3

"I enjoyed everything as it was very helpful and informative "

H.M. , Excel Level 1 Essentials

Following this training what are you going to do differently "Use my calendar alot more for work and personal use. "

J.L. LHP, Outlook 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.
Join The Team!