NIEVGEN | Certified Data Analytics Associate

COURSE DESCRIPTION

The Certified Data Analytics Associate course aims to provide participants with the fundamental knowledge, skills, tools and techniques in data analysis and visualization techniques. It covers basic statistics and analysis, graphs using MS Excel, embedded charts using MS Excel, wireframe/UI/UX design fundamentals using WireframeSketcher, PowerBI and Tableau fundamentals.

Pre-requisite: None

Co-requisite: None

Instructor Led Hours: 16 Hours

Instructor Led Mentoring: 0 Hours

Homework: 8 Hours

Total Certificate Hours: 24 Hours

Training Type: Experiential

Training All-in Fee: Course Fees

Training Schedule: Schedule

ENROLLMENT PROCEDURES

1. Read fully the course details.

2. Read and commit yourself to the Nievgen Code of Ethics.

3. Go to https://www.nievgen.com/ENROLL.html.

4. Fill up completely the course enrollment form. Do not submit yet as you will have to pay the training fees.

5. Pay the training fee thru the indicated payment methods and accounts.

6. Write the transaction reference number in the form.

7. Click the SUBMIT BUTTON once.

8. Just to be sure, you may send your payment confirmation to registration@nievgen.com.

9. Add us at our social accounts.

CERTIFICATION PROCESS:

Phase 1: Attend the instructor led workshop, fully participate and submit in-class activity outputs.

Phase 2: Complete the post-class assignments, essays and take home examinations.

