pencil

Data Analytics

Data analytics experts are in high demand within the global tech industry. This Practical Data Analytics training will equip you with the right skills needed to thrive as a Data Analytics Expert.

With the advent of technology and the growth of the internet, vast amounts of data are being generated and collected every day, giving rise to the field of Big Data and data science, which focuses on processing and extracting valuable insights from large datasets.

Group of people sitting
elipse
Lady Cancel Icon
Hello There, Do you know the course you want to enrol for??

Discover your ideal career path by taking our insightful personality test.

Thinking Icon

Personality Test

Course Overview

Proper management, analysis and utilisation of data have become critical for businesses and organisations to gain a competitive edge, and drive innovation.

This course is designed for anyone that is looking to elevate their career to an enriching tech job. You will be equipped with the knowledge and skills required to resolve business challenges and bring value to the workplace.

Common responsibilities for Data Analysts include extracting data using special tools and software, responding to data-related queries, setting up processes to make data more efficient, analysing and interpreting trends from the data, and reporting trends to add business value.

Data analytics experts are in high demand within the global tech industry. Analysts evaluate data to gain critical insights and solve problems that impact on a business and thereby boost profits.

Duration   Duration:
8 weeks
Lectures   Lectures:
50
Lectures  Instructor:
Timothy Amaefule
Lectures   Levels:
4
Lectures   Training Method
Remote Learning
Lectures   Pricing:
USD800.00

Course Structure

Days Activity Time
Thursday Data Analytics Training 7:00pm - 10:00pm UK Time
7:00pm - 10:00pm WAT
Friday Data Analytics Training 7:00pm - 10:00pm UK Time
7:00pm - 10:00pm WAT
Saturday Data Analytics Session 10:00am - 2:00pm UK Time
10:00am - 2:00pm WAT
Monday Sprint Review 7:00pm - 10:00pm UK Time
7:00pm - 10:00pm WAT
Tuesday Spring Retro / Sprint Planning

Daily Stand-Up meetings of 15 minutes (TIME AGREED BY TEAM)
7:00pm - 10:00pm UK Time
7:00pm - 10:00pm WAT

Learning Objectives

Upon embarking on this program, you will learn to:

Learn about careers and opportunities that exists within the industry

Learn the concept of data analytics, its applications, processes, workflow

Get familiar with tools being used globally to analyse and process data.

Understand working with Excel as a data analyst, the different data analytics process, use of excel functions and the stages in carrying out data analysis

Master tools like Power BI, and become proficient in SQL and also become familiar with Python ion to Python for Data Analytics.

Identify, locate, evaluate, collect, compile and responsibly use data and associated materials from multiple sources relevant for Data Analytics.

Use appropriate models of analysis, assess the quality of input, derive insight from results, and investigate potential issues.

take large volumes of complex data, extract insights, and help solve business problems.

Course Benefits

Here are some phrases highlighting the benefits
of taking courses

Informed Decision Making

Improved Efficiency and Productivity

Enhanced Customer Experience

Predictive Analytics

On-the-job support

Digital Product Simulation

Discounted access to DCA Work Experience Program

Patterns

Data Analytics Program Schedule

We offer a wide range of opportunities for you.
See what you get and your benefits

