Create a GITHUB profile EASILY
17:19
Пікірлер
@RASEL-rb6co
@RASEL-rb6co 2 күн бұрын
How can I open First Abu Dhabi Bank if there is no bank statement and I have money
@SaberBacari-w3p
@SaberBacari-w3p 16 күн бұрын
thanks you so must her is my first project 😄
@CivilEngineer-p9i
@CivilEngineer-p9i Ай бұрын
Thanks mate
@Itsisswhatiss
@Itsisswhatiss Ай бұрын
Hi, I am doing the exact same thing as you and getting this error. error 400. Do you know why?
@skillswithsid
@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
@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
@RandomSeven7 Ай бұрын
J
@مصطفىالربع-ت7س
@مصطفىالربع-ت7س Ай бұрын
hi friends i need an excel dataset regarding NDT
@karthikiyer206
@karthikiyer206 Ай бұрын
Excellent video
@nchitha
@nchitha 2 ай бұрын
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?
@shiot
@shiot 2 ай бұрын
In my opinion, Power BI is easier to learn and it has Power Query but lacks in basic customization
@swizzthesecond
@swizzthesecond 2 ай бұрын
Thanks for this helpful video.
@biznezplus
@biznezplus 2 ай бұрын
Thanks for your presentation and clarification of the distinctions between Tableau and Power BI...
@KhasionJasioen
@KhasionJasioen 2 ай бұрын
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
@skillswithsid Ай бұрын
What do you mean formatted? Are you referring to changing of the data from the API call?
@KhasionJasioen
@KhasionJasioen 2 ай бұрын
wow what a workaround LOOOL. thank you
@kebincui
@kebincui 3 ай бұрын
Excellent video. Thank you 👍
@AskDrRita
@AskDrRita 3 ай бұрын
Thanks for this insight! Will definitely check up on the different types of averages.
@skillswithsid
@skillswithsid 3 ай бұрын
Full video below kzbin.info/www/bejne/jqK5gGiJbqaWlacsi=-cfS8EglsN62u9Ce
@harjitsandhu7375
@harjitsandhu7375 3 ай бұрын
@jor9285
@jor9285 3 ай бұрын
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
@alex741321
@alex741321 4 ай бұрын
can't we use text edit for Mac instead of word?
@skillswithsid
@skillswithsid 3 ай бұрын
You can try, I couldn’t get it to work from a text file, but Google Sheets is another option (and free of course)
@niladripaul
@niladripaul 4 ай бұрын
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?
@skillswithsid
@skillswithsid 4 ай бұрын
Are you after Directors? Or just company information? I should have a new video later this week exploring the api in more detail
@niladripaul
@niladripaul 4 ай бұрын
@@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.
@karamalmustafa6395
@karamalmustafa6395 4 ай бұрын
Thanks a lot, this was very insightful.
@chandureddy7487
@chandureddy7487 4 ай бұрын
"Extremely comprehensive and detailed. Thank you on behalf of all of us for providing this information, which has greatly clarified our career choices."
@VHNews
@VHNews 4 ай бұрын
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.
@karimahmuhdhor9267
@karimahmuhdhor9267 4 ай бұрын
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)
@chrisder1814
@chrisder1814 4 ай бұрын
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-z8u
@MRaju-z8u 5 ай бұрын
Hi, i am also trying as a data analyst but my resumes getting rejecting, Could you share your data analyst resume.
@teckniec2
@teckniec2 5 ай бұрын
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.
@riskcatriax
@riskcatriax 5 ай бұрын
Ez video to follow
@riskcatriax
@riskcatriax 5 ай бұрын
Ez video to follow
@NS-tp3vr
@NS-tp3vr 5 ай бұрын
How to access api with access token that needs to be refreshed?
@skillswithsid
@skillswithsid 5 ай бұрын
I will cover API tokens later this week including Bearer tokens
@NS-tp3vr
@NS-tp3vr 5 ай бұрын
@@skillswithsid Can we import data from api with access token needs to be refreshed?
@sathishkumar_698
@sathishkumar_698 5 ай бұрын
Thanks a lot, Sid. It really helped to get a better understanding.
@mkolassa
@mkolassa 5 ай бұрын
Excellent Video. Clear and concise
@skillswithsid
@skillswithsid 5 ай бұрын
Thank you! Do let me know if there is any other content you want me to cover in future
@jaymurallon
@jaymurallon 5 ай бұрын
Great video, thanks. Could you please create another one where you can pass Bearer Token?
@skillswithsid
@skillswithsid 5 ай бұрын
@@jaymurallon thanks Jay, yes will do a video on Bearer Tokens this July, appreciate the suggestion.
@skillswithsid
@skillswithsid 5 ай бұрын
Have an API you want me to explore? Share in the comments below and I will do a video on it
@skillswithsid
@skillswithsid 5 ай бұрын
kzbin.info/www/bejne/lWfanot3pcSXq7ssi=4S-ucz1dm_zmq1hn
@user-yd6jg2xe7u
@user-yd6jg2xe7u 5 ай бұрын
Best tableau abd Power bi comparison ever for beginners.
@skillswithsid
@skillswithsid 5 ай бұрын
Thank you for your kind words!
@u1002s
@u1002s 5 ай бұрын
Find out my customized API connector! kzbin.info/www/bejne/pKarf5yensyca9ksi=IriD6XG5vIAJyAOd
@MonjuMeah
@MonjuMeah 5 ай бұрын
Great tutorial!
@ShivaniSorakhe
@ShivaniSorakhe 5 ай бұрын
Helpful Video. Thanks!
@ahhkekeke
@ahhkekeke 5 ай бұрын
Love it Sid! V lookups are a fundamental tool in any data analysts arsenal!
@skillswithsid
@skillswithsid 5 ай бұрын
Link to Vlookup video here: kzbin.info/www/bejne/qXzWmnyCopJ4d68si=plOaPZHbe-_qcbfg
@Drive_Success
@Drive_Success 5 ай бұрын
I need to brush up on excel skills
@sukumarborman152
@sukumarborman152 5 ай бұрын
It's great learning in short form
@jamiewing4468
@jamiewing4468 5 ай бұрын
Thanks Sid, this is excellent - it's easy to understand and straight to the point. You deserve more views
@skillswithsid
@skillswithsid 6 ай бұрын
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
@aizaadvincula8669
@aizaadvincula8669 6 ай бұрын
More python topic pls.. Newbie here.. can you do vid like python intro for beginners, ?
@skillswithsid
@skillswithsid 5 ай бұрын
More Python vids coming soon!
@matthewhealy9710
@matthewhealy9710 6 ай бұрын
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.
@alfonsosundblad3275
@alfonsosundblad3275 6 ай бұрын
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
@tejascookstableau
@tejascookstableau 7 ай бұрын
Perfectly explained ❤
@friodia
@friodia 7 ай бұрын
Thank you very much!