Course Objectives

Learn how you can easily search, access, and analyze very large data sets inside and outside of your organization in just a few clicks with business intelligence features that lie inside Microsoft® Office®. This training walks you through the self-service BI tools that only require Excel.

You will learn how to query external data sources using tools that are available in Microsoft® Office® Excel 2013. With this training Excel will appear like totally different application software from the one you have been used all through powerful insights that you never were possible in Excel.

You'll learn to connect to your local SQL Database as well as remote data sources and model that data, and present your findings in the form of interactive tables, charts, maps, dashboard and reports.

This training does not require new software but it enhances the application of Excel and allow you to use the software you already know and love to analyze and share complex business data.

Who should Attend Includes?

  • Business& Financial Analysts
  • HR professionals
  • Financial Controllers and Accountants
  • MBA’s and Business Undergraduates
  • IT Professionals

Course Coverage           

  • Leveraging Excel for Business Intelligence

This section gets you started with Self-Service BI for Excel 2013. It explores the tools you need for successful Excel analytics to leverage your organization’s competitive advantage and improve the quality of decision making information. This section also covers the installation of the various power tools including enabling Component Object Model (COM) add-ins for Excel BI.

  • Using Excel to get Data

In this section you will learn how to search for online data using Excel’s BI tools and explore the commercial and free data sources available. It then looks how to shape the large data sets for analysis including how to appending and merge data sets, dealing with duplicates and how to troubleshoot large dataset. This section also covers how to connect to an SQL database

  • Modeling Your Data with Power Pivot

In this section, we show you how to connect to an SQL database and build an Excel Analysis Data Model. We also show you how to create relationships between tables from different data sources into one Power Pivot Data Model. This means you can theoretically create a Power Pivot Data Model that contains some data from an SQL Server table, some data from online database, and even data from a one-off text file or SharePoint.

  • Enhancing PivotTables with Power Pivot

As you gain an understanding of Microsoft® BI tools, it becomes clear that PivotTables are an integral part of delivering business intelligence to your audience. This section shows you the advanced techniques in working with PivotTables including creating standard and timeline slicers and how to control multiple PivotTables with one slicer for Dashboards.

  • Expanding the Data Model in Power Pivot

DAX (Data Analysis Expression) is the formula language Power Pivot uses to perform calculations within its own construct of tables and columns. In this section, we touch on some of the DAX functions that can be leveraged in calculated columns and in adding a related column. The section then looks at building a hierarchy and how to create a measure and key performance indicator (KPI) as well as how to apply a threshold for your KPI in measuring performance.

  • Visualizing Geospatial Data with Excel BI Tools

Location intelligence is an area of business intelligence where data is represented in terms of geospatial plots on a map. With it, you can show your audience a visual representation of how certain data points relate to others in terms of location. In this section, you discover how you can leverage Excel BI tools to add location intelligence to your cache of BI solution offerings. You learn about spatial data and how to create a data tour using Excel BI tools and how to add animated visualization of data over time. It also looks at how to add detail with annotations and text boxes to your map.

  • Creating Advance Interactive Dashboard Visualization Reports

This section shows you how to use Excel BI interactive canvas that allows you to display charts, tables, maps, and slicers in one dashboard window. The components in the window will be inherently linked so that they all work together and respond to any filtering or slicing you apply while using the dashboard. Select a region in one chart, and the other components in the dashboard automatically respond to show you data for only that region.

  • Delivering Business Intelligence with SharePoint and Excel Services

By publishing your Excel reports and dashboards to SharePoint, you can make them available to others in your organization via a browser. This avoids multiple users having separate versions of your workbooks on their computers. This also enables you to make your BI solutions easier to find, share, use and control the access rights to sensitive information. In this section, you gain a basic understanding of what SharePoint is and how it helps organizations share and collaborate data. You also explore how to publish your Excel reports and dashboards to SharePoint.

Event Properties

Event Date 31-10-2018 8:00 am
Event End Date 02-11-2018 5:00 pm
Individual Price Ksh43,500
We are no longer accepting registration for this event

Copyright © 2018 Institute of Advanced Technology