Microsoft Business Intelligence Training Courses and Resources

Wise Owl train in all the main Microsoft Business Intelligence applications (collectively sometimes called the BI Stack), including Reporting Services, Analysis Services and Intelligence Services, as well as in the Excel Power BI Tools and Power BI Desktop.

Business Intelligence classroom training

Business Intelligence classroom training

We train in most Business Intelligence tools in the MS BI Stack, as the list below shows:

Can't see the course you want? Have a look at our onsite Business Intelligence training page.

Not sure which course you want? See what you can learn on one of our Business Intelligence courses.

Other Business Intelligence training resources

Business Intelligence blogs

Blogs on Business Intelligence

As well as publishing courses and exercises, we've written a host of blogs about aspects of Microsoft's business intelligence software applications (collectively sometimes called the BI Stack):

Business Intelligence videos

Videos on Business Intelligence

You can learn about the Microsoft BI stack from our BI training videos:

Business Intelligence training venues

Business Intelligence training venues

The main locations in which we train on MS BI applications are as follows:

Which is the right Business Intelligence course for you?

We reckon that you work in Business Intelligence or BI if your job involves interpreting large amounts of data to make business decisions.  Below is a summary of the BI courses that we offer. 

You can also create business intelligence tools using Excel or Access, of course, or even by programming in SQL, C#, VB or VBA.  Business intelligence is at the heart of virtually every training course that we run!

SQL Server BI Tools

The Microsoft BI world includes the following software applications for SQL Server:

Software Notes
Integration Services This allows you to extract data from a number of different formats, transform it and then load it into its final resting place (such as a data warehouse).  We currently run a two-day SSIS Introduction course, and also list a two-day advanced SSIS course.
Analysis Services This comes in two flavours: multi-dimensional model SSAS allows you to build cubes, and tabular model SSAS is the more modern variant.  If you're not sure which to use, read this blog on the differences between them.
Reporting Services This allows you to create reports and publish them to your corporate Intranet or to the wider Internet.  We currently run a two-day Introduction to SSRS course and also a two-day advanced SSRS training course, as well as a course on the simplified version of SSRS is that Report Builder.

Other BI Tools

You can also create BI applications using PowerPivot within Excel or the Power BI tools:

Software Notes
Excel Power BI Tools The main Excel Power BI tools are PowerPivot (which allows you to import data from a number of different data sources, and combine the resulting tables to create a data model and hence a pivot table), and Power Query (which is like a mini SSIS, allowing you to extract, transform and load data within Excel).  Our two-day Excel Power BI course covers these, as well as giving an overview of Power BI Desktop.
Power BI Desktop The standalone Power BI Desktop package allows you to create beautiful dashboards by importing data from a variety of data sources and then visualising it on screen.  Our two day Power BI Desktop course also covers Power BI web services, while our two-day advanced Power BI Desktop course covers more advanced reporting features.

We also run a two-day course on DAX, the formula language used by PowerPivot and Power BI Desktop (and by Analysis Services Tabular Model too, as it happens).

If you're not sure which of the above courses to choose - PowerPivot or Power BI Desktop - read our blog on the differences between the two products.

If you're still not sure which is the right course for you, give us a ring or send us a quick enquiry!

10 things our Business Intelligence courses include

Each of our scheduled courses includes:

  1. Small course sizes - we have a maximum of 6 people on each course, and frequently run courses with fewer.
  2. A computer for each delegate (obviously).
  3. A trainer! And not just anyone - Wise Owl courses are only ever given by Wise Owls.
  4. Full colour courseware of oustanding quality .
  5. Interesting exercises to reinforce what you've learnt (you can review some of the Business Intelligence exercises we use here).
  6. Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
  7. Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.
  8. A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too.
  9. A Sheaffer biro and notepad.
  10. Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).

Have a look at our full list of benefits, or read hundreds of testimonials to the quality of our training.

About our Business Intelligence training

Whichever Business Intelligence course you choose to attend, we'll try to make it as interesting as possible.  In particular, you'll work with datasets which are as simple as they can be, while still allowing us to demonstrate the topics needing covering:

Courses Data used
SSRS, Report Builder Our database of 1,200 movies
Power BI Desktop, PowerPivot, SSAS Our Make-a-Mammal database
Integration Services A variety of different data sources

Whichever course you attend, we'll try to show you how you can analyse data (big or small) and present it in a meaningful and interesting way!

This page has 0 threads Add post