- info@webcapz.com.ng
- Mon - Sat: 8.00 am - 6.00 pm
We are creative, ambitious and ready for challenges! Hire Our Talents
Data Analytics
// Data Analytics Training in Port Harcourt
Become A Certified
Become A Certified
Data Analyst
In this course, you will learn to use data analytics to create actionable recommendations, as well as identify and manage opportunities where data-based decisions can be used to change the way you do business. Data Analysis is an ever-evolving discipline with lots of focus on new predictive modelling techniques coupled with rich analytical tools that keep increasing our capacity to handle big data.
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?
- 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 Analytics
- 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
Business Analytics 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
Introduction to Tableau
- Why Tableau
- Tableau as a BI tool
- A walkthrough of the tableau workspace
- Data Types in Tableau
- Dimensions and Measures
- Tableau Data Sources
Creating Basic Views:
- Bar Chart
- Column Chart
- Tree Map
- Bubble Chart
- Heat Map
- Highlight Table
- Pie Chart
- Donut Chart
- Line Chart
- Area Chart
- Scatter Chart
- Box and Whisker
Intro To Tableau Functions
- Date Functions
- String Functions
- Number Functions
- Aggregate Functions
- Spatial Functions
- Type Conversion Functions
- Logical Functions
- Table Calculation Functions
Calculated Fields in Tableau
- Formatting Views
- Formatting Numbers
- Formatting Marks
- Formatting Axes and Axes titles
- Formatting Titles, etc.
Parameters
- Definition of Parameters
- Types of Parameters
- Creating an using parameters
- Demo
Level of Detail Expressions (LOD Expressions)
- Definition
- Types
- Demo
Groups and Sets
- Definition
- Demo
Geospatial Analysis
- Definition
- Spatial Functions
- Demo
Table Calculations
- Definition
- Demo
Advanced Filters
- Introduction
- Extract Filters
- Data Source Filters
- Context Filters
- Dimension Filters
- Measures Filters
- Table Calculation Filters
- Filters Cascading
Data Visualization Project
SQL
GETTING STARTED
- Overview of SQL
- Install MySQL and the Workbench tool
- Create a database and write your first query
GETTING DATA FROM A SINGLE TABLE
- The SELECT statement
- The SELECT with WHERE clause
- AND, OR & NOT operators
- IN operator
- BETWEEN operator
- LIKE operator
- ORDER BY clause
- LIMIT clause
GETTING DATA FROM MULTIPLE TABLES
- Inner join
- Self join
- Implicit join
- Outer join
- Self Outer join
- The USING clause
- Natural join
- Cross join
INSERT, UPDATE AND DELETE DATA
- Insert a row
- Insert Multiple rows
- Updating a row
- Updating Multiple rows
- Using Subqueries to Update
- Deleting rows
- Restoring the database
SUMMARIZING DATA
- Aggregate function
- The GROUP BY clause
- The HAVING clause
- The ROLLUP operator
VIEWS
- Creating views
- Droping or Altering views
- Updatable views
STORED PROCEDURES
- Stored Procedure Overview
- Creating a Stored Procedure
- Dropping a Stored Procedure
- Parameters
- Parameters with default values
- Output Parameters
- Variables
- Functions
TRIGGERS
- Viewing triggers
- Dropping triggers
- Triggers events
DATABASE DESIGNS
- What is database design ?
- Data modeling
- Primary and foreign keys
- Foreign keys constraints
- Normalization
- First, second and third normal forms
INDEXING FOR PERFORMANCE
- Indexes overview
- Creating indexes
- Viewing indexes
- Composite indexes
- Order of columns in composite indexes
SQL PROJECT
Data Analytics with Python
PYTHON AND DATA ANALYSIS
- Introduction to Data Analysis
- Understanding the
- Nature of Data and Types of Data
- When Data becomes Information and Information becomes Knowledge
- Knowledge Domains
PYTHON FUNDAMENTALS
- Python IDEs: Spyder Interface in Focus
- Data Types, Variables
- Statements, Expressions and Functions
PYTHON FOR DATA PROCESSING WITHY NUMPY
- Numpy Arrays
- Indexing
- Operations
- Advanced Topics in Numpy.
GETTING DATA
- CSV Files
- Online Data Sources
- Internal Data Sources
DATABASE MANIPULATION WITH PANDA
- Series
- Dataframes
- Operations
- Merging, Grouping and Joining
DATA VISUALIZATION WITH MATPLOTLIB AND SEABORN
- Scatterplot
- Bar Chart and
- Histogram
- Pie Chart
- Heat Map
DATA ANALYSIS WITH PYTHON
- Use Cases
- Storytelling and representation
Data Analytics Capstone Project
Final capstone data analysis and visualization project using Data Analytics Tools.
//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.
