[DSC MENA 24] Ahmed_Refaay_- Where to Start Your Data Analytics Journey.pptx

The world of data analytics is booming, offering exciting opportunities to those who can unlock the power of information. This talk will equip you with a roadmap to kickstart your data analytics journey. We'll explore three key areas to empower your beginning: Business Acumen: Gaining a business understanding is crucial. We'll discuss how to translate business problems into data-driven solutions, ensuring your analysis is relevant and impactful. Six Sigma Foundations: This problem-solving methodology can be a valuable asset. We'll delve into the basic principles of Six Sigma and how they can improve your data analysis approach, leading to more efficient and accurate insights. Data Analytics Fundamentals: We'll introduce essential data analysis concepts like data wrangling, visualization, and basic statistics. Understanding these fundamentals will equip you to handle and interpret data effectively. By combining business acumen, Six Sigma principles, and foundational data analysis skills, you'll be well-positioned to embark on a rewarding data analytics journey. This talk will provide a clear starting point and ignite your curiosity to explore this dynamic field further. at the end we shall share some business cases from our success stories.

1. Data-Driven culture in Organizations track 20 th April, Saturday, 2024 Where To Start Your Data Analytics Journey

2. Brief Summary & Focus Introduction Subject Matter Experts Customers Business Cases Extras Start your Data Journey

3. is the ethos connecting Process Excellence with Digital Transformation

4. Business Consultancy that Fosters Growth, Enhances Processes, and Empowers companies using Digital Transformation Enablers, Data Analytics, And Operational Excellence Methodologies. 8 Years Adding Value Regionally 100% Certified Team Members & Experts 96% Customer Satisfaction 72+ Customers’ Success Stories 60% Process Optimization 40% Digital Transformation

5. Current Practices Percentage of Analyst Time Business Value Data Integration Reporting Analysis Pegasus Enabled Percentage of Analyst Time Data Integration Reporting Analysis Pegasus Reorients your Business to a Greater Value Business Value

6. + Standards, Systems & Benchmarks How Can Pegasus Enable Your Organization + KEY Drivers KEY Indicators Produces Performance Measures Performance

7. Key Technology Partners

8. Pegasus Operational Excellence Solutions www.pegasus-oe.com It’s no longer the big beating the small …it is the fast beating the slow! Eric Pearson Writer

9. Pegasus Operational Excellence Solutions www.pegasus-oe.com It’s no longer the big beating the small …it is the fast beating the slow! Eric Pearson Writer

10. At Pegasus we use multiple Data Technologies and Operational Excellence methodologies together …Yet the real power is our experienced team .

11. Partners & Subject Matter Experts Rawiah Abdallah Scaling & Transformation Dr. Halim Emeira Financial Transformation Rana Amin Digital Transformation Feras Mostafa Supply Chain Optimization Ahmed Refaay Operational Excellence Dr. Nada GabAllah Data Science & AI

12. Ahmed Refaay Earlier Maintenance & Reliability Manager – P&G 1 year Process & Productivity Engineer – P&G 2 years Projects Engineer – EDC 2 years University Teaching Assistant – AUC 1 Semester Factories Quality Assurance Manager 2 Years – P&G Establish Q Systems 35 Employees Achieved Global Record Quality Approved Site Startup EGP XXX Million Projects Dep. Manager 3 year – P&G 8 Engineers+220 Worker Executed $XX Million Projects Engineer Work Process Owner for 7 factories PMP – P&G QMS Auditor – P&G Lean Six Sigma PRB – GE Data Analytics - Cambridge Certifications Education MBA Operations Management (AUC) B. Sc. Mech. Engineering Industrial & Materials Manufacturing (AUC) Factory Operations Manager 1 year – Farm Frites 7 Ops Departments 460 Employees $XXX+ Million Sales Ops per yr Develop Org Leadership Preventive Maintenance Leadership Quality Focused Improvement Work Process Improvement Organization Initiative Management Education & Training TPM Pillars Led Pillars Member of Africa, ME, RCIS & Turkey OPS Analytics & Productivity PRGMs 3 year – GE Healthcare Integrated Big Data Analysis & Operations Score Card Productivity Projects $ X Million Lunched Kenya MOH Metric Ops President Award Club Member eg.linkedin.com/in/ahmedrefaay/ AUC Part time Instructor PMP & Lean Six Sigma, Crisis Mgmt, Ops Mgmt Since 2011

13. Through Ages, People wanted to Know What happened! Explain why did it happen! Predict what will happen!

14. 90% of the data we possess has been generated within the past 4 years. Now, Data can be maintained, saved, integrated, and used. This is the Data & AI age.

15. Performance & Results Financial Gains & Funds Brilliant Visualizations & Dashboards Individuals & Departments Actions and new Changes Impactful Use-Cases driven (Revenue Generate or Loss Eliminate) Collecting data with purpose (clean, useful, meaningful data) Single Source of truth, Data Governance & Consistency Objective, Goals, Strategy, Measures Implementation Business & Technical common language & direction Data-Driven Mindset across all levels & functions Enabled Business with Embedded data insight Right infrastructure and Data Stack Lean Process Optimization Journey Business Functions Integration Empowered Right Talents Experimentation Culture Good Communication

16. Imagine if You Can do Both!

17. People don’t want to buy a quarter-inch drill …They want a quarter-inch hole Theodore Levitt Economist

18. A good individual can maximize their data capability by Building business acumen first about the topics and business that you work in Learning general process improvement methodologies Empowering others Being technology savvy to harness the power of tools then start focusing on specialized tools & Platforms

