text.skipToContent text.skipToNavigation

Business Intelligence with Excel


Building Business Intelligence Solutions with Excel 2010

Introduction

In this 2 day training, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by applying advanced analysis techniques to more complex data sets. Students will leave the course with a good understanding of how to create Excel reports, within a business context and a good understanding of how to create Excel Dashboards.

In this 2 day training, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by applying advanced analysis techniques to more complex data sets. Students will leave the course with a good understanding of how to create Excel reports, within a business context and a good understanding of how to create Excel Dashboards.
In this 2 day training, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by applying advanced analysis techniques to more complex data sets. Students will leave the course with a good understanding of how to create Excel reports, within a business context and a good understanding of how to create Excel Dashboards.
Choose variant
Duration: 2 days

  • Defining Business Intelligence, Business Intelligence Solution Users, Common Business Intelligence Terminologies, Traditional & Contemporary Business Intelligence Solutions, Microsoft Business Intelligence Vision - Performance Management, Data Warehousing, Reporting and Analysis.
  • Excel Formulas and Functions: Formulas & Functions Basics, Essential Functions, Lookup & Reference Functions, Text Functions, Date & Time Functions, Arrays & Database Functions, Excel Efficiency Tools.
  • Summarizing Excel 2010 Data to Make Better Business Intelligence Decisions: Deriving Business Intelligence from Excel Data, Summarizing Data Using Lists, Creating a PivotTable, Fine-Tuning PivotTables. <
  • Analyzing Excel Databases & Maximizing PivotTables/PivotCharts: Create an Excel Database, Modifying a Database, Using Data Validation, Using Data Forms, Sorting and Filtering Records, Working With Advanced Filters, Summarizing Data Within a List, Exporting And Importing Data, PivotTables. Make Your Data Work for You, A Quick Tour, Manipulating The PivotTable, Digging Deeper, Beyond The Basics, More PivotTable Calculations, Optional Topics.
  • Accessing SSAS cubes with Pivot Tables and OLAP formulas. Slice and dice with Pivot Tables and AutoFilter
  • Building Excel Dashboards: Using Excel Array functions for Dashboards, use of Sparklines and Bullet Charts in Dashboards
  • Forecasting and Trend Analysis Using Excel 2010: Introduction to accessing SQL Server 2008 Databases, Analysis Services cubes and Data Mining in Excel. The Risks and Benefits of Forecasting Data, Creating Formula-Based Forecasts, Forecasting by Using Moving Averages, Maximizing Profit Potential.
  • PowerPivot Excel 2010 Introduction and preview
  • Use Excel to Data to make better Business Intelligence Decisions
  • Analyse Excel Databases & maximize value of  PivotTables/PivotCharts
  • Accessing SSAS cubes with Pivot Tables and OLAP formulas

 None.

If you want to further increase your skill and knowledge, the following additional courses are recommended

  • Data Visualisation