Content snippet of workshop: review of statistics module and reporting tools

Workshop to be held prior to user meeting, June 5th 08:30 – 11:30.

Power Pivot
– Difference between PowerPivot and Pivot tables
– How to import data into PowerPivot
– Handle relations in data models
– Build PowerPivot tables based on several data sources
– PowerPivot formatting – impressive reports
– Use of slicers

PowerView
– Introduction to PowerView
– System requirements
– Organize and load of datasets
– How to use difference sources
– Handle relations
– Sorting and filtering
– Working with prebuilt themes
– Different formatting and views
– Work with tables, views, diagrams and Maps
– Layout and design
– Combining PowerPivot with PowerView

PowerMap
– How to prepare data for map visualization
– Prepare of aggregated data
– «GEO coding»
– Layout and effects
– Bubble and cake diagrams