Unlock the power of data with our easy-to-follow tutorials, real-world case studies, and career tips. Whether you're a beginner or a seasoned pro, you'll find valuable content on Excel, SQL, Python, R, Tableau, and more. Stay updated with the latest trends and learn how to solve common data challenges.
**Subscribe** and hit the **bell icon** 🔔 to join our community of data enthusiasts!
Thanks for the project but i dont have access to power bi service to publish the dashboard, how can i show this dashboard to interviewer? please reply..
@@Analystmind sir but while publishing to web i got this : Contact your admin to enable embed code creation To publish this report on the web, ask your Power BI admin if they will allow you to create new publish to web embed codes. Once they turn that on, you will be able to publish this report to the web , do i need to have premium account to publish
Explanation: SUM(Sales[SalesAmount]) calculates the total SalesAmount for the entire dataset. CALCULATE modifies the filter context by adding a filter for Sales[Region] = "West". Therefore, TotalSalesWest will only consider sales where the Region is "West."
In this example, the filter context restricts the rows to only those where the Region is "West" before performing the calculation, resulting in a different outcome compared to calculating the total sales for all regions.
Bruh is this whole dax playlist or many more videos to come? I m finding job as Power BI developer need to polish DAX skill. Any suggestion how will I get through this. Also, tell me if Microsoft Power BI DP -300 certification is important to get job?
@@hhgg-n4f you can try searching in the search bar if it's pre-installed if not follow ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kMWTzl7sSLM.htmlsi=kUbR_NyO18h9mXXP instalation.
1 opinion about the recursive cte--- Should have explained the condition for recursion used in the next part of union all...For beginers ,it wouldvbe a bit easy to understand..
bhai ek question hai .. mai bhi sql project banane ka try kr rha hoo dataset toh easily mil jaate hai but business problem nhi samaz aata (am asking for questions) toh mai analysis kis pr kroo ? plz help bhai .. kaafi confusion ho rhi hai
@@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
Hi Shivam. I'm getting this error while using command prompt after entering pw. please help me fix this.. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Hey, wanted to start this project but I'm getting stuck in command prompt itself , in second command it says 'mysql' is not recongnized as the internal or external command , operational file or batch file. Can you please help?
@@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!
In 4th query, you haven't found the current managers as asked in question, instead you did for all employees who were managers of a departement at any point of time. Can you tell how to do for only current managers @Analystmind
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;
Hi shubham i am following your steps, but i am getting stuck to "Load the database schema and data into MySQL" in this step again and and again after entering the password it is showing error. i know the password even though its not working could you please suggest me another method. thanks
Use the table data import wizard method watch my video using below link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LJ4xjNi4ZA4.htmlsi=a0OuAAIjF-r_iTsj
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