Data analysis is the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
Program
DATA ANALYSIS WITH EXCEL
What is Data Analysis?
Excel Pro Tips for Power Users
Advanced Excel Formulas & Functions
Structuring Source Data for Analysis in Excel
Excel tables
Advantage of Excel tables over regular ranges
Filter, sort and see totals
Use tables to add columns to the existing data in the Excel table
Raw data structure in Excel
Design & formatting options
Sorting, filtering, & grouping tools
Calculated fields, items & values
Interactive Excel dashboards
PIVOT TABLES
Why Pivot Tables?
Create pivot tables
Data Analysis with Excel PivotTables
Use pivot tables and pivot charts to create dashboards
Connect multiple slicers to the pivot tables
Configuring pivot table layouts & styles
Pivot Table layouts & styles
Pivot Charts, slicers & timelines
USING PIVOT TABLES FOR ADVANCED CALCULATIONS
The full power of pivot tables
Filter pivot table data to achieve interesting subsets of the data
Apply calculated fields with pivot tables
Calculate profitability and find anomalies
AGGREGATE DATA
Use formulas to aggregate data
Aggregate data as an alternative to pivot tables
Flexible reporting layouts
Pivot charts using more than one table
DATA ANALYSIS IN EXCEL USING TOOLS
Set the lab environment up with Office applications
Data analysis in Excel using tools:
o pivot tables
o pivot charts and slicers
Excel data models
Power Pivot add-in
DAX expressions for calculated columns and measures
QUERIES
What are the queries?
Power Query for Excel 2010 and 2013
Excel data model built from a single flat table
Import multiple tables from a SQL database
Create an Excel data model using imported data
Create a collated result with data from text-files and data from a SQL
database
Up & running with Power BI Desktop
Publishing to Power BI Service
SQL database analysis for beginners
DATA FILTERS & MEASURES
How to establish measures to calculate each cell
Filter context for calculation
DAX functions
Enhanced queries to import data from a formatted Excel sheet
Queries beyond the standard user interface
DATA VISUALISATIONS
Data visualisations in Excel
Cube functions for year-over-year comparisons
Create timelines, hierarchies, and slicers
Excel working together with Power BI
Excel workbooks with Power BI service
Excel on the mobile platform
CASE STUDIES
capstone projects
Training Fees
150,000
Early Birds
127,500
Offer ends 22nd February, 2025
We offer both physical and online classes. Please note that certain courses, such as Data
Science/Analysis, are currently only available as physical classes.
This course is ideal for children aged 6-12 who are interested in learning how to code. It’s
perfect for beginners with no prior coding experience.
No prior coding experience is necessary. Basic reading and math skills are helpful. A
curiosity about technology and a willingness to learn are the most important prerequisites.
Yes, upon successful completion, you will receive a certificate that you can add to your
resume and LinkedIn profile to showcase your skills to potential employers.
Children will have access to instructor-led sessions, interactive lessons, a supportive
community, and opportunities for 1:1 guidance and feedback on their projects.
The course helps children develop critical thinking, problem-solving, and logical reasoning
skills. It fosters creativity, encourages teamwork, and provides a foundation for future
learning in technology and computer science.
To enroll, visit our course registration page, fill out the application form, and follow the
instructions to complete your enrollment. If you have any questions, our support team is
here to help.
Student’s Feedback
Delu Olasunmbo Natiq
Works at Aledoy Solutions Limited
My experience at Aledoy Academy has been wonderful since I joined as an intern. The company's focus on innovation and creativity, along with seamless collaboration between UI/UX designers, frontend, and backend developers, has been a great learning opportunity.
Gloria Nwankwo
Works at Aledoy Solutions Limited
Attending the UI/UX design course at Aledoy Academy was transformative. The vibrant, supportive environment and hands-on projects deepened my skills, covering everything from user research to prototyping. I highly recommend registering for the next bootcamp!
Alao Oluwamurewa
Works at Nazza Tech
Aledoy Academy provides comprehensive training to prepare you for a tech career, covering technical skills, workplace dynamics, and team communication.
Alabi Olayinka Roqeeb
Works at NYSC
Aledoy Academy offers a supportive learning environment with up-to-date resources essential for practical courses. Knowledgeable and approachable instructors enhance the learning experience, making the academy an excellent choice for aspiring developers.
Gloria Nwankwo
Works at Aledoy Solutions Limited
Attending the UI/UX design course at Aledoy Academy was transformative. The vibrant, supportive environment and hands-on projects deepened my skills, covering everything from user research to prototyping. I highly recommend registering for the next bootcamp!
Valerian Pedro Adimike
What sets Aledoy Academy apart is its top-tier instructors—industry experts with real-world experience. The well-structured, up-to-date curriculum ensures students gain the latest knowledge and skills.
Anthony
Aledoy Academy is fantastic! Expert instructors, engaging curriculum, and a supportive community. I've gained valuable skills and confidence. Highly recommend!
Fatai Anifat Kanyisola
I recently finished (Web Designer : Frontend ) at ( Aledoy Academy) and wanted to share my feedback. The school strengths include knowledge instructors, relevant course material and a conducive environment