• Tel: 09125620273, 09064823667
  • info@lagosdataschool.com

Author Archives: Data Analysis | Data Analytics | Data Science Training in Ikeja Lagos State

Advanced-Execl-Training-in-Ikeja-Lagos-Nigeria

1. SQL for Data Analysis

The SQL (Structured Query Language) training typically provides a comprehensive overview of managing and manipulating data within relational database management systems.

Module 1: SQL Basics & Setup

  • What is a database? (RDBMS vs NoSQL)
  • Installing MySQL/PostgreSQL/SQLite
  • Tools: pgAdmin, MySQL Workbench, DBeaver
  • Tables, rows, columns, Primary/Foreign keys
  • SQL syntax conventions

Module 2: Querying and Manipulating Data

  • SELECT, WHERE, AND, OR, NOT
  • Sorting: ORDER BY
  • Limiting: LIMIT, OFFSET
  • Data types and casting
  • INSERT, UPDATE, DELETE
  • CREATE, DROP, ALTER tables

Module 3: Aggregations & Grouping

  • COUNT, SUM, AVG, MIN, MAX
  • GROUP BY and HAVING
  • Filtering aggregate results

Module 4: Joins and Subqueries

  • INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
  • Aliases and table prefixes
  • Subqueries: IN, EXISTS, NOT IN
  • Common Table Expressions (CTEs)

 

Module 5: Advanced SQL for Analytics

  • Window Functions: RANK(), ROW_NUMBER(), LEAD(), LAG()
  • Date functions: DATE_TRUNC(), EXTRACT(), INTERVAL
  • CASE logic and conditional expressions
  • Pivoting and unpivoting data
  • Working with JSON/XML data (if applicable)

Module 6: SQL + Python Integration

  • Running SQL queries in Python using pandas.read_sql()
  • Connecting databases using SQLAlchemy
  • Automating queries in data pipelines

Module 7: Real-World SQL Project

  • Data modeling for e-commerce or HR datasets
  • Writing reusable queries
  • Dashboards powered by SQL (e.g., in Power BI or Streamlit)

 

2. Power BI for Data Visualization & Reporting

Power BI training provides comprehensive instruction on transforming raw data into interactive, insightful reports and dashboards to enable data-driven decision-making.

Module 1: Data Modeling & Preparation

  • Power BI Desktop overview
  • Importing data from Excel, SQL, CSV, Web
  • Star Schema vs Snowflake Schema
  • Creating relationships between tables
  • Optimizing performance: filters, data types

Module 2: DAX (Data Analysis Expressions)

  • Basic DAX: SUM, COUNT, DISTINCTCOUNT, AVERAGE
  • Row context vs Filter context
  • CALCULATE, FILTER, ALL, VALUES
  • Time intelligence: SAMEPERIODLASTYEAR(), TOTALYTD(), DATESINPERIOD()
  • Advanced DAX: What-if parameters, dynamic measures

Module 3: Visualizations & Reports

  • Creating visualizations:
    • Bar, line, pie charts
    • Tables, matrices
    • Slicers, maps, cards
  • Custom visuals from AppSource
  • Hierarchies, drill-downs, tooltips
  • Dashboard design best practices (layout, colors, KPIs)

Module 4: Publishing & Collaboration

  • Power BI Service:
    • Workspaces, Apps, Sharing
    • Row-Level Security (RLS)
  • Scheduled data refresh
  • Power BI Mobile
  • Embed reports in websites/apps (Power BI Embedded)

Module 5: Real-World Dashboards

  • Sales & Marketing KPI Dashboard
  • Finance Dashboard (P&L, Cash Flow)
  • HR Analytics Dashboard

 

3. Excel for Data Analytics

The Advanced Excel training provides in-depth skills beyond basics, focusing on complex formulas and functions, data analysis with PivotTables, data visualization for interactive dashboards, and automation with Macros and VBA to improve efficiency and decision-making.

Module 1: Excel Basics

  • Interface, workbooks vs. worksheets
  • Cell referencing (relative, absolute)
  • Data entry, formatting (dates, numbers, text)
  • Essential functions: SUM, AVERAGE, MAX, MIN, IF, IFS

 

Module 2: Data Cleaning & Validation

  • Removing duplicates, blanks
  • TRIM(), CLEAN(), TEXT TO COLUMNS
  • Data validation (dropdowns, custom rules)
  • Conditional formatting

 

