COVID-19 UPDATES For the latest information regarding IIBS operations, please contact info@iibscollege.ca
+1-905-268-0958
Apply Now

Data Analytics and Reporting

PROGRAM OVERVIEW

Data Analytics and Reporting (with SAP SAC, Microsoft Power BI and Tableau) is a highly flexible and curated course designed based on the market latest research, combining 3 opportunity factors into one course i.e., SAC, Microsoft Power BI and Tableau, to raise the dual probability of availing better job with high salary.

CAREER OPPORTUNITIES

Get trained to work. Prepare for Job Titles such as- Reporting Analyst, Data Analyst, Financial Analyst, BI Consultant, Sales Analyst. Get all the cloud analytics features you need – business intelligence (BI), augmented analytics, predictive analytics, and enterprise planning – in a single solution. Optimize BI efforts with embedded analytics. Become a Data Science Influencer. This is a knowledge-packed professional learning experience that includes a cutting-edge curriculum, real business projects and case studies, and tech-enabled education. Our training goes a long way towards helping you unlock lucrative career opportunities in the coveted fields of Data Analytics. SAP Analytics Cloud is already transforming how decisions are made by thousands of its customers covering over 75 countries. By joining them and using SAP Analytics Cloud you can provide everyone in your organization with the insights they need to make better decisions and act with confidence.

ADMISSION REQUIREMENTS

  • An Ontario Secondary School Diploma or equivalent
  • Students are 18 years of age or older
  • Have met all additional requirements established by the private career college for the program

Course Outline:

Data Analytics and Reporting

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.

    Request Info!

    Fill in the form below and we will contact you as soon as possible.

    I understand that by submitting this form, I consent to be contacted by email, phone, text message or any other form of communication by IIBS College. My consent can be withdrawn at any time.

    Department Contact Info

    Business

    IIBS Mississauga (PCC Location)
    151 City Center Drive
    Suite #403.
    Mississauga, ON, L5B 1M76

    +1-905-268-0958
    info@iibscollege.ca

    Student Resources