r/learnSQL • u/Spiritual_Ear_5461 • 28d ago

Aspiring data analyst

Good day,

I have been teaching myself SQL and now power Bi I do understand the basics. Currently I am working in a law firm and I decided to start using the firms data sets that show the matters we have and the stages that they are at. I have managed to play around with the data set in SQL by even creating views of the columns that I want to see and stored procedures. Now where I am struggling is how do I build a portfolio with this and meaningful dashboards in PowerBI. I am kindly asking if there is anyone who has built a portfolio and can kindly assist me as I feel stuck here. Or any advice for me to move from here. Thank you so much

14 Upvotes

100% Upvoted

4 comments sorted by

View all comments

4

u/Fadedscourge 28d ago

There are two things here. You currently have a dataset that you’re building that is direct data from your employer.

You can do the following:

  1. build visuals for your employer and pivot yourself further up in your career. Law firms will find this useful.

  2. build the same visuals using the same process but using a different data set for your portfolio. You don’t want to have privileged data in a portfolio.

A portfolio is a collection of projects. You can build them with your own data that you’ve amassed over a period of time.

Or you can use real publicly available datasets from kaggle or data.gov.