My 'SQL for Data Analytics' course on YouTube

I have created Job ready Data Analyst Course in 90 Days which involves analysis in several platforms like Excel, Python, R and SQL along with Visualization in Tableau.

Model Context Protocol (MCP) server for Databricks that empowers AI agents to autonomously interact with Unity Catalog metadata. Enables data discovery, lineage analysis, and intelligent SQL execution. Agents explore catalogs/schemas/tables, understand relationships, discover notebooks/jobs, and execute queries - greatly reducing ad-hoc query time.

Data Science has been ranked as one of the hottest professions and the demand for data practitioners is booming. This Professional Certificate from IBM is intended for anyone interested in developing skills and experience to pursue a career in Data Science or Machine Learning. This program consists of 9 courses providing you with latest job-ready skills and techniques covering a wide array of data science topics including: open source tools and libraries, methodologies, Python, databases, SQL, data visualization, data analysis, and machine learning. You will practice hands-on in the IBM Cloud using real data science tools and real-world data sets. It is a myth that to become a data scientist you need a Ph.D. This Professional Certificate is suitable for anyone who has some computer skills and a passion for self-learning. No prior computer science or programming knowledge is necessary. We start small, re-enforce applied learning, and build up to more complex topics. Upon successfully completing these courses you will have done several hands-on assignments and built a portfolio of data science projects to provide you with the confidence to plunge into an exciting profession in Data Science. In addition to earning a Professional Certificate from Coursera, you will also receive a digital Badge from IBM recognizing your proficiency in Data Science.

Smart India Hackathon 2018 Identification of meritorious students in primary education Problem Statement:- Gujarat government has nearly 90 lac students studying in primary education across state. They are in different cities and villages across state. There is no mechanism to identify bright students who are performing well in study, sports or other activities. Web portal can be designed to acquire date about such students and can be analyzed on different parameters. What Exact Problem is being solved? : Such identified students can be provided with extra resources or special attention can be given to their upbringing. Abstract To identify meritorious students firstly all the educational institutions need to upload the results of students as well as points of extra curriculum activity (activity name, score out of 10 for performance) to the database for a student according to the current class of study. Aadhar number for all the students will always be given (from there students details will be verified).A parent or any other nongovernment institute can also upload scanned copy of result or certificate of any student with his/her Aadhar number and their own details. Admin will Cross-check and verify it for the update in the database. One’s (schools and institutions) first login or registration, there will be a unique token, (user id and password) to the Portal. That login will be further verified. So every institution will have a unique user id and password and students' details will be uploaded yearly and updates will be done twice in a year. The second fold of the solution is to sort the data according to the merit of students. The designed application will perform the operation with the provided data and present a lesser (according to requirement) students' details. There should be some methods (a faster and optimal Algorithm to sort data by marks and activity score from database Base will be adopted i.e., any tree type-level representation) to sort the data (details) of meritorious students from provided records of all the students. The third and final part is providing the list of meritorious students to the education department and university. Each official and university will also have a login section. The list of meritorious students will be provided according to year, required field. The education department or university can also post the facilities provided to the selected and shortlisted student as a notice. Therefore, we are going to solve the stated problem by providing a Web-based application comprising of Web portal and secured database to identify meritorious students in primary education according to data (100%) uploaded and retrieved from several institutions and selected meritorious students list will be provided to (according to specification of different facilities 20-30%) to Education Department and Universities. Keywords: Aadhar Number as Primary key of Student Table. Online WEB-portal. Update Records every year to keep a check on the improvement, Standardization & Soring data based on Z – stat to filter out the meritorious students on the basis of acads and extra-curricular activities. Tree type-level representation of Database i.e. Admin – Institute – Student. Use Case :- Choice Based selection of meritorious student from data set. For instances if the requirement is only limited to academics, they can refer to the website to fetch a list of top scorers say top 100 or top 200 students. Again if the requirement is limited to selection of Extra-curricular activity like – singing, painting, dancing etc they can fetch the list of students having expertise in that particular field only. Identification of poor meritorious students and Funding based support from different NGO’s, organizations and donations if they want to provide. Supervising data based on entries done in every year (Region based) to keep a check on the individual growth of a student. For instances, a diligent student say X has been receiving scholarship every year now say that X student’s data has not been registered in Database in the next year. Thus there is a decay of GDP in the sample space. To highlight the social issues such as Child Labour, child trafficking, by year wise regulation Data. To prevent the girl child marriage on the basis of Dataset by the investigation Team. For instance if a girl found not registering in the consecutive Year, an investigation team can take action accordingly. Special Features: The school should submit their data to get a recognition as well as to be in sight of fund providing parties (governmental or non-governmental). Students will be benefited as direct communication is in between officials and student and no middle man in between. • Data analysis will be the key point to identification using assignment of z-marks by standard normal distribution. Technology Stack: We are to make a Web-based app, in a microlithic structure format, where the app structure is broken into different fragments, which does the different job. One part will be taking in the to the database from a web portal designed using CSS, JavaScript, PHP, and Servlet. Computation of the sorted data and the various mathematical calculations i.e. arranging the sorted data according to given criteria etc on a mathematical platform powered by JAVA. Another part will be integrated with the API's of various Education Department and Universities to provide them up with shortlisted meritorious students, integrating with their personal choices and cut-offs, and also where shortlisted students will be notified by notice posted. Keeping in mind the ease of obtaining marks and details which has increased throughout the years. In the web app, after one's first login or registration, each part of the education department, university and institution have a unique token, (user id and password) to the database. Coming to the part of its database, My SQL or Oracle or Mongo DB can be used with a firmed dashboard powered by python or JavaScript on a network frame. Since the app will be containing huge academic details of many students, so a strong encryption algorithm is to be used for data integrity and data security. AES-256 or MD5 would be best to use to protect the data in the database and for authentication Biometric data will also be preserved.

