Project Code: STATE-SEN-157

Develop a Business Intelligence Dashboard to help us manage our building budgets better!

Project Title Develop a Business Intelligence Dashboard to help us manage our building budgets better!
Project Summary Trample our crummy spreadsheets into dust as you develop an easy to use and update dashboard that pulls in multiple data sources allowing us to better manage our building budget.
Country Senegal
Country/Region of Focus Senegal
Agency Department of State
DoS Office N/A
Post DAKAR
Section MGMT
Number of Interns 3
Project Description

Your challenge, if you accept it, is to use Microsoft Office 365 and Power BI Pro to build us a budget dashboard.

What's so hard about that you say? We have multiple data sources that need to feed into this dashboard and you won't be allowed to use any outside software, no-plugins, no apps from the app store and for sure no Python.

This will be a great challenge for software developers to take an idea from the initial idea to proof of concept during your internship.

You must have access to Office 365,Power BI desktop Pro and Power BI online.

Required Skills or Interests
Skill(s)
Coding
Data analysis
Data visualization
Design thinking
Economic analysis
Additional Information

We are looking for people with experience in Data Visualization, coding skills in DAX and who have a deep knowledge of Sharepoint, Power Bi, and the Microsoft Office 365 environment. If you have knowledge of SQL that might be useful as well.

You will be tasked with working only in the Office 365 and Power Bi environment to develop this dashboard (as that's what we have to use). You will be manipulating data from Excel, CSV, and perhaps a SQL server database.

We want you to help us figure out an easy way to collect, parse and display our information.

Your mentors will be a Facility Manager and an IT specialist in the Foreign Service.