fbpx

Over 10 years we help companies reach their financial and branding goals. WebCapz Technologies is a values-driven technology agency dedicated.

Gallery

Contacts

No. 1 Oro-Ekpo Junction, Ada-George Road, Port Harcourt, Nigeria.

info@webcapz.com

+234 -704-000-0608

// Data Analysis Training in Port Harcourt

Get Certified As A
Data Analyst

In this course, you will get hands-on with data analysis and visualization in Advanced Excel along with equipping you with an understanding of data handling in Power BI with progression towards complex data visualization in Power BI.

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.

Our data analysis training is beginner-friendly, practical and project-based. It is designed to help participants gain mastery of different data analysis and visualization tools that are used to make informed decision. It is tailored to help you gain real-world experience that can get you a job and grow your career.

// 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?

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.

REGISTER NOW

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.

REGISTER NOW

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.

 LEARN MORE

// 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

Cleaning Data

  • Removing Duplicates
  • Removing Spaces
  • Spell check
  • Replacing blank cells
  • Using proper fonts
  • Extracting Substring or part of data

Transforming Data

  • Merging data in cells
  • Text to columns
  • Data sorting
  • Transpose data
  • Flash fill

Compiling Data

  • 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

Data Analysis

  • 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

 Preparing Dashboard

  • 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

Capstone Project

Final capstone data analysis and visualization project using Excel and Power BI

.
Duration:

2 Months

                   .

Fee:

N200,000

.
Discount Fee:

N120,000

//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
3,000+ Students Trained

Christian Onyebuchi,
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,
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,
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,
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
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,
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.

    Ready to Get Started?

    Your email address will not be published. Required fields are marked *