INTRODUCTION TO DATA ANALYTICS

  • What is data?
  • What is data analysis?
  • What are the careers in data analytics?
  • What are the opportunities in data analytics?
  • What are the technics in data analytics?
  • INTRODUCTION TO DATA ANALYTICS WITH EXCEL

  • Basic terms, short cut understanding excel
  • Creating tables and naming and saving files
  • Hands on Excel
  • Simple calculations on Excel
  • Importing files and customising ribbons
  • Formulas and functions on Excel
  • IN-DEPTHS OF EXCEL

  • Data cleaning, Sorting and filtering in Excel
  • Data formatting and Conditional formatting
  • Data validation process
  • VLOOKUP
  • Pivot Table
  • Visualisation with Excel
  • INTRODUCTION TO SQL

  • About SQL (Structured Query Language – Sequel)
  • Dataset and Database
  • Creating a table in SQL
  • Basic for SQL and Relational database
  • Importing a dataset
  • Working knowledge of SQL and Database
  • IN DEPTHS OF SQL

  • Connect Database and run SQL queries
  • Proper data cleaning in SQL - Sorting queries in SQL
  • Transforming data in SQL

  • Functions in SQL
  • Combining multiple Data sets – understanding JOINS
  • Subqueries (Nested queries)
  • POWERBI

  • About PowerBI
  • Importing dataset
  • Understanding PowerBI tools
  • Visualisation with PowerBI
  • Working with DAX functions
  • POWER BI DASHBOARD

  • Exploring the basics of dashboard
  • Designing a dashboard
  • Building a dashboard
  • PROJECT DEVELOPMENT

  • Revision of lessons
  • Project Design and planning
  • Cases Studies
  • Project development
  • PPROJECT DEV CONT.

  • Documentation
  • Technical Writing
  • Presentation
  • Backup
  • Defencing
  • Additional personal research required

  • Microsoft Excel
  • Microsoft Power BI
  • SQL Workbench
  • Microsoft Word
  • Medium
  • LinkedIn
  • Preparatory for Interview questions
  • Practice questions HR tackles when interviewing Data Analyst for Job Opportunities
  • Data Collection from
  • Database
  • Forms/Survey
  • ThirdParty
  • Pulling with SQL
  • Analysing Data on Excel
  • Building Powerful Insight and Dashboard on Power
  • Pricing

    Flexible and Convenient Pricing Option

    Our flexible pricing option has made achieving your goals easier i.e getting a course.
    You can conveniently pay for your desired course as in full and enjoy
    discount or paying in installment for over 2 - 3 months period

    One Time Payment

    Course Fee:

    USD800.00

    Pay Now

    Installment Payment

    1st installment:

    USD495

    2nd installment:

    USD247.50

    3rd installment:

    USD247.50

    Pay Now
    pattern ellipse
    ellipse

    Agile Scrum Ceremonies:

    Sprint Planning:

    This is a meeting for the team to consider items of work to be completed and commits to what they have capacity to deliver during the coming Sprint.

    Daily Stand-Up:

    This is a 15-minute team meeting to provide updates and progress of individual work done towards adding value to product development.

    Scrum Review:

    This is where the team showcases what they have completed for the Stakeholders’ review and feedback and get a sign-off.

    Scrum Retrospective:

    This is a meeting where the team reflects on their performance during the current Sprint and seek ways to improve their interaction, practices and lessons learnt

    Sprint:

    This is a cycle of work for the team (can be 1 - 4 weeks interval)

    Enroll Now
    agile scrum
    A pattern

    What our candidates
    say about us

    Left arrow
    Customer 1
    Five star Rating

    A Beyond Rewarding Experience!!!

    "Enrolling with DCA has been beyond rewarding for me. Being someone who transitioned into tech from a totally unrelated field, I can now boast of the confidence, skills and expertise needed to excel in this field since enrolling for the Scrum Master and Agile Delivery Manager training at DCA. The courses delivery from the various coaches who are always available to provide learning support, hands-on training on various collaborative tools and learning resources made available to students to study at their own time, are a few benefits of enrolling on DCA. I would recommend DCA again and again. Many thanks to DCA!!!."

    Kemi Adekeye
    Customer 1
    Five star Rating

    Really great place to train

    Really great place to train - you get hands-on experience, mentoring, personalized learning and genuine interest in your overall welfare. DCA comes highly recommended.

    Tabs
    Customer 1
    Five star Rating

    Deep Learning & Hands-on Work.

    "I have taken a few courses and I must say this one is exemplary. Industry expert coaches tutored and helped me to be ready and pivot to a new digital role. I attended training sessions with practical and hands-on live change projects. The modelling of the training conditioned the learning environment to industry standard. It totally exceeded my expectations. I'd recommend the course to anyone who is considering moving to tech or trying to gain new tech skills.."

    Ola Balogun
    Customer 1
    Five star Rating

    Fantastic Coaches & Hands-on experience

    "Fantastic Trainers/Coaches & opportunities for work experience for graduating students from simulation. DCA also support with free interview prep class. Candidates who joins the WX team are supported with reference when they get their permanent offers. Theoretical & Practical hands on style/framework. Great place to be!."

    Babajide Jolaolu-Kehinde
    Right arrow
    A pattern
    Arrow Up