March 2026
Intermediate to advanced
478 pages
12h 7m
English
Content preview from Microsoft Power BI Data Analyst Associate Study Guide
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 6. Planning and Architecting Enterprise Power BI Solutions
When Power BI was released in 2015, many industry professionals recognized that at first it was a significant departure from their previous product focus that addressed the needs of IT developers and database professionals. Microsoft product teams had previously made deep investments in enterprise-ready technologies that eventually comprised all the capabilities within Power BI; namely, to connect to, transform, store, model, calculate, and visualize business data. However, projects were developed using IT developer tools like Visual Studio and SQL Server Management Studio (SSMS).
As self-service analytics and business intelligence reporting tools became popular, Microsoft adapted these technologies with a focus on ease-of-use for the desktop user. At first, competitors pushed the industry forward with impressive visualization features, which quickly caught the attention of business data users, and new products rose in popularity, but Microsoft had an edge; they had already developed data storage and data management technologies that were up to the task of handling large quantities of data at scale. Within a few short years, Power BI evolved to serve the needs of two audiences—desktop data analysts and professional IT data professionals.
Power BI, along with Microsoft Fabric, now leads the industry in both categories and many in-between. This chapter explores the balance between enterprise-managed data and self-service ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.