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”
Tag Archives: Data Analytics
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”
Query Folding and Query Diagnostics in Power BI
It is important that your Power BI dashboard is updated and refreshed as quickly and giving good performance to your dashboard users. Having query timeout error, more refreshing time is going to cause frustration to the users. Power BI has in built tools to check the performance of your queries. Power BI provides the PerformanceContinue reading “Query Folding and Query Diagnostics in Power BI”
All about Power BI Service
As you know Power BI is a collection of software services, apps that work together to help you create, share dashboards. The Microsoft Power BI service (app.powerbi.com), sometimes referred to as Power BI online, is the SaaS (Software as a Service) part of Power BI. In the Power BI service, dashboards help you keep a finger on the pulse ofContinue reading “All about Power BI Service”
Excel Automation using Power Query
Microsoft Excel includes a powerful feature called Power Query—also known as Get & Transform or Get Data—which provides fast and powerful data gathering and cleansing capabilities. A biggest advantage of Power Query & Power Pivot is, you can have large amounts of data compressed and stored in memory to transform and analyze anytime for creatingContinue reading “Excel Automation using Power Query”
A-Z of Power Query
Create Low Code Automated Dashboard Are you finding difficult to learn VBA – Macros like me? Are you taking more time to clean & transform your data like me? Are you looking for “Low code options to perform ETL process like me? Bored of doing repetitive tasks in Excel? Power Query & Power Pivot isContinue reading “A-Z of Power Query”
LR Virtual Classroom 