How to Do Data Profiling in Excel? #dataprofiling

HOW TO DO DATA PROFILING IN EXCEL?//
Did you know that Excel has the capability to perform some data profiling on the data that you bring into it? Here's how you can use Excel to do some quick data profiling.

0:00 Intro
1:00 Prepare your data
1:45 Power query
3:00 Table profile function
4:24 View the summary table
5:30 Correct your data
5:55 Refresh your data
8:38 Review null values

**********************************
My mission at LightsOnData is to:

1️⃣ Provide current and future data professionals with increased knowledge and better understanding of data governance, data management, and data storytelling.

2️⃣ Provide simple, fun, and engaging, as well as thorough explanations, teachings, and advice on important, but otherwise boring and dry topics of the data world.

3️⃣ Put the lights on data-focused organizations and products by helping them get more exposure on social media.

Here are ways that you can benefit from LightsOnData's content:

💡 ONLINE COURSES: Easy to learn, engaging and highly valued online courses in areas of data governance, data management, and much more:

💡 LIGHTS ON DATA SHOW: Each episode puts the lights on various data topics with renowned industry experts. Listen and watch the live show and podcast:

💡 FREE TEMPLATES: Check out our website for more useful content, templates, best practices, definitions, etc. on data governance, data management, data storytelling practices.

💡 DAILY TIPS: Follow our LinkedIn page to benefit from daily content on data governance, data management, data quality, data storytelling, and all things data.

💡 FUN DATA SWAG: Show others your love for data with any of these fun apparel items and accessories:

**********************************

Connect with George Firican on Social Media:

[seungcherryhae]

thank you for saving my life! just recently start my internship and had to use excel/power bi. it sucks that my uni never bother to implement excel in our studies

[codermomma]

I had to do data profiling today using excel on the first day of my new job. You literally saved my life!!!!

[da]

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.

[aapje]

Very good video, it helps a lot in exploring new data files, thank you! Best wishes from Holland!

[EdialeEremionkhale]

Great introduction video. I really wish that an extended video can be done with several examples

[DAMA-VancouverBC]

This is very useful, thanks, George. I will incorporate it into my DQ class as an alternative to the Ataccama DQ Analyzer.

[khushbumehta]

can you explain analyzing the columns having date?

[losbichosdehector]

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.

[manuelboadi]

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.

[benomondi]

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?

[iamShruti]

Hi, really informative. One quick question? How can we download the power query for excel 2010 version? PS: Subscribed already !

[tacs]

does this not work on microsoft excel for mac?