Visualize that data model graphically in a report or on a dashboard using charts, graphs, etc.Ĭlear so far? Each of these steps maps to an add-in for Excel:. Modify the data, making any calculations necessary as desired, in essence creating a data model. 
Collect your data to be used in your dashboard / report from a data source. What are the steps involved? Well, at a very high level, you will be doing the following: Ok so you want to make a “dashboard” of sorts. Sweet! To be sure we’re all on the same page, let’s clear up any confusion on these Power add-ins. The Power Pivot add-in was now included (but had to be enabled), we still had to download Power Query, but now we could also download Power Map. You could build your data and visualizations in Excel, then upload them to a SharePoint site that had Power Pivot configured, which allowed web-based consumption of these great new visuals. These add-ins were free, but you had to download and install them. Add-ins for Excel 2010 were released which included Power Pivot and Power Query. This was required to lay the foundation for the base technology to really catapult the transformation of BI as you know it. This began with the introduction of Power Pivot and Power View functionality introduced in SQL Server 2012. Microsoft has been putting tremendous effort into changing the game of Business Intelligence, wrenching it from the clutches of data analyst / report creator / SQL guru (think PerformancePoint 2007, SQL Server Reports, SQL analysis and integration services) and making it accessible for the savvy business user. How Did We Get Here? And What’s Power BI? “Bring the power of data to every user in your organization” In your Office 365 Message Center, you might have seen this message on the right. Honestly I believe it’s for the better, but there are a few things that still haven’t come to fruition. 
I’ve been wondering when this would happen for quite a while now, and its finally happened. It had a good run, but Microsoft is finally killing off the initial iteration of Power BI to let its new service move in and run the show. As it happens with Microsoft products, there are two competing versions of the same thing and eventually one gets phased out.
0 kommentar(er)
