This Week In Data – Episode 6 (Why Companies are Choosing Power BI)

TWID-Blog-Header.jpg

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re going to discuss the top reasons why companies are adopting Power BI.

Power BI is a cool tool that allows users to pull data from a variety of sources and visualize the data in many different ways.  Based in the cloud, Power BI allows you to easily share data with others. It is different from other BI tools because of its ease-of-use, as well as how you can quickly design and build reports.  In this episode, Adam and Devin will give you their top reasons why your company should consider using Power BI.

Adam and Devin also discuss Uber’s self-driving cars, Microsoft’s release of Minecraft in Oculus Rift and how Super Mario Brothers got into Excel. Learn more about these topics in our latest episode:

Youtube_2013_icon.pngSubscribe on YouTube

SoundCloud.pngSubscribe on SoundCloud

iTunes-iOS-7-logo.pngSubscribe on iTunes

Power BI Custom Visuals Class (Module 18 – Stream Graph)

Stream Graph_thumb[4]

In this module you will learn how to use the Stream Graph chart Power BI Custom Visual.  The Stream Graph is similar to a Stacked Area Chart but has more of a fluid look and feel to it. You’ll find this visual often useful when displaying data across time.

Module 18 – Stream Graph

Downloads

Key Takeaways

  • Works and looks similar to a Stacked Area Chart but with a wiggle feature that gives it a more fluid look and feel
  • Great for displaying data that changes over time

image

This shows a Stream Graph with a multiple series values, which are separated out by color.

  • Under the Format paintbrush there are quite a few customizations that can be made to the appearance of the Stream Graph.
  • First under the General section of the Stream Graph you will find a property called Wiggle. This property is turned on by default but turning it off makes

image

image

This shows the what the Stream Graph looks like with the Wiggle property turned off.

  • Using the X-Axis or Y-Axis properties you can turn on or off the ability to display a title on these areas of the graph or change the color as well.

imageimage

  • Under the Legend section you can change the Position, Color and Text size of the legend.  You are also able to add a title and customize the title text.

image

  • Turning on the Data Labels property places a label on every data point on the graph. Once data labels are turned on you can change their color and text size. I have found that using these can sometimes be a little overwhelming.

image

  • In addition to these properties you have a set of settings that appears on every visual to adjust the background color, add a border around the visual and lock the aspect ratio.

Find Out More

You will always be able to find this video module and advanced viewing of future modules on the Pragmatic Works On Demand Training platform.  Click here to learn more about this training platform that includes 25+ courses.

Catch up on all the Power BI Custom Visuals blog posts here.

This Week In Data – Episode 5 (Data Visualization Best Practices)

TWID-Blog-Header.jpg

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re discussing some data visualization best practices

Data visualization is a hot topic right now, particularly because of the capabilities of Power BI and the release of SSRS 2016 Mobile Reports. Your data is an important asset that is often haphazardly thrown on a report. Using data visualization practices is a bit of an art form that when done correctly can more effectively communicate your most important asset to your business. In this episode, Adam and Devin discuss how to get started in your design, how much information to include in your reports, and things you should avoid when building your reports. We’ll give you a hint on what to avoid – say goodbye to pie charts.

Adam and Devin also discuss Thursday Night Football on Twitter, how Microsoft is currently beating Facebook and how the new game Bad Piggies is all about science. Learn more about these topics in our latest episode:

Youtube_2013_icon.pngSubscribe on YouTube

SoundCloud.pngSubscribe on SoundCloud

iTunes-iOS-7-logo.pngSubscribe on iTunes

Power BI Custom Visuals Class (Module 17 – Sunburst)

Sunburst_thumb[3]

In this module you will learn how to use the Sunburst chart Power BI Custom Visual.  The Sunburst chart is similar to the standard donut chart but allows you to show multiple level at once, which is great when presenting hierarchical data.

Module 17 – Sunburst

Downloads

Key Takeaways

  • Works like a Multilevel donut chart.
  • Used for showing hierarchical data.

image

This shows a Sunburst chart with a hierarchy of Group, Country and Region displayed by quantity sold.

  • Under the Format paintbrush there isn’t much available to customize the appearance of the Sunburst chart.
  • The one section specific to the Sunburst that you have available is found under the Group section.
    • By changing the Show Selected property you are able to turn on or off the label that appears in the middle of the chart when you select a slice of the Sunburst chart. This property is turned on by default.

image

image

This shows a Sunburst chart with the Show Selected property turned on. The text United States in the middle of the chart is an example of how this property displays.

  • In addition to these properties you have a set of settings that appears on every visual to adjust the background color, add a border around the visual and lock the aspect ratio.

Find Out More

You will always be able to find this video module and advanced viewing of future modules on the Pragmatic Works On Demand Training platform.  Click here to learn more about this training platform that includes 25+ courses.

Catch up on all the Power BI Custom Visuals blog posts here.

Power BI Custom Visuals Class (Module 16 – Bubble)

Bubble

In this module you will learn how to use the Bubble chart Power BI Custom Visual.  The Bubble chart allows you to show the value of categories proportionally represented by the size of the bubble.

Module 16 – Bubble

Downloads

Key Takeaways

  • 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

image

This shows a Bubble chart with Genre as the category and the size of the bubbles representing the revenue they have earned.

  • Under the Format paintbrush there isn’t much available to customize the appearance of the Bubble chart.
  • The one section specific to the Bubble that you have available is found under the Label section.
    • By changing the Fill property you are able change the color of of the text shown inside of each bubble

image

  • In addition to these properties you have a set of settings that appears on every visual to adjust the background color, add a border around the visual and lock the aspect ratio.

Find Out More

You will always be able to find this video module and advanced viewing of future modules on the Pragmatic Works On Demand Training platform.  Click here to learn more about this training platform that includes 20+ courses.

Catch up on all the Power BI Custom Visuals blog posts here.

This Week In Data – Episode 4 (What is Slack?)

TWID-Blog-Header.jpg

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re discussing how Slack can improve your company’s internal communication.

Over the past year, the Pragmatic Works team has been successfully using Slack for internal communications. As we all know, our email inboxes have become increasing cluttered and it can be difficult to take notice of important news and updates from your company. Slack’s goal is to end email and allow you to easily communicate with your coworkers. Adam and Devin talk about Slack’s enhanced capabilities, how Pragmatic Works uses it to gain feedback and much more!

Adam and Devin also discuss increased confidence in the cloud, how analytics are being used in politics and the dreaded removal of the headphone jack from the new iPhone. Learn more about these topics in our latest episode:

Youtube_2013_icon.pngSubscribe on YouTube

SoundCloud.pngSubscribe on SoundCloud

iTunes-iOS-7-logo.pngSubscribe on iTunes

This Week in Data – Episode 3 (What is the Internet of Things (IoT)?)

TWID-Blog-Header.jpg

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re answering the question, “What is the Internet of Things?”

Most of you have probably been hearing about Internet of Things (IoT) and are curious as to what it is. In short, Internet of Things is the thought that anything with power can be put on the internet. Fitbit is a great example of IoT but you probably want to know how IoT relates to your business. Adam and Devin discuss the importance of IoT, how it’s evolving and how you can use it in your business environment.

Before we talk about IoT, Adam and Devin also discuss several updates from Microsoft such as updated security in Azure, the first cumulative update for SQL Server 2016 and where Gartner ranks Azure in the world of cloud. Learn more about these topics in our latest episode:

Youtube_2013_icon.pngSubscribe on YouTube

SoundCloud.pngSubscribe on SoundCloud

iTunes-iOS-7-logo.pngSubscribe on iTunes