SQL for Beginners | Introduction
4:05
Пікірлер
@kalyanirangari108
@kalyanirangari108 Күн бұрын
I have power bi (free) and fabric (free) licenses. I want to learn AI and copilot functionality in power bi. Will Fabric Trial version able to help me here? Or do I need to invest ?
@BIConsultingPro
@BIConsultingPro Күн бұрын
Unfortunately not! You need Fabric F64 to try it out or Power BI Premium P1
@kalyanirangari108
@kalyanirangari108 Күн бұрын
@@BIConsultingPro Ok, Thanks.
@SouravSaha-b8p
@SouravSaha-b8p 3 күн бұрын
I have given the exam from my organization mail id but after leaving the organisation how will I renew it
@BIConsultingPro
@BIConsultingPro Сағат бұрын
You need to contact Microsoft support
@AA-kq8on
@AA-kq8on 5 күн бұрын
Good Morning thank you so much please , i realy want from you video about Real time Intellignts in microsoft Fabric, please dont forget me thank you in Advance
@BIConsultingPro
@BIConsultingPro 5 күн бұрын
Thank you and I really appreciate your time. Please wait for a week or so. We are going to publish multiple videos on it. Currently, it's a holiday season and we'll start working on or after 7th of January 2025.
@AA-kq8on
@AA-kq8on 5 күн бұрын
@@BIConsultingPro Thank You so much You are the best Happy new year 🎊🎈🎆
@ibrarmuhammad5621
@ibrarmuhammad5621 7 күн бұрын
I WORK A LOT BUT I DIDNT SOLVE THE PROBLEM MY SELF SO I CAME HERE I THINK IT BECUSE OF WHEN WE CHANGE THE SILCIER THE TABLE FROM WHICH THE SLICER IS COMING IS NOT CONECTED TO OUR MODEL AND WHEN WE CHANGE IT IT DOES NOT AFFECT OTHER VISULE CULCUATIONS WE CAN DO IT SOME HOW MAKE RALTION BW THE SLICER TABLE IN MODEL IF IT POSSIBLE BUT IF IT IS NOT WE CAN ADD ALL THE POSSIBLE VALUE OF THE SLICER INTO A TABLE WHICH IS PART OF THE MODEL BUT THEN WE WILL NEED TO USE ALL FUNCTION TO ELEMINTE THE FILLTER COMING FROM THE COLUMN WE JUST ADD
@abhilashvyas5254
@abhilashvyas5254 11 күн бұрын
1. Data Analyst 2. Model and 3. Informed Business Decisions
@AA-kq8on
@AA-kq8on 12 күн бұрын
Thank You for new Information Please, i wait for the Video about Real Time Intelligent in Fabric Thank You in Advance
@AvinashPashavula
@AvinashPashavula 12 күн бұрын
@BI Consulting Pro, are the reports developed using these external tools have any impact when migrated to different environments during deployments?
@KrishnenduHazra-w4i
@KrishnenduHazra-w4i 14 күн бұрын
The service principal that you mentioned is it created from Azure portal? Yes/no? How are you getting the client id, client secret and tenant values?
@Ken-tu7zh
@Ken-tu7zh 14 күн бұрын
Interested in copilot. It would be great if it could analyze my model and data. By the way, do you have F64? How did you demo it?
@MounikaCh-z7o
@MounikaCh-z7o 14 күн бұрын
such a funny video. you gonna, we gonna and more gonna
@TheShivi08
@TheShivi08 15 күн бұрын
Hi I would like you to create a detailed video on how to beome MCT trainer
@sahilsrivstava2356
@sahilsrivstava2356 16 күн бұрын
Hi sir, is this playlist sufficient to prepare for PL-300 cert?
@BIConsultingPro
@BIConsultingPro 16 күн бұрын
Yes but please do read Microsoft Document and practice
@sahilsrivstava2356
@sahilsrivstava2356 15 күн бұрын
@ thank you sir!
@AdityaKumarChauhan-qo9gi
@AdityaKumarChauhan-qo9gi 18 күн бұрын
hme is exam k liye fee bhi deni pdegi kya ??
@SakshiLoharkar
@SakshiLoharkar 23 күн бұрын
That was very informative. But is it possible to generate summary of the report/visual using copilot & then share that summary with required people over mail? Could you create a video for this?
@naperushivasarangi4415
@naperushivasarangi4415 23 күн бұрын
How do i select destination as dataverse table?
@sabarivel4555
@sabarivel4555 23 күн бұрын
Paginated report is no more premium feature.
@SAURABH-n2s1x
@SAURABH-n2s1x 25 күн бұрын
What if user did not selected any value
@SAURABH-n2s1x
@SAURABH-n2s1x 25 күн бұрын
What if user did not selected any value
@fallhydrangea9627
@fallhydrangea9627 25 күн бұрын
Hi! thank you so much for the video. I followed everything you do, but when i refresh my dashboard manually after changing a value in my excel sharepoint, the dashboard didn't change :'(. Can you help me please?
@vinayteja6163
@vinayteja6163 26 күн бұрын
can you please send the pdix file once again please we can't access it right now please share please do the needful
@AA-kq8on
@AA-kq8on 26 күн бұрын
Thank you
@AA-kq8on
@AA-kq8on 28 күн бұрын
can you Please make a video about Realtime Intelligent in Fabric Thank you in Advance
@BIConsultingPro
@BIConsultingPro 26 күн бұрын
Sur! We’ll work on it
@AA-kq8on
@AA-kq8on 26 күн бұрын
@@BIConsultingPro ❤
@Charlesantony1000
@Charlesantony1000 28 күн бұрын
Thanks. Very clear and practical explanation. I will be exploring more videos on this channel.
@Hehehe-ni8gb
@Hehehe-ni8gb 28 күн бұрын
Thankyou so much man
@NaveenKumar-fm5yg
@NaveenKumar-fm5yg 29 күн бұрын
i think calculate function only return a scalar value calculatetable will return a table
@jwhelanm
@jwhelanm Ай бұрын
This was very helpful, thank you!
@snooglehound1285
@snooglehound1285 Ай бұрын
This seems like a very inefficient way to solve the problem and has a few gaps. I'd suggest creating a new table with a distinct list of Student ID and Student Name and call it dim_student. Then create another table with a distinct list of Class ID and Class Name and call it dim_class. Then from the Student table create a new table with only the Student ID and Class ID columns call that fact_enrollments. Join the fact_enrollments table to the original Class Table filtered where student ID is null and append that to fact_enrollments. Add a column to the fact_enrollments table and set its value to 1 where there is both a class ID and a Student ID are populated and 0 where either class ID or Student ID is null. Now with these 3 tables dim_student, dim_class, and fact_enrollments we can measure several things from the number of students in each class, average class size, average number of classes per student, as well as students not enrolled in classes, and classes with no students enrolled. We can also produce class rosters and student class lists. The tables are normalized to optimize model size. If the model is extended a bit with class date and time on dim_class and enrollment date on fact_enrollment we can produce class schedules and other analysis including semester planning and enrollment history. Essentially the core of a Functional Data Warehouse. Better yet communicate this model to upstream Data Engineers and build a proper analytic platform. In my opinion a good Data Analyst should be not be settling for "Work arounds" with clunky data (no matter how "Clever"), but acting in their clients best interest to improve and refine the data estate.
@miriamcasas2928
@miriamcasas2928 Ай бұрын
Thank so much! 😁👍✨️
@matiasignaciomenesescaro9577
@matiasignaciomenesescaro9577 Ай бұрын
oh bro, thank you very much for the video!
@user-ft9tp4ss2d
@user-ft9tp4ss2d Ай бұрын
It is amazing.. Thank you so much.. I subscribed..
@prashantrane2015
@prashantrane2015 Ай бұрын
your voice is not clear. You talk too fast,
@siddharthakar7190
@siddharthakar7190 Ай бұрын
Not good
@AkhtarHussain-ct2hr
@AkhtarHussain-ct2hr Ай бұрын
Hello, I am looking for a particular previous record, based on the condition of the current row. It could be index -1 or index -2 or index - 3. how would I code this, any help would be greatly appreciated.
@BIConsultingPro
@BIConsultingPro Ай бұрын
Please try this: PreviousRecordValue = VAR CurrentIndex = YourTable[Index] VAR Offset = SWITCH( TRUE(), YourTable[ConditionColumn] = "Condition1", 1, YourTable[ConditionColumn] = "Condition2", 2, YourTable[ConditionColumn] = "Condition3", 3, BLANK() -- Default case if none of the conditions are met ) VAR PreviousIndex = CurrentIndex - Offset RETURN IF( NOT(ISBLANK(Offset)), CALCULATE( MAX(YourTable[YourColumn]), FILTER( ALL(YourTable), YourTable[Index] = PreviousIndex ) ), BLANK() )
@franciscosegura2020
@franciscosegura2020 Ай бұрын
Hi! Sorry for asking, but is there any alternative that does not rely on having admin permissions in the workspace (for unmount and mount again a workspace to a development pipeline, you need to have admin permissions over the workspace you have to mount).
@BIConsultingPro
@BIConsultingPro Ай бұрын
to a deployment pipeline without having Admin permissions on that workspace. This is a built-in security measure within Power BI to prevent unauthorized modifications to workspace settings and deployment configurations.
@BIConsultingPro
@BIConsultingPro Ай бұрын
Unfortunately, as of now, there is no alternative that allows you to mount or unmount a workspace to a deployment pipeline without having Admin permissions on that workspace. This is a built-in security measure within Power BI to prevent unauthorized modifications to workspace settings and deployment configurations.
@MurtuzaFernandes
@MurtuzaFernandes Ай бұрын
you just skipped the main part , how the admin gives the access to the content creator ? in your live demo
@SumitArora-zf3of
@SumitArora-zf3of Ай бұрын
If I build a report using Power BI Premium license and share the report with users,do they also need premium license?
@elmzlan
@elmzlan Ай бұрын
If its premium per user only people with premium per user license can see it. If its a premium capacity everyone can see it. If im not mistaken
@rkumars1982
@rkumars1982 Ай бұрын
Fabric capacity could be confusing for some
@AbhishekSharma-vm7tr
@AbhishekSharma-vm7tr Ай бұрын
hello sir should i watch all videos to crack interview for a fresher roles or just beginners videos is enough ?
@kunaljain2154
@kunaljain2154 Ай бұрын
Thank u so much, your videos is very helpful and teaching method is excellent...
@medaminehaji8801
@medaminehaji8801 Ай бұрын
audio is very low
@BIConsultingPro
@BIConsultingPro Ай бұрын
Apologies for that! We'll see what we can do here. Thank you.
@kunaljain2154
@kunaljain2154 Ай бұрын
Sir please start teaching this course as well.
@BIConsultingPro
@BIConsultingPro Ай бұрын
kzbin.info/www/bejne/Y6uqg2aXecqXoKMsi=q07eoY-00GCoS0rs
@favour_george
@favour_george Ай бұрын
Thank you for this video. My connections were successful. Also, after Publishing a dashboard to Power Bi service, if i make changes in the Power Bi desktop, does it reflect automatically in Power BI service? I tried and it is not working here. Please helppp
@BIConsultingPro
@BIConsultingPro Ай бұрын
Hi there, this would take up to an hour to see the changes. You don't need to do anything but to update your credentials under semantic model settings. Also, make sure that your credentials haven't been expired. To check this, please login on sharepoint in incognito mode.
@ijaz6567
@ijaz6567 Ай бұрын
Hi Download link does not work. Please correct it thanks
@PhilD-ur9pq
@PhilD-ur9pq Ай бұрын
Great video - accurate, helpful and straight to the point - thank you!
@jekboy2003
@jekboy2003 Ай бұрын
Best ever advice.. You save me so much time ❤
@favour_george
@favour_george Ай бұрын
Wow, I watched your first video on this, but i prefer this method, and it worked!!!!!!!!!!! I am so happy. Please, does this mean the report will also be updated in real time as the data is been updated???
@BIConsultingPro
@BIConsultingPro Ай бұрын
This may take up to an hour as per Microsoft Official Documentation.
@favour_george
@favour_george Ай бұрын
@BIConsultingPro Thank you, so all I have to do is refresh from Power Bi?
@APG67-q8l
@APG67-q8l Ай бұрын
Excelente, Chandeep. Tiene toda la lógica lo que dices. Coincido por completo con tu criterio. Gracias porque si lo dice alguien con tanto conocimiento como tú, sabemos que vamos por buen camino y nosotros mismos adquirimos seguridad. Un cordial saludo,
@comptegoogle511
@comptegoogle511 Ай бұрын
Please spread the word: Please spread the word. The only thing that went flawless was the 165 USD payment. kzbin.info/www/bejne/kH-UdZtmmbhlq5I&ab_channel=MattCommand
@welcometooaudioland7877
@welcometooaudioland7877 Ай бұрын
$4
@oskarhedstrom9261
@oskarhedstrom9261 Ай бұрын
If you have a new file (exactly the same but with new data) - can I just replace it or add the new one ? how does that work ?
@rajeshmanepalli7367
@rajeshmanepalli7367 Ай бұрын
Hi sample not provided for the above lecturer but there is information in that file after opening it