Видео

Clear

@@visheshshera Any one project in which you are 100% confident and know every step u applied is enough

@@Analystmind ok,can you also tell what is most important skill in data analytics eg sql ,pbi, pandas etc

@@visheshshera I will make a detail video on this and answer is SQL , Dashboard tool any , Python

@@Analystmind hi whats your linkedin?

@@visheshshera it's in description

@@shreyakansal8629 thank you so much ❤️

Thank you 👍 I will

@@atul5003 thank you most welcome

You're welcome 😊

Please upload advanced dashboards in eCommerce and Retail domains in both Power BI & Excel 😊 showing the usage of new KPI cards, bookmarks etc

@@CarlosVolpe-w1n sure

@@atulshinde5343 thank you so much ❤️

@@unsolve_writer1245 most welcome 🤗

Sure best of luck 🤞🤞

Always and forever ❤️

@@piyushwandile4152 will try to improve

Sure will try to make a new video on Recursive CTE

@@theinsightminer08 thank you so much ❤️

@@unsolve_writer1245 yes on it

Thank you will hide from next time

@@makarsh29 usually jo questions solve hum karte hai wohi business requirements hoti hai as a data analyst people will always ask you to get this data now it's up to you how u will get it. For that schema knowledge is required and data you are working on. If you are doing for job work on query and logic behind it that is enough

Try implementing ruclips.net/video/SaBDurpAtpc/видео.htmlsi=dP-Zjlvte-s2PT3k

@@tanushrithawkar3690 It sounds like your system isn't recognizing the `mysql` command, which usually happens when the MySQL installation path isn't added to the system's PATH environment variable. Here's how you can fix it: ### 1. **Locate MySQL Installation Path** - First, find where MySQL is installed. By default, it's usually in `C:\Program Files\MySQL\MySQL Server 8.0\bin`. ### 2. **Add MySQL to the System PATH** - Right-click on "This PC" or "My Computer" and select "Properties." - Click on "Advanced system settings" on the left. - In the System Properties window, click on the "Environment Variables" button. - In the Environment Variables window, under the "System variables" section, find the "Path" variable and select it. Then, click "Edit." - In the Edit Environment Variable dialog, click "New" and paste the path to the MySQL `bin` directory (e.g., `C:\Program Files\MySQL\MySQL Server 8.0\bin`). - Click "OK" to close all windows. ### 3. **Restart Command Prompt** - Close and reopen your Command Prompt to apply the changes. ### 4. **Test MySQL Command** - Type `mysql --version` in the Command Prompt to check if MySQL is now recognized. This should resolve the issue. Let me know if you encounter any further problems!

@@Analystmind Thank you, Looking forward to make it work 👍

@@BettyHill-t7f thank you so much ❤️❤️

@@BettyHill-t7f thank you so much ❤️

U can explain the steps u learn like data import how u did what insight u got from the data which new things u learn.

@@mukeshcr1891 thank you 😊

Superb Bro.... Keep going on🎉

@@rajeevdwivedi3785 thank you 😊🥰

Thank you for highlighting it u can use the solution below WITH RankedManagers AS ( SELECT d.dept_no, d.dept_name, e.emp_no, e.first_name, e.last_name, dm.to_date, ROW_NUMBER() OVER (PARTITION BY d.dept_no ORDER BY dm.to_date DESC) AS rn FROM departments d JOIN dept_manager dm ON d.dept_no = dm.dept_no JOIN employees e ON dm.emp_no = e.emp_no ) SELECT dept_no, dept_name, emp_no, first_name, last_name, to_date FROM RankedManagers WHERE rn = 1;

@@Analystmind Thank you

@@Dictator-ih7cc define the steps u perform in this project point wise which will surely impress the interviewer to show your skills.

Use the table data import wizard method watch my video using below link ruclips.net/video/LJ4xjNi4ZA4/видео.htmlsi=a0OuAAIjF-r_iTsj

If this still not working then probably u are entering wrong password either reset the password or directly try it in MySQL console

@@harpalsingharmo5015 thank you so much means allot

@@bashadude sure will pick this in future

Where are you getting stuck

@@aashishsharma2936 thank allot this means allot

learn.microsoft.com/en-us/sql/integration-services/import-export-data/start-the-sql-server-import-and-export-wizard?view=sql-server-ver16 please go through the guide for it

Any laptop with 16 GB ram I5 processor 12 gen or greater and good graphics of 4 gb

Sure give me some time busy with new office project will surely make it more hard level .

Sure give me some time we will do a heavy project

Thanks for the support and suggestions will surely make it.

Glad it was helpful! ☺️

@@Analystmind thanks

GIT HUB Download Data : github.com/datacharmer/test_db Link for query: github.com/shubhamringole/employees/tree/main

Thank you for noticing

@@Analystmind unable to found above link github page showing error.kindly, pls upload whole data and share it after making changes.

@@DipankarRaman Try now

@@Analystmind now working thanks

@@pulastyadas3351 thank you so much

Thank you

@@sweetsubha514 sure check my playlist for more

Topics like advanced excel , SQL, python basic and any one dashboard tools like power BI , Qlik

@@Analystmind maths k b kuch topics krne chiye like statistics n all?

Basic maths probability, statistics if you're good with other tools mostly they won't ask it in rare cases they ask about maths.

@@shwetas4388 Technical SkillsProgramming Languages:Python and R are commonly used for data analysis.SQL is essential for querying databases.Data Visualization:Tools like Tableau, Power BI, or libraries such as Matplotlib and Seaborn in Python.Statistics and Mathematics:Understanding statistical tests, distributions, and probability theory.Data Cleaning and Preparation:Skills in handling missing data, outliers, and data transformation.Excel:Advanced Excel skills, including pivot tables, VLOOKUP, and macros.Database Management:Knowledge of relational databases and experience with database management systems (e.g., MySQL, PostgreSQL).Big Data Technologies (optional but beneficial):Familiarity with Hadoop, Spark, or NoSQL databases like MongoDB.