Data Science & Analytics

دورك كمحلل بيانات حاجه مش سهله مهما عملت Dashboard او طلعت insights او كتبت code او Query كل ده مش هيميزك كل الجوانب الماليه و الاقتصاديه و التقنيه المرتبطه ببيانات مؤسستك او قسمك لازم تكون مُلم بيها من غير كده كل ال ASKs بتاعتك هتكون not valuable و بالتالى تحليلك غير مفيد و recommendations ملهاش لازمه لو مش عارف اسأل مش عيب عشان تعمل Data preparation مظبوطه لازم يكون دورك الاول و الثانى و الثالث انك تكتشف Realistic Solutions و تكون Applicable وده مش هييجى الا بدراسه عميقه لبياناتك بعد عمل validation قوى الموضوع مش سهل يا جماعه لازم نبنى Strong Analytical Mindset مع ال Skills الفرص كتيره ان شاء الله 💙♥️

#Job We Are Hiring : * Data Analyst Location: October -Attractive salary -Transportation provided If interested, kindly send your updated CV and mention Job title Talentacquisition.eg@panda.com.sa

ي حد مهتم يتعلم بايثون ال ٢ فيديو دول عظمة جدا بشمهندس أحمد جزاه الله خيرا عامل فيهم مجهود محترم ❤️ *Part 1 https://www.youtube.com/watch?v=XKQaCF_Om8o *Part 2 https://www.youtube.com/watch?v=mlbe7Vxr7yA #Python

#Job Junior BI Developer is needed for immediate hiring for a Multinational Company located in Heliopolis. With Flexible Working Hours, Benefits and Competitive Salary. Qualifications: - B.S. degree in Computer Science, Computer Engineering - Good knowledge in Database and SQL is a must - Banking knowledge is a plus - 0-1 Year of experiences. If interested Please share your updated resumes with us on hr.recruitment@datagearbi.com , with Subject (BI-01)

🔴لو مهتم أو بتدرس تراك الداتا أناليسيز ف دي بلان كورسز من مايكروسوفت كويسه جدا ممكن تشوفوها الكونتنت بالكامل بتقدمه Microsoft Learn ودا اللينك بتاعه : https://lnkd.in/dG3Pgi9e ودا كورس ل Power BI واللي هو من أهم تولز ال Visualization في الداتا أناليسيز https://lnkd.in/dzH4nu27

Barcode creation using Python

Audio to Text using Python

2D Histogram Plot using Python

لماذا يطلق علينا سحرة البيانات؟ لأن البيانات نادرًا ما تصل إلينا بتنسيق جاهز بل تحتاج الى تنظيف وفلتره ودمج .....الخ و بمجرد أن تكون البيانات جاهزة، نبدأ السحر الحقيقي!😀

السلام عليكم لو عندك انترفيو كداتا اناليست، دى شوية حاجات تراجع عليها كويس 1. Removing Duplicates: Ensure data accuracy by eliminating repeated entries. 2. Text to Columns: Organize data by splitting text into multiple columns. 3. Data Validation: Establish rules to maintain data integrity. 4. Flash Fill: Automatically fill in data based on recognized patterns. 5. SUMIFS, COUNTIFS, AVERAGEIFS: Aggregate data using multiple criteria. 6. VLOOKUP, HLOOKUP: Efficiently search for data either vertically or horizontally. 7. INDEX & MATCH: Combine these functions for advanced lookups. 8. Logical Functions (IF, AND, OR, NOT): Perform essential logical operations. 9. Nested Functions: Use multiple functions together for complex calculations. 10. Array Formulas: Process multiple values simultaneously. 11. XLOOKUP, LET: Utilize modern functions for streamlined lookups and variable definitions 12. SUMPRODUCT, INDIRECT: Perform advanced calculations for complex scenarios. 13. Text Functions (LEFT, RIGHT, MID): Extract specific characters from text strings. 14. Pivot Tables & Charts: Summarize and visualize large datasets effectively. 15. Sorting and Filtering: Organize data to enhance accessibility and analysis. 16. Subtotals: Calculate subtotals within your datasets for clarity. 17. Conditional Formatting: Highlight important data based on specific criteria. 18. Charting Techniques: Create various types of charts, from basic to advanced. 19. Dynamic Dashboards: Build interactive dashboards for real-time data insights. 20. Data Consolidation: Merge data from various sources seamlessly. 21. Advanced Filtering: Apply advanced techniques to filter data effectively. 22. Slicers and Timelines: Improve pivot table interactivity with these tools. 23. Date and Time Functions (TODAY, NOW, EOMONTH, etc.): Manage and manipulate date/time data. 24. Error Handling (IFERROR, ISERROR): Manage formula errors efficiently. 25. COUNTA: Count non-empty cells in a range to gauge data presence.