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.
"Fantastic, well recommended "

A.L. GSK, Excel Level 2

"Things I was doing on Excel that would take up hours of my day now only take 10 minutes. "

S.B. THARSUS VISION LTD, Excel Level 2

"Great location very accessible "

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

Which part of the course did you find particularly valuable "The ability to have questions answered during the course. Cost allocation process very useful as most people don't know this is possible "

A.F. DeepOcean 1 UK Ltd, Microsoft Project Essentials

"A lot of detail to take on board but interesting nonetheless. "

A.P. James Jones and Sons Ltd, Excel Level 2

"Insert art design, insert picture window, cover page, table layout. Copy paste option reset picture transparency. Background removal. Design water mark page. "

A.A. Merton, Word Essentials

Following this training what are you going to do differently "I have not used Sage before, so this has given be a good insight of what it's about. I will be able to start using it feeling a bit more confident. "

E.M. Newcastle GP Services, Sage Accounts Level 1

"Excellent delivery. Very motivating. "

T.B. Van Leeuwen, Negotiating and Influencing Skills

Are there any aspects of the course which you feel require improvement "No, excellent pace and plenty of hands on experience "

J.H. Breedon Northern Ltd, Crystal Reports Level 1

"Brilliant session, great trainer. "

S.H. NOCN, Microsoft Power BI Desktop

Which part of the course did you find particularly valuable "All of it "

A.W. WATMOS, Microsoft Forms SharePoint and Power Automate Essentials

"The whole course was a good refresher of previous skills "

T.T. Marelli, Excel Level 3

Which part of the course did you find particularly valuable "Chat, upload and share documents "

D.A. Engie Services Ltd, Microsoft Teams in Office 365 Essentials

Please select the words that best describe your learning experience "for someone who hasn't used computers much this was a great help "

G.H. universal wolf, Excel Level 1 Essentials

"I am going to implement these skills as fast as possible after the course. "

C.R. Tharsus, Excel Level 2

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!