How lk-learner/ibm-data-analyst-professional-certificate works
Project Type and Purpose
• This repository is a learning-content system: nine sequential courses, each containing slides, activity files (Excel, CSV, databases), Jupyter notebooks, and final projects.
• Purpose: teach data-analysis skills through hands-on labs (Excel, Python, SQL, visualization, dashboarding).
File Structure
• Top-level folders “Course-1 … Course-9,” each with:
– readme.md (course overview)
– subfolders “Activities References” or “Activites” with raw data files (.csv, .xlsx, .db, .sql).
– Jupyter notebooks (.ipynb) for interactive code labs.
– Presentation slides (.pptx) summarizing theory and instructions.
• A “Lakshmi Kadali Certificates” folder holding PDF certificates.
• A root README.md describing the entire Professional Certificate: its courses, tools, and projects.
README for Insights
• It outlines a learning pipeline:
1. Data-wrangling in Excel (Course-2)
2. Visualization in Excel & Cognos (Course-3)
3. Programming in Python (Course-4)
4. Python project (Course-5)
5. SQL & Databases (Course-6)
6. Data analysis with Python & ML (Course-7)
7. Visualization in Python (Course-8)
8. Capstone bringing all skills together (Course-9)
• Tools/technologies: Excel, IBM Cognos Analytics, Jupyter Notebooks, Python libraries (Pandas, NumPy, Matplotlib, Seaborn, Plotly, Dash), SQL/SQLite.
Main Components & Relationships
1. Content Repositories: PPTX slides, DOCX instructions, CSV/XLSX/DB raw datasets
2. Interactive Code Environment: Jupyter Notebooks
3. Programming Languages & Libraries: Python + Pandas/NumPy/BeautifulSoup/Scikit-learn, SQL
4. Visualization Tools: Excel charts, Cognos dashboards, Python plotting libs (Matplotlib, Seaborn, Plotly, Dash)
5. Learning Sequencer: Coursera platform (implied)
6. Capstone Project: integrates ingestion, processing, analysis, visualization
– Raw Data → Jupyter Notebooks (data ingestion & wrangling)
– Jupyter Notebooks → Python Libraries (code execution)
– Excel Sheets ↔ Data Files (manual pivot & charts)
– Cognos Analytics ↔ Excel/CSV (dashboard ingests prepared data)
– Python Visualizations ↔ Notebooks (plots generated)
– All Courses feed into Capstone (final deliverable)
c. Architectural Patterns / Principles:
– Layered Learning Pipeline: Data Ingestion → Wrangling → Visualization → Advanced Analysis → Dashboarding
– Modularity: each course is a self-contained module with clear inputs (data, slides) and outputs (notebooks, dashboards)
– Technology Separation: distinct layers for spreadsheets, code notebooks, databases, BI tools
d. Key Technologies / Frameworks:
– Excel (spreadsheets, pivot tables)
– IBM Cognos Analytics (dashboards)
– JupyterLab / Notebooks (interactive code)
– Python libs: Pandas, NumPy, BeautifulSoup, Scikit-learn, Matplotlib, Seaborn, Plotly, Dash
– SQL / SQLite (local .db files, .sql scripts)
Detailed Capture of Essential Elements
• Dependencies: e.g., Course-6 SQL labs depend on .db and .sql scripts in its Activities folder.
Putting It All Together
[Course-1: Intro Slides] → [Course-2: Excel Module] → [Course-3: Excel/Cognos Dashboards] → [Course-4 & 5: Python Notebooks & Project] → [Course-6: SQL Labs] → [Course-7: Python EDA & ML] → [Course-8: Python Viz] → [Course-9: Capstone]
– Underneath, layer the data artifacts feeding into them, and above, list tools & libraries they invoke.
– Highlight final Capstone module as aggregate of all previous layers.