Categories

Data Analysis Course

12 Weeks

Overview

This Data Analysis Course is designed to equip learners with the essential skills to extract, analyze, and interpret data to drive informed decision-making. This comprehensive course covers the fundamentals of data analysis, including data collection, cleaning, visualization, and statistical analysis. Whether you're looking to enhance your career or pivot into the growing field of data analysis, this course provides the practical knowledge and tools needed to succeed in a data-driven world.

Requirements

Willingness to Learn: An eagerness to engage with data and a passion for problem-solving.

Internet Access: Reliable internet access is necessary for participating in online modules, completing assignments, and accessing data analysis tools and resources.

Basic Computer Literacy: Familiarity with operating systems, internet navigation, and basic software applications (e.g., MS Excel).

Curriculum

Module 1- Microsoft Excel (Spreadsheet)

- Introduction to Data Analytics
- Introduction to Microsoft Excel
- Menus and Cell Structures
- Understanding General Formatting
- Mathematical Operations
- Understanding Formulars and Functions
- Complex Formulars – Cell Referencing
- Quick Formatting and Analysis
- Pivot Tables in Excel
- Working with Charts
- Capstone Project – Business Analysis

- Introduction to PowerBI and its components
- ETL in PowerBI
- Power Query Editor for Data Transform
- Introduction to Data Modelling
- Creating Visuals on Dashboards
- Building a Simple Sales Report
- Building a Sales Report with Calculated Fields and DAX
- Building an Intermediate Sales Report using Time
- Intelligent Functions and DAX
- Creating a Simple Financial Report using PowerBI
- Publishing and Saving PowerBI Reports
- Capstone Project-Social Media Storytelling

- Visualization Types in Tableau
- Data visualization in tableau
- Connecting to various data sources
- Carrying out simple visualization
- Aggregation
- Tableau calculations
- Saving to tableau public
- Combining data
- Join & Create calculated fields
- Forecasting
- Capstone Project-Dashboard Stories

- Introduction to SQL
- Installing XAMP and PostgreSQL
- Database and Table (SQL CRUD, Export & Import)
- Select Statements
- SQL Aggregate Functions
- Operations, Concatenation
- Column Aliasing, Where Clause, Order By and Group By
- SQL JOINS Queries and Sub-Query
- Capstone Project – Sakila Database Query

FAQs

This course is designed for anyone interested in learning data analysis, whether you're starting from scratch or looking to build on existing skills. It's ideal for aspiring data analysts, professionals seeking to enhance their analytical abilities, entrepreneurs wanting to make data-driven decisions, and students aiming to gain a competitive edge in the job market.

Basic computer skills and familiarity with the internet are recommended. A passion for Data and a desire to learn are key. No prior data analysis experience is necessary, as we cover all the essentials from the ground up.

Yes, upon successfully completing the course, you will receive a recognized certificate from BCT Academy, which you can showcase to employers or clients as proof of your expertise.

₦100,000

Buy Now

Featured Review

BCT has a conducive environment for learning, I felt welcomed from the moment I walked through the door. I had young and vibrant motivational tutors who really helped to support me along my journey With the practicality of the training and my steadfastness, I gained an employment into one of the top financial service company as a Data Analyst.

—Okafor Chimezie Kingsley, Data Analyst