{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":822454639,"defaultBranch":"main","name":"Portfolio-Projects","ownerLogin":"Assem94plasma","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2024-07-01T07:27:42.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/150113232?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1719819092.0","currentOid":""},"activityList":{"items":[{"before":"b4771b2370f11ccc3da048e4f6c7215a92ff70fc","after":"09b27f652f41671a693e96daa7b59abef14d6076","ref":"refs/heads/main","pushedAt":"2024-07-10T15:30:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Assem94plasma","name":"Assem Abdel-Kareem","path":"/Assem94plasma","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/150113232?s=80&v=4"},"commit":{"message":"README.md","shortMessageHtmlLink":"README.md"}},{"before":"37e87b60464ebb9dbaf5cd8f3424b9c38e80e6fb","after":"b4771b2370f11ccc3da048e4f6c7215a92ff70fc","ref":"refs/heads/main","pushedAt":"2024-07-10T15:04:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Assem94plasma","name":"Assem Abdel-Kareem","path":"/Assem94plasma","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/150113232?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":"7288a2aea837c56490e4778705d9e09156e281da","after":"37e87b60464ebb9dbaf5cd8f3424b9c38e80e6fb","ref":"refs/heads/main","pushedAt":"2024-07-10T14:59:41.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Assem94plasma","name":"Assem Abdel-Kareem","path":"/Assem94plasma","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/150113232?s=80&v=4"},"commit":{"message":"Pharma Analysis","shortMessageHtmlLink":"Pharma Analysis"}},{"before":"e5b8fabd20e25e37a00b0858e84b70b04c7295de","after":"7288a2aea837c56490e4778705d9e09156e281da","ref":"refs/heads/main","pushedAt":"2024-07-10T14:56:38.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Assem94plasma","name":"Assem Abdel-Kareem","path":"/Assem94plasma","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/150113232?s=80&v=4"},"commit":{"message":"Create Pharma Analysis\n\nProject Title: SQL Data Analysis Project\r\n\r\nDescription:\r\nThis folder contains SQL scripts and queries used for a comprehensive data analysis project. The project involves various operations, including data extraction, transformation, and loading (ETL), data cleaning, and complex queries for insights generation.\r\n\r\nContents:\r\n01_Data_Exploratory.sql: SQL scripts for exploratoring data.\r\n02_Data_Transformation.sql: Scripts for transforming raw data into a structured format.\r\n03_Data_Cleaning.sql: Queries used for cleaning and preparing data for analysis.\r\n04_Data_Analysis.sql: Advanced SQL queries for performing data analysis and generating insights.\r\n05_Data_Visualization.sql: Scripts for preparing data for visualization tools.\r\n\r\nKey Features:\r\nUtilizes advanced SQL functions such as window functions, CTEs.\r\nIncludes examples of data aggregation, and filtering.\r\nDemonstrates how to handle NULL values and perform data validation.\r\nContains performance optimization techniques for large datasets.\r\n\r\nPurpose:\r\nThe purpose of this project is to showcase practical SQL skills for data analysis. It aims to provide examples and templates for common data operations, making it a valuable resource for anyone looking to enhance their SQL proficiency in the context of data analysis.","shortMessageHtmlLink":"Create Pharma Analysis"}},{"before":"4fa83a309955886d60f05a51372286788534963f","after":"e5b8fabd20e25e37a00b0858e84b70b04c7295de","ref":"refs/heads/main","pushedAt":"2024-07-07T21:03:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Assem94plasma","name":"Assem Abdel-Kareem","path":"/Assem94plasma","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/150113232?s=80&v=4"},"commit":{"message":"Delete HR_DataAnalysis.pbix","shortMessageHtmlLink":"Delete HR_DataAnalysis.pbix"}},{"before":"2f3894c0fc50aabd8030e78d3129118effeb7614","after":"4fa83a309955886d60f05a51372286788534963f","ref":"refs/heads/main","pushedAt":"2024-07-07T21:02:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Assem94plasma","name":"Assem Abdel-Kareem","path":"/Assem94plasma","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/150113232?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":"a7c6d7560ff0c79a771fe70917a6c3f6fc38ab62","after":"2f3894c0fc50aabd8030e78d3129118effeb7614","ref":"refs/heads/main","pushedAt":"2024-07-04T15:17:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Assem94plasma","name":"Assem Abdel-Kareem","path":"/Assem94plasma","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/150113232?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}},{"before":null,"after":"a7c6d7560ff0c79a771fe70917a6c3f6fc38ab62","ref":"refs/heads/main","pushedAt":"2024-07-01T07:31:32.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"Assem94plasma","name":"Assem Abdel-Kareem","path":"/Assem94plasma","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/150113232?s=80&v=4"},"commit":{"message":"Add files via upload","shortMessageHtmlLink":"Add files via upload"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEe-u6twA","startCursor":null,"endCursor":null}},"title":"Activity · Assem94plasma/Portfolio-Projects"}