I love learning with examples, very good video I was bummed it finished so soon but in hindsight, I've learnt exactly what data profiling is and how it can be performed in Excel, it also reassured me that data profiling is an essential step in a data analysis pipeline. This video will help me divide my workflow.
I keeep getting this error when I do the process: Expression.Error: A cyclic reference was encountered during evaluation. Any advice on how i can clear this?
it's because you use the table you just create as the source for your profiling. hence the cyclic reference. you have to use an existing table not the one you create right now
This video is really interesting to share with my business users, thanks!!!! However, for me, I will go on with my OpenRefine tool for Data Profiling and Data Preparation :-). **Edited, I mispelled the tool.
@@LightsOnData ahggg, sorry, I wrote wrong the tool name, I was answering to your video whilst I was performing a task with another tool called "*Resumed*" :-) It is OpenRefine, not as user-friendly as other visual tools, but really powerful with a great scripting transforming language.
Good video, George. I was wondering if PQ whether in Power Pivot or Power BI has any function that could do some EDA, like we do in Python or other languages. In Python I really like Dtale library simply marvellous. Is there anything closer to this in PQ?
I had to do data profiling today using excel on the first day of my new job. You literally saved my life!!!!
Glad to be of help, Manali.
Very good video, it helps a lot in exploring new data files, thank you! Best wishes from Holland!
This is very useful, thanks, George. I will incorporate it into my DQ class as an alternative to the Ataccama DQ Analyzer.
I’m glad to hear that Gordon. Thank you!
Great introduction video. I really wish that an extended video can be done with several examples
Glad you liked it! I'll add it to the list.
I love learning with examples, very good video I was bummed it finished so soon but in hindsight, I've learnt exactly what data profiling is and how it can be performed in Excel, it also reassured me that data profiling is an essential step in a data analysis pipeline. This video will help me divide my workflow.
I'm glad you found this useful.
I keeep getting this error when I do the process: Expression.Error: A cyclic reference was encountered during evaluation. Any advice on how i can clear this?
Hi Ben, it's hard for me to tell without following what you've done. Did you follow the steps in the video?
@@LightsOnData yes each and every step.. I even tried using different data sets, keep getting the same message
@@benomondi296 the error is not usually due to a data issue. Can you share your file with me so I can take a look at the formulas?
it's because you use the table you just create as the source for your profiling. hence the cyclic reference. you have to use an existing table not the one you create right now
Thanks, George, very useful.
I'm glad to hear that. There's a lot of things that can be done in Excel.
This video is really interesting to share with my business users, thanks!!!! However, for me, I will go on with my OpenRefine tool for Data Profiling and Data Preparation :-). **Edited, I mispelled the tool.
I'm glad that you found it interesting, Manuel. I haven't heard of the OpenResume tool before. Is it a data profiling tool?
@@LightsOnData ahggg, sorry, I wrote wrong the tool name, I was answering to your video whilst I was performing a task with another tool called "*Resumed*" :-) It is OpenRefine, not as user-friendly as other visual tools, but really powerful with a great scripting transforming language.
Hi, really informative. One quick question? How can we download the power query for excel 2010 version? PS: Subscribed already !
Thanks for subscribing, Shruti. Here’s a link I found where you can download it from: www.microsoft.com/en-ca/download/details.aspx?id=39379
Hi Shruti, let me know if you were able to install the extension for 2010z
Really insightful. Thanks!
Glad it was helpful!
can you explain analyzing the columns having date?
Under the view tab in power query I am not seeing column profile, quality and distribution in mine. What’s the problem. I need help.
Are you using MS365 or Office 2016, or what version are you using?
Thanks for making this video!
Very helpful! Thank you!
Thank you. I like it.
I'm glad to hear that.
Thank you.
You’re welcome, Boris.
does this not work on microsoft excel for mac?
I don’t see what it wouldn’t. Do you have a Mac?
Good video, George.
I was wondering if PQ whether in Power Pivot or Power BI has any function that could do some EDA, like we do in Python or other languages.
In Python I really like Dtale library simply marvellous.
Is there anything closer to this in PQ?
Thanks Salman! I recommend checking out @daveondata as he has a few videos on how to do EDA in Excel.
you look cute :)