Business Data Analysys

Picture
Reduce time to develop reports and performance analysis by 50% with new methods and techniques.
Excel is currently the most popular data analysis tool used by management and executives in business.  
The two day Business Data Analysis workshop teaches managers how to easily visualize and analyze data in Excel 2007 / 10.

The two day workshop focuses on the following:
  • Learn to use PivotTables to aggregate and compare data
  • Learn other types of Analysis
  • Learn to format and manage PivotTables
  • Easily Rank data and perform Top 10 analysis
  • Quickly create great management reports
  • Understand trends over Time 
  • Calculate Percentage Contributions
  • Learn to Graph and Visualize PivotTable data
  • Use Conditional Formatting with PivotTables
  • Create basic Dashboards

Tableau

Picture
Workshop Outcomes:
  • Create interactive Dashboards
  • Measure Performance against Target  and Budget
  • Perform Quick Analysis
  • Create Quick Filters      
  • Interactive Scatterplot
  • Powerful What If Analysis
  • Distribute and Share

PowerPivot

Picture
Microsoft PowerPivot is a free add-in for Excel 2010 that will revolutionize the ability of business to access and analyze large quantities of data.  PowerPivot allows users to analyze millions of rows of data and to create easy to setup relationships between data.

This one day workshop focuses on the following:
• Introduction to PowerPivot
• Importing Data into PowerPivot
• Creating and Managing Relationships
• Creating PivotTables
• Creating DAX Measurements
• Creating PivotCharts