Data Analytics

Introduction to Microsoft Excel, Analyzing Data with Power BI, and Laser-Focused SQL Mastery.

The training is detailed and hands-on, and it will equip us with real-life scenarios. So, let’s get set to give it all that it takes.

What comes with the training?

1. Introduction to MS Excel:

Data entry
Worksheet vs Workbook (Range vs Table)
Formulas vs functions
IF, SUM, SUMIFS, LOOKUP
Conditional Formatting
Creating report/dashboard using Pivot Table

2. Analysing/visualising using Microsoft Power BI.

3. A laser focus on the following SQL areas will serve you well:

Data Retrieval: Mastering SELECT queries, WHERE clauses, and JOIN operations.
Data Aggregation: Using GROUP BY, COUNT, SUM, AVG functions to summarize and analyze data.
Subqueries: Leveraging subqueries for complex data retrieval scenarios.
Data Transformation: Understanding CASE statements, data type conversions, and functions like COALESCE.
Indexes and Performance Tuning: Learning how to optimize queries for faster performance.

4. Practicality
5. Practice files
6. Access to Office 365 applications.
7. One month of support after training.

What is expected of the participants:

A Windows 10 or 11 laptop (PC) with a minimum of 8GB RAM is required.
Office Suite (2016 or 2019 or 365)
Download Power BI Desktop from the Microsoft Store to your Windows computer.
SQL Server Management Studio (SSMS)
Get your mind set for the training.

Course Duration: 2h 20m

Course level:Beginner

The concepts of data analytics, the role of a data analyst, and the tools that are used to perform daily functions.
Data ecosystem and the fundamentals of data analytics, such as data gathering & data mining.
Relevant soft skills
How to clean, analyze, and share your data with the use of visualizations and dashboard tools.
How to carry out data process and present data using graphics.
The different career paths that are available for data analytics.
You will explore the many resources available for mastering this profession.

Testimonials

The teaching experience was very extensive as it covered a lot of vital areas needed to excel in this field. I learnt new skills like data analysis and tools like Microsoft Excel and PowerBI. My facilitator was extremely knowledgeable and willing to breakdown complex ideas into simpler forms. He made it a comfortable learning environment for each of us and this helped hasten the learning process. I thoroughly the learning process and can’t think of any area of improvement. For my group project, we ensured that each member was involved in each phase of the process; Data clean-up, Data Analysis, final reporting. I was responsible for cleaning and trimming the data using PowerBI, next, I worked with the team to use various formulas to segregate the data before projecting it into a final report.

Ntui Onor-Abasi

Medical Doctor

The teaching experience was spectacular. The lecturer was passionate and inspiring and knew how to communicate to individuals of various competency levels.

Belema

Medical Practitioner in Nigeria

It was a very insightful experience, I learnt how to effectively use Power BI for data analysis including data cleaning and visualization techniques, I also relearnt a few techniques on Excel which have better equipped me to handle complex data sets. My facilitator did an amazing job, his teaching was top notch in my opinion, he was very detailed and patient. I played a key role in the data cleaning process which involved rectifying any errors or missing values to ensure an accurate analysis. I also contributed to visualizing data using Power BI, after analyzing the data, I was able to making meaningful conclusions and. provide insights to my team.

Vanessa

Public Relationship Officer in Nigeria

Given that I had no prior experience with data analytics, I had nothing to unlearn—instead, I learned a great deal. I gained a thorough understanding of a variety of data analytics tools, techniques, and methodologies, including data visualization with Microsoft Power BI, which enabled me to draw insights and analyze reports based on data-driven evidence for projects that we worked on during the course of learning. Our facilitator, demonstrated his expertise and passion for data analytics throughout the course, demonstrating a thorough understanding of the subject matter and effectively communicating complex ideas in a clear and highly engaging manner. His enthusiasm and dedication to our success were motivating, inspiring me to fully immerse myself in the learning process and strive for excellence in my data analytics journey. I played a crucial role in performing data cleaning tasks to prepare it for analysis. Likewise, I collaborated with my teammates to utilize various data techniques and tools to analyze the data and derive meaningful insights. I also contributed to the creation of project reports and presentations summarizing our findings and recommendations.

Ogunleye Temitunde

Teacher in Nigeria

Our Students' Reviews

Job Titles You Can Apply To As A Data Analyst

Business Intelligence Analyst
Data Analyst
Data Scientist
Data Engineer
Quantitative Analyst
Data Analytics Consultant
Operations Analyst
Marketing Analyst

Upcoming Cohort

Frequently Asked Questions

Are there weekend classes?

No please. Class holds during the week Monday to Friday

What other tools will be taught in class?

No other tool will taught asides Microsoft Power Bi

What specification of laptop do I need

Windows PC (Windows 10, Core i5 or 7, 8GB RAM – minimum spec).

Is Installment payment allowed?

No please, Installment payment is not allowed

Duration and Time of class

Three weeks.
Monday to Friday.
7pm-9pm WAT on each day.

What to expect from the class

The training is a detailed and hands-on one that will equip us with real life scenarios and ofcourse for the certification exam as a Microsoft Certified Data Analyst Associate – MCDAA. So, let’s get set to give it all that it takes.

What comes with the training?

1. Practicality
2. Practice files
3. Live Exam dumps
4. Access to Office 365 applications.
5. One month support after training.

What do I need for the course?

1. A Windows 10 laptop (PC) with minimum of 8GB RAM is required.

2. Download Power BI Desktop to you computer from Microsoft store on windows computer.

3. Get your mind set for the training.

What certification are we going to be prepared for?

Microsoft PL- 300

How much is the certification?

$165

How do I write the exam?

Each student is guided during the class on how to write their exam.

Data Analytics

Introduction to Microsoft Excel, Analyzing Data with Power BI, and Laser-Focused SQL Mastery.

What comes with the training?

What is expected of the participants:

Who is this course for?

What I will learn?