🚀 New Video Release! | Cricket Analytics Meets Machine Learning 🏏🤖

 As a lifelong cricket lover and a researcher in data analytics, I'm excited to share my latest work that digs deep into a long-held belief in T20 cricket — Do extra deliveries (wides & no-balls) really give a major advantage to the batting side?

Using data from 269 T20 matches across international & franchise formats (both men’s and women’s cricket), I applied multiple machine learning models and feature selection techniques to uncover the truth.
📊 Key Insight:
Despite what many experts say, the outcomes of extra deliveries are highly unpredictable — behaving more like random events than strategic advantages.
🔍 What the study reveals:
73% of extra deliveries have low or no positive impact
9 ML models could not reliably predict outcomes (<40% accuracy)
Only a few parameters (match stage, batsman strike rate, bowler runs conceded) showed weak influence
Expert intuition doesn’t always match data-driven reality
🎥 I have prepared a YouTube cover/thumbnail summarizing the findings visually.
Full video: https://lnkd.in/gYib62QY
Full Paper : https://lnkd.in/gWrcX9Xg
Always happy to connect with others who love cricket, analytics, or both! 🏏📈
hashtag#Cricket hashtag#T20Cricket hashtag#MachineLearning hashtag#SportsAnalytics hashtag#DataScience hashtag#Research hashtag#BigData hashtag#CricketLover hashtag#AzureML hashtag#OrangeDataMining hashtag#LinkedInResearch hashtag#DataDrivenInsights

 

Learn how to conduct a PRISMA-compliant Systematic Literature Review (SLR) using Zotero in this video https://lnkd.in/gBPGdqrC. Whether you're a researcher, academic, postgraduate student, or practitioner, this guide will walk you through the full PRISMA workflow — from database searching to exporting the PRISMA flow diagram.

In this video, you will learn how to:

✅ Set up your Zotero library for systematic reviews

✅ Import and organise research articles from multiple databases

✅ Remove duplicates using Zotero’s advanced tools

✅ Apply PRISMA-based screening (title, abstract, and full text)

✅ Use tags, notes, and metadata to track inclusion/exclusion

✅ Export data for

hashtag

#PRISMA documentation and reporting

✅ Generate and prepare a PRISMA 2020 flowchart

This tutorial is ideal for:

– Researchers conducting literature reviews

– Academics teaching research methods

– Anyone wanting a clean and efficient PRISMA workflow

Have you captured all research papers for your study?

 Started writing articles with LinkedIn platform as it has many readers. 

Have you captured all research papers for your study? | LinkedIn. 

Promtology: Prompt Patterns for Prompts

Generated from Co-Pilot

Design patterns are like blueprints for solving common problems in software development. They aren't code snippets, but rather established templates or strategies that describe how to structure your code to make it more maintainable, flexible, and efficient.

Similar to design pattern in software development, there are pattens for other domains as well. Due to the increase usage of GenAI tools such as ChatGPT, Gemini or Co-Pilot, it is important identify the prompt patterns. By reading few research papers, following list of prompt patterns were identified.

Prompt Patterns contains 17 prompt patterns that are categorized into six categories.

Data Warehousing Best Practices

Continuing on the Data warehouse article series, this is the next article, Data Warehousing Best Practices for SQL Server at www.mssqltips.com.  I have updated the list of articles as well at Data is everywhere, but?: All Data Warehouse Related Articles. 

All Data Warehouse Related Articles

Writing is my passion. Writing has opened me many avenues over the years. Thought of combining all the data warehouse related article into a one post in different areas in data warehousing. 

DESIGN

What is a Data Warehouse? (mssqltips.com)

Things you should avoid when designing a Data Warehouse (sqlshack.com)

Infrastructure Planning for a SQL Server Data Warehouse (mssqltips.com)

Why Surrogate Keys are Needed for a SQL Server Data Warehouse (mssqltips.com)

Create an Extended Date Dimension for a SQL Server Data Warehouse (mssqltips.com)

SQL Server Temporal Tables Overview (mssqltips.com)

Data Warehousing Best Practices for SQL Server (mssqltips.com)

 SSIS

•       Testing Type 2 Slowly Changing Dimensions in a Data Warehouse (sqlshack.com)

•       Implementing Slowly Changing Dimensions (SCDs) in Data Warehouses (sqlshack.com)

•       Incremental Data Extraction for ETL using Database Snapshots (sqlshack.com)

•       Use Replication to improve the ETL process in SQL Server (sqlshack.com)

•       Using the SSIS Script Component as a Data Source (sqlshack.com)

•       Fuzzy Lookup Transformations in SSIS (sqlshack.com)

•       SSIS Conditional Split overview (sqlshack.com)

•       Loading Historical Data into a SQL Server Data Warehouse (mssqltips.com)

•       Retry SSIS Control Flow Tasks (mssqltips.com)

•       SSIS CDC Tasks for Incremental Data Loading (mssqltips.com)

 SSAS

•       Multi-language support for SSAS (sqlshack.com)

•       Enhancing Data Analytics with SSAS Dimension Hierarchies (sqlshack.com)

•       Improve readability with SSAS Perspectives (sqlshack.com)

•       SSAS Database Management (sqlshack.com)

•       OLAP Cubes in SQL Server (sqlshack.com)

•       SSAS Hardware Configuration Recommendations (mssqltips.com)

•       Create KPI in a SSAS Cube (mssqltips.com)

•       Monitoring SSAS with Extended Events (mssqltips.com)

SSRS

•       Exporting SSRS reports to multiple worksheets in Excel (sqlshack.com)

•       Enhancing Customer Experiences with Subscriptions in SSRS (sqlshack.com)

•       Alternate Row Colors in SSRS (sqlshack.com)

  Cloud

•       Migrate On-Premises SQL Server Business Intelligence Solution to Azure (mssqltips.com)

Other

•       Dynamic Data Masking in SQL Server (sqlshack.com)

•       Data Disaster Recovery with Log Shipping (sqlshack.com)

•       Using the SQL Server Service Broker for Asynchronous Processing (sqlshack.com)

•       SQL Server auditing with Server and Database audit specifications (sqlshack.com)

•       Archiving SQL Server data using Partitions - SQL Shack

•       Script to Create and Update Missing SQL Server Columnstore Indexes (mssqltips.com)

•       SQL Server Clustered Index Behavior Explained via Execution Plans (mssqltips.com)

•       SQL Server Maintenance Plan Index Rebuild and Reorganize Tasks (mssqltips.com)

•       SQL Server Resource Governor Configuration with T-SQL and SSMS (mssqltips.com)