LEVEL UP YOUR BUSINESS ANALYSIS with our Videos tutorials, weekly videos covering business analytics concepts and tools such as SQL, Excel, PowerBi and Python. This channel is aimed at business users and students who want to leverage data analysis tools to improve their role performance or data analytics portfolios. My name is Adam, I am in the midst of a varied techo-functional career where I have worked as a data end user (business analyst / accountant) and am now leading some finance analytics projects for one of the world's top consultancy firms. Using my experience with both large and small business I hope to share relevant, usable and actionable tutorials / walkthroughs. I believe in lifelong learning and am learning everyday. #businessanalytics #businessanalysis #dataanalytics #datavisualization #dataanalysis #bigquery #powerbi #SQL #excel #python
Thankyou Adam for putting up this beginners video on writing app script. I am a complete novice in this area and was finding it really hard to navigate through this vast field. However, because of your video study guide I wrote my first app script and it worked. I hope you will add more such beginners tutorials 😊.
Thank you! Is there a way to make this same excel public so it can be accessed from a link, while always being actualized without the need for me to refresh it manually?
Adam, if I will have multiple tables pulled from BigQuery and multiple Pivot Tables, will the user need to update each Pivot Table separately, or is the data refresh global?
Nope there is a scheduled data refresh if you create the pivots from the live data where you can choose to refresh all artefacts also (graphs / pivots tables etc) you can do it on a trigger
No this model not good in High reasoning Like writing an old classical Arabic poem in a certain meter and with a unified rhyme and rhyme. But Claude is better than him in this aspect, although it fails in some verses, it is close to doing them, unlike Gemini.
Hi Adam, your videos are so amazing! Could you please helpe me? I'm in trouble trying to get a calculated field with numbers with a Venn Diagram report resources. Could you please help me? I saw you let your e-mail here, may i send you? Thank you a lot
Thanks Clare. I have done two follow up video on this topic that you could find useful. They bring some more options in to the mix. Going to do one on implementing the solution directly in sheets in the next few weeks. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-A1III_DQU4I.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0FtcHjI5lmw.html
@@analyticswithadam wow, that's really amazing! Will watch the two video as well. Just a question Adam, do you think it's possible to extract the most engaged (comments, likes) RU-vid accounts in a certain channel using RU-vid API?
@@claireivy-d3p Id say first its collect all the comments from all the videos then pivot it up on account with count of comments. Don't think you can get likes by account by ill look in to it.
Do you know how to configure a chart for dynamic L12M? So not for a calendar year of so but for example July 2023 - July 2024, and compare that to the previsous year
@@analyticswithadam Well, since you asked 🙂I'm sure that many viewer would like to understand why in Excel, we have to install a driver to connect to a Postgresql while in Power BI, we don't ....
brand new to Looker. So sorry of I ask dumb question. DO I have to do the joins for each report? is there a way like in PowerBI to have a data model set up , so i don't have to do the links for each report? Or do I have to create a "master" report with all the joins and copy that each time I create a new report? Cheers (i will go on a course in near future)
Here is the official Answer Blends get their information from multiple data sources. Blends are always embedded into the report in which they are created. You can't make a blend reusable across reports. However, if you copy the report, the blends are copied into the new report, so your charts will continue to work on the blended data. But depending on the datasource you might be able to do the blend at source. Where is the data coming from?
I need to get up to speed on Looker Studio as quickly as possible. This video is great - no filler or waffle, just awesome tips from the get go. Cheers Adam.
Thank you for the video Adam. For people who wish to go on to the Associate Cloud Engineer certification, would you also recommend ExamPro? Do they have labs baked into their course?
Hi Adam! How much JavaScript knowlege is required for this? I came across this while going though a job description & I am thinking to learnt this tool. I only know python & R language.
Hi Vivek , A little bit of JS to customise but its mostly internal api functions with the Google workspace apis. I’ve been getting help off Claude and chat gpt with the coding… there is a good course on Udemy too that’s fairly cheap.
If you have a good handle on basic programming syntax it’s not a heavy lift. I’m building some super useful things at my company and am not an expert at JS
@@analyticswithadam Recording with macro & seeing the code seems a cool idea. One more..unrelated question as you seem to be working in tech. Sorry to bother 😅 Actually learning JavaScript was on my mind but I couldn't decide it. I am not from Engineering background. I am trying to make a career change from non-tech field. I learned data analytics tools and techniques, build projects also but the market is bad right now for career transitioners. I am thinking to reconsider my goals and learn web development but that requires a lot of time. I got some career gap as I am not working. Would learning Front End to start working in tech be a good decision at this point? I know some basic html and costs stuff. I have a JS course on Udemy. My only problem is my huge career gap which may impact when applying. Pretty entangled and don't have friends in tech who could help. So, thought to ask you.
@analyticswithadam I don't know anything about code, all I can do is copy and paste I watched a tutorial in which the RU-vidr explained how to copy and paste the openAI API into a Google sheet module in order to use chatgpt in Google sheet and so I ask you how can I use another API when there is no module available?
@@analyticswithadam I'm asking you this question because I don't know anything about coding and I'm starting to use make software And I'm wondering about other automation software, what other software do you use? Do you also create Chrome or WordPress extensions? Do you also use custom gpt?
@@chrisder1814 Hi Chris, I use Power Automate which is a microsoft tool but people in my company use UI Path for automation. It depends on the tech stack they are all similar. I do not create extensions, just focused on data analytics for finance so use whatever helps me there
Updated Code ---- Use this one, in some cases issues with the original code in the description github.com/analyticswithadam/Python/blob/main/Web_Scraping_from_TrustPilot%20v2.ipynb
Two possible ways - this is a bound script which means it’s attached to the sheet. For an unbound script or a bound script attaching to another sheet you just capture the sheets id and connect to it that way
He throws out this videos and doesn't even state that you have to pay for the v.2, and never replies to anyone that asks him questions. So here goes: Is there a way to do this on the FREE version? I'd rather try it for free and get it working, before I start paying $100 or more per month.?
I made this video before Elon took over twitter and put the basic api behind a paywall. It’s possible to use a web scraping tool like beautiful soup but it’s not entirely legal
Hi! Can you make a video on how we can Fine tune the gpt on custom dataset with image. And then in colab code we will use the API and our Fine tuned model to test it with image whether it can response like our image text pair dataset.
@@analyticswithadam I have a multimodal dataset(image + text). And I want to use this dataset to train the gpt model. And then I can ask question from my dataset with image and it can answer me based on the image and my question.
great video! can you dive a little deeper into how can we can create a script that copies only the last row from a given sheet (general sheet) and then filter it for it to land into an specific sheet depending on a specific value and date? is that even posible?
I created a developers account for myself, but those keys that you are showing stay hidden. I can not copy them or access any of them except bearer's key. Any suggestions?
i have a problem in PQ in Excel (2019 v)... data preview tab in power query at excel shows only two options ( whitespace - monospacced ) how i show column quality option ? all the best...