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 […]
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 […]
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 […]
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 […]
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 […]
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, […]
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, […]
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 […]
Recent Comments