How can I open First Abu Dhabi Bank if there is no bank statement and I have money
@SaberBacari-w3p16 күн бұрын
thanks you so must her is my first project 😄
@CivilEngineer-p9iАй бұрын
Thanks mate
@ItsisswhatissАй бұрын
Hi, I am doing the exact same thing as you and getting this error. error 400. Do you know why?
@skillswithsidАй бұрын
A 400 code indicates a Bad Request to the API, double check your code, make sure you have no mistakes in your Python syntax e.g. no random commas etc. Also make sure your API key is set up and running correctly, you can request for a fresh API key below: developer.company-information.service.gov.uk/manage-applications/add
@skillswithsidАй бұрын
Also make sure your variables are in a single case, Python code is case sensitive, "response" is not the same as "Response", Python will think they are 2 separate variables
@RandomSeven7Ай бұрын
J
@مصطفىالربع-ت7سАй бұрын
hi friends i need an excel dataset regarding NDT
@karthikiyer206Ай бұрын
Excellent video
@nchitha2 ай бұрын
I am getting a key error while merging. Is there a condition that two data frames should have a same number or rows or columns?
@shiot2 ай бұрын
In my opinion, Power BI is easier to learn and it has Power Query but lacks in basic customization
@swizzthesecond2 ай бұрын
Thanks for this helpful video.
@biznezplus2 ай бұрын
Thanks for your presentation and clarification of the distinctions between Tableau and Power BI...
@KhasionJasioen2 ай бұрын
is there a way for the data to not get automatically formatted? i cant seem to find the option to do so on mac
@skillswithsidАй бұрын
What do you mean formatted? Are you referring to changing of the data from the API call?
@KhasionJasioen2 ай бұрын
wow what a workaround LOOOL. thank you
@kebincui3 ай бұрын
Excellent video. Thank you 👍
@AskDrRita3 ай бұрын
Thanks for this insight! Will definitely check up on the different types of averages.
@skillswithsid3 ай бұрын
Full video below kzbin.info/www/bejne/jqK5gGiJbqaWlacsi=-cfS8EglsN62u9Ce
@harjitsandhu73753 ай бұрын
❤
@jor92853 ай бұрын
This video was sooooo helpful. Thanks!!! Coming from strategy analyst in Advertising and wanting to shift to data analyst in Finance. Changed cities and Finance is king in #CLT
@alex7413214 ай бұрын
can't we use text edit for Mac instead of word?
@skillswithsid3 ай бұрын
You can try, I couldn’t get it to work from a text file, but Google Sheets is another option (and free of course)
@niladripaul4 ай бұрын
Hi Sid, this was a very helpful video. You mentioned doing one with looping where we can extract data from a list of company IDs. Any idea when you will be able to publish that?
@skillswithsid4 ай бұрын
Are you after Directors? Or just company information? I should have a new video later this week exploring the api in more detail
@niladripaul4 ай бұрын
@@skillswithsid Director information is one of the KPIs I am looking at. But I suppose if you could explain how the looping works, any parameter from the list of Public Data API reference can be pulled out, right? Look forward to your new video later this week.
@karamalmustafa63954 ай бұрын
Thanks a lot, this was very insightful.
@chandureddy74874 ай бұрын
"Extremely comprehensive and detailed. Thank you on behalf of all of us for providing this information, which has greatly clarified our career choices."
@VHNews4 ай бұрын
Thanks for taking the time to post this, but unfortunately it is not the right way to do it. In "advanced Power Query editor" (also for Mac) you can use Json.document command (nested into a Web.Contents command ) to get the data directly and then structure it by using Record.ToTable commands and Table.FromColumns and so on to get the table data in the right structure. No need for saving an .iqy file and manually structure output. There are lots of articles on the usage of this on stackoverflow and other places. Just saying.
@karimahmuhdhor92674 ай бұрын
Thanks for the video!! What a clear explanation. But I have a question, what if we wanna know the busiest time in a specific day? (like the busiest time on the busiest day)
@chrisder18144 ай бұрын
hello in this video so you are integrating an API into Excel? do you also do this on Google sheet? I think the difference is that on Excel it's very simple since there is a function integrated into the Excel software but on Google sheet I have to download an extension? Or do I have to code in app script?
@MRaju-z8u5 ай бұрын
Hi, i am also trying as a data analyst but my resumes getting rejecting, Could you share your data analyst resume.
@teckniec25 ай бұрын
I'm just starting out and I found Power BI to be more easy for me but I am going to learn both. If I hade to pick one I would pick Tableau because when I search the pay scale, it seemed to be higher.
@riskcatriax5 ай бұрын
Ez video to follow
@riskcatriax5 ай бұрын
Ez video to follow
@NS-tp3vr5 ай бұрын
How to access api with access token that needs to be refreshed?
@skillswithsid5 ай бұрын
I will cover API tokens later this week including Bearer tokens
@NS-tp3vr5 ай бұрын
@@skillswithsid Can we import data from api with access token needs to be refreshed?
@sathishkumar_6985 ай бұрын
Thanks a lot, Sid. It really helped to get a better understanding.
@mkolassa5 ай бұрын
Excellent Video. Clear and concise
@skillswithsid5 ай бұрын
Thank you! Do let me know if there is any other content you want me to cover in future
@jaymurallon5 ай бұрын
Great video, thanks. Could you please create another one where you can pass Bearer Token?
@skillswithsid5 ай бұрын
@@jaymurallon thanks Jay, yes will do a video on Bearer Tokens this July, appreciate the suggestion.
@skillswithsid5 ай бұрын
Have an API you want me to explore? Share in the comments below and I will do a video on it
Best tableau abd Power bi comparison ever for beginners.
@skillswithsid5 ай бұрын
Thank you for your kind words!
@u1002s5 ай бұрын
Find out my customized API connector! kzbin.info/www/bejne/pKarf5yensyca9ksi=IriD6XG5vIAJyAOd
@MonjuMeah5 ай бұрын
Great tutorial!
@ShivaniSorakhe5 ай бұрын
Helpful Video. Thanks!
@ahhkekeke5 ай бұрын
Love it Sid! V lookups are a fundamental tool in any data analysts arsenal!
@skillswithsid5 ай бұрын
Link to Vlookup video here: kzbin.info/www/bejne/qXzWmnyCopJ4d68si=plOaPZHbe-_qcbfg
@Drive_Success5 ай бұрын
I need to brush up on excel skills
@sukumarborman1525 ай бұрын
It's great learning in short form
@jamiewing44685 ай бұрын
Thanks Sid, this is excellent - it's easy to understand and straight to the point. You deserve more views
@skillswithsid6 ай бұрын
In this video I used a data analytics maturity framework originally devised by Gartner back in 2014, you can read more about this here: www.gartner.com/en/newsroom/press-releases/2014-10-21-gartner-says-advanced-analytics-is-a-top-business-priority
@aizaadvincula86696 ай бұрын
More python topic pls.. Newbie here.. can you do vid like python intro for beginners, ?
@skillswithsid5 ай бұрын
More Python vids coming soon!
@matthewhealy97106 ай бұрын
Awesome tips! Can you dynamically pass parameters into the iqy file or do you have to create a new file each time and then run it in PQ? I suspect the answer is the latter unfortunately.
@alfonsosundblad32756 ай бұрын
Great Video! Question: how could i put the user number in a cell and have it referenced in the query? for my use case it would be a date, since my coworkers wont use power queries they will need the value outside of it