Paul Turley's SQL Server BI Blog
sharing my experiences with the Microsoft data platform, Fabric, enterprise Power BI, SQL Server BI, Data Modeling, SSAS Design, SSRS, Dashboards & Visualization since 2009
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular…
This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer. What is it and why…
Requirement: Allow users to enter comments after they review results from a Power Pivot model and then show the comment text in the Pivot Table report results. Here’s a quick example of the final result. My example uses Flintstones characters in-place of employee or customer names and a simple measure value. After reviewing the results, the user moves to another worksheet and enters a comment for the date and person with an expiration date for the comment. After refreshing the report, each cell with a comment is indicated with a little “dog ear” and the comment is displayed by clicking the cell…
The other day a secondary family member said “we’re still on Microsoft 2010”. Another said “My friend is using Windows 2003 and can’t open a document I sent”. They were apparently talking about versions of Office products.
I get so deeply engrained in the Microsoft Business Intelligence community culture that I have to remind myself that most people don’t spend all their time keeping up with these products that are constantly in motion. And these are just Office users! When I work with BI consulting clients and business folks in the industry, it’s apparent that most people really don’t understand where these products and services begin and end.
Mark Tabladillo has done the world a service by laying out exactly what Power BI is, the products that it includes, and how to license it and get started. This is a great resource on the Microsoft MVP Program Blog that breaks it all down and helps it all make sense. Thank you, Mark!
Here’s a sample
On Business Intelligence projects of all sizes, the composition of the team is a crucial element for success. What is the organization of a functional BI team? How do the individual roles and disciplines contribute to a successful outcome? How is team composition different for self-service and business-owned BI projects? The best answer for an organization will depend on several factors including corporate culture, communication and management styles…
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week…
If you’re attending the PASS Business Analytics Conference in San Jose, please join us on Friday morning for a special…