<?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 Power BI on Medium]]></title>
        <description><![CDATA[Stories by Power BI on Medium]]></description>
        <link>https://medium.com/@powerb916?source=rss-ac85199323d5------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/2*OBLKkapsnN4X5pNaXX_jYA.png</url>
            <title>Stories by Power BI on Medium</title>
            <link>https://medium.com/@powerb916?source=rss-ac85199323d5------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 18:03:20 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@powerb916/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[What is Power BI DAX? (Updated 2019)]]></title>
            <link>https://medium.com/@powerb916/what-is-power-bi-dax-updated-2019-1623de51fc54?source=rss-ac85199323d5------2</link>
            <guid isPermaLink="false">https://medium.com/p/1623de51fc54</guid>
            <dc:creator><![CDATA[Power BI]]></dc:creator>
            <pubDate>Mon, 16 Dec 2019 17:40:15 GMT</pubDate>
            <atom:updated>2019-12-16T17:40:15.921Z</atom:updated>
            <content:encoded><![CDATA[<p>First of all, I will discuss the <strong>term DAX</strong>. Data Analysis Expression(DAX) is a formula expression language used in <a href="https://data-flair.training/blogs/business-intelligence-tools/"><strong>different BI &amp; Visualization tools</strong>.</a> DAX is also called function language, where the full code is kept inside a function.</p><p>Power BI DAX could be a combination of functions, operators &amp; constants which will be utilized in a formula, or expression, in order to calculate and come one or additional values. DAX helps you in producing new info from existing information of your model.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/720/0*eYcTxhVWKIXdRyIF.jpg" /></figure><p>Now let me tell you about the <strong>Importance of Power BI DAX?</strong></p><p>You can easily <a href="https://data-flair.training/blogs/power-bi-desktop/"><strong>create a new Power BI Desktop file</strong></a> and import some data into it. Without using any DAX formula at all, you can create reports that show valuable insights.</p><p>But if you want to analyze growth percentage across product categories and for different data range, or if you want to calculate year-over-year growth compared to market trends, then with the help of DAX formulas you can perform these tasks. DAX formulas provide capabilities to calculate them and many other important capabilities as well.</p><p>Furthermore, let’s put some light on Power BI DAX Functions-</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*wahRhR0LeLspiSMJ" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/542/0*59vBcBYIcv3rvtqC" /></figure><ul><li><strong>Aggregate Functions</strong> — MIN, MAX, SUM etc.</li><li><strong>Counting Functions</strong> — COUNT, DISTINCTCOUNT, COUNTA, etc.</li><li><strong>Logical Functions </strong>— AND, OR, NOT, IF</li><li><strong>Text Functions</strong> — REPLACE, SEARCH, UPPER, FIXED.</li><li><strong>Date Functions</strong> — WEEKDAY, NOW, DATE.</li></ul><h3>Prerequisites for DAX Basics in Power BI:</h3><p>If you already know about making formulas in Microsoft stand out, then that data is going to be useful in understanding DAX, even though you have no expertise with stand-out formulas, the ideas that are presented here can help you to start making DAX formulas &amp; finding real-world metal issues promptly.</p><p>Therefore, in order to get specialized in understanding Power BI DAX formulas, you need to already be equipped with Power Metal Desktop, important information, adding fields to a report and with basics of Measures and Calculated columns.</p><h3>DAX Functions:</h3><p>Power Bi DAX includes the following function classes: date and time, time intelligence, information, logical, math, applied math, text, parent/child, and various functions. If you are familiar with functions in distinguished formulas, some of the functions in DAX may seem like you; however, DAX functions are distinctive in the following ways:</p><p>An entire column or table is perpetually referenced by a Power BI DAX. If you want to use a table or column’s only explicit values, you can add filters to the formula.</p><p>If you want to customize calculations on a row — by — row basis, DAX provides functions that enable you to use the current row price or a connected price as a form of argument to perform context — adjusting calculations. You may later learn more about the context.</p><p>DAX includes a spread of the functions of your time intelligence. These functions allow you to outline or select date ranges and support them in performing dynamic calculations. You will be able to compare sums over parallel periods as an example.</p><h3>Conclusion:</h3><p>Now that you have a basic understanding of the most important DAX concepts, you can start to create DAX formulas for your own measurements. DAX may be a bit tricky to learn, but you have a lot of resources at your disposal. You can learn more about other DAX concepts and formulas after reading this article and experimenting with some of your own formulas.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1623de51fc54" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Streaming Live Charts and Graphs with Microsoft Power BI]]></title>
            <link>https://medium.com/@powerb916/streaming-live-charts-and-graphs-with-microsoft-power-bi-fc4683e6d443?source=rss-ac85199323d5------2</link>
            <guid isPermaLink="false">https://medium.com/p/fc4683e6d443</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[graphic-design]]></category>
            <category><![CDATA[live-streaming]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[Power BI]]></dc:creator>
            <pubDate>Sat, 14 Dec 2019 06:58:43 GMT</pubDate>
            <atom:updated>2019-12-14T06:58:43.852Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/540/0*oWQApFfwOvhaUcLn.gif" /></figure><p>Realtime charts and graphs take business intelligence to a new level, and PubNub is excited to <a href="https://www.pubnub.com/blog/2016-08-11-microsoft-power-bi-integrates-pubnub-for-realtime-data-visualization/?utm_source=Syndication&amp;utm_medium=Medium&amp;utm_campaign=SYN-CY18-Q1-Medium-January-22">make your data streams available on the Microsoft Power BI platform</a>.</p><p>In most any industry use case (Automotive, Energy, Manufacturing, Medical, Retail, Smart City, Telecommunications), you can use PubNub to feed your data into Power BI.</p><p>In this tutorial, we’ll document how to feed your PubNub data streams into Power BI, resulting in some really impressive realtime charting functionality!To use your own data, if you don’t yet have an account, go ahead and <a href="https://admin.pubnub.com/#/register?utm_source=Syndication&amp;utm_medium=Medium&amp;utm_campaign=SYN-CY18-Q1-Medium-January-9&amp;utm_term=sign-up">sign up now</a> to get your API keys. Create an App, and then a Keyset, and you’ll be ready to go.</p><h3>Signing Up for Power BI</h3><p>To get access to Power BI:</p><ol><li>Go to <a href="https://powerbi.microsoft.com/en-us/">Power BI</a>.</li><li>Click <em>Get started free</em>.</li><li>Click Sign Up under Power BI (Not Power BI Desktop for Windows).</li></ol><h3>Charting a Realtime Datastream</h3><p>Power BI can chart any PubNub realtime data stream, as long as the payload is a JSON object. In addition, PowerBI supports not only flat objects, but also those with hierarchy (objects within objects). Neat, huh?</p><p>In reality, you can use your very own PubNub data streams to populate Power BI charts, but for the sake of simplicity, we’ll use a demo datastream called “sensor-network.”</p><h3>Our Demo Datastream</h3><p>Our “sensor-network” datastream object contains realtime environmental data from five different cities, with attributes of:</p><ul><li>Location / Geo (keyed by name, with lat/lon object data)</li><li>Temperature (in both F and C)</li><li>Humidity (%)</li><li>Barometric Pressure (mb)</li><li>Pollution Index</li><li>UV Index</li><li>Noise Level (dB)</li></ul><p>In JSON, the native format PubNub communicates in, it will look similar to this snippet:</p><p>Now that you have an overview of what our data looks like, the next step is to visualize it.</p><p>Creating our first Power BI Dashboard, PubNub Data Source, and Chart can be done quickly and nearly simultaneously. Let’s jump right in and begin by defining a new Dashboard!</p><h3>Defining a New Dashboard</h3><p>If you’ve already setup Power BI in the past, then when you login, go ahead and skip to the <em>Previously Setup Account</em> section below.</p><p>If this is your first time logging in to Power BI, follow the Newly Setup Account instructions below.</p><h3>Newly Setup Account</h3><p>When you first login to Power BI, you will be presented with the <strong>Welcome</strong> screen.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*mRPSQGrYbAmIli8E" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/883/0*tBV0nmA45IjAd41L.png" /></figure><p>Click Get under Files and the <strong>Files </strong>menu appears.</p><p>Click <strong>&lt; My Workspace</strong> to return to the <strong>Workspace</strong> screen.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*OJ9mh_ZftIGNxfID" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/877/0*fHIeFtMTpvA6TtpM.png" /></figure><p>Proceed to the <em>Previously Setup Account</em> section below to continue.</p><h3>Previously Setup Account</h3><p>Expand the Power BI left menu by clicking the <strong>three horizontal lines</strong> on the collapsed menu bar.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*jWjbyp9R9b7fSqaF" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/69/0*6QGbmr9nQm-9ocGG.png" /></figure><p>Once expanded, the left menu should look similar to this:</p><p><strong><em>NOTE: </em></strong><em>If this your first time using Power BI, the three horizontal lines may not be visible. If this is the case, instead, click </em><strong><em>Sample Data</em></strong><em>.</em></p><p>Click on the <strong>+ </strong>(plus-sign) under <strong>Dashboards</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/15/0*Ip0zbGvRGy_IqbCE" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/278/0*SfTPVeKU9k9QXPIl.png" /></figure><p>A text field will appear.</p><ul><li>Enter PubNub Sensor Cluster in the text field, then press the enter key.</li><li>Click on the newly created <strong>PubNub Sensor Cluster.</strong></li></ul><p>You’ll now be viewing the empty <strong>PubNub Sensor Cluster Dashboard</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*knvg5WkTXzhadXWf" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/922/0*JKBJIoaKBPICTi5o.png" /></figure><p>Next, lets add a <strong>Tile</strong> to the Dashboard. Click the<strong> + </strong>next to<strong> Add Tile</strong> (located in the upper left of the screen). The <strong>Add tile</strong> panel appears.</p><p>Click the <strong>CUSTOM STREAMING DATA </strong>button, located below the REAL-TIME DATA heading, then click <strong>Next</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/18/0*9w576bc-P-LMEDWB" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/488/0*0IShFb1t-_GBd1zJ.png" /></figure><p>The <strong>Add a custom streaming data tile</strong> panel appears. This screen is where we will bring in the actual PubNub Data Stream, credentials and all, into Power BI, as a streaming dataset.</p><h3>Add PubNub as a Streaming Dataset</h3><p>To add PubNub as a streaming dataset, click <strong>manage data</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/26/0*Gv61vnvWTQuk6AlH" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/481/0*FecRYtXNwPyGjR34.png" /></figure><p>The <strong>Streaming data</strong> page opens. Click the <strong>+ Add streaming dataset </strong>link in the upper-right of the screen.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*OI1gGXYwiVYE2w0C" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/922/0*I3FlunIXddLAnm9d.png" /></figure><p>The <strong>New streaming dataset</strong> panel opens. Select <strong>PubNub</strong>, then click <strong>Next</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/26/0*TLm18fcDeTUQcye8" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/480/0*gNWvCbzQZR0Z4wH2.png" /></figure><ul><li>For <strong>Dataset name</strong>, enter PubNub Sensor Network.</li><li>For <strong>Sub-key</strong>, enter the PubNub subscribe key for this tutorial, mspowerbi.</li><li>For <strong>Channel name</strong>, enter the PubNub data streams channel for this tutorial, sensor-network<strong>.</strong></li><li>For <strong>PAM Auth Key</strong>, leave it blank, as this demo dataset does not utilize one.</li><li>Click <strong>Next</strong>.</li></ul><p>Upon clicking <strong>Next</strong>, you should see an example schema and example object representation of the data.</p><p><strong><em>NOTE: </em></strong><em>This dataset is large — be sure to scroll all the way down to get a comprehensive look at the information presented.</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/13/0*UvGW1VEaXi682-JI" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/415/0*ROliuFIEbAPT-gQk.png" /></figure><p>Click the <strong>Create</strong> button to save this newly created Streaming dataset. The <strong>Streaming Data</strong> page appears again, but this time, with our <strong>PubNub Sensor Network</strong> displayed as a defined entry.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*QYUlY8HQjr3myS4C" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/922/0*v_RqDdBAEUXzZib7.png" /></figure><p>Now that we’ve created the streaming dataset, we have the foundation to build our visualizations on top of it.</p><h3>Power BI Charting Options</h3><p>Power BI provides many different chart types for realtime streaming data. They include:</p><ul><li>Cards</li><li>Line Charts</li><li>Clustered Bar Charts</li><li>Clustered Column Charts</li><li>Gauges</li></ul><p>Each chart type has its niche — more details on the various chart types can be found within <a href="https://powerbi.microsoft.com/en-us/documentation/powerbi-service-visualization-types-for-reports-and-q-and-a/">Power BI documentation</a>, but I’ve assembled a brief summary of when to use each one.</p><h3>Cards</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*4rEquQcyEB9CIl0b" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/202/0*Kt8dPTgO2kmIKXWa.png" /></figure><p>When the latest number value of a metric is the most important thing to know, use a card.</p><h3>Line Charts</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*ugLSgpNcP-3mct9P" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/272/0*Z-Og--zYZtwITEu2.png" /></figure><p>Line charts display data points, connected together by lines. A great use of line charts is to visualize data changes across a time period.</p><h3>Clustered Bar and Column Charts</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*jRG6e4dZKrnwQ5fA" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/218/0*p-GBMHOhVjsTAhep.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*Mm3tnWlGyudCMsbL" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/270/0*ZUb1mX9OykK-tUeO.png" /></figure><p>Column charts display data relative to a horizontal (x-axis) reference point, and bar charts display data relative to a vertical (y-axis) reference point. Both are great for displaying changing minx and maxes. “Clustered” just means that you can display many values together (for example, “North American Sales” and “Asia Sales”) together on the same tile.</p><h3>Gauges</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*ysndHZR4qRz6yeW2" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/347/0*mtVYwt0bGiFgVFke.png" /></figure><p>A gauge chart shows a min and max of two extremes, and where your value lies between the two. These are best used when it’s important to know where you stand in the midst of two extremes.</p><p><strong>NOTE</strong>: Although Power BI provides a wide-range of industry-leading visualization features, the purpose of this post isn’t to go in-depth into all of them at once. Instead, we’ll begin with simple PubNub-driven examples, and based on user feedback, we will be excited to add more blog post installments with more varying, user-requested topics. As such, as you have fun learning about PubNub visualizations through Power BI, take some notes on additional areas of interest, and email them to use at <a href="/service/mailto:support@pubnub.com">support@pubnub.com</a>.</p><p>Now that we know our options, let’s begin with a simple Card example.</p><h3>Creating a Card</h3><ul><li>Under <strong>Dashboards</strong> click <strong>PubNub Sensor Cluster</strong>.</li><li>Click <strong>+ Add tile</strong>, locatedx in the upper left of the screen.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*VW9QIhDaR7e9OAlL" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/308/0*cnEtL-sl-m1Z1Vmg.png" /></figure><p>The Add tile panel appears.</p><p>Click the <strong>CUSTOM STREAMING DATA </strong>button, located below the REAL-TIME DATA heading, then click <strong>Next</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/18/0*oqvk92qo0TTvrtt3" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/488/0*u6Wx1C1AA9ypW6Ws.png" /></figure><p>Click the <strong>PubNub Sensor Network</strong> button, then click <strong>Next</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*KWHApNA-ol1nkPIx" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/471/0*mfl7UDUIa9DLuW0p.png" /></figure><p>The Visualization Type dropdown will appear.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*xUUfIs-Nq68qXFbt" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/481/0*AE9XJniB3qezGORl.png" /></figure><p>Select <strong>Card</strong>. Under <strong>Fields</strong>, click <strong>+ Add Value</strong>.</p><p>A dropdown will appear with attributes of the PubNub data stream.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/26/0*iz6eBUc7eXSrrT8g" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/470/0*2JI5oQpSGPbU9sJ-.png" /></figure><p>Scroll down to select <strong>Chennai.noise</strong>, then click <strong>Next</strong>. In the <strong>Title</strong> field, enter Noise in Chennai. In the <strong>Subtitle</strong> field, enter dB.</p><p>Your screen should look similar to below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*k8HSGoqtZKycrYaN" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/922/0*uMB0GtEgzGjWjzs9.png" /></figure><p>Click <strong>Apply</strong>. Repeat the above steps, but with <strong>noise</strong> readings from <strong>Novato</strong>, <strong>Redmond</strong>, and <strong>San Francisco</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*zPH2jSLS_5ahBIwb" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/922/0*QkeK5L8RFNMTBwSb.png" /></figure><p>Congrats! You’ve created your first realtime visualizations with Power BI Cards powered by a PubNub data stream!</p><p>Next, we’ll experiment with Line Charts.</p><h3>Creating a Line Chart</h3><ul><li>Click <strong>+ Add tile</strong>, located in the upper left of the screen.</li><li>Click the <strong>CUSTOM STREAMING DATA </strong>button, located below the REAL-TIME DATA heading, then click <strong>Next</strong>.</li><li>Click the <strong>PubNub Sensor Network</strong> button, then click <strong>Next.</strong></li></ul><p>The Visualization Type dropdown will appear.</p><ul><li>Select <strong>Line Chart</strong>.</li><li>For <strong>Axis</strong>, click <strong>+ Add Value</strong>, and select <strong>timestamp.</strong></li><li>For <strong>Values</strong>, select <strong>Redmond.humidity.</strong></li></ul><p>You should now see the humidity in Redmond as a function of time in the preview. But for bonus points, let’s also plot the humidity in San Francisco as well.</p><ul><li>For <strong>Values</strong>, select <strong>San Francisco.humidity.</strong></li></ul><p>Your screen should similar to the example below:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*ylNnth13r3sC-U2G" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/922/0*QUf51yN1nN1RxPbL.png" /></figure><ul><li>Click <strong>Next</strong>.</li><li>For <strong>Title</strong>, enter Redmond vs San Francisco.</li><li>For <strong>Subtitle</strong>, enter By Percent Humidity.</li><li>Click <strong>Apply</strong>.</li></ul><p>The line chart appears next to the last card we made. Let’s resize and arrange our new line chart for purely aesthetic purposes.</p><ul><li><strong>Drag</strong> the line chart to place it below the cards.</li><li><strong>Resize </strong>the line chart by grabbing it by the lower-right corner, so it’s flush with the right-hand edge of the right-most card.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*Cwov_VZ4FBBX6DJs" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/922/0*_K5ko7PAqbiCENYV.png" /></figure><p>Congratulations are in order once again, as now, we have a two value Line Chart added to our Dashboard!</p><p>Next, let’s create some Bar and Column charts.</p><h3>Creating Bar and Column Charts</h3><ul><li>Click <strong>+ Add tile</strong>, located in the upper left of the screen.</li><li>Click the <strong>CUSTOM STREAMING DATA </strong>button, located below the REAL-TIME DATA heading, then click <strong>Next</strong>.</li><li>Click the <strong>PubNub Sensor Network</strong> button, then click <strong>Next.</strong></li></ul><p>The Visualization Type dropdown will appear.</p><ul><li>Select <strong>Clustered Bar Chart</strong>.</li><li>For <strong>Value</strong>, add <strong>Novato.Temperature.F</strong>.</li></ul><p>Repeat the above step for each other city’s temperature in Fahrenheit.</p><ul><li>Click <strong>Next</strong>.</li><li>For <strong>Title</strong>, enter Temperature<strong>.</strong></li><li>For <strong>Subtitle</strong>, enter Fahrenheit.</li><li>Click <strong>Apply</strong>.</li></ul><p>We now have the a temperature bar chart. Next, let’s do a variation of the same data, but in a column chart.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*zPXR_syXmnEMW2vq" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/472/0*lBIzNHtpxlUBebYY.png" /></figure><ul><li>Click <strong>+ Add tile</strong>, located in the upper left of the screen.</li><li>Click the <strong>CUSTOM STREAMING DATA </strong>button, located below the REAL-TIME DATA heading, then click <strong>Next</strong>.</li><li>Click the <strong>PubNub Sensor Network</strong> button, then click <strong>Next.</strong></li></ul><p>The Visualization Type dropdown will appear.</p><ul><li>Select <strong>Clustered Column Chart</strong>.</li><li>For <strong>Value</strong>, add <strong>Novato.Temperature.C</strong>.</li></ul><p>Repeat the above step for each other city’s temperature in Celsius.</p><p>In the column chart example, we omitted the x-axis (known simply as the <strong>axis</strong>). By adding an axis value (in this case, the timestamp), we can then show multiple instances of the chart relative to the axis value, within a time window.</p><ul><li>Under <strong>Axis</strong>, click <strong>+ Add</strong> <strong>value</strong>.</li></ul><p>The Axis dropdown will appear.</p><ul><li>Select <strong>timestamp</strong> from the dropdown.</li><li>Under <strong>Time window to display</strong>, enter Last 5 Seconds.</li><li>Click <strong>Next</strong>.</li><li>For <strong>Title</strong>, enter Temperature — Five Second Window<strong>.</strong></li><li>For <strong>Subtitle</strong>, enter Celsius.</li><li>Click <strong>Apply.</strong></li></ul><p>We now have two versions of the same data visualized very differently. Two units of measure are shown in two charting formats, one, with the bar chart’s values displayed in-place for an always current view of the data, and the other as a column chart, the last five seconds worth displayed.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*PWQiOPtNTwKSCm2B" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/922/0*I7VSx6WVEBiSymZC.png" /></figure><p>For our final chart, lets create a gauge chart to compare the noise levels of three cities at once.</p><h3>Creating Gauge Charts</h3><ul><li>Click <strong>+ Add tile</strong>, located in the upper left of the screen.</li><li>Click the <strong>CUSTOM STREAMING DATA </strong>button, located below the REAL-TIME DATA heading, then click <strong>Next</strong>.</li><li>Click the <strong>PubNub Sensor Network</strong> button, then click <strong>Next.</strong></li></ul><p>The Visualization Type dropdown will appear.</p><ul><li>Select <strong>Gauge</strong>.</li><li>For <strong>Value</strong>, select <strong>Honolulu.noise</strong>.</li></ul><p>This will make it so the gauge indicates the noise in Honolulu.</p><ul><li>For <strong>Minimum Value</strong>, select <strong>Novato.noise</strong>.</li></ul><p>This will re-scale the gauge at the min-point, so the min value in the scale represents the current noise level in Novato.</p><ul><li>For <strong>Maximum Value</strong>, select <strong>Chennai.noise</strong>.</li></ul><p>This will re-scale the gauge at the max-point, so the max value in the scale represents the current noise level in Chennai.</p><ul><li>Click <strong>Next</strong>.</li><li>For <strong>Title</strong>, enter Noise Levels.</li><li>For <strong>Subtitle</strong>, enter Relative to Novato, Honolulu, and Chennai.</li></ul><p>The gauge appears next to the last chart we made. Let’s resize and arrange our gauge for purely aesthetic purposes.</p><ul><li><strong>Drag</strong> the gauge to place it below the column and bar charts.</li><li><strong>Resize </strong>the gauge by grabbing it by the lower-right corner, so it’s flush with the right-hand edge of the right-most column chart.</li></ul><p>And there you have it, a crash-course in using PubNub realtime data streams with Power BI!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/22/0*Eg1_-GEM944Wh890" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/758/0*1ID20Nu7JSf1MecC.png" /></figure><p>We hope you enjoyed this tutorial! Your feedback is really important — tell us what you’d like to see us focus on for our next installment of Power BI and PubNub. Email your requests to <a href="/service/mailto:support@pubnub.com">support@pubnub.com</a>, and we’ll be looking forward to your feedback!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fc4683e6d443" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Learn Power BI : Step-by-Step Guide 2019]]></title>
            <link>https://medium.com/@powerb916/learn-power-bi-step-by-step-guide-2019-c64e862fde2d?source=rss-ac85199323d5------2</link>
            <guid isPermaLink="false">https://medium.com/p/c64e862fde2d</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[power-bi-training]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[bi]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Power BI]]></dc:creator>
            <pubDate>Sat, 14 Dec 2019 06:50:53 GMT</pubDate>
            <atom:updated>2019-12-14T06:50:53.930Z</atom:updated>
            <content:encoded><![CDATA[<h3>Learn Power BI : Step-by-Step Guide 2019</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/732/0*vWRmNhza8DSnP7S-.png" /></figure><p>Before we start, what is Power BI in the first place? As stated on its <a href="https://powerbi.microsoft.com/">website</a>: “Power BI is a suite of business analytics tools that deliver insights throughout your organization.”</p><p>It is, by all means, no exhaustive definition of this instrument. The comprehensive set of features enables easy to use data import from a variety of files, simple to handle data transformations, beautiful visualizations with interactivity, and even more. Also, there are several possible ways to work with Power BI: Power BI Web, Mobile, Embedded, Desktop App.</p><p>In this quick intro to Power BI, we will use the Desktop version. You can download it either by selecting Power BI Desktop in the product menu on the main page or, in case you are already registered and signed in, you can click download button near your account icon.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/428/0*86ERqmyCydUFvlOX.png" /></figure><p>To install it, simply run <strong>PBI_desktop_x64/32.msi</strong> file, which you have just downloaded, and follow straightforward installation wizard prompts. The next step is to sign in to Power BI with your account. If you already have one, just use your credentials; otherwise, click “Get started free” on the main page of the website and fill in the registration form, then sign in with your freshly created account. Now, we are ready to explore.</p><p>To begin with, we need to import the data. As an example, we have chosen to use the <a href="https://public.tableau.com/s/sites/default/files/media/TopBabyNamesbyState.csv">Top Baby Names in the USA dataset</a>. For the next step click “Get Data” on the <strong>Home bar</strong> on the very top of Power BI window.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/536/0*UnfbWCLvOC-3TmD-.png" /></figure><p>You will be prompted to choose from where you want to import and which file format to use. For now, we will connect the local file of plain CSV format.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*jGJ-rk8lsyIfuDaW" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/570/0*7HZVAiwQq7PwgGSz.png" /></figure><p>Navigate to the folder where the downloaded data is located, choose it and click “Open”. At this point, you will get a preview of your data in the table form.</p><p>There are several options available here:</p><ul><li>you may import data as is, without any modifications and tuning;</li><li>you may just change the way data types are detected; here we have chosen to detect on the entire document (probably do not want to do that on really big data sets);</li><li>and finally, we can modify data (by clicking “Edit”).</li></ul><p>There is actually one minor problem with the data here — the <strong>Year</strong> field is detected in whole numbers format. It is not going to cause errors or miscalculations in the future analysis (a year is a whole number after all), but it will cause some inconvenience such as obscure labeling.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*DiiW7SACCc0TFOsd" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/285/0*SsEkhOPW1KM74YTs.png" /></figure><p>We want the years to be points on the timeline or in other words — timestamps, instead of flat numeric values. To perform this transformation, we will go ahead and edit the data set before connecting.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*fefI_ePkm1_idEL2" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rbhs0-8_J6z3zB44.png" /></figure><p>In the window that has just opened, it is very simple to perform all kinds of manipulations with data. It also features the data itself, the log of actions (Applied Steps), and many other handy things. To change the data type of the column — click on it, choose “Data Type” on the <strong>Home bar</strong>, and then pick the new data type.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*5N91m9Lp2xucN1Dm" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/91/0*Q-6HobEEBsEJKZC-.png" /></figure><p>We will have a <em>date</em> type for our <strong>Year</strong> column. It will append day and month to every entry, but it is not much of a deal for us here. To finish editing, just click “Close &amp; Apply” button on the <strong>Menu bar</strong>of the current window. And that’s it, our data is imported and ready to be worked with. You may see the indication of this on the fields pane, where a new table is added with the corresponding fields exposed.</p><p>Now, let’s get our hands on some visualization.</p><p>Before we start, we need to define what we see in the main window. There are three main areas:</p><ol><li><strong>Report area</strong> (big blank sheet), where all the drawing goes;</li><li><strong>Visualizations pane</strong>, where types of visuals are chosen and tuned;</li><li><strong>Fields pane</strong>, which we have already mentioned above.</li></ol><p>First, we will try to discover the most interesting spots of our data and analyze them. We can begin by outlining the most frequent names throughout the history. To see that, we will expose the quantile relationship between the <strong>Occurrences</strong> and the <strong>Top Names</strong>. The most suitable way to show it is to use a bar chart.</p><p>To draw plain bar chart (the horizontal one), we will click on <strong>Stacked Bar Chart</strong> on <strong>Visualizationspane</strong>. An empty placeholder will pop up in the <strong>Report Area</strong>. This placeholder is the place to start. It should get in the focus automatically, but if it does not — just click on it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/14/0*wSnojzd56QRBPB74" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/163/0*ntAe_FKCRBXB23zj.png" /></figure><p>Right under the visuals types, you may see fields to visualize in this bar chart. Just drag and drop data in corresponding places. We want to see names on the axis and occurrences to define values, so we will drag each one to its place.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*4MNSSqGqgkIfex8_" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*J87BdGx-eLIEj_wA.png" /></figure><p>At this point, we have our first visual, but the chart seems too sparse. However, it is not because our data is sparse, it gets intense as you go down, it is just that entries are sorted by <strong>Top Name</strong>, and we want them to be sorted by <strong>Occurrences</strong>. We will do that by clicking three dots at top left and choosing sort by occurrence.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*xGqaTST6fUhB2wt8" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*bzVzQMfQ05Bnctgc.png" /></figure><p>With that, the visualization becomes meaningful, and as you can see we did not change a single field.</p><p>To continue, let’s get a different look at our data, now from the time perspective. We will visualize the dynamics of name frequencies over time. The perfect fit for that is a <strong>Line Chart</strong>, so we choose this one from our visualization types. Next, we will populate our visual with data:</p><ul><li>as our axis we will take <strong>Year </strong>field;</li><li>for values the pick is <strong>Occurrences</strong>;</li><li>and finally, the legend will be filled with <strong>Top Names</strong> field.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*XJ-WpdRfVANArVk-" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/951/0*N3l-MyOTI5YDYw2q.png" /></figure><p>First of all, we want to get rid of this annoying “Year Year” label at the bottom. It is actually not a mistake; it is just the way date type is presented. We can change the way it is shown by clicking on the <strong>Year</strong> field in axis place and choosing “Year”, instead of “Date Hierarchy”.</p><p>Reports in Power BI are interactive, that means that all charts work in contraction, as one. With that, we can choose entities in one chart, and that will affect the display of another.</p><p>For example, in our previous chart, we have seen that name “Mary” is the most reoccurring throughout entire history, and we want to see the dynamics of this name over time. To do that, click on the bar for this name and this will update the display in all charts where this name happens to be. This often comes in handy.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*121U2FLtJ4wufuRi" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/937/0*cWhOeaF0Vp5ZILBV.png" /></figure><p>Using Power BI, we always can look at the picture of data as a whole and as parts of one. We can choose specific areas of our dataset by filtering the things we do not want to see on the graph. For our next case, we want to see what male names compose the most popular ones in the last year presented in the dataset. The perfect fit to see the fractions of a whole is a <strong>Pie chart</strong>.</p><p>The process of drawing the chart is the same as previously, but this time we will apply several filters.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/814/0*XnhI6MjpFM8Nk5SY.png" /></figure><p>The filters already contain fields that compose the visual. To add new filters without adding them to visualization, we can just drag and drop fields to filters.</p><p>First, drag the <strong>Year</strong> field and set it to the 2012 year. Then, we add <strong>Gender</strong> field to filters and check it to be male. And that is it.</p><p>To finalize our report and show some advanced visualizations Power BI provides, we want to visualize male name distribution for 2012 geographically (across the state).</p><p>Power BI gives two default options to visualize geo data: <strong>Maps</strong> and <strong>Filled maps</strong>. Our choice will be<strong> Filled maps</strong>. There are also several ways to specify exact location: Country, State, Country or State codes, longitude and latitude, etc. Our data set has <strong>State</strong> column with state code inside, so we will use it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*RSuj0cCEulFWWdZE" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/931/0*Z1RBZhKRQeR6iK_9.png" /></figure><p>We will use two filters (<strong>Gender: male, Year: 2012</strong>) and two fields to be shown on our map. For location option we use<strong> State</strong> and for legend — <strong>Top Name</strong> field. Power BI will produce the visualization using Bing maps.</p><p>Now, before rolling up our report to see the light, we want to give our charts some meaningful titles. We can change that in <strong>Format tab</strong> of <strong>Visualizations pane</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/27/0*JWPP0AJtdYmGmpLD" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*RYE2UwUtahtJHIOk.png" /></figure><p>Since we think that our report looks pretty, we want to share that with the world. All you need to do is just save the report and click “Publish” on the <strong>Menu bar</strong>. The report will get uploaded to the Power BI account. In your account, you can pin entire report or separate charts to a dashboard (new or existing one) and share it by email or via link.</p><h3>Conclusion</h3><p>In this tutorial, we’ve got acquainted with the Power BI, a powerful tool and comfortable environment for data visualization and analytics tasks, learned how to create simple graphics and modify them to suit our needs and tastes. This information pretty much wraps up the general usage of Power BI, but there is always more. Amongst other great functionalities are relationship management, custom visualizations, cloud-powered reports, and a whole variety of tools available to your discretion.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c64e862fde2d" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>