Data Transformation Project for Cuso International

Closed
Cuso International
Ottawa, Ontario, Canada
Manager, IT Services
(2)
3
Project
Academic experience
60 hours of work total
Learner
Anywhere
Intermediate level

Project scope

Categories
Data visualization
Skills
data transformation power bi sql (programming language) dashboard
Details

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.


Deliverables


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.


Mentorship

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.

Supported causes

The global challenges this project addresses, aligning with the United Nations Sustainable Development Goals (SDGs). Learn more about all 17 SDGs here.

Gender equality

About the company

Company
Ottawa, Ontario, Canada
51 - 200 employees
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.