Reporting Services 2016, Power BI and PASS Summit 2016
What am I most excited about as I prepare for the PASS Summit here in Seattle this week? A lot…
Category: Self-service BI
Power BI Dashboard In A Day Training in Richmond and Pittsburgh
I’m pleased to announce that I will be presenting two more Dashboard-In-A-Day training sessions in October. These free, full day…
BI Industry, Business Analytics, Microsoft BI Platform, Power BI, Power View, Self-service BI, SolidQ, SQL Server Pro Magazine, SQL Syndication
Happy Birthday Power BI
Today marks the first anniversary of Power BI Desktop and the Power BI Service. The effort to achieve this milestone…
BI Industry, Business Analytics, Microsoft BI Platform, MVP Community, Power BI, Self-service BI, SolidQ, SQL Server, SQL Syndication, SQLServerPedia, SSAS Administration, SSAS Design, Tabular Models
Using Power BI with Enterprise, On-premises Data
I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data. The running time for…
Color Themes for Power BI
Color coordination is important in report and dashboard design. We’ve seen theming and color pallet options in the prior iteration…
Power BI Workshops – Dates and Locations
The Hands-On Power BI Workshop has been a great success and and a good opportunity to learn this technology first-hand. …
BI Industry, BI Projects, Business Analytics, Microsoft BI Platform, Power BI, Self-service BI, SQL Syndication, SQLServerPedia, SSAS Design, Tabular Models
Tabular Models, Multiple Data Sources and Unknown Members
Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from…
Power BI Hands-on Workshops
Chicago – full-day: March 4, 2016 San Jose, CA – 2 hour session at the PASS BAC, May 3-4, 2016…
BI Industry, BI Projects, Business Analytics, Power BI, Self-service BI, SQL Server, SQL Syndication, SQLServerPedia, SSRS Design
The Resurrection of Reporting Services & The Maturing of Power BI
Spending the past two weeks at the annual PASS Global Summit and the Microsoft MVP Summit, I’ve consumed a literal…
BI Industry, BI Projects, Data Visualization, Excel BI, Power BI, Self-service BI, SolidQ, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia
Are you Ready to Use Power BI?
What! NO? Get with it, my friend. Power BI is for everyone. All the kids are doing it… not to…
BI Industry, BI Projects, Excel BI, PowerPivot, Self-service BI, SQL Syndication, SQLServerPedia, SSAS Administration, Tabular Models
Maintaining Parallel Power Pivot and SSAS Tabular Models–Tales from the Trenches
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.
Articles, BI Industry, BI Projects, Business Analytics, DataZen, Microsoft BI Platform, Self-service BI, SolidQ, SQL Server, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia
Microsoft DataZen Mobile Platform Available to SQL Server Enterprise Customers for Free
Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite. This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio. What’s more, is that they plan to make if free for SQL Server Enterprise customers who have Software Assurance agreements.
Watch for a series of articles about getting started with DataZen in SQL Server Pro Magazine online.
I presented a session at the PASS Global Summit in 2013 showcasing DataZen called “New York, London, Paris Munich; Everybody’s Talking About Mobile BI”.
BI Industry, Excel BI, Microsoft BI Platform, PowerPivot, Self-service BI, SSRS Administration, SSRS Design
How to Get SSRS Reports in Excel Without Exporting from Reporting Services
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.
Data Visualization, Microsoft BI Platform, Self-service BI, SQL Server Pro Magazine, SQL Syndication
Microsoft DataZen Mobile Platform Available to Enterprise Customers for Free
Last week Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite. This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio. What’s more, is that they plan to make if free for SQL Server Enterprise customers who have Software Assurance agreements.
I presented a session at the PASS Global Summit in 2013 showcasing DataZen called “New York, London, Paris Munich; Everybody’s Talking About Mobile BI”.
Data Visualization, Microsoft BI Platform, Power BI, Power View, PowerPivot, Self-service BI, SQL Syndication, SQLServerPedia
Power BI Workshop Videos
I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this…