# rritec/powerbi architecture

> Architecture diagram of the GitHub repository rritec/powerbi, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-04-10). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/rritec/powerbi
- Repository: https://github.com/rritec/powerbi

## Overview

##### Main Components
- Training Materials / Course Content: This is the core of the repository. It includes:
– “01. Notebooks” (detailed lab instructions, demos, markdown files, and Jupyter notebooks for Power BI exercises)
– “03. Interview Questions” (materials that supplement learning with interview prep and conceptual questions)
– “04. SQL” (SQL examples and supporting instructional content)
- Lab Data: (“02. Labdata”) Contains sample PBIX files, CSV datasets, Excel files, and other data sources used in the labs. This component represents the simulated data layer which the notebooks and practical exercises use.
- Documents & Reference Material:
– “docs” directory for course-related PDFs, configuration files, and exam materials.
- External Resources:
– README and embedded links to videos, external websites, and contact information.
– Links to Power BI videos or external tool downloads (such as DAX Studio installers found via the “misc” folder).

##### Relationships and Interactions
- “Interview Questions” and “SQL” folders are additional modules that extend the learner’s practice and knowledge, linking back to core Power BI topics.
- The “docs” directory and “images” support the training materials by providing further explanations and visual aids that can be referenced from within the training modules.
- External links (video demos or external documentation) can be shown as integrations that supplement the repository’s static content.

##### Architectural Patterns and Design Principles
- Separation of Concerns: Each folder has a clearly defined role which makes it easier to update or extend a particular segment of the coursework without affecting the others.
- Self-Containment: The repository is structured so that practical exercises (in the Notebooks) refer directly to the lab data, enabling a “sandbox” for learners to experiment with Power BI functionalities.

##### Relevant Technologies and Tools
- DAX Studio (and scripting materials) are referenced as part of the training on DAX queries.
- Data sources (Excel, CSV, SQL databases) are represented in the lab data; even though they are not live databases, they simulate real-world data interactions.
- Mention external tools (e.g., Git for version control, PowerShell scripts mentioned among cmdlets, and external installation packages under “misc” in Labdata).

##### Important Detail
- Although this project is not an operational system, capturing its “content architecture” in as much detail as possible will help outline dependencies and the pathway a learner takes through the course.

## Diagram (Mermaid)

```mermaid
flowchart TD
    GPI("General Project Info"):::external
    A("Power BI Training Ecosystem"):::header

    subgraph "Content Modules"
        NB("Training Materials - Notebooks"):::content
        IQ("Interview Questions"):::content
        SQ("SQL Examples"):::content
    end

    LD("Lab Data"):::data
    SD("Supporting Documents"):::support
    SI("Supporting Images"):::support
    ER("External Resources"):::external

    %% Core Ecosystem Connections
    GPI -->|"introduces"| A
    A -->|"comprises"| NB
    A -->|"comprises"| IQ
    A -->|"comprises"| SQ

    %% Supporting Data and Materials
    LD -->|"providesData"| NB
    SD -->|"supports"| NB
    SD -->|"supports"| IQ
    SD -->|"supports"| SQ
    SI -->|"illustrates"| NB
    SI -->|"illustrates"| IQ
    SI -->|"illustrates"| SQ
    ER -->|"supplements"| NB
    ER -->|"supplements"| IQ
    ER -->|"supplements"| SQ

    %% Additional Direct Connections to Ecosystem
    A --> LD
    A --> SD
    A --> SI
    A --> ER

    %% Click Events
    click NB "https://github.com/rritec/powerbi/blob/master/01. Notebooks"
    click LD "https://github.com/rritec/powerbi/blob/master/02. Labdata"
    click IQ "https://github.com/rritec/powerbi/blob/master/03. Interview Questions"
    click SQ "https://github.com/rritec/powerbi/blob/master/04. SQL"
    click SD "https://github.com/rritec/powerbi/tree/master/docs"
    click SI "https://github.com/rritec/powerbi/tree/master/images"
    click ER "https://github.com/rritec/powerbi/tree/master/02. Labdata/misc"
    click GPI "https://github.com/rritec/powerbi/blob/master/README.md"

    %% Class Definitions for Colors
    classDef header fill:#cce5ff,stroke:#333,stroke-width:2px;
    classDef content fill:#d4edda,stroke:#333,stroke-width:2px;
    classDef data fill:#f8d7da,stroke:#333,stroke-width:2px;
    classDef support fill:#fff3cd,stroke:#333,stroke-width:2px;
    classDef external fill:#d1ecf1,stroke:#333,stroke-width:2px;
```
