4 Simple Steps to Convert Your Flat File into a Data Model
The beginner level attendees of our Power BI training in Sydney and Power BI training in Melbourne often find it difficult to make a Data Model out of a Flat File. Flat file…
Circular References in Data Modeling
In our recent Power BI online training held in Sydney, one of the attendees accidently created a circular referenced data model while solving a common business problem. This created an…
Creating Bridge Table
Our attendees of Power BI training in Australia often come up with the problem of linking two tables with many-to-many relationship between them. This issue is addressed immediately by our…
Creating a basic Calendar lookup Table
In our last Power BI training in Sydney, we noticed that as a beginner, users normally create a calendar dimension table in Excel and connect and transform via Power Query.…
Power BI Best Practices, guidelines, and How to Avoid Common Mistakes – a Beginner’s Guide
In our Power BI training in Sydney, Melbourne, and other Australian cities, we provide in-depth training on Power BI covering basics to advanced level content. Our blogs provide insights on…
Dealing with misleading interpretations | Power BI training in Sydney | Power BI training in Melbourne
Creating stunning visualizations in Power BI is amazingly easy but the correctness of values must be ensured so that legitimate information is conveyed. In our last Power BI training in…
Working with Multiple Fact Tables | Power BI training in Sydney | Power BI training in Melbourne
In our last Power BI training in Sydney, we found out that 60% of our Power BI Basic course attendees consider it impossible to have multiple fact tables in a…
Active vs. Inactive Relationship in a Data Model
Our Power BI courses across Australia and Power BI training across Australia cover the data modeling principles in detail. We address all the issues from basic to advanced level. To…
Creating Product Hierarchy in a Table
Power BI training sessions always uncover common issues. The aim of this blog series is to address the common issues occurring in our Power BI training in Sydney, Melbourne, Brisbane,…
Optimizing Data Model
Whether it’s a Power BI training in Sydney or a Power BI training in Melbourne, data modeling is an essential part of the lesson. Our trainers ensure that all the…