Here's to YOU

Happened this week...?

?? Alex Freberg is finally going solo after 5 years in the field. Alex announced he left his company to allow more time for the many projects he is working on!

Interesting posts...

?? Nick Holt , who regularly posts SQL informative content, defined Seven Tips to improve your SQL skills

Your wellness tip...

?? Holidays and festivities coming up... If you drink, here's a few things you can do instead of driving, no matter your condition:

?? stay the night where you are

?? ask someone to drive you

?? call someone to pick you up

?? call a taxi or ride-share

Better to choose one of these or anything that will keep you safe, even if not ideal, than to take the risk.

Low to No Degree Jobs…

...we will resume in 2023!

Upcoming events... Eastern Timezone

? Tomorrow, 8 PM EST #PandaWisdom - AMA for Jobseekers, and...

? Wed, Jan 4, at 5 PM New Year, New Career: Optimizing Your Professional Presence on LinkedIn - these are not hiring events but two events for general job seeking advice

? and on Tue, Jan 3, 11 AM audio event Data Fight Club: Data v. Problems you don't know you have but need to solve

Your daily exercise to try this week...

?? Standing or sitting on a chair or on a mat by something festive or comforting ?? in your home (even just the TV...), bend forward to a gentle stretch, breath and relax. Depending on the position you choose, you'll feel the stretch in a different area.

??? Junior Data Analyst jobs through staffing agencies: "Master’s degree in Computer Science, Computer Engineering, or any elated field of study. Exposure in Agile & Waterfall methodology. Job duties are project-based and performed on long-term assignments at various unanticipated sites within the U.S. which may require relocation at the end of each project. Advanced level MS Excel skills (Pivot Tables, VLOOKUPs, etc.) Excellent communication and presentation skills. Must know how to use Power BI. 2) Data Analysis experience for ~ 3 years; SQL Experience, Report writing, data mapping "and more". The other listing asks for "three years of program experience which includes statistical collection and analysis, evaluation of efficiency, data quality or cleansing, root cause analysis, and participation on data or quality analysis teams. Knowledge of the Microsoft Office Suite, SQL, Azure, Databricks, Tableau, Java, and Python. Experience with common enterprise architecture frameworks, models and artifacts and relational database management systems. Strong analytical skills with the ability to collect, organize, analyze, summarize and distribute significant amounts of information with attention to detail and accuracy. Must be a self-starter and self-motivated. Must be able to quickly learn and lead in a new environment. Ability to work well within a team environment and have exceptional collaborative skills. Must be service oriented with strong interpersonal skills to work with all levels of business and technical staff. Another 'entry level' data analyst position through a staffing agency asks for Proven working experience as a Data/ Business Data Analyst:

?? expertise regarding data models, database design development, data mining and segmentation techniques ?? knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (XML, Javascript, or ETL frameworks) ?? and of statistics and experience using statistical packages for analyzing datasets (Excel, SPSS, SAS etc) ?? strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy ?? adept at queries, report writing and presenting findings ?? aaaaand a BS in Mathematics, Economics, Computer Science, Information Management or Statistics

Something I learned...

Python Software Foundation is a non profit, devoted to "advancing open source technology related to the #python programming language". I joined as a student member for a reduced membership price of $25. Currently working on data cleaning and preprocessing in Python with Pandas and NumPy. Some key points: inspecting the data with .head(), tail, sample, info, describe, shape, value_counts. Looking at white spaces, the proportion of missing values, unnecessary duplicates, outliers, inconsistencies such as different capitalizations or use of abbreviations and full names, the format of columns, renaming columns to be more clear, and changing the index.

My dog???

(He's a little confused- he visited 5 Santas and 2 Grinches)

??If really cold while being outside, allow more activity (and possibly better quality food), dogs can get snow blindness too, so careful if there is snow on the ground and the sun is out. Don't neglect their physical and mental fitness (and yours) just because it's cold out, if they are sensitive to cold- play inside more

??consider a cozy jacket and a warmer bed, and protect them from getting too close to heating sources in the house

??be cautious about the ground temperature, condition and materials such as salt and esp. antifreeze that could irritate their paws and is toxic, and wipe/ wash off the salt or dirty snow

??grooming: keep their paws' fur and nails trimmed and brush throughout regularly

??if they have access to the yard, watch out for escape routes once snow has piled on the ground by the fence

??don't feed them holiday leftovers, and keep cooked bones away

??And of course, everyone should be aware of the deadly foods and keep them far from reach: cooked bones, grapes, onion, garlic, chocolate, artificial sweeteners, anything with high fat/sugar/salt content, alcohol