Course Outline
This informal technical workshop has been written to take delegates beyond the basics of BI, and also for those who have used earlier versions, a first look at some features available within 2012. A flexible and less rigid approach will be taken with this workshop, which aims to give delegates an opportunity to explore options, discuss best practice and make the most of BI.
The course is also available as a closed session, focusing on your own data and business needs.
Course Content
This hands-on more advanced Business Intelligence with SSAS and SSIS training course has been developed with real-world, commercial scenarios in mind by our expert instructors. See below for detailed syllabus. If you have a technical question, please email sales@jbinternational.co.uk
Available as a public or closed course at our London training centre, delivered on-site as a bespoke, customised training course.
Personal BI
PowerPivot for Excel
DAX formulas
Shared BI
PowerPivot for SharePoint
PowerView and PowerPoint
PowerView reports on PowerPivot for SharePoint
PowerView reports on SSAS Tabular cubes
PerformancePoint – dashboards, scorecards, KPIs, drill-down charts, and decomposition trees
Enterprise BI
SSAS Multidimensional databases - cubes
Overview of design in SSDT/BIDS
MDX queries on multidimensional cubes
SSAS Tabular databases - cubes
Designing tabular in SSDT
DAX and MDX queries on tabular cubes
Data Mining
SSAS Multidimensional databases – data mining
Data mining from Excel and SSDT – examples of a few of the available algorithms
DMX queries - content queries, cases queries, prediction queries
SSRS
SSRS reports on multidimensional cubes, tabular cubes, and PowerPivot
Using SSRS reports in SharePoint, PerformancePoint, and PowerPivot
Review of BI strategies
MDX or DAX?
Multidimensional or Tabular?
