SQL & Excel Portfolio Project | Data Analyst Portfolio Project | Excel Project |For Beginners Part 1

#dataanalyst #sql #excel
SQL & Excel Portfolio Project | Data Analyst Portfolio Project | Excel Project | For Beginners

Part 2 – https://youtu.be/wGJYJ42V8OQ

You will learn how to Import data in MS SQL Server DB, create DB, write simple and complex queries, create a SQL document. In this video you will learn requirement gathering, data cleaning, processing, analysis and dashboard creation in Excel. Complete data analytics project for data analyst in Excel.

📱 Follow me on LinkedIn – https://www.linkedin.com/in/swapnjeet-s-58a673273

⭐Data and other files Download – https://drive.google.com/drive/folders/1ecpBALfFUMSK-GOnk-X4nZhC_uK18zih?usp=sharing

This video is specially made for beginners, experienced folks lookin for Data Analyst Projects, intermediates, freshers, college students and recent pass outs. It will help in learning new skill. This video will help in getting a good hold on tools like Excel and SQL DB. By practicing this tool and developing similar dashboards one can even start with freelancing on international platforms.
Developing similar end to end deploy ready projects will help freshers/ beginners understanding the work flow of a project.

⭐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 – https://youtu.be/_0i_VMeL-Zo
Details mentioned below-
email- [email protected]
WhatsApp – 8208804502

⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.

➖➖➖➖➖➖➖➖➖➖➖➖➖
Content
Intro 00:00
Contents 04:12
Problem Statement 07:27
Software Used 14:51
Raw Data Walkthrough 15:49
Import Data in MS SQL Server DB 18:20
KPI’s Query 25:56
Trend for Total Orders Query 39:48
Percentage of Sales Query 46:58
Best and Worst Sellers Query 59:51
Query Document 01:05:09

Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-

Tableau Dashboard-
Sales Overview Dashboard – https://youtu.be/NoppQVdd8U8
HR Dashboard – https://youtu.be/oAIubTqg-Kw
Ecommerce Sales Dashboard – https://youtu.be/pCpvlIr1yvs
IPL Dashboard – https://youtu.be/LX1LokapH4Q
Customer Complaint Dashboard – https://youtu.be/_EcRJQa3ZDM

Power BI Dashboard
HR Dashboard – https://www.youtube.com/watch?v=-sOHVl_iCHA&t=0s

Excel Dashboard
IPL Dashboard – https://youtu.be/urhI3pEBEBY
Ecommerce Sales Analysis – https://youtu.be/xHTUP1Dxu-M

➖➖➖➖➖➖➖➖➖➖➖➖➖
Tableau Material available-
1. Tableau hand written notes
2. Tableau printed notes
2. Tableau important formulae print notes
3. Tableau important interview questionnaire
All these are available at very minimal cost of Rs.200 only, ping me on WhatsApp to get these.

➖➖➖➖➖➖➖➖➖➖➖➖➖
Reach out to me for any personal or Business related Dashboard/ Report development on my email- [email protected]
WhatsApp – 8208804502

➖➖➖➖➖➖➖➖➖➖➖➖➖
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

Disclaimer: All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for.
Data used in the video is a demo data, modified data and does not belong to any real time industry/ company/ government etc. Data used is only for practice purpose.