Category: Data Science

Top 25 SQL Commands to Python Cheat Sheet

Hello Readers, Are you a programmer like me, who have who have mastered SQL over the years and then ventured into the world of Python??  As per the TIOBE (The Importance Of Being Earnest ) and PYPL (PopularitY of Programming Language Index),  Python is ranked as #1 most […]

Checkmate the OCR Challenge: Image to Text Extraction

Extract text from images in 3 simple steps Unleash the power of Microsoft Azure Computer vision using Python OCR optical character recognition or to say in layman terms extracting text from images has been one of the most remarkable features available today. Gone are the days when organizations employed […]

Key Phrase Extraction and Visualization: Python and Microsoft Power BI

Discover insights in unstructured text   Implementing RAKE algorithm in Python and Power BI integration Key-Phrase Extraction, Photo by Rabie Madaci on Unsplash We live in an age where data is the new currency! This makes the Big tech giants the richest companies in the world. The best investment for the […]

Analyzing and Visualizing Sentiments from Unstructured data

Using Microsoft Azure Text Analytics and Power BI Integration Photo by Mason Jones on Unsplash The Sentiment Analysis Microsoft Azure Cognitive services and Power BI Integration The total amount of data created, captured, copied, and consumed in the world is forecasted to increase rapidly, reaching 74 zettabytes in 2021 (Source: Statista). Imagine how much of this 74 […]

VBA Macro to Split Single Excel file into Multiple Excel Files basis any row count

Dear Readers,  A strong command in MS Excel is one of must have skill for every professional but an expertise in VBA is a lifesaver. Recently, I encountered a common situation where a platform had a limitation of accepting excel files with no more than 1000 rows. This […]

Bye Bye VLOOKUP, Welcome XLOOKUP!

Yes, its true, It is time to forget Vlookup, Hlookup, Index-Match as Microsoft Excel is now fully loaded with XLOOKUP. This best in breed function is called XLOOKUP as it can do Cross lookup (*vertically as well as horizontally). Here is the quick syntax: =XLOOKUP (lookup_value, lookup_array, return_array, […]

How to Count Distinct in a pivot table?

Hello Learners, Today, I am going to talk about a handy and simple Excel formula which can help you count distinct values in a pivot table. When we create a pivot table and look for field values options we can see that we can summarize values by Count, […]

VBA Basics – Part 1

Dear Readers, VBA stands for Visual Basic for Applications an event-driven programming language from Microsoft. The Birth story of VBA VBA was derived from Visual Basic. The story of the birth of VBA began in 1991 when Microsoft partnered with Alan Cooper from Tripod under the project code named as “Ruby“. Microsoft decided […]

We improve our products and advertising by using Microsoft Clarity to see how you use our website. By using our site, you agree that we and Microsoft can collect and use this data. Our privacy statement https://jayantkodwani.com/get-certified/privacy-policy/ has more details.