broken image
broken image
broken image
  • Home
  • Solutions 
    • Custom BI
    • HoReCa BI
  • Business Intelligence
  • Technology
  • Our Customers
  • About us
  • Contact us
  • …  
    • Home
    • Solutions 
      • Custom BI
      • HoReCa BI
    • Business Intelligence
    • Technology
    • Our Customers
    • About us
    • Contact us
    Support
    broken image
    broken image
    broken image
    • Home
    • Solutions 
      • Custom BI
      • HoReCa BI
    • Business Intelligence
    • Technology
    • Our Customers
    • About us
    • Contact us
    • …  
      • Home
      • Solutions 
        • Custom BI
        • HoReCa BI
      • Business Intelligence
      • Technology
      • Our Customers
      • About us
      • Contact us
      Support
      broken image

      KC Firiakis – Financial Reporting

      Overview

      KC Firiakis is a service provider group of more than 50 companies. Navision is the accounting system used by KC Firiakis.

      One of the main problems is that the financial statements for each company and the consolidation accounts were done manually.

      Therefore:

      • Many hours of work required
      • Unavoidable human errors
      • No 100% control of the transactions
      broken image

      Approach

      Using SQL SSIS, we extracted the data from different databases (Navision), then we transformed the data, and finally loaded the data into a single Data Warehouse (SQL Server Database Engine).

      Then we created a multidimensional cube (SSAS). An Analysis Services multidimensional solution uses cube structures for analysing business data across multiple dimensions and calculations.

      One of the key advantages of cube architecture is the simplicity in slicing and dicing the data. The tools that we used to make this easy is the Pivot Table.

      For example, one of the dimensions is the ‘Company’ dimension, one dimension is the ‘account code’, and one dimension is the ‘account description’. Therefore, you can see for example for each company for all, or selected, accounts the opening balance, debit movement, credit movement, net movement and closing balance, and therefore the balance sheet and the Profit and loss or the consolidated balance sheet and profit and loss.

      In addition, calculations such us PY credit movement, YTD credit movements etc. could be created.

      Results

      KC Firiakis has a tool which is updated automatically every day from Navision.

      With this tool the client can see:

      • All the balances/movements whenever he wants
      • Compare with PY, PY YTD etc.
      • Compare Companies
      • Consolidate Companies
      • Use filters (Company, employee, department, bank, brand, vendor, account etc.)

      Conclusion

      The client saves a lot of time of manual work. Therefore, there is more available time for analysis and strategic decisions.

      broken image

      In addition, this tool is a good control for the accounting system as mistakes due to the human factor can be easily avoided or identified.

      In addition, all the data continue to be consistent and organized over time.

      Subscribe
      Previous
      Alphamega - Finance Cube
      Next
      Lanitis EC Holdings - Consolidation Finance Cube
       Return to site
      Profile picture
      Cancel
      Cookie Use
      We use cookies to improve browsing experience, security, and data collection. By accepting, you agree to the use of cookies for advertising and analytics. You can change your cookie settings at any time. Learn More
      Accept all
      Settings
      Decline All
      Cookie Settings
      Necessary Cookies
      These cookies enable core functionality such as security, network management, and accessibility. These cookies can’t be switched off.
      Analytics Cookies
      These cookies help us better understand how visitors interact with our website and help us discover errors.
      Preferences Cookies
      These cookies allow the website to remember choices you've made to provide enhanced functionality and personalization.
      Save