The Applied Data Science and Business Analytics course at the Bangladesh-Korea Information Access Center (BK-IAC) is designed for professionals, entrepreneurs, researchers, and decision-makers who want to use data to solve real-world business problems.
The course provides practical knowledge of the complete data science and business analytics workflow, including data collection, database querying, data preprocessing, exploratory data analysis, statistical inference, machine learning, time-series forecasting, model interpretation, and business reporting. Participants will work with real-world datasets and learn how to transform raw data into meaningful insights for strategic and operational decision-making.
The course emphasizes hands-on learning using Python, NumPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, and SQL. Participants will also complete assignments and a case-study-based final project.
After successfully completing the course, participants will be able to:
Participants are expected to have prior programming knowledge, particularly basic Python programming. They should be familiar with variables, conditional statements, loops, functions, lists, dictionaries, and basic file handling.
The first classes will provide a short refresher on Python libraries used for data analysis, but the course will not teach introductory Python programming from the beginning.
Participants without adequate Python knowledge are strongly encouraged to complete our Introduction to Python course before enrolling. Enrolling without the required programming background may make it difficult to follow the practical exercises and assignments.
The course will run for 8 weeks, with two classes per week. Each class will be approximately 3 hours long, resulting in a total of 48 contact hours. The tentative lecture plan is as follows:
| Class# | Content |
|---|---|
| 1 | Introduction to Data Science and Business Analytics; Data-Driven Decision-Making; Python Environment Setup; Jupyter Notebook and Google Colab; NumPy and Pandas Refresher |
| 2 | Working with Business Data Using Pandas: DataFrames, Indexing, Filtering, Sorting, Aggregation, GroupBy, Pivot Tables, and File Operations |
| 3 | SQL for Business Analytics—I: Relational Database Fundamentals, Tables, Keys, SELECT, WHERE, ORDER BY, DISTINCT, Aggregate Functions, GROUP BY, and HAVING |
| 4 | Data Collection and Handling: SQL JOIN Operations and Subqueries; Loading Data from SQL Databases, CSV, Excel, and JSON into Pandas; Combining and Reshaping Datasets |
| 5 | Data Cleaning and Preprocessing: Missing Values, Duplicate Records, Inconsistent Data, Outlier Detection, Categorical Variables, Scaling, and Transformation |
| 6 | Exploratory Data Analysis—I: Descriptive Statistics, Business Metrics, Distribution Analysis, Group-Based Analysis, Correlation, and Pattern Identification |
| 7 |
Exploratory Data Analysis—II and Visualization: Matplotlib and Seaborn; Histogram, Box Plot, KDE Plot, Violin Plot, Pair Plot, Bar Chart, Heatmap, and Time-Series Plot
Assignment 1: Data Cleaning, EDA, and Visualization |
| 8 | Evaluation and Presentation of Assignment 1; Discussion of Common Data Analysis and Visualization Mistakes |
| 9 | Statistical Inference for Business: Sampling, Confidence Intervals, Hypothesis Formulation, Statistical Significance, Common Statistical Tests, and A/B Testing |
| 10 | Regression Analytics: Simple Linear Regression, Multiple Linear Regression, Assumptions, Feature Selection, Performance Evaluation, and Business Interpretation |
| 11 | Supervised Machine Learning for Business: Classification Problems, Logistic Regression, Decision Trees, Random Forests, and Practical Scikit-Learn Workflows |
| 12 |
Model Development and Evaluation: Train-Test Split, Cross-Validation, Data Leakage, Feature Engineering, Scikit-Learn Pipelines, Hyperparameter Tuning, and Model Comparison
Assignment 2: Predictive Analytics and Machine Learning |
| 13 | Unsupervised Learning and Customer Analytics: Clustering, K-Means, Customer Segmentation, Principal Component Analysis, and Business Applications |
| 14 |
Time-Series Analytics and Forecasting: Trends, Seasonality, Moving Averages, Forecast Evaluation, ARIMA, and Introduction to Machine-Learning-Based Forecasting
Evaluation of Assignment 2 |
| 15 | Applied Business Analytics Case Study: Integrating Data Extraction, Data Preprocessing, Exploratory Analysis, Visualization, Statistical Analysis, and Predictive Modeling |
| 16 |
Explainable and Responsible Data Science: Feature Importance, Model Interpretation, Bias, Fairness, Privacy, Ethical Use of Data, and Communicating Model Limitations
Final Case-Study Presentation and Evaluation: End-to-End Analysis of a Business Dataset, Findings, and Business Recommendations |
Email: iac@cse.buet.ac.bd
Phone: 9665650-80 Ext-6438
Mobile: 01670032959