<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by David Eldersveld on Medium]]></title>
        <description><![CDATA[Stories by David Eldersveld on Medium]]></description>
        <link>https://medium.com/@dataveld?source=rss-34a29a35687------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*Q3-fTSLRO5hdUou3.png</url>
            <title>Stories by David Eldersveld on Medium</title>
            <link>https://medium.com/@dataveld?source=rss-34a29a35687------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 03:54:46 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@dataveld/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Jupyter as an External Tool for Power BI Desktop (Python Part 4) — DataVeld]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@dataveld/jupyter-as-an-external-tool-for-power-bi-desktop-python-part-4-dataveld-852bebd50a93?source=rss-34a29a35687------2"><img src="https://cdn-images-1.medium.com/max/1705/0*oS3i_FUVa4kMJF29" width="1705"></a></p><p class="medium-feed-snippet">Many people use Python with notebooks, so let&#x2019;s take a look at one possible way to enable a Jupyter external tool for Power BI Desktop&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@dataveld/jupyter-as-an-external-tool-for-power-bi-desktop-python-part-4-dataveld-852bebd50a93?source=rss-34a29a35687------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@dataveld/jupyter-as-an-external-tool-for-power-bi-desktop-python-part-4-dataveld-852bebd50a93?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/852bebd50a93</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[jupyter-notebook]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Mon, 17 Aug 2020 04:32:44 GMT</pubDate>
            <atom:updated>2020-08-17T05:02:43.338Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Python as an “External Tool” for Power BI Desktop: Part 1 — DataVeld]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@dataveld/python-as-an-external-tool-for-power-bi-desktop-part-1-dataveld-1d1ec251edde?source=rss-34a29a35687------2"><img src="https://cdn-images-1.medium.com/max/1326/0*Yys34EYv3R1VZ2_J" width="1326"></a></p><p class="medium-feed-snippet">The July 2020 version of Power BI Desktop includes a new preview feature that allows &#x201C; external tools &#x201C; to more easily connect to Power BI&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@dataveld/python-as-an-external-tool-for-power-bi-desktop-part-1-dataveld-1d1ec251edde?source=rss-34a29a35687------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@dataveld/python-as-an-external-tool-for-power-bi-desktop-part-1-dataveld-1d1ec251edde?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/1d1ec251edde</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[python]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Tue, 21 Jul 2020 00:15:56 GMT</pubDate>
            <atom:updated>2020-08-02T14:19:10.964Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Power BI Risk Assessment: External Tools, Connectors, and Community Visuals — DataVeld]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@dataveld/power-bi-risk-assessment-external-tools-connectors-and-community-visuals-dataveld-62b0463eba7f?source=rss-34a29a35687------2"><img src="https://cdn-images-1.medium.com/max/737/0*lthmJMicOPp233hu" width="737"></a></p><p class="medium-feed-snippet">An abundance of quality, partner-built or community created add-ons is often the sign of a healthy software platform. While it signals&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@dataveld/power-bi-risk-assessment-external-tools-connectors-and-community-visuals-dataveld-62b0463eba7f?source=rss-34a29a35687------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@dataveld/power-bi-risk-assessment-external-tools-connectors-and-community-visuals-dataveld-62b0463eba7f?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/62b0463eba7f</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[risk-management]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Sat, 04 Jul 2020 16:42:41 GMT</pubDate>
            <atom:updated>2020-08-02T14:24:37.742Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Four Core Differences Between the Tableau and Power BI Data Models — DataVeld]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@dataveld/four-core-differences-between-the-tableau-and-power-bi-data-models-dataveld-7a8582c3bfd6?source=rss-34a29a35687------2"><img src="https://cdn-images-1.medium.com/max/777/0*EcsqetttUeQJ5kf1" width="777"></a></p><p class="medium-feed-snippet">Tableau recently released a logical data model in version 2020.2, while a similar semantic layer has been core to Microsoft Power BI since&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@dataveld/four-core-differences-between-the-tableau-and-power-bi-data-models-dataveld-7a8582c3bfd6?source=rss-34a29a35687------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@dataveld/four-core-differences-between-the-tableau-and-power-bi-data-models-dataveld-7a8582c3bfd6?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/7a8582c3bfd6</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[tableau]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-modeling]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Thu, 18 Jun 2020 05:34:54 GMT</pubDate>
            <atom:updated>2020-08-02T14:27:53.549Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Configuring Postman for Use with the Power BI REST API — DataVeld]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@dataveld/configuring-postman-for-use-with-the-power-bi-rest-api-dataveld-935a8d1b944?source=rss-34a29a35687------2"><img src="https://cdn-images-1.medium.com/max/876/0*USLxpS-tzZZDPy0s" width="876"></a></p><p class="medium-feed-snippet">Postman is a valuable tool to work with APIs, especially when testing and making ad hoc requests outside of an automated production&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@dataveld/configuring-postman-for-use-with-the-power-bi-rest-api-dataveld-935a8d1b944?source=rss-34a29a35687------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@dataveld/configuring-postman-for-use-with-the-power-bi-rest-api-dataveld-935a8d1b944?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/935a8d1b944</guid>
            <category><![CDATA[postman]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Sun, 10 May 2020 03:57:46 GMT</pubDate>
            <atom:updated>2020-08-02T14:32:52.327Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[How To Obtain a Power BI Custom Visual If It No Longer Appears on AppSource — DataVeld]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@dataveld/how-to-obtain-a-power-bi-custom-visual-if-it-no-longer-appears-on-appsource-dataveld-f0d15cd5e43d?source=rss-34a29a35687------2"><img src="https://cdn-images-1.medium.com/max/600/0*WhJuRnG5y0la7JpV" width="600"></a></p><p class="medium-feed-snippet">AppSource is the digital marketplace where Microsoft makes many add-on resources available for a variety of products. This marketplace&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@dataveld/how-to-obtain-a-power-bi-custom-visual-if-it-no-longer-appears-on-appsource-dataveld-f0d15cd5e43d?source=rss-34a29a35687------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@dataveld/how-to-obtain-a-power-bi-custom-visual-if-it-no-longer-appears-on-appsource-dataveld-f0d15cd5e43d?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/f0d15cd5e43d</guid>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Sat, 11 Apr 2020 13:43:56 GMT</pubDate>
            <atom:updated>2020-08-02T14:34:03.452Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Data Color Reference for Power BI Themes (as of December 2019) — DataVeld]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@dataveld/data-color-reference-for-power-bi-themes-as-of-december-2019-dataveld-dd22bfb76aa0?source=rss-34a29a35687------2"><img src="https://cdn-images-1.medium.com/max/2000/0*w-eNLq8Wpv7LDnda" width="2000"></a></p><p class="medium-feed-snippet">Along with an updated Power BI Desktop ribbon, several additional report themes are now available. The Power BI docs provide a great&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@dataveld/data-color-reference-for-power-bi-themes-as-of-december-2019-dataveld-dd22bfb76aa0?source=rss-34a29a35687------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@dataveld/data-color-reference-for-power-bi-themes-as-of-december-2019-dataveld-dd22bfb76aa0?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/dd22bfb76aa0</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Tue, 31 Dec 2019 13:06:53 GMT</pubDate>
            <atom:updated>2020-08-02T14:35:24.802Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[3D Effect with Orthographic Projection in Power BI — DataVeld]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/@dataveld/3d-effect-with-orthographic-projection-in-power-bi-dataveld-c6c5166b2e0a?source=rss-34a29a35687------2"><img src="https://cdn-images-1.medium.com/max/2000/0*kIxZgrKZbS2iac9s" width="2000"></a></p><p class="medium-feed-snippet">Orthographic projection is a way to use two-dimensional space to represent three-dimensional objects. In Microsoft Power BI, this 3D&#x2026;</p><p class="medium-feed-link"><a href="https://medium.com/@dataveld/3d-effect-with-orthographic-projection-in-power-bi-dataveld-c6c5166b2e0a?source=rss-34a29a35687------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://medium.com/@dataveld/3d-effect-with-orthographic-projection-in-power-bi-dataveld-c6c5166b2e0a?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/c6c5166b2e0a</guid>
            <category><![CDATA[power-bi-tutorials]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Sat, 07 Sep 2019 15:18:52 GMT</pubDate>
            <atom:updated>2020-08-02T14:36:53.240Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[R Visuals in Power BI: Beyond Plots]]></title>
            <link>https://medium.com/@dataveld/r-visuals-in-power-bi-beyond-plots-74c618f2e6f3?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/74c618f2e6f3</guid>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[rstats]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Wed, 10 Feb 2016 02:28:36 GMT</pubDate>
            <atom:updated>2016-02-11T03:08:05.558Z</atom:updated>
            <content:encoded><![CDATA[<p>One of the advantages of having R in Power BI is that it opens up opportunities to move beyond the default charts without having to build a TypeScript/JavaScript custom visual. The R output is not as interactive as D3 can be, but it is quick to develop, the script is more transparent to users, and it can be shared easily. Recently, however, I have also been exploring how to take advantage of the R visual in Power BI Desktop for use beyond plotting, such as I/O.</p><p>When you first create the R visual, Power BI directs the input that you have added into a data frame called “dataset”. In the case of the screenshot below, I added two fields called “X” and “Y” from my Power BI dataset, and I can now use those two fields in my R script.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/299/0*FB4-hBEVXxa62KdW.png" /></figure><p>If I were to click “Run” at this point, Power BI would throw an error. Why? For its final R output, Power BI requires a plot–or at least an image of some type–and not a data frame. Without a plot, you will receive the following message stating that “no image was created”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/576/0*vO5-mihA1edWc75u.png" /></figure><p>With proper code that creates a plot as output, however, you can develop some great content using R. Ultimately though, having R also allows for more advanced scenarios besides simply generating plots. The following “Ship Sinker” prototype that I built in Power BI Desktop is a variation of a popular trademarked game. The <em>Selection History</em> chart as well as the <em>Hit Counter by Ship</em> are both generated using the ggplot2 package. Some people may object to the lack of an opponent, or having only one layout for the ships, but that’s probably due to their envy of my undefeated record and the fact that I usually hit a ship on every move. In any case, see the Power BI report in action in this video:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FYjbtoLFgL2A%3Ffeature%3Doembed&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DYjbtoLFgL2A&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FYjbtoLFgL2A%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/005f2d5b42485a18ee79040520fe68b3/href">https://medium.com/media/005f2d5b42485a18ee79040520fe68b3/href</a></iframe><p>It’s great to make some fairly poor-looking charts using the built-in R plot, ggplot2, plotrix, or some other library (at least, mine always end up looking fairly bad as well as inconsistent with other Power BI charts, but that reflects my still-growing level of expeRtise). What if you could do more with the R visual?</p><p>Perhaps I/O?</p><p>The two R charts in the prototype game are unique in that they not only display data relevant to the <em>current</em> user selection, but also their <em>historical</em> selections. It would not be Battleship <em>Ship Sinker</em> without the ability to keep track of coordinates that you have already guessed. In Power BI, tracking this history would normally create a problem because users do not have access to telemetry data as they click around. With R, the inability to retain prior user selections is no longer a problem. Note that in most cases, retaining this type of data is not necessary. In the case of a game like Battleship <em>Ship Sinker</em>, however, it is required (unless you have the ability to recall up to one hundred moves).</p><p><strong>Local File Input/Output</strong></p><p>What makes this plot of historical moves possible? Looking at the following R script, it takes advantage of R functions for <strong>write.table</strong> and <strong>read.table.</strong> Clicking on the report’s 10×10 scatterplot grid to make a move triggers the R visual to write the X &amp; Y coordinates as well as other data associated with the selection to a local text file. Because it is <em>appending</em> to the file, all historical selections are preserved. Reading from that same file then allows all of the historical selection data to be used in R. Since the final output is a plot of the selection history, Power BI does not give an error when the intermediary IO code is used.</p><pre>library(ggplot2)</pre><pre>#Local file path<br>filePath = &quot;C:/temp/PBIShipSinker.txt&quot;</pre><pre>#filter some unnecessary data (it&#39;s just a buggy prototype...)<br>dataset &lt;- subset(dataset, dataset$CurrentColor != &quot;#FFFFFF&quot;)</pre><pre>#write data associated with the current selection to the file path<br><strong>write.table</strong>(dataset, file = filePath, append = TRUE, sep = &quot;,&quot;, col.names = FALSE)</pre><pre>#read all historical data from the file path into a new data frame<br>df &lt;- tryCatch(<strong>read.table</strong>(file = filePath, sep = &quot;,&quot;), error=function(e) NULL)</pre><pre>#specify column names for the new data frame<br>colnames(df) &lt;- c(&quot;ID&quot;, &quot;SelectionXLabel&quot;, &quot;SelectionX&quot;, &quot;SelectionY&quot;, &quot;HitMiss&quot;, &quot;CurrentColor&quot;, &quot;ShipType&quot;)</pre><pre>#Use ggplot2 to create the Selection History plot<br>ggplot(df, aes(x = SelectionX, y = SelectionY, label = HitMiss)) + <br> geom_point(aes(colour = CurrentColor), size = 3) +<br> scale_colour_manual(values = c(&quot;#587ABC&quot;, &quot;#EE0000&quot;, &quot;#587ABC&quot;)) + <br> theme(legend.position=&quot;none&quot;, axis.ticks = element_blank()) +<br> geom_text(vjust = 2) + <br> xlim(1,10) + ylim(1,10) +<br> xlab(&quot;&quot;) + ylab(&quot;&quot;) + ggtitle(&quot;Selection History&quot;)</pre><p>After the code runs, the final plot displays all historical X &amp; Y coordinates as well as interprets some of the other data such as whether it was a hit or a miss. The second chart also takes advantage of this history by displaying what type of ship was hit.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*gkOCCOqN_ngoRcjc.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/643/0*BwbTJwvwBWH3CM6T.png" /></figure><p>Because it’s 1982, when you want to start a new game, simply delete the file on your local drive, or write additional R code to delete it. Wait…what?</p><p><strong>SQL Server Input/Output</strong></p><p>Local I/O is ultimately not a great option. What happens when R support comes to the Power BI service online, and you do not have access to your local file system? What if potential future multiplayer support will not involve physically passing your computer to another person? Everything is okay. The same logic can be applied for connections to SQL Server or other databases.</p><p>R has a few packages such as RODBC and RSQLServer that handle connections to SQL Server. With R Services in SQL Server 2016, it may even be possible to change your Power BI compute context from your local R environment to SQL Server in-database. Someone should try that…</p><p>For my current prototype, I used RODBC and adjusted the original code. Note how the following R script handles the SQL connection, appends new data (<em>sqlSave</em>), and selects all history from the table (<em>sqlQuery</em>) prior to the plot code. Using <em>sqlSave, </em>R creates the table if it does not already exist, and specifying <em>append=TRUE</em> handles the retention of historical moves. When it comes to the ggplot2 portion, nothing changes.</p><pre>library(ggplot2)<br>library(RODBC)</pre><pre>#filter some unnecessary data (it&#39;s just a buggy prototype...)<br>dataset &lt;- subset(dataset, dataset$CurrentColor != &quot;#FFFFFF&quot;)</pre><pre>#ODBC connection to SQL Server, store new values and retrieve all history<br>connStr &lt;- &quot;Driver=SQL Server;Server=localhost;Database=Demo;Uid=[User];Pwd=[PW]&quot;<br>connODBC &lt;- odbcDriverConnect(connStr)<br><strong>sqlSave</strong>(connODBC, dataset, tablename = &quot;dbo.Ships&quot;, append = TRUE)<br>selectQuery &lt;- &quot;SELECT SelectionXLabel, SelectionX, SelectionY, HitMiss, CurrentColor, ShipType FROM dbo.Ships&quot;<br>df &lt;- data.frame(<strong>sqlQuery</strong>(connODBC, selectQuery))</pre><pre>#specify column names for the new data frame<br>colnames(df) &lt;- c(&quot;SelectionXLabel&quot;, &quot;SelectionX&quot;, &quot;SelectionY&quot;, &quot;HitMiss&quot;, &quot;CurrentColor&quot;, &quot;ShipType&quot;)</pre><pre>#Use ggplot2 to create the Selection History plot<br>ggplot(df, aes(x = SelectionX, y = SelectionY, label = HitMiss)) + <br> geom_point(aes(colour = CurrentColor), size = 3) +<br> scale_colour_manual(values = c(&quot;#587ABC&quot;, &quot;#EE0000&quot;, &quot;#587ABC&quot;)) + <br> theme(legend.position=&quot;none&quot;, axis.ticks = element_blank()) +<br> geom_text(vjust = 2) + <br> xlim(1,10) + ylim(1,10) +<br> xlab(&quot;&quot;) + ylab(&quot;&quot;) + ggtitle(&quot;Selection History&quot;)</pre><p>Exciting, eh? The plot is the same as it was when using a local file, but the data is now stored in and retrieved from a SQL Server table. This type of functionality represents a big advantage for the R visual in my opinion. In the real world, there may even be some creative uses besides a typical auditing scenario for retaining Power BI data like this. At the very least, maybe it’s time for <em>Ship Sinker</em> multiplayer…</p><blockquote>Originally published at https://dataveld.wordpress.com</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=74c618f2e6f3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power BI — Designing a [Fun]ctional Visualization]]></title>
            <link>https://medium.com/@dataveld/power-bi-designing-a-fun-ctional-visual-part-1-of-2-e6c57a7bd4dc?source=rss-34a29a35687------2</link>
            <guid isPermaLink="false">https://medium.com/p/e6c57a7bd4dc</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[David Eldersveld]]></dc:creator>
            <pubDate>Sun, 22 Nov 2015 02:12:25 GMT</pubDate>
            <atom:updated>2016-02-10T11:19:58.078Z</atom:updated>
            <content:encoded><![CDATA[<p>With Power BI from Microsoft, you can deploy meaningful visualizations for a variety of audiences. As I have grown to know the product, I have deployed it as a <a href="http://www.blue-granite.com/">consultant</a> as well as used it for fun. Apart from initial exploratory work, I have learned that <strong>greater success </strong>with Power BI has always been the result of a <strong>strategic, cohesive design</strong> regardless of whether I create a business report or something to share with friends. You can <strong>experiment</strong>, but do it in a way that may help <strong>enhance rather than detract </strong>from your message.</p><p>Here is a framework that I employ when designing visualizations:</p><ol><li>Step away from the software</li><li>Consider the data (and data quality)</li><li>Consider the audience</li><li>Consider the message</li><li>Design</li><li>Execute</li></ol><p>We’ll consider each of these points using a sample “report” from Power BI. I have spent too much time looking at invoice, logistics, and sales data recently; so I will focus on something more appropriate for personal time: college football.</p><p>The final product shows conference stats for the current season prior to November 21:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/955/1*zlJIlRTiN_42ORC_sjOzsA.png" /><figcaption>2015 Big Ten football season as of November 20, 2015 — Visualized in Power BI</figcaption></figure><h4>1. Step Away from the Software</h4><p>Cohesive design does not begin with dragging charts around. Whether using Power BI or something else, a “spray and pray” effort where you throw a variety of charts, colors, and text together on-screen may eventually get you a successful visualization. More often than not, however, you get results that consist of poor quality, an unclear story, and lots of rework. A little planning goes a long way. Therefore, before using Power BI or any other visualization software to create something meaningful, consider a fruitful design process first. <strong>Know the capabilities</strong> of Power BI and keep its functionality in mind as you plan, but <strong>avoid the temptation to jump right in</strong>.</p><p>Good design starts here:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/264/1*2_ldKM81sRqNtE52cviibw.jpeg" /><figcaption>Use your brain and plan ahead</figcaption></figure><p>Poor design starts here:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*rFRSSaT6CFVZ__phLDBPmg.png" /><figcaption>Don’t use a “spray and pray” strategy for charts</figcaption></figure><h4>2. Consider the Data (and Data Quality)</h4><p>There are a lot of data and statistics tracked in sports. For my college football visualization, I selected the basics: <strong>wins, losses,</strong> and<strong> points scored </strong>by each team. I also narrowed it down to one conference: the <strong>Big Ten</strong>.</p><p>In terms of data, can I trust my source? Even with a reliable source, is the quality okay? I chose to obtain data from <em>ESPN.com</em>, and the likelihood that team records and scores could be wrong are low. Generally, however, it is not wise to take data cleanliness for granted. <strong>Poor data leads to a poor or misleading message </strong>for your audience. If needed, Power BI has built-in tools to help cleanse, transform, and model your data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/450/1*JhzG605V9GeP4IP_I55Bdg.png" /><figcaption>Source: ESPN.com</figcaption></figure><h4>3. Consider the Audience</h4><p><strong>Design with your target audience in mind</strong>. Keep in mind that sometimes you are <em>not </em>a member of the target audience. For this project, who cares about college football data? College football fans? With data limited to the Big Ten Conference, perhaps only Big Ten fans? Also, <strong>be aware of assumptions</strong>. Should we assume that everyone knows what a win and loss is? If I use an image of a school logo, can I assume that people know the school, or should I also write the school name? Taking some time to consider who your audience is will help you create a more coherent, targeted visualization.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/82/1*d5oI2gp9ZSDQyf7qih46Vw.png" /><figcaption>Can the audience identify Rutgers by logo alone, or is the text helpful?</figcaption></figure><h4>4. Consider the Message</h4><p>Over the past few years, there has been a growing focus on using data to <em>tell a story</em>. Whether you call it that or use other terminology, you are <strong>leading your audience</strong> through the data and trying to <strong>provide insights</strong> along the way. With my schedule data and audience of Big Ten fans, what am I trying to convey? Perhaps I want to focus on team records, but using the scoring data, can I also attempt to describe what might result in a win or loss? Do higher <em>average </em>scores correlate with wins? How can I guide my audience to see such a correlation (or lack thereof)?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/201/1*m3OrYpFKvVwsXEKOe_7KpQ.png" /><figcaption>Big Ten Records as of November 20, 2015</figcaption></figure><p>There are many different factors that result in wins and losses, and I only have data for the records themselves and points per game. In this case, limited<strong> </strong>data <em>could </em>lead to incorrect understanding. What if a team’s offense scores a lot of points per game, but the defense <em>gives up more </em>points (such as Indiana)? If you presented a look at offensive stats <em>alone</em>, you might lead your audience to expect that such a team has a relatively high number of wins. <strong>Sometimes limited data is enough, but data that is <em>too </em>limited can be misleading</strong>.</p><p><strong>Present only what is needed for the audience to gain insight and tell your story</strong>. If you have a simple message, do not err by presenting <em>too much</em> data just because it is available. In the real world, you need to sift through <strong>numerous data points</strong> and determine what might be relevant or not, then<strong> use only relevant data</strong> to tell the story. You engage your audience better when you <strong>present a concise, coherent message</strong>.</p><h4>5. Design</h4><p>We are finally at a stage where Power BI is involved! At this point, you translate the fruit of your planning into a rough visual design. That design should consciously <strong>match your data and intent with the features and constraints</strong> of the software. For example, you can consider your medium — is it a report or dashboard? What chart or combination of charts work best for your audience? Can you find the balance between too bare and too cluttered? Do you have a visual theme, and how will color be used to enhance it? Etc.</p><p>In terms of chart types, date and team<strong> </strong>are good candidates for slicers. Using slicers, I can interact with my data and see results for individual or multiple dates and teams. For presenting both the win/loss data as well as average points per game, linear charts such as bar charts, a waterfall chart, or even a funnel are typically easiest to interpret at a glance. Finally, since football involves a <em>network </em>of teams, I could consider how to visualize each game played throughout the season.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*B-vdPjOnNUyJAYoMhdHhlw.png" /><figcaption>Blurred vision above is not the result of Football Saturday</figcaption></figure><h4>6. Execute</h4><p>Once you have an initial design, it is time to execute. For my football visualization, I used the <strong>Chiclet Slicer</strong> for teams, which allows for custom images (team logos in this case). I also opted to use it for game dates both for consistency and because it is more versatile than the default slicer.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/235/1*wF4q_C3FYNlqmAC9rQGPbw.png" /><figcaption>Chiclet Slicers: beautiful, versatile, and should probably be the default in Power BI…</figcaption></figure><p>For comparing points, I selected a <strong>Clustered Bar Chart</strong> to display each team’s average alongside their opponents’. A<strong> Waterfall Chart </strong>displays cumulative wins throughout the season, and it also functions as a helpful way to show a running total by date. Finally, the overall wins and losses for each team are presented using a <strong>Bar Chart</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/703/1*QjcYWNIth-zmEiqEg4An8w.png" /><figcaption>Linear charts are typically more readable and easy to interpret</figcaption></figure><p>In order to visualize how all of the teams in the conference interact throughout the season, I used the new <strong>Force-directed graph.</strong> This presents each team as a node, with links for each game played, and points scored as the width of each link. Note how this visual could be helpful in an interactive environment, but it may have limitations when simply viewed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/324/1*ias1Ml5z-YPEQUBpIECEeA.png" /><figcaption>Too cluttered: force-directed graph showing links between teams for the whole season</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/262/1*2RiMXndTQtKnENDLcBwAHg.png" /><figcaption>Now filtered for an individual game day; move clockwise from a node to gauge relative points</figcaption></figure><p>After the core charts are in place, final work involves consistent styling and meaningful use of sizing and color. At that point, the visualization is complete — or is it?</p><p>Some additional things to consider: Does the visualization convey my meaning as coherently as possible. Did I execute well upon my design considering my data, audience, and message? Did I use an appropriate combination of visuals in Power BI, or is there room for improvement?</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e6c57a7bd4dc" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>