Power BI Training Resources (Free)

Power BI Training?  My most common request, by far, is for training resources for Power BI.  There have been some posts I have used to acquire more/better/different options for learning Power BI but I have accumulated, filtered out, and singled out the best resources below.  I will add/modify periodically as new resources are added and … Read more

Microsoft Business Intelligence Roadmap Enhancements

An overview to the top Microsoft Business Intelligence Roadmap Enhancements announced thus far for Power BI Services and Mobile, Microsoft Excel 2016, SQL Server Reporting Services 2016, and SQL Server Analysis Services 2014-2016. I will not be the first to say this (I will be added to a long list of others), but SQL 2014 … Read more

AdventureWorks Power BI Visualization Samples

Power BI conducted a best visuals contest during the month of September.  Now, they have added a large portion of those visuals to a community gallery and added the ability to download and import those into the Power BI online services or Power BI Desktop. Click here to see our article on people’s choice awards and … Read more

Power BI Visual Contest

Power BI conducted a best visuals contest (http://community.powerbi.com/t5/Best-Visual-Contest/con-p/best_visual_contest) during the month of September.  There were around thirty entries in the contest.  It was impressive to say the least. Winners were announced on October 8th, 2015 and included three people’s choice awards, a third place winner, a second place winner, and a grand prize winner: 1st People’s … Read more

Power BI Lost Features & Functionality Tracking

With the most recent release of Power BI Desktop / Services and removal of dependencies on Excel, we have lost several features and functionality.  However, the gains and improvements far outweigh the losses.  We gained funnel charts, gauges, donut charts, filled maps, treemaps, waterfall charts, dual axis line and column charts, area charts, custom titles, custom … Read more

How to Profile SQL Server Data Using Power BI

With the announcement of General Availability for Power BI 2.0, Microsoft made BI to the masses possible. There were some steps back (chart/map drill down, tile slicers, etc.) but many more steps forward. They removed the reliance on Excel, added formatting options, new visualizations, and more. With the new release, we wanted to create a … Read more

Twitter Account Created – @powrdax

We now have a Twitter social media presence!   @powrdax on Twitter @powerdax was not available!  We Our hope is that we will be able to keep everyone more up to date with Twitter than with articles.  I have such a backlog of articles to share but not very much time to author them.  Twitter … Read more

Power View for Power Pivot / Tabular Data Models

Power Pivot or SSAS Tabular data model optimization is important for Power View reporting usability and functionality. In this posting, we will discuss the following topics: X-Axis Guidelines Advanced Properties Image Handling Data Categories Table Behavior Field Behavior   X-Axis Guidelines Data type and distribution Utilize a number or date that increases uniformly (primarily for … Read more

Power View Data Model Optimization

Before a Power View report can be built, you have to have a data model built as a data source.  There are several configuration options to help optimize your data model specifically for Power View.  These configurations and/or optimizations are made within your Power Pivot model or in SQL Server Data Tools on the SSAS … Read more