Gain the job-ready skills for an entry-level data analyst role through this eight-course Professional Certificate from IBM and position yourself competitively in the thriving job market for data analysts, which will see a 20% growth until 2028 (U.S. Bureau of Labor Statistics). Power your data analyst career by learning the core principles of data analysis and gaining hands-on skills practice. You’ll work with a variety of data sources, project scenarios, and data analysis tools, including Excel, SQL, Python, Jupyter Notebooks, and Cognos Analytics, gaining practical experience with data manipulation and applying analytical techniques.

This program includes over 180 hours of instruction and hundreds of practice-based assessments, which will help you simulate real-world data analytics scenarios that are critical for success in the workplace. The content is highly interactive and exclusively developed by Google employees with decades of experience in data analytics. Through a mix of videos, assessments, and hands-on labs, you’ll get introduced to analysis tools and platforms and key analytical skills required for an entry-level job. Skills you’ll gain will include: Data cleaning, problem solving, critical thinking, data ethics, and data visualization Platforms and tools you will learn include: Presentations, Spreadsheets, SQL, Tableau and R Programming In addition to expert training and hands-on projects, you'll complete a case study that you can share with potential employers to showcase your new skill set. Learn concrete skills that top employers are hiring for right now.

HR Analytics Dashboard built with SQL, Excel, and Power BI — includes attrition analysis, department insights, and job satisfaction metrics.

An automated system for Twitter data Analysis using AWS Services. In this architecture, a python script pulls data continuously using Twitter API, a Lambda function along with Kinesis Firehose is then used for pre-processing data and then writing it to S3 in JSON format. An EMR activity (Spark Job) is scheduled on hourly basis to create reports using Spark-SQL which are then written in S3.

