Data Analytics.

Become a Certified Professional Data Analyst by learning modern techniques for Data Analysis. In this course, you will be learning various ways to deal with raw and messy data and derive meaningful information from them. you will also be part of a team to work on a real-life project. This is a beginner to advance course in Data Analytics, positioning you to be ready for the market.


Learn: Introduction | Microsoft Excel | Power BI | Tableau | SQL | Data Analytics with R | Projects

Mentor: Dr Michael Richards

₦149,999

40% OFF

Register
  • Overview
  • Instructor
  • Review

What you'll learn

    Module 1

  • Introduction to data analytics and it's concept
  • Module 2

  • Introduction to Microsoft Excel
  • The interface, Excel formula basics
  • Excel workbook vs worksheet, Data entry
  • Basic formatting, Filtering and Sorting
  • Inserting image, Printing preparation, Finding and replacing data
  • Freezing panes, Excel functions, Conditional formatting, LookUP functions, Vlook Up Data Cleaning
  • Module 3

  • Data Analysis with Excel, Rules to Data Analytics, Data Visualizations, Pivot Tables
  • 2 weeks long practicals on Real life Analysis, Projects Phase One - 6 Projects
  • Module 4

  • Introduction to Business intelligence, Business intelligence vs Data warehouse
  • POWER BI installation and overview, Connecting power BI to different data sources
  • Introduction to power query, Query editor, Data formatting troubleshoot
  • Append queries and merge queries, Text transformation, Number column calculation, Data type
  • Power query data formatting, 2nd Portfolio Creation and Additions
  • Project Phase II - 4 Projects
  • Module 5

  • Introduction to Tableau, Measures and Dimensions, Formatting Tools in Tableau
  • Data Cleaning with Tableau, Visualizations in Tableau, Filtering, Data Modelling in Tableau
  • Cardinalities, Calculated Fields in Tableau, Forecasts In Tableau, Creating Stories
  • 3rd Portfolio Creation and Additions, Projects Phase III - 7 Projects
  • Module 6

  • Introduction to SQL, Databases and Queries, Application Dashboard, Schemas
  • Creating Tables with SQL (Methods), SELECT Keyword, INSERT Keyword
  • understanding Primark Keys and Foreign Keys, Schemas in SQL, Data Import in SQL
  • UPDATE Keyword, WHERE Keyword, DELETE Keyword, Importing Foreign and Primary Key
  • Using Operators, Replacing, Indenting, Toggle, Toggle-case, AND/OR/NOT Keyword
  • IN Keyword, BETWEEN / LIKE Keyword, ALIAS/ LIMIT/ORDERBY Keyword, Aggregate Functions, GROUPBY / HAVING Keyword, ALIAS Keyword
  • CASE Synthax, Types of Joining : Full, Left, Right, Inner.
  • 4th Portfolio Creation and Additions, Projects Phase IV
  • Module 7

  • Introduction to R, Panel Descriptons, Global Options
  • R shortcuts, Variables in R, R Objects
  • R Vectors, LIST Objects, R Dataframes, View Keyword
  • Matrix in R, R Dataset Directory, Working Directory
  • Installing Packages within R, Repicate Functions
  • Working with Arrays, Operators In R, Element-wise logical AND
  • Indexing and Subsetting, Tidyverse, TidyR, ReadR
  • Flexdashboard, stringr, Plotly, Pipe Operators, R Markdown
  • Setting Working Directory, Filter Functions, Omit NAS, Proportions, Geom_bar
  • Geom_bar, geom_boxplot etc, Visualizatiosn in R, YLimit, Projects Phase V
  • Module 8

  • Capstone Project in Teams and individual Capstones

Requirements

  • This course has no skill prerequisites; however, having a basic familiarity with computer operations is beneficial.
  • Personal computer—whether it's a Mac, Windows PC, or a Linux machine
  • A stable internet connection is essential for engaging in virtual classes, downloading required softwares, and for individual practice.
  • Time

