Advanced Power BI Project: Analyzing ATM Transactions for Business Intelligence
HTML-код
- Опубликовано: 11 сен 2024
- The purpose of this project is to analyze the ATM transaction data for Wisabi Bank to gain insights on customer behavior, ATM usage, and identify opportunities to improve the bank's services.
Access Project Files here: drive.google.c...
Create Free Microsoft 365 tenant for practice: / creating-a-free-micros...
Excel Playlist: • Power Query in Excel
Power BI Playlist: • Getting Started with M...
SQL Playlist: • INTRODUCTION TO SQL
If you are having issues with the Power Query Transformations especially with the Date columns, kindly follow the steps here to change the locale settings for the file: ruclips.net/video/eMm5toWfLiA/видео.html
Ensure you set it to English (United States).
@@RohitSatpute-if6rm You will extract time and date from the datetime column.
Kindly follow the steps in the video to implement this.
You're probably still getting that error because the date issue has not yet been resolved. This happened to me too.
First, reload the transaction data into powerBi, once you do that, powerBi automatically adds a step in the power query that is causing the whole problem.
Now, open your power query editor and click on the already generated "changed data type" steps in the applied steps, then you click on the date table, change the date locale to English (US) and then close & apply. This worked for me, you should try it too.
@@estheroluwaseyi9272 I am also facing this issue.... even after i change the locale time, its still throwing error.... any help here please?
i am having problem in making the age column..i doing exactly the way you did but column shows error
@@estheroluwaseyi9272 Yesss! Thank You. This worked! I deleted that "changed data type" steps altogether and redid it. It was such a pain though.
thank you kind sir for your lesson, you sound like the nicest person on earth, best wishes to you and your life
following your project is going to help me get a job. thank you for sharing!
It’s amazing how I learned a lot in this one project. Thank you 👏
Thanks so much for this video, it's has really taught me alots. I've not even finished watching but gained alots already
Thanks once again
You are welcome!
Great job with this boss truly an end to end project learning new tricks as I'm following along. Please where did you get the data?
Quick observation moderator. Shouldn't you be rounding the age down instead of up? Rounding up gives them an age they are yet to attain.
Thank you for your comment. Depending on the scenario, either approach can be adopted.
Now that I think about it, in this scenario rounding down might be more appropriate.
I'm unable to format birth date column to date data type from text it's giving dataformat.error
excuse me buddy, see the bookmarks we have created in overview page for filters ,i copy that blank icon from filter icon and paste it on the demography page Also but when i try to make it work it is directing me to overview page ,"as the bookmark was created on overview , to make it work i repeat the same process add 2 another bookmarks for demography page , is there any short that we can make it work without creating another 2 bookmarks for overview ?
In my preview features I am unable to see Azure map visual, my power BI desktop version is of August 2023.
why does customer dimension have an atm id?
sir your voice is not clear
exactly
Hii sir I'm also facing same type of error while get data option proper data not loaded please provide new data file for the same project
@wisabianalytics sir please give azure alternative, bcz unable to work on azure map asking for sign in, please help
Guys I don't know whether I'm blind or what , but for some reason I can't find the transaction fact tables Data set. can someone point me in the right direction. Thanks
You can find the Transaction table files here: drive.google.com/drive/folders/1zj_DVYTJa8ZyIvLmzMJ96VNrHwYdn1_c?usp=drive_link
Alternatively, you can access the project files on Kaggle: www.kaggle.com/datasets/obinnaiheanachor/wisabi-bank-dataset
Thank you for your time in creating this content for us. How about the link for azure map?
To enable Azure Maps Power BI visual, in Power BI Desktop, select File > Options and Settings > Options > Preview features, then select the Azure Maps Visual checkbox. If the Azure Maps visual isn't available after enabling this setting, it's likely that a tenant admin switch in the Admin Portal needs to be enabled.
Thank you for all you do. But then, Azure map visual check box is not in my preview features
Could i upload this project practice on my LinkedIn Page?
Hi Good day, please after working on my data in power query and loading it to the desktop, I keep getting error for the transaction table, the birthdate column. I've checked my locale and don't really know what's wrong.
Please help me
Can you share a screenshot of the error in Power Query here: wisabi.analytics@gmail.com
Just seeing your comment, I'll send it rn
Hi, apparently the date is in US format. So when changing your locale, change it to English (US) and that would solve the issue.
And even the columns that didn't have errors were not displaying the correct date but if you change the locale to US, it'll be solved. I hope this works.
@esther oluwaseyi thanks so much, will try it out
@@estheroluwaseyi9272 hii, thanks but still getting error after changing it to english us fomat after changing the locale when trying to change it data type getting same error plz help
Why the data set is entirely different for me ,dates are in two different format 😢😢 not able to transform into single date data type can anyone help please
Faced the same problem
right click on Date column and in the change Type click on using locale. Check whether your dataset Date format and your regional date format is same.
Hi can you make the power bi project on stock market analysis..
Prediction Market risk Thanks 👍
I'll create a tutorial around this
@@wisabianalytics Thanks 👍