Target Audience: Process improvement specialists, project managers, analysts, and professionals who need to apply specific tools in operational excellence initiatives.
MS Project FastTrack
- Schedule Development
- Task creation and organization
- Duration estimation techniques
- Dependency types and setup
- Constraints and deadlines
- Resource Management
- Resource types and creation
- Cost tracking and management
- Project Tracking
- Baseline setting and management
- Progress updating methods
- Reporting and Communication
- Visual dashboards
- Export and sharing options
- Standard reports configuration
- Custom report development
- Visual dashboards
- Change management in MS Project
- Variance analysis
- Progress updating methods
Minitab
- Graphical Analysis
- Basic graphs creation and customization
- Multi-variable and grouped visualizations
- Time series and trend analysis
- Advanced visualization techniques
- Statistical Analysis
- Descriptive statistics
- Hypothesis testing
- Correlation and regression analysis
- ANOVA and other comparative tests
- Process Analysis
- Control chart creation and interpretation
- Process capability analysis
- Measurement systems analysis
- Non-normal data handling
- Design of Experiments
Business Analytics | Power BI
- Data Connection and Preparation
- Data source connections
- Query Editor techniques
- Data transformation methods
- Data modeling best practices
- Data Modeling and DAX
- Relationship creation and management
- Calculated columns and measures
- Basic DAX functions
- Time intelligence calculations
- Visualization Development
- Visual selection principles
- Chart and graph customization
- Table and matrix formatting
- Custom visuals integration
- Dashboard Design and Sharing
- Dashboard layout principles
- Interactive features and filtering
- Publishing and sharing options
- Collaboration and security settings
Root Cause Analysis
- Core RCA Methodologies
- 5 Why analysis
- Fishbone (Ishikawa) diagrams
- Fault tree analysis
- Pareto analysis for prioritization
- Advanced RCA Techniques
- Barrier analysis
- Change analysis
- Current reality trees
- System analysis approaches
- Countermeasure Development
- Solution generation techniques
- Evaluation and selection criteria
- Implementation planning
- Effectiveness verification
- Organizational Learning Systems
- Knowledge capture and sharing
- Trend analysis across problems
- Preventive analysis approaches
- Building a learning culture
Excel Data Analysis
- Advanced Functions and Formulas
- Lookup and reference functions
- Text and data manipulation
- Date and time analysis
- Logical and conditional functions
- Data Analysis Tools
- PivotTables and PivotCharts
- Data tables and scenario manager
- Statistical analysis tools
- Solver and optimization
- Visualization and Dashboards
- Chart selection and customization
- Conditional formatting techniques
- Interactive elements creation
- Dashboard layout and design
- Automation and Efficiency
- Named ranges and dynamic references
- Data validation techniques
- Template development
Statistics Foundations
- Descriptive Statistics
- Measures of central tendency
- Measures of dispersion
- Distribution shapes and properties
- Graphical representation techniques
- Inferential Statistics
- Sampling concepts
- Confidence intervals
- Hypothesis testing fundamentals
- Statistical vs. practical significance
- Relationship Analysis
- Correlation analysis
- Simple linear regression
- Multiple regression introduction
- Association vs. causation
- Statistical Applications in OPEX
- Process capability analysis
- Statistical process control
- Measurement system analysis
- Design of experiments overview