Refocus - Certificate of Graduation
Learn to earn
Certificate
of Graduation
This certifies that
EDREEN BRYAN VALDEAVILLA
has successfully finished the Core
and Advanced tracks of the Data Analytics course
and completed all the assignments and projects
with a passing grade
June 08,-
Roman Kumar Vyas
CEO & Founder of Refocus
Learn to earn
EDREEN
BRYAN VALDEAVILLA
N
Has successfully finished the Core and Advanced tracks of the Data Analytics course
Number of hours completed
100 hours of video lectures, assessments, and self-study
Number of assignments passed
20 practical assignments and tests with evaluation
Description of project(s) finished
Refocus Project Creating a report
During the project, students analyzed and provided methodology
on how the company can address clients' dissatisfaction with their services. They
used PostgreSQL and Excel to solve problems and visualize data. As a result, they
provided insights and recommendations for the company.
Refocus Final Project
In this project, students utilized their knowledge of Excel, SQL, Power BI, and Python
to complete comprehensive data analysis. They worked with intricate datasets,
cleaned and transformed the data, and created a cohesive narrative through
visualization tools. They identified key trends and takeaways and presented their
insights in a clear and concise manner.
Refocus Project Crafting a Power BI Dashboard for Clockster (optional)
In this project, students successfully processed and cleansed raw data supplied by
the HR department, utilizing tools like Excel, SQL, and Power BI. Following this, they
developed Power BI dashboards to visualize the data and present the insights
requested by the company’s CEO.
Modules completed
Intro Module
Creating Reports Using Excel
Loading Data Using SQL
Creating a Report
Visualizing and Calculating Data in Power BI
Analyzing Data With Python
Tools learned
Databases: MySQL, PostgreSQL
Power BI
Skills acquired
Business Metrics
Final Project
Microsoft Tools: Word, Excel (Pivot)
Python and libraries: Pandas, Seaborn, NumPy, SciPy and Matplotlib
Cleaning, calculating, and visualizing data using Excel and SQL
Creating pivot tables in Excel
Conducting statistical analysis through Excel
Running SQL queries to retrieve information from databases
Processing data and creating dashboards in Power BI
Using Python libraries for data acquisition, cleaning, exploration, transformation,
and visualization
Collaborating with businesses and stakeholders to provide
pertinent information as needed
Showcasing analytical findings and offering insights and recommendations
Demonstrating strong teamwork and effective time and task management
Using business metrics and KPIs to assess a company's performance