Excel to Power BI Portfolio Project | Full End-to-End Data Project | #excel #sql #powerbi #python

💻 We are pulling data from Kaggle, exploring and analysing it in Excel, cleaning and testing it in SQL, and visualizing it in Power BI. Follow along at your own pace - feel free to drop any questions or feedback you have in the comments below.

📩 Join my community here:

How to join:

____________________________________________

📲 Socials:

____________________________________________

🎁 Free Resources:

Here are some of the free resources I’ve created that you may find useful for your own data projects:

* My templates & guides (coming soon, feel free to ask me for them!!!)

Here are some of the resources used in this project:

____________________________________________

📩 Installation links:

Download these resources mentioned in the project:

____________________________________________

🎶 Music used:

Creative Commons CC BY-SA 3.0

____________________________________________

⏲️ Timestamps:

- Introduction (00:00:00)
- Pipeline architecture (00:01:29)
- Stages of the project (00:02:33)
- Objective (00:06:21)
- Create the requirements (00:08:30)
- Design the dashboard (00:13:11)
- Get data from Kaggle (00:17:39)
- Explore the data (00:18:41)
- Import into SQL (00:21:45)
- Clean data with SQL (00:24:54)
- Create SQL view (00:36:37)
- Test data (00:38:40)
- Import into Power BI (00:53:00)
- Create DAX measures (00:55:10)
- Build the visuals (01:07:52)
- Create the table visual (01:08:34)
- Create the tree map visual (01:11:46)
- Create the scorecards (01:14:48)
- Create the bar chart (01:17:43)
- Clean up the dashboard (01:08:34)
- Set up GitHub Pages (01:28:57)
- Create an ‘assets’ folder (01:30:43)
- Enable GitHub Pages (01:38:13)
- Edit ‘README.md’ file (01:39:39)
- Change theme of portfolio website (01:41:17)
- Create Excel analysis workbook (01:45:28)
- Calculate potential ROI in Excel (01:53:32)
- Validate calculations in SQL (02:01:28)
- Define variables in SQL (02:04:00)
- Create a CTE (02:05:53)
- Create calculated columns in SQL (02:11:54)
- Sort SQL results by net profit (02:17:00)
- Create a ‘difference’ table in Excel (02:18:50)
- Populate remaining columns in Excel (02:23:05)
- Format Excel analysis workbook (02:24:37)
- Analyse the data (02:25:57)
- Add recommendation to Excel workbook (02:29:46)
- Overview of GitHub portfolio website (02:32:55)
- Update GitHub portfolio via ‘README.md’ file (02:36:01)
- Add headers (02:36:41)
- Add table of contents (02:37:53)
- Add images (02:38:48)
- Add code blocks (02:39:23)
- Add markdown tables (02:40:09)
- Find markdown cheat sheet (02:41:58)
- Closing announcements (02:44:13)

[sdw-online]

UPDATE:

The Python script I wrote for this project can be found here:

[YashPatel-bqnh]

I guess, I am the only one who didn't come here from TikTok. So my friend YouTube algorithm has started doing its magic. But, just make some changes to your video banner to get more attention. And all the best.🤜

[gabrieldsfaria]

Thank you for this video! Most youtubers just tell you what to do, but you highlight each step of the thought process! Would love to see more videos like this! Learned a lot from this!

[mahamanedaoudamaiga]

I would like to thank you and tell you how grateful I am for your diligent and detailed work.
We're all looking forward to an another end-to-end project …
With a PYTHON tutorial

[wade]

Thank you, I when from what an I looking at to knocking out a project in a few hours. Awesome video.

[ramikundalini]

Coming off from Ticktock, glad to have discovered your Chanel videos.
Thank you.

[kufrehdavid]

this is helping with my IT.
thanks for sharing.

[ramatuabdulazeez]

Really cool i came to check out the video from tiktok.

[MegdelawitTegene]

Found on TikTok and subscribed to your YouTube channel. Thank you for sharing. I followed along and created the Power BI dashboard. I especially appreciated the data cleaning and validation on SQL and learned so much. The analysis you did on Excel was amazing!! Thank you. I hope to see more of your contents and learn more!

[moamedel_hassan]

i finished the Google Data Analytics course 1 month ago, unfortunately stuck on the projects and how to make them from zero, this video bring most of what I've learned together, i hope to see more like this, keep going we are looking for your advices and more projects, Thanks A lot

[jackofallcontent]

You really helped me grasp the process of analytics man… thanks for your amazing work

[xgyrysc]

Thank you for this resource Stephen. Very detailed and easy to understand. Looking forward to seeing/learning more

[priscillangambi]

Done and dusted !Thanks @stephen remain Blessed

[nessim.liamani]

Thanks Stephen!
It was very informative.

[BloomHubX]

Where have you been all my life?
Well done Stephen!

[ezhankhan]

Thank you sincerely for putting so much effort into this excellent project! I was looking for a way to use Power BI in the context of an end-to-end project with SQL. This is perfect! :)

[deviprasadgharpehai]

Pls we need more such project videos it's very beneficial for data engineers❤. Pls keep uploading more such useful projects😀

[tonictidings]

This is exactly what i have been looking for...Thank you so much for this great deal...I really appreciate

[usman]

Amazing! Your contents are trustworthy.

[funmiadegoye]

I sent you a message on tiktok only to see this directions to this video. I just want to say thank you. You are amazing! This is more than enough!❤