- info@webcapz.com.ng
- Mon - Sat: 8.00 am - 6.00 pm
We are creative, ambitious and ready for challenges! Hire Our Talents
// Data Analysis Course in Port Harcourt
Get Certified As A Professional Data Analyst
Are you ready to build a future-proof career in one of the most in-demand tech skills today? Our Data Analysis Course in Port Harcourt is designed to equip you with practical, job-ready skills in data analysis and data visualization using industry-standard tools such as Advanced Excel, Power BI and Tableau.
This comprehensive Data Analysis Training will take you from beginner to professional level, helping you analyze, interpret, and visualize data for smarter business decision-making. Whether you want to learn data analysis, switch careers, or enhance your professional value, this program provides the right foundation and hands-on experience to succeed.
At WebCapz Technologies, we don’t just teach theory, we train you to think like a data analyst, solve real business problems, and confidently present insights through powerful dashboards and reports.
To make informed business decisions, organizations must have a data analyst that can help analyze and interpret business data. Gain the tools and credentials to launch a rewarding career in the field of modern technology.
Why Data Analysis Skills Are in High Demand
In today’s digital economy, data drives decisions. Organizations across industries finance, healthcare, marketing, logistics, oil & gas, and technology rely on data analysts to uncover insights that improve performance and profitability.
By enrolling in our Data Analysis Course, you gain:
- In-demand analytical and problem-solving skills
- Strong data visualization expertise
- Practical experience with real-world datasets
- A competitive edge in Nigeria and globally
This program positions you for roles such as Data Analyst, Business Intelligence Analyst, Reporting Analyst, and more.
You’ll learn how to clean data, analyze trends, and build interactive dashboards that help stakeholders make informed decisions.
Our Data Analysis Training is structured for absolute beginners and intermediate learners alike. You don’t need a technical background to get started.
By the end of the program, you will confidently handle datasets, create compelling visualizations, and explain insights clearly, skills employers value highly.
// We are proud members and partners of leading technology and professional organizations:
Our Partnerships & Certifications
// From Beginner To Mastery
Who Should Attend
01
Career Switch
Those who are switching career to tech industry for freelancing or to get a remote job.
02
Next Level
Those who have programming skills but want to take their skill to next level with real-life projects.
03
Travel Abroad
Those planning to travel abroad and seeking hands-on skill that can make them relevant.
// Benefits of Training at WebCapz
Why Choose Us?
- Expert
- Career
- Certificate
WebCapz is the leading IT Training Institute with over 10 years cognitive experience. Our courses are taught by experienced professionals with a wealth of industry experience. Our approach is beginner-friendly, practical and project-based.
We Commit to your Success! We offer world-class support to our students with over 3,000+ students trained in Nigeria. CV review, interview preparation, LinkedIn profile update, job alert within our alumni community and mentorship.
WebCapz Technologies is a registered IT solution and training company in Nigeria. We collaboration with our international partners in the UK and India that allows us to issue recognized certificate to our students at the completion of the training.
// What You Will Learn
Course Content:
Introduction To Data Analysis
- What is data analysis
- Preparing data for analysis
- The data analysis process
- Data analysis tools
- Types of data analysis
- Essential requirements in performing data analysis
Data Analysis with Excel
Introduction: Getting to Know Excel
- Understanding and working with Cell
- Understanding and working with Column
- Understanding and working with Row
- Mastering Copy Paste
- Mastering Autofill
- Intelligent navigation with Excel data
- Basic Mathematical functions
- Unlocking Keyboard Shortcuts with Master-key
- Homework: Entering 10 records in Excel
- Best Practices – Entering data in Excel
- Removing Duplicates
- Removing Spaces
- Spell check
- Replacing blank cells
- Using proper fonts
- Extracting Substring or part of data
- Merging data in cells
- Text to columns
- Data sorting
- Transpose data
- Flash fill
- Vlookup
- Hlookup
- Index and match
- Consolidate
- Append data with power query
Getting Ready for Data Analysis
- Freeze Panes
- Filters and advance filters
- Conditional Formatting
- Subtotals
- COUNTIF
- COUNTIFS
- SUMIF
- SUMIFS
- Introduction to Data Analysis and Data
Summary by a parameter - Adding parameters with drill down and drill up
- Breaking down information by Column
- Filtering the data in reports
- Understanding Value Field Settings
- Working with Dates in rows
- Grouping example
- Compiling data on one sheet
- Slicers
- Timeline
- Adding Calculated Fields
- Calculated Fields – Why this approach is better
- Introduction and first chart
- Exploring the chart options further
- Compiling data on one sheet
- Adding timeline (time slicer) on dashboard
- Adding and adjusting slicers
- Adding trendline charts
Relational Data and Data Modelling
- Understanding Relational Data
- Adding Power Pivot to Excel
- Adding data to Data Model
- Data Modelling
- Power Pivot
Data Analysis & Visualization with Power BI
INTRODUCTION TO POWER BI
- Touring the Report View (Power View)
- Touring the Data View (Power Query)
- Touring the Model View (Power Pivot)
- Starting new Instances of Power BI Desktop
- Splash Screen
- Viewing Table Relationships and Settings
- Web Authentication and Loading Tables
- Optimizing Performance with Excel Files
- Optimizing performance with Power Pivot Data Model
- Connecting to underlying Pivot Table Data
- Importing from Power Pivot Data Model
PART 2
- ETL and Power Query
- Data Shaping – Renaming Tables
- Data Shaping – Promoting the First Row
- Data Shaping – Duplicating Column/Replace Values
- Data Shaping – Removing Columns
- Data Shaping – Filtering/Sorting, etc.
PART 3
- Introduction to Enhancing Data Structure
- Enhancing Data Structure – Join Types/ Merging Queries
- Data Profiling Recap
- Introduction to Designing a Data Model
- Working with Tables
- Fact Versus Dimension
- Breaking Down Tables
- Creating Hierarchy
PART 4
- Relationships (a.k.a Cardinality)
- Creating Relationships
- Reviewing the Model Interface
- Creating Row Level Security Roles in Desktop
PART 5
- Introduction to DAX (Data Analysis Expression)
- Creating Calculated Tables
- Creating Calculated Columns – DATEDIFF
- Creating Calculated Columns – RANKX Highest
- Creating Quick Measures
- Creating Measures
- Creating Date Tables
- Time Intelligence Functions
- Importance of Variables
- Building a Measure to use in a Measure
- Building a Measure with Variables and Comments
- Other Optimization Techniques
PART 6
- Using and Formatting Drill Through Pages
- Conditional Formatting
- Accessibility Features
- Introduction to creating Dashboards
- Dashboard Guided Project
Capstone Projects
Data Visualization with Tableau
Module 1: Introduction to Data Visualization & Tableau
What is Data Visualization?
Importance of Data Visualization in Business
Introduction to Tableau Ecosystem
Tableau Desktop
Tableau Public
Tableau Server & Tableau Cloud
Use cases of Tableau across industries
Installing and setting up Tableau
Practical:
✔ Exploring Tableau interface
✔ First Tableau worksheet
Module 2: Understanding Data & Connecting Data Sources
Types of data (Structured vs Unstructured)
Understanding data formats:
Excel
CSV
Text files
Databases
Connecting Tableau to data sources
Live vs Extract connections
Understanding data types and fields
Practical:
✔ Connecting to Excel & CSV files
✔ Data preview and field configuration
Module 3: Data Preparation & Cleaning in Tableau
Data Interpreter
Renaming fields and aliases
Splitting and merging columns
Handling missing values
Pivoting data
Data filtering and sorting
Data blending vs joins
Practical:
✔ Cleaning a messy dataset
✔ Preparing data for analysis
Module 4: Core Data Visualization Concepts
Dimensions vs Measures
Discrete vs Continuous data
Understanding Marks Card
Chart types and use cases:
Bar charts
Line charts
Area charts
Pie charts
Scatter plots
Maps
Choosing the right visualization
Practical:
✔ Building multiple chart types
✔ Applying formatting and labels
Module 5: Filters, Sorting & Groups
Creating filters (dimension & measure filters)
Context filters
Top N filters
Sorting data
Creating groups and sets
Using sets for advanced analysis
Practical:
✔ Interactive filtering
✔ Creating dynamic groups
Module 6: Calculations & Table Calculations
Introduction to calculated fields
Basic calculations
Conditional logic (IF, CASE)
Aggregate vs non-aggregate calculations
Table calculations:
Running totals
Percentages
Moving averages
Date calculations
Practical:
✔ Creating KPIs using calculations
✔ Trend and growth analysis
Module 7: Parameters & Advanced Interactivity
What are parameters?
Creating and using parameters
Dynamic calculations using parameters
Parameter-driven dashboards
Using parameters for user input
Practical:
✔ Interactive dashboards with parameters
Module 8: Mapping & Geographical Analysis
Geographic data in Tableau
Working with maps:
Symbol maps
Filled maps
Custom geographic roles
Using latitude and longitude
Map layers and formatting
Practical:
✔ Sales or population map dashboard
Module 9: Dashboards & Storytelling with Data
Dashboard design best practices
Creating interactive dashboards
Using dashboard actions:
Filter actions
Highlight actions
URL actions
Building stories in Tableau
Data storytelling techniques
Practical:
✔ End-to-end business dashboard
✔ Interactive storytelling project
Module 10: Analytics & Business Intelligence Features
Trend lines
Forecasting
Clustering
Reference lines and bands
Using analytics pane
KPI dashboards
Practical:
✔ Business performance analysis dashboard
Module 11: Publishing, Sharing & Security
Publishing dashboards to Tableau Public
Tableau Server & Cloud overview
Exporting dashboards
User permissions and security
Best practices for sharing insights
Practical:
✔ Publishing final dashboards
Module 12: Real-World Projects & Capstone
Learners will complete hands-on projects based on real business scenarios such as:
Sales Performance Dashboard
Financial Analysis Dashboard
HR Analytics Dashboard
Marketing Campaign Analysis
Operations & Supply Chain Dashboard
Capstone Project:
✔ End-to-end Tableau project from raw data to executive dashboard
Capstone Project
Final capstone data analysis and visualization project using Excel and Power BI
Introduction To Data Analysis
- What is data analysis
- Preparing data for analysis
- The data analysis process
- Data analysis tools
- Types of data analysis
- Essential requirements in performing data analysis
Data Analysis with Excel
Introduction: Getting to Know Excel
- Understanding and working with Cell
- Understanding and working with Column
- Understanding and working with Row
- Mastering Copy Paste
- Mastering Autofill
- Intelligent navigation with Excel data
- Basic Mathematical functions
- Unlocking Keyboard Shortcuts with Master-key
- Homework: Entering 10 records in Excel
- Best Practices – Entering data in Excel
- Removing Duplicates
- Removing Spaces
- Spell check
- Replacing blank cells
- Using proper fonts
- Extracting Substring or part of data
- Merging data in cells
- Text to columns
- Data sorting
- Transpose data
- Flash fill
- Vlookup
- Hlookup
- Index and match
- Consolidate
- Append data with power query
Getting Ready for Data Analysis
- Freeze Panes
- Filters and advance filters
- Conditional Formatting
- Subtotals
- COUNTIF
- COUNTIFS
- SUMIF
- SUMIFS
- Introduction to Data Analysis and Data
Summary by a parameter - Adding parameters with drill down and drill up
- Breaking down information by Column
- Filtering the data in reports
- Understanding Value Field Settings
- Working with Dates in rows
- Grouping example
- Compiling data on one sheet
- Slicers
- Timeline
- Adding Calculated Fields
- Calculated Fields – Why this approach is better
- Introduction and first chart
- Exploring the chart options further
- Compiling data on one sheet
- Adding timeline (time slicer) on dashboard
- Adding and adjusting slicers
- Adding trendline charts
Relational Data and Data Modelling
- Understanding Relational Data
- Adding Power Pivot to Excel
- Adding data to Data Model
- Data Modelling
- Power Pivot
Data Analysis & Visualization with Power BI
INTRODUCTION TO POWER BI
- Touring the Report View (Power View)
- Touring the Data View (Power Query)
- Touring the Model View (Power Pivot)
- Starting new Instances of Power BI Desktop
- Splash Screen
- Viewing Table Relationships and Settings
- Web Authentication and Loading Tables
- Optimizing Performance with Excel Files
- Optimizing performance with Power Pivot Data Model
- Connecting to underlying Pivot Table Data
- Importing from Power Pivot Data Model
PART 2
- ETL and Power Query
- Data Shaping – Renaming Tables
- Data Shaping – Promoting the First Row
- Data Shaping – Duplicating Column/Replace Values
- Data Shaping – Removing Columns
- Data Shaping – Filtering/Sorting, etc.
PART 3
- Introduction to Enhancing Data Structure
- Enhancing Data Structure – Join Types/ Merging Queries
- Data Profiling Recap
- Introduction to Designing a Data Model
- Working with Tables
- Fact Versus Dimension
- Breaking Down Tables
- Creating Hierarchy
PART 4
- Relationships (a.k.a Cardinality)
- Creating Relationships
- Reviewing the Model Interface
- Creating Row Level Security Roles in Desktop
PART 5
- Introduction to DAX (Data Analysis Expression)
- Creating Calculated Tables
- Creating Calculated Columns – DATEDIFF
- Creating Calculated Columns – RANKX Highest
- Creating Quick Measures
- Creating Measures
- Creating Date Tables
- Time Intelligence Functions
- Importance of Variables
- Building a Measure to use in a Measure
- Building a Measure with Variables and Comments
- Other Optimization Techniques
PART 6
- Using and Formatting Drill Through Pages
- Conditional Formatting
- Accessibility Features
- Introduction to creating Dashboards
- Dashboard Guided Project
Capstone Projects
Data Visualization with Tableau
Module 1: Introduction to Data Visualization & Tableau
What is Data Visualization?
Importance of Data Visualization in Business
Introduction to Tableau Ecosystem
Tableau Desktop
Tableau Public
Tableau Server & Tableau Cloud
Use cases of Tableau across industries
Installing and setting up Tableau
Practical:
✔ Exploring Tableau interface
✔ First Tableau worksheet
Module 2: Understanding Data & Connecting Data Sources
Types of data (Structured vs Unstructured)
Understanding data formats:
Excel
CSV
Text files
Databases
Connecting Tableau to data sources
Live vs Extract connections
Understanding data types and fields
Practical:
✔ Connecting to Excel & CSV files
✔ Data preview and field configuration
Module 3: Data Preparation & Cleaning in Tableau
Data Interpreter
Renaming fields and aliases
Splitting and merging columns
Handling missing values
Pivoting data
Data filtering and sorting
Data blending vs joins
Practical:
✔ Cleaning a messy dataset
✔ Preparing data for analysis
Module 4: Core Data Visualization Concepts
Dimensions vs Measures
Discrete vs Continuous data
Understanding Marks Card
Chart types and use cases:
Bar charts
Line charts
Area charts
Pie charts
Scatter plots
Maps
Choosing the right visualization
Practical:
✔ Building multiple chart types
✔ Applying formatting and labels
Module 5: Filters, Sorting & Groups
Creating filters (dimension & measure filters)
Context filters
Top N filters
Sorting data
Creating groups and sets
Using sets for advanced analysis
Practical:
✔ Interactive filtering
✔ Creating dynamic groups
Module 6: Calculations & Table Calculations
Introduction to calculated fields
Basic calculations
Conditional logic (IF, CASE)
Aggregate vs non-aggregate calculations
Table calculations:
Running totals
Percentages
Moving averages
Date calculations
Practical:
✔ Creating KPIs using calculations
✔ Trend and growth analysis
Module 7: Parameters & Advanced Interactivity
What are parameters?
Creating and using parameters
Dynamic calculations using parameters
Parameter-driven dashboards
Using parameters for user input
Practical:
✔ Interactive dashboards with parameters
Module 8: Mapping & Geographical Analysis
Geographic data in Tableau
Working with maps:
Symbol maps
Filled maps
Custom geographic roles
Using latitude and longitude
Map layers and formatting
Practical:
✔ Sales or population map dashboard
Module 9: Dashboards & Storytelling with Data
Dashboard design best practices
Creating interactive dashboards
Using dashboard actions:
Filter actions
Highlight actions
URL actions
Building stories in Tableau
Data storytelling techniques
Practical:
✔ End-to-end business dashboard
✔ Interactive storytelling project
Module 10: Analytics & Business Intelligence Features
Trend lines
Forecasting
Clustering
Reference lines and bands
Using analytics pane
KPI dashboards
Practical:
✔ Business performance analysis dashboard
Module 11: Publishing, Sharing & Security
Publishing dashboards to Tableau Public
Tableau Server & Cloud overview
Exporting dashboards
User permissions and security
Best practices for sharing insights
Practical:
✔ Publishing final dashboards
Module 12: Real-World Projects & Capstone
Learners will complete hands-on projects based on real business scenarios such as:
Sales Performance Dashboard
Financial Analysis Dashboard
HR Analytics Dashboard
Marketing Campaign Analysis
Operations & Supply Chain Dashboard
Capstone Project:
✔ End-to-end Tableau project from raw data to executive dashboard
Capstone Project
Final capstone data analysis and visualization project using Excel and Power BI
//Take the next step and speak to our admissions team.
Ready To Start Your Tech Journey?
// Your Trusted Career Partner
Where WebCapz Grads. Get Hired
// What Our Student Are Saying
We are Trusted
We are Trusted
3,000+ Students Trained
Christian Onyebuchi,
Graduate
"The training was an eye opener on the vulnerability and inherent risk we run as an institution. The training has empowered me to effectively mitigate the noted flaws in all platforms and block all loop holes that can be exploited by hackers."
Godsreward Ejike,
Programmer
"The training has been very interesting and useful. I learned a lot from one of the world’s leading authorities on Ethical Hacking in the person of Tim Pierson. WebCapz Technologies has done very well by bringing in the best to give the best."
Onome Ogunleye,
UI/UX Designer
"Kickstarting my IT career couldn’t have been easy with WebCapz Technologies, I had the best experience with them, wonderful staffs, and ultimately, with the knowledge I acquired, I got a job of my dream. Thanks to Team WebCapz."
MIke Agada,
General Manager
"This is to testify that the training was conducted in good ethical manner, the hospitality of the host was wonderful. Nancy the Logistic officer did a good job in making us comfortable. Generally, the training is satisfactory."
Peter Goteh
Full-Stack Engineer
"It's always an awesome experience learning at WebCapz Technologies. Support is always available even at the most unimaginable hours of the day and the mentorship even after the training is of immense value. Thank you Team WebCapz."
Ruth Onyije,
Backend Developer
"I used to think that software development is meant for only science students alone, but my experience with WebCapz Technologies changed my thought cause with what I have learned, I can now build & develop software applications."
// Frequently Asked Questions
FAQs
Can I make payment in installment?
Yes, we accept installment payment. You can discuss with our course administrator on available payment plans.
Do I need to have a prior knowledge of programming before I can enroll?
No prior programming experience is required. However, you need to know how to operate the computer efficiently. Our training approach is beginner friendly, and we work on several real-world projects to help our students have a deeper understanding of each module.
Will I be given a job immediately I finish the training?
We do not guarantee job. However, we do refer our students for jobs as different organization do reach out to us to hire our students. Some of our students have gotten job through this process.
What type of Laptop is required?
Depending on your budget, Core i7, 16GB RAM with SSD is best. However, core i3 or i5 with 4GB or 8 GB RAM HDD will also work fine. It can be HP, DELL, Mac or any other brand.
Is it a physical class?
Yes, our training is physical at Ada-George, Port Harcourt. However, those outside Nigeria or living far away can join us online via zoom or Google meet. The experience is similar.
// Let's Get You Started!
Ready to Learn Digital Marketing and Build Your Tech Career?
Enroll today in the Digital Marketing Course at WebCapz Technologies and gain skills that open doors to global opportunities.
