Data Analytics Fundamentals

Embark on a transformative journey into the realm of data-driven decision-making with our Data Analytics Fundamentals training course. Explore the foundational principles of data analysis, mastering essential techniques to derive meaningful insights from raw datasets. This comprehensive program is tailored to empower participants with the skills needed to navigate the dynamic landscape of data analytics and contribute significantly to informed decision-making processes.

The Crucial Need for Data Analysts in Organizations: Data analysts play a pivotal role in organizations by leveraging their expertise to interpret and transform complex data into actionable insights, empowering informed decision-making, optimizing processes, and enhancing overall business performance.

Learning Objectives

• Understand key data analysis concepts and techniques.
• Develop proficiency in using Microsoft Excel for data analysis tasks.
• Acquire skills to create interactive data visualizations using Power BI.
• Learn SQL for effective data querying and manipulation.
• Apply data analysis techniques to solve real-world business problems.

Participants will learn about:

• Data Analysis using Excel including :-
  • Introduction to Data and Database
  • Entity-Relationship Concepts
  • Data Integrity and Normalization
  • Working with Functions & Formulas on Excel
  • Data Cleaning & Advanced Techniques
  • Statistical Analysis & Interpretation
• Data Analysis using Power BI
  • Data Cleaning with Power BI using Power Query
  • Data Visualization & Dashboarding
  • Advanced Power Query
  • Data Models
  • Data Analysis Expressions
  • M Query
  • Power BI Publishing Architecture
  • Using the R and Python Visuals
• Use of SQL
  • Writing SQL Statements: SELECT, FROM
  • Filtering & Sorting Data
  • Grouping & Summarisisng
  • Views & Subqueries
  • Querying Multiple Tables
  • Windows Functions
  • Data Cleaning & Analysis with SQL
  • Reports
• Python Foundation

There will also be a Capstone Project and Career Boost including building a data analysis portfolio

Who should attend?

• Entry-level professionals
• Data Co-ordinators
• Data Analysts

What is the training format?

• Online training – The training will be delivered online via Zoom over 8 Weeks  (5 hours per week)
  • 3 hours for Theory (On Saturdays)
  • 2 hours for Practicals (On Sunday)
• The training will be interactive and engaging, incorporating a mix of lectures, hands-on activities, and group discussions.
• This breakdown allows for a balanced mix of theoretical learning, practical application, and interactive engagement with the participants.

Who will deliver the training?

The training will be delivered by facilitators with extensive cognate experience in Data Analysis

What is the cost?

• Online (Virtual) training = N130,000.00 ($130) exclusive of VAT
• Instalmental payment available (40% deposit required)

For more information,

Send an email to info@tenthcodemedia.com

Training Calendar