Transcript Document
JustFoodERP BIG PICTURE REPORTING What does reporting mean to our customers? Standard Documents Self-serve Business Intelligence Scheduling Online vs. Offline Notifications Onsite vs. Remote JustFoodERP Reporting Strategy Native Reports Business Charts Role Center Notifications SharePoint Alerts Reporting Services Standard Reports and Charts Business Notifications Self-serve Dashboards & Insights Generic Charts Send to Excel Power BI (Power Pivot, Power View, Power Query, Power Map) Data Models/Cubes Power BI SharePoint Portals KPIs Standard Reports and Charts DEMO Self-serve Generic Chart and Send to Excel DEMO Power BI for Excel Power Pivot Power View • Data Modeling • Create a sophisticated Data Model directly in Excel • Explore and Visualize • Create reports and analytical views with interactive data visualizations Power Map Power Query • 3D Geo-visualization • Explore and navigate geospatial data on a 3D map experience in Excel • Data Discovery • Easily discover and connect to data from public and corporate data sources Power BI for Office 365 Power BI for Excel Power Pivot Power View Power Map Power Query Power BI Sites • Share, view, and interact with reports in these collaborative Power BI sites Power BI Q&A Power BI App • Use natural language queries to find, explore, and report over your data • View reports on the go, with the Power BI Windows Store app Power BI for Excel DEMO Power Pivot and Power View add-ins for Excel Business Notifications Instead of running reports to identify the issues, have the issues come to you when they happen! Events • Email notification triggered by an event in JustFoodERP SharePoint • Automate data refresh • Alerts SQL Server Reporting Services • Schedule and Distribute • Publish data to RSS feed and subscribe to feed in Outlook Event Notifications DEMO Only 30% of potential BI users adopt standard BI tools -Forrester Research Dashboards & Insights SALES GENERAL LEDGER ACCOUNT SCHEDULES MANUFACTURING FIXED ASSETS RECEIVABLES PURCHASE INVENTORY PAYABLES SALES ORDERS PURCHASE ORDERS JOBS AND RESOURCES SERVICE MANAGEMENT WAREHOUSE Power BI for Office 365 Power BI for Excel Power Pivot Power View Power Map Power Query Power BI Sites • Share, view, and interact with reports in these collaborative Power BI sites Power BI Q&A Power BI App • Use natural language queries to find, explore, and report over your data • View reports on the go, with the Power BI Windows Store app Comprehensive Templates Reporting Strategy MOBILITY Access JustFoodERP from any device anywhere using a web browser!! Display JustFoodERP pages and reports inside SharePoint! Free Windows Store App Works with Power BI site on Office 365 Gartner Group Magic Quadrant for Business Intelligence and Analytics Platform “Microsoft has made early investments in its cloud-based BI offering, Power BI. Microsoft's strategy is to use the cloud to increase adoption of its new and most competitive BI capabilities in Excel (starting with Excel 2013), and to accelerate enhancements to Excel to every six months.” - Gartner JustFoodERP Reporting Strategy Native Reports Business Charts Role Center Notifications SharePoint Alerts Reporting Services Standard Reports and Charts Business Notifications Self-serve Dashboards & Insights Generic Charts Send to Excel Power BI (Power Pivot, Power View, Power Query, Power Map) Data Models/Cubes Power BI SharePoint Portals KPIs