What you'll learn?
- Identify types of data and of data analytics, and apply the phases of data analysis while protecting personal data
- Calculate and interpret measures of central tendency and variation with spreadsheet functions
- Import data from files into a spreadsheet with the right settings
- Clean data sets: duplicates, missing values, inconsistencies, formats and outliers, with a cleaning log
- Filter data with tables and slicers to answer specific requests
- Summarize data with pivot tables: totals, percentages, running totals, ranks and frequency analysis
- Choose and build charts and dashboards in Google Sheets, Looker Studio and Power BI
- Publish and share reports with proper versioning, access control and documentation
Description
Course content
95 lessons
- Welcome to Data Analytics III Enroll to access
- How the program runs: laboratory, online and self-paced time Enroll to access
- Meet Haraya Retail Corporation and the Data Lab Enroll to access
- How you are assessed Enroll to access
- Course datasets: download the practice files Enroll to access
- Glossary: key terms from every lesson Enroll to access
- LO1. Communicate information about workplace processes Enroll to access
- LO2. Lead workplace discussions Enroll to access
- LO3. Identify and communicate issues arising in the workplace Enroll to access
- Written test: Leading Workplace Communication Enroll to access
- LO1. Provide team leadership Enroll to access
- LO2. Assign responsibilities Enroll to access
- LO3. Set performance expectations for team members Enroll to access
- LO4. Supervised team performance Enroll to access
- Written test: Leading Small Teams Enroll to access
- LO1. Examine specific workplace challenges Enroll to access
- LO2. Analyze the causes of specific workplace challenges Enroll to access
- LO3. Formulate resolutions to specific workplace challenges Enroll to access
- LO4. Implement action plans and communicate results Enroll to access
- Written test: Applying Critical Thinking and Problem Solving Techniques in the Workplace Enroll to access
- LO1. Develop an individual's cultural awareness and sensitivity Enroll to access
- LO2. Work effectively in an environment that acknowledges and values cultural diversity Enroll to access
- LO3. Identify common issues in a multicultural and diverse environment Enroll to access
- Written test: Working in a Diverse Environment Enroll to access
- LO1. Assess work procedures, processes and systems in terms of innovative practices Enroll to access
- LO2. Generate practical action plans for improving work procedures, processes Enroll to access
- LO3. Evaluate the effectiveness of the proposed action plans Enroll to access
- Written test: Proposing Methods of Applying Learning and Innovation in the Organization Enroll to access
- LO1. Use technical information Enroll to access
- LO2. Apply information technology (IT) Enroll to access
- LO3. Edit, format and check information Enroll to access
- Written test: Using Information Systematically Enroll to access
- LO1. Interpret Occupational Safety and Health practices Enroll to access
- LO2. Set OSH work targets Enroll to access
- LO3. Evaluate effectiveness of Occupational Safety and Health work instructions Enroll to access
- Written test: Evaluating Occupational Safety and Health Work Practices Enroll to access
- LO1. Interpret environmental practices, policies and procedures Enroll to access
- LO2. Establish targets to evaluate environmental practices Enroll to access
- LO3. Evaluate effectiveness of environmental practices Enroll to access
- Written test: Evaluating Environmental Work Practices Enroll to access
- LO1. Develop and maintain micro-small-medium enterprise (MSMEs) skills in the organization Enroll to access
- LO2. Establish and Maintain client-base/market Enroll to access
- LO3. Apply budgeting and financial management skills Enroll to access
- Written test: Facilitating Entrepreneurial Skills for Micro-Small-Medium Enterprises (MSMEs) Enroll to access
- LO1. Assess quality of received materials Enroll to access
- LO2. Assess own work Enroll to access
- LO3. Engage in quality improvement Enroll to access
- Written test: Applying Quality Standards Enroll to access
- LO1. Plan and prepare for task to be undertaken Enroll to access
- LO2. Input data into computer Enroll to access
- LO3. Access information using computer Enroll to access
- LO4. Produce/output data using computer system Enroll to access
- LO5. Maintain computer equipment and systems Enroll to access
- Written test: Performing Computer Operations Enroll to access
- Quick reference: Applying Statistical Concepts and Analysis Enroll to access
- LO1. Apply key basic statistical concepts Enroll to access
- Data Lab: Know your data: types, questions and protection Enroll to access
- LO2. Apply basic statistical analysis Enroll to access
- Data Lab: Delivery times: central tendency and variation Enroll to access
- Practice simulator: data types and summary statistics Enroll to access
- Lab task sheets (face-to-face): Applying Statistical Concepts and Analysis Enroll to access
- Written test: Applying Statistical Concepts and Analysis Enroll to access
- Quick reference: Preparing Data Sets Enroll to access
- LO1. Import data Enroll to access
- Data Lab: Import a supplier price list Enroll to access
- LO2. Clean data Enroll to access
- Data Lab: Clean the raw online-order export Enroll to access
- Practice simulator: clean a product returns export Enroll to access
- LO3. Filter data Enroll to access
- Data Lab: Filter the orders for each request Enroll to access
- Practice simulator: filter and sort the supplier deliveries Enroll to access
- Lab task sheets (face-to-face): Preparing Data Sets Enroll to access
- Written test: Preparing Data Sets Enroll to access
- Quick reference: Summarizing Data Sets Enroll to access
- LO1. Aggregate pivot table data Enroll to access
- Data Lab: Pivot tables: totals, shares, running totals and ranks Enroll to access
- LO2. Create pivot table frequency analysis Enroll to access
- Data Lab: Frequency analysis with pivot tables Enroll to access
- Practice simulator: pivot totals, shares and a frequency table Enroll to access
- LO3. Create pivot charts Enroll to access
- Data Lab: Pivot charts: choose, build and read Enroll to access
- Practice simulator: choose, build and read charts Enroll to access
- Lab task sheets (face-to-face): Summarizing Data Sets Enroll to access
- Written test: Summarizing Data Sets Enroll to access
- Quick reference: Preparing Data Visualization Enroll to access
- LO1. Apply data visualization concepts Enroll to access
- Data Lab: Critique the charts before they reach management Enroll to access
- LO2. Create data visualization Enroll to access
- Data Lab: Build the Q3 operations dashboard Enroll to access
- LO3. Publish and share report Enroll to access
- Data Lab: Publish and share the operations dashboard Enroll to access
- Lab task sheets (face-to-face): Preparing Data Visualization Enroll to access
- Written test: Preparing Data Visualization Enroll to access
- Preparing for your institutional assessment Enroll to access
- Comprehensive written test (institutional assessment) Enroll to access
Requirements
- Basic computer operation and basic spreadsheet application skills
- Basic mathematical and analytical skills, attention to detail and problem-solving ability
- Ability to communicate in oral and written English
- A Google account (for Google Sheets and Looker Studio) and a laptop or desktop computer with internet access for the online sessions (the Data Lab needs a screen at least 1024 pixels wide)
- Attendance at the face-to-face sessions in the computer laboratory
Frequently asked questions
A formal qualification and competency standards framework set by the Technical Education and Skills Development Authority (TESDA) for the ICT sector, designed to prepare people for Junior Data Analyst roles.
Yes. This is the training program of Communityline Development Corporation under TESDA's Enterprise-Based Education and Training (EBET) program, run by the TESDA IT Hub. Your trainer assesses each unit of competency during the program, and trainees who complete it are TESDA certified.
144 hours: your face-to-face sessions in the computer laboratory, your scheduled online sessions, and self-paced time on this LMS. Time you spend actively working on lessons, quizzes and Data Lab simulators outside your scheduled sessions is recorded automatically and counts toward the 144 hours. The four core units (96 hours) take most of the time.
A practice workspace built into this course. You import, clean, filter, summarize and chart the datasets of a fictional grocery chain in your browser and answer questions about them. Each lab is graded automatically and your attempts are kept as evidence for your trainer.
A web browser and a free Google account (Google Sheets and Looker Studio). Excel and Power BI Desktop (free, Windows) are used in the computer laboratory; you can also install Power BI Desktop at home if you have a Windows computer.
Trainees accepted into the Data Analytics Level III program of the TESDA IT Hub. Your account is created and enrolled by the training staff.
Students also bought
About the instructor
- 34 Students
- 0 Reviews
- 4 Courses
- View all Courses
Student feedback
No approved reviews yet. Enrolled students can be the first to leave feedback.
Reviews
No published reviews yet.
Add a Review
Please log in and enroll in this course to leave a review.
Free
Enrolment is arranged by your administrator or organization coordinator.
Get access helpSecure checkout and lifetime course access
This course includes
- 95 lessons
- Information sheets, Data Lab simulators, downloadable datasets, lab task sheets
- Revisit enrolled course content
Course Features
- Lectures 95
- Resources Information sheets, Data Lab simulators, downloadable datasets, lab task sheets
- Language English
- Skill level
- Students 0
- Certificate No
- Progression Flexible
More Courses by Jeremiah Phillippe
Become an Instructor, Share your knowledge
Create an online course, guide learners, and grow your teaching business.