Module 3: Analysis Functions

  • Lookup functions: VLOOKUP, HLOOKUP, INDEX-MATCH, XLOOKUP
  • Logical: IF, AND, OR, NOT
  • Date & Time: TODAY(), DATEDIF(), WORKDAY(), NETWORKDAYS()
  • Statistical: COUNTIFS, SUMIFS, AVERAGEIFS, RANK

 

Module 4: PivotTables & Visualization

  • Creating PivotTables and PivotCharts
  • Calculated fields and grouping
  • Dashboard layout, slicers, dynamic ranges
  • Charts: bar, line, combo, sparklines

 

Module 5: Power Tools in Excel

  • Power Query:
    • Import, clean, transform data
    • Merge/append queries
  • Power Pivot:
    • Data modeling
    • DAX formulas in Excel
  • Intro to Macros:
    • Recording macros
    • Basic VBA for automation

Module 6: Statistical tests in Excel

  • Correlation and regression
  • Descriptive Statistics and T-tests
  • Sampling and Histogram plots
  • ANOVA and Predictive analysis
Africa Generative AI Conference

Africa Generative AI Conference 2025

The Africa Generative AI Conference is a strategic knowledge of sharing initiative powered by Lagos Data School a leading institution championing data literacy and innovation across Africa. Held bi-monthly, this event is designed to empower African professionals, entrepreneurs, and decision makers with insights into the rapidly evolving world of Generative AI and its transformational power.

This October edition brings together top AI professionals and business leaders to explore how generative AI technologies are reshaping industries from marketing and finance to education, healthcare, and logistics.

How Generative AI will impact African Businesses and the Workplace Generative AI is no longer futuristic, it’s present and potent. African businesses now have the chance to:

• Automate content creation, customer support, data analysis, and reporting.
• Build smarter products and services that meet real time customer needs.
• Bridge the talent and productivity gap with AI enhanced operations.
• Compete globally by innovating at scale, even with limited resources.
• From small enterprises to large institutions, generative AI offers a powerful tool to reimagine growth, improve efficiency, and create jobs of the future.

 

Generative AI Training in Ikeja Lagos Nigeria

BUSINESS ANALYSIS TRAINING IN IKEJA LAGOS NIGERIA

BUSINESS ANALYSIS TRAINING IN IKEJA LAGOS NIGERIA

Business analysis is the activity of facilitating change in an organization by articulating needs and offering solutions that add value to stakeholders. Business analysis enables a company to communicate its needs and the logic for change, as well as build and describe value-added solutions. Learn everything there is to know about setting company objectives, accomplishing those objectives, and solving business problems with the business analysis training in Ikeja Lagos Nigeria organized by Lagos Data School.

 

By developing a scorecard that will present the data and rank the customers according to their profit margin and sales, business analysts can study the statistical data about their customers. Business analysis displays product and sales performance to show not just customer statistics but also product and sales performance to show if locations have met or exceeded their sales goals as well as showcase data about products and historical patterns in various statistics.

 

A professional with the training and skills to perform business analysis tasks is a business analyst. Understanding organizational issues and objectives, examining demands and potential solutions, developing strategies, enacting change, and fostering stakeholder engagement are just a few of the duties of a business analyst.

 

Enrolling in this business analysis training program, which is being offered by Lagos Data School in Ikeja, Lagos, Nigeria, guarantees that students will graduate with the know-how and abilities necessary to be successful in their career as a business analyst. The objective of Lagos Data School is to broaden the participants’ skill sets during the Business Analysis course in Ikeja Lagos by exposing them to Excel, SQL, Agile scrum master, Tableau, CCBA, CBAP and more. Trainees will also gain a lot of understanding about business analysis as well as how to create interactive dashboards, work with SQL databases, and more. They will become immediately qualified to work as business analysts after completing all of the training courses.

 

Who should enroll?

Any professional, whether an experienced or new worker, may choose to pursue a career as a business analyst. An analytical attitude is basically needed to be an effective business analyst. Being a business analyst has no specific educational requirements.

 

However, people who want to become business analysts and professionals getting ready for the Certified Business Analysis Professional (CBAP) certification exam could both benefit from the business analysis training in Ikeja Lagos Nigeria.

 

Highlights of what you will learn at the business analysis training in Ikeja Lagos Nigeria:

  • Getting started with business analysis.
  • Introduction to BABOK organizational scheme.
  • Stakeholder Designs and Requirements.
  • Key Terms for the Business Analysis Core Concepts Model.
  • Approach to Business Analysis Planning.
  • Business Analysis Information Management Planning.
  • Elicitation of conduct.
  • Strategy analysis, risk evaluation and change strategy.
  • Examining performance metrics and evaluating solutions.
  • Tools and technology in business analysis.
  • Business analysis soft skills.

 

