List of Training Resources for Workforce Planning Data Analysis and Data Interpretation Skills
               COURSE TITLE                              COURSE OVERVIEW                             FOCUS ON    FOCUS ON DATA 
                                                                                                   DATA ANALYSIS INTERPRETATION
           Analytical Thinking and                                                                       X             X
              Problem Solving  In today’s lean, flat organizations, it is everyone’s job to effectively solve problems. 
                               And while analytical thinking skills may seem natural, they’re not necessarily 
                               intuitive, and they don’t come easily to many people. Analytical thinking and 
                               problem solving are foundational thinking skills that involve breaking things down 
                               into their component parts. They also involve deductive reasoning, drawing 
                               conclusions from givens and applying judgments to reach conclusions from a 
                               combination of evidence and assumptions. This seminar introduces you to 
                               fundamental thinking processes so that you can successfully analyze and solve a 
                               wide variety of business problems. Get these essential analytical thinking and 
                               problem-solving skills now to give yourself a powerful competitive and career 
                               advantage! 
            Analytics Boot Camp                                                                          X
                               This course provides in-depth knowledge and skills associated with the core tools 
                               and techniques used in modern analysis. The course covers the use of MicrosoftTM 
                               Excel® functionality in probability, the analysis and presentation of data, and 
                               statistical concepts critical for analytical proficiency.  There are no prerequisites for 
                               this course.
                                    List of Training Resources for Workforce Planning Data Analysis and Data Interpretation Skills
              Building Meaningful    John Boudreau has advised that for HR to move to the next stage of its maturity, it                     X
                    Analytics        needs to become a Decision Science. In fact, HR has more decision frameworks that 
                                     can be used to optimize talent than are immediately apparent. First and foremost, 
                                     a strong analytics capability is a great basis for future decisions. But the measures 
                                     and metrics that result must be based on the strategic direction and initiatives that 
                                     are unique for each organization. The end result of this process is a Talent 
                                     Scorecard that is tailored to your organization. It must be grounded in the strategy 
                                     and context of your organization; and the Talent Scorecard is a start, not an end. It 
                                     is important to track these measures over time, adjust as needed and look for 
                                     patterns that can inform decisions. A one-time snapshot is not nearly as useful as a 
                                     more historical analysis that shows differences or similarities over time.
               Business Analysis     Develop the skills used by business analysts to effectively plan and monitor a         X                X
              Planning Workshop      complete business analysis project, including shaping the business analysis 
                                     approach and conducting stakeholder analysis.
               Business Analysis:    Using the Guide to the Business Analysis Body of Knowledge (BABOK®), you               X                X
                   Overview          develop a firm foundation in the principles and practices of business analysis - the 
                                     critical process of identifying business improvement needs and developing projects 
                                     to satisfy those needs.
                                     The business analyst serves a critical role as the bridge between organizational 
                                     stakeholders and solution providers, including contractors, to identify business 
                                     process improvement opportunities, gather and analyze business requirements, 
                                     and communicate and assist in implementing the solution package. 
             Career Edge: Business                                                                                          X                X
               and Data Analysis
                                     This course teaches you how to evaluate market and financial data, and present 
                                     insights effectively. You will develop the foundational skills to use Excel as a 
                                     powerful analytical and communications tool. Using innovative educational 
                                     methods, including interactive assessments and games, you will learn, practice, and 
                                     apply techniques to build confidence in your analytical skill set.
                                     List of Training Resources for Workforce Planning Data Analysis and Data Interpretation Skills
              Cost-Benefit Analysis                                                                                            X
              Using Microsoft Excel
                                      Cost-benefit analysis is used by governments and other organizations to evaluate 
                                      the desirability of a given policy or to justify the allocation of scarce financial 
                                      resources to attain an established performance goal. Cost-benefit analysis also 
                                      provides a portable, scalable model for organizing facts, assumptions, estimates, 
                                      and findings in support of complex decisions. This course introduces concepts that 
                                      are applicable to selecting optimal decisions through the use of trade-off analysis. 
                                      In the course, financial and program staff, such as budget and program analysts as 
                                      well as project managers and contracting personnel, will learn to conduct accurate 
                                      cost-benefit analyses, thereby identifying choices that increase public welfare and 
                                      improve efficiency
                Data Analysis and     This course provides some of the core tools used to analyze data. Starting with an       X                X
              Modeling Techniques     overview of the six phases of the Analytics Process Model, participants will focus 
                                      on phase four—Analyzing and Interpreting Data. Learn how to generate 
                                      hypotheses, select appropriate analysis techniques, model data, and interpret 
                                      analysis results to answer your organization’s toughest questions. Hands-on 
                                      exercises provide plenty of practice to reinforce the facilitated discussions, and the 
                                      integration of a case study into the course drives home the concepts with real-
                                      world activities.
               Data Collection and    Learn how to collect and analyze data for a management study or audit. Discover          X                X
                    Analysis          how the data shape the results and reliability of the management study or audit.
                 Data Collection                                                                                               X                X
                   Techniques
                                      This course provides in-depth knowledge and skills associated with the first and 
                                      second phases of the Analytics Process Model—framing the question and collecting 
                                      data. Through individual, small-group, and large-group exercises; discussions; and 
                                      computer applications; participants learn about and practice formulating a data 
                                      collection plan, selecting appropriate data collection methods, developing a survey, 
                                      and conducting interviews and observations. Each day of the course, participants 
                                      are given time in class to work on a group project. The course culminates with 
                                      presentations about the group projects.
                                   List of Training Resources for Workforce Planning Data Analysis and Data Interpretation Skills
             Decision Making and    Learn strategies to improve the impact of your decisions. Learn how to evaluate     X
                Problem Solving     the possible outcomes of various decisions. You increase your productivity and gain 
                                    confidence as you learn a variety of decision-making strategies and how to resolve 
                                    problems constructively. 
           Evaluating and Presenting                                                                                                     X
               Analysis Results: 
              Microsoft Excel 2007
                                    This course focuses on transforming analysis findings into information the 
                                    organization can use to make effective decisions. Participants will learn how to 
                                    determine if an analysis has met the project goals and steps to take when finalizing 
                                    an analysis. The course then shifts to the design and development of presentations. 
                                    Best practices for evaluation and presentation are provided in facilitated 
                                    discussions and reinforced with practical exercises.
                     Excel          Explore essential Excel tasks while working with data to create formulas, charts,   X
                                    pivot tables, and workbooks.
             Excel 2013 Formulas    This course is for those who have experience with Excel and want to enhance their   X
                    DA131           knowledge in the topic of formulas and functions. This course will discuss basic 
                                    formulas and functions in a lecture/hands-on format.
            Excel 2013 PivotTables   Upon completion of this course, participants will be able to:                      X
                    DA123
                                        Create and Analyze a PivotTable
                                        Use Excel's Recommended PivotTable Feature
                                        Use Aggregate Functions within a PivotTable
                                        Create Pivot Charts
                                        Use Excel's Recommended Charts and Animated Charts Features
                                        Create and Utilize Slicer