How you will learn
1.
Learning modelAn 8 -week experiential learning and hands-on training session
2.
Training MethodologyLearn through real-life business cases and work on live projects
3.
Alumni NetworkJoin an ecosystem of talents and connect with leading employers.
Learn Data Analytics Best Practices Live
We’re in a digital economy where data is more valuable than ever. It’s the key to the smooth functionality of everything from the government to local companies. Without it, progress would halt. As a result of the growing importance of data in the digital economy, companies are looking for bright individuals that will help them extract and take advantage of their data. [AI] Academy’s programs are designed to introduce beginners to data analytics from the foundation to an advanced level. At the end of this course, you will be able to work with databases, create visualizations and perform analysis..
Salary and Job Outlook
As one of the fields where the demand for talent far outstrips the supply, it is no surprise that data analytics provides promising career growth and as a result pays handsomely. According to Glassdoor, in 2021 the annual average salary for a Data Analyst was $73,000 in the United States. While in Nigeria, in 2021 the annual average salary for a Data Analyst was ₦3m according to Salary Explorer. Data science is one career that has long been foreseen as one that will trend in the future because of its impact on our daily lives. Some top career and professional websites like Glassdoor.com and Careercast.com rated data science as the No.1 best job in America for 2020. Many persons have become interested in building a successful career in data science as a result of recent trends.
What you will learn
Module 1
Data Analytics using Microsoft Excel
In this module, you will learn how to use the most versatile Data Analytics tool—Microsoft Excel. We will explore everything from basic formulas to advanced functions that provide efficient analysis and reliable results, taking your Microsoft Excel skills to the next level. At the end of this module, you’ll be able to Create dynamic reports by mastering one of the most popular tools, PivotTables.
This module is designed to provide you with in-depth knowledge on these:
Introduction to Data Analytics
Getting started with Excel
Data entry, Editing, and Formatting in Excel
Using Formulas and Functions
Worksheet Management
Data Validation, Data Sorting and Filtering
Conditional Formatting
Introduction to Excel Charts
Advanced Excel Charts
Pivot Tables
Excel Macros
Module 2
Data Analytics using Microsoft Power-BI
In this module, you will learn how to use one of the worlds most robust business analytics tools that allows you to connect to over 70 data sources. You will understand the flow of using Power BI, from connecting to various data sources, importing these into Power BI, transforming the data and then presenting it effectively. At the end of this course, you will be able to build interactive dashboards and publish them to the web and mobile app.
This module is designed to provide you with in-depth knowledge on these:
Set up and Introduction to Power BI
Power Query for data transformation
Data Visualization with Power BI
Data Modelling and Data Analysis Expression (DAX)
Setup and Integration with Power BI services
Module 3
Structured Query Language
Everything uses a database, and MySQL is one of the most popular databases out there. It is free and Open Source; MySQL is a great database for just about everything. Likewise, Python is one of the most popular and powerful programming languages today. Pairing the two together is a powerful combination! In this course you'll learn the basics of using MySQL with Python. You'll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more.
This module is designed to provide you with in-depth knowledge on these:
MySQL Get Started
MySQL Create Database
MySQL Create Table
MySQL Insert
MySQL Select
MySQL Where
MySQL Where
MySQL Order By
MySQL Delete
MySQL Drop Table
MySQL Update
MySQL Limit
MySQL Join
Module 4
Data Visualization with Python
Write your first Python program by implementing the concepts of variables, strings, functions, loops, and conditions. Understand the nuances of lists, sets, dictionaries, conditions and branching, objects, and classes. Work with data in Python, including reading and writing files, loading, working, and saving data with Pandas. Data visualization plays an essential role in the representation of both small and large-scale data. In this Data Visualization with Python course, you will learn how to create impressive graphics and charts and customize them to make them more productive and more pleasing to your audience. You will gain expertise in several data visualization libraries in Python, namely Matplotlib and Seaborn to extract information, better understand the data, and make more effective decisions. Learn data visualization and best practices when creating plots and visuals Master basic plotting with Matplotlib. Generate different visualization tools using Matplotlib such as line plots, area plots, histograms, bar charts, box plots, and pie charts Understand Seaborn, a data visualization library in Python, and how to use it to create attractive statistical graphics. Understand Folium and how to use it to create maps and visualize geospatial data.
This module is designed to provide you with in-depth knowledge on these:
System environment setup
Python Basics
Python Data Structures
Python Programming Fundamentals
Working with Data in Python
Working with NumPy Arrays
Introduction to Visualization Tools
Basic Visualization Tools
Specialized Visualization Tools
Advanced Visualization Tools
Creating Maps and Visualizing Geospatial Data
Statistical Computing
Mathematical Computing using NumPy
Data Manipulation with Pandas
Data visualization with Python
Intro to Model Building
Earn a Nano Degree in Data Science
Upon completing [AI] Academy’s Data Incubator Program, you'll receive an industry-recognized, professional certification to share with your network and showcase all that you've learned. AI Academy certificates are formatted for sharing on LinkedIn.
