#dataanalyst #sql #excel
SQL & Excel Portfolio Project | Data Analyst Portfolio Project | Excel Project | For Beginners
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.
Book a 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - https://topmate.io/data_tutorials
For Important Data Analyst Materials and Other Resources - https://topmate.io/data_tutorials
Follow me on LinkedIn - https://www.linkedin.com/in/swapnjeet-s-58a673273
Follow me on Facebook - https://www.facebook.com/profile.php?id=100095047697882&mibextid=ZbWKwL
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 - +91 9579005495
For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
Content
Connecting Excel to MS SQL Server 00:21
Data Cleaning 04:05
Data Processing 07:20
Data Analysis 09:36
Data Viz and Dashboard Building 20:05
Trend for Total Orders 36:00
PCT of Sales 51:20
Best and Worst Sellers 01:14:02
Adding Timeline Slicer 01:24:55
Outro 01:28:21
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 - +91 9579005495
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.