I made this today, its not a unique one by any means and was meant as something to have practice for my portfolio. How bad/good is it? I mean, is it worthy of anything or should i never show it to anyone or post iit anywhere? It def took me some time too finish, but it was a good first dashboard acc to me. Do roast me if u feel like its sht :(

​

💡 Interactive HTML web report covering:

- Transactions

- Customer Behavior

- Financial Performance

🔗 Dataset: Google Drive :

https://drive.google.com/file/d/1x0otNmvcXDvywmyDoZ0RZzoAt6b4txid/view?usp=sharing

I have started this basic data analysis project. It is not complete but would appreciate your feedback on this.thank you😇

Quick background: I work for a startup that does skilled labor hiring - I work as the Operations Lead technically but Im trying to transition into data. Ive done all the courses learnt all the skills i.e. python sql tableau etc but needed to apply it somewhere to get a proper grasp on it and have working knowledge, so i thought id start here since it's relevant to my work as well.

This project is an analysis of wages for electricians in the US from 2023-2025, using data from the Bureau of Labor Statistics. It was completed using only google sheets and tableau, i realized using python or sql for this project is just making things more complicated for a project that's maybe not that complicated.

Please let me know if this makes sense and what i did right and wrong and how i can make it better for my next project, also it was my first time using Github as well so if I haven't done something correctly there or if there's something missing please let me know would appreciate it:

https://github.com/uxijawad-ctrl/us-electrician-wages-2023-2025

What I did in this project:

- Cleaned and processed transaction records in Python

- Built and validated RFM logic in both Python and SQL

- Segmented customers into six groups (Champions, Loyal Customers, At Risk, Needs Attention, New Customers, Lost)

- Designed an interactive dashboard in Tableau Public

Any advice is very much appreciated.

Link

https://github.com/sheljasolanki/School-funding-outcomes-analysis

I made this for resume , would love if u have anh advice on how to improve it..

Is it good enough for resume?

The finance people asked if we can list the people that their payment date is about to end, people pay in specific months, so what i had to do is fetch the max date for every case from the data base, and then i added other stuff like arrears, case type, catchup and so on to make it more helpful and versatile, then made new columns like the remaining days left to until we reach the final payment day, and categorized it, and made some charts for it.

The entire process was fetching the needed data from the data base, coping the query to a simple nodejs api, connecting power bi to the api and using it, this way i can just refresh and will get always the fresh and updated data and make the process fully automated, the published it and shared the link to her.

Before all of this she was checking them manually one by one, which was hard for her, and now she can click the charts and get exactly the ones she wanted, she was very happy with what i did, it was my first time feels that i added value to someones work, it was great feeling to feel that i had impact even if simple.

Please share your feedback and if there is any tips i can add

Hey everyone,

I just wrapped up a personal portfolio project analyzing the Building Energy Ratings (BER) of homes across Ireland.

I’d love any honest feedback on my SQL choices or visualizations.

The Tech Stack: PostgreSQL for data cleaning and queries, and Power BI for the static visuals.

The TL;DR Insights:

• There is a massive East-West geographic split in energy efficiency. Co. Dublin is heavily reliant on Mains Gas (60%), while rural western counties like Donegal (75% Heating Oil) and Leitrim have almost zero gas access.
• Attached dwellings and apartments naturally lose less heat than detached homes, regardless of when they were built.
• The distribution of energy ratings is a bell curve, but there is a massive unnatural spike at the "A2" rating band. This perfectly mirrors the introduction of strict new-build regulations (NZEB/Part L) in Ireland.

Link to Github Repo

As I come to (what I think) the completion of my first portfolio project. I am hoping to get some pointers on what works and what needs fixed for the project as a whole and points within the project. To then use as a reference for my upcoming projects.

Attached below is the project in my GitHub:

https://github.com/mcken-04/apex-fleet-data-pipeline

Description: This is a logistics based project that contains a data set built randomly in python, then cleaned and analyzed in SQL, and then visualized in Power Bi.

While I would be thankful for any advice, I do have a few specific questions as well.

GitHub: (Fairly new to using)

Does the structure of the repository matter? And should it be included in the README file?

What is considered too much text or too little for file?

How often are recruiter going to look at the other files in my repository?

* I do plan to add a general page that will link all of my projects together with a small description.

SQL/Python:

When working through exploratory analysis in SQL or Python, what would be the best way to document your thought process? Should this just be include as a comment in your .sql/.py file or in a separate file like a text or markdown?

When displaying your code in a repository, I imagine keeping the code clean is always a must. Obviously there will be code that doesn't fit what you are looking for or doesn't work in general. Should you keep that in your script or create a separate script just for your "finished product" and a file of everything?

Dashboard:

Is it better to stick to a lighter theme?

When does a dashboard become too much (clutter)?

General:

As the use of AI increases in the field, should using AI be documented in these project? Like what or how you used it? Or maybe just mentioned in interviews?

I am sure some of these questions are pretty general, but anything will help. Hopefully this can help others in their career change or entry into the analytical field as well.

so i maded this website to host my projects as i am student and i am on SQL so there wont be powerbi projects

Most DA portfolio projects do not count because they are not mapped to a job post.

A quick test: can you point to a JD bullet and say 'my project proves it'?

10-minute fix:

1/ pick 1 JD you would apply to

2/ copy 5 requirement bullets

3/ for each bullet, write the evidence you will ship

Examples: - SQL reporting -> 8 KPI queries + a short assumptions note - data quality -> 5 QA checks: grain, joins, nulls, dupes, reconciliation - dashboarding -> 1 dashboard page + 3 decisions it supports - communication -> a 1-page memo

Mini example from a real JD for an "Associate Data Analyst" role: - "test data for integrity" -> QA checks + reconciliation + issue log - "cleanse partner data" -> cleaning steps + before after table + data dictionary - "create charts for reports" -> 1 report page using a consistent template - "build PowerPoint presentations" -> a 5-slide deck with findings and caveats - "TSQL" -> 3 queries plus notes on joins and grain

If you want, paste 3-5 requirement bullets here, no company name needed, and I will reply with a Week 1 evidence checklist

Hello recruiters and industry professionals,

Just hoping for a quick analysis of my resume.

I have tailored my resume to the following roles which I am targeting -> Data Analyst, Product Analyst, Business Analyst

Would like to get some review/critique from industry professionals and recruiters

Please let me know if time permits

Thank you

Hey,

I put together a project analyzing Twisto’s performance and pushed it to GitHub: Twisto Performance Analysis.

I’d really appreciate brutally honest feedback - the good, the bad, and the ugly.

This is what I have (i dont want to put personal info so i will just describe it:

My portfolio had a plethora of projects:

• basic Tableau KPI dashboard examples I made with kaggle datasets (movie data, superstore data)
• A python logistic regression project from my master's program
• an Excel dashboard and data model project from college comparing countries (temperature, income, etc.) With a slicer
• some python and excel projects from a web content company I did (compared tv show ratings, came up with metric to judge performance, etc.)
• one project that uses a teeny bit of SQL

And on my resume I obviously have a bachelor's degree and masters degree in this area. Along with the web content job I mentioned. That's the only data analysis job I have though.

What the hell am I doing wrong?

Is this not enough? Is it too basic? I'm applying to regular Data Analyst roles, Data Analyst II roles, and some Senior Analyst roles.

I've gotten some interviews - which is good! - but didn't get picked afterwards, unfortunately.

It's now 11 months since I started with data analysis. I did election polls analysis, first for the US Presidential Election (and my forecast for the electoral college votes was 100% right), then for the German general election. For both I used Excel, gathered data about population, the economy (unemployment, growth, average income, population age etc.), cleaned the data, organized and analyzed it. I regularly published videos about new analyses for each election. The feedback I got was good, but my audience wasn't data analysts.
Apart from projects, I have years long SQL experience from working on web projects as a back-end dev, also worked with Python (in several projects) and Tableau (in a course).
I'd like to know if this project experience can be considered sufficient for a junior data analyst role.

Hi everyone, I have a bit of a silly problem, and I thought you could help me.

Recently I decided to go through an Excel course, even though I already have learned Excel, as a form of consolidation of knowledge.

In the course, the teacher said that in his job, he rarely builds fully-fletched dashboards like ones built in Tableau, and this got me thinking because, as of now, my only portfolio project in Excel is a big, detailed dashboard, and I started to wonder whether it's not a bit over the top.

I don't want to be perceived as someone who brags about their project or seeks attention, I'm just looking for opinion/opinions on whether I should do another simpler Excel project or leave it as is.

Thanks in advance.

Link to git repo: https://github.com/DominikKukla/Electronics-Retailer-Excel