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
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
Blogs on Business Intelligence
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:
|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:
|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:
- Small course sizes - we have a maximum of 6 people on each course, and frequently run courses with fewer.
- A computer for each delegate (obviously).
- A trainer! And not just anyone - Wise Owl courses are only ever given by Wise Owls.
- Full colour courseware of oustanding quality .
- Interesting exercises to reinforce what you've learnt (you can review some of the Business Intelligence exercises we use here).
- Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
- 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.
- A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too.
- A Sheaffer biro and notepad.
- 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).
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:
|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!