Unlocking Insights: Visualizing Data on GCP with Tableau Hey readers! I’m excited to share a new article with you. In this article, we’ll explore the seamless integration of GCP Big Query with Tableau, allowing you to effortlessly visualize your data on the Google Cloud Platform using the powerful features of Tableau. Let’s dive in and discover how you…

Azure Data Engineering Interview Questions Data engineering is a critical role in the world of data science and analytics. In this article, I will be sharing questions that I have faced during the interview process i.e., asked in product and service-based companies. Write an SQL query to find a day on which the weather temperature…

Power BI: Transforming Data with ETL Techniques In a world driven by data, making informed decisions is paramount. Enter Power BI , a dynamic tool that transforms raw data into meaningful insights. Power BI stands out for its user friendly interface, seamless integration and powerful visualization tools. Whether you are a business analyst, data enthusiast, or decision…

From Preparation to Success: “A Roadmap for Passing Databricks Certified Data Engineering Associate” Hello!! My medium family this time I am back with an article, sharing my journey from preparation to success for the certificate exam. I am happy to share I have cleared my Databricks Certified Data Engineering Associate Exam with preparation of one month. With this article I will be sharing…

POWER OF APACHE SPARK API Spark an distributed engine which provide an support for various languages such as Java, Python, Scala, Sql. It provides an flexibility for an programmer to write code in any supported language. In this article we will discuss about the API support provided by Apache spark which provide a great ease…

Joins In Pyspark In this article we will explore the reason behind joining tables/data frame and types of joins used in Pyspark. With the requirement of bringing more clear and meaningful way to store data in table led to coming up of data modelling concept in the world of data warehouse. Datamodelling…

Demystifying Azure Integration Runtime(IR) How to Seamlessly Connect and Manage Data Across Your Ecosystem. In simple terms, IR describes “how to take the data “.Let’s understand the detailed definition of IR. “Azure Integration Runtime Bridges the Gap Between Cloud Data and Between On-Premises Data and Cloud Data.” Integration Runtime provides computation power to the…

Working with Dates and Time in PySpark Recently working on my current project faced a scenario where we need to convert a string datatype column with the date value to a date or datetime datatype with the same value. In this article, we will learn how to convert different formats of date/datetime values using Pyspark. Functions to…

Unleashing the Power of Azure Synapse with External Table In this article, we will learn how to create an external table in Dedicated SQL Pool and Serverless SQL Pool. How do create an External Table in Serverless SQL Pool? # create database DROP DATABASE appdb; CREATE DATABASE appdb; # Change to connect to: built-in and db name: appdb CREATE…