In my previous post, we explored the Radar Chart visual. In this module you will learn how to use the KPI Indicator (This is kind of like saying “ATM Machine” isn’t it?) Power BI comes standard with a KPI visual but the custom visual we will cover in this post shows a few more options than is available in the standard tool. Using the KPI Indicator allows you to not only visualize key performance indicators but also include a historical trend line or bar chart with it.
Category: Power Bi117 Results
In my previous post, we explored the Hebxbin Scatterplot visual. In this module, you will learn how to use the Radar Chart - another Power BI Custom Visual. The Radar Chart is sometimes also know to some as a web chart, spider chart or star chart. Using the Radar Chart allows you to display multiple categories of data on each spoke (like spokes on a bicycle wheel) of the chart. The Radar Chart does support the display of multiple metrics, which allows you to compare and contrast the “pull” that each category has on your metrics.
In part one of my Power BI Custom Visuals blog series, I showed you all the fun you can have with the Enlighten Aquarium visual. In this module, you will learn how to use the Hexbin Scatterplot Power BI Custom Visual. The Hexbin Scatterplot is a variation of the traditional Scatter Chart but instead of using bubble size it relies on color saturation and hexbins to show value distribution. You should consider using this chart when you’re more interested in visualizing density instead of individuals points themselves.
Welcome to an exciting new FREE class on Power BI Custom Visuals! Over the next year (that’s right year), I will be releasing one module a week detailing how to work with all of the Power BI visuals available in the Custom Visuals Gallery. You might ask why am I doing this? Well The Microsoft Power BI team and the Power BI Community, through the Custom Visuals Gallery, have expanded the data visualization capabilities of Power BI drastically but have provided little direction on how to use these the new features.
Welcome to an exciting new FREE class that I am launching today! Over the next year (that’s right year!) I will be releasing one module a week detailing how to work with all of the Power BI visuals available in the Custom Visuals Gallery. You might ask why am I doing this? Well The Microsoft Power BI team and the Power BI Community, through the Custom Visuals Gallery, have expanded the data visualization capabilities of Power BI drastically but unfortunately has provided little and in some cases no direction on how to use these the new features. Click here to view all the blogs and videos I have published about Power BI Custom Visuals.
In my previous blog post, I shared my initial experience with using Power BI to analyze some transaction trends by customer type. I fully anticipated building upon this solution based off of new questions that arose as I explored the transaction data. That plan has been temporarily delayed since a new analytical challenge was brought up by one of my peers who asked to see a breakdown of revenue by state over a period of time. This new question presented me with an opportunity to use a new visual type in Power BI Desktop, a filled map and slicers. I’m sure I’ll have the chance to get back to expanding the Transaction Size BI Solution, but for now I’m diving into this geography based solution. This kind of redirection or change in reporting priorities is probably very familiar to most data professionals.
This post reviews some of the tips and techniques that I covered in my webinar Performance Techniques for Power BI Data Models. To save blog space I have highlighted the first 5 tips from the presentation. There are more tips and techniques, along with expanded explanations and references in the presentation slides.
I am a sales professional - not a formally educated data professional. (I swear!!)
With that being said, my primary focus, here at Pragmatic Works, is to assist my team in generating top-line revenue. In my role, I need to make critical decisions that ensures our sales organization is set up for success – and, ideally, these decisions are supported by data. Fortunately, Pragmatic Works specializes in helping organizations leverage their data to make more informed, intelligent business decisions. To my benefit, I have access to some amazing training resources (the Pragmatic Works Power BI Desktop and Dashboards On-Demand class taught me everything I needed to get started) and talented B.I. professionals that work with data for a living. A virtual thank you to Devin Knight and the Pragmatic Works Virtual Mentoring Team for being available to help me work through this small project!
**Information is current as of 5/21/2015**
Recently Azure SQL Database was added as a new connection to the Power BI Preview. Read the notes about how it can be used here. The things I found especially worth noting were:
In this tutorial, I will show you how to pull data into Excel using Power Query and then put together a simple report with Power View. While you can get rather elaborate with these tools, this tutorial will begin with a simple focus. I am going to create a report that displays sales amounts from different countries over a period years.
Need help with this topic? Ask the author below.