About This Course

Data analytics is the process of examining and interpreting data to uncover meaningful insights, identify patterns, and inform decision-making. It involves various techniques and tools to collect, clean, and analyze data, enabling organizations to optimize processes, enhance performance, and predict future trends based on historical data. Through data analytics, businesses can make data-driven decisions, improve operational efficiency, and gain a competitive edge.
The ultimate goal of data analytics is to support and enhance decision-making processes. By providing insights and recommendations, organizations can optimize operations, improve customer experiences, identify new opportunities, and mitigate risks.


Data analytics is widely applied across various industries, including finance, healthcare, marketing, retail, and sports. Companies use it to analyze customer behavior, improve operational efficiency, manage risks, and drive strategic decisions.
Overall, data analytics is a powerful tool that transforms raw data into actionable insights, enabling organizations to harness the potential of their data to gain a competitive advantage and achieve their goals.

Show More

Instructor

Dr Richards Michael

Data Engineer

Mentor Richards is a skilled Data Analytics professional with a Master's in Big Data Analytics from the University of Derby, UK. He has expertise in various Engineering Tech Stacks, contributing to process optimization and market enhancement for organizations. His strategic approach focuses on promoting business growth and efficiency. Additionally, Richards is committed to knowledge-sharing and continuous learning within the tech community, advancing data analytics and technology.

Review
Adenike Idowu
4.9

Empowering and Educative!

I am grateful for the invaluable resources that Vephla University provided throughout my studies. The platform’s comprehensive curriculum was a perfect fit for my diploma program, offering both essential knowledge and specialized skills needed in my field. The self-paced learning format was incredibly beneficial, especially during my hectic finals season— I could manage my time while diving deep into complex topics.

  • Helpful
  • Not helpful
Wivina Omolemen
4.9

Life-Changing Educational Journey!

As a recent graduate, I can confidently say that Vephla University played an instrumental role in my academic success. The platform offered a diverse range of courses that not only enriched my knowledge but also developed my practical skills. The interactive learning modules made difficult concepts easier to grasp, and I loved how I could learn at my own pace.

  • Helpful
  • Not helpful
Apply Now

Don't miss out! Apply now and kickstart your journey!

Checkout Other Courses!

Elevate your skills today!
Show More Courses

Best Seller

100% Live Lectures

7 months | Installments allowed

Data Analytics
5.0
(40% off)
Mentor: Dr Richards Michael
₦149,999
Enroll

100% Live Lectures

7 months | Installment allowed

UI/UX Design
4.9
(40% off)
Mentor: Ms. Evelyn J
₦149,999
Enroll

100% Live Lectures

12 months + Paid internship

Fullstack Software Engineering
4.8
(38% off)
Mentor: Dev Jacobs
₦399,999
Enroll

100% Live Lectures

7 months | Installment allowed

Frontend Engineering
4.9
(40% off)
Mentor: Dev Peter A.
₦149,999
Enroll

100% Live Lectures

12 months + Paid internship

Design Engineering
4.8
(45% off)
Mentor: Dr Michael A.
₦299,999
Enroll

100% Live Lectures

7 months | Installment allowed

Cybersecurity
4.9
(40% off)
Mentor: Alfred M.
₦149,999
Enroll

100% Live Lectures

7 months | Installment allowed

Project Management
4.9
(40% off)
Mentor: Dr. Lucy Raymond (PhD)
₦149,999
Enroll

100% Live Lectures

7 months | Installment allowed

Python & Pandas
4.9
(40% off)
Mentor: Dr. Richards Michael
₦149,999
Enroll

100% Live Lectures

7 months | Installment allowed

Data Science
4.9
(40% off)
Mentor: Dr. Richards Michael
₦149,999
Enroll

100% Live Lectures

7 months | Installment allowed

Advanced SQL
4.9
(40% off)
Mentor: Dr. Richards Michael
₦149,999
Enroll