بسم الله الرحمن الرحيم C.V. NAME: SHA'BAN YOUSEF MOHAMMAD ELQASASS TELE PHONE NO. : 0799455189 NATIONALITY: JORDANIAN ADDRESS: JORDAN-AMMAN E-MAIL: SHBNQ422@YAHOO.COM WWW.SHAABANALQASSAS.COM CERTIFICATES: • HIGHER DIPLOMA IN INFORMATION TECHNOLOGY ( THE UNIVERSITY OF JORDAN) • B.CS IN CHEMISTRY AND COMPUTER FROM YARMOUK UNIVERSITY JORDAN • MCAD.NET (MICROSOFT CERTIFIED APPLICATION DEVELOPER 2003) • ADO.NET; ASP.NET ; MVC :LINQ :VB.NET : C# • MS SQL SERVER DATABASE 2005-2008-2012-2014 • ACCESSING DATA WITH MICROSOFT .NET FRAMEWORK 4 CERTIFICATE -MICROSOFT • JOOMLA WEBSITES DEVELOPER • PHP; MYSQL DATABASE; • MICROSOFT CERTIFIED TECHNOLOGY SPECIALIST (MCTS 2013) • CERTIFICATE DEVELOPING DATA ACCESS SOLUTIONS- MICROSOFT • CERTIFICATE DEVELOPING WEB APPLICATIONS – MICROSOFT • CERTIFICATE ADMIN TEAM FOUNDATION SERVER – MICROSOFT • CERTIFICATE DEVELOPING SILVERLIGHT – MICROSOFT • OFFICIAL TRANING IN ARCGIS 10.1 (I) – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( II) – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( III) performing analysis – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( BUILDING GEODATABASE) – BY ESRI • OFFICIAL TRANING IN IMPLEMENTING VERSIONED WORKFLOWS IN A MULTIUSER GEODATABASE – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( BUILDING WEB APPLICATION USING THE ARCGIS API ) – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( INTRODUCTION TO ARCGIS SERVER) – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 (CONFIGURING & MANAGING THE MULTIUSER GEODATABASE (SDE)) – BY ESRI • CERTIFICATE MAINTAINING MICROSOFT SQL SERVER DATABASE-MICROSOFT • CERTIFICATE IMPLEMENTING MICROSOFT SQL SERVER DATABASE REPORTING SERVICES- MICROSOFT • CERTIFICATE SHAREPOINT SERVER ADMINISTRATION- MICROSOFT • CERTIFICATE SHAREPOINT SERVER DEVELOPMENT- MICROSOFT • BUSINESS INTELLIGENCE TOOLS :DATA ANALYSIS SERVICES, DATA TRANSFORMATION SERVICES (DTS), DATA MIGRATION SERVICES, ETL (EXTRACT, TRANSFORM, AND LOAD) SERVICES, • ONLINE ANALYTICAL PROCESSING (OLAP) AND DATA-MINING TOOLS • CERTIFICATE WRITING QUERIES USING MICROSOFT SQL SERVER TRANSACT SQL –MICROSOFT • CERTIFICATE IMPLEMENTING AND MAINTAINING MICROSOFT SQL SERVER ANALYSIS SERVICES –MICROSOFT • CERTIFICATE IMPLEMENTING AND MAINTAINING MICROSOFT SQL SERVER INTEGRATION SERVICES –MICROSOFT • CERTIFICATE ADMINISTERING TEAM FOUNDATION SERVER • SYSTEM ADMINISTRATOR • Adobe program (graphics & design) • MS - SQL SERVER REPORTING SERVICE-OLAP-BI • SPSS ADVANCED TRAINING • ICDL CERTIFICATE • GEOMEDIA PROFESSIONAL GIS • GEOMEDIA WEBMAP GIS • GEOMEDIA TRANSPORTAION GIS • INTEL CERTIFICATE FUTURE FOR LEARNING • A+ COMPUTER MAINTENANCE (HARDWARE & SOFTWARE) • NETWORK + • SPECIALIZED COURSE IN METHODS OF CALCULATING THE RATE OF POPULATION GROWTH / DEPARTMENT OF STATISTICS • COURSE COMPLETION DEMOGRAPHIC / DEPARTMENT OF STATISTICS • SPECIALIZED COURSE IN THE MEASUREMENT OF IMMIGRATION / DEPARTMENT OF STATISTICS. • Develop GIS websites using GIS SILVERLIGHT asp.net technology. • Develop GIS websites using GIS flex technology. • Certificate projection methods and simulation models-UNESCO • Specialized course in fertility / Department of Statistics. • Specialized course in the measurement of levels and patterns of DEATH / DEPARTMENT OF STATISTICS • COURSE CODE POPULATION PROJECTIONS / DEPARTMENT OF STATISTICS • SPECIALIZED COURSE IN THE PREPARATION OF PROJECTIONS IN CRISES AND STRATEGIC PLANNING - UNESCO • WEB DESIGN USING DREAM WAVER • ASSOCIATE REGIONAL WORKSHOP ON EDUCATION STATISTICS - UNESCO INSTITUTE FOR STATISTICS • USING SPSS PROGRAM • ADVANCED COURSE IN STRATEGIC PLANNING AND THE PREPARATION OF INDICATORS • ADVANCED COURSE IN-DEPTH DEMOGRAPHIC ANALYSIS (U.S.BUREAU OF CENSUS) • ADVANCED COURSE IN POPULATION PROJECTIONS (U.S.BUREAU OF CENSUS) • EMIS EDUCATIONAL MANAGEMENT INFORMATION SYSTEM EXPERIENCES: • HEAD OF EMIS AND GIS DIVISION ) EDUCATIONAL MANAGEMENT INFORMATION SYSTEM( • HEAD OF PLANNING AND STATISTICS DIVISION • SUPERVISOR IN THE STATISTICS OF THE POPULATION IN THE KINGDOM IN 2004 AND DESIGNED STATISTICAL SOFTWARE.PARTICIPANT IN THE DEVELOPMENT OF DATABASES AND SOFTWARE EDUCATIONAL INDICATORS SIDE WITH GIS MAPS OF SCHOOL • TEAM LEADER IN DEVELOPMENT OF INFORMATION SYSTEM PROJECT ERSP • TEAM LEADER IN DEVELOPMENT OF INFORMATION SYSTEM PROJECT OPENEMIS • PARTICIPANT IN THE DEVELOPMENT OF DATABASES AND SOFTWARE STATISTICAL INFORMATION AND SURVEY FOR SCHOOL FOOD.. UNITED NATIONS WORLD FOOD PROGRAMME (WFP) • PARTICIPANT IN THE DEVELOPMENT OF DATABASES AND SOFTWARE STATISTICAL INFORMATION EMIS-EDUWAVE. • DEVELOP AND MANAGE IMPLEMENTATION OF PROJECT COMMUNICATION STRATEGIES AND COORDINATE CHANGE MANAGEMENT. • NATIONAL COORDINATOR OF THE EDUCATION INDICATORS WEI "WORLD EDUCATION INDICATOR" -UNESCO • DATABASE SPECIALISTS OF PARLIAMENTARY ELECTIONS • DATABASE ADMINISTRATION • DATABASE DESIGN, IMPLEMENTATION, TRANSACTION PROCESSING, REFERENTIAL INTEGRITY, PERFORMANCE TUNING AND MONITORING WITH AN EMPHASIS IN MS SQL. • MONITOR, REVIEW, AND VERIFY BACKUPS, RECOVERY, AND DISASTER RECOVERY PROCESSES. • CONTROL AND MONITOR USER ACCESS TO DATABASES AND MAINTAIN DATABASE SECURITY. • TROUBLESHOOT JOB FAILURES, PERFORMANCE ISSUES, DATABASE INTERGRITY, ETC. • MONITOR ALERTS AND TAKE CORRECTIVE ACTION OR ESCALATE ISSUES. • RESOLVE DATABASE REQUESTS AND ISSUES. • PERFORM DATABASE TUNING FOR OPTIMAL PERFORMANCE. • WORK CLOSELY WITH DEVELOPMENT AND NETWORK TEAMS ON RESOLVING ISSUES. • MAINTAIN DOCUMENTATION OF SYSTEMS AND STANDARD OPERATING POLICIES AND PROCEDURES. • ASSOCIATE IN THE DEVELOPMENT OF PARLIAMENTARY ELECTIONS SCHEDULES FOLLOW-UP AND THE RESULTS. • PARTICIPANTS IN THE INFORMATION SYSTEMS INTEGRATION PROJECT IN THE MINISTRY OF EDUCATION. • PARTICIPANT IN THE DEVELOPMENT OF DATABASES AND APPLICATION FOR SYRIAN REFUGEES CRISIS INFORMATION SYSTEM • PARTICIPANT IN THE LAMP (LITERACY ASSESSMENT AND MONITORING PROGRAM) –UNESCO • PARTICIPANT IN THE OUT OF SCHOOL CHILDREN STUDY – WITH UNICEF AND UNESCO • PARTICIPANT IN THE DEVELOPMENT OF THE DIRECTORATE AND THE SCHOOL (SDDP), • PARTICIPANT IN WORKSHOP FOR CHANGE MANAGEMENT –USAID • PARTICIPANT IN WORKSHOP FOR STATISTICAL INFORMATION –UNESCO &ALECSO- TUNIS • PARTICIPANT IN WORKSHOP FOR MONITORING AND EVALUATION -USAID • DESIGN AND CONSTRUCTION OF APPROPRIATE EDUCATIONAL POLICIES. • ADVANCED COURSE IN LEADERSHIP IN STRATEGIC COMMUNICATION • ADVANCED COURSE IN USING SPSS FOR DATA ANALYSIS • ADVANCED COURSE IN USING SPSS FOR DEMOGRAPHIC HEALTH SURVEYS • DESIGNER STATISTICAL SOFTWARE ESPECIALLY IN THE CAMPAIGN PROVIDES YALA MAY IN AMMAN IN 2009. • WEB SITE DEVELOPER AND DESIGN • PREPARE AND PARTICIPATE IN WORKSHOPS, INTERNATIONAL INDICATORS AND STRATEGIC PLANNING AND THE USE OF SOFTWARE AND DEVELOPMENT • PROGRAMMER IN PLANNING DIVISION SINCE 1/2004 • TEACHER FOR COMPUTER AND CHEMISTRY FROM 8/1995 • TRAINER FOR VISUAL BASIC.NET ADO.NET ASP.NET AND ICDL CERTIFICATE الاسم: شعبان يوسف محمد القصاص هاتف: 0799455189 فاكس :5666492 الجنسية: أردني العنوان: الأردن -عمان البريد الالكتروني: SHBNQ422@YAHOO.COM WWW.SHAABANALQASSAS.COM المؤهل العلمي: دبلوم عالي في تكنولوجيا المعلومات الجامعة الأردنية بكالوريوس كيمياء و حاسوب من جامعة اليرموك الأردنية عام 1993 شهادة مطور برمجيات ميكروسوفت من شركة ميكروسوفت العالمية ( MCAD .NET ) MS SQL server DATABASE 2005-2008-2012-2014 /ASP.NET/ ADO.NET/ VB.net C#: MVC : LINQ PHP ; MYSQL DATABASE دورة "أخصائي تكنولوجيا معتمد من مايكروسوفتMCTS MS - SQL SERVER REPORTING SERVICE –OLAP-BI MS ANALYSIS SERVICE System administrator Joomla website developer شهادةNETWORK + الدولية في شبكات الحاسوب شهادة التعليم للمستقبل INTEL لحوسبة التعليم شهادةA+ الدولية في صيانة الحاسوب شهادة نظم إدارة المعلومات التربوية EMIS وشهادة الخرائط الجغرافية GIS تدريب متخصص ArcGIS10.1 (I) شركة ESRI العالمية تدريب متخصص ArcGIS10.1 (II) شركة ESRI العالمية تدريب متخصص ArcGIS10.1 (III) performing analysis شركة ESRI العالمية تدريب متخصص ArcGIS10.1 (building geodatabase) شركة ESRI العالمية تدريب متخصص SharePoint إدارة وتطوير GEOMEDIA PROFESSIONAL GIS GEOMEDIA WEBMAP GIS GEOMEDIA TRANSPORTAION GIS دورة استخدام برمجيات المؤشرات والتحليل الاحصائي devinfo spectrum -- دورة متخصصة في اساليب حساب معدل النمو السكاني / دائرة الاحصاءات العامة دورة متخصصة في الاستكمال الديمغرافي / دائرة الاحصاءات العامة دورة متخصصة في قياس الهجرة / دائرة الاحصاءات العامة دورة متخصصة في الخصوبة / دائرة الاحصاءات العامة دورة متخصصة في قياس مستويات وانماط الوفاة / دائرة الاحصاءات العامة دورة متخصصة في برمجية الاسقاطات السكانية / دائرة الاحصاءات العامة Adobe program (graphics & design) تصميم مواقع الانترنت باستخدام Dream Waver استخدام برمجية SPSS في التحليل الاحصائي دورة متقدمة في التخطيط الاستراتيجي واعداد المؤشرات دورة متخصصة في اعداد الاسقاطات في الازمات والتخطيط الاستراتيجي - يونيسكو دورة متقدمة في التحليل الديمغرافي المعمق U.S.BUREAU OF CENSUS دورة متقدمة في الاسقاطات السكانية U.S.BUREAU OF CENSUS الخبرات: • رئيس قسم نظام إدارة المعلومات التربوية EMIS والخرائط GIS في وزارة التربية • رئيس قسم التخطيط والاحصاء التربوي في وزارة التربية والتعليم من تاريخ 2006 . • اعداد والمشاركة في ورش المؤشرات الدولية والتخطيط الاستراتيجي واستخدام برمجياتها وتطويرها • مشرف في الاحصاءات العامة للسكان في المملكة للعام 2004 ومصمم برمجيات احصائية. • تطوير مواقع انترنت الجغرافية باستخدام تقنية GIS SILVERLIGHT asp.net • تطوير مواقع انترنت الجغرافية باستخدام تقنية GIS flex • اخصائي قواعد بيانات في الهيئة المستقلة للانتخاب –الأردن • مدير فريق تطوير نظام إدارة المعلومات التربوي والمؤشرات التربية ERSP • مدير فريق تطوير نظام إدارة المعلومات التربوي والمؤشرات التربية OpenEMIS • مشارك في تطوير قواعد بيانات و معلومات الطلبة اللاجئين السوريين • مشارك في ورشة عمل في إدارة التغيير – USIAD • مشارك في ورشة عمل في المتابعة والتقييم - USIAD • مشارك في تطوير قواعد بيانات و برمجيات المؤشرات التربوية باستخدام الخرائط المدرسية GIS • مشارك في الانتخابات النيابية تطوير جداول المتابعة واصدار النتائج. • مشارك في تطوير قواعد بيانات وبرمجيات المعلومات الاحصائية EMIS-Eduwave • مشارك في مشروع تطوير المديرية والمدرسة (SDDP) ورسم وبناء السياسات التربوية . • مشارك في مشروع تكامل انظمة المعلومات في وزارة التربية والتعليم • مشارك في مشروع احصائيات معرفة القراءة والكتابة برنامج تقييم وتتبع مستويات القرائية LAMP • دورة متقدمة في القيادة في استراتيجية الاتصال . جامعة ميتشغان الامريكية • المنسق الوطني لمؤشرات التعليم WEI "World Education Indicator " -UNESCO • مشارك في ورشة عمل الاقليمية حول احصاءات التعليم – معهد اليونسكو للاحصاء • مصمم برمجيات احصائية خاصة في حملة يالا نوفر مي في عمان للعام 2009 • مطور ومصمم مواقع انترنت • مبرمج في قسم التخطيط في مديرية التربية والتعليم .تطوير برامج الحاسوب لحوسبة أعمال القسم من تاريخ 2004 • مدرس لمادتي الكيمياء والحاسوب للمرحلة الثانوية والأساسية من تاريخ 1995 • مدرب لبرمجية visual basic .net asp.net ado.net من تاريخ 2004 • مدرب لشهادة الحاسوب الدولية ICDL)) من تاريخ 2001

