Leap Forth

  • About
  • Business Intelligence
  • Accounting
  • Consulting
  • Learning
  • Contact
  • About
  • Business Intelligence
  • Accounting
  • Consulting
  • Learning
  • Contact

Feed the mind

Excel Ad in 1992

21/11/2019

0 Comments

 
That was then. Now is Power BI. The Excel killer?
Picture
0 Comments

Data Studio - Data Blending is finally here

14/7/2018

0 Comments

 
Data blending or creating relationship with multiple data sources is one of the most useful features in reporting.

By default, charts in Data Studio get their information from a single data source. Blending lets you create charts based on multiple data sources, called a blended data source. For example, you can blend two different Google Analytics data sources to track the performance of your app and website in a single visualization.
​
Blending can reveal valuable relationships between your data sets. Creating blended charts directly in Data Studio removes the need to manipulate your data in other applications first, saving you time and effort.
0 Comments

Business Intelligence Tool - Introduction to Power BI

24/5/2016

0 Comments

 
Picture
Power BI is a suite of business analytics tools to analyze data and share insights. Power BI dashboards provide a 360-degree view for business users with their most important metrics in one place, updated in real time, and available on all of their devices. With one click, users can explore the data behind their dashboard using intuitive tools that make finding answers easy.

​Creating a dashboard is simple thanks to over 50 connections to popular business applications, complete with pre-built dashboards crafted by experts that help you get up and running quickly. And you can access your data and reports from anywhere with the Power BI Mobile apps, which update automatically with any changes to your data.
​
If you are a data analyst delivering reporting and analytics to your organization, Power BI lets you be productive and creative with what you build. Power BI Desktop is a feature-rich data mashup and report authoring tool. Combine data from disparate databases, files, and web services with visual tools that help you understand and fix data quality and formatting issues automatically. With over 20 built-in visuals and a vibrant community of custom visualizations, create stunning reports that communicate your message effectively. With the Power BI service, publish reports securely to your organization and setup automatic data refresh so everyone has the latest information.

Power BI can unify all of your organization’s data, whether in the cloud or on-premises. Using the Power BI gateways, you can connect SQL Server databases, Analysis Services models, and many other data sources to your same dashboards in Power BI. If you already have reporting portals or applications, embed Power BI reports and dashboards for a unified experience.

0 Comments

Move from Excel to Accounting Software

28/5/2015

0 Comments

 
Small businesses often start out using Excel – but that’s only doable up until a point. Like every teenager eventually becomes an adult, your business needs to evolve and grow. Find out why the smartest organisations are using online accounting software instead.

Why Excel isn’t a long term solution

Excel can do a large number of tasks, is easily available and is very widely used in the world of business. And it would be wrong not to not acknowledge this up front. However, while the application is sturdy, it’s the spreadsheets created while using it that aren’t – and this often causes issues down the track.

Seven reasons why accounting software is better than Excel
  1. Hit the ground running with confidence
  2. Your company’s real-time financial data is kept in one central place – online, in the cloud
  3. Out-of-box reports. Get most of the reports you will ever need, with a few clicks
  4. Up-to-date information and ready to share
  5. You’ll have a clean audit trail
  6. It syncs with other business applications
  7. Access to data anywhere, anytime 

It's about letting your business grow


While it can often be hard to alter the way you do business and embrace change, the potential rewards are huge. The truth is, the writing is on the wall if you don’t find it easy to quickly manage your day-to-day business using Excel.

Excel was simply not built to replace accounting software – so it’s time to give your business the room to grow and succeed, without restrictions.

Extracted from Xero Guides to Small Business.
0 Comments

Get a real-time view of your cash flow

29/4/2015

0 Comments

 
Cash is not king. Cash flow is. 

If you are running a business, you need to be updated on your cash flow. How? The best is to have automatic bank feeds directly into your accounting software, real-time.

With Xero online accounting software, you can log in online anytime, anywhere on your Mac, PC, tablet or phone and see up-to-date financials. It is small business accounting software that’s simple, smart and occasionally magical.

Xero has all the time-saving tools you need to grow your business: unlimited users and 24/7 support, not to mention the security and reliability you’d expect from Xero.

0 Comments

Accounting software - beyond MYOB and UBS

17/9/2013

5 Comments

 
Most SMEs in Malaysia are using either MYOB or UBS as their accounting software, which are essentially desktop software (meaning you have to purchase the software and install on your computer or server). You have to do your own regular backup and pay for upgrades when new versions are available.

With the emergence of cloud software, you now have more alternatives. You don't have to purchase and install accounting software anymore. 

Most cloud-based accounting software are on monthly subscription basis (which means no large upfront payment), nothing to install (just subscribe online and use immediately) and accessible anytime, anywhere using any devices (PC, notebook, smartphones, tablets etc). Free upgrades, unlimited users and backups are done by the software providers.

Some alternatives to MYOB and UBS include Wave Accounting (free software), XERO, Saasu (with inventory functionality), Quickbooks, Freshbooks, Yendo (with CRM functionality), Outright, Kashoo and LessAccounting.

Most of these software have free trial (without credit card details). Check it out to ensure that it meets your requirements. Consult your Accountant, if necessary.

There are more alternatives, particularly if you are in property management, legal services industry or non-profit, that have unique accounting needs. All these alternatives have a reputation for being user friendly, feature-packed, relatively inexpensive and suitable for small business. In most circumstances, you need not consider a more robust accounting solution such as NetSuite, OpenERP or SAP until you reach a much larger size.

