CI/CD & DevOps for Power BI… Are We There Yet?
Paul Turley's SQL Server BI Blog
by Paul Turley
1M ago
In my view, projects and teams of different sizes have different needs. I described DevOps maturity as a pyramid, where most projects don't require a sophisticated DevOps implementation, and the most complex solutions do. The DevOps maturity is a progression, but only for projects of a certain scale. One of the following options might simply be the best fit for a particular project. Unless you are throwing together a simple Power BI report that you don't plan to maintain and add features to, the first and most basic managed project should start with a PBIX file or Power BI Project folder store ..read more
Visit website
Power BI for the Enterprise Precon: Atlanta Feb 9th
Paul Turley's SQL Server BI Blog
by Paul Turley
1M ago
Please come to the Atlanta SQL Saturday BI Edition in February, and join me for a full-day preconference event: Designing and Developing Enterprise-scale Solutions with Power BI ..read more
Visit website
Conference Sessions and Presentations in late 2023 & 2024
Paul Turley's SQL Server BI Blog
by Paul Turley
6M ago
Events I am presenting Check back for event links and updates March 2023 Using Power BI with Lots of Data ..read more
Visit website
Introducing the New Power BI Project, and why it is important
Paul Turley's SQL Server BI Blog
by Paul Turley
9M ago
The enterprise Business Intelligence and IT community have been anxiously awaiting this capability for many years and it has finally arrived - at least in Preview form for testing and prototyping real Power BI CI/CD DevOps solutions ..read more
Visit website
How Does Microsoft Fabric Change the Enterprise BI Game?
Paul Turley's SQL Server BI Blog
by Paul Turley
10M ago
Microsoft Fabric (#MicrosoftFabric), the new Unified Analytics platform, was announced this morning, literally moments before the Build Conference. Satya made the official announcement in the keynote address. Why is this big news and why is it important? In a few words, this is the most significant expansion to the Power BI and the analytics platform since the product was introduced. Satya said that Fabric is the most significant data platform innovation since SQL Server ..read more
Visit website
How Lakehouse Architecture is Revolutionizing Business Intelligence
Paul Turley's SQL Server BI Blog
by Paul Turley
10M ago
The Lakehouse is the evolution of the earlier cloud data platform in many pieces that came with "some assembly required". All of the components are modern, mature and capable but complicated and require specialized skills. Imagine that the new version is easier to assemble with instructions that are only a few pages with stick figures, and it comes with an Allen wrench. We're seeing consulting customers putting Lakehouse and BI solutions on-line in just a few weeks. Then they iterate to scale-up their modern data warehouse/BI platform as they train their Center of Excellence champions and Data ..read more
Visit website
Protected: DevOps & CI/CD for Power BI 
Paul Turley's SQL Server BI Blog
by Paul Turley
11M ago
There is no excerpt because this is a protected post ..read more
Visit website
Creating and Displaying a Last Refresh Date Measure
Paul Turley's SQL Server BI Blog
by Paul Turley
1y ago
usiness users often need to know how fresh the data is that they see on a Power BI report. This requirement can be interpreted to mean either "when was the last date & time that the source data was updated?" or "when was the last date & time that the data model was refreshed?" I've used a few different approaches to record the actual date and time, but all generally using the same technique ..read more
Visit website
Power BI and the Dimensional Dilemma
Paul Turley's SQL Server BI Blog
by Paul Turley
1y 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
1y 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

Follow Paul Turley's SQL Server BI Blog on FeedSpot

Continue with Google
Continue with Apple
OR