"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"
Brian Leek, Data Analyst, May 2022
This course is aimed at data developers and those who need to load, import, transform, build and maintain data models, as well as build interactive reports which empower businesses and colleagues to harness the growing amount of data being produced by the business systems and Internet of Things (IoT). Some basic SQL skills would be an advantage.
"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"
Brian Leek, Data Analyst, May 2022
“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”
Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022
Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...
All 20 points are in our latest Newsletter - Delivered directly to your inbox
Our Microsoft Business Intelligence (BI) 2016 training course is built around data modelling with SQL Server Reporting Services (SSRS) and cloud/desktop Power BI. We also cover data warehousing and cube design with SQL Server Analysis Services (SSAS).
The Business Intelligence course covers the discovery and preparation of data, the modelling of the data, and the presentation of the data in insightful and attractive reports and dashboards.
We initially look at SSRS and visualisation tools such as Power BI, and when you return to your office you will easily be able to create powerful and informative reports and dashboards.
The latter part of the course is spent on data warehousing and cube design, using the modelling tools within SSAS and with a little help from Integration Services (SSIS).
Both SSAS multidimensional and tabular models are covered, which are the powerhouses that drive your reports and dashboards.
CONTACT
+44 (0)20 8446 7555
Corporate Policies Terms & Conditions
JB International Training Ltd - Company number 08458005
Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS
