Solutions for Data Science

  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.

One-click charts are easy: Select the data and press  Alt+F1 . What if you would rather create bar charts instead of the default clustered column chart? To make your life easier, you can change the default chart type. Store your favorite chart settings in a template and then teach Excel to produce your favorite chart in response to  Alt+F1 . Say that you want to clean up the chart above. All of those zeros on the left axis take up a lot of space without adding value. Double-click those numbers and change Display Units from None to Millions. To move the legend to the top, click the + sign next to the chart, choose the arrow to the right of Legend, and choose Top. Change the color scheme to something that works with your company colors. Right-click the chart and choose Save As Template. Then, give the template a name. (I called mine ClusteredColumn.) Select a chart. In the Design tab of the Ribbon, choose Change Chart Type. Click on the Templates folder to see the template that ...

Download the example Dynamic Chart from below link. https://drive.google.com/file/d/1oJ5PcXX3wWhlgx8__87etRdbFm4oqdf3/view?usp=sharing Below are the steps to create a dynamic dashboard 1. Structured Data Create a table from the data you have. Select the data and press Ctrl + T  or Click on Table in Inset tab under Tables group as shown below. 2. Create Pivots Select the table and create a pivot by pressing Alt + N+V or Click on Pivot table in Insert tab under Tables group as shown below. Select New worksheet in the dialogue box and click ok. 3. Modify Pivot Table Once Pivot table is created name the pivot table in Analyse tab Pivot table Name in PivotTable section for reference. Pivot tables fields may appear automatically or if not appearing then click on field list in Analyse tab under Show.  Select Customer ID and Years in Rows section and Purchase Amount in Values section as shown below. ...