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 the fundamentals of data analytics and its relevance across industries.
• Clean, analyze, and visualize data using Excel.
• Query and manipulate relational databases using SQL.
• Build interactive dashboards and perform data storytelling using Power BI.
• Confidently relate to Python as a tool applicable for analytics.
• Execute a mini project that combines all four tools.

Participants will learn about:

• Module 1: Introduction to Data Analytics & Data Thinking :-
  • What is Data Analytics? Why does it matter?
  • Types of data analytics: Descriptive, Diagnostic, Predictive, Prescriptive
  • Data Analytics Life Cycle
  • Roles in Data Analytics & Career Pathways
  • Data types, sources, and basic ethics
  • Activity: Group brainstorming on “Everyday Data Problems”
• Module 2: Data Analysis Using Excel
  • Session 1: Excel for Data Analytics – Basics
  • Session 2: Formulas & Functions for Analysis
  • Session 3: PivotTables, Charts & Dashboarding
  • Session 4: Intro to managerial Excel Analytics Tools
• Module 3: SQL for Data Exploration
  • Session 1: Introduction to Databases & SQL
  • Session 2: Aggregations & Filtering
  • Session 3: Joining Tables
  • Session 4: Subqueries & Functions
  • Session 5: Practical SQL Challenge
• Module 4: Data Visualization with Power BI
  • Session 1: Introduction to Power BI Interface & Data Import
  • Session 2: Data Modeling
  • Session 3: Visualizations & Interactivity
  • Session 4: Storytelling & Sharing Insights
• Module 5: Python Foundation
• Module 6: Capstone Project & Presentations
• • Participants will be provided with a dataset or choose from several
  • They will clean, analyze, and visualize data using Excel, SQL, and Power BI
  • Deliver a 5-minute presentation showcasing their findings

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 – Saturdays)
• 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