DATA ANALYSIS TECHNIQUES FOR ENGINEERS &
TECHNOLOGISTS
22—24 May, 2016
Doha, Qatar
Course Introduction:
Making sound business decisions in a timely manner is a key success factor for today’s mod-ern operations managers and Entrepreneurs. Faced with large amounts of information available today, most managers would use modern tools (such as Microsoft® Excel spread-sheet program) to help them summarize, chart, and analyze data/trend in order to make accurate, fast and better decisions. Sorting, organizing and analyzing data can becomes mere activities unless one is able to gain insights into what the data is revealing and accu-rately transform that information for business decision making actions. They also need to build analytical business models to help their company increase profits, reduce costs, or just to manage their operations more efficiently.
This training program covers those important MBA-taught subjects and teaches the partici-pants to use proven data analysis tools and business modeling methods that could save them hundreds of hours in number crunching, besides providing them with new improved approaches for analyzing important business decisions and opportunities. It covers the are-as of Finance, Operations Management, Sales & Marketing, Quality Improvements and also Applied Statistics. The training approach is hands-on, practical, teach-by-examples with the focused emphasis on “real-world” business scenarios and examples.
Course Objective:
Upon completion of this course, the trainees will be aware and understanding of the fol-lowing:
Perform real operations and business quantitative decision-making analysis using prov-en techniques in these areas:
Data Tabulation and Analysis; Using Pivot Tables, Graphs & Statistics
Analyzing and making Financial Decisions
Analyzing & making Operation Management Decisions
Analyzing and making Sales & Marketing Decisions
Analyzing and making Quality Improvements Decisions
Analyzing and testing data using Applied Statistics
Efficiently utilize MS Excel to compile data, tabulate & interpret results, and present tables/charts in a fast track manner.
Analyze data using proven methods and construct business models effectively.
Solved real operations & business problems in a fast pace manner.
Be able to test and make better business & per-sonal decisions for bottom-line results
Mechanical Engineer
Who Should Attend:
This course is specially designed for Entrepreneurs, Operations Managers, Business & Fi-nance Managers, Project Managers, Executives and Engineers, whose job requires analyzing daily operational data and make good decisions for improvements.
Mechanical Engineer
ing
Course Content:
Module (01) Introduction to Data Analysis (using MS Excel)
1.1 What is Data Analysis?
1.2 Introduction to Management Science & Business Operational Decision Analysis 1.3 Importance and benefits of utilizing quantitative data analysis for business decision making
1.4 Benefits of using MS Excel for data analysis
1.5 Exercises: Comparing two groups of data & Descriptive Statistics 1.6 Exercises: MS Excel Toolpak Analysis
Module (02) Transforming Data into Information for Decision-Making
2.1 Preparing data for analysis
2.2 Get new perspectives on data with subtotals 2.3 Get new perspectives on data with pivot tables
2.4 Easy & fast charting and tabling techniques for better decision making 2.5 Exercises: How is your business performing?
2.6 Exercises: How efficient are your operations?
Module (03) Analyzing & Making Financial Decisions
3.1 Preparing data for analysis
3.2 Get new perspectives on data with subtotals 3.3 Get new perspectives on data with pivot tables
3.4 Easy & fast charting and tabling techniques for better decision making 3.5 Exercises: How is your business performing?
Mechanical Engineer
ing
Course Content:
Module (04) Analyzing & Making Operations Decisions
4.1 Determine which product mix will yield the greatest profits 4.2 Determine optimal production loadings
4.3 Optimizing workforce scheduling
4.4 Making Production’s ‘Buy or Make’ business decisions
4.5 Solving transportation and distribution issues
Module (05) Analyzing & Making Sales & Marketing Decisions
5.1 Minimizing the cost of sales
5.2 Create best, worst, and most-likely scenarios for sales 5.3 Optimizing sales results
5.4 Interpret the effects of price and advertising on sales
5.5 Exercise: Using Simple Regressions and Multiple Regressions
Module (06) Analyzing & Making Quality Improvement Decisions
6.1 Analyzing data distribution against specification windows with Histogram. 6.2 Prioritizing vital areas to solve problems with Pareto Diagram
6.3 Analyzing correlation with Scatter Diagram
6.4 Using Control Charts to determine level of service and operation processes 6.5 Using Control Charts f
Module (07) Analyzing & Testing Data Using Applied Statistics
7.1 Statistical hypothesis testing
7.2 Comparison test (one sample and two samples): 7.3 Multiple sample comparison:
7.4 Analysis of Variance (ANOVA)
7.5 Exercises: Concluding ‘Before’ & ‘After’ tests effect
Course Fees:
The amount of 10, 900 QAR will be charged for the course fee and Full Payment is required prior to commencement of the course. This Rate Includes Participant’s Manual, Hand-outs, Buffet Lunch, Coffee/Tea on Arrival, Morning and Afternoon of each day.
Bank Name: Commercial Bank of Qatar
Account Name: Qatar Skills Academy
Account Number: 4050-200774-001
Branch: Commercial Bank Plaza Main Branch
Swift Code: CBQAQQA
IBAN: QA64CBQA000000004050200774001
Payment Methods:
Registration Methods:
Email: [email protected] Fax: +974 4416 2637 Website: www.qatarskillsacademy.comContact us:
Address:
Barwa Commercial Avenue
Building 39, Doha, Qatar
GPS Coordinates:
25.223682 / 51.506324
Tel:
+974 4416 1622
Fax:
+974 4416 2637
Email:
[email protected]
Course Methodology:
Course Timing:
07:30 to 08:00 Registration, Coffee / Tea 08:00 to 09:30 First Session
09:30 to 09:50 Coffee / Tea, Snacks 09:50 to 12:00 Second Session
12:00 to 13:00 Lunch Break and Prayer Break 13:00 to 14:30 Last Session
Lectures and Power Point Presentation
Case Studies and Self Questioner
Concepts, Techniques and sharing Practical Experience
Visual Aid (Video Simulation )
Role Plays
Individual and Group Exercises
Pre and Post test
Individual Assessment During the Class