Know Thy Data: Techniques for Data Exploration
The number one rule for data analysts: Know thy data. Can you answer these questions: Where did the data come from? Has it been indexed? Is it clean or dirty? Are there data entry errors? Missing data? Bizarre outliers? Last but not least--What are common key columns on which you can join your data?
Scrubbing dirty data, manipulating it to make it ready for analysis, is usually the most tiresome step in data analysis. But failure to attend to these so-called fundamental tasks may lead to flawed results. Use SAS to get to know your data so you can analyze and forecast to get deeper insights into the trends and patterns of your data & customers. In this powerful presentation, learn multiple ways of looking at data to get that complete sense of your data's characteristics. Get answers to questions like: What are the extreme values of my data and what are all possible data combinations? Learn to use dictionary tables to get SAS to list all datasets which have a column with the word "Date" in them without having to write macro programs. All this and much more!
Scrubbing dirty data, manipulating it to make it ready for analysis, is usually the most tiresome step in data analysis. But failure to attend to these so-called fundamental tasks may lead to flawed results. Use SAS to get to know your data so you can analyze and forecast to get deeper insights into the trends and patterns of your data & customers. In this powerful presentation, learn multiple ways of looking at data to get that complete sense of your data's characteristics. Get answers to questions like: What are the extreme values of my data and what are all possible data combinations? Learn to use dictionary tables to get SAS to list all datasets which have a column with the word "Date" in them without having to write macro programs. All this and much more!
Confessions of a PROC SQL Instructor
After teaching at SAS for over 10 years to thousands of learners, this instructor has collected many best practices from helping customers with real-world business problems. Hear all about her confessions on making life easy with mnemonics to recall the order of statements in SQL. Learn about the data step diehard user who now loves SQL thanks to this little known secret gem in PROC SQL. Hear about the ways in which ANSI SQL falls short and PROC SQL picks up the slack. In short, there are many confessions and so little time. session is open to all interested in improving their SQL knowledge and performance.
|
About the Presenter
With a background in computer systems management. SAS Instructor Charu Shankar engages with logic, visuals, and analogies to spark critical thinking. Prior to joining SAS, Charu served in the United Nations managing educational projects and taught computer language skills at Rotman School of Management, University of Toronto. At SAS, Charu curates and delivers unique content on SAS, SQL, Viya, etc. via the SAS YouTube channel, SAS Global Forum, SAS Ask the Expert Series, SAS Training Post, etc. When not coding, Charu teaches yoga and loves to explore Canadian trails with her husky Miko.
|
