Skip navigation links
Business Technology Solutions
Thought Leadership
Customer Results
About Us
Self Help BI Course 

SEMINARS AND WORKSHOPS:  Self Help BI

Course Overview

Self Help BI Course using Excel 2010 and PowerPivot

BI is all about empowerment of end-users. Accessing information at a time that suits you, in a format that you want to work with is important. Unfortunately, many BI solutions don’t offer this freedom to end-users. This half day course is aimed at people that need to interact with information on a regular basis and often cannot wait for long development cycles before they can get their hands on the right data to make informed decisions. The course will focus on using BI tool number 1 in the world, Excel 2010, including the free add-in PowerPivot.  PowerPivot for Excel 2010 is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel.

After this hands-on, half day course attendees will be able to immediately apply the PowerPivot functionality in their own environment, enabling them to transform large quantities of data with incredible speed into meaningful information to get the right answers in seconds.

Course content:

  

  • Introduction to Excel as a BI tool and the PowerPivot add-in Basics
  • Connect to data source
  • Import data
  • Create relationships
  • Create basic pivot table
  • Data Analysis Expressions (DAX) – The Basics
  • Simple DAX Functions
  • Time Intelligence Functions
  • Creating meaningful reports and dashboards

Who should attend:

  • Anyone who analyses data using Excel

 Prerequisites:

  • Affinity for working with data
  • Basic understanding of Excel & Excel Pivot Tables

iSPartners is a Microsoft Gold Partner that specialises in Business Intelligence, Customer Relationship Management, Corporate Performance Management and Knowledge Management. Please contact us on 011 463 8155 or info@ispartners.co.za for more information.

How to enrol

Book Via Computicket at: http://www.computicket.com/web/event/advanced_excel_self_help_bi_course/367803570  

Terms and Conditions
Please refer to iSPartners Terms and Conditions on the website when you make your booking.

Contact details
Telephone: 011 463 8155
Fax: 086 215 8327
E-mail:
jackieb@ispartners.co.za
Website:
www.ispartners.co.za

 
 
© 2010 IS Partners. All Rights Reserved. | Privacy Policy | Terms of Use CareersContact Us