Data Analytics & Decision Support Portfolio

April 12, 2026 · View on GitHub

This repository presents a structured collection of applied analytics projects designed to transform raw data into decision-ready business insights.

The portfolio covers:

  • Data Warehouse Architecture
  • Power BI Reporting
  • SQL Analytics
  • Python Analytics
  • Qlik Sense Dashboards
  • Tableau Dashboards

Each project demonstrates production-style analytics workflows combining modeling, transformation, and visualization.

Portfolio Structure

01_Data_Warehouse/
02_PowerBI_Dashboards/
03_SQL_Analytics/
04_Python_Analytics/
05_Qlik_Sense_Dashboards/
06_Tableau/

1. Data Warehouse Architecture

Data Warehouse Architecture

Bronze → Silver → Gold layered architecture implemented for scalable analytics environments.

Highlights:

  • layered warehouse modeling
  • star schema semantic layer
  • SQL Server & Snowflake implementations
  • ETL reproducibility
  • analytics-ready structures

2. Power BI Dashboards

Hospital Dashboard

Interactive KPI dashboards supporting operational and financial monitoring.

Highlights:

  • executive KPI cards
  • category performance tracking
  • trend analysis
  • business storytelling dashboards
  • decision-support reporting

3. SQL Analytics

Exploratory analytics workflows built directly on dimensional warehouse models.

Highlights:

  • KPI engineering in SQL
  • ranking logic
  • window functions
  • cumulative metrics
  • YoY comparisons

4. Python Analytics

Applied analytical notebooks supporting structured dataset exploration.

Highlights:

  • dataset profiling
  • statistical summaries
  • feature-level analysis
  • analytical workflows

5. Qlik Sense Dashboards

Store Sales

End-to-end BI applications built with scripted ETL and semantic modeling layers.

Highlights:

  • star schema modeling
  • QVS ETL pipelines
  • KPI dashboards
  • customer analytics
  • employee performance tracking

6. Tableau Dashboards

HR Dashboard

Interactive workforce analytics dashboards designed to explore organizational structure, demographic composition, and compensation patterns.

Highlights:

  • guided workforce analytics workflow (overview → demographics → compensation)
  • department and geographic workforce distribution analysis
  • education vs performance segmentation
  • salary structure exploration across roles and experience levels
  • employee-level filtering interface for targeted workforce investigation

Includes:

  • synthetic HR dataset
  • analytical data catalog
  • decision-support dashboard structure
  • packaged workbook (.twbx)

Core Competencies Demonstrated

  • Dimensional Modeling (Star Schema)
  • KPI Engineering
  • SQL Analytics
  • Tableau Dashboarding
  • Power BI Reporting
  • Qlik Sense Development
  • Data Warehouse Design
  • Snowflake & SQL Server
  • Python Analytics Workflows
  • Business Performance Analysis

Continuous Development

Additional structured learning projects and technical explorations are available in:

👉 https://github.com/Farius0/Formation_Ligne

Certifications & Professional Credentials

Data Analytics

  • Google Data Analytics Professional Certificate

Cloud & AI Foundations

  • Microsoft Azure AZ-900 (Fundamentals)
  • PL-300 (Power BI Data Analyst Associate -- in progress)

Programming & Development

  • Python Developer Certification
  • SQL, Excel, Power BI Certifications

Verified credentials and official transcripts:

Contact

⭐ This portfolio reflects a structured approach to analytics engineering, BI reporting, and decision-support system design.