• 

  The Main PowerBI Dashboard

Inspiration

After seeing how PowerBI is used at work, I wanted to try using it on my own. This is the first dashboard I have ever made by myself

What it does

The PowerBI Dashboard connects the given profile data to Microsoft's systems. This allows me to do things such as map out locations of users.

How I built it

I imported the data into MySQL and ran tests in MySQL with python. I did my initial analysis using data from excel and MySQL.

For PowerBI, I moved the data from MySQL to PowerBI and created a dashboard using their tools.

Challenges I ran into

the nan values in the tables caused issues in columns that were normally integer values since the string "nan" is not an integer.

Users who entered locations that contained markup tags "" caused issues as I had to escape the quotation marks.

Accomplishments that I'm proud of / What I learned

I learned how to use PowerBI as well as completed my first data analysis project using MySQL.

What's next for Sonobi Challenge

I hope to use the knowledge I gained in this challenge to aid me in future projects

Built With

• excel
• mysql
• powerbi
• python
• word