بداية مذاكرتك لل Data analysis

-
شوفت كذا بوست عن ازاي تبدأ في مجال ال Data analysis
ومحتاج تكون عارف ايه وهكذا
عموما هحكي من خلال خبرتي البسيطة يعني
وهيكون البوست مختلف كالعادة بما انه في ناس اتناولت الموضوع اكيد بشكل احسن مني ♥️
___




لو جيت قولتلك مين هو ال Data analyst وخليتك تقرأ شوية هو بيعمل ايه وبيشتغل ازاي
وازاي بيشتغل علي ال Data
هتكون فاهم كويس جدا وناقصك بس ال tools
ال tools الي هتعمل بيها analysis وتتعامل مع ال Data
والي هتعمل بيها Dashboards وهكذا
طب لو اديتك ال tools دي كلها في الاول
وبقيت كويس في sql و python و مثلا power bi
هتبقي حاسس انك جامد
بس مش فاهم همسك الدنيا ازاي

زي مثلا حد مذاكر سواقة كويس وفاهم الاشارات والمرايات وامتي ابص هنا وامتي احود والطرق
لو ركب حاجة جامدة زي BMW m3 هيعرف يسوق حتي و ان كانت اول مرة يستخدم ال tool دي
بل كمان هيستكشف حاجات جميلة جوا العربية تسهل عليه المشوار
لكن لو حد مش فاهم سواقة
هيسوق ال BM عادي مجرد ما يحط الفتيس علي ال D ويحرك الدركسيون
بس هو مش فاهم رايح لفين ولا امتي ابص في المراية ولا حاجة
____
دة شبه الي حصل ليا
اول ما بدأت اخدت اول مسارين من منحة Udacity تبع Egypt fwd
كنت جامد ك tools ولو فجاة قدامي data هعرف اتعامل معاها بشكل كويس
بس هي الفكرة مش هيبقي قدامك data فجاة
في قصة كبيرة قبلها وبعدها
ف الي هو انا مش فاهم امتي اعمل دة وامتي معملش دة
___
اسألة كتيرة لقيت ليها اجوبة بقا في google certificate الي علي Coursera
فهمت الدنيا هنا شوية

ف نصيحتي الكورسين دول ابدأ بيهم
و وسط المشوار هتعرف انت ناقصك ايه
بدأت بكورس جوجل تمام هتحس انك عايز تبقي جامد شوية في الادوات
بدأت ب udacity هتحس انك عايز تفهم الدنيا اكتر
ف خد الاتنين وبعدها الدنيا هتوضح
انا ديما مش بحب اسأل كتير
بحب ادخل في اي كورس
وبعدها هعرف انا ناقصني ايه
زي ما انا عملت بظبط ♥️
#dataanalysis

Comments

Post a Comment

Popular posts from this blog

Managing Null Values in Your Data Warehouse: Key Considerations

-
When it comes to null values in your data warehouse, the decision to replace or handle them depends on the nature of your data and the requirements of your analytical processes. Explore these key considerations for effective null value management: Understand the Meaning of Null: Before making decisions on null values, grasp their meaning in your data. Null may signify a lack of information, an unknown value, or an intentional absence of data. Contextual understanding is crucial for informed decision-making. Use Default Values or Codes: Rather than opting for a generic placeholder like 'unknown,' leverage default values or codes with specific meanings. For instance, 'N/A' (Not Applicable) or 'Not Available' can effectively represent cases where data is genuinely missing. Consider Business Rules: Evaluate your business rules and requirements. Null values may be acceptable in some cases, carrying meaningful interpretations. For i...
Read more

What is data science

-
Introduction Some people think that data science is the same thing as statistics. But it's not. Data science involves a lot more than just analyzing numbers. What is actually data science Data science is a field of study that uses data to solve problems. It's an interdisciplinary field that incorporates techniques and theories from many fields, including statistics, data mining, machine learning and pattern recognition. Data scientists are able to apply their knowledge of statistics and machine learning algorithms in order to analyze large amounts of information in order to find patterns that might not be obvious at first glance. Data scientists can work in many different fields, including business and finance. They're often employed by large companies that have a lot of data to analyze, like banks or insurance companies. They may also be employed by technology companies that specialize in collecting user-generated data such as Facebook or Google. A data scientist is an exp...
Read more

Choosing Between Alternate Key (Business Key) and Surrogate Key for Foreign Keys in the Fact Table: A Guide

-
When integrating a foreign key into the fact table, referencing the product dimension table, it's advisable to choose the surrogate key. The surrogate key, often an auto-incremented integer, serves as a unique identifier for each record in the dimension table. Benefits of Surrogate Keys: Stability for the Long Haul: Surrogate keys offer lasting stability. Unlike natural keys, they remain unchanged over time. In the dynamic world of source systems, alterations to the natural key of a product can pose challenges in your data warehouse. Surrogate keys act as a reliable shield against such complications. Optimized Performance: Size matters, even in the key domain. Surrogate keys, being compact and numeric, enhance storage and query processing efficiency. Opting for foreign key relationships based on smaller numeric values can significantly boost overall performance. Ensuring Consistency: Consistency is the backbone of a robust data warehouse. Surrogate keys play a crucial role in es...
Read more

A Comprehensive Guide to CSV Files vs. Parquet Files in PySpark

-
When working with large-scale data processing in PySpark, understanding the differences between data formats like CSV and Parquet is essential for efficient data storage, query performance, and scalability. In this guide, we’ll compare CSV and Parquet files, explore their strengths and weaknesses, and provide examples of how to work with both formats in PySpark. 1. What is a CSV File? A CSV (Comma-Separated Values) file is a simple text-based format where each row represents a record, and columns are separated by commas (or other delimiters like tabs or semicolons). CSV files are widely used due to their simplicity and compatibility with many systems. Characteristics of CSV: Human-readable: CSV files are plain text, making them easy to open and read in any text editor. No schema: CSV files don’t store metadata (like data types). This can make it harder to work with complex data structures. Slower performance: Since CSV is not a binary format, reading and writing l...
Read more

SQL query execution order

-
Image
  ليه لازم تفهم دة عشان لما ت Run حاجة زي دي تفهم ايه الغلط ________  : Query 1 SELECT first_name +' '+ last_name AS full_name FROM students ORDER BY full_name _____________________________  : Query 2 SELECT first_name +' '+ last_name AS full_name FROM students 'WHERE full_name = 'Omar Khaled ____________________________ ال Error هيجي من Query 2 ليه تعالي نحلل Query 1 الاول _____ اول حاجة في Query دي بتتنذف FROM بيشوف فين الداتا بعدها ال SELECT ف هنا هو شاف انه في حاجة اسمها full_name اتعملت في ال run time فا مش هيعترض اما يشوفها في ORDER BY الي هي اخر حاجة بتتنفذ هنا ___________ لكن في QUERY 2 اول حاجة في Query دي بتتنذف FROM بيشوف فين الداتا بعدها بينفذ ال WHERE هنا هيقول انا معنديش حاجة اسمها full_name لان الترتيب ان ال WHERE بتتنفذ بدري عن ال SELECT __________ الترتيب كالاتي FROM JOIN ON بيشوف هو الداتا فين WHERE GROUP BY HAVING - AGG بعدها يفلترها SELECT - DISTINCT + AGG ORDER BY TOP
Read more