Power BI End to End Project ( Banking Domain)
HTML-код
- Опубликовано: 8 сен 2024
- Enroll in our new batch every month. Kickstart Your Career with Our Full Stack Power BI with Microsoft Fabric Course 2024.
Get free demo classes by Registering now :- bit.ly/3IG1wmF
Datasets for practice
drive.google.c...
End to End Power BI Project - Banking Domain
We will be implementing complete Power BI Projects end to end. Right from requirement gathering to publishing the report. We will be following all the real time scenario based requirements. We will be having all follow up videos. Please do watch all videos sequentially. These videos will get to complete end to end knowledge on projects.
Once the data is gathered, next step is to clean the data, transform the data and proceed with data modelling. data cleansing becomes very important step in project. because it deals majority of issues. wat u give in, will come out. if we give clean data, we will get the best insights of business.
***********************
Live Powerbi Interview with Capgemini : • Capgemini Interview 20...
Live Powerbi Interview with EY -Round 1: • First Round Live Inter...
Live Powerbi Interview with EY -Round 1: • Live Recorded Intervie...
Interview tips and Tricks: • Power BI Tips and Tric...
Self introduction: • Self Introduction in I...
Salary Negotiation: • How to Negotiate Best ...
*************************
How are we different from others
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. 100 % Job Guarantee
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
Call us on IND: 8951795123 / 8951785123 / 9916961234 to talk to our Course Advisors.
This is the 3rd video in this playlist. We will demonstrate the usage of all charts in power bi. An expert in power bi knows when to use right chart for right data. This will be very useful to build story.
#azure #microsoft #microsoftfabric #datascience #dataanalytics #powerbi #cloudcomputing
#PowerBi #DataAnalytics #BusinessIntelligence #DataVisualization #BigData #Microsoft #Analytics #DataScience #BI #SQL #Excel #AnalyticsTool #MasteringData #DataInsights #Dashboard #DataAnalysis #Tableau #DataDrivenDecisions #DataReporting #businessanalyticscourse #powerbiinterview #powerbiinterviewquestions questions #datascience
WHAT A TRAINER, HATS OFF TO THIS LADY, EVEN THOUGH I DIDN'T MISS THE SINGLE CONTENT AND FOR 5-7 HRS I CONTINUOUSLY SAT AND WATCHED THE VIDEO AND PARALLELLY PRACTICED THE SAME.
I REALLY LIKED THE VIDEO, YOU MADE MY ALL CONCEPTS CLEAR IN A SINGLE VIDEO AND MADE MY LIFE EASY TOO. THANK YOU SO MUCH
Thank you
I Have never seen such a humble trainer in my life , she was so sweet and explained everything from scratch , hats off to the trainer for such a beautiful lecture on project building. Even a kid with zero knowledge could have easily understood everything , we need more such people for teaching , thanks a lot , learnt more about power bi in 3 hours than i did in my entire last year
😀
thanks for feedback !!!
This is called a real time project...🙏🏻
Thank you so much, please subscribe our channel for regular updates
Without a doubt the best power BI Video i have watch. The trainer is awesome
Thank You so much
"why this is not working" hahahaha so cute. Jokes apart, excellent video, many thanks to the team and instructor. All in one video.
Thank You !
Thank you for sharing this project very good understand and detail explain more gain insights about project.
Glad it was helpful!
Beautifully explained end to end execution of the project.The way she explained and the presentation was awesome.
Thank you so much, please subscribe our channel
Thanks to Uma and KSR Datavizon for this very informative session... I watched this session at the right time of my journey... I am very thankful to you guys... The way she explained every topic and how she was interacting was very impressive... Best session on Power BI i ever watched... 👏👏👏👏
Thank you so much for your kind words! We're glad you found the session helpful and engaging.
I had made this full project after seeing your video and I would like to thank you soo much that you made us understand the topics in a very easy way..
Thank you for all your efforts...👌👌👌
Most welcome 😊 Please subscribe our channel for regular updates
Mam such wholistic end to end videos are really appreciated and helpful
Glad to hear that, Please subscribe our channel, it will motives to do more videos
honestly amazing !!! I was badly in search of this end to end project , tons of thanks to you !!
Great to hear!
Very much appreciate for insightful project
It's my pleasure, Please share and subscribe our channel, Thank you so much for your compliment.
You are very nice trainer.. U mentioned each and every small concept in detailed manner. Thank you so much... Its very helpful to me... ❤❤❤
Thank you so much, Please subscribe our channel for regular updates
Thanks a lot! Every minute in it was valuable. Please add many more such end to end videos.
Thank you, We will
Sooooper helpful and clear explanation. We want more videos like this on different domains...
Sure 👍
One video cleared all my doubts Thank you #KSR team 🙏🙏🙏
You are welcome
Thank you so much. Your explanation is mind blowing.
You are most welcome, You are welcome! Please subscribe our channel, it motivates us
Wow amazing session the way uma explaining concepts is flawless enjoyed the complete session.
Looking forward to more interactive sessions like this.
Thank You 🤩👍
Thank you so much, Please subscribe our channel for regular updates
Thank you very much for End to end project.
You are welcome! Please subscribe our channel, it motivates us
Hi uma… you are amazing… the way you explain. Thank you so much for your inputs… love from Poland.
You are so welcome!, please subscribe our channel for regular updates
Thanks a tonnnn. I have been searching for such video for long time. Thanks a million for making this. This is so informative and helpful. Cleared all my doubts. 🙏🙏🙏🙏🙏
Glad it was helpful! Please subscribe our channel for regular updates, its motivate us
its very interesting
Thanks for content like this, your project helped me to understand end to end approach of how power bi works. please add more videos. your work is really appreciatable.
Thanks, will do! ASAP
Very valuable n informative video
Thanks a lot
What a trainer i had never seen before like this type of online class
very usefully completed full course and topics
greater to meet you✌👌👍
Thanks a ton
Thanks a tonn.
I have been searching for such video for long time. Thanks a million for making this. This is so informative and helpful. Cleared all my doubts. 🙏
You're welcome! I'll be expecting a million-dollar check in the mail then!, Please subscribe our channel it motivates us a lot
@@KSRDatavizon mam can you provide total deccription too
1,000,000 of thanks to share this treasure of power bi video. I would like to study with you, if I would have the oportunity.
Again, thanks a lot.
Thanks
Truly Insightful session, engaging and Instructor explaining the concepts in the simplest manner possible, very supportive and humble. Hats Off to you :). Also Thanks for making the premium content available for free.
Glad you enjoyed it! Please subscribe our channel for regular updates
Thankyou for this amazing project and to the point explaination!
You're very welcome! please subscribe our channel it motivates us to do more videos
Let me begin by saying this first, The video is amazing.
Quick suggestion for calculating the number of active customers: The following DAX formula feels to me like a better fit. Given that it is the same table that we use for our purposes and is easy to read.
= CALCULATE(count(Bank_Churn[CustomerId]),Bank_Churn[IsActiveMember] = 1)
Similarly for the inactive members it can be easy to read as follows:
= CALCULATE(COUNT(Bank_Churn[CustomerId]),Bank_Churn[IsActiveMember] = 0)
Thank you for the amazing videos.
Nice bro good and Easy idea i got result through yours simple way DAX.
I appreciate your suggestion and I'm glad you found the video helpful!
Very UseFul. thank you
You are welcome
Tonnes of Thanks
Each concept explained in very simple manner
Thank you so much for your comment, please subscribe our channel for regular updates. it motivates us a lot
Awesome session from this awesome teacher ...
thank you
Well explained. Even minor details also explained.
Thank You so much
Detailed Explanation, Great Video
Glad it was helpful! Please subscribe our channel, it motivates us a lot
Thank you very much 😊. Please Bring more end to end project videos🙏🙏🙏🙏
Sure sir will do
Hi hope you are doing well This video helps us a lot and the way you explained is very detailed, and you are providing keen knowledge about Power Bi Thank you
So nice of you
Wonderful video thanks
Thank You
very helpful end to end project, thanks from UK
You're welcome! Please subscribe our channel for regulr updates.
Good explain i could understand with uma mam brief lecture on project Mam i request you do more complete projects in different kinds of scenarios please...You have excellent teach skills nice english communication..
We will try to do more videos
It was very informative, Thank you so much!
Glad it was helpful!
Well-articulated , You covered end to end project with great patience, i must say you are an excellent tutor, Uma
Thank you so much, Please subscribe our channel for regular updates
Excellent discussion. Thank You
Our pleasure!
omg very deep explaination, thank you so much ma'am
Most welcome 😊, Please subscribe our channel for regular updates and it motivates us a lot
Plz do more videos like this, thank you soo much for such an amazing content
sure, thank you so much for your valuable feedback, Please subscribe our channel, it will motives to do more videos
Amazing work hope will get some more in near future
Thanku mam for the wonderful session.❤
Keep watching,You are welcome, Please subscribe our channel for regular updates and its motivate us a lot
Best project explanation in power bi
Thanks a lot
Awesome Trainer, Hatsoff to the session creator. This module was very engaging, interesting.
Thank you so much, Please subscribe our channel it will get motivation for us
Learned almost all in one class thank you
You're welcome, please subscribe our channel for regular updates
Really a Good session. Topics well covered and very useful
thank you so much for your feedback, will make more sessions on this. please subscribe for regular updates and it motivates us a lot
Thank you so much for the wonderful video. It's so simple to understand. Humble trainer. Hatts off..
You are most welcome
Great session
Thank you somuch, please subscribe our channnel for regular updates and it motivates us a lot
learnt Alot . Amazing project .Thanks team
Always welcome, please subscribe our channel for regular updates and it motivates us
Amazing Trainer .
Thank you so much, please subscribe our channel for regular updates
Very Nice and clear explanation
Thanks for liking, please subscribe our channel for more videos like this
Excellent tutorial.Thanks for sharing 👍
Thank you so much, Please subscribe our channel for regular updates
Truly really cool and helpful thanks 😊 girl
You're so welcome!, please subscribe our channel, it will motivates us to do more. thank you
Amazing explanation from the ksr team, Request you to make end to end project video on supply chain solutions (sales, CRM, procurement, finance, marketing, operations)
Thank you for the suggestion! We'll definitely consider creating an end-to-end project video on supply chain solutions.
very helpful information. well explained..thanks from DATA is FuturRe channel dedicated to Data Science
You are most welcome
Very useful information. Thanks for sharing this information. All my doughts were cleared. Thank you very much. Please do more videos like this.
Nice to hear
clear explanation....thank you
You are welcome
Thanks a lot for this kind of great content mam, Hats of to your patience levels🙂
Thanks a lot
Very useful project I have been following your channel since year expecting few more different projects 👍👏👏
Thank you very much
Good explaination mam,
please upload 1 more project.
Will upload soon
Thanks Uma, well explained.
You are welcome 😊
Nice madam you will complete information regarding power bi
thank you
so helpful, very nicely explained
Glad it was helpful!
UMA thank you so much .... it's really helpful..
You are most welcome, Please subscribe our channel it motivates us
Good session that covers end to end content on a high level!!
Thank you so much for your responce, please like, share and subscribe our channel for regular updates, and it motivates us a lot.
Very well explained. you deserve million subscribers. kindly make video on telecom end to end project
😍
Thank you so much, please subscribe our channel, it motivates us to do more videos.
Thanks a lot, really really helpful!!
Thank you for your kind words, they mean a lot to me! Please subscribe our channel for regular updates.. and its motivates us a lot ,, thanks again
Its a good video, but if you would have included the Data refresh after RLS , issues y it doesn't work in desktop and powerbi service it would be great... Errors and issues also has to be explained.. It will be helpful
Thanks for the tip, please subscribe our channel for regular updates
Too Good Madam
Thanks a lot, please subscribe our channel it motivates us
Too good
Thank you so much
Thank you Mam
Most welcome 😊 Please subscribe our channel, it will motivates us
Please also do in depth Sales Analysis like this one.
sure sir
Thank you madam...Very very good video...I can't find right end to end report with healthcare data or hospital data .Please upload one video with healthcare data analysis ...Thank you
Super training sister Garu....Pls make a video on roles and responsibility in ur powerBI project .....????
We already have uploaded in our channel. pls have a look at it
Hi , thanks for giving this most valuable information this cleared some of doubts, i have question that when you created new table as calculation how its automatic connect with fact table?
Bcoz same Column name. as they used fact table "Date Column" if you remember.
Yes, you can
Hello mam, can u upload one more new project bacuse its very helpful to us. I trid this project its very easy to learn nice and nice.
Requested to you pls uplaod another new topic project
Will upload soon
@@KSRDatavizon ok thnks.
I m doing internship now but we hv don't know abt projexlct and i saw your videos and i hav done your project bank domain so pls giv us one more project pls
Most awaited video... Thank you so much 🙏🥰
My pleasure 😊, Please subscribe our channel, it will motives to do more videos
Please do one video for a pharmacy project.
Hello mam excellent explanation, while I was doing power query the Bank churn particularly the Bank doj column taken power query as text while I was changing to date or date time it is giving error in data pls resolve this .
Understanding the Issue:
It seems you're encountering an error when attempting to convert the "Bank DOJ" column from text to date or date/time format in Power Query. This typically occurs when the text data is in an inconsistent or unrecognized format.
Troubleshooting Steps:
Inspect the Data:
Check for Inconsistencies: Ensure that all values in the "Bank DOJ" column are formatted consistently (e.g., "DD/MM/YYYY", "MM/DD/YYYY").
Identify Invalid Dates: Look for any entries that might contain invalid dates (e.g., incorrect day, month, or year).
Remove Extra Characters: If there are any extraneous characters (e.g., spaces, hyphens) surrounding the date, remove them using Power Query's text functions.
Adjust the Data Type:
Choose the Correct Format: Select the appropriate data type (date or date/time) based on the format of your data.
Specify the Format: If your data is in a non-standard format, you might need to use the Text.Format function to specify the correct format. For example, if your data is in "DD/MM/YYYY" format, you could use:
Code snippet
Text.Format([Bank DOJ], "DD/MM/YYYY")
Use code with caution.
Handle Errors:
Use try...otherwise: If there are invalid dates in your data, you can use the try...otherwise function to handle errors gracefully. For example:
Code snippet
try Text.Format([Bank DOJ], "DD/MM/YYYY") otherwise null
Use code with caution.
Filter Out Errors: You can also filter out rows with invalid dates using the Table.SelectRows function.
Example Power Query Formula:
Code snippet
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dZAAAAAAAAgEAAAD/AAAA/gAAAAAAAAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = #table({"Bank DOJ"}, {{"01/01/2024"}}) in _t),
#"Changed to Text" = Table.TransformColumns(Source, {{"Bank DOJ", Text.Type}}),
#"Filtered for Errors" = Table.SelectRows(#"Changed to Text", each try Text.Format([Bank DOJ], "DD/MM/YYYY") otherwise null null),
#"Added Custom Column" = Table.AddColumn(#"Filtered for Errors", "Bank DOJ (Date)", each try Date.FromText([Bank DOJ], "DD/MM/YYYY") otherwise null)
in
#"Added Custom Column"
Use code with caution.
This example assumes your data is in "DD/MM/YYYY" format. Adjust the format as needed based on your specific data.
Additional Tips:
If your data contains time information, you'll need to use the appropriate date/time format (e.g., "DD/MM/YYYY HH:MM:SS").
Consider using Power Query's built-in date/time functions (e.g., Date.FromText, Time.FromText) to simplify your transformations.
If you're still encountering issues, provide more details about your data (e.g., sample values, expected format) for more tailored assistance.
By following these steps and carefully inspecting your data, you should be able to successfully convert the "Bank DOJ" column to the desired date or date/time format in Power Query.
Amazing explanation mam
Thanks a lot, Please subscribe our channel, it will motives to do more videos
@@KSRDatavizon could you plz make video on manage parameters .
very nice explanation...Could you plz made one video for data security using principle function
sure, will make those video shortly . than you.
Greate video... for the SWITCH, what about using the AND out of brackets instead of the && eg Credit Type =
SWITCH(
TRUE(),
AND(Bank_Churn[CreditScore] >= 800, Bank_Churn[CreditScore] = 740, Bank_Churn[CreditScore]
Hi maam your explanation is good and i have to request you please increase when you write dax formula the screen is not visible so word not correct find out that
sure will make in future videos, thank you for letting us . please subscribe our channel for regular updates
51:44 why in line chart, months are not in chronological order like jan, feb, march etc......they are at random whe i try to do it
Facing the same problem.I hope you found the solution. Please help if you got the solution.
I have question that datemaster table values are being used for analysis exit of customer, "DOJ+Tenure",should be used for churn analysis.....but DateOfJoining has been used ???
we can do either way sir.. each biz defines own way of churn
Very nice video...really helpful...
But while am trying to create Exit and retain customers measures am getting total customers values... Why?
pls post your measure calculation here.. there could be filter context error
Mam make a video on what key parameters we take for a businesses analysis
Sure mam will do asap
This project i can add my resume.
yes , you can add in your resume, but chnage the clients name
From now onwards i became fan of this word "Okay" 😅😅
:)
Hello, At every video I liked your explanation. Thank you so much for such helpful information. I have one request that could you please make end to end project on bank domain project i.e. capital restructuring and Privatization..thanks
Great suggestion! i will try my best mam
Thank you for this excellent video. Are you able to provide a template for business requirements document
Yes, soon
Hi thanks for the video. While i create column chart with active member vs inactive along date and month name onlu gives blank values. What is the issue? Pls help me
hi mam, the current month exit customers and previous month exit customers on the line chart visuals are resulting incorrect Results! can you please check???
the first report clustered column chart is not working as expected
Here some measure calculations are not working even I write same as shown in vedio still facing problems nd couldn’t make the dashboard plz guide me.