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.
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoff...
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:
www.lightsonda...
💡 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:
anchor.fm/ligh...
www.lightsonda...
💡 FREE TEMPLATES: Check out our website for more useful content, templates, best practices, definitions, etc. on data governance, data management, data storytelling practices.
www.lightsonda...
💡 DAILY TIPS: Follow our LinkedIn page to benefit from daily content on data governance, data management, data quality, data storytelling, and all things data.
/ lightsondata
💡 FUN DATA SWAG: Show others your love for data with any of these fun apparel items and accessories:
www.lightsonda...
**********************************
Connect with George Firican on Social Media:
/ georgefirican
clubhouse.com/...
/ lightsondata
/ georgefirican
www.pinterest....
Subscribe to LightsOnData RU-vid Channel Here: / lightsondata
18 авг 2024