If you are used to working with Excel, you know that all you need is IFERROR() function to avoid any issues with dividing by 0. Also adding a blank to a number is not creating any issues in Excel. In SQL, however, its not that straight forward, you need to remember to differentiate between ISNULL()…
Guide to select G4F providers
G4F, also known as GPT4free is a python package which enables users to prompt language or image generation models for free directly inside a python script without the need to pay for APIs like OpenAI. So what’s the draw-back? Well, there really isn’t one. G4F is just a big list of free GPT providers, like…
The Mantra of AI in today’s Tech World.
If you listen to Microsoft’s Satya Nadella, OpenAI’s Sam Altman, Google’s Sundar Pinchai or any other Tech CEOs you would probably hear the term “AI” used as a sort of mantra that starts and ends every sentence and sometimes in between. Besides these big guys, everybody else is also talking about AI nowadays, but few…
FabCon Las Vegas 2025: The Ultimate Microsoft Fabric Conference
What a Fabulous News: FabCon is in the house! (FabCon stands for Fabric Conference) As the data landscape continues to evolve, staying updated with the latest tools and technologies is essential for data professionals. FabCon Las Vegas 2025, the premier conference for Microsoft Fabric enthusiasts, promises to be an unforgettable event. Scheduled to take place…
Creating user-friendly connection names for long SQL strings (Fabric Endpoint)
Ever wondered how to remember 54 character long, cryptic connection string to a SQL Warehouse in Fabric? It could become challenging when using SSMS to choose the right connection when you have a drop down of few Fabric SQL Endpoint connections. Who knows by heart 54 random character strings? Well, there is no direct way…
Test: ChatGPT vs Microsoft Copilot on image creation
ChatGPT Image Creation I tried comparing the quality of ChatGPT and Microsoft Copilot when it comes to creating an image. I learned that they both use DALL-E tool, but the results are still different as you will see the article. I chose the topic of chihuahua dog, since I find it amusing. The prompt engineering…
How to Disable the Research Pane in Excel
What an annoyance! I personally, have never found any use in Excel’s Research Pane, other that it being really annoying and becoming such a distraction if it pops up unexpectedly, just like that dude Jar-Jar-Binks in Star Wars! If you find yourself wanting to disable it, follow these steps: Method 1 (the only one I…
Create multiple Schema in Lakehouse in Fabric
One thing that I was waiting for that was missing is the ability to create different schema in Lakehouse in Fabric. As of today, it is already in preview mode and can be accessed. The advantage of creating multiple schema in your Lakehouse is that it allows you to organize tables and also provide access…
Everything you need to know about home servers
Do you have an old computer laying around? Or do you need a server for your company? No matter what’s the case, setting up a home server is much easier than you think. In this blog, you will learn the technical specification for a home server and everything else you need to setup. Without further…
Power BI – split budget into ratios via DAX
In certain times, you would like to split a higher grain number into lower grain by using some percentage ratios. For example, if you have a budget for Product Brand all up, we want to split further the budget into Product Names based on last year’s sales percentage ratios. You can do this by: Procedure…