Let’s cut the chase and make a series of mini posts 😊 to cover how to’s? As of the time of writing this mini blog, we cannot use VENETS to bring data from snowflake. Option 1: use a On premise gateway that is running in same network as the snowflake. Option 2: write to Iceberg […]
When loading data into Power BI, it is often necessary to convert date columns to datetime columns. This is because Power BI uses datetime columns for its internal data storage for incremental load. There are a number of ways to convert date columns to datetime columns in M code. One way is to use the […]
In data warehousing, two main approaches to data modeling are Tabular and Multidimensional Cube. Each method has its own strengths and weaknesses, and the decision on which to use depends on the needs of the business. Tabular models are built on the relational database model and use the DAX (Data Analysis Expressions) language for calculations […]
In dimensional modeling, there are two main schema designs: Snowflake and Star. Each has its unique advantages and use cases, and the decision to use one over the other depends on the data and the requirements of the business. Snowflake schema is a normalized design that separates data into multiple related tables. This schema is […]
Moving data from Databricks to Snowflake can be a bit tricky, but with the right tools and approach, it can be done relatively easily. In this blog post, we’ll take a look at how to move data from Databricks to Snowflake, including a step-by-step guide and some best practices to keep in mind. Before we […]
PySpark is the Python library for Spark programming. It allows developers to interface with the powerful Apache Spark engine through Python, a popular language for data science and machine learning. PySpark enables data scientists to perform complex data manipulation and analysis tasks with minimal code and maximum efficiency. One of the main benefits of PySpark […]
Power BI is a powerful data visualization tool that allows users to create interactive reports and dashboards. One of the key features of Power BI is the ability to connect to a variety of data sources and refresh the data to ensure that the reports are up-to-date. However, as the data sources grow in size […]
Power BI Embedded is a powerful tool that allows you to embed interactive Power BI reports and visualizations into your own applications. In this blog post, we will discuss the process of creating an application with Power BI Embedded and provide a code example to help you get started. Before you can create an application […]
Visual Basic for Applications (VBA) is a programming language that can be used to extend the functionality of Paginated Reports in Power BI. In this blog post, we will discuss the benefits of using VBA in Paginated Reports, some common use cases, and how to get started with using VBA in your reports. One of […]
Dimensional modeling is a technique used to design and organize data in a way that makes it easy to understand and analyze. In this blog post, we will discuss the importance of dimensional modeling and how it can be used to improve the performance of your business intelligence and data warehousing systems. One of the […]