COURSE DESCRIPTION:
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.
SCHEDULE: Mostly on Mondays, Wednesdays and Saturdays Between 7pm WAT - 10pm WAT
FEES (40% Off): #149,999 : Payable in Multiple Installments
KINDLY FIND YOUR CURICULUM BENEATH.
MODULE 1: Introduction to data analytics
• What is data analytics?• Importance of data analytics
• How companies use data analvtics
• difference between data analytics and data science
• Job opportunities in data analytics
• salaries of a data analyst
• Types of data analytics
• Problem types data analyst solve
• Data, database, dataset, metadata
• Types of data
• Big and small data
• The 4 V's of Big data
• Data life cycle
• data ethics
• Data collection
• Data sources
• Data analytics steps
MODULE 2 : Introduction to Microsoft Excel PART 1
• Introduction to Microsoft Excel• The interface
• Excel workbook vs worksheet
• Excel formula basics
• Data entry
• Basic formatting
• sorting
• filtering
• Inserting image
• printing preparation
• finding and replacing data
• freezing panes
• Excel functions
• Conditional formatting
• LookUP functions
• Vlook Up
• Data Cleaning
MODULE 3 : Introduction to Microsoft Excel PART II
• 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: Data analytics with POWER BI
• 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: Data Analytics with Tableau
• 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 : Data Analytics with SQL
• 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
• Table Joining:
• Types of Joining : Full, Left, Right, Inner.
• 4th Portfolio Creation and Additions
• Projects Phase IV
MODULE 7 : Data Analytics with R
• 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
Frequently Asked Questions
Course Mentor
Richards Micheal.
Bsc., PGD(Dublin)., Msc (England)., aCAP., CDSA.
Mentor Richards is a distinguished Data Analytics professional with a Master's Degree in Big Data Analytics from the University of Derby, UK. His educational achievement underscores his dedication and expertise in data analytics and various Engineering Tech Stacks, showcasing a versatile skill set in the tech sector. His practical application of his knowledge in real-world projects has significantly impacted the organizations he has worked with, optimizing processes and strengthening their market position. His strategic approach to data analytics focuses on leveraging data for business growth and efficiency, highlighting his role as a visionary in the field. Furthermore, Richards is committed to sharing his insights and fostering a culture of continuous learning within the tech community, contributing to the advancement of data analytics and technology as a whole.
More Courses
Data Analytics.
Empower your career with our Data Analytics course! Gain invaluable skills, make informed decisions, and elevate your success. Join today to harness the transformative potential of data for professional growth
UX/UI Design
Craft your envisioned future! Elevate your career with our UI/UX Design course, merging creativity with functionality. Join us to shape captivating digital experiences and unlock professional opportunities.
Front End Engineering
Transform your coding aspirations into reality! Enroll in our Front End Engineering course to delve into the dynamic world of web development. and unlock the skills that fuel digital innovation.
Project Management with Slack & Asana
Elevate your career with our Project Management course, refining leadership skills and propelling your journey to new heights. Cultivate strategic prowess and become a force behind success.
Fullstack Software Engineering ( Nano Degree )
Fullstack Software Engineering
Accelerate your career with our Beginner to Advance Full Stack Software Engineering course. Gain comprehensive skills, positioning yourself as a market-ready professional. Secure your future success. enroll now!
Design Engineering ( Nano Degree )
Elevate your career as a Certified Full Stack Designer. Learn cutting-edge UI/UX Design and Frontend Development techniques. Achieve professional certification and stay ahead in the dynamic world of design and development.. gaining the skills and confidence to excel in today's competitive market. Enroll now to shape your success
Maryjane O.
Hi Vephla, A Vephla Graduate recommended Vephla to me as he got a job upon completion, Please can i have more details like how classes are held and other details i may need, I will want to start as soon as possible, Thank you and i look forward to your feedback.
Reply
Vephla Uni
Hiya Mary, our mentorships lasts for 6 months , otherwise stated for some courses. -fees are payable in installments ( preferably two to three installments ) -We operate fully remotely hence All classes are Online live sessions that are expert led with all classes being recorded during classes too and saved for you to rewatch anytime there is need to catch up on your cloud link if you miss a class. -our learning proceeding is super practical as you’re taught right from the scratch without needing to have a prior knowledge to sail through -Classes are thrice weekly inclusive with a day for an assessment. Classes are mostly between 8pmWAT through 10pm ( class hours are often within that range of timing ) -What distinguishes Vephla Tech stack learning out is the fact that we also recommend our top performing students for internships and their first roles and we take our students through varying graduate fairs to get them prepared for their first roles And most importantly, you get a certification upon completion. Do you have any further questions you’ll want me to help with ?
Reply
Pay for Your Fees Here