-
Notifications
You must be signed in to change notification settings - Fork 0
2. In this repository
Silvia Aragon edited this page Mar 1, 2024
·
1 revision
These are the files you will find in this repository:
- Main Power BI Report:
power_BI_report.pbix
-
SQL-queries folder, containing:
- SQL sessionfile containing all queries:
all-queries-azure.session.sql
- Python script to automate extraction of column names into csv files for all tables in the dataset, using psycopg2 library:
extract_col_names.py
- Python class utilities to connect to database and extract information:
database_utils.py
-
database-info folder, containing all csv files extracted. Most files are named as {table name}_columns.csv: they list all column names in each dataset table. Also contains a
table-list.csv
file, containing a list of all tables in the database. - client-queries folder, containing all answers to client queries (.csv files).
- SQL sessionfile containing all queries:
- This
README.md
file. -
.gitignore
file