No description available

No description available

SQL-based analysis of Data Analyst jobs (2023) - salaries, skills demand, and career insights using PostgreSQL, inspired by Luke Barousse’s SQL course.

Job-ready FP&A & Financial Analytics portfolio—forecasting, variance analysis, KPI dashboards, and executive reporting (Python/SQL).

No description available

No description available

This project explores top-paying jobs, in-demand skills, and where high demand meets high salary in data analytics.

No description available

SQL-driven analysis of global AI job postings to explore salary trends, experience levels, education impact, and remote work flexibility.

This project explores a dataset of AI-related jobs to uncover insights about salary trends, in-demand skills, education levels, and remote work preferences. The analysis was done using SQL for querying and Excel for data cleaning and preparation.

SQL-powered analysis and normalization of job vacancies from HH.ru for deeper job market understanding

SQL and Python-powered system for job scraping, database management, and market analysis

Data Science job market analysis (HH.ru): SQL + Python (pandas, Plotly) with insights on skills, salaries and demand

End-to-end SQL-based analysis of 2023’s data analyst job market—identifying top-paying roles, in-demand skills, and career growth strategies using PostgreSQL and real job posting data.

Enterprise-grade ETL Monitoring Dashboard for job scheduling, log tracking, staging analysis, sales analytics, and fact exploration. Built with ASP.NET Core MVC, Entity Framework, and a SQL-based data warehouse.

