Duration of Training : 6 Weekends

Training includes : 20+ assignments, 3 POCs

and 1 Real time Project

SYLLABUS

Week-1 (Introduction)

• User interface basics
• Connecting to data
• Dimensions vs. measures
• Show Me
• Marks card
• Simple formatting
• Building views
• Building a dashboard

Week-2 (Connecting to Excel, CSV and Text Files)

• Connecting to single or multiple tables
• Connecting live versus importing the data
• Editing data connections after initial connection
• Data source filtering

Week-3 (Working with Data)

• Flat Files (Excel, CSV, Access DB)
• Cube and Relational Databases
• ODBC Drivers
• Live or Import Data Connection
• Metadata Management
• Multiple Data Connections
• Creating and Refreshing an Extract

Week-4 (Analysis)

• Hierarchies
• Sorting
• Grouping
• Filtering
• Aggregations
• Trend lines
• Page shelf
• Forecasting

Week-5 (Formatting & Calculations)

• Row-banding
• Number formatting
• Text formatting
• Shading
• Labels
• Annotations
• Tooltips
• Aggregate Calculations
• Row-Level Calculations
• Quick Table Calculations

Week-6 (Dashboard)

• Dashboard Objects
• Filter Actions
• URL Actions
• Sizing
• Tiled and Floating Sheets
• Dynamic Sheet Titles