How to Design Visually Stunning Reports in Power

How to Design Visually Stunning Reports in. Power BI

Science Behind Data Visualization Most Bad or forgettable reports all have the same problems http: //www. dashboardzone. com/school-student-dashboard-bad-good-or-ok

20% GRIDS LINES SIZE SHAPES CONSISTENCY ALIGNMENT SPACING BALANCE COLOR BACKGROUND CONTRAST SIMPLICITY

MEASURES RELATIONSHIPS DATA SOURCES EDIT QUERIES TRANSPOSE APPEND M COMBINE BINARIES DRILL DOWN FORMULAS DAX UNPIVOT MULTIDIMENTIONAL TABLES SPLIT COLUMNS HIERARCHY MODELING FILTERS SORT BY AGGREGATE MERGE REPLACE EXTRACT REMOVE DUPLICATES EXPAND PIVOT SUMMARIZATION

WORKING, CLEANING ENHANCING 80% DATA AND THE

10 RULES Designing reports and dashboards in Power BI

consectetur 61% consectetur 1. Draw a Sketch 42 52% ADIPISCING Lorem ipsum dolor -30% Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 Category A 1/10/2002 1/11/2002 1/12/2002 Category B 1/13/2002 1/14/2002 1/15/2002 Category C 1/16/2002 1/17/2002 1/18/2002 Category D 1/19/2002 1/20/2002 Category E fugiat nulla 87 87 87 87 1/21/2002

What do you want to explain? WHAT WHEN WHERE WHY HOW

2. Organize your Structure 1 Main KPI 2 a Over Time 2 b Over Time 2 c Over Time 3 a 3 b Comparison Map 3 c Top

Demo Visual Studio Storyboarding

consectetur 61% consectetur 42 . use a 2 Always ADIPISCING Lorem ipsum dolor -30% Lorem ipsum 52% Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 Category A 1/10/2002 1/11/2002 1/12/2002 Category B 1/13/2002 1/14/2002 1/15/2002 Category C 1/16/2002 1/17/2002 1/18/2002 Category D 1/19/2002 1/20/2002 Category E fugiat nulla 87 87 87 87 1/21/2002 Grid

consectetur 61% consectetur 42 3 Use. a correct ADIPISCING Lorem ipsum dolor -30% Lorem ipsum 52% Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 Category A 1/10/2002 1/11/2002 1/12/2002 Category B 1/13/2002 1/14/2002 1/15/2002 Category C 1/16/2002 1/17/2002 1/18/2002 Category D 1/19/2002 1/20/2002 Category E fugiat nulla 87 87 87 87 1/21/2002 Alignment

consectetur 61% consectetur 42 . 4 Appropriate ADIPISCING Lorem ipsum dolor -30% Lorem ipsum 52% Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 Category A 1/10/2002 1/11/2002 1/12/2002 Category B 1/13/2002 1/14/2002 1/15/2002 Category C 1/16/2002 1/17/2002 1/18/2002 Category D 1/19/2002 1/20/2002 Category E fugiat nulla 87 87 87 87 1/21/2002 Spacing

5. Select the right Background

Demo Grid, Alignment and Spacing in product and background guide

consectetur 3 2 1 consectetur 61% consectetur 4 42 ADIPISCING Lorem ipsum dolor -30% Lorem ipsum 52% Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 5 Series 1 80 60 Series 1 40 20 0 1/5/2002 1/6/2002 1/7/2002 1/8/2002 Category A 1/9/2002 1/10/2002 1/11/2002 1/12/2002 Category B 1/13/2002 1/14/2002 1/15/2002 1/16/2002 Category C 1/17/2002 1/18/2002 1/19/2002 Category D 1/21/2002 Use the right Visualizations Category E fugiat nulla 87 87 87 87 6 1/20/2002 6. <7

4 Design Ways to show your results Analysis State Overview Pictorial EASY MEDIUM HARD EXTREME

4 Design Ways to show your results Reports Scorecards Dashboards Infographics EASY MEDIUM HARD EXTREME

