Learn Microsoft Fabric, Power BI, SQL, and Data Analytics with Amit Chandak. Want to learn Power BI, SQL, and Tableau. With over 600 videos on these topics, we have something for everyone. Whether you're a beginner or an experienced user, you'll find the information you need to master these powerful tools.
Our videos cover a wide range of topics, including:
Power BI basics Power Query DAX Power BI Service Power BI App XMLA endpoint Advance Power BI SQL vs Power BI Power BI Direct Query Power Bi Dataset Power BI Dataflow Tableau Table calculations Level of Details Tableau LOD Tableau Rank SQL SQL Insert, Update, and Delete SQL Index SQL Joins SQL Windows functions If you are preparing for Power BI DA 100, PL 300, this channel provides you with concepts that you need to clear power bi certification. Feature by Feature comparison of Tableau and Power BI.
Thanks. Hope you like other videos too Complete Power BI in one Video 11 hours: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cN8AO3_vmlY.html Mastering Power BI 230+ videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wvsAzTqSDVg.html Power BI Concepts 180+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cAqjakPjbMU.html Mastering Microsoft Fabric 50+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p-v0I5S-ybs.html
Jitna detail me aap power bi complete karaye hai sir waise pure RU-vid me koi nahi padhaya hai ... Bahout aucha Sir power bi me extra kuch advance chart hai uska use karke advance graphs bhi sikhayea
@sonukumarskp6933 , I do have covered AI charts in few videos. But will try have separate video too How to use Play Axis Visual- ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-dhClPq0cPvE.html Decomposition Tree, Q&A Visual: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cN8AO3_vmlY.html
Thanks for sharing. CTE works as well but Recursive CTE doesn't work at all either in the notebook or outside the notebook. Looking forward from MS Fabric team to support this feature at the earliest.
Hi Sir, I want to create a data flow such that I can extract all the attachments having csv and or Excel format and save it in the Lake House, in the table format in Microsoft Fabric. Can you guide me how to execute this task?
Thank you @FemkeS-o7k ! Hope you will like other videos too Complete Power BI in one Video 11 hours: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cN8AO3_vmlY.html Mastering Power BI 230+ videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wvsAzTqSDVg.html Power BI Concepts 180+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cAqjakPjbMU.html Mastering Microsoft Fabric 50+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p-v0I5S-ybs.html
Thank you @FemkeS-o7k ! Hope you will like other videos too Complete Power BI in one Video 11 hours: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cN8AO3_vmlY.html Mastering Power BI 230+ videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wvsAzTqSDVg.html Power BI Concepts 180+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cAqjakPjbMU.html Mastering Microsoft Fabric 50+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p-v0I5S-ybs.html
I have chosen pay as you subscription, In their prizing list they have hourly plans but while creating fabric its only showing estimated costs for month which is very high. How can I get hourly plan option while creating fabric. If I purchase F64 for month and use fabric for only two hours in month, will they charge me for only that two hours in month
Thanks, hope you will like the next 10 questions too ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LQ-Zi_ChVKg.html Other videos Complete Power BI in one Video 11 hours: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cN8AO3_vmlY.html Mastering Power BI 230+ videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wvsAzTqSDVg.html Power BI Concepts 180+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cAqjakPjbMU.html Mastering Microsoft Fabric 50+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p-v0I5S-ybs.html
You did no change the datatype for destination in mapping? i wonder how did your sql query worked because sum(quantities) cannot be done on strings time slot at 11:50 and 14:45
Hi @flyincarpet1338, This UI has evolved over time. Back then, the only option was to change the source type, and that would be taken care of in the destination. Hope you will also find other videos useful. Other series too Complete Power BI in one Video 11 hours: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cN8AO3_vmlY.html Mastering Power BI 230+ videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wvsAzTqSDVg.html Power BI Concepts 180+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cAqjakPjbMU.html Mastering Microsoft Fabric 50+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p-v0I5S-ybs.html
@jeffhsu7536, I will try that out. Thanks for suggestion. Hope you will like other videos and series Complete Power BI in one Video 11 hours: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cN8AO3_vmlY.html Mastering Power BI 230+ videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wvsAzTqSDVg.html Power BI Concepts 180+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cAqjakPjbMU.html Mastering Microsoft Fabric 50+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p-v0I5S-ybs.html
@nataschalaros418, You're welcome! Hope you will like other videos and series too Complete Power BI in one Video 11 hours: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cN8AO3_vmlY.html Mastering Power BI 230+ videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wvsAzTqSDVg.html Power BI Concepts 180+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cAqjakPjbMU.html Mastering Microsoft Fabric 50+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p-v0I5S-ybs.html
What is I need to add another column in the table visual which "Product". Each Brand can have multiple Product. Will this measure works in similar context?
We need tweak the measure in such case, depending on if we need change when we add brand or not. If it should not change. we need use remove filter on Product or all except on Brand
@@AmitChandak Thanks for the reply Amit bro. I tried different methods to get this result however your method worked for me. I needed to do slight tweak in the measure to get the output.
Hi @laxmanreddy2051 , This video will give you basic concepts. My Advice would be to watch selective videos from Expertise Power BI: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-59PUFuuCrbY.html And Watch Interview Questions: Power BI Interview Questions series: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vvFGAAbds1k.html Blogs: Power BI Interview Part 1: amitchandak.medium.com/power-bi-interview-questions-part-1-4982de3be327 Power BI Interview Part 2: amitchandak.medium.com/power-bi-interview-questions-part-2-de5c7b16db84
If you have both cost and qty then Divide(Sumx(Table, [Qty]*[Cost]) , Sum(Table[Qty]) ) If not, then Please share some sample data with me on LinkedIn- www.linkedin.com/in/amitchandak78/
Thanks for the video. I also saw direct connections video series very helpful. Can you please share with example (detail steps) how to create live connection?
@gunpath-3096 I'm thinking of offering a free live Power BI course in Hindi. Please let me know if it’s okay to run it on Sunday mornings, India time, as a 3-hour class for 4 weeks. We might miss one or two weekends, but I'll aim to complete the 12-hour course in 6 weeks.
This video is very helpful. I have learn power bi from this video. I have question as i wanted to publish my reports. But it is asking organization/student id...i don't have it as i took break of 4 yrs from my job, and it is not taking last organization id...bcz its disabled..so what to do in such cases? if i want to publish report and not having id?
@@AmitChandak This link doesn't create any new id...I got "Thank you for joining. You don't current qualify for a Microsoft 365 Developer Program sandbox subscription." this msg from them..
Dropbox - full file - www.dropbox.com/scl/fi/9pkc21vd8xczspy9w5khv/retailData.csv?rlkey=98j16rh9cna7vhjf739el08ja&dl=0 Small Version on GitHub -github.com/amitchandakpbi/powerbi/raw/refs/heads/main/For%20Beginner%20Tutorial%20Series%20You%20Tube.xlsx
Hi, I’ve tried to calculate PMT & CUMIMPT but I keep getting an error stating wrong data type or the result is too large or too small. I suspect the issue is with my nper field. When I input numbers it works, but I get the error when using existent columns
You can use Dataflow Gen 2 or Data Pipeline with On-premise Gateway Load local SQL server data in Lakehouse using on-premise Gateway| Dataflow Gen2: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oEF-jHVmvdo.html Microsoft Fabric Using Data Pipelines: Gateway Update: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-sVePvZOjtoo.html You can choose any destination lakehouse or warehouse Mastering Microsoft Fabric 50+ Videos: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p-v0I5S-ybs.html
@@AmitChandak Thank you for your response. Yes, can be done using Dataflow or using a DF pipeline. just wanted to check any possible way using notebook.
Hi Amit, Just started watching this video I had one question is this video cover only basic power bi or post watching this I will be able to make a good dashboard?
This video covers most of the visuals, DAX, and Power Query fundamentals. You should be able to create reports/dashboards in Power BI after watching it. The video focuses on the key concepts that will help you do so. There is a newer version of this video. There is a new version as a course, but the free version has been stopped for now - biworld.graphy.com/courses/Power-BI-Full-Course-64279a37e4b039e3060146e9 The paid version is available here - biworld.graphy.com/courses/Power-BI-Full-CourseEarly-Access--Pre-Recorded-6682d32c9df4111bff6a4883 But the above 11-hour video is a good starting point. You can post your questions in the comments.
Hey Amit, Thanks for prompt response Need some more info What is the duration of the paid video Additionally, before going for that, Do I need to complete this video?
I'd just want to mention that it was a great experience being interviewed by you today. You're an awesome person, and I really appreciate learning from you. You really inspire people with all your perspectives and your content. Thanks so much sir.
Thanks Amit for this am currently an hour into the training and I all I can say is thank you for taking your time to explain I am following the training and practicing at same time. When am done probably by tomorrow will drop my final review.
Thanks so much! I'll be looking forward to your final review. There's also a newer version available, and I'd be happy to give you access if you're interested biworld.graphy.com/courses/Power-BI-Full-Course-64279a37e4b039e3060146e9 If you need that, ping me on LinkedIn, I will enable the Enroll button- www.linkedin.com/in/amitchandak78/
Hi @excelscientist5041, This video is part of the series - ru-vid.com/group/PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki But I will try to cover more basic fundamentals.