Applied Excel and Analysis Services

Applied Excel and Analysis Services

If your organization have Analysis Services Multidimensional cubes or Tabular models and you want to gain valuable insights from them in Excel, then this course is for you. Designed as a step-by-step tour, this course teaches business users how to become data analysts and unlock the hidden power of data. You’ll learn how to apply the Excel desktop BI capabilities to create versatile reports and dashboards for historical and trend analysis. You’ll learn also how to share your BI artifacts across the organization by publishing them to SharePoint.

Audience

  • Business users
  • Power users
  • Data analysts
  • In general, anyone interested in using Excel for BI

Prerequisites

  • Experience navigating the Microsoft Windows environment
  • Experience with Microsoft Excel is preferable

Hardware and software requirements

  • Windows XP with SP3, Windows Vista with SP1 or Windows 7
  • Minimum of 1GB RAM (2GB recommended)
  • Microsoft Excel 2010 32-bit or 64-bit
  • SQL Server 2008 or above (with Database Engine and SSAS intalled)