Job roles in Business Analysis

These days, there is a high demand for business analysts across many different businesses. For those who possess strong analytical abilities and desire to succeed and advance in life, a career in business analytics can be highly fascinating.

Business analysis positions pay quite well in Nigeria. Across Nigeria, business analysts are needed in the majority of industries, including tech, real estate and consulting. The following employment titles in business analysis range from entry-level to experienced positions:

  • Data Analyst.
  • Business Architect.
  • Management Consultant.
  • Business Systems Analyst.
  • Enterprise Analyst.
  • Product Manager.
  • Requirements Engineer.

 

After completing the business analysis training in Ikeja Lagos Nigeria, the Lagos Data School will award you a certificate designating you as a business analyst who is capable of performing in any business analysis capacity.

 

Project-management-Training-at-Ikeja-Lagos-Data-School

PROJECT MANAGEMENT TRAINING IN IKEJA LAGOS NIGERIA

 

Today’s workforce is largely engaged in several, frequently concurrent projects. Gaining an advantage in today’s fiercely competitive global business climate requires the capacity to deliver projects on time, on budget, and in alignment with corporate goals and objectives. Project managers should have a thorough understanding of all aspects of project management, from the fundamentals to significant experience. The goal of the project management training provided by the Lagos Data School in Ikeja, Lagos, Nigeria is to raise the bar for all trainees.

 

Project managers have a very demanding job that requires a combination of analytical thinking, excellent interpersonal skills, and organizational skills. Applying knowledge, skills, tools, and strategies to execute a project in accordance with predetermined specifications is the practice of project management. The key to understanding project management is to recognize the issue, develop a strategy to address it, and then carry out that strategy up until the issue is resolved. Even though it can seem straightforward, each step of the procedure involves a lot of work..

 

Although this program is open to everyone, those with project management expertise across a variety of industries, professionals in a workforce pursuing a project-related job, employment, or industry, are its ideal candidates. This training is appropriate for those who also wish to obtain their PMP certification. Trainees will be prepared for the PMP through the project management training in Ikeja, Lagos, Nigeria. Project Management Professional, or PMP, is the most significant certification recognized in the industry for project managers. because it gives you the flexibility to work in any industry and in any type of setting. Project managers with this accreditation also have a higher earning potential than project managers without it.

 

What will be taught at the project management training in Ikeja Lagos Nigeria:

  • Introduction to the essential building blocks of project management, its operating environment and responsibilities of managers.
  • Project planning including the creation of project charter and strategies for monitoring project work.
  • Communication procedures in projects.
  • Management of project procurements, costs and risks related to projects.
  • Project stakeholders expectations and requirements management.
  • Timely scheduling for project activities.
  • Project management lifecycle from planning to closure of projects.
  • Software for effective compilation, monitoring and reporting of project progress.
  • Divers methodologies in managing projects.

 

What makes project management crucial?

  • Risk identification and planning.
  • Speculated approach to project execution.
  • Proper financial planning.
  • Effective decision making process in every project phase.

 

Duties of Project Managers

Project managers must have a thorough understanding of project management because they are in charge of the planning, carrying out, monitoring, controlling, and finishing of projects.

  1. Project planning: Project managers are in charge of outlining the most practical course of action for the project. The project scope, timeline, and budget must all be included in the plan. At the project management training in Ikeja Lagos Nigeria by Lagos Data School, trainees will also learn to choose the appropriate instruments for a project  task.
  2. Team formation: Finding the right team is essential to the fundamentals of project management. Depending on the size of the initiative and the tasks required to finish the project, each project team will be unique. Project managers ensure that their team is aware of the precise duties and due dates for each phase of the project.
  3. Budget and schedule management: The ability to create a project budget and manage costs is essential for success because most projects will involve some charges. Just like managing the budget, keeping things on schedule is a project manager’s responsibility. This ensures that the team sticks to the estimated completion dates.
  4. Project intermediary: Project managers are expected to keep positive relationships and open lines of communication with stakeholders who can both help remove obstacles and empower their team. On completion of a project, the project manager must turn in to the team succeeding the completed project.
  5. Process logging and reporting: projects are kept track of by the reports given on its procedure. This is necessary to avoid mistakes that occurred in previous project activities. At the project management training in Ikeja, Lagos, Nigeria, provided by the Lagos Data School, participants will learn the appropriate formatting for documenting project procedures.

 

