dataism

  This time, I collected documents in the theme of SQL. Sources are marked, where avaliable. All the material are downloaded from linkedin professional groups.   First of all, a detailed SQL handbook from Hans-Petter Halvorsen, also avaliable on https://www.halvorsen.blog SQL in detail   Another useful document. Unfortunately the source is unknown: SQL_basics   Another one from the internet (unknown source): SQL_notes   SQL interview Q&A from www.algotutor.io site: SQL_Quick_Revision_Notes_For_Interview   Another 80 interview questions from Aspersh Upadhyay ( https://www.linkedin.com/in/aspersh-upadhyay/ ) 80_sql_interview_questions   An SQL tutorial from www.tutorialspoint.com SQL Tutorial   A useful one from www.w3schools.com SQL_tutorial_w3schools   A must save document from HIMANSHU KUMAR https://www.linkedin.com/in/himanshukumarmahuri SQL_Must_Save_And_Share  

Nowadays, data analysis is a rather recruited field. There is a huge need for well-qualified proffesionals. No concidence, that many people want to break into this labor market as part of career-hack. And this is not a problem. Currentrly we are lack of well-qualified professionals, who can use Power BI, Tableau or SQL on an advanced level. And you are able to learn these softwares. It’s not brain surgery… If you are interested in these tools, I encourage you to learn them. In my previos post I have wrote about it: Self-learning, self-developement Now I want to write a little about the difficulties we encounter as a data analyst at daily work. During learning of a software (Power BI, SQL, Access, whatever…), you are always in an almost ideal environment. You can practice on a well-structured database, and you can try all the features with them. In real life, this is usually not the case. Let's have a look what obstacles we have to face.   Data inputs are coming fr

  We have several better tools for data analysis than Excel, but we will probably never eradicate Excel from our life. Excel has it’s onw beauty. And it was cool in the ’90s 😊 Thanks for the LinkedIn community, I want to share some useful documents of MS Excel. Let’s see the shortcuts firstly. Another one in pdf: Excel_Shortcuts   Some tips and tricks: Excel tipd and tricks Some useful functions (XLOOKUP, INDEX&MATCH, SUMIF, IFERROR, etc…) 10_EXCEL_FUNCTION_IN_DATA_ANALYSIS   Advanced formulas Advanced_Excel_Formulas_and_Calculations A long story…: EXCEL_NOTES   Anoter long one for mazochistics: Excel_Formula_Bible   Some VBA notes: Excel_VBA_notes_for_professionals   Have fun! 😊

  In today's busy world, it is very important to keep up with trends. I started my professional career for over 15 years, and during this time the world has significantly changed. Many new software has been published on the market and a lot of new methodologies have been applied. 15 years ago, I had a SAP User Access and an Excel workbook. That was my working tool. Today I use several corporate softwares, and I have learned the tips and tricks of database management (Such as SQL, MS Access, Power Query, Power BI). But why is continuous learning important? On one hand, to develop. There is no person who knows everything, even within their own field. You can always learn something new. It is important to be open-minded. Learning is not equal to participate in school-lessons. You can do a lot for your development by sharing and discussing your experiences with your colleagues and friends. On the other hand, to expand your capabilities. You may be a Financial Analyst today, but i