In today's fast-paced business environment, effectively harnessing and interpreting data is crucial. Whether starting in business analytics or simply looking to brush up on specific areas. A follow-up to Data Analytics for Informed Decision-Making, this in-depth, 2-day course is structured to enhance your knowledge and provide actionable insights, empowering you to employ analytics in your work effectively. You will learn the essential elements that make up a data analysis project, including problem identification, data collection, and analysis methods. We will help you understand and implement a step-by-step guide for data and analytics.
Learning Objectives »
- Identify the critical components of a data analysis project.
- Navigate the data analysis project lifecycle.
- Formulate well-crafted questions to guide the analysis.
- Differentiate between types of data and analysis methods.
- How to start your project correctly using stakeholders and scope.
- Employ data visualization techniques.
- Create a compelling data narrative.
Course Agenda
Collaborative Analytics Foundation
- Core Principles for All Skill Levels
- Essential Mental Framework
- Skill Level Pathways
- Excel as the Common Platform
- Universal Analytics Use Cases
The Data Project Workflow
- Setting the Stage
- Data Projects Method
- Benefits of Using Data Analysis
Questions & Stories
- Asking Well-Crafted Questions
- The First Decision in Data Storytelling
- Key Principles of Data Stories
- The Storyteller’s Primer
The Basics of Data Analytics
- Data Types and Characteristics
- Quantitative Data Examples
- The Mixed Method Approach
- Initial Data Analysis Consideration
- Exploratory and Explanatory Analysis
- Descriptive and Diagnostic Analytics
- Predictive and Prescriptive Analytics
Data Projects
- Individual vs. Team Project
- Project Scope and Objectives
- Better Objective Statements
- Data Collection
- Mixed-Method Data Collection
- Surveys and Interviews
- Focus Groups, Observations, and Tests
- Extracting Data for Analysis
- Data Table Primer
- Cleaning and Organizing Workflow
- Tabular vs. Cross Tabulated
- Data Wrangling
- Tools for Data Analysis
- Excel Baker’s Dozen for Data Analysis
- Making Your Analysis
- Causation and Correlation
Crafting Your Data Story
- Drafting Your Data Story
- Data Visualizations
- Best Practices for Data Visualizations
- Finalizing Your Data Narrative
- The Storyteller’s Primer
- The Common Challenges of Storytelling