19. Being technology savvy to harness the power of tools then start focusing on specialized tools & platforms Learning general process improvement methodologies Empowering others Building business acumen first about the topics and business that they work in Attend with other departments orientations and business meetings + daily/weekly sync for a period of time. Understand their goals and objectives Understand their pains and gains Lean Six Sigma is a great start as you will learn process mapping, CTQs/CTPs, 6W2H, 5 Whys, Fishbone and many other mini-tools to shape your general process thinking Your organization’s tools are the top priority Make it a habit to test and check other tools Make it a habit to check other business cases To master the tools, teach and mentor others The most effective way of moving forward is to synergize with others A good individual can maximize their data capability by

20. A good company can maximize their data usage by Business Cases and Major Milestones to be achieved that directly impact core business values & results Capability Building and Foundational Basics awareness of how the Organization ticks Focused and Directed innovation based on utilization of current setup and newly adapted technologies Having Crystal Clear Goals linked to individuals’ tasks backed by Leadership enablement

21. OGSM

22. KPIs should be cascaded from the Management’s Priorities

23. The CEO should focus 80/20 + 4DX Here are the Top Points Were We Can Empower Your Business with

24. The CEO should focus 80/20 + 4DX Be Selective. Don’t measure everything. Management should focus only on the delta of Priorities (Wildly Important Goal); the rest should be departmental internal operations and should be reported back to management. Management should be empowering others to Measuring the lead Behaviors and focusing on. Management should have Dashboards review sessions with their departments + Weekly Heads accountability meeting to ensure they enable each other and support management Wildly Important Goal. Rewards and recognition culture is important to ignite positive challenges inside the organization. Here are the Top Points Were We Can Empower Your Business with

25. Only Select KPI’s that you can have an impact on, control, and accurately reliable. Measuring Rates are much better than measuring totals or averages Customers per Week is a much better metric than Total Customers, because it immediately answers the question, "did our marketing efforts succeed this week?" The total will always go up, but the only way the rate goes up is if our marketing efforts are working. Here are the Top Points Were We Can Empower Your Business with

26. Set goals/targets and compare Total Monthly Recurring Revenue is the big exception we make to the "No totals" rule, and that's because it has a big fat goal associated with it: becoming profitable. Also totals doesn’t make it actionable from anyone's side. The Action plan behund the In-process measures is much more important to focus on rather than the KPI itself. Here are the Top Points Were We Can Empower Your Business with

27. Choose a time window Choosing rate should be based on fixed time window. Shorter time windows mean you'll learn faster but on the other hand, if you choose a time window that's too small, your metric will be too noisy, and become useless. It can go from daily, weekly, or monthly, depending on the business. Here are the Top Points Were We Can Empower Your Business with

28. Everything revolves around the process Understand the Overall business strategy Ensure that everyone get’s it (What does it mean for me and my department) Define the critical control points to understand how to influence your business Put the KPIs on the process and the area where the value change, not at the end Segregate KPIs into Output measures, and in-process measures. If we control the in-process ones, surely the output will be correct Choose the most important ones to focus on (OGSM) Here are the Top Points Were We Can Empower Your Business with

29. Choosing metrics with clear ownership Having a metric that's controlled by two different teams is a problem because it lets one team's failure hide in another's success. So it should be split. RACI is the most effective way. Personalized / Departmentalized scorecards are highly recommended. Centralized Team/Product Score card is of great importance to everyone and the company. This is where you Audit and Change action plans. Here are the Top Points Were We Can Empower Your Business with

30. It is all about Customers Discover what’s most important to each group of “Audience”, then build Traits from a heap of raw data. Subsequently, personalize their experience. Personalize messages and keep them consistent across channels. “Behavioral” data usage is the right approach rather than “market segment” data. Remember twins at the same house hold, have different interests and behaviors although they are from the same market segment. Improving customers’ active engagement will increase loyalty that will lead to more revenues. Here are the Top Points Were We Can Empower Your Business with

31. Pegasus OE Customers’ Use Case & Success Stories Multiple use cases and business scenarios can be discussed directly with many of these companies during the POC period

32. 1 Dashboard relating 6 different sources to enable decision making for Shipping, Warehouse capacity, storage condition, Different shipping quotes, and remote areas supplies needs. Dashboard, Integration, and verification completed in 3 days.

33. XX.X K XX.X x XX.X % XX.X K XX.X K XX.X % Staggering 2 Digits % Monthly Improvement XX% decrease in returns based on the Project’s Implementation Revitalizing Danone’s Egypt Operations: Returns Decrease

34. Optimizing Run-outs & Wastage: Analytics to empower decision making Ultra-Fresh & Bakery focus Delivered a comprehensive 360-degree view of Products Performance with multiple scenarios to optimize reordering points and eliminate wastage and run-outs ongoingly related to customers behavioral shopping pattern

35. Optimizing Order to cash Cycle: From Order Placement to Revenue Realization Improvement “Everything” 360 Insight Delivered a comprehensive 360-degree view of products, Customers’ Performance, Finance, Individual Performance, and overall company execution

36. 4Sale is poised to redefines the cutting-edge data strategy. Imagine real-time insights, lightning-fast decisions, and a personalized user experience so seamless, it sets the industry standard. Crafting a Unified, Insight-Driven Operational Ecosystem

37. www.Pegasus-OE.com @PegasusOE fb.me/PegasusOE www.linkedin.com/company/pegasus-oe http://bit.ly/Pegasusyoutube pegasus_oe [phone] New Cairo, Egypt Thank You Reach us on…

38. Executives Report Measurable Results From Big Data, But Challenges Remain

39. The Analytics Maturity Curve Value Maturity

40. The Analytics Maturity Curve