How I find Projects as a Data Analyst

so where do you start with looking for a project I find that people are exhaustively searching outside of areas that they're familiar with instead of focusing on right in front of them one day one of my colleagues came up to me and explained this problem he was having analyzing financial data for an account he managed the issue was that the data was only in monthly Excel files so if you want to analyze Beyond this such as year or compare year over year you'd have to go through and copy and paste each one of those monthly reports asking around the office I found that even other account managers had the same problem without any solution to solve it for this I used the power of power query to combine all these Excel files over the last number of years from there I built a dashboard solution in power bi that had a central location for all the account managers to go to

Channel: Luke Barousse

Views: 51,837

Keywords: data viz by luke, business intelligence, data science, bi, computer science, data nerd, data analyst, data scientist, how to, data project, data analytics, portfolio project, sql, excel, python, power bi, tableau, data engineer

Id: FR_6qEu2kko

Length: 0min 42sec (42 seconds)

Published: Wed Mar 22 2023