• TECHNICAL INTRODUCTION TO ACCOUNTING ANALYTICS

How Data and Analytics in Accounting is changing the financial world

The Human Side of Data

Data Analytics Tools: Spreadsheets vs. Data Science Languages

Data Analytics in Managerial Accounting

Analytics in Auditing Overview

Data Analytics in Financial Accounting

Data Analytics in Taxes

Data Analytics in Systems Accounting

Conclusion 

• ACCOUNTING ANALYSIS AND ANALYTICS APPROACH

Pragmatic Enquiry of Accounting Data

Developing Analytical Thinking Mindset

Inductive and Deductive Reasoning

Advanced Analytics and Influence on accounting systems

Question Framing Context

Concept of Assembling Data

Calculating and Describing Results 

• PROPERTIES OF DATA

What is Data?

Data Types

Data and Decision Making

Structured and Unstructured Data

Wide Data vs. Long Data

Properties of a Tidy Dataframe

Data Dictionaries

Merging Data

Data Automation

Statistical Distributions of assembled data

Visualizing Data Relationships

• DATA VISUALIZATION 1 (Introduction to Microsoft Excel)

Why Visualize Data?

Visual Perception Principles

Data Visualization Building Blocks

Basic Chart Data

Scatter Plots

Bar Charts

Box and Whisker Plots

Line Charts

Maps

Financial Chart Data

Waterfall Charts

Candlestick Charts

Treemaps and Sunburst Charts

Sparklines and Facets

Charts to Use Sparingly

•  POWER BI

How to install Power BI Desktop

How to connect Power BI to different sources of data

How to create and manage relationships between data sets in Power BI

How to analyze and visualize data in Power BI

How to create interactive dashboards in Power BI

How to use power Add-ins in MS Excel & more

.                        

• PRACTICALMentoring Session
• Case Study 1: Analytics in finance A walk-through of an Overhead expenses allocation model: How it is built & its uses for budgeting, forecasting, analysis, and cost management
• Case Study 2: Applying the data visualization and analysis skills learned: A walk-through of a Debtors aged-analysis: Analyzing for business, visualizing with excel and the Power-BI.
• Positioning Yourself in the job market
• Group Assignment and presentation