Excel Project | Data Analyst Portfolio Project | Finance Domain | Start to End | For Beginners | #2

#excel #powerbi #sql #tableau
🚀 Book your slot for the Odin School’s Data Science Demo now! - hubs.la/Q02bbrxV0
Excel Project | Data Analyst Portfolio Project | Finance Domain | Start to End | For Beginners | #2
⭐Data Download - drive.google.com/drive/folder...
📱Data Analyst Materials & Projects - topmate.io/data_tutorials
📱Book 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/data_tutorials
📱For Important Data Analyst Materials and Other Resources - topmate.io/data_tutorials
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
📱Follow me on Facebook - profile.php?...
✅Data Modelling - • Data Modeling in Power...
✅Data Cleaning - • Data Cleaning in Power...
✅Data Analyst Portfolio Projects - • SQL & Excel Portfolio ...
✅Power BI Projects - • Power BI Dashboard fro...
✅Tableau Projects - • Tableau Dashboard from...
✅Excel Projects - • Dynamic Excel Dashboar...
✅SQL Projects - • Data Analysis SQL Proj...
✅Power BI Interview Questions with Answers - • Power BI Scenario base...
✅Tableau Interview Questions with Answers - • Tableau Scenario Based...
Welcome to this comprehensive Data Analyst Project tutorial! In this tutorial, I will guide you through the complete process of building a data analysis project using popular tools such as Power BI, Tableau, SQL, and Excel.
Throughout this tutorial, you will learn how to extract, transform, and load data using SQL queries. We will then show you how to analyze and visualize the data using the powerful features of Power BI, Tableau & Excel.
⭐Data Analyst Material available at very minimal cost of Rs. 999. This will include a complete Data Analyst Syllabus with video links, important pdf's, Q&A, this will also include Complete project on Excel (2 Projects), Tableau (2 Projects) and Power BI (1 Project). And the projects will be different from that uploaded on You Tube. If you are interested to buy contact me on my mail or WhatsApp.
For More info watch this Data Analyst Roadmap 2.0 video - • Data Analyst Roadmap 2...
Details mentioned below-
To Buy - topmate.io/data_tutorials
email- [e-mail]
WhatsApp - [phone]
⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
➖➖➖➖➖➖➖➖➖➖➖➖➖
Content
Introduction 00:00
Odin School 04:27
Raw Data Overview 10:30
Problem Statement 11:50
Data Preparation 19:50
Connecting to MS SQL Server 21:39
Connecting to csv (Who Don't have Server) 24:41
Primary KPI Design 26:20
Dashboard Layout 44:28
Adding Primary KPI to Dashboard 50:00
Secondary KPI Design 01:11:56
Adding Secondary KPI to Dashboard 01:25:15
Loan Status KPI Chart 01:38:45
Designing Charts 01:55:57
Adding Slicer and Formatting 02:20:30
Adding Navigation Buttons 02:25:35
Outro 02:27:50
➖➖➖➖➖➖➖➖➖➖➖➖➖
Reach out to me for any personal or Business related Dashboard/ Report development on my email- [e-mail]
WhatsApp - [phone]
➖➖➖➖➖➖➖➖➖➖➖➖➖
Related keywords:
data analyst project,
data analyst project for beginners,
data analyst portfolio project,
data analysis project,
data analyst projects for resume,
data science project,
data analyst excel project,
excel tutorial,
excel tutorial for beginners,
end to end project for data analyst,
excel project for data analyst,
excel project,
report in excel,
dashboard in excel,
data analyst portfolio project
data analyst project
data analysis project
data analyst projects for resume
data analyst sql project
end to end project for data analyst
sql project for data analyst
project for beginners
sql portfolio project
data analyst sql project
data analyst full project
data analyst resume project
sql project
power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, Tableau, tableau dashboard, tableau tutorial, SQL, SQL project

[@datatutorials1]

Book your slot for the Odin School’s Data Science Demo now! - hubs.la/Q02bbrxV0

[@yvkvlogs]

Its an Human Magic 😯 Un believable excel dashboard

[@sarojrai9326]

This is the first KZbin comment that I commented today of this year, I rarely do comments on videos which means I'm so picky even though I like the video most, cause i have been learning and applying data science related topics from KZbin since long time but honestly I find this channel is literally insane, so useful. Its too good Thank You So much Sir

[@datatutorials1]

Thank you so much 😊

[@julierazafindranaly7876]

Thank you helped me so much ;)

[@nikhilbhosale8279]

Im.gonna try this project

[@mohamedelbrawy1222]

magnifecent💯💯

[@marcuselliott2446]

Very helpful - thankyou.

[@datatutorials1]

Glad it was helpful!

[@mayanksingh581]

Need more videos on full Excel Project

[@siddarajpujari6988]

Have you created insurance dashboard in Excel videos

[@NiazMorshed-pq1sj]

Thank you very much for teaching a very useful data analytics project. Truly appreciate this. I have completed this project using MS Excel only. Hopefully, I will do it again along with SQL as well. For now, can I add the completed project to my LinkedIn profile? Looking forward to a positive response from your end.

[@siddarajpujari6988]

Excel project for insurance dataset

[@kidferrer5010]

Why do we write sql queries and not use it when doing the visualization?

[@annujsawant1514]

sir how to explain this project without having domain knowledge to companies if i get interview call ?

[@user-br9zw9eu7u]

sir can u plz upload the same project using power bi ?? plzz

[@ReferKaroEarnKaroo]

Do recruiters also want excel dashboard ?

[@kanchan-kulkarni407]

@ Data Tutorials, Hello Swapnajeet, Can i add this project to linked in or Novypro? also tell the steps to upload to novypro, there is no embedd option given in my Excel 2021.

