Vol. 01 · Knowledge Sarva
A working field guide for AI + data builders
Knowledge sarva.
Tutorials, deep dives, and dispatches for builders shipping with AI, data platforms, and open-source.
- Dispatches
- 50
- Quadrants
- 05
- Last filed
- Mar 11, 2025
Browse by tag
Recent dispatches
50 matching- Mar 11, 202514 min
Iceberg
Apache Iceberg, an open-source table format for data lakes. This guide covers core concepts, features like ACID transactions and time travel, and implementation on platforms like Spark and Snowflake.
Akhil Gurrapu
- Mar 11, 202510 min
PowerBI and Snowflake Integration
This blog will explore how to effectively integrate Power BI with Snowflake, focusing on best practices and technical details from the provided documents. It aims to help users understand the process and optimize their data analytics…
Akhil Gurrapu
- Mar 11, 20256 min
Building an MCP Server for Snowflake Cortex Agents
Step-by-step guide to building a Model Connectivity Protocol (MCP) server for Cortex Agents with Snowflake, enabling AI applications like Cursor to connect to your Snowflake data and documentation.
Akhil Gurrapu
- Dec 21, 20246 min
Optmizing Query Performance with Clustering Keys in Snowflake
This blog explores how Clustering Keys Data Pruning, and the Search Optimization Service (SOS) enhance query efficiency in Snowflake. It explains how clustering keys physically organize data into micro-partitions enabling faster queries by…
Akhil Gurrapu
- Dec 19, 20245 min
Connect Power BI to On-Premise Oracle Database via VPN
Learn how to securely connect Power BI Desktop to an on-premise Oracle database using VPN, configure the On-Premises Data Gateway, and automate report refreshes in Power BI Service. Includes troubleshooting tips, performance optimizations,…
Akhil Gurrapu
- Nov 21, 202415 min
Automating Power BI Workflows with CI/CD in Microsoft Fabric
An in-depth blog on automating Power BI workflows with CI/CD (Continuous Integration/Continuous Deployment) in Microsoft Fabric. This blog covers Azure DevOps and Git integration, automating deployments for data pipelines and reports, and…
Akhil Gurrapu
- Nov 18, 20243 min
Installing Oracle Database on macOS
Discover how to easily set up Oracle Database on your Mac using Docker containers. This step-by-step guide walks you through the installation process, from Docker setup to database configuration, and shows you how to connect using VS Code.
Akhil Gurrapu
- Oct 23, 20245 min
dbt and Snowflake Integration
This article explores the integration of dbt with Snowflake, a comprehensive guide to using dbt with Snowflake. It covers the main concepts of dbt, including models, materializations, sources, tests, documentation, macros, and packages. It…
Akhil Gurrapu
- Oct 23, 20243 min
DBT
This article explores the types of tests in dbt (data build tool), including generic tests, dbt_utils package tests, and custom tests. It provides an overview of each type of test, their purpose, and how to use them effectively to ensure…
Akhil Gurrapu
- Aug 30, 20243 min
Snowflake Fundamentals
An overview of Snowflake, a cloud-based data warehouse platform. This article explains Snowflake's architecture, key features, and how it differs from traditional data warehouses. Learn about its separation of storage and compute, support…
Akhil Gurrapu
- Aug 30, 20249 min
What is Snowflake?
An overview of Snowflake, a cloud-based data warehouse platform. This article explains Snowflake's architecture, key features, and how it differs from traditional data warehouses. Learn about its separation of storage and compute, support…
Akhil Gurrapu
- Aug 8, 202432 min
SQL Interview Quick Guide: From Basics to Interview Ready
Whether you're a beginner or looking to polish your skills, this blog post breaks down essential SQL concepts with clear explanations and practical examples of potential SQL interview questions. Prepare to your next SQL interview!
Akhil Gurrapu
- Aug 6, 202438 min
Power BI Interview Ready
Let's look at all the possible Power BI interview questions
Akhil Gurrapu
- Jul 6, 202411 min
Microsoft Purview: Unified Data Governance and Security
Discover Microsoft Purview's capabilities for data management and protection. This guide covers: Core components and features of Microsoft Purview, Data security, governance, and risk management solutions. How Microsoft Purview can enhance…
Akhil Gurrapu
- Jun 12, 20243 min
Using Azure Key Vault in Microsoft Fabric Notebooks
Learn how to securely manage secrets in Microsoft Fabric Notebooks using Azure Key Vault.
Akhil Gurrapu
- Mar 30, 20245 min
DP-600: Implementing Analytics Solutions Using Microsoft Fabric Certification Roadmap
A comprehensive guide to preparing for and earning the Microsoft Certified: Fabric Analytics Engineer Associate certification
Akhil Gurrapu
- Mar 11, 20246 min
DBT and Snowflake Native app
DBT and Snowflake Native app, how dbt works as a full functional Snowflake native app.
Akhil Gurrapu
- Feb 17, 20245 min
Azure Data Factory: Microsoft Cloud Data Integration Tool
Azure Data Factory is Microsoft's cloud-based service for orchestrating and automating data movement and transformation. It offers data integration from various sources, supports complex ETL processes, and enables efficient workflow…
Akhil Gurrapu
- Feb 17, 20246 min
Row-level security (RLS) in Power BI
This article provides a detailed overview of implementing Row-Level Security (RLS) in Power BI. It covers setting up roles and rules in Power BI Desktop and the Power BI service with a real world Example
Akhil Gurrapu
- Feb 11, 20246 min
Real Time - Analytics with Azure Databricks:
This beginner-friendly article explores Azure Databricks in IIoT, detailing its role in enhancing data analytics from ingestion to data visualization, machine learning. It includes a practical case study on wind turbine optimization,…
Akhil Gurrapu
- Feb 8, 20247 min
What is Data Modeling - Normalization, and Application in OLTP Systems
Explore the essentials of Data Modeling in this article, which covers key types (Conceptual, Logical, Physical) and techniques like ER Modeling and Normalization. It highlights normalization's role in databases, particularly in OLTP systems
Akhil Gurrapu
- Feb 8, 20245 min
PL-300: Microsoft Power BI Data Analyst Certification Roadmap
Your go-to guide for conquering the PL-300 Power BI Data Analyst exam, packed with practical tips and resources for success.
Akhil Gurrapu
- Jan 23, 20245 min
Data Science in Microsoft Fabric
Learn how Microsoft Fabric simplifies data science from start to finish. Explore key steps, machine learning models, and efficient experimentation and model management with MLflow. Uncover the tools and techniques for data-driven…
Akhil Gurrapu
- Jan 23, 20246 min
Data Integration in Microsoft Fabric Data Warehouse
Uncover the power of Microsoft Fabric Data Warehouse. Learn its key features, ETL process, and data loading strategies. Explore data pipelines, advanced SQL capabilities, and Dataflow Gen2. Get hands-on with workspace setup, lakehouse…
Akhil Gurrapu
- Jan 23, 20248 min
Data Warehouses in Microsoft Fabric
Explore the power of Microsoft Fabric's data warehouse, designed for seamless collaboration among data professionals. Learn data ingestion, storage, querying, modeling, and visualization essentials. Create your own Fabric data warehouse…
Akhil Gurrapu
- Jan 23, 20243 min
Understanding the Role of a Fabric Administrator
This article provides a concise overview of the Fabric Administrator's role in Microsoft's Fabric platform. It explains key concepts, administrative tools, and responsibilities associated with Fabric administration. The article also…
Akhil Gurrapu
- Jan 22, 20249 min
Apache Spark for data ingestion into Microsoft Fabric Lakehouse using Notebooks
Explore the power of Apache Spark and Python for seamless data ingestion into Microsoft Fabric Lakehouse. Dive into Fabric notebooks, a scalable and systematic solution that empowers you to ingest external data, configure authentication…
Akhil Gurrapu
- Jan 21, 202419 min
Microsoft Fabric Lakehouse and Medallion Architecture
Explore how Fabric's Lakehouse solution, empowered by the flexible Medallion Architecture, transforms data handling and analytics for businesses. Learn about the architecture's layers, implementation, simplified data querying, reporting,…
Akhil Gurrapu
- Jan 20, 202410 min
What is Microsoft Fabric
Explore Microsoft Fabric, an all-in-one analytics platform that simplifies data analytics for businesses and professionals. Discover its core features, including OneLake, and how it unifies various data tools, making data-driven decisions…
Akhil Gurrapu
- Jan 19, 20246 min
Apache Spark in Microsoft Fabric:
In this article, discover the key features and advantages of using Apache Spark in Microsoft Fabric. Explore its versatile language support, Spark settings, and rich library ecosystem. Learn how Microsoft Fabric seamlessly integrates Spark…
Akhil Gurrapu
- Jan 19, 20244 min
Data Factory Pipelines in Microsoft Fabric
EExplore the power of data pipelines in Microsoft Fabric. Learn how these pipelines streamline data transfer and transformation, using activities, parameters, and runs for efficient data management. Discover a code-minimal approach to…
Akhil Gurrapu
- Jan 19, 20244 min
DataFlows (Gen2) in Microsoft Fabric
Explore how Microsoft Fabric's Dataflows (Gen2) revolutionizes data engineering in the retail industry with global operations. This essential tool simplifies the extraction, transformation, and loading (ETL) processes, making it an…
Akhil Gurrapu
- Jan 19, 202410 min
Delta Lake tables in Microsoft Fabric
This article explores the integration of Delta Lake tables within Microsoft Fabric's lakehouse architecture. It highlights the key features of Delta Lake, including relational table operations, ACID transactions, data versioning, and…
Akhil Gurrapu
- Jan 19, 20246 min
Exploring Sales Data with Apache Spark in Synapse Data Engineering
In this tutorial, we navigate the process of creating a lakehouse in Synapse Data Engineering, a critical component for data analysis and management. The journey begins by downloading a dataset (orders.zip) containing sales data from 2019…
Akhil Gurrapu
- Jan 17, 20245 min
Microsoft Fabric and How to Enable and Access Microsoft Fabric
Learn what Microsoft Fabric is, its services, and how to access it in this informative article. In today's data-driven landscape, Microsoft Fabric emerges as a comprehensive solution, streamlining data analytics for both experts and…
Akhil Gurrapu
- Jan 17, 20245 min
Microsoft Fabric Lakehouse
Explore the innovative Microsoft Fabric Lakehouse, a powerful data management solution that combines the flexibility of a data lake with the analytical capabilities of a data warehouse. Learn how it simplifies data processing, offers…
Akhil Gurrapu
- Jan 14, 20244 min
SQL Server Setup on Mac with Docker: A Step-by-Step Guide
A straightforward guide to setting up SQL Server on Mac using Docker. From installation to running a SQL Server container, this article provides easy-to-follow steps tailored for developers and database enthusiasts on macOS
Akhil Gurrapu
- Jan 11, 20243 min
Mastering Docker
This article introduces Docker for beginners, focusing on data engineering applications. It covers Docker's essentials and demonstrates setting up a PostgreSQL database and Python environment, ideal for those with basic Docker and…
Akhil Gurrapu
- Jan 9, 20248 min
A Beginners Guide to Numpy in Python
Discover NumPy basics in Python! Learn to manipulate data effortlessly with arrays and boost your coding skills. Perfect for beginners diving into numerical computing.
Akhil Gurrapu
- Jan 9, 202413 min
A Beginners Guide to Pandas in Python
Learn the essentials of Python's pandas library in this beginner's guide. Discover how to effortlessly manipulate and analyze data for your projects.
Akhil Gurrapu
- Jan 7, 20243 min
Hadoop Ecosystem
Explore key components categorized for easy understanding. From data storage to seamless workflows, machine learning discover how Hive, HBase, Flume, and more contribute to the world of big data.
Akhil Gurrapu
- Jan 6, 20246 min
Introduction to Hadoop
Breaking down Big Data basics! 📊 Explored structured, unstructured, and semi-structured data. 📊 Explored big data challenges and solutions, spotlighting HDFS and MapReduce Architecture.
Akhil Gurrapu
- Jan 3, 20246 min
Data Analytics
Welcome to the Microsoft PowerBI Certification Series! Discover the world of data analytics and business intelligence with our comprehensive series. Learn about Power BI, data analysis processes, roles in data management, and gain insights…
Akhil Gurrapu
- Jan 3, 202411 min
Data Modelling in PowerBI
Welcome to the Microsoft PowerBI Certification Series! Discover the world of data analytics and business intelligence with our comprehensive series. Learn about Power BI, data analysis processes, roles in data management, and gain insights…
Akhil Gurrapu
- Jan 3, 20248 min
Preparing Data for Analysis in Power BI
Welcome to the Microsoft PowerBI Certification Series! Discover the world of data analytics and business intelligence with our comprehensive series. Learn about Power BI, data analysis processes, roles in data management, and gain insights…
Akhil Gurrapu
- Jan 3, 20246 min
Optimization in PowerBI
Welcome to the Microsoft PowerBI Certification Series! Discover the world of data analytics and business intelligence with our comprehensive series. Learn about Power BI, data analysis processes, roles in data management, and gain insights…
Akhil Gurrapu
- Dec 28, 20238 min
Lists/Sets/Dictionaries/Tuples in Python
Explore all the key concepts of Lists/Sets/Dictionaries/Tuples in Python related to Data Science
Akhil Gurrapu
- Dec 16, 20234 min
Understanding Keys in Database Design
Learn what Microsoft Fabric is, its services, and how to access it in this informative article. In today's data-driven landscape, Microsoft Fabric emerges as a comprehensive solution, streamlining data analytics for both experts and…
Akhil Gurrapu
- Nov 22, 20233 min
Bayes Theorem in Data Science
Imagine your job search during a recession 🧩. How likely are you to find a job given the economic downturn? 📉 That's where Bayes Theorem comes in!
Akhil Gurrapu