1Typically 2 to 3 days
Excel for analysis
Everyone who works with data
- Cleaning and structuring data
- Lookups, logical and date functions
- PivotTables and charts
- Power Query basics
Professional training
From spreadsheets to decisions: data skills your team will actually use
Hands-on training in Excel, SQL, Power BI and Python. Participants clean real data, analyse it and build dashboards that answer business questions, and they keep everything they build.
Professional training
Data Analytics Training
- Tools
- Excel, SQL, Power BI, Python
- Levels
- Beginner to intermediate
- Formats
- Bootcamp, in-house or live online
- Every track ends with
- A capstone dashboard or analysis
Who it’s for
- Analysts and officers who spend their days in spreadsheets
- Finance, sales, operations and HR teams who report to management
- Graduates and career changers moving into data roles
- Managers who need to ask better questions of their data
Outcomes
What participants will be able to do
- 01Clean, combine and reshape messy data reliably
- 02Choose the right analysis for a business question
- 03Build interactive dashboards in Power BI
- 04Query databases with SQL
- 05Automate repetitive analysis with Python
- 06Present findings clearly to decision-makers
Levels and tracks
Learning tracks
Start where your team is today. Tracks can be taken on their own or as a full pathway.
2Typically 3 days
Business intelligence with Power BI
Analysts and reporting teams
- Getting and transforming data
- Data modelling and relationships
- DAX measures
- Dashboards, publishing and sharing
3Typically 2 days
SQL for analysts
Analysts working with databases
- SELECT, filtering and sorting
- Joins and aggregations
- Subqueries and views
- Writing queries for reports
4Typically 4 to 5 days
Python for data analysis
Analysts ready to automate
- Python and Jupyter essentials
- pandas for cleaning and analysis
- Visualisation
- Automating recurring reports
Curriculum
Core curriculum
Module 1
Data thinking
- Framing the business question
- KPIs and metrics that matter
- Types of data and their traps
Module 2
Getting and cleaning data
- Importing from files and systems
- Handling blanks, duplicates and errors
- Reshaping and combining tables
Module 3
Analysis
- Summaries and aggregations
- Trends, comparisons and segments
- Basic statistics without the jargon
Module 4
Visualisation and storytelling
- Choosing the right chart
- Designing a clear dashboard
- Writing the headline insight
Module 5
Responsible data
- Personal data and the Nigeria Data Protection Act
- Access control and sharing
- Checking your own work
Module 6
Capstone
- A real question, start to finish
- Peer review and feedback
- Presentation to the group
Our approach
How we teach data
Business first
We start from the questions your organisation asks, then teach the tools to answer them.
Realistic data
Exercises use realistic Nigerian business data: sales, finance, operations and HR. In-house courses can use your own data.
Capstone projects
Every track ends with a dashboard or analysis participants build and present themselves.
Data protection built in
Handling personal data responsibly is part of the course, not an afterthought.
Formats
Formats
Bootcamp cohorts
Intensive programmes for individuals and career changers, with a capstone project.
In-house team training
Tailored to your systems, data and reports, at your premises or online.
Live online
Instructor-led virtual sessions with hands-on labs and recordings of demonstrations.
Leadership briefing
A focused session for managers on reading dashboards, asking better questions and the role of AI.
Tools covered
- Microsoft Excel and Power Query
- Power BI Desktop and Service
- SQL (PostgreSQL, MySQL or SQL Server)
- Python, pandas and Jupyter
A Windows laptop is recommended for Power BI Desktop. Mac users can join using the Power BI web service or a virtual machine.
What you receive
- Course materials and practice datasets
- Your capstone dashboard or analysis
- Reusable templates and query snippets
- Certificate of completion from Flexschool Technologies
FAQ
Frequently asked questions
Can’t find what you need? Ask us directly.
Do I need a maths or programming background?
No. Excel for analysis starts from everyday spreadsheet skills. Python for data analysis assumes you are comfortable with Excel and ready to learn some code.
Which track should we start with?
Most teams start with Excel for analysis, then Power BI. Teams with databases add SQL, and those who repeat the same analysis every week benefit most from Python. We can run a short skills check to recommend a path.
Can you train us on our own data?
Yes, for in-house courses, under a confidentiality agreement. We help you anonymise personal data before it is used in the classroom.
Will we get a certificate?
Yes, a certificate of completion from Flexschool Technologies. It is not a vendor certification such as a Microsoft exam.
What happens after the course?
We offer follow-up clinics and can help you build or review your first production dashboards.
Related services
All servicesProfessional trainingProject Scheduling Training with Primavera P6 & Microsoft ProjectHands-on Primavera P6 and Microsoft Project training for planners, engineers and project managers, from fundamentals to schedule review.Learn more Agentic AIAgentic CodingSoftware built with AI coding agents under senior-engineer control, plus coaching and guardrails for teams adopting the same way of working.Learn more
Turn your data into decisions
Tell us about your team, your tools and the reports you need. We will recommend the right track.