M Management Reporting 2015 Lets Get Started 1
- Slides: 25
M Management Reporting 2015 Let’s Get Started… 1
Management information systems (MIS), produce fixed, regularly scheduled reports based on data extracted and summarized from the firm’s underlying transaction processing systems[3] to middle and operational level managers to identify and inform structured and semi-structured decision problems. Decision support systems (DSS) are computer program applications used by middle and higher management to compile information from a wide range of sources to support problem solving and decision making. A DSS is used mostly for semi-structured and unstructured decision problems. Executive information systems (EIS) is a reporting tool that provides quick access to summarized reports coming from all company levels and departments such as accounting, human resources and operations. -----------------------------------------------------------------------------------------------Hierarchy of reporting – methods of delivery (reports, dashboards & KPI’s, BI Excel cubes) = 446 options – we need to pick a top 10 to get started! Method Count System Type Notes NAV – core reports 36 modules, 286 reports MIS Has report writer to tailor each report NAV Dashboards 32 role based EIS Jet Reports - essential 36 MIS & DSS SQL reports CRM – core reports 3 modules, 25 reports MIS CRM dashboards 3 core, unlimited EIS SQL reports - Vox ISM 22 provided by VOX MIS & DSS BI cubes 4 cubes, each cube has 10 views DSS Flash reports 1 EIS Use SQL subscription, automatic daily email Audits 1 DSS Great for inventory control Each report has variables 2
Traditional ERP Reports Written in native NAV language, old, ugly, not flexible. Ops Manager SSRS Reports, Audits, Inquiry NAV Role Center 3
Simple Operational Report Ops Manager SSRS Reports, Audits, Inquiry NAV Role Center This is written in SQL, main benefit is that you get options (variables) at the top. This report is really 7 reports. 4
Financial Report Writer CFO/Owner Score Cards, KPIS, Flash Reports, Mobile Dashboard, Jet Reports 5
Examples of Jet Reports CFO/Owner Score Cards, KPIS, Flash Reports, Mobile Dashboard, Jet Reports Each report will take an hour to connect to your d. B structure 6
3 types of Dashboards – NAV below Each dashboard is configurable Front-Line Worker ERP/CRM 7
8
9
Slicers vs Subscription 10
Ad-hoc Queries Front-Line Worker ERP/CRM 11
Ad-hoc Graphs Front-Line Worker ERP/CRM 12
Complex Operational Report Ops Manager SSRS Reports, Audits, Inquiry NAV Role Center 13
Example of Audit Ops Manager SSRS Reports, Audits, Inquiry NAV Role Center 14
Automatic Reminders to Vendors Ops Manager SSRS Reports, Audits, Inquiry NAV Role Center 15
Shop Floor Inquiry - mobile Ops Manager SSRS Reports, Audits, Inquiry NAV Role Center 16
Example of Score Card (KPI’s) CFO/Owner Score Cards, KPIS, Flash Reports, Mobile Dashboard, Jet Reports 17
Example of Flash Report CFO/Owner Score Cards, KPIS, Flash Reports, Mobile Dashboard, Jet Reports AR 18
4 BI cubes – Sales, Supply Chain, Manufacturing, & Accounting 19
BI cube drill down All NAV variables are connected to the Excel cube 20
Example of BI Inventory Analyst Excel/Power BI 21
Power BI – example of sales by location Analyst Excel/Power BI 22
What-If Analysis Analyst Excel/Power BI 23
What Technology vs Effort $$$ Easy Hard Typical work effort, cost $$ Flash Report Excel BI cubes Dashboards Core Reports KPI, Score. Card NAV custom rep orts Operational Rep orts and Audits
“Best Practice Recommendations” – what I did, Jim’s top 10 to get started, effort = Reports Method Note/report name Income Jet Reports 4 Options a) 80’s style Jet report b) GL Income Statement c) Profit and Loss Variance d) Company Overview Balance Sheet Jet Reports e) In company Overview Cash NAV module Aged Receivables SSRS + CRM AR Dashboard Sales from CRM Dashboard Jim’s Sales Dashboard Operations NAV Dashboard Small Business Role Center BI cube Sales BI Cube Flash report SSRS Report 25
- Lets get started images
- Get into/out of
- One direction - one thing
- Lets get a lock for this thing cartoon
- English for presentation unit 1
- How to get started with soar?
- Rancher slack channel
- Bcbs fep vision exclusive collection
- Let's get to know
- Jeff roark
- Excited to get started
- Get up get moving quiz
- Get up get moving quiz
- Get up get moving quiz
- Selection in pseudocode
- Get focused get results
- Get up get moving quiz
- Iso 9001 presentation
- Management review iso 9001 version 2015 muster
- What are the steps in performance management process
- The word report derived from
- Variable costing and segment reporting tools for management
- Individuals with access authority to general ledger
- Variable costing and segment reporting tools for management
- Variable costing and segment reporting tools for management
- Management reporting package