1 / 42

Next Generation Power BI Portals

Next Generation Power BI Portals. David M Feldman. Sr. Technical Director SharePoint & Analytics. Please tweet using any of these tags @ BostonMusicDave # PowerBI , #SPSBOS, #ATRIONRI,. Who is this guy Dave?. http://bit.ly/SharePointBI. Self Service BI Evolution.

ednaa
Download Presentation

Next Generation Power BI Portals

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Next Generation Power BI Portals David M Feldman Sr. Technical Director SharePoint & Analytics

  2. Please tweet using any of these tags @BostonMusicDave#PowerBI, #SPSBOS, #ATRIONRI,

  3. Who is this guy Dave? http://bit.ly/SharePointBI

  4. Self Service BI Evolution 1st WaveTechnical BI 2nd WaveSelf Service BI 3rd WaveEnd User BI 1st WaveTechnical BI 2nd WaveSelf Service BI 3rd WaveEnd User BI IT End User Analyst End User Everyone

  5. 1st Wave of BI: IT - 1996 OLAP Services, Analysis Service, Unified Dimensional Model, MDX

  6. 2nd Wave of BI: Analysts 2008 2010 Products of the Year: PowerPivot “PowerPivot to BI is what the printing press was to literacy…” Microsoft PowerPivot, Excel Data Model, Microsoft PowerView, Tableau, Spotfire…..

  7. 3rd Wave of BI: Everyone Technical BI Self Service BI End User BI SaaS, Power BI Dashboards, Power BI Designer

  8. Tools & Platforms Technical Analyst End User

  9. Powered by Modern Data Sources ? Your App

  10. Refreshable Data Sources with Excel & Power Query In Power BI Designer or Excel, you can query, import, and create reports from your on-premises organizational data from sources like SQL Server. However, from Power BI Preview, we currently do not support refreshing datasets connected to on-premises data sources other than Analysis Services Tabular

  11. Create Power BI Content with Power BI Designer • Free download • Combines Power Query, Power Pivot, and Power View into a desktop application • Focused around interactive visualization and analysis • Outputs reports or easily publishes to Power BI Service • Updated monthly

  12. DemoExcelData

  13. DemoPower BIDesigner

  14. DemoAnalysis ServicesConnector

  15. DemoAzure Stream Insight

  16. Agenda • Topic 1 • Topic 2 • Topic 3

  17. TOPIC 1

  18. Slide Title (Note: Slide titles must be one line only) • Bullet 1 • Bullet 2 • Bullet 3

  19. Bullet 1 • Bullet 2 • Bullet 3

  20. Slide Title Category 1 Category 2 • Bullet 1 • Bullet 2 • Bullet 3 • Bullet 1 • Bullet 2 • Bullet 3

  21. Slide Title

  22. Picture Slide Title Picture Title

  23. QUESTIONS

  24. A Few Custom Slide Designs for Your Use

  25. Slide Title Item 1 Item 2 Item 3

  26. Slide Title Item Item Item Item Axis 2 Axis 1

  27. Slide Title

  28. Presentation Style Guide

  29. Sample Title Slide Presenter Name Title

  30. Right edge limit for all text [5.50] Left edge for logo only [6.42] Left edge for title text and byline [5.50] Top edge for title text box (not the text itself) [1.50] Top edge for byline text box (not the text itself) [2.17] Bottom edge limit all text [3.00] Leveraging Corporate BrandingAssets for Presentation Museo Sans 100 54 pt. Align left Spacing condensed by 1pt. Vertical alignment: top Do not autofit All margins: 0 Museo Sans 100 24 pt. Align left Spacing normal Vertical alignment: top Do not autofit All margins: 0 Garry Foisy Sr. Director, Marketing Museo Sans 100 20 pt.

  31. Theme Fonts • Museo Sans 100 • Primarily used at font sizes of 32 and above • Museo Sans 300 • Primarily used for body/paragraph text • Museo Sans 500 • Primarily used for section titles • Museo Sans 700 • May be used for emphasis, such as highlighting words within body text

  32. Basic Font Usage • This is a Section Title Set in Museo Sans 500, 28pt. • This is standard paragraph text. It’s set in Museo Sans 300, 24pt. The top of this text box is the top limit for content placement. Its left and right edges are also limits for content width. The box has the following properties: • Vertical alignment: top • Resize to fit text • Margins: 0 • Wrap text in shape is enabled • Note: The font sizes mentioned above are suggestions, and may not fit every situation.

  33. Bulleted Lists • A Short List with a Title • Set in Museo Sans 300, 24pt. • Round bullets • Bullet color is Dark Teal, Accent 1 • Font size may be reduced to accommodate longer text (see example at right) • A Very Long List with a Title • Set in Museo Sans 300, 16pt. • Font size depends on length of content • Current text box is set to “Resize shape to fit text” • Alternatively, use “Shrink text on overflow” • Maecenas id odio ac magna dapibus molestie id nec • Maecenas vel diam sed nibh pulvinar faucibus a non • Suspendisse commodo arcu eget neque dignissim • Cras sed urna ultrices risus tristique semper. • Pellentesque dignissim orci in nisl sagittis, ut facilisis • Lorem ipsum dolor sit amet, consectetur adipiscing • Ut eu turpis vitae nisi accumsan cursus laoreet sit • Fusce dignissim elit sed ipsum mattis elementum • Maecenas id odio ac magna dapibus molestie id nec • Maecenas vel diam sed nibh pulvinar faucibus a non • Suspendisse commodo arcu eget neque dignissim Note: Text color of the list titles is optional, but if used, the color should be Dark Teal, Accent 1, and all lists within the presentation that have titles should use the same color.

  34. Footnotes Footnotes may be used to provide explanations, citations, etc. Marking footnotes with an asterisk is not necessary in all cases.* *This is a footnote set in Museo Sans 300, 18pt, Dark Teal, Accent 1. Footnotes might be lengthy, and the font size can be adjusted down to accommodate longer text, but should not be larger than 18pt.

  35. Content Margins Left limit [5.83] Right limit [5.83] Bottom limit [3.00] Top limit [2.08] CONTENT REGION (Measurements are from center of slide)

  36. Theme Colors Atrion PPT Palette 1 Black Not actually part of the theme, but may be used for fills and shapes. Grey-80% Text 1 Used for the majority of body text. White Background 2 Mainly used for fills. Not actually white, although PowerPoint considers it to be. White Background 1 Mainly used for backgrounds or text that appears on dark colored backgrounds. Dark Teal Text 2 Mainly used for backgrounds or fills. Dark Teal Accent 1 Can be used for text, such as footnotes, titles, etc. or as a fill color. Light Blue Accent 2 Can be used as a fill or accent color. Dark Red Accent 3 Can be used as a fill or accent color. Dark Red Accent 4 Can be used as a fill or accent color. Red Accent 5 Can be used as a fill or accent color. This is also the color of the red block in the Atrion logo on the cover slide. Orange Accent 6 Can be used as a fill or accent color. This is also the color of the red block in the Atrion logo on the cover slide. Subject to change.

  37. Example Color Usage This is also an example of table styling

  38. Poster Slide Example The following slide is an example of a poster slide that may be used to separate sections of a presentation (such as “LUNCH BREAK”) or serve as a final slide (such as “THANK YOU”). The text is set in Museo Sans 300, 40pt. ALL CAPS. The text should be kept to 1-4 words across 1-3 lines. If the chosen text is very close to fitting, but needs to be reduced in size, do not reduce it below 32pt.

  39. THANK YOU

More Related