/inkomoko_fake_data

Data preparation experiment

Primary LanguageJupyter Notebook

Inkomoko Impact Dashboard

Data preparation experiment

Purpose

This repository uses fake data. The goal is to show a new approach to preparing data for use in Power BI dashboard creation.

Setup

Python Python libraries: pandas, numpy, os, mysql.connector Anaconda (to create a local development environment and to be able to access Jupyter Lab or Jupyter Notebook)

MySQL credentials

  1. Obtain MySQL credential from Inkomoko IT Department
  2. create config.py file with this format: hostname = "insert_here" username = "insert_here" password = "insert_here" port = "insert_here"
  3. You will also need the database name (this example uses "mel_db_test"; this info is stored in the code rather than the config file)