Skills in Business Analytics

1. Skills in Business Analytics By Christa Smith Head of Business Analytics KPMG: Performance & Technology An IBM Partner

2. Content • What is Business Analytics? • The Skills Shortage • Required Skills • Educating the NET Generation

3. Business.Com Dictionary: Computer-based techniques used in spotting, digging-out, and analyzing ‘hard’ business data, such as sales revenue by products or departments or associated costs and incomes. Wiktionary: Any information that pertains to the history, current status or future projections of a business organization Forrester Research: Business Intelligence is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and operational insights and decision-making What is Business Intelligence?

4. Financial Planning & Consolidation Data Integration Data Warehousing Master Data Management Reporting Scorecard Predictive Analytics Dashboards What is Business Analytics? Analysis

5. Business Analytics 83% 76% Virtualization 71% Risk Management & Compliance 68% Mobility Solutions 68% Customer & Partner Collaboration Self-service Portals 66% 64% Application Harmonization 64% Business Process Management SOA / Web Services 61% 60% Unified Communications The Skills ShortageCIO #1 Concern – IBM Global Survey 4 Source: IBM Global CIO Study 2009, n = 2345,

6. The Skills ShortageIs There a Shortage of Business Intelligence Skills? Display sources for all reproductions of published material, including as much detailed information as possible, e.g. dates, author, page no. etc. If you are reproducing a large extract or a whole article please source fully and ensure you have obtained written permission from the author. Do not reproduce newspaper/magazine articles by scanning unless you have obtained written permission from the author. 11 Hot Skills for 2011 Stacey Collett – Sep 2010 “As data proliferates and IT departments look for ways to contribute to the company's profitability, business intelligence skills will be highly sought-after in 2011, according to 13% of survey respondents. “ Experts Ponder the Era of Big Data John Boudreau – Jun 2011 “Last year, consumers and businesses around the world are estimated to have stored more than 13 exabytes of information on PCs, laptops and other devices -- the equivalent of more than 52,000 times the information housed in the Library of Congress. An exabyte is 1 followed by 18 zeros, or a billion gigabytes.” BI Skills Deficiency Mounting Alex Kayle – Feb 2011 “Currently, a lot of BI analysts start as technology people; this will have to change. BI analysts are going to have to reverse this and are going to have to come out with solid business understanding.” Understanding the Intelligence Business Kuanda Chama – May 2011 “Looking at the local market, Ives comments that the single biggest challenge in the BI space is skills availability because there seems to be no new skilled individuals entering the market “

7. Skills RequiredRoles in Business Intelligence ETL Developer Display sources for all reproductions of published material, including as much detailed information as possible, e.g. dates, author, page no. etc. If you are reproducing a large extract or a whole article please source fully and ensure you have obtained written permission from the author. Do not reproduce newspaper/magazine articles by scanning unless you have obtained written permission from the author. Trainer Project Manager Application Developer Solution Architect Data Modeller

8. Skills RequiredThe Challenge • When we employ a graduate we look for: • The Right Attitude • Understanding of Business Analytics • Understanding of Business Terms • Understanding of Technology and Programming Logic • When our clients need a consultant they look for: • Product Experience • Someone that has already been trained • We invest in the graduate before we can utilize them by: • Training • Learning on-site from senior resources • Teaching them about methodologies • Our competitors look for: • An opportunity to entice a trained resource

9. Skills RequiredRequired Knowledge • Understanding Technology and the History of Technology • Project Management Principals and Methodologies • Data Warehousing Design Principals • Business Practices and Technology • Statistics • Data Analysis and Reporting Techniques • Management Accounting • Understanding Data • Data Quality Issues • Architecting Solutions • Implementation Methodologies • Problem Solving • Best Practices Development with BI Tools • Reporting and Analysis Techniques • Business Writing Skills Experience

10. Educating The NET GenerationWhat do we know about the Net generation • Ninety-seven percent own a computer, 94 percent own a cell phone, and 56 percent own an mp3 player. • Students speak with their parents an average of 1.5 times a day about a wide range of topics. • Seventy-six percent of students use Instant Messaging. • IM users typically chat 80 minutes per day. • Ninety-two percent of IM users reported doing something else on the computer while IM-ing. • Forty percent of students reported that the television was their primary source of obtaining news while 34 percent reported that websites were their primary source (newspapers were the primary source for 11 percent and radio for 8 percent). • Twenty-eight percent reported owning a blog and 44 percent reported reading blogs. • Forty-nine percent reported downloading music using peer-to-peer file sharing (15 percent reported downloading movies and 16 percent reported downloading software). "Connecting to the Net Generation: What Higher Education Professionals Need to Know about Today's Students.“ by Dr Reynol Junco and Dr JeannaMastrodicasa

11. Educating The NET GenerationSo how do they behave? • Well connected • Copy Paste • Assumptions and Mis-information • Expect to have Information at their fingertips • Want it NOW – Instant minded and Impatient • High Expectations – expected to change jobs frequently • Problem solving by “Browsing Menus” • Aptitude for technology • Multi Tasking • Resourceful

12. Educating The NET GenerationWhy practical experience as part of curriculum? • Dynamic Curriculum to Keep Up With Technology • Practical Application of Technology • Relating Business Problems to Technological Solutions • Working With Real Business Cases • Technology Experience Benefits Both Industry and the Student

13. Graduation Programme Educating The NET GenerationHow can we help each other? You IBM KPMG

14. Thank you • Presentation by Christa Smith • Christa.Smith@kpmg.co.za