star schema
5 posts about star schema by 4 contributors.
Know star schema? Share what you know with developers who are learning it.
- Articles
- 5
- Contributors
- 4
Articles about star schema
- Article · Power BI
From Tables to Insights: Connecting PostgreSQL to Power BI Locally and on Azure
A practical guide to connecting PostgreSQL with Power BI for data analysis and reporting. It covers local and Azure Database for PostgreSQL connections, authentication, Import and DirectQuery modes, troubleshooting, data modelling, SQL optimisation, database views, and best practices for building reliable and efficient Power BI reports.
- Article · Power BI
Power BI Data Modeling Mistakes That Kill Performance
Optimize Power BI models! Discover common data modeling mistakes that kill performance, from star schema flaws to calculated column overuse. Build faster reports!
- Article · Power BI
How to Optimize Power BI Reports for Large Datasets
Optimize Power BI reports for large datasets! Learn data modeling, DAX optimization, and storage strategies for faster, reliable, and scalable performance.
- Article · Databases & DBA
Star Schema vs. Snowflake Schema – Which One Should You Use?
When designing a data warehouse, choosing the right schema structure is crucial for performance, usability, and scalability. Two of the most commonly used schemas are Star Schema and Snowflake Schema. In this article, we’ll explore what each schema looks like, how they differ, and when you should use one over the other.
- Article · Power BI
Best Practices for Power BI Data Modeling
Learn Power BI data modeling practices for improving report performance, including star schemas, relationships, DAX optimization, date tables, and reducing model size.
