Data Analytics and Reporting with SAP SAC, Microsoft Power BI and Tableau

Introduction to Accounting

• Fundamentals of Accounting
• Basic concepts of recording journal entry
• Posting in Journal Ledger

Accounting for Receivables

• Identify different kinds of receivables.
• Recognition of accounts receivable
• Methods and bases to value receivables
• Notes receivables and their recognition.

Evaluate short term liquidity.

Long-lived Assets

• Distinguish between tangible and intangible capital assets.
• Cost principle to property plant equipment.
• Concept of Amortization
• Distinguish between revenue and capital expenditure.

Indicate how to capital asset are reporting in balance sheet.

Liabilities

• Explain different kinds of liabilities and their accounting.
• Disclosure requirements for contingencies.
• Advantages of issuing bonds over common stocks.
• Entries of issuing bonds and interest expense.
• Account for long term liabilities.
• Contrast the accounting for operating leases and capital leases.
• Analysis of long term liabilities

Compute the debt to total asset ratio, interest coverage and cash interest covera

Corporation-Dividends, Retained Earnings and Income reporting

• Prepare the entries for different kinds of dividends
• Identify the items that are reporting in Retained Earnings Statement.
• Prepare comprehensive shareholders equity section
• Concept of intra-period tax allocation

Compute earnings per share ratio, payout ratio and dividend yield

Managerial Accounting and Business Environment

• Difference between financial accounting and managerial accounting.
• Understand the role of management accountants in an organisation.
• Concept of managerial accounting.

Cost Terms, Concepts and Classification

• Identify the three basic cost elements in manufacture of a product.
• Distinguish between product and period cost
• Prepare a schedule of cost of goods manufactured.
• Cost terms variable and fixed cost.
• Differential cost and opportunity cost.

System Design and Job Order Costing

• Order Costing
• Compute predetermined over head rates
• Job order costing flow of cost
• Compute under and over allocated overhead cost
• Recording of journal entries

System Design and Process Costing

• Compare job costing and process costing.
• Determine flow of cost in process costing system.
• Determine equivalent units in a process costing system.
• Prepare a production report using the weighted average method.
• FIFO Method Production Reporting.
• Allocate service department cost to operational cost.
• Direct and step down method.

Budgeting

• Importance of business plan.
• Processes organizations use to create budgets.
• Prepare sales and production budget.
• Cash manufacturing cost.

Master budget.

Standard Cost

• Explain how direct material and direct labour are set.
• Compute the direct material and direct labour price and efficiency variances.
• Compute overhead cost variances.
• Record all standard cost and variances journal entries

Introduction to Advanced management Reporting

• Case study on different project
• Reporting of different departments in the company
• Comparison between different activities performed in the company.