Microsoft Office 365 Training - Business Intelligence in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.
425.-/d
ID : 1124
Goal : Learn how to build and know the limits (relative to Microsoft Visio, Microsoft Performance Server, Microsoft SQL Server Analysis Services) of performance indicators (KPIs) and dashboards of Office 365 by using libraries / lists and Microsoft Excel tables (via Excel Services) and using Power BI tools (PowerPivot, PowerQuery, PowerView, PowerMap, Power BI Desktop).
Audience : This course is intended for both users and Office 365 owners (not recommended for developers and administrators) who whish to implement metrics in their organization.
Prerequisites : Have good experience in the overall use of Office 365 and MS Excel and Visio elements and have completed PowerPivot / PowerView / Power BI Desktop trainings or equivalent knowledge.
Goals :
- Introduction
- Basic theoretical concepts of the Business Intelligence
- Key Performance Indicators (KPI)
- Dashboards
- Balanced scorecard
- Network or Industriels schemes
- Presentation and limitations of Office 365 in BI
- Excel BI vs Visio BI vs Performance Point BI vs Power BI
- Create KPI lists
- Creating manual KPIs coming from SharePoint libraries, MS Excel or SSAS
- Definition of conditional indicators in MS Excel and release of a range of cells with Excel Server
- Creating a SharePoint Report Center site
- Integrating Excel Services and Power BI Web Parts
- Adding KPIs or Detailed KPIs Web Parts
- Use Excel Chart Web Part
- Using the Dashboard Filtering Web Part
- Creating ODC connections
- Using PowerPivot / PowerView and Power BI reports
- Dynamic cross-analysis with Microsoft Visio
- Publishing Visio Services dashboards
- ...
Pedagogical method : Cours démonstratif avec de petits exemples à pratique en groupe.
Suggested duration for presentiel training (days) : 1
Suggested duration for on-line training (days) : 1.2
Daily price in face-to-face : 425 CHF
Daily price in remote : 204 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 2125 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).
Tags : office 365 training, office 365 course, windows sharepoint services, business intelligence, excel server, excel services, dashboards, kpis, key performance indicators, business scorecards.