Paul Turley's SQL Server BI Blog
sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009
As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. …
I’m working on a series of articles about creating enterprise solutions with Power BI and the first article was published…
The DAX function documentation in MSDN can be found on separate pages, organized by function categories and then details for…
Please join me at the PASS Global Summit in Seattle for a half-day, 3-hour hands-on Power BI mini workshop. Bring…
This post is really a collection of field notes and some lessons learned from recent project experience. I’ve done plenty of SSAS Tabular projects over the past few years – usually starting with a Visual Studio project rather than Power Pivot. I’ve also done a bit of Power Pivot work for clients. These projects were either delivered to an analyst using Excel on their desktop or some business users through SharePoint. But, authoring in Excel Power Pivot and deploying to a server-hosted Tabular model has been mainly theoretical up to this point so I thought I’d share my experience.
I’ve recently seen a wave of questions from clients and peers about difficulties exporting reports to Excel lately. Every few weeks I get a call or question about this. This topic has been a recurring theme for a very long time and one that I have encountered many times over the past – oh, eleven years or more – using SSRS. Business users like Excel because it’s what they know and they can reformat and manipulate data in a workbook. People like Reporting Services because all the hard work of connecting to data sources, writing queries, totaling, grouping and formatting the results gets done once and then all they need to do is run the report. Users want the best of both worlds and they expect that when they export and report to Excel that they should have their cake and eat it. In other words; they should be able to get a report, with all the goodness of headers, scrolling regions, pagination, interactive sorting – you name it – to work exactly the same way in Excel.
I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this…
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular…
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
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week…
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value…
This series of video sessions will demonstrate how to create a business intelligence solution with sets of business data from…
by Paul te Braak, from Packt Publishing on Amazon Good technology books usually come in one of two forms. Some…
What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. …