You cannot find a dataset without the field “Date”. It can be created date, approved date, ordered date etc. All the data revolves around time. So it is important to create calendar table first as part of your dataset in Power BI. You can use individual Date and Time functions in Power BI or useContinue reading “Create Calendar Table in 6 easy steps”
Tag Archives: Power BI
Row-level security (RLS) with Power BI Desktop
With Power BI Desktop, row-level security (RLS) may be utilized to limit data access for certain users. You can set filters within roles to restrict data access at the row level. Members of a workspace who have access to datasets in the workspace in the Power BI service will not have any impact by RLSContinue reading “Row-level security (RLS) with Power BI Desktop”
All about Cardinality
As we are aware of the fact and dimension table, it’s important to understand the relationship between the tables. It is where the cardinality comes into the picture. Cardinality is the directionality of a relationship, such as one-to-many, one-to-one, and so on. It describes the directionality between fact and dimension tables. Four Types of Cardinality:Continue reading “All about Cardinality”
Fact vs Dimension Table
The first and foremost concept you need to understand in Power BI is the difference between the Fact and Dimension table. Relationships are defined between tables through primary and foreign keys. Relationships between tables are formed when you have primary and foreign keys in common between different tables. Fact Tables (Foreign Key) Dimension Tables (PrimaryContinue reading “Fact vs Dimension Table”
5 Data Modelling Fundamentals
In this post, let’s understand the 5 important Data modeling fundamentals. They are the most important which one should focus as a beginner. If these are not understood enough, I repeat, it is important to get the basics right. Data and lookup tables & Primary and foreign keys Relantionship Cardinality Filter Flow Evaluation Context CommonContinue reading “5 Data Modelling Fundamentals”
How to Set Up Power BI Gateway
As you know, Power BI allows to connect various sources of data. One such data source is On premises data. It is important to configure the data gateway to enable the schedule refresh and stay updated with dashboard. Let’s recap the common sources of data import in Power BI as listed below: Sources of DataContinue reading “How to Set Up Power BI Gateway”
6 Types of Joins in Power BI
Relationships are defined between tables through primary and foreign keys. This is the important part of data modeling. As soon as you import the data, one of the major step is to define the relationship between the tables to further perform calculations & analysis. Relationships between tables are formed when you have primary and foreignContinue reading “6 Types of Joins in Power BI”
Merge & Append Queries
The ability to combine queries is powerful because it allows you to append or merge different tables or queries together. Why we need to Merge / Append queries? You can combine tables into a single table in the following circumstances: Too many tables exist, making it difficult to navigate an overly-complicated data model. You combineContinue reading “Merge & Append Queries”
Profile Data in Power BI
What is data profiling? Why do we need to perform in Power BI. Yes, Data Profiling is a crucial part of data warehousing, data migration, and Business Intelligence projects. •You have to make sure the data which you are loading to the destination is in a good quality. •During the process of data profiling, mainlyContinue reading “Profile Data in Power BI”
Clean and Transform data with Power BI Query
In this section 10, we are going to learn about the Cleaning & Transforming the data with Power BI Query || Automate Data Tasks in Power Query Editor. Why Do We Need To Clean / Transform The Data Live Demo Of Transforming The Data Best Practices For Naming Tables, Columns, And Values Evaluate And ChangeContinue reading “Clean and Transform data with Power BI Query”
LR Virtual Classroom 