Choose the Right Data Visualization for Numbers

Only numbers - Showing Numbers in visuals

Sometimes, just showing the data as text is the most effective

way of conveying information.

Single value chart

When you just have one number, it’s best to just report

it as-is. Plotting a single value graphically (such as with a

bar or point) usually isn’t meaningful if there aren’t other

values to compare it to.

Single value with indicator

An indicator compares the single value to a second

number. This is often to compare a metric’s value between

the current period and the previous period.

Bullet chart

Chart type comparing a single value to another number,

often a benchmark rather than another data point. The

single value is shown with a bar’s length, while comparison

points are shown as shaded regions or a perpendicular line.

Table

Compares data points (rows) across multiple different

attributes (columns). Usually sorted by an important or

prominent attribute to improve utility.

Comments

20 Time Intelligence Dax Measures

20 Time Intelligence DAX measures in Power BI with examples: Year-to-Date Sales: css Copy code YTD Sales = TOTALYTD( [Total Sales] , Calendar [Date] ) Month-to-Date Sales: css Copy code MTD Sales = TOTALMTD( [Total Sales] , Calendar [Date] ) Quarter-to-Date Sales: css Copy code QTD Sales = TOTALQTD( [Total Sales] , Calendar [Date] ) Previous Year Sales: mathematica Copy code Previous Year Sales = CALCULATE ( [ Total Sales ] , SAMEPERIODLASTYEAR ( Calendar [ Date ] ) ) Year-over-Year Growth: css Copy code YoY Growth = DIVIDE( [Total Sales] - [Previous Year Sales] , [Previous Year Sales] ) Rolling 3-Month Average Sales: sql Copy code 3 M Rolling Avg Sales = AVERAGEX(DATESINPERIOD(Calendar[ Date ], MAX (Calendar[ Date ]), -3 , MONTH ), [Total Sales]) Cumulative Sales: scss Copy code Cumulative Sales = SUMX (FILTER(ALL(Calendar), Calendar [Date] <= MAX (Calendar[Date])), [Total Sales] ) Running Total Sales: scss Copy code Running Total Sales = SUMX (FILTER(ALL(Calendar), Calen...

Data Model an easy substitute for Vlookup

you have a data set with product, date, customer, and sales information. The IT department forgot to put sector in there. Here is a lookup table that maps customer to sector. Time for a VLOOKUP, right? There is no need to do VLOOKUPs to join these data sets if you have Excel 2013 or newer. These versions of Excel have incorporated the Power Pivot engine into the core Excel. (You could also do this by using the Power Pivot add-in for Excel 2010, but there are a few extra steps.) In both the original data set and the lookup table, use Home, Format as Table. On the Table Tools tab, rename the table from Table1 to something meaningful. I’ve used Data and Sectors. Select one cell in the data table. Choose Insert, Pivot Table. Starting in Excel 2013, there is an extra box, Add This Data to the Data Model, that you should select before clicking OK. The Pivot Table Fields list appears, with the fields from the Data table. Choose Revenue. Because you are using the Data Model, a new line a...

Sum a cell through several Worksheets

You have 12 identical worksheets, one for each month. You would like to summarize each worksheet. Is there a better way than using =Jan ! B4 + Feb! B4+Mar! B4+Apr! B4…? Solution: You can use a 3-D formula such as =SUM(Jan:Dec!B4) , as shown in Figure 41 . Figure 41. A 3-D formula adds up all instances of B4 on the 12 sheets from Jan through Dec. Late-breaking Tip : To add up cell B4 on all the worksheets with Sales in the sheet name, type =SUM(‘*Sales’!B4) and press Enter. If the first or last worksheet contains a space in the name, you have to use apostrophes around the pair of worksheet names: =SUM(‘Jan 2009: Dec 2009’!B4) . You can easily copy this formula to other cells on the summary worksheet. Gotcha: Do not drag the summary worksheet to appear after the Jan worksheet, or you will set up a circular reference. Additional Details: It is possible to set up a named range that refers to a 3-D range. Here is an interesting way to set...

Solutions for Data Science

Search This Blog