Data Science is one of the hottest professions of the decade and the demand for data scientists who can analyze data and communicate results to inform data driven decisions has never been greater. This Professional Certificate from IBM will help anyone interested in pursuing a career in data science or machine learning develop career-relevant skills and experience. The program consists of 10 online courses that will provide you with the latest job-ready tools and skills, including open source tools and libraries, Python, databases, SQL, data visualisation, data analysis, statistical analysis, predictive modelling, and machine learning algorithms. You’ll learn data science through hands-on practice in the IBM Cloud using real data science tools and real-world data sets. This Professional Certificate has a strong emphasis on applied learning. Except for the first course, all other courses include a series of hands-on labs in the IBM Cloud that will give you practical skills with applicability to real jobs, including: Tools: Jupyter / JupyterLab, GitHub, R Studio, and Watson Studio Libraries: Pandas, NumPy, Matplotlib, Seaborn, Folium, ipython-sql, Scikit-learn, ScipPy, etc. Projects: random album generator, predict housing prices, best classifier model, predicting successful rocket landing, dashboard and interactive mapping

The main objective of this project is to Develop a predictive model logic based algorithm in SQL in accordance to the predictive model developed earlier with R, to predict the possibilities of Delayed discharges and secondly to analyse the Delayed Discharges of the patients in Govt.Hospital and provide forecasts of various indicators for future months. The scope of the project can be divided into two different phases as stated below, 2.1 Phase1: The main objective of this phase is to automate (SSIS package integration) the data (features of the patients) extraction from the integrated data storage which was previously loaded into data base through various integration jobs in Microsoft SQL server. Develop a new predictive model with Machine Learning algorithm in R . To support the model developed to predict the possibilities of a patient delaying discharge based on the previous historic data by automating the data analysis (required features of the patient by the model) and providing a daily automatic email Discharge team based on the output from the newly developed Patient Score calculating algorithm. SQL Reporting Services will be used for this work. 2.2 Phase 2: The main objective of this phase is to analyse the historic data to find trends and seasonality measures in order to foresee the occurrences of the delayed discharges and associated indicators e.g. care home availability over a short or long term as expected by Gov.Uk Hospitals. Various forecasting techniques can be used based on the data availability.

No description available

No description available

This is a hobby project powered by Luke Barousse where I've compiled a set of SQL scripts designed for job analysis. I created this repository as a personal learning endeavor to sharpen my SQL skills while gaining insights into the job market. From employment trends to dissecting salary ranges and skill requirements, I got to learn a lot from this.