A Fine Slice Of SQL Server
Devin Knight continues his custom visuals series with the bubble chart:
Each category is defined as a bubble on the visual.
The size of the bubble is defined by a measure.
The Bubble chart does allow for cross filtering. Meaning you can click on a bubble in the chart and it will filter other report items
This is a nice eye-catcher image, like you might see in a news article.
Comments closedReza Rad shows how to tell a data story using a combination of Powerpoint and Power BI:
You can see here that I’ve added a title for this slide in Power Point, and also a Textbox with text “Psychology has the most sales”. Yes, with this method you can add commentary to Power BI reports and dashboards, you can tell the story behind the data with integration of Power BI and Power Point. very simple feature but really useful.
Under each Power BI tile in Power Point there will be a link to Power BI
Read the whole thing.
Comments closedJustin Kestelyn describes the Impala Connector for Power BI Desktop:
Note that the connector currently only supports Import mode, which requires downloading the query output data to the local data model. In future updates, we will enhance the connector with DirectQuery capabilities, as well as with support for refresh scenarios via the Power BI Gateway. [Ed. Note: As of the August 2016 update, the Impala Connector also supports DirectQuery mode, which means you are always viewing the most up-to-date data. The functionality for both periodic refreshes and DirectQuery mode require the Power BI Gateway running either on-premise or in Microsoft Azure.]
Enabling Power BI connectivity to Impala has been a very frequently requested capability from our customers. We encourage you to give it a try and share with us any feedback or issues that you encounter via the “Send a Frown” feature in Power BI Desktop.
Good stuff.
Comments closedDevin Knight continues his Power BI custom visuals series:
In the Table Heatmap the color of the boxes is determined by the value in your measure.
Only 1 category field can be used, which will dynamically generate the number of columns based on the number of distinct values your field has.
The number and types of colors can be changed using some of the settings we’ll discuss below.
I can see the table heatmap being a good visual for calendars.
Comments closedMany of the functionality people associate with source control programs live inside the group one drive which is created for Power BI. Looking at the picture of the group screen, which was created when a Power BI Workspace was created, you will see that this group contains 7 members and four files. The members of this groups are the only ones who have access to the files. The file AcmeThree.pbix is selected, and cClicking on the elipise (…) brings up a menu for the file. Notice one of them is Check Out. If I check out a file, the icon next to the name changes, providing a visual queue to all who wish to edit the file that it is being working on. The menu option for me would change to Check In, providing the ability to check the file in to the directory, allowing others to check out the file and work on it. Notice Version History also exists. This feature allows previous versions of the file to be loaded, which means that changes made to a file can be rolled back.
It’s good that this is available, and I’d make use of it. For Power BI Desktop, it seems prudent to continue using source control.
Comments closedDevin Knight looks at the Tornado chart:
The Tornado has a few limitation that should be aware of before using
If there’s a legend value it should only have 2 distinct values
Each distinct category values is a separate bar with left or right parts
Alternatively, you can have two measure values and compare them without a legend
I’m split on whether I like the tornado or not. It is intuitive and information-dense, which are two major factors in its favor. It is, however, difficult to read and compare. This seems like a useful “big picture” chart, but you’d want to organize the data in a different way when you start drilling down.
Comments closedReza Rad digs into line charts:
Value Line
Line chart can show one or more measures as measures, such as Sales Amount, Total Costs, Quantity of the goods sold and etc.
Trend Line
Depends on the variety of values across a time period, Line chart can illustrate a straight line as a trend. This trend is good to understand how in overall products are selling, is revenue going up or down for example.
Reference Line
You might want to define minimum, maximum, average, or median values for your line chart as separate lines, and compare values lines with these lines. These are reference lines which can be dynamically created based on value of measures in the chart.
I think this was a rather helpful post in figuring out what Power BI is capable of doing, although if you build a lot of charts that look like Reza’s last example, you probably want to scale that back a bit.
Comments closedDavid Smith points out some of the work the Power BI team has done to integrate R into their product:
Power BI, Microsoft’s data visualization and reporting platform, has made great strides in the past year integrating the R language. This Computerworld article describes the recent advances with Power BI and R. In short, you can:
import data into Power BI by using an R script
cleanse and transform other data sources coming into Power BI using R functions
create custom charts in a Power BI dashboard using the R language, like these maps
Click through for more things you can do, as well as additional links and resources.
Comments closedReza Rad shows how to get the last item in each group using Power Query:
Scenario that I want to solve as an example is this:
FactInternetSales has sales transaction information for each customer, by each product, each order date and some other information. We want to have a grouped table by customer, which has the number of sales transaction by each customer, total sales amount for that customer, the first and the last sales amount for that customer. First and last defined by the first and last order date for the transaction.
In T-SQL, this sounds like the job of window functions. In Power BI, we write M.
Comments closedAdam Saxton has a video on how to use Power BI Auditing:
In this video, I look at the Power BI Auditing feature that was made available a few weeks ago. I show how to turn it on and how to search. This can be helpful with understanding who is doing what within your organization.
You can read more about Power BI Auditing by checking out the official docs.
Adding the ability to audit data access is important enough within regulated environments that this was probably a deal-killer until a few weeks ago.
Comments closed