[@datatutorials1]

Yes you can add. I too need to check out excel publishing to novy

[@swathikandhimalla9133]

I am not getting the field map even though my system has internet connection can you please help me

[@AboZain-dt9gw]

Excel Project | Data Analyst Portfolio Project | Finance Domain

[@user-by6ss5xc6n]

Sir the dasbboard will not be made in power bi ? Earlier you were making this dashboard in power bi

[@datatutorials1]

Will be and uploaded in next week

[@anjalisharma5911]

How to modify issue_date column?

[@antotsh4303]

The excel file in the description is not the same you are using.... Please upload the one you're using

[@amalraj4405]

Hi , I am also expecting Power BI Dashboard. Please upload it. Thanks, Amal

[@datatutorials1]

Will upload soon

[@adhyankumar9492]

@@datatutorials1 please upload the power bi part as well.

[@20cca7fareethahamed9]

I thought you will create this dashboard on power bi but unfortunately not as expected

[@raveenathakur1176]

It's Excel Project soo made in Excel ,, he made same project in Power BI Also

[@asadullahkhan7693]

Sir, when creating an MTD measure, adding issue_date to rows gives me a list of dates but I am getting the whole list how can it be turned to month format, (the data file is already converted to Excel from CSV, and the issue_date column data type is set to date short and date long alternatively but no change in the result)

[@inspiretointeract6434]

Same problem

[@shivangisoni181]

Hi When I am creating a MTD measure, adding issue_date to rows is giving me a list of date but I am getting the whole list how can it be turned to months format

[@ramshataqdees5570]

U can make calendar table when using time intelligence functions like MTD , Calendar table will not have any duplication hence there will be no uncertainty in results. Put date in rows and set hierarchy to month if u want month format

[@mohitahlawat2642]

facing same issue, any solution ?

[@konani]

QUICK FIX: Create 'issue_month' column before you start working on your pivot table. Then instead of adding 'issue_date' to the rows, you add 'issue_month'. (the data type of the 'issue_date' is not correct)

[@user-re4ip5ms9w]

what i did is i opened the format cell custom then type mmm/dd/yyyy then replace - with / then manually switch the day and month to month and day hit enter and it will fix it its not that bad because you only need to manually do 4 bad data cell but it there's a better solution tell me because its a pain if you need to do a lot more manual change

[@kuch0nahin]

Can I add this project in my resume?

[@user-re4ip5ms9w]

if you have a problem with issue_date here is what I did i opened the format cell custom then type mmm/dd/yyyy then replace - with / then manually switch the 4 bad data cell day and month to month and day hit enter and it will fix it its not that bad because you only need to manually do 4 bad data cell but it there's a better solution tell me because its a pain if you need to do a lot more manual change Edit: the last_credit_pull_date column is worst I don't know the fix unless you do it manually Edit 2: Found a solution first replace the - and / with . then find the position of " . " also find the 2nd position of " . " use Left, Mid, and Right Function to get the day month and year finally use the =Date() Function then its now cleaned and format it as mmm/dd/yyyy if you like

[@rahadatulaisynabilah7432]

How to get data from mysql server online sir?

[@khaledhamed7680]

the data you are using in the video is not the same as in the description, pls can you download the right one

[@mohanadzead6024]

Is data analysis job decrease with AI

[@saumyasingh848]

Whenever I tried to use issue date column in pivot table it comes in date format not in month format please help me how van i rectify this

[@datatutorials1]

Either extract month from the date column in data itself, using Text(Cell, “mmmm”). Cell means the cell in which date is present Then use that month in pivot tables

[@vuquanghuy55]

using Power BI in the thumbnail in part 1 and part 2 you turned to excel?

[@amulyamuthoju]

Is part 2 available in PowerBi ?

[@mohitsuryawanshi191]

Sir your excel.data giving different values

[@cosmogaming5132]

Did you use 2 dataset and merge it?

[@datatutorials1]

Nooe

[@ComedywithZero]

hello sir i have faced date formating in row data when i create pivot table MTD also created but issue is when i drag the issu_date formate will be open in dd/mm/yyy like this not open month wise data i request to you sir please solve this problem in short video we are still waiting please solve sir thank you

[@datatutorials1]

Did you convert the csv file to excel file

[@mohitahlawat2642]

@@datatutorials1 did in both ways but not working

[@konani]

Make sure dates are in the right date type before you create your pivot table.

[@revalladhanunjay8690]

mee too same problem.....i have tried many times...but no result.

[@Kira0586]

Same problem

[@vivekshakywar]

Hi, I am unable to find the Excel data sheet for practice. Please check once and update it.Thank you.

[@datatutorials1]

It is available as csv file

[@hrudaysahu2977]

Please share the one with Power BI

[@datatutorials1]

Will be uploaded soon

[@abhayrai1724]

sir plz upload soon @@datatutorials1

[@bodymohmed6493]

After I finished the entire project, I worked hard on it all day, and it did not save

[@ramshataqdees5570]

Why in Excel when we have powerbi and tableau?

[@datatutorials1]

You will also be required to create some projects and data cleaning in excel

[@ravimaurya7093]

Hindi me video

[@kuch0nahin]

Why didn't you clean the data first?

[@datatutorials1]

Cleaning is done

[@kuch0nahin]

@@datatutorials1can you please upload the video of cleaning the data used in this project as well.

[@datatutorials1]

@kuch0nahin watch data cleaning video available on my channel

[@kuch0nahin]

@@datatutorials1thanks. Will do!

[@ramanandraitsioryvoarisoai7708]

@@kuch0nahin u can go for the power BI project to explain it clearly ( data cleaning).

[@Jamalhappy]

Sir .... Hindi ya urdu mai nai hai???