Data Analyst Job Search Cheat Sheet Power BI Dashboard A Complete Guide to Uploading Your GitHub Portfolio

While studying data at Queenstown QRC, I created a lot of Power BI dashboards, but they were a waste of space on my computer, so I decided to upload my Power BI portfolio to GitHub. I've put together a step-by-step screenshot of the process from a non-IT person and a chef.

How do I upload a Power BI dashboard to GitHub?

Hi, I'm Daniel, an aspiring data analyst from New Zealand, and I've finally started working on moving my dashboards to the big stage of GItHub.

GitHub is a project repository that allows developers and data analysts to record the code they write and the change history of their projects, and share and collaborate with people around the world.for example.

I was working my ass off at Queenstown QRC school, and I was like, "What's the point of having a Power BI dashboard if you're just making Power BI dashboards?" I was like, "If you're doing work, you should show it off." So GitHub (GitHub), and I thought about putting it up there.

Now that I think about it, I'm sure many people have thought about putting something up on GitHub, but for those who haven't tried it because they think it's too hard, here's my first attempt as a non-IT person.

Why put it on GitHub?

I'm not particularly an IT developer, and the reason I put what I build on GitHub is for my own records.

I've built a lot of dashboards at school, and I've documented the process, and it's nice to have it in a place where people can see it, so I can just link to it and not have to explain what I've been working on.

I also decided to put my project on GitHub because humans are forgetful creatures, so even if it's something I did, I'm bound to forget about it at some point, but if I put it in a GitHub repo, I can always go back and look at it and refresh my memory.

The process of uploading a Power BI dashboard to GitHub

1) GitHub Dashboard

I'm going to assume you've signed up for GitHub. The picture you're looking at above is the GitHub Dashboard.

Click New (green button) in your GitHub Dashboard

2) Create a new repository

This is where you create a repository. Think of a repository as a place to put your work. The nice thing is that it's not just a place to put your deliverables, it's a record of your work over time.

It's all recorded who modified and updated what and when. There are only three parts to fill out.

Owner: Your account
Repository name: Any name for the project you're uploading (e.g. HR-data-analysis)
Description: A brief description of the project

3) Upload your files

Now that you have a repository for your project, how do you upload any additional files you want to include in it?

In the photo above, under the Quick setup section, click on the part that says upload an existing file in blue.

You can drag and drop files into the space above, or click choose your files to browse for files on your computer.

I've uploaded a Power BI dashboard file called HR data analysis.pbix that I created for sharing, and you can write a short description in the Commit chnages below it.

Then, you'll see the file you uploaded a moment ago, and underneath it is a section called README, which is a place to write a general description of your project.

README: Project description (purpose, modeling, cleaning, key insights, etc.)

4) Create a README

Since this is my first time making one, I decided to let the AI help me out. I could have just written it down, but it's better to have it formatted the first time.

I asked Gemini to type in the above and create a readme format. I was asking it to write a readme file for the Power BI project I've created.

The picture above is an ERD (Data Relationship Diagram), not to sound silly, but if you're curious about ERDs, you should definitely read the post below.

Dive into ERD of relationships between data tables

Project purpose
Instructions for downloading and installing Power BI
Data cleaning and assumptions I made for this project
Insights I found

You can ask it to create them for you. Instead, you have to write down your goals, cleaning, assumptions, and insights. The AI will try to make it make sense with a sample first, but it's better to write down your thoughts instead of trusting it.

In case you need a prompt, I'll leave it in the notepad below

Readme AI request prompts Download

So the AI will take the prompt, and it'll create something, and you'll have to tell it to create it in Markdown code, because that's what you're going to put in your readme file. You can copy and paste that code into your readme space.

Then click Commit changes in the top right corner. It's important to note that Commit means save.

When you see the screen above, hit Commit changes once again.

So now you can see that the readme file has been created, the file has been uploaded, and you should see something that says HR Analytics in the README space that was blank.

The idea is that other people will read this README and understand what the project is, how it's done, and what it's trying to say.

You can also upload the data source file that you used to create the dashboard. Next to the green Code button is the Add file button, which lets you create a new file or import an existing one.

Uploading can be done by importing a file from above, or by dragging and pasting and hitting the Commit changes button.

I uploaded four CSV files (raw data files). So far, we've worked on creating and uploading a Power BI Dashboard file, raw data files, and a Readme file to GIthub.

5) How to edit a GitHiub file

If you want to make edits to the readme file, or if you want to delete or add specific files, GIthub allows you to do so by pressing the . button on the keyboard, which will take you to the edit screen below.

The README file should be selected, and you should see what we've created right away. You can make any edits you want here. When you're done, you should see a number under the magnifying glass in the left menu with a diagrammatic icon. Select it and you'll be taken to the screen below, where you'll find the

Originally, it would be nice to simply write what you fixed, but I just wrote updated readme and then hit the commit and push button to update.

For reference, commit (save) and push (upload to GitHub).

The nice thing about Github is that it has a revision history, so when you make a change, you can see the history, rather than having the file completely overwritten.

This way, others can see who modified what and when.

If you're curious about my journey studying Queenstown QRC data, please read the posts below one by one. I am a current ChefBut I started because I wanted to change my career path to data analyst.

Finalize

Today, I've been talking about the Data Analyst Job Hunt Cheat Sheet Power BI Dashboard GitHub Portfolio Upload Complete Guide. Let's do a quick recap

What is GitHub?
Why put a portfolio of Power BI dashboards on GitHub?
The whole process of publishing a Power BI dashboard portfolio on GitHub

If you're studying data analytics, you're probably familiar with Github, but in case you're not, I've put together this post for you.

I'll post any updates in another post.

Data analyst job hunting cheat sheet Power BI dashboard GitHub A complete guide to uploading a portfolio