GENFOCUS Academy AI-Integrated Data Analytics Program DRAFT SYLLABUS — details require final academic confirmation Category: Artificial Intelligence & Data Analytics Duration: 16 weeks Mode: Hybrid Level: Career accelerator COURSE OVERVIEW You will learn to turn raw data into clear insight. Using Python, SQL, Excel and Power BI, you will clean, analyse and visualize data, understand statistics and machine learning fundamentals, and use AI-assisted tools to work faster and smarter. CURRICULUM 1. 01 · Python for Data Analytics - Python programming foundations for analytics workflows - Numerical data manipulation with NumPy arrays - Data wrangling, cleaning, and aggregation with Pandas DataFrames - Automating repetitive data extraction and file processing 2. 02 · SQL for Data Querying - Relational database concepts and SQL syntax - Filtering, sorting, grouping, and aggregating business datasets - Multi-table joins (INNER, LEFT, FULL) and subqueries - Advanced window functions, CTEs (Common Table Expressions), and views 3. 03 · Advanced Microsoft Excel Modeling - Advanced formulas: XLOOKUP, INDEX/MATCH, SUMIFS, and nested logic - Dynamic Pivot Tables, Pivot Charts, and Slicers - Data cleaning, text manipulation, and conditional formatting - Building automated financial and operational spreadsheet models 4. 04 · Data Visualization & Storytelling - Visual encoding principles, chart selection, and layout design - Creating compelling static and interactive visualizations with Matplotlib & Seaborn - Designing executive dashboards that communicate actionable insights - Presenting quantitative findings clearly to technical and business stakeholders 5. 05 · Business Intelligence with Power BI - Power Query for extracting, transforming, and loading (ETL) data - Data modeling, star schemas, relationships, and cardinality - DAX (Data Analysis Expressions) for calculated columns and measures - Publishing interactive multi-page reports with drill-through filters 6. 06 · Applied Statistics for Business - Measures of central tendency, variability, and data distribution - Probability concepts, sampling techniques, and normal distributions - Hypothesis testing (p-values, t-tests, chi-square) and confidence intervals - Correlation vs. causation and regression analysis 7. 07 · Machine Learning Fundamentals - Supervised vs. unsupervised machine learning concepts - Regression algorithms for numerical forecasting - Classification models (Decision Trees, Logistic Regression, Random Forest) - Model evaluation metrics: Accuracy, precision, recall, RMSE, and confusion matrix 8. 08 · AI-Assisted Analytics Workflows - Using AI code-assistants for rapid data transformation and query writing - Automating data profiling and report drafting with LLMs - Building automated insight summaries from large analytical datasets - Ethical data governance, privacy compliance, and responsible AI practices SOFTWARE & TOOLS - Python - SQL - Power BI - Microsoft Excel - Pandas - NumPy - Scikit-learn - Jupyter - Copilot / AI Tools PRACTICAL PROJECTS - Executive Power BI dashboard connecting multi-table SQL databases with automated KPI refresh - End-to-end Python predictive analysis predicting customer attrition or revenue trends with machine learning CERTIFICATION A Genfocus Academy Course Completion Certificate is awarded upon fulfilling attendance, practical exercise benchmarks, and capstone project review. Contact admissions@genfocus.com to confirm the final syllabus, fees and schedule.