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.
Following this training what are you going to do differently "I now want to take on more challenges and improve the documents I produce. "

A.M. PX Group, Word Advanced Features

"All teachings were valuable. I appreciated that I was able to ask questions and use examples specific to my job. "

G.H. Spincraft ETG, Microsoft Project Essentials

"A very good course, thanks. "

S.F. Nissan, VBA Essentials using Excel

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

T.T. Marelli, Excel Level 3

"Very pleased with the course, trainer ensured we all had understanding before moving on "

T. Westrock, VBA Essentials using Excel

Following this training what are you going to do differently "Think about how I engage with my customers and build relationships "

J.A. Cirrus Environmental Soultions Ltd, Customer Care

Which part of the course did you find particularly valuable "The whole course was great, really helpful. Nothing was too much to ask Moira. "

H.S. Department for International Trade, Adobe In Design Level 1

"Its a good overview of the whole programme "

G.V. Direct Rail Services, Microsoft Project Essentials

"I will make some graphics myself rather than searching online and trying to edit those online. It will be much quicker for me just to make the visual I need. "

G.A. Karbon homes, Adobe Illustrator Level 2

Following this training what are you going to do differently "Not refer to internet as much for any Excel problems! For what I require in my work I feel more confident with the knowledge Ive gained after today. Also feel I have more knowledge to help my seniors in other Excel based projects. "

R.Y. GSK, Excel Level 3

Which part of the course did you find particularly valuable "I found the whole course very valuable , i had no previous knowledge of sage and the trainer was very patient and explained the course in great detail "

N.D. Newcastle GP Services, Sage Accounts Level 1

"I do not use PowerPoint often so this has given me a great overview "

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

"I found all of the course valuable as what I learned was all information I didn't know before. "

D.S. , Word Advanced Features

"I can now use Project to generate reports for weekly meetings, presentations etc. More generally confident in my use of Project. "

C.S. Seymour Civil Engineering, Microsoft Project Essentials

Following this training what are you going to do differently "Prepare and plan presentations differently. Have more confidence don't hold myself back. "

L.K. Northumbrian Water, Presentation Skills Advanced

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!