Data Transformation Project for Cuso International

Fermé
Contact principal
Cuso International
Ottawa, Ontario, Canada
Manager, IT Services
(2)
3
Projet
60 heures par apprenant.e
Apprenant.e
N'importe où
Niveau Intermédiaire

Portée du projet

Catégories
Visualisation des données
Compétences
data transformation power bi sql (programming language) dashboard
Détails

The main goal for the project is to transform reports from Excel to PowerBI. The data is exported from SQL. This will involve several different steps for the learners, including:


- Understanding the structure and content of the data exported from SQL.


- Learning how to use PowerBI to create visualizations and reports.


- Transforming the existing Excel reports into PowerBI dashboards and reports.


- Ensuring the accuracy and integrity of the data throughout the transformation process.


Livrables


By the end of the project, learners should complete the following tasks:


- Successfully transform at least 3 reports from Excel to PowerBI.


- Create interactive visualizations and dashboards in PowerBI.


- Ensure the accuracy and consistency of the data in the transformed reports.



Final deliverables should include:


- The transformed PowerBI reports.


- Documentation outlining the transformation process and any challenges faced.


- A presentation demonstrating the new PowerBI reports and the benefits of the transformation.


Mentorat

Students are free to work at there own time, but they need to be ready to answer questions related to the project. they will got access to data and resources in our Organization, so confidentiality is a big issue. as for support, we are ready to support them by any means possible.

Causes prises en charge

Les défis mondiaux auxquels ce projet s'attaque, en accord avec les objectifs de développement durable (ODD) des Nations unies. En savoir plus sur les 17 ODD ici.

Gender equality

À propos de l'entreprise

Entreprise
Ottawa, Ontario, Canada
51 - 200 employé.es
Non-profit, philanthropic & civil society

Our bold vision and mission
Our Vision is an equitable, inclusive, and sustainable world where all people are treated with dignity and can participate fully in society.

Our Mission is to share skills for better futures.

Our Strategic Goal is to work with our partners to address the root causes of inequality and improve the economic and social conditions of marginalized groups.