Phase 3: Nievgen Internal Assessment and Audit Activities (Assessors' full evaluation of the competency based on recorded evidences)

Milestone: Awarding of "Certified Data Analytics Associate" credential.

IDEAL PARTICIPANTS:

Engineering students, Accounting students, Engineering professionals, IT analysts, BSBA students, Management assistants, Management auditors, Data Analysts

OBJECTIVES:

At the end of the course, it is expected that the participants will be able to:

Understand business analytics and the financial statement;
Calculate some of the financial ratios and asssess the company's strengths and weaknesses;
Tell the story of a business by doing statistical analysis using functions and Data Analysis;
Create foundational charts in MS Excel and use PivotChart and PivotTables;
Automate charting in MS Excel using VBA (Visual Basic for Applications)
Use WireframeSketcher to create mock designs or wireframes;
Create visualization/dashboards using PowerBI;
Create visualization/dashboards using Tableau;

CERTIFICATION REQUIREMENTS

1. Answer and pass all homework/activities given by the instructor.

2. Actively participate in the class.

3. Full attendance to the sessions.

4. The candidate must commit to displaying good behaviors or conduct to the instructor and his peers.

5. Passing the MCQ final examination and the written essay.

TECHNICAL REQUIREMENTS:

1. Online classes are delivered via ZOOM. Please install zoom.

Install the software that will be used in the class as will be advised by the instructor on Day 01.

2. A laptop or desktop computer is required in the class.

3. For best training experience, you should have an extra viewing/extension monitor that you can connect and be placed adjacent to your laptop.

4. The participants must be computer-literate and must be able to use MS Excel.

5. All classes are recorded for learning, assessment and certification purposes. In joining the class, you agree to be recorded by the Nievgen instructor.

6. The candidate shall TURN ON the CAMERA at all times.

ENROLLMENTS REQUIRE APPROVAL OF NIEVGEN

Nievgen has the right to reject course enrollments if it sees that the enrollment of an individual or of a company is invalid, detrimental and against to the overall interests and internal policies of the company, i.e. intellectual property infringement, the knowledge acquired from the company shall be used to start another training company, knowledge/skill will be used for illegal acts or when the enrollee individual/ company is a competitor or potentially will become a competitor or when the enrollee is deemed unqualified to take the course due to prerequisite or due to professional decisions of the enrollment assessors and/or the enrollee showed unprofessional behaviors. All enrollments to Nievgen undergoes audit prior the start of the class and requires the APPROVAL of the company, similar to other knowledge and competency centers. Immediate refund will be made to individuals or entities who paid during registration, but is declared as ineligible for enrollment.

AWARD AND REVOCATION

The certification is awarded to the successful participants after successful training and assessments, but the certification remains a property of the Nievgen. The certification shall and may be revoked if the participant failed to demonstrate decent or professional behaviors, as according to the Code of Conduct and Professional Ethics of Nievgen, after a complaint has been issued and and an investigation is completed by Nievgen. Nievgen deserves the full right to revoke the certification after due consideration of facts.

ESSENCE OF CERTIFICATION

A certification awarded by Nievgen, thru our competent trainors and assessors, means that you have completed the training and has been assessed to be COMPETENT in the required competencies of learning, as required by NIEVGEN. Certifications are supported by evidences of learning and skills, that are fully documented during training and after training.

Our goal is for you to get the best-in-class training and competency certification at a reasonable price.

SOURCE OF INSTRUCTION

NIEVGEN uses ISO and other ISO-derived international standards of practice and references, including relevant codes and best know practices. Our instructors are also highly experienced, highly trained and internationally certified by ISO 17024 accredited companies, issuing professional certification, as COMPETENT professionals. Our instructors are also graduates of international universities, who continuously train study and receive certifications in United Kingdom, United States and Canada so they can give YOU our customers the best international knowledge and training experience.

COMPETENCIES OF LEARNING:

CDAA-01. Understand data analytics and visualization.

CDAA-02. Perform statistical analysis in MS Excel.

CDAA-03. Use "Data Analysis" in MS Excel.

CDAA-04. Use PivotTable and PivotCharts.

CDAA-05. Use Excel VBA for embedded automatic charts.

CDAA-06. Understand data visualization best practices.

CDAA-07. Create wireframes using WireframeSketcher.

CDAA-08. Create tables and graphs in PowerBI.

CDAA-09. Use formula and functions in PowerBI.

CDAA-10. Create dashboards in PowerBI.

CDAA-11. Create tables and graphs in Tableau.

CDAA-12. Use formula and functions in Tableau.

CDAA-13. Create dashboards in Tableau.

CDAA-14. Manage a data visualization capstone project.

COMPETENCY INFORMATION

CDAA-01. Understand data analytics and visualization.

The instructor shall discuss business analytics and the fundamentals of the financial statements. The candidates are expected to calculate financial metrices and ratios and understand how it impacts the businesses. The candidates are also expected to graph the values, i.e. understand trends and pie charts.

CDAA-02. Perform statistical analysis in MS Excel.

Calculate mean, median, mode, maximum, minimum, range, standard deviation, variance, quartile 1, quartile 3, interquartile range, kurtosis, skewness and normality. Also perform linear regression analysis.

CDAA-03. Use "Data Analysis" in MS Excel.

Perform descriptive analysis and linear regression using Data Analysis of MS Excel.

CDAA-04. Use PivotTable and PivotCharts.

Create tables and charts using PivotTable and PivotCharts technology of MS Excel.

CDAA-05. Use Excel VBA for embedded automatic charts.

Create charts and dashboards automatically by pressing a button, using Excel Visual Basic for Applications.

CDAA-06. Understand data visualization best practices.

Create charts that are telling stories and shows the data that is important to the audiences using the best practices.

CDAA-07. Create wireframes using WireframeSketcher.

Create models of your analytics sites by making layouts, mockups of user interfaces and visualizations. Use WireframeSketcher to accomplish the models.

CDAA-08. Create tables and graphs in PowerBI.

CDAA-09. Use formula and functions in PowerBI.

CDAA-10. Create dashboards in PowerBI.

The participants will use PowerBI to connect to database (extract), transform and load data. Afterwards, the candidates will create formulas, various charts and dashboards.

CDAA-11. Create tables and graphs in Tableau.

CDAA-12. Use formula and functions in Tableau.

CDAA-13. Create dashboards in Tableau.

The participants will use Tableau to connect to database (extract), transform and load data. Afterwards, the candidates will create formulas, various charts, dashboards and stories.

CDAA-14. Manage a data visualization capstone project.

The participant is expected to apply his knowledge and obtained skills in a case study or a visualization project.

INSTRUCTOR

ENGR. JOHN PLACENTE, PMP(R), PRINCE2(R)

President & CEO, Nievgen Group

Master of Business Administration, Heriot-Watt University Post Post Graduate Diploma of Business Administration, HWU

Post Graduate Certificate of Business Administration, HWU

MSc Electrical Engineering, Mapua (Cum Laude)

MSc Finance, Accounting & Taxation, IU Germany

BSc Mechanical Engineering, UC (With Honors)

BSc Electrical Engineering, PLM (Cum Laude)

Board Placer, Registered Electrical Engineering

Certified Trainer and Assessor, Australia

Certified Trainer and Assessor, DOLE-OSHC

Project Management Professional

PMI Agile Certified Practitioner

PRINCE2 Certified Project Manager

PMI Professional Business Analysis

Certified Master Black Belt

Certified Six Sigma Black Belt

Certified Six Sigma Green Belt

Certified Manager, ICPM

Certified Professional Manager, COPC

WE ISSUE BIR OFFICIAL RECEIPTS

Nievgen complies with all government laws, requirements, rules and orders. As a legitimate company operating legally in the Philippines, WE ISSUE OFFICIAL RECEIPTS INSTANTLY by sending you a digital scanned copy of the OR to your email and then sending them through our courier partners, JTExpress and LBC. We also perform weekly audit of transactions to ensure that we give you the OR and we pay the tax greatly needed by the Philippine Government.

PRIVACY & INFORMATION

In enrolling in the class, you ALLOW Nievgen to record you and to keep your information (attendance, evidences of learning, class recording, works, name, address and contact numbers) for the purpose of training, assessment, certification record retention and delivery of certifications to your office or residences. You shall also allow Nievgen to post your class picture in the social media sites (i.e. Facebook, LinkedIn, Instagram) as part of public documentation and proof of attendance. You also allow Nievgen to share your name, address and cellphone number to the courier of your certificate (i.e. LBC, JTEXPRESS, GRAB, DHL) so that the company may be able to sent it to you. Should you want to erase your residence, email and cell number data from our system, please email us at registration@nievgen.com.

Social Media