Видео

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?

In my opinion, Power BI is easier to learn and it has Power Query but lacks in basic customization

Thanks for this helpful video.

Thanks for your presentation and clarification of the distinctions between Tableau and Power BI...

is there a way for the data to not get automatically formatted? i cant seem to find the option to do so on mac

wow what a workaround LOOOL. thank you

Excellent video. Thank you 👍

Thanks for this insight! Will definitely check up on the different types of averages.

Full video below ruclips.net/video/XqVO5S9Ac_E/видео.htmlsi=-cfS8EglsN62u9Ce

❤

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

can't we use text edit for Mac instead of word?

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?

Thanks a lot, this was very insightful.

"Extremely comprehensive and detailed. Thank you on behalf of all of us for providing this information, which has greatly clarified our career choices."

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.

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)

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?

Hi, i am also trying as a data analyst but my resumes getting rejecting, Could you share your data analyst resume.

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.

Ez video to follow

Ez video to follow

How to access api with access token that needs to be refreshed?

Thanks a lot, Sid. It really helped to get a better understanding.

Excellent Video. Clear and concise

Great video, thanks. Could you please create another one where you can pass Bearer Token?

Have an API you want me to explore? Share in the comments below and I will do a video on it

ruclips.net/video/_6wmXAp_duY/видео.htmlsi=4S-ucz1dm_zmq1hn

Best tableau abd Power bi comparison ever for beginners.

Find out my customized API connector! ruclips.net/video/nuHNihigi5w/видео.htmlsi=IriD6XG5vIAJyAOd

Great tutorial!

Helpful Video. Thanks!

Love it Sid! V lookups are a fundamental tool in any data analysts arsenal!

Link to Vlookup video here: ruclips.net/video/sKsiILm-EAM/видео.htmlsi=plOaPZHbe-_qcbfg

I need to brush up on excel skills

It's great learning in short form

Thanks Sid, this is excellent - it's easy to understand and straight to the point. You deserve more views

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

More python topic pls.. Newbie here.. can you do vid like python intro for beginners, ?

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.

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

Perfectly explained ❤

Thank you very much!

THANK YOU. 👍👍👍👍 I have been trying to understand how to integrate private APIs, into Excel. Yours is the first I have viewed, as a non-coder, that is clearly comprehendible. It's about the 10th one, including two series, on the topic, that were supposedly beginner level: not. I needed to work out how to transpose the information, into the various parameter, values, etc., which I was struggling with. This at least gives me more knowledge on trying to work out the supplied coding; & where to insert it, into the Excel 'from web' setup.

Hey Sid! Awesome video! I would draw your attention to one aspect that is often overlooked - Data Protection! You need to be compliant with your country's Data Protection legislation. In the UK it is making sure that your data doesn't leave the UK/EU and making sure you are clear with what you tell your customers about the processing of their data. Also, need to be mindful when using AI that you don't push any automated decision making through AI as that will can become a big issue very quickly. Lots of love! Keep up the good work!

Full length video on Cloud Computing on my channel here: ruclips.net/video/sajR8kE-TwE/видео.html

Many of you will have heard of Cloud Computing, in this video I explain what you need to know about Cloud Computing and future career paths. Its an exciting field and one which is growing every year.

Thanks!!!

Thanks!

How can I input Google map or Bing map/ route API for calculating daily milage in Excel spreadsheet from address to address. I tried following using your video but Google doesn't show v2 documentation.. very new to this and get lost on the website as what is my next step? Can you do a video on inputting information from google maps in Excel?