Classroom/ Online: Yes/ Yes
Scheduling Date(s):
Note: Please click specific date for detailed venue and course fee etc.
Data Analytics and Statistics made easy using Microsoft Excel
Data Analytics and Statistics skill is becoming a "must have" skill to gain competitive advantage both in business and in career growth in an increasingly digitalized and data driven business environment. This one-day "Data Analytics & Statistics made easy using Microsoft Excel" is designed to help participants get good insight into data analytics tools & techniques in an interactive way using MS Excel instead of fancy and expensive software. The examples & case studies include from various industries such as Manufacturing, Retail, F&B, Banking & Financial services, Hospitality etc
Objective
At the end of this course, participants will be able to
- Understand types of data, data collection methods & sampling plans
- Apply various statistical tools & techniques for real world scenarios from different industries
- Develop and present appropriate graphs and charts at business meetings
- Utilize insight from data analytics outcome for business decision
Outline
- Data Types, Data Analytics Framework, Statistical concepts
- Data collection methods and Sampling plans
- Data behaviour, data insight, comparing different set of data
- Data relationship to help develop insight into future
- Validating data for data integrity, data quality
- Visual and graphical approach to data analytics, presentation and storytelling
- Data analytics & statistics for digital strategy & transformation
Who should attend
- Leaders, managers, supervisors who require daily data analysis and data driven decision making
- Process improvement leaders, Data analysts, Teachers, Lecturers, Trainers
- Students who require to understand and present data & statistics as part of their course work
- People who want to improve their career opportunities in a dynamic job market
Profile of Ramesh Rao
Ramesh Rao holds a bachelor’s degree in engineering, and in finance, and master’s degree in supply chain management & strategic finance. He is a certified design thinking facilitator, a certified lean six sigma master black belt (MBB), certified agile & project management professional. Ramesh also holds professional certificates in data science, applied statistics and digital transformation. Ramesh is an adult education & facilitation specialist holding a diploma in adult continues education (DACE) from IAL (SUSS). Ramesh has 30 plus years’ experience in corporate and in consulting & training career spanning multiple continents and countries. Ramesh worked in leadership role in operations, supply chain, quality management, automation & robotics, finance, operational excellence & digital transformation. The industries he helped include manufacturing, financial services, retail, supply chain & logistics, healthcare, hospitality, government organizations, start-ups and more. Ramesh successfully applied, coached, mentored companies and leaders in applying data analytics & statistics for various business scenarios and helped companies make better data-driven decisions & improve profitability. Ramesh also provides training at local universities in Singapore