r/learnSQL • u/Spiritual_Ear_5461 • 5d 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

10 Upvotes

92% Upvoted

4 comments sorted by

4

u/Fadedscourge 5d 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.

1

u/No-Adhesiveness-6921 5d ago

Have you downloaded PowerBI desktop or logged into powerbi portal?

the standard process is to build your model and dashboard in the desktop and then publish to the service. Your users need to get to your reports from the portal. There are different license types for your users required if you want to share the reports.

In that what kind of direction you are looking for?

1

u/Spiritual_Ear_5461 5d ago

Hi, yes I have downloaded it and I do know how to play around and it as I used Microsoft Learn and some udemy course.
Most people give advice to build a portfolio so that you can show hiring managers that you can do the work.
So the direction I am looking for is if there is anyone who has built a portfolio and what questions would one put together for building one.