- Certificate of completion - Free
- Tutor is available to students
This specialist course developed in-house by our Business Intelligence and Analytics Specialists will enable you to fully understand what Management Information Reporting entails and its value to businesses and their development. Also, it will give you all the necessary skills in advanced Excel with visual basic (VBA). You will be able to write and understand advanced macros to automate work and extend Excel features by programming add-ins and functions. Also, you will be able to manage all the Metrics and KPI’s to be implemented in your Reports, providing you an Introduction to Data Warehousing and how to produce and maintain Dashboards.
Digital certificate - Included
Course Unit 1: Building Applications with Advanced Microsoft Excel VBA
Course Unit 2: Management Information Reporting (MIR)
1. Decision Making
• Effective Decision Making
• Steps to Making Effective Decisions
2. Introduction to Management Information Reporting
• Sources of Information and Data
• Uses of Management Information Reporting
3. Enterprise Performance Management
• Defining and Communicating Strategy
• Measuring Performance
• Analysing Performance
• Reporting and reviewing Performance
• Aligning People and Culture
4. Organisational Level and Reports
5. Key Performance Indicators
• What are Key Performance Indicators
• Benefit of KPI’s
• KPI Planning
• KPI metrics
• Identify KPI
6. HR metrics
• Turnover Rate
• Cost Per Hire
• Human Capital ROI
• Inventory to Sales Ratio
7. Service Level Agreement
• Introduction to SLA
• Why SLA is important to Management Information Reporting
• How to use and apply SLA to reports
8. Financial Metrics
9. Marketing/Sales Metrics
10. Designing and Planning Management Information Reports
• Approach to Data Reporting
• Accessing and updating live data from underlying accounting systems
• Implementing key performance indicators and benchmarking
• Building a tailored front end reporting system
• Drill down by different sectors, departments, timeframes or any other user defined variables
• Producing a budgeting model
11. Data Analysis lifecycle
• Using Information and Data Strategy to Analyse Business Objects
12. Data Sources
• Transactional Data
• Business operational Data
• Lifestytatic Report
13. Static Reports
14. Data Preparation and how to identify and deal with missing values
• Importing and Exporting Data
15. Quality Assurance
16. Identifying the right Chart
• Proportion of the Whole
• Column Charts
• Bar Charts
• Line Charts
• Combination Charts
• Sparkline, Data Bars
17. Identifying what you want to say
• Proportion of the Whole
• Trend Analysis
• Relationships
• Comparison
• Distribution
18. Trend Analysis
• Visualisation of trend Analysis
19. Data Visualisation in report
• Common Data visualization Issues
20. Pattern Recognition in Data and Charts
21. Database types
• Transactional Database
• Analytical Database
22. Introduction to Data Warehousing
• Definition of Data Warehousing
• Benefits and challenges of Data Warehousing
• Data Warehousing architecture
• Data mart
• Star Schema
• Snowflake Schema
23. Balance scorecards
24. Dashboards
• What is a Dashboard
• Categorizing Dashboards
• Establishing the user Requirement for Dashboard
• Building a Dynamic report
• Creating Dashboards using Power Pivot Tool
• Creating visually appealing dashboards and group summaries
25. Customer-Based Reports
• Customer Segmentation
• Behavioural analysis
Currently there are no reviews for this course. Be the first to leave a review.
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.