Designing Power BI Analysis TEXT TABLES CHARTS CARDS INDICATORS IMAGES LOREM IPSUM DOLOR SIT AMET CONSECTETUR ADIPISCING Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 1. 2 1. 4 8. 2 3. 2 Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod Category 4 4. 5 1 st Qtr Category 3 Category 2 Category 1 3. 5 2. 5 4. 3 Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. 2 nd Qtr Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. 3 rd Qtr 4 th Qtr Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillfugiat nulla pariatur. Excepteur sint Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis SLICERS A report is a textual work (usually of writing, speech, television, or film) made with the specific intention of relaying information or recounting certain events in a widely presentable form (Wikipedia).

Designing Power BI consectetur Scorecards consectetur 61% consectetur 42 INDICATORS TABLES CARDS CHARTS SLICERS IMAGES ADIPISCING Lorem ipsum dolor -30% Lorem ipsum 52% Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 Category A 1/10/2002 1/11/2002 1/12/2002 Category B 1/13/2002 1/14/2002 1/15/2002 Category C 1/16/2002 1/17/2002 1/18/2002 Category D 87 87 fugiat nulla 87 87 A succinct summary that captures the information most relevant to those reading it. (Wikipedia). 1/20/2002 Category E fugiat nulla TEXT 1/19/2002 1/21/2002

Designing Power BI Lorem Lorem Lorem ipsum dolor sit amet DASHBOARDS 1 st Qtr 52% 2 nd Qtr consectetur SLICERS CARDS INDICATORS TABLES IMAGES TEXT consectetur 1. 4 4 th Qtr 1. 2 Lorem ipsum dolor sit amet consectetur consectetur 3. 2 Lorem 1 st Qtr 2 nd Qtr 3 rd Qtr 4 th Qtr 00 2 20 0 11 2 /2 1/ 002 13 /2 1/ 002 14 /2 1/ 002 15 /2 1/ 002 16 /2 1/ 002 17 /2 1/ 002 18 /2 1/ 002 19 /2 1/ 002 20 /2 1/ 002 21 /2 00 2 10 / 1/ 1/ 9/ 2 00 2 Category A 1/ 7/ 2 1/ 8/ 2 00 2 8. 2 1/ 5/ 2 42 6/ 2 consectetur 1/ Lorem 1. 2 1. 4 1/ CHARTS ADIPISCING Lorem ipsum dolor consectetur 3. 2 3 rd Qtr consectetur Lorem 8. 2 Category B Category C fugiat nulla 87 87 Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 1/10/2002 1/11/2002 1/12/2002 1/13/2002 1/14/2002 1/15/2002 1/16/2002 1/17/2002 1/18/2002 1/19/2002 1/20/2002 1/21/2002 …. a dashboard is an executive information system user interface that (similar to an automobile’s dashboard) is designed to be easy to read (Wikipedia).

Designing Power BI 42 SED LOREM IPSUM INFOGRAPHICS Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit 8 IMAGES 4 dolor sit 30% dolor sit 60% 2 20% TEXT CHARTS dolor in reprehenderit INDICATORS SLICERS TABLES 2/12 2/12 Lorem LOREM 71 CARDS Lorem $20, 000 USD DOLORE MAGNA Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. 2/12 Information graphics or infographics are graphic visual representations of information, data or knowledge intended to present information quickly and clearly (Wikipedia).

- CEO - President - Director - Leader - Manager - Supervisor - Analyst - Marketing Specialist - IT Technician - Client - Customer - Employee All about the Users

Demo Data Stories Gallery and more http: //visuals. powerbi. com http: //extremepresentation. typepad. com/files/choosing-a-good-chart-09. pdf

consectetur 61% consectetur 42 Lorem ipsum 52% ADIPISCING Lorem ipsum dolor -30% NICE Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 60 40 20 0 80 Series 1 80 60 Series 1 40 20 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 1/10/2002 1/11/2002 1/12/2002 1/13/2002 1/14/2002 1/15/2002 1/16/2002 1/17/2002 Category A Category B Category C 1/18/2002 1/17/2002 1/18/2002 1/19/2002 1/18/2002 1/20/2002 1/19/2002 1/21/2002 1/20/2002 Category D Category E fugiat nulla 87 87 87 87 1/21/2002 7. Simpler Is better!

consectetur 61% consectetur 42 Lorem ipsum 52% Lorem ipsum dolor -30% 8. ADIPISCING Lorem ipsum dolor ADIPISCING Use Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 60 40 20 0 80 Series 1 80 60 Series 1 40 20 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 1/10/2002 1/11/2002 1/12/2002 1/13/2002 1/14/2002 1/15/2002 1/16/2002 1/17/2002 Category A fugiat nulla 87 fugiat nulla Category B Category C 87 87 1/18/2002 1/17/2002 1/18/2002 1/19/2002 1/18/2002 1/20/2002 1/19/2002 1/21/2002 1/20/2002 Category D 1/21/2002 Category E 87 87 8787 87 87 fugiat nulla 87 87 87 87 Negative Space wisely

ANALOGOUS . your 9 Choose Colors <4 Color palette TRIADIC Colors <4 MONOCHROMATIC Color <6

Palette Demo With Great Power Comes Great Responsibility

consectetur 61% consectetur 42 Lorem ipsum 52% ADIPISCING Lorem ipsum dolor ADIPISCING -30% Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 60 40 20 0 80 Series 1 80 60 Series 1 40 20 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 1/10/2002 1/11/2002 1/12/2002 1/13/2002 1/14/2002 1/15/2002 1/16/2002 1/17/2002 Category A fugiat nulla 87 fugiat nulla Category B Category C 87 87 1/18/2002 1/17/2002 1/18/2002 1/19/2002 1/18/2002 1/20/2002 1/19/2002 1/21/2002 1/20/2002 Category D 1/21/2002 Category E 87 87 8787 87 87 fugiat nulla 87 87 87 87 . 0 1 Enhance the important parts of a page

consectetur 61% consectetur 42 Lorem ipsum 52% ADIPISCING Lorem ipsum dolor ADIPISCING -30% Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 60 40 20 0 80 Series 1 80 60 Series 1 40 20 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 1/10/2002 1/11/2002 1/12/2002 1/13/2002 1/14/2002 1/15/2002 1/16/2002 1/17/2002 Category A Category B 87 Category C 87 1/18/2002 1/17/2002 1/18/2002 1/19/2002 1/18/2002 1/20/2002 1/19/2002 1/21/2002 1/20/2002 Category D 87 Category E 87 fugiat nulla 87 87 87 87 fugiat nulla 87 87 1/21/2002 87 87 87 . 0 1 Enhance the important parts of a page

consectetur 61% consectetur 42 Lorem ipsum 52% ADIPISCING Lorem ipsum dolor ADIPISCING -30% Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod 60 40 20 0 80 Series 1 80 60 Series 1 40 20 1/5/2002 1/6/2002 1/7/2002 1/8/2002 1/9/2002 1/10/2002 1/11/2002 1/12/2002 1/13/2002 1/14/2002 1/15/2002 1/16/2002 1/17/2002 Category A Category B 87 Category C 87 1/18/2002 1/17/2002 1/18/2002 1/19/2002 1/18/2002 1/20/2002 1/19/2002 1/21/2002 1/20/2002 Category D 87 Category E 87 fugiat nulla 87 87 87 87 fugiat nulla 87 87 1/21/2002 87 87 87 Success!!!

! s k n a Th Slides By Miguel Myers Questions? @Chass

Choosing the Right Charts http: //www. storytellingwithdata. com/blog/2013/04/chartchooser

Power BI Support Resources Contact Support Report Errors, Issues – Support. Power. BI. com Resources use presentation mode to click the hyperlinks Ø Ø Community. Power. BI. com – Community Forum Data Stories Gallery – Get inspired with Data Stories by other Power BI users R-Visuals Gallery – Get inspired by others use of R for analyzing their data Visuals. Power. BI. com – Custom PBI visuals and R visuals you can download and use in your story Ø Power BI Blog - weekly updates Ø Ø User Voice for Power BI – Vote on (or submit) your favorite new ideas for Power BI Issues. Power. BI. Com – log issues with the community Ø Ø Whitepaper - Creating an Enterprise Class Dashboard Solution with Power BI Guided Learning Self Service Power BI training Ø DAX Formula Language – syntax for DAX Ø DAX Patterns – Great website to learn new patterns for the DAX Language Ø Power Query Formula Language – syntax for the “Query” language Instructors:

BASIC FRAME

General Detailed

SPLIT FRAME

General Detailed

SIX FRAME

General Detailed

General Detailed

QUARTER GRID

General Detailed

General Detailed

THIRDS GRID

General Detailed

General Detailed

General Detailed

HERO THIRDS

General Detailed

General Detailed

General Detailed