- 40
- 142 139
Analyze It
Приєднався 28 січ 2015
Welcome to Analyze It, your go-to source for comprehensive insights into the world of analytics and data analysis tools. On my UA-cam channel, I create videos that unlock the potential of various analytic and analysis tools. Join me as we dive deep into the realms of Power BI, Microsoft Excel, Power Pivot, DaX (Data Analysis Expression), Python, Machine Learning and more.
My mission is to empower you with practical knowledge and guidance, enabling you to apply analytics effectively. Through my videos, you'll gain a solid understanding of these software tools and how they can be utilized to analyze data.
Have burning questions or specific topics you'd like me to cover? I'm here to assist you! Feel free to reach out to me at nael150571@gmail.com with any inquiries, suggestions, or even business-related matters.
Let's embark on a journey together, uncovering the insights and possibilities that data analysis has to offer.
My mission is to empower you with practical knowledge and guidance, enabling you to apply analytics effectively. Through my videos, you'll gain a solid understanding of these software tools and how they can be utilized to analyze data.
Have burning questions or specific topics you'd like me to cover? I'm here to assist you! Feel free to reach out to me at nael150571@gmail.com with any inquiries, suggestions, or even business-related matters.
Let's embark on a journey together, uncovering the insights and possibilities that data analysis has to offer.
Create visualizations with ChatGPT and get the Python codes
Unlock the power of AI with ChatGPT and take your data visualization skills to the next level! In this 2 minutes video, I’ll show you how to leverage ChatGPT for creating stunning correlation heatmaps and then get the Python codes. Whether you're a data analyst, a student, or just someone looking to enhance your data presentation skills, this step-by-step guide will empower you to transform complex data into beautiful and insightful visuals with ease.
Переглядів: 81
Відео
Instantly analyze image, charts & generate report with ChatGPT4o
Переглядів 1815 місяців тому
Discover the incredible potential of ChatGPT-4o ! In this video, I'll guide you through how to leverage OpenAI's multimodal chatbot to analyze charts directly from images. Learn how to prompt the model to create a comprehensive Word document that highlights key insights, findings, and takeaways. Finally, watch as the model generates a downloadable link for your ready-made report. Elevate your d...
Transform Your Fridge into Delicious Meals with ChatGPT 4o
Переглядів 595 місяців тому
Discover how you can revolutionize your kitchen routine using ChatGPT 4o! In this video, I'll show you how to upload a picture of your refrigerator's contents and let ChatGPT 4o analyze it for you. Watch as I receive insightful suggestions on what dishes I can prepare based on what's in my fridge. It's an easy, fun, and smart way to make the most out of your groceries and try new recipes. Join ...
Translate French PDFs to English Word Docs Using ChatGPT
Переглядів 1755 місяців тому
I'll be demonstrating the incredible power of ChatGPT for seamless translations. Watch as I take a French PDF document and transform it into a beautifully formatted English Word document with just a few simple prompts. I'll walk you through the entire process, from designing the perfect prompt to ensuring accurate and clear translations. Whether you're a student, professional, or just curious a...
Transform Your Notes: Handwritten to Digital Text with ChatGPT OCR
Переглядів 9848 місяців тому
This video is a step-by-step guide on how to transform any text captured in a photo into typed text effortlessly. Whether it's notes from a meeting, pages from a book, or just a random piece of paper you found interesting, I'll show you how to transcribe it quickly and accurately. We're diving into the world of OCR - Optical Character Recognition technology, and I'll be using ChatGPT, a powerfu...
Connecting and fetching data from Kobo toolbox in Python
Переглядів 5569 місяців тому
In this tutorial, I demonstrate the process of linking Kobo Toolbox with Python to retrieve data. Detailed instructions are given on how to accomplish this using Google Colab. You can access the entire code for this tutorial using that link github.com/naeljb/python/blob/branch-1/kobo_in_python_version_github.ipynb
Easy Audio to Text using Python & OpenAI
Переглядів 1,9 тис.9 місяців тому
In this tutorial, I demonstrate the process of converting an audio file into text format by using Python and the OpenAI speech-to-text engine. The focus will be on utilizing the OpenAI API to accurately transcribe and translate a single audio file in Python. You will find the entire code for this tutorial in my github account. Use that link: github.com/naeljb/speech-to-text/blob/main/Transcribe...
Demo of audio transcriber application
Переглядів 339 місяців тому
This video is a demonstration of the alpha version of an application that I developed that allows to transcribe audio record into text. I utilized Whisper-1, a speech transcription model developed by OpenAI (the creators of ChatGPT) to build this application. It cost me only 0.06 cents per minute of audio transcribed and it has high level of accuracy for 57 different languages including English...
How to create a customized map with google my map
Переглядів 113Рік тому
In this video, I’m showing how you can import a dataset that is composed with a list of locations and their GPS coordinate to create a customized map. I’m using google drive for my map to build that map.
Use of ChatGPT for missing values handling
Переглядів 193Рік тому
In this tutorial, I will demonstrate how ChatGPT can assist you in managing missing values while cleaning structured datasets. The primary focus will be on employing techniques such as imputation, deletion, and KNN machine learning to effectively handle the missing data. By the end of the video, you will have a clear understanding of how to leverage ChatGPT's capabilities for seamless data prep...
How to run Machine Learning with ChatGPT plugin
Переглядів 201Рік тому
This video demonstrates how to use ChatGPT plugin to run machine learning. I specifically show how to run K-Means cluster using Notable plugin. I will show how to upload a dataset from Notable to ChatGPT, then I will type prompts to run K-Means algorithm with python codes.
Analyse de données et creation d'information a l'aide de ChatGPT
Переглядів 330Рік тому
Dans cette vidéo, je démontre l'utilisation de l'interpréteur de code ChaptGPT dans le but d'analyser une base de données, de générer des graphiques visuels et d'extraire des informations simplement en tapant une question ou un prompte. En outre, je montre comment demander à ChatGPT de rédiger un brouillon d’article sur en utilisant la base de données, et je montre la possibilité d'améliorer l'...
Dataset insights through ChatGPT
Переглядів 101Рік тому
In this video, I demonstrate the utilization of the ChaptGPT code interpreter for the purpose of analyzing a dataset, generating visual charts, and extracting insights simply by typing a question or prompt. Furthermore, I showcase the ability to request ChatGPT to draft an article based on the provided dataset, and highlight the potential for enhancing the article by providing additional contex...
Partitioning a dataset with an optimum number of clusters
Переглядів 99Рік тому
In this video, I'm showing how to determine the optimum number of clusters with K-Means Machine Learning. Specifically, I discuss the inertia measurement and the elbow method. Finally, I use a dataset and compute the optimum number of cluster and then run K-mean clustering in Python. Through this video (project), I'm using several libraries such as Pandas, Numpy, Matplotlib, Seaborn and SKlearn...
How to generate barcodes from a customer list in Excel
Переглядів 73Рік тому
How to generate barcodes from a customer list in Excel
How to do a pairplot in Power BI using Python
Переглядів 487Рік тому
How to do a pairplot in Power BI using Python
Comment importer un tableau d'une page Web vers Excel
Переглядів 1,7 тис.Рік тому
Comment importer un tableau d'une page Web vers Excel
How to import a table from a web page into Excel or Power BI
Переглядів 993Рік тому
How to import a table from a web page into Excel or Power BI
How to do a Paired T-test with Excel ?
Переглядів 1062 роки тому
How to do a Paired T-test with Excel ?
Descriptive Statistics Table in Excel
Переглядів 2,4 тис.2 роки тому
Descriptive Statistics Table in Excel
Creating a new table using a conditional column from another table in Excel
Переглядів 3,1 тис.2 роки тому
Creating a new table using a conditional column from another table in Excel
Automating conditional column values in Kobo Toolbox using Power BI
Переглядів 3292 роки тому
Automating conditional column values in Kobo Toolbox using Power BI
Automation of data update and transformation in Power BI from Kobo Toolbox
Переглядів 3,6 тис.2 роки тому
Automation of data update and transformation in Power BI from Kobo Toolbox
Pivoting column table in Excel via Power Query
Переглядів 742 роки тому
Pivoting column table in Excel via Power Query
Inner Joint with Excel via Power Query
Переглядів 1232 роки тому
Inner Joint with Excel via Power Query
Clustering and outliers detection with DBSCAN in Power BI
Переглядів 7722 роки тому
Clustering and outliers detection with DBSCAN in Power BI
Python Machine Learning in Power Bi : Decision Tree algorithm
Переглядів 8462 роки тому
Python Machine Learning in Power Bi : Decision Tree algorithm
Python Machine Learning in Power BI: K-Means algorithm
Переглядів 1,8 тис.2 роки тому
Python Machine Learning in Power BI: K-Means algorithm
Python in Power BI, part 4 : Correlation heatmap
Переглядів 1,6 тис.2 роки тому
Python in Power BI, part 4 : Correlation heatmap
You are one the best teacher online that follow. Thank you for your tutorial. It's very clear even for a non english native.
very clear presentation. how do i get the value labels instead of the values?
Eres lo máximo :)
That is amazing 🙂 - I see you can try 2 times and then it blocks you - that is a pity - is there a way around it instead of paying $ 20.00 per month
Merci la video, tres pedagogique.
Great tutorial. This is very helpful for me. Thank you
Superb
Thank you! This is truly helpful!
how to use audio link instead of file
Have you try to put the url link ? # create a variable that provides the path of your audio file audio_path = " include your URL link "
could you help me ? When i execute the fourth step this error occurs: JSONDecodeError Traceback (most recent call last) File ~\AppData\Roaming\Python\Python311\site-packages equests\models.py:971, in Response.json(self, **kwargs) 970 try: --> 971 return complexjson.loads(self.text, **kwargs) 972 except JSONDecodeError as e: 973 # Catch JSON-related errors and raise as requests.JSONDecodeError 974 # This aliases json.JSONDecodeError and simplejson.JSONDecodeError File C:\ProgramData\anaconda3\Lib\json\__init__.py:346, in loads(s, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw) 343 if (cls is None and object_hook is None and 344 parse_int is None and parse_float is None and 345 parse_constant is None and object_pairs_hook is None and not kw): --> 346 return _default_decoder.decode(s) 347 if cls is None: File C:\ProgramData\anaconda3\Lib\json\decoder.py:337, in JSONDecoder.decode(self, s, _w) 333 """Return the Python representation of ``s`` (a ``str`` instance 334 containing a JSON document). 335 336 """ --> 337 obj, end = self.raw_decode(s, idx=_w(s, 0).end()) 338 end = _w(s, end).end() File C:\ProgramData\anaconda3\Lib\json\decoder.py:355, in JSONDecoder.raw_decode(self, s, idx) 354 except StopIteration as err: --> 355 raise JSONDecodeError("Expecting value", s, err.value) from None 356 return obj, end JSONDecodeError: Expecting value: line 2 column 1 (char 1) During handling of the above exception, another exception occurred: JSONDecodeError Traceback (most recent call last) Cell In[9], line 1 ----> 1 data = kobo.get_data(form_id) File ~\AppData\Roaming\Python\Python311\site-packages\koboextractor\__init__.py:143, in KoboExtractor.get_data(self, asset_uid, query, start, limit, submitted_after) 141 if self.debug: print(f'KoboExtractor.get_data: Calling {url}') 142 response = requests.get(url, headers=headers) --> 143 return response.json() File ~\AppData\Roaming\Python\Python311\site-packages equests\models.py:975, in Response.json(self, **kwargs) 971 return complexjson.loads(self.text, **kwargs) 972 except JSONDecodeError as e: 973 # Catch JSON-related errors and raise as requests.JSONDecodeError 974 # This aliases json.JSONDecodeError and simplejson.JSONDecodeError --> 975 raise RequestsJSONDecodeError(e.msg, e.doc, e.pos) JSONDecodeError: Expecting value: line 2 column 1 (char 1) any idea what it might be happening ?
Many thanks ! good explanation
Could you please create a video demonstrating how to integrate Kobotoolbox into an ASP MVC C# application using its API?
Unfortunately, ASP.NET MVC application in C# is not my domain of knowledge
does it work with math formulas?
Good question, I have not tested this but perhaps you could experiment this
This is helpful
wonderful video
Thank you
I liked it and I subscribed :) great work :)
Great video!
Thank you so much. I never seen a very simple way of controlling outliers in your dataset as good as this.
Glad it was helpful!
Also please note that z-score method assumes the data sets has a frequency distribution that are mound shaped and symmetric.
In this video, I was using a hold version of openai module. If you have installed and updated version, the openai.Audio.transcribe method that I used to create the transcript variable will not work. Instead use openai.audio.transcriptions.create . I updated the code in github. Feel free to access it via this link github.com/naeljb/speech-to-text/blob/main/Transcribe%20audio%20in%20python%20with%20Whisper-1.ipynb You can also check openai website for documentation at : platform.openai.com/docs/guides/speech-to-text/quickstart
Nice!
What did you use to create this app? Do you have the exe file
I used Tkinter. Yes, I have a executable file. For now it is the alpha version
Very nice.
I need an app that can translate audio in real time from portagues language to English. Is there any application like this?
As I explained in the description of this video, I utilized Whisper-1 text to speech engine ( developed by OpenAI) for transcribe and then build this Application using Tkinter. You can then use the same engine and the translations API takes as input the audio file in any of the supported languages and transcribes, if necessary, the audio into English. This differs from /Transcriptions endpoint since the output is not in the original input language and is instead translated to English text. Being said my App for now doesn't do translation but this is something that is totally possible. Perhaps it is a good idea for further improvement by adding a window/feature for translation into English.
@@AnalyzeIt_Nael I need it for learning Power BI but most of the best content I found is in Portuguese language.
Congratulations🎉
Merci, vous êtes très pédagogue.
Merci beaucoup
can you add more explanation points about two plots ?
share github link for dataset
Please share this dataset file
Bonjour Nael, c’est super aidant, je vous fais un mail. Merci, Jean
you just talk and show zero
Merci pour ce partage très contributif
hi, thank you a lot for your video. does this only work for power bi desktop or also for power bi online?
très bonne explication, avec un bon rythme.Bravo
Très bonne pédagogie ...je veux un prof particulier comme vous
Merci pour les mots d'encouragements.
Thank you for the video but here is my problem : Web.Contents failed to get contents from the API, how will I solve this problem
The error "Web.Contents failed to get contents from the API" in Excel typically means that Excel was unable to retrieve data from the specified API endpoint. This error can occur due to several reasons, such as incorrect API endpoint URL, missing or incorrect authentication credentials, network connectivity issues, or an issue with the API itself. To solve this problem, you can try the following steps: 1) Verify that the API endpoint URL is correct and active. 2) Check if you have provided the correct authentication credentials, such as API key, OAuth token, etc. 3) Ensure that your network connection is stable and there are no firewalls blocking the connection. 4) Try to access the API endpoint using a web browser or other tools to confirm that the endpoint is working correctly. 5) If the issue persists, you may need to contact the API provider or your IT department for further assistance. It is also worth noting that some APIs have rate limits or other usage restrictions that may cause errors, so make sure to check the API documentation for any such restrictions. Hope this helps
amazing! simple and effective, the way i like
Please also sentiment analysis in power query "dataset call" feature through python package like NLTK.
Thank for your suggestion, this is an area that I'm currently investigating as well and how this can work best with Power BI.
You can find the PDF version of these codes via this URL drive.google.com/file/d/1Ghna1RtQcVzdCBHxLtKur66xjukMnd5M/view?usp=share_link You can also access the entire codes in Jupyter notebook via my Github account : github.com/naeljb/python/blob/main/KMeans_elbow_project.ipynb
Thanks for this very informative video Sir. Please also do videos on this "Magic" dataset call. I think this take our data analysis to the next level. Hope you explore it further in your videos and I really keen to watch out and learn from your unique videos. Thank. ua-cam.com/video/F2M4F4sUDw8/v-deo.html
The code 39 font that I'm using for this video can be found at www.1001freefonts.com/idautomation.com-code-39-barcode-font-free-version.font
Hi, when I make my login tell me that my credention that was given to me, but I enter in the kobo toolbox to create the projects, and I have a lot of information that I need to transport to excel. Can you help me, and tell me what I need to do? That you for all support
not sure I understand your problem. when you connect to the web in Power BI, you have to plug the URL of your project in KOBO. Then it will ask you to enter the logging and password and these are the one from your Kobo account
Hi! Analyze It, Glad you know your development and Analysis on KMeans Clustering, And I hope you might have share the Elbow method as to make the basket of clusters. Cheers!
I will
Superb simple Explanation ... Very good easy to understand the content... Keep up the good work!!!!
The python codes for this video can be found here docs.google.com/document/d/1-q3Fh0rfZ6jLEHBH0Mf_Krl9_3iWyLSe/edit?usp=share_link&ouid=113822024531173115708&rtpof=true&sd=true
@Analyze it. Can I edit Data in the Excel and its also updated in Kobo? Thats it i linked them up
Thank you, It was very helpful, and you explained it excellently!
You are welcome
When I click XLS it doesn't download the file, it only shows blank white screen
One issue, after loading data to excel, some of the data is missing. how can I fix it
this is weird. Did you get an error message