|
|
|
Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
webmaster@sqlservercentral.com.
Contact the author
All Blogs
Feeds
Archives
for this blog
I’ve created a series of five tutorial videos for a set of workshops I’ll be doing at several events this year. The workshop is available from an hour-long quick demo to a full-day, hands-on workshop with a hosted lab environment in the cloud. The series teaches how to create a… Read more
Some exciting announcements were made today about the new Power BI cloud-based business analytics service. Today Power BI is an add-on service for Office 365 that requires an enterprise-level license – about $50 per user per month. Data transformation queries, data models and dashboard visualizations are all created using add-in… Read more
This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar fashion. The multidimensional design experience is different but the mechanics of the SSAS engine are essentially the same. When loading data from a SQL Server data source into a Tabular… Read more
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular model projects were introduced in SQL Server 2012, one of the major blocking points for adaption has been the lack of out-of-the-box support for many-to-many relationships. I’ve been using, demonstrating… Read more
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular model projects were introduced in SQL Server 2012, one of the major blocking points for adaption has been the lack of out-of-the-box support for many-to-many relationships. I’ve been using, demonstrating… Read more
This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer. What is it and why is it important? The most significant thing about it is that report and dashboard users do not need to have Excel 2013 ProPlus edition or an Office 365 subscription to… Read more
Can an SSRS report be designed to drill-through to an Excel workbook in-context (showing only the same filtered detail data)? I have to admit that I have been chasing this solution for a few years now before I was motivated enough to work it through to a viable result. More… Read more
Please join my associates and I for an all-day SQL Server Upgrade workshop on November 3rd
If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop.
Join John Martin, Sr. Technology Evangelist from Microsoft, will spend the morning… Read more
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… Read more
Thank you to the Microsoft MVP Program for awarding me MVP for six years running! I love this program and look forward to another year of great community events and opportunities to advise and mentor. This year I had the privilege to speak at numerous SQL Saturdays, conferences and user… Read more
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… Read more
I just received some bad news and found out that a friend passed away today. Reed Jacobson was one of the early leaders in the Microsoft Business Intelligence community. Somewhere around 2004-2008 I worked with Reed at Hitachi Consulting in Seattle where we travelled, taught classes and worked on client… Read more
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?… Read more
I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger. The tool allows you to navigate through the metadata for a tabular model and select from measures and table attributes to build a simple query which is executed and timed. The query can be… Read more
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This is a big question that can’t easily be answered without understanding the variables of scale, complexity, user and business requirements. My knee jerk reaction to a question like this is… Read more
Watch below for live updates during the conference Stay tuned and you’ll find out what’s going on during this week in San Jose. I’ll be blogging from the conference as announcements are made and as the rest of the community buzzes about new developments in the community and here at… Read more
As I continue to explore the many facets of DAX functions, I’m finding more creative ways to add business value and simplify user experiences. In this post, I will demonstrate how to use slicers to pass values into a calculated measure in an SSAS Tabular model to dynamically change the… Read more
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The use of rectangles is very much a core part of Reporting Services report design and a difference in behavior is expected. Cells in a tablix will grow vertically to accommodate… Read more
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The use of rectangles is very much a core part of Reporting Services report design and a difference in behavior is expected. Cells in a tablix will grow vertically to accommodate… Read more
What I’m going to show you is not rocket science. This one gets filed under the category of “well, duh. That was easy …now that I see how to do it.” Power View sets the maximum value for a chart series based on the maximum unfiltered axis value; pretty simple… Read more
Older posts
|
Subscribe to this blog
