Transform knowing into understanding

The “Data Analysis, Organization and Management BootQamp” is a perfect way for applying tools and skills to the actual work and tasks of the participants. In the BootQamp setting, there is a constant interaction between theory and application in practice. Combined with best practices, the participant will be able to generate highly valuable information for the organization. Particularly, the BootQamp consists of the following parts:

Part 1: Introduction to Data Analysis and Analytics

The first part introduces a brief evolution of the field of data analysis and discusses the need for best practices in data analysis, especially as the volume of data grows, and the time available to make decisions and remain competitive continues to shrink.

• Definition and history
• Current technology, the growing availability of data, and increasing challenges
• Applications for gaining competitive advantages
• Fact-based decision making
• Process tracking and control
• The BootQamp:
  • Data in your work
  • Objectives for your data
  • Defining data in your job description
  • Presentation

Part 2: Data description, identification and classification

In the second part, we will start identifying and collecting data, defining variables and decisions that need to be supported by information.

• Identification of data
• Describing variables and linking them to research objectives
• Defining key decisions and the need for Information
• Selecting measures and targets
• Collecting data:
  • Tracking business performance
• Measuring performance and finding performance gaps
• Learning from data: experience provides the best data:
  • Historical Data
  • Root Cause Analysis
• Best practices
• The BootQamp:
  • Your data in perspective; applying the theory
  • Presentation
  • Lessons learned – looking back on analysis & presentation

Part 3: Using Excel as data analysis tool

The third part of this course deals with the specific tools and tricks almost every organization is able to use for analysis purposes: Microsoft Excel.

• Introduction to data in Excel
• Advanced analysis features
• Gather and transform data from multiple sources
• Data model creation
• Basic statistics for thorough analysis
• Explore, analyze, and visualize data
• Basic statistics for thorough analysis
• The BootQamp:
  • Analyzing your data with Excel
  • Presentation of the results
  • Lessons learned - feedback

Part 4: Communicating data, analyses and results

The fourth and final part of the “Data Analysis, Organization and Management BootQamp” is dealing with a simple notion. Gathering and analyzing data is as important as presenting the results and communicating effectively. This part deals with:

• Chart basics, like pies, columns, bars, lines and variations
• Advanced charts, like scatters, bubbles , histograms, bullet graphs, combos, and Paretos
• Using trend lines, reference bands, annotations, and direct labeling
• Using Excel to organize data in tables, how to design
• Tricks, tips, and techniques for creating proper workflows
• The BootQamp:
  • Transforming your data into visualizations
  • Presentation of the data and the analysis results
  • Wrap up and implementation project
  • Define the data area for analysis
  • Define research objectives
  • Compose a personal BootQamp data analysis and research plan

Participants to the Data analysis and management BootQamp will generate the following benefits for them, their team and their organization as a whole:

• Understand a variety of data analysis methodologies and background concepts
• Data collection tools
• Analyze and evaluate data
• Understand and apply the various stages of data analysis
• Discover patterns in data
• Perform and present statistical analysis
• Communicate results in various formats
• Use Excel for analysis and evaluation
• Produce analysis reports