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 202316
- 5.2Study Materials30 Weeks
- 5.3Study Materials 218 Weeks
- 5.4Classroom: Introduction Day and Class of Saturday 25th of Feb, 20236 Hours
- 5.5Classroom: Sunday Class of 26th of Feb, 20236 Hours
- 5.6Classroom: Thursday Class of March 2, 20233 Hours
- 5.7Classroom: Saturday Class of March 4th, 20236 Hours
- 5.8Classroom: Sunday Class of March 5, 20235 Hours
- 5.9Classroom: Thursday Class of March 9, 20232 Hours
- 5.10Classroom: Saturday Class of March 11, 20236 Hours
- 5.11Classroom: Sunday Class of March 12, 20236 Hours
- 5.12Classroom: Thursday Class of March 16, 20232 Hours
- 5.13Classroom: Saturday Class of March 18, 20236 Hours
- 5.14Classroom: Sunday Class of March 19, 20236 Hours
- 5.15Classroom: Class of Thursday 23rd of March, 20232 Hours
- 5.16Classroom: Saturday Class of March 25, 20236 Hours
- 5.17Sunday Class of March 26, 20236 Hours
- Real Class Sessions Intermediate Excel 202314
- 6.1Classroom: Sunday Class of March 26, 20236 Hours
- 6.2Classroom: Thursday Class of March 30, 20232 Hours
- 6.3Classroom: Saturday Class of April 1, 20236 Hours
- 6.4Classroom: Sunday Class of April 2, 20236 Hours
- 6.5Classroom: Saturday Class of April 8, 20235 Hours
- 6.6Classroom: Sunday Class of April 9, 20235 Hours
- 6.7Classroom: Thursday Class of April 13, 20232 Hours
- 6.8Classroom: Saturday Class of April 15, 20235 Hours
- 6.9Classroom: Sunday Class of April 16, 20235 Hours
- 6.10Classroom: Thursday Class of April 20, 20232 Hours
- 6.11Classroom: Saturday Class of April 22, 20235 Hours
- 6.12Classroom: Sunday Class of April 23, 20236 Hours
- 6.13Classroom: Class of Thursday 27th of March, 20232 Hours
- 6.14Classroom: Saturday Class of April 29, 20235 Hours
- Real Class Sessions Advanced Excel 20239
- 7.1Classroom: Sunday Class of April 30, 20236 Hours
- 7.2Classroom: Thursday Class of May 04, 20232 Hours
- 7.3Classroom: Saturday Class of May 06, 20236 Hours
- 7.4Classroom: Sunday Class of May 07, 20236 Hours
- 7.5Classroom: Thursday Class of May 11, 20231 Hour
- 7.6Classroom: Saturday Class of May 13, 20235 Hours
- 7.7Classroom: Sunday Class of May 14, 20235 Hours
- 7.8Classroom: Thursday Class of May 18, 20232 Hours
- 7.9Classroom: 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.1Classroom: Thursday Class of June 29, 20232 Hours
- 9.2Classroom: Saturday Class of July 01, 20235 Hours
- 9.3Classroom: Sunday Class of July 02, 20236 Hours
- 9.4Classroom: Thursday Class of July 6, 20232 Hours
- 9.5Classroom: Saturday Class of July 08, 20236 Hours
- 9.6Classroom: Sunday Class of July 09, 20236 Hours
- 9.7Classroom: Thursday Class of July 13, 20232 Hours
- 9.8Classroom: Saturday Class of July 15, 20236 Hours
- 9.9Classroom: Sunday Class of July 16, 20236 Hours
- 9.10Classroom: Thursday Class of July 20, 20232 Hours
- Real Class Sessions SQL 20235
- Resume and Interview Preparation1
- STUDY MATERIALS2
- ASSIGNMENTS0
- 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.1Modifying Rows, Columns, and Cells
- 22.2Change the Height and Width of rows and columns in your worksheet
- 22.3Wrap text and Line Breaks in cells
- 22.4Merge Cells in Excel
- 22.5Centering Across Selection
- 22.6Insert, Move, Hide/Unhide, and Copy a whole worksheet Name, Rename your worksheet
- 22.7Delete your Worksheet(s)
- DATA FORMATTING12
- 23.1What “formatting” in excel mean
- 23.2Importance of formatting excel worksheets and cells
- 23.3Ways to Format Cells within Excel
- 23.4Styling Elements
- 23.5Data Alignment within the Cell(s)
- 23.6Shading, Background Colors, and Text colors in the cell
- 23.7Format Painter – Formatting made Faster
- 23.8Borders of the Cell(s)
- 23.9Formatting numbers. Categories in the number section
- 23.10Data turned into Table
- 23.11How to Use Conditional Formatting
- 23.12Custom 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.1Understanding List Structure – what to do and avoid doing
- 30.2Multi-Level Excel Data Sorting
- 30.3Sorting Dates Data
- 30.4Using Sorting to Delete blank rows,
- 30.5Custom Sorting in Excel
- 30.6Single-Level Excel Data Sorting
- 30.7Filter – What is a Filter in Excel?
- 30.8Filtering Data with the AutoFilter
- 30.9Using the Advanced Filter
- 30.10Filtering Based on a Single Condition
- 30.11Filtering Based on Multiple Conditions and Columns
- EXCEL LIST FUNCTIONS6
- EXCEL DATA VALIDATION10
- 32.1Understanding Data Validation – what is this about? When is data validation useful?
- 32.2How to Validate Data in Excel
- 32.3Data Validation Examples
- 32.4How to Edit Data Validation in Excel
- 32.5How to Copy Data Validation rules to other cells in Excel
- 32.6Finding Cells with Data Validation
- 32.7How to Remove Data Validation
- 32.8How to Validate an Entry based on another cell
- 32.9How to Create your very own Meaningful Error Message(s)
- 32.10Data Validation Tips
- IMPORTING AND EXPORTING DATA7
- PIVOT TABLES9
- 34.1Understanding Pivot Tables? Why Pivot Tables? Benefits
- 34.2Inserting Pivot Table
- 34.3Formatting Data with Pivot Tables
- 34.4Sorting Data with Pivot Tables
- 34.5Filtering Data with Pivot Tables
- 34.6Grouping Data with Pivot Tables
- 34.7Refreshing Pivot Tables
- 34.8How to Design and Improve pivot table
- 34.9Deleting an Excel Pivot Table
- POWER PIVOT TOOLS - DATA MODELING IN EXCEL AND POWERFUL DATA ANALYSIS9
- 35.1Introduction to Excel Power Pivot
- 35.2The power behind the Power Pivot Tool – Power Pivot vs Basic Excel
- 35.3How to get and Install the Power Pivot Add-in
- 35.4Importing CSV files to the Data Mode
- 35.5Viewing the Data Model in Power Pivot
- 35.6Create Relationships between the tables
- 35.7Create a PivotTable from Data Models
- 35.8Power Pivot KPIs
- 35.9Data 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.1Introduction to Tableau, Data Visualization, and Analytics
- 44.2Components of Tableau
- 44.3Download Tableau Desktop. Installation of the Software
- 44.4Getting started – Data Visualization using Tableau
- 44.5Why use Tableau? What makes it attractive?
- 44.6Connecting to various data sources
- 44.7Shelves and cards in detail
- 44.8Functions in Tableau
- 44.9Creating basic Charts and reports
- 44.10Table and Cross Tab reports
- 44.11Annotations
- 44.12Creating Calculated Columns
- Advancing with Tableau - Advanced Calculations and Functions Improving Dashboards6
- IMPROVE DASHBOARDS7
- POWER BI SECTION 118
- 47.1Introduction to Power BI
- 47.2Power BI Desktop Installation
- 47.3Different types of charts
- 47.4Basic Charts in Power BI
- 47.5Overview of Power BI Desktop
- 47.6How to Create a Map in Power BI
- 47.7Table and Matrix
- 47.8Subtotal and Total in Matrix
- 47.9Other Charts in Power BI
- 47.10Cards and Filters
- 47.11Slicers
- 47.12How to build Power BI Dashboards
- 47.13How Data types and Data Sets work
- 47.14Power BI Query Editor
- 47.15DAX Series
- 47.16Demo on Generating a Power BI Report
- 47.17Power Query
- 47.18Data Transformations Using Power Queries
- POWER BI CURRICULUM SECTION 214
- 48.1Renaming Tables
- 48.2Promoting the First Row
- 48.3Data Shaping
- 48.4Introduction to Enhancing Data Structure
- 48.5Introduction to Designing a Data Model
- 48.6Working with Tables
- 48.7Fact vs Dimension
- 48.8Breaking Down Tables
- 48.9Creating Hierarchy
- 48.10Relationships aka Cardinality
- 48.11Creating Relationships
- 48.12Reviewing the Model Interface
- 48.13Creating RLS Roles in Desktop
- 48.14Assigning 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!