Power BI and the Dimensional Dilemma
Paul Turley's SQL Server BI Blog
by Paul Turley
5h ago
There is no secret about this. If you do any legitimate research about Power BI (reading blogs, books or training from reliable sources), you will quickly learn that a lot of basic functionality requires a dimensional model, aka "Star Schema". This is a hard fact that every expert promotes, and self-taught data analysts either have learned or will learn through experience. So, if everyone agrees on this point, why do so many resist this advice? Perspective is everything. I didn't understand why getting to the star schema was so out of reach so often until I was able to see it from another pers ..read more
Visit website
Developing Large Power BI Datasets – Part 3 – Detail Tables
Paul Turley's SQL Server BI Blog
by Paul Turley
2M ago
Power BI is architected to consume data in a dimensional model, with narrow fact tables and related dimensions. Introducing a big, wide table in a tabular model is extremely inefficient. It takes up space and memory resources, impacts performance, and complicates measure coding. Flattening records into a flat table is one of the worst things you can do in Power BI and a common mistake made by novice Power BI users ..read more
Visit website
Developing Large Power BI Datasets – Part 2 – Partitioning
Paul Turley's SQL Server BI Blog
by Paul Turley
2M ago
Partitioning Large Tables Table partitioning has long been an important task in semantic model design using SQL Server Analysis Services. Since SSAS Tabular and Power BI models are built on top of the SSAS architecture, the pattern of partitioning remains the same as it has been for twenty years. However, the specific methods for implementation have been fine-tuned and improved. The reasons for partitioning large fact tables mainly include: Improve refresh speed Prevent reloading historical records Capture updated history Reduce database resource load You don't have to have massive tables to b ..read more
Visit website
Developing and Managing Large Power BI Datasets – Part 1
Paul Turley's SQL Server BI Blog
by Paul Turley
2M ago
When planning a Power BI solution, how can we plan for scale and growth? Like any technology, Power BI has ..read more
Visit website
Power BI Object Names – Why Standards Are Important
Paul Turley's SQL Server BI Blog
by Paul Turley
3M ago
Dear colleague, if I have sent you to this post, it is because I respect you and want to make ..read more
Visit website
Getting Data Into Shape for Reporting with Power BI
Paul Turley's SQL Server BI Blog
by Paul Turley
5M ago
I see a lot of Power BI projects that we are asked to fix or performance tune, and at least nine times out of ten, the answer is that the data needs to be shaped and transformed so it is optimized for reporting. This is often an iterative process, which means that a developer might ..read more
Visit website
Full-day Power BI for Enterprise Solutions Workshop in Chicago, Sept 12
Paul Turley's SQL Server BI Blog
by Paul Turley
6M ago
If you are in the Chicago area and haven’t already registered for the Data Insights Summit, please join me. I will be teaching a full-day workshop specifically focused on Power BI enterprise-scale solution best practice design. With in-person events resuming, I’m excited to get back into the classroom and teach what I love so much ..read more
Visit website
Use Paginated Reports to Create a Gantt Chart
Paul Turley's SQL Server BI Blog
by Paul Turley
10M ago
A Gantt chart is an excellent example of where Paginated Report & SSRS were an ideal choice for the purpose. It is a running list of activities with the duration for each displayed as a horizontal bar depicting the beginning and ending day along a horizontal scale. The challenge is that this is not a standard chart type in either Power BI or SSRS/Paginated Reports. Furthermore, project planners may prefer to see activities as rows in the format of a printed page ..read more
Visit website
Doing Power BI The Right Way – for Enterprise Reporting
Paul Turley's SQL Server BI Blog
by Paul Turley
1y ago
I started a series of blog posts back in 2020 about best-practice guidelines for planning and designing enterprise reporting solutions with Power BI. To make the topics covered in this series of posts easier to find and follow, they are listed on this page: Doing Power BI The Right Way – for Enterprise ReportingPaul Turley's SQL Server BI Blog which you can access from the main menu on the blog. We have a few more topics to go so check back and subscribe for notifications ..read more
Visit website
Doing Power BI the Right Way: 8. Delivery options
Paul Turley's SQL Server BI Blog
by Paul Turley
1y ago
Part of the the series: Doing Power BI the Right Way When you sign-up for the Power BI service at PowerBI.com (this address redirects to App.PowerBI.com), use establish a tenant for your organization, hosted in the Azure cloud. Even if you setup a 90-day trial account, you have a tenant that you can upgrade later on ..read more
Visit website

Follow Paul Turley's SQL Server BI Blog on Feedspot

Continue with Google
OR