# microsoftlearning/pl-300-microsoft-power-bi-data-analyst architecture

> Architecture diagram of the GitHub repository microsoftlearning/pl-300-microsoft-power-bi-data-analyst, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-09-21). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/microsoftlearning/pl-300-microsoft-power-bi-data-analyst
- Repository: https://github.com/microsoftlearning/pl-300-microsoft-power-bi-data-analyst

## Overview

##### Project type and purpose
- This repository is **not** a running application or microservice-based system; it is a **content‐centric, documentation and lab file** repository for the PL-300 Microsoft Power BI Data Analyst course.
- Its purpose is to store and publish:
- Hands-on lab files (PBIX, SQL backups, CSVs, PowerShell scripts) under `Allfiles/`
- Lab and demo instructions (Markdown) under `Instructions/`
- GitHub metadata for collaboration (`.github/`)
- A Jekyll/GitHub Pages site configuration (`_config.yml`, `index.md`, `readme.md`, `_build.yml`)

##### File structure
- Top-level directories:
- `.github/` → PR and Issue templates, contributor docs
- `Allfiles/` → course assets:
– `DatabaseBackup/`, `Demos/`, `Labs/`, `Resources/`, `Setup/`
- `Instructions/` → Markdown guides for Demos and Labs
- Configuration files:
- `_config.yml` and `_build.yml` indicate a static site build (likely Jekyll)
- `index.md` and `readme.md` drive the GitHub Pages homepage
- No backend code or service APIs; content is static, version-controlled, and delivered as downloads or via a static site.

##### README for additional insights
- Confirms the repository is for **open contributions** by MCTs (trainers), using GitHub pull requests.
- Mentions a separate “Docker-Build” repo for building lab instructions, but in this repo the build is a static site pipeline.
- No runtime components; emphasis on updating content as Power BI evolves.

a. Main components
- **GitHub Repo**
– Source of truth: all Markdown, lab files, assets
– `.github/` for collaboration workflows
- **CI/CD Pipeline (GitHub Actions)**
– Triggers on push or PR, runs `_build.yml` to build the site
- **Static Site Generator**
– Jekyll (or equivalent) transforms Markdown and assets into HTML/CSS/JS
- **Hosting**
– GitHub Pages serves the generated site at `https://microsoftlearning.github.io/PL-300-Microsoft-Power-BI-Data-Analyst/`
- **Consumers**
– MCTs (trainers) clone/download the repo or browse the site
– Students (indirect) receive lab files from trainers

b. Relationships and interactions
- Authors push commits → GitHub → CI pipeline → build HTML → deploy to GitHub Pages
- Consumers clone repo for local labs or browse published site for instructions
- PR/Issue templates guide collaboration back into the GitHub Repo

c. Architectural patterns and design principles
- **Single repository** hosting both content and site code
- **Static site generation** for low-maintenance publishing
- **GitOps** workflow: version control, CI/CD, automatic deployment
- **Clear separation** of content (`Allfiles/`, `Instructions/`) vs. build config (`_config.yml`, `_build.yml`)

d. Technologies, frameworks, or libraries
- GitHub and GitHub Pages
- Jekyll (implied by `_config.yml`) or similar static site generator
- GitHub Actions (defined in `_build.yml`)
- Markdown (.md) for instructions and docs

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Actors
    Author["Author (MCT)"]:::endpoint
    Trainers["Trainers (MCTs)"]:::endpoint
    Students["Students"]:::endpoint

    %% GitHub Repository and Contents
    subgraph "GitHub Repo"
        Repo["GitHub Repo"]:::storage
        CF[".github/ (Collaboration Workflows)"]:::storage
        Assets["Allfiles/ (Course Assets)"]:::storage
        Instr["Instructions/ (Lab & Demo Instructions)"]:::storage
        Config["_config.yml (Site Generator Config)"]:::storage
        BuildYML["_build.yml (CI/CD Workflow)"]:::storage
        Home1["index.md (Homepage)"]:::storage
        Home2["readme.md (Homepage)"]:::storage
    end

    %% Build and Deployment
    Repo -->|"push / PR"| CI["CI/CD Pipeline (GitHub Actions)"]:::process
    CI -->|"runs build"| Gen["Static Site Generator (Jekyll)"]:::process
    Gen -->|"deploys HTML"| Host["GitHub Pages Hosting"]:::endpoint

    %% Consumption flows
    Host -->|"browses site"| Trainers
    Host -->|"browses site"| Students
    Trainers -->|"clone/download"| Repo

    Author -->|"creates content"| Repo

    %% Click Events
    click CF "https://github.com/microsoftlearning/pl-300-microsoft-power-bi-data-analyst/tree/Main/.github/"
    click Assets "https://github.com/microsoftlearning/pl-300-microsoft-power-bi-data-analyst/tree/Main/Allfiles/"
    click Instr "https://github.com/microsoftlearning/pl-300-microsoft-power-bi-data-analyst/tree/Main/Instructions/"
    click Config "https://github.com/microsoftlearning/pl-300-microsoft-power-bi-data-analyst/blob/Main/_config.yml"
    click BuildYML "https://github.com/microsoftlearning/pl-300-microsoft-power-bi-data-analyst/blob/Main/_build.yml"
    click Home1 "https://github.com/microsoftlearning/pl-300-microsoft-power-bi-data-analyst/blob/Main/index.md"
    click Home2 "https://github.com/microsoftlearning/pl-300-microsoft-power-bi-data-analyst/blob/Main/readme.md"

    %% Styles
    classDef storage fill:#bbdefb,stroke:#1e88e5;
    classDef process fill:#c8e6c9,stroke:#43a047;
    classDef endpoint fill:#ffe0b2,stroke:#fb8c00;
```