Have fun selecting the right accounting software for your business.

5 Comments

Presentation for Malaysian Investor Relations Association

23/8/2013

0 Comments

 
Completed a presentation on "The Key to Enhancing Company Value - Understanding Effective Financial Management" organised by Malaysian Investor Relations Association (MIRA) in Bursa Malaysia. 

Participants include IR practitioners, company directors, CEO and other professionals from various industries. Shared the importance of financial management in enhancing company value.

Picture
0 Comments

Excel is the most dangerous software in the planet?

28/2/2013

0 Comments

 
"... So that’s one sense in which Excel could be dangerous: that we’ve tens of thousands, hundreds of thousands, of financiers and bankers throwing trillions of dollars around the markets on the basis of their incomplete spreadsheets and their ignorance of how they’re doing it wrong. Pretty scary really".  This was reported in Forbes.com here.

Yes, Microsoft Excel is indeed a very dangerous software - if not used probably.  In the hand of untrained Excel users, it will lead to costly errors that will lead to errors in decision.  Some of the common errors include using the wrong formula, did not update the spreadsheets, did not add up a column or row etc etc.  It may sound like silly mistakes but these are indeed common and costly errors.

Even if it does not lead to error in decision making, untrained Excel users wasted hours in spreadsheet design.  They treat Excel as a manual books with columns using rudimentary formulas, have multiple sheets and cross linked all these sheets, treat dates are words instead of numbers etc etc.  These actions can go on for years without realizing it.  To make it worse, the company employs more staffs to update the spreadsheets - which could have been fully automated in the first place.

Are you or your staffs using Excel? If yes, you need to be aware of how dangerous Excel is.  Here are some of the symptoms that you or your staffs are using Excel dangerously:

1. Spending too much time on spreadsheets (e.g. copy / paste, repetitive formulas etc)
2. Have to enter the same data more than once (usually in multiple sheets or files)
3. Using calculator to double check the spreadsheets (really, it happens)
4. Did not use pivot table (using pivot table is efficient as it does not involve formula)

What is the best way to avoid this dangerous software? The best is to avoid using Excel, if possible.  If your requirements are complex, it is best to invest in a rigorously tested customised software or suitable ERP system (which links your point of sale, inventory, accounting, reports etc).  

If you must use Excel (which is understandable), then make sure that you or your staffs are adequately trained.  In other words, do not just let anymore in your company (especially fresh graduates whom you do not know what to do with them) to design spreadsheets.  Train your staffs or get professional help.

Picture
0 Comments

    About

    Business, economy, education and current issues.  Providing tips, tricks and tools in managing business.


    Archives

    March 2022
    February 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012


    Tags

    All
    Accountant
    Accounting
    Active Listening
    Aeon
    Alibaba
    Allen Stanford
    Amy Cuddy
    Animation
    Articial Intelligence
    Bernanke
    BI
    Brain Rules
    Brene Brown
    Budget 2022
    Business
    Business Intelligence
    Business Model
    Cash Flow Management
    Ceo
    Change
    Cloud
    Coca-cola
    Collapse
    Covid-19
    Creativity
    Culture
    Daniel Zhang
    Dashboard
    Data Science
    Data Studio
    Digital
    Digital Free Trade Zone
    Disruption
    Dr Eric Berg
    Dr Oz
    Dr Richard Teo
    Economy
    Edmondson
    Edward De Bono
    Ego
    Eric Schmidt
    ESG
    Excel
    Exercise
    Failure
    Farmland
    Finance
    First Article
    Fraud
    Free
    Fund
    Garr Reynolds
    Gaur Gopal Das
    George Carlin
    Global Crisis
    Google
    Google Docs
    Growth
    GST Malaysia
    Harvard
    Harvard Business Review
    Health
    Hubdoc
    Inflation
    Innovation
    Inspiring
    Insurance
    Investment
    Ipo
    Jack Ma
    Jim Rogers
    John Kotter
    John Medina
    Kai Fu Lee
    Ken Segall
    Kicc
    Kiss
    KPI
    Leadership
    Liquidation
    M&A
    Machine Learning
    Management
    Managing Cash
    Maradona
    Marketing
    Mastermind
    Maxton
    McKinsey
    Meeting
    Meryl Streep
    Milton Friedman
    Mit
    Mohamed El-Erian
    Motivation
    Napolean Hil
    Negotiation
    Obesity
    Online Education
    Paperless
    Partners
    Peter Drucker
    Pimco
    Pivottable
    Play
    Power BI
    Powerpoint
    Presentation Zen
    Princeton
    Procter & Gamble
    Productivity
    Property
    Recovery
    Responsibility
    Rest
    Restructuring
    Retirement Planning
    Reverse Mortgage
    Robinson
    Roubini
    Salary
    Seth Godin
    Simplicity
    Sir Ken Robinson
    Sleep
    Smoking
    Startup
    Stephen Chow
    Steve Jobs
    Stress
    Sugata
    Tan Le
    Tax
    Team Work
    Technology
    Thomas Cook
    Tony Fernandes
    Toys R Us
    Valuation
    Vietnam
    Vistage
    Warren Buffet
    Wealth
    Welcome
    WeWork
    Xero


Powered by Create your own unique website with customizable templates.