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…
Schemas in a Data Model
In our last Power BI training in Sydney, we spent a lot of time answering questions around the best data modeling schema for creating reports in Power BI. Schema refers…
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…
4 Steps to create a Data Model | Power BI training in Sydney | Power BI training in Melbourne
Data Modeling is a part of our every Power BI training in Australia. In Power BI Basic course, only the basic concepts related to data modeling are covered whereas Power…
The Data Preparation Stage of Data Modeling
We often spend a lot of time in our Power BI advanced training in Sydney focusing on the creation of a perfect data model before starting any reporting task. Data…
Getting the right number of tables for a good data model
Data modeling is one of the core topics covered in Power BI Advanced training in Sydney and Power BI Advanced training in Melbourne. Data Model refers to the abstract model…
Relationship Characteristics of a Data Model
Data Modeling is one of the core topics discussed in our advanced Power BI training in Sydney and Melbourne. Without the correct data model, analytics can merely add any value.…
Data Modeling: Filter Propagation in Action
A Data model in Power BI consists of the right number of tables with the right relationship between these tables. The data is present in the table but can be…