Data Analytics & AI
Data analysis training entails gaining skills in data gathering, cleansing, statistical analysis, visualization, and machine learning in order to extract insights. Handling multiple data sources, studying and comprehending data using statistical methods and visualization tools, applying machine learning for predictions, and assuring ethical data practices are all part of the job. The training modules include Excel, PowerBI, SQL and Python.
Curriculum Breakdown
The programme curriculum covers all areas of data Analysis.
1
Introduction to Data Analysis
- Introduction to Data Analytics
- What is Data analytics
- Data types and Data sources
- Data types and Data sources
- Data Storage and Data Manipulation
- Introduction to Excel, SQL, and Power Bi
- Data Visualization using excel and Power Bi
- Data Cleaning and Preparation with Excel
2
Introduction to Database
- SQL Syntax and Basic Queries
- Advanced SQL Queries and Functions
- SQL Joins and Subqueries
- Data Modeling with SQL
- Collaborating in Power BI
- Data Analysis and Visualization with Power BI
3
Introduction to Excel
- Cleaning and Transforming Data with Excel
- Data Modeling and Analysis with Excel
- Database Fundamentals with SQL
4
Introduction to PowerBi
- Data Modeling and Transformation in Power BI
- Creating Visualizations in Power BI
- Creating Interactive Dashboards in Power BI
- Sharing and Collaborating in Power BI
5
SQL
- SQL Database/Basic
- SQL Joins
- SQL Aggregation & Subqueries
- SQL Temporary Tables & Window Function
6
AI in Data Analysis: Practical Applications.
- Microsoft Copilot (Excel & Power BI AI)
- Excel Copilot: Summarizing data, forecasting, and writing formulas with AI.
- Power BI AI visuals.
- ChatGPT / GPT-4 (OpenAI)
- Prompt engineering for data tasks.
- Using ChatGPT to write SQL & Excel formulas.
- Data storytelling and business insights generation.
Course Benefits
- Internship Placement
- Build an online portfolio wih 6 high-end project
- One on one mentorship and coaching session
- Study group
- Career mapping
- Recommendation/reference letter
- Job interviewpPreparation
- Gain online presence for job prospect visibility
- Coaching and mentoring
Job Opportunities
- Data Analyst
- Data Engineer
- Data Scientist
- Data Architect
- Data and Analytics Manager
- Machine Learning Engineer
- AI Engineer
- Business Intelligence Developer
Contact Evolve HQ
Enroll for Data analytics by Evolve HQ
I decided I wanted to at least learn something new this year even though I never had anything in mind and just then i stumbled on data analysis with Evolvehq and then I decided to give it a try, as someone who is a novice to the tech world, after a couple of lessons I can boldly say it has exceeded my expectations and has served as an eye opener to things I would not have had an idea about if I hadn’t taken the bold step.
Igwe Chinedum Augustine
Nigeria
Meet Our Faculty
Meet our world class, competent and ever dedicated tutors who will be guiding you through the journey
Olayinka Oyedele
Know More about evolve HQ Courses
Lorem ipsum dolor sit amet, consectetur elit. Ut elit tellus, luctus nec adipiscing
Explore Other Courses from Evolve HQ
All programs are designed to prepare you for the future in the tech world
Excel Mastery for Human Resources
Ethical Hacking & Penetration testing
Governance, Risk & Compliance (GRC)
Security Operations Centre (SOC)
Artificial Intelligence Automation
