Start Date: August 2025
Want to transition from beginner to advanced level in Data Analysis and earn as high as $100k per year without the need to delve into coding?
Then this is the program for you! The advantage is that you gain more than you spend. You graduate with zero student loans and take on a career that can give you back what you invested in learning in as little as one month or less? You do not have to have a science background to go into this field of Information Technology. Willing and ready to learn in order to succeed in one of the markets that defies inflation?
Then we welcome to the best online program on Data Analysis and Data Visualization. Data analysis is a process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, and is used in different business, science, and social science domains. This course is a complete package for everyone wanting to pursue a career in data analysis and gives you complete knowledge from basics to advanced level on Excel. You will learn to create interactive dashboards using Excel, Power BI as well as Tableau.
In 12 weeks, you can become a Data Analyst with this boot camp taught by Instructor Faithful Okere, an American Data Engineer/Analyst that can set you into a career of analyzing data for several industries worldwide. At the end of this program, you will be an expert at Microsoft Excel, Power Bi and Tableau which equips you to handle working for corporations or working for yourself as a consultant or setting up your own firm. Many of our graduates have gone on to become Market Analyst, HR Analyst, Trade Analyst, Reporting Analyst, Governance Analyst and more. An entry level analyst who has just completed just the Excel part of the course can go on to earn minimum of $25/30 an hour. They can earn as high as $50 per hour entry level. A mid-level data analyst makes as low as $40 hour and as high as $65 an hour. A senior level Analyst can earn as low as $50 an hour $90 an hour. It all depends on a combination of factors like experience and other tools you know how to utilize in carrying out your work.
A data analyst has a great potential to grow and advance or diversify deeper into the information technology field like AWS, Cyber Security Analysts, Solutions Architecture, DevOps, Business Analysis, Software Engineers, Full Stack Developers. Many have gone on to become Data Engineers and scientist who make over $100k per year as minimum pay. Note that these figures are expressly for the American market. Each country pay vary. Data Analyst can decide to choose jobs that are work from home or hybrid. Some opt for in-office jobs. A data analyst usually works alongside a team that comprises of software engineers, project managers, product managers, scrum master and more. Data analysis is projected to grow over the next 25 years in demand as every industry need to keep and analyze data. It is also one of the fields in I.T that does not require Coding to succeed. You can still earn Six figures without coding.
Curriculum
- 48 Sections
- 292 Lessons
- 40 Weeks
- Orientation Guide1
- Graduation Ceremony1
- MID TERM TEST2
- Final Exams4
- Real Class Sessions Beginner Excel 202319
- 5.0Week 5 Assignment, March 25 Delivery7 Days
- 5.1Assignment for Week 3, March 11 Delivery7 Days
- 5.2Assignment: Saturday 4th of March Delivery, 202310 Days
- 5.3Study Materials30 Weeks
- 5.4Study Materials 218 Weeks
- 5.5Classroom: Introduction Day and Class of Saturday 25th of Feb, 20236 Hours
- 5.6Classroom: Sunday Class of 26th of Feb, 20236 Hours
- 5.7Classroom: Thursday Class of March 2, 20233 Hours
- 5.8Classroom: Saturday Class of March 4th, 20236 Hours
- 5.9Classroom: Sunday Class of March 5, 20235 Hours
- 5.10Classroom: Thursday Class of March 9, 20232 Hours
- 5.11Classroom: Saturday Class of March 11, 20236 Hours
- 5.12Classroom: Sunday Class of March 12, 20236 Hours
- 5.13Classroom: Thursday Class of March 16, 20232 Hours
- 5.14Classroom: Saturday Class of March 18, 20236 Hours
- 5.15Classroom: Sunday Class of March 19, 20236 Hours
- 5.16Classroom: Class of Thursday 23rd of March, 20232 Hours
- 5.17Classroom: Saturday Class of March 25, 20236 Hours
- 5.18Sunday Class of March 26, 20236 Hours
- Real Class Sessions Intermediate Excel 202314
- 6.0Classroom: Sunday Class of March 26, 20236 Hours
- 6.1Classroom: Thursday Class of March 30, 20232 Hours
- 6.2Classroom: Saturday Class of April 1, 20236 Hours
- 6.3Classroom: Sunday Class of April 2, 20236 Hours
- 6.4Classroom: Saturday Class of April 8, 20235 Hours
- 6.5Classroom: Sunday Class of April 9, 20235 Hours
- 6.6Classroom: Thursday Class of April 13, 20232 Hours
- 6.7Classroom: Saturday Class of April 15, 20235 Hours
- 6.8Classroom: Sunday Class of April 16, 20235 Hours
- 6.9Classroom: Thursday Class of April 20, 20232 Hours
- 6.10Classroom: Saturday Class of April 22, 20235 Hours
- 6.11Classroom: Sunday Class of April 23, 20236 Hours
- 6.12Classroom: Class of Thursday 27th of March, 20232 Hours
- 6.13Classroom: Saturday Class of April 29, 20235 Hours
- Real Class Sessions Advanced Excel 20239
- 7.0Classroom: Sunday Class of April 30, 20236 Hours
- 7.1Classroom: Thursday Class of May 04, 20232 Hours
- 7.2Classroom: Saturday Class of May 06, 20236 Hours
- 7.3Classroom: Sunday Class of May 07, 20236 Hours
- 7.4Classroom: Thursday Class of May 11, 20231 Hour
- 7.5Classroom: Saturday Class of May 13, 20235 Hours
- 7.6Classroom: Sunday Class of May 14, 20235 Hours
- 7.7Classroom: Thursday Class of May 18, 20232 Hours
- 7.8Classroom: Saturday Class of May 20, 20235 Hours
- Real Class Sessions Power BI 202313
- 8.1Classroom: Sunday Class of May 21, 20235 Hours
- 8.2Classroom: Thursday Class of June 1, 20232 Hours
- 8.3Classroom: Saturday Class of June 3, 20236 Hours
- 8.4Classroom: Sunday Class of June 4, 20236 Hours
- 8.5Classroom: Thursday Class of June 8, 20232 Hours
- 8.6Classroom: Saturday Class of June 10, 20236 Hours
- 8.7Classroom: Sunday Class of June 11, 20236 Hours
- 8.8Classroom: Thursday Class of June 15, 20232 Hours
- 8.9Classroom: Saturday Class of June 17, 20236 Hours
- 8.10Classroom: Sunday Class of June 18, 20236 Hours
- 8.11Classroom: Thursday Class of June 22, 20232 Hours
- 8.12Classroom: Saturday Class of June 24, 20236 Hours
- 8.13Classroom: Sunday Class of June 25, 20236 Hours
- Real Class Sessions Tableau 202310
- 9.0Classroom: Thursday Class of June 29, 20232 Hours
- 9.1Classroom: Saturday Class of July 01, 20235 Hours
- 9.2Classroom: Sunday Class of July 02, 20236 Hours
- 9.3Classroom: Thursday Class of July 6, 20232 Hours
- 9.4Classroom: Saturday Class of July 08, 20236 Hours
- 9.5Classroom: Sunday Class of July 09, 20236 Hours
- 9.6Classroom: Thursday Class of July 13, 20232 Hours
- 9.7Classroom: Saturday Class of July 15, 20236 Hours
- 9.8Classroom: Sunday Class of July 16, 20236 Hours
- 9.9Classroom: Thursday Class of July 20, 20232 Hours
- Real Class Sessions SQL 20235
- Resume and Interview Preparation1
- STUDY MATERIALS2
- ASSIGNMENTS2
- Real Practice Group Session3
- INTRODUCTION TO EXCEL5
- UNDERSTANDING EXCEL'S INTERFACE/FEATURES6
- BASIC TERMINOLOGIES USED IN EXCEL13
- FUNDAMENTALS TO DATA ENTRY IN EXCEL2
- BASIC EXCEL FORMULAE6
- REFERENCES IN EXCEL FORMULAS3
- FUNCTIONS IN EXCEL5
- MODIFYING YOUR WORKSHEET IN EXCEL7
- 22.0Modifying Rows, Columns, and Cells
- 22.1Change the Height and Width of rows and columns in your worksheet
- 22.2Wrap text and Line Breaks in cells
- 22.3Merge Cells in Excel
- 22.4Centering Across Selection
- 22.5Insert, Move, Hide/Unhide, and Copy a whole worksheet Name, Rename your worksheet
- 22.6Delete your Worksheet(s)
- DATA FORMATTING12
- 23.0What “formatting” in excel mean
- 23.1Importance of formatting excel worksheets and cells
- 23.2Ways to Format Cells within Excel
- 23.3Styling Elements
- 23.4Data Alignment within the Cell(s)
- 23.5Shading, Background Colors, and Text colors in the cell
- 23.6Format Painter – Formatting made Faster
- 23.7Borders of the Cell(s)
- 23.8Formatting numbers. Categories in the number section
- 23.9Data turned into Table
- 23.10How to Use Conditional Formatting
- 23.11Custom theme for a new workbook
- ADVANCED FORMATTING IN EXCEL5
- BASIC DATA VISUALIZATION TOOLS IN EXCEL7
- SECURITY AND PROTECTION IN EXCEL5
- HOW TO PRINT YOUR WORKSHEET6
- ALL ABOUT EXCEL TEMPLATES5
- BONUS - SECRET TIPS/TRICKS TO BECOMING AN EXCEL PROFESSIONAL0
- MICROSOFT EXCEL INTERMEDIATE - EXCEL LIST11
- 30.0Understanding List Structure – what to do and avoid doing
- 30.1Multi-Level Excel Data Sorting
- 30.2Sorting Dates Data
- 30.3Using Sorting to Delete blank rows,
- 30.4Custom Sorting in Excel
- 30.5Single-Level Excel Data Sorting
- 30.6Filter – What is a Filter in Excel?
- 30.7Filtering Data with the AutoFilter
- 30.8Using the Advanced Filter
- 30.9Filtering Based on a Single Condition
- 30.10Filtering Based on Multiple Conditions and Columns
- EXCEL LIST FUNCTIONS6
- EXCEL DATA VALIDATION10
- 32.0Understanding Data Validation – what is this about? When is data validation useful?
- 32.1How to Validate Data in Excel
- 32.2Data Validation Examples
- 32.3How to Edit Data Validation in Excel
- 32.4How to Copy Data Validation rules to other cells in Excel
- 32.5Finding Cells with Data Validation
- 32.6How to Remove Data Validation
- 32.7How to Validate an Entry based on another cell
- 32.8How to Create your very own Meaningful Error Message(s)
- 32.9Data Validation Tips
- IMPORTING AND EXPORTING DATA7
- PIVOT TABLES9
- 34.0Understanding Pivot Tables? Why Pivot Tables? Benefits
- 34.1Inserting Pivot Table
- 34.2Formatting Data with Pivot Tables
- 34.3Sorting Data with Pivot Tables
- 34.4Filtering Data with Pivot Tables
- 34.5Grouping Data with Pivot Tables
- 34.6Refreshing Pivot Tables
- 34.7How to Design and Improve pivot table
- 34.8Deleting an Excel Pivot Table
- POWER PIVOT TOOLS - DATA MODELING IN EXCEL AND POWERFUL DATA ANALYSIS9
- 35.0Introduction to Excel Power Pivot
- 35.1The power behind the Power Pivot Tool – Power Pivot vs Basic Excel
- 35.2How to get and Install the Power Pivot Add-in
- 35.3Importing CSV files to the Data Mode
- 35.4Viewing the Data Model in Power Pivot
- 35.5Create Relationships between the tables
- 35.6Create a PivotTable from Data Models
- 35.7Power Pivot KPIs
- 35.8Data Analysis Expressions (DAX)
- USING SLICERS IN EXCEL0
- LARGE DATASETS OF EXCEL DATA4
- MICROSOFT EXCEL - ADVANCED0
- ADVANCED LOGIC AND CONDITIONAL EXCEL FUNCTIONS5
- LOOKUP FUNCTIONS IN EXCEL0
- VSTACK FUNCTION IN EXCEL0
- POWER QUERY10
- BONUS TOPICS2
- TABLEAU - BEGINNER TO ADVANCED LEVEL12
- 44.0Introduction to Tableau, Data Visualization, and Analytics
- 44.1Components of Tableau
- 44.2Download Tableau Desktop. Installation of the Software
- 44.3Getting started – Data Visualization using Tableau
- 44.4Why use Tableau? What makes it attractive?
- 44.5Connecting to various data sources
- 44.6Shelves and cards in detail
- 44.7Functions in Tableau
- 44.8Creating basic Charts and reports
- 44.9Table and Cross Tab reports
- 44.10Annotations
- 44.11Creating Calculated Columns
- Advancing with Tableau - Advanced Calculations and Functions Improving Dashboards6
- IMPROVE DASHBOARDS7
- POWER BI SECTION 118
- 47.0Introduction to Power BI
- 47.1Power BI Desktop Installation
- 47.2Different types of charts
- 47.3Basic Charts in Power BI
- 47.4Overview of Power BI Desktop
- 47.5How to Create a Map in Power BI
- 47.6Table and Matrix
- 47.7Subtotal and Total in Matrix
- 47.8Other Charts in Power BI
- 47.9Cards and Filters
- 47.10Slicers
- 47.11How to build Power BI Dashboards
- 47.12How Data types and Data Sets work
- 47.13Power BI Query Editor
- 47.14DAX Series
- 47.15Demo on Generating a Power BI Report
- 47.16Power Query
- 47.17Data Transformations Using Power Queries
- POWER BI CURRICULUM SECTION 214
- 48.0Renaming Tables
- 48.1Promoting the First Row
- 48.2Data Shaping
- 48.3Introduction to Enhancing Data Structure
- 48.4Introduction to Designing a Data Model
- 48.5Working with Tables
- 48.6Fact vs Dimension
- 48.7Breaking Down Tables
- 48.8Creating Hierarchy
- 48.9Relationships aka Cardinality
- 48.10Creating Relationships
- 48.11Reviewing the Model Interface
- 48.12Creating RLS Roles in Desktop
- 48.13Assigning Users to RLS Roles in Service
Requirements
- You don’t need a tech background
- No prior knowledge required
- Laptop or Desktop
- No MS Excel experience needed. Students will learn everything about MS Excel from scratch.
- Excel (2010 - Office 365)
- Determination and Desire to Learn new things
Features
- Take your data analysis skills from ZERO to PRO with Excel
- Transform Data into INSIGHT and INTELLIGENCE using powerful methods of analysis, techniques and tools
- Learn about basic formatting in excel
- Learn about sorting and filtering functions in excel
- Learn BEST practices for the design and setup of INTERACTIVE dashboards
- Learn advanced Excel tools like automated dashboards, scrolling charts, dynamic formats, and more
- Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
- Create a spreadsheet that allows for data input and output as well as data analysis in response to a business case that requires the use of formulas.
- Develop documentation for Excel files and devise security measures to protect the integrity of the file’s functions and design.
Target audiences
- Job-seekers
- Students and professionals who want to improve the training capabilities
- Data Analysts
- ANYONE who works with Excel on a regular basis
- Excel users who have basic skills but would like to become more proficient in data exploration and analysis
- Anyone looking to pursue a career in data analysis or business intelligence
- All Business people who want to turn data into information
- Excel users who want to take their reporting and analysis to the next level
- Small and medium-sized business owners
Please sign me in. Thank you
Hey guys! I’m in! So excited!