MS Office Excel Training - Power View (Power BI) 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.
750.-/d
ID : 1077
Goal : Take a look at the Power View add-in, which allows you to publish dynamic, interactive, and real-time updated dashboards on the SharePoint Intranet or Office 365. The various tabular, matrix, charts, columns, lines, pie charts and geographic charts will be studied in detail and their known limitations will be communicated by the trainer. This training also prepares the attendee for the Power BI Desktop training.
Audience : Anyone who already has the mastery of standard Excel charts and wishing to discover what Power View can possibly bring more compared to the traditional tools.
Prerequisites : Have followed the PowerPivot and the Charts training or have equivalent knowledge.
Goals :
- Introduction
- Recommended technical configuration
- Enabling the Power View Add-in and accessing the Power View button
- Creating a PowerView worksheet (inability to copy)
- Title of the dashboard
- Reminders about PowerPivot field descriptions
- Creating tables
- Creating matrices
- Creating maps
- Using hierarchies
- Types of Subtotals and Totals Options
- Formatting numbers
- Use of filters, advanced filters and mosaics
- Structural options for Bar, Lines, Dots/Bubbles and Sectors charts
- Define the grid
- Filters and Slicers
- Label, Axis, and Sync options
- Creation of geostatistics
- Compilation in a dashboard
- Publishing in SharePoint / Office 365
- ...
Pedagogical method : This training is based on exercises mainly imposed by the trainer or on the client files if the data and requests have already been sent at least two days before the training.
Suggested duration for presentiel training (days) : 1
Suggested duration for on-line training (days) : 1.2
Daily price in face-to-face : 750 CHF
Daily price in remote : 360 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 3750 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 : ms excel power view, ms excel power view training, ms excel power viwe course, power view, powerpivot, power bi, pivot tables, dynamic charts, dashboards, geostatistics, business intelligence.