Enroll today at Lagos Data School!

 

web-development-training-at-ikeja-lagos-data-school

WEBSITE DEVELOPMENT TRAINING IN IKEJA LAGOS NIGERIA

Building and maintaining websites is known as website development also called ‘Web Development”. It is the work that is done behind the scenes to make a website seem attractive, run quickly, and deliver a positive user experience. The Lagos Data School is offering hands-on website development training in Ikeja, Lagos, Nigeria that will prepare you to create beautiful websites. Attendees will have group learning opportunities in class, individualized coaching, and a project deployment phase to demonstrate the abilities they have learned during the program.

 

Want to improve your chances of getting the job or shift careers? One of the skills taught at Lagos Data School in Ikeja, Lagos, Nigeria, that will prepare you for your objectives is website development. Note that anybody and everyone, regardless of proficiency level or training goal, is welcome to enroll in Lagos Data School’s website development training in Ikeja, Lagos, Nigeria. With the right digital abilities as a web developer, you may work from anywhere at your own speed and in a pleasant environment. Lagos Data School have designed the website development training to provide you the knowledge and abilities you need to become pertinent.

 

Frontend and Backend Development

Website development includes frontend development and backend development. A web developer is a programmer who creates client-server web applications. The layout, design, and interaction of a website using HTML, CSS, and JavaScript are the responsibility of a frontend web developer. The frontend developer creates a number of programs to bind and structure the elements, make them seem appealing, and provide interaction, bringing the website’s visual component, menus, and text together accessible from a browser.

 

The backend developer designs what happens in the background. The frontend wouldn’t exist without this side because it is saved here. The backend developer makes use of software to ensure that the server, the application, and the database all function together without any issues using a variety of server-side languages, such as Python and PHP.

 

While a full-stack developer oversees both the frontend and the backend of a website and needs to be knowledgeable about every aspect of web operation to comprehend how the client and server sides will work together. The fact that there is more to study means that it will take longer to acquire this level of skill.

 

You can start with HTML and CSS before getting your hands dirty with various projects. Another excellent strategy to advance your website development abilities is to join a developer community.

 

Technologies in Website Development

Web developers, or “devs,” accomplish this utilizing a number of coding languages. They use different languages based on the tasks being completed and the platforms used. The following technologies will be covered in the website creation training in Ikeja, Lagos, Nigeria:

  • HTML: HyperText Markup Language, sometimes known as HTML, is the industry-standard markup language for texts intended to be viewed in a web browser.
  • CSS: Cascading Style Sheets (CSS) is a style sheet language that is used to describe how a document that was produced in a markup language, such HTML or XML, is presented. To make your website seem appealing, you will learn about flexbox, the box model, and other techniques.
  • JavaScript: Web pages will become more interactive using JavaScript. Functions, arrays, the document object model (DOM), and javascript libraries will all be covered.
  • Git: Git is a version control tool that is typically employed in software development to manage source code.
  • PHP: PHP is one of the most popular open source scripting languages for creating dynamic web pages and web applications. The scripts are simple to use, straightforward to download, and run on a server. It is suitable for beginners.

 

Frameworks in Website Development

A set of resources and tools known as a web development framework is used by web developers to build and maintain websites, online services, and web applications.

For Backend development, they include:

  • Laravel
  • Django
  • ExpressJS
  • Spring
  • Ruby on Rails

For Frontend development, they include:

  • AngularJS
  • VueJS
  • Ember
  • Backbone
  • React

Other frameworks include; JQuery and Bootstrap.

 

Career opportunities in Website Development

Web development is a good career choice because it is highly sought after and pays well.  It is one of the most easily accessible higher-paying fields because it does not require a typical university degree to qualify.

Any of the following are viable career options: Application developer, Multimedia programmer, SEO expert, Frontend developer, Backend developer, User experience(UX) researcher, Web content creator and Game developer.

 

After completing the website development training provided by Lagos Data School in Ikeja, Lagos, Nigeria, you can be sure to acquire one of these jobs. It is important to emphasize that you will need additional abilities in order to enjoy the program and give it your best effort. These talents include strong creative ability, excellent problem-solving skills, outstanding communication skills, and numeracy skills.

 

Hi, How Can We Help You?
Welcome To
Lagos Data School

Artificial Intelligence (AI), Machine Learning and Robotics Programmes Are Now Available!!!

Enroll Now!

Thank You
100% secure website.