Microsoft Business Intelligence Training Courses
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.
Business Intelligence classroom training
We train in most Business Intelligence tools in the MS BI Stack, as the list below shows:
Not sure which course you want? See what you can learn on one of our Business Intelligence courses.
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||The standalone Power BI 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 course also covers Power BI web services, while our two-day advanced Power BI course covers more advanced reporting features.|
We also run a two-day course on DAX, the formula language used by PowerPivot and Power BI (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 - 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 delegates.
- A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls (our average feedback scores are in the range 9.2 to 9.8 out of 10).
- Full colour courseware and exercises of oustanding quality .
- A no cancellation guarantee (once you've booked/confirmed training, it will run).
- A computer for each delegate (obviously).
- 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, together with a Sheaffer biro.
- 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).
- A certificate sent out digitally or in paper form (your choice) after each course, together with (for online courses) the trainer's thoughts on how the course went.
Scheduled Business Intelligence training dates
Here are the Business Intelligence courses we have scheduled for the next 3 months:
|Introduction to SSIS||Tue/Wed 18-19 December 2018||2||London||£850||Book places|
|PowerPivot / Excel Power BI||Mon/Tue 07-08 January 2019||2||Manchester||£695||Book places|
|Reporting Services||Thu/Fri 10-11 January 2019||2||London||£850||Book places|
|Reporting Services||Thu/Fri 17-18 January 2019||2||Manchester||£695||Fully booked|
|Reporting Services||Thu/Fri 17-18 January 2019||2||Manchester||£695||Book places|
|PowerPivot / Excel Power BI||Thu/Fri 17-18 January 2019||2||London||£850||Book places|
|Introduction to SSIS||Tue/Wed 29-30 January 2019||2||Manchester||£695||Book places|
|SSAS - Tabular Model||Tue/Wed 05-06 February 2019||2||Manchester||£695||Book places|
|Introduction to Power BI||Tue/Wed 05-06 February 2019||2||London||£795||Book places|
|Introduction to SSIS||Tue/Wed 12-13 February 2019||2||London||£850||Book places|
|Introduction to Power BI||Tue/Wed 12-13 February 2019||2||Manchester||£695||Book places|
|PowerPivot / Excel Power BI||Tue/Wed 19-20 February 2019||2||Manchester||£695||Book places|
|SSAS - Tabular Model||Thu/Fri 21-22 February 2019||2||London||£795||Book places|
|SSAS - Multidimensional||Mon/Tue 25-26 February 2019||2||Manchester||£695||Book places|
|Reporting Services||Thu/Fri 28th Feb/1st March 2019||2||London||£850||Book places|
|Introduction to Power BI||Tue/Wed 05-06 March 2019||2||Manchester||£695||Book places|
|Reporting Services||Thu/Fri 07-08 March 2019||2||Manchester||£695||Book places|
|Introduction to SSIS||18/12||London|
|PowerPivot / Excel Power BI||07/01||Manchester|
|PowerPivot / Excel Power BI||17/01||London|
|Introduction to SSIS||29/01||Manchester|
|SSAS - Tabular Model||05/02||Manchester|
|Introduction to Power BI||05/02||London|
|Introduction to SSIS||12/02||London|
|Introduction to Power BI||12/02||Manchester|
|PowerPivot / Excel Power BI||19/02||Manchester|
|SSAS - Tabular Model||21/02||London|
|SSAS - Multidimensional||25/02||Manchester|
|Introduction to Power BI||05/03||Manchester|
All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite Business Intelligence training at your offices (we'll even provide the computers and projector).
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, 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!