SQL Server Pro Magazine: Datazen Mobile Dashboards with Analysis Services and Drill-through
This post is a teaser for an article I just published to SQL Server Pro Magazine. This is the third…
Category: BI Projects
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…
Datazen Visual Control Categories
Choosing the right visualization control for a set of data can sometimes be challenging. I find some aspects of designing…
Power BI General Availability Announced: July 24, 2015
On Friday, James Phillips, Microsoft VP of Business Intelligence, announced the general availability of the new Power BI Business Analytics…
BI Industry, BI Projects, DataZen, SQL Server, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia
Online Training event: Designing a Mobile Dashboard Solution with Microsoft DataZen
I’d like to make you aware of a three-hour training event that I will be presenting, hosted by SQL Server…
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”.
Articles, BI Industry, BI Projects, SolidQ, SQL Server Pro Magazine, SSAS Administration, SSAS Design, Tabular Models
SSAS Tabular Modeling Article Series on SQL Server Pro Magazine
I’ve just finished a series of four articles for SQL Server Pro Magazine, along with sample projects and hands-on exercises. The series will take you through SSAS Tabular model design from start to finish, using the Adventure Works sample data in SQL Server 2012 or 2014. Here are links to all four articles followed by an excerpt from each.
Part 1 – Getting Started with SSAS Tabular
Part 2 – Easy DAX – Getting Started with Data Analysis Expressions
Part 3 – Tabular Model Administration
Part 4 – Deep Dive DAX – Solving Complex Business Problems with Data Analysis Expressions
Download the sample projects here: Part 1, Part 2, Part 3, Part 4
Glossary of Terms Used in Microsoft BI Projects
At the beginning of many new BI projects it can be challenging to get everyone using common terminology and language. …
How to resolve connection errors when loading data in SSAS Tabular project
This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar…
BI Industry, BI Projects, Business Analytics, Power BI, PowerPivot, Self-service BI, SQL Syndication, SQLServerPedia, Tabular Models
Power BI Semantic Model Supports Many-to-Many Relationships
Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular…
BI Industry, BI Projects, Business Analytics, DAX, Microsoft BI Platform, Power BI, PowerPivot, Self-service BI, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia, Tabular Models
Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table
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…
BI Industry, BI Projects, Business Analytics, Microsoft BI Platform, MVP Community, PASS, SolidQ, SQL Saturday, SQL Server, SQL Server Pro Magazine, SQL Syndication, SQLServerPedia
SQL Server MVP for a Sixth Year
Thank you to the Microsoft MVP Program for awarding me MVP for six years running! I love this program and…
Business Intelligence Roles and Team Composition
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…
What Does it Cost to Implement a Business Intelligence Project?
Someone recently asked me through LinkedIn how much it would cost to implement a BI project with Microsoft tools. This…