Evolution of BI in 2024
I wrote a blog defining Business Intelligence (BI) back in 2021. So what is BI in 2024? It is still not mind-reading, but close enough. However, everyone defines it differently,…
What is Amazon Redshift?
Data warehousing is not a new concept as it is about multiple processes stitched together to consolidate data from several data sources, store them in a common format, and transform…
Building Your First Report and Dashboard in Power BI: A Step-by-Step Guide
Introduction Embark on your Power BI journey by creating a stunning report and dashboard that bring your data to life! In this article, I'll walk you through each step -…
A Guide to Snowflake Data Cloud Platform
Traditional data warehouses faced challenges with storing large volumes of data and providing faster and more efficient analytical queries. Things are changing with modern cloud warehouse solutions where the storage…
A Guide to Azure Synapse Analytics Architecture
Digital transformation is critical in today's age to stay competitive. This requires a powerful data management strategy to oversee data integrity & quality, security, and integration with all different data…
Mastering Power BI – The Ultimate Guide For Beginners
Imagine if Excel, Picasso, and a data wizard had a love child - that’s Power BI. It’s Microsoft’s powerhouse tool for transforming raw data into interactive, visual stories. Whether you’re…
Is it time to move to Azure?
Let's jump on the cool kids' bandwagon and move to the cloud. Seriously, you do not want to be the only one doing backups, patching, and worrying about EOL support…
How to perform a large delete operation
Deleting data from your production databases can be tricky. You can either choose TRUNCATE or DELETE statements to suit your need. Here in this blog, I will focus more on…
How To Tune SSRS Reports?
Let us not get into a discussion of why we are still talking about SSRS here and not some other fancy BI technologies like Power BI, Tableau, etc. I like…
What are partitions in SQL Server?
SQL Server supports table/index partitions that store multiple chunks of row data in different partitions. Starting in 2016 SP1, this is no longer just an enterprise edition-only feature. In a…