| The data is in the system! Yes, that's right. Whatever | | | | to capture has already changed. Therefore, a lot of |
| you want to know about your business, your | | | | people resort to using Excel to present the |
| customers' spending patterns, your stock level, your | | | | information they need to their bosses. And without |
| financial performance, your customers' profile, and | | | | good Excel Skills, it is going to be a painful process |
| many other questions you want answered. | | | | for them. |
| Citibank, in an article published in 6 Dec 2005 of | | | | You can make use of readily available worksheet |
| Singapore Digital Life, reveals that theyuse the data | | | | functions to transform those raw data from the |
| in their system to identify customers who fit their | | | | system, present them as useful business information |
| assumptions of the potential customer base like age, | | | | used for making critical business decisionand planning. |
| salary and spending behaviour. | | | | For those working in big corporations, you do not |
| Business Intelligence is not confined to BIG | | | | have to rely on your IT department to generate the |
| companies. A specialised system normally can cost | | | | reports for you. You will learn how to analyse those |
| tens and hundreds of thousands. But there are | | | | data using readily available function provided by Excel. |
| always alternative and the solution is right in your | | | | For SME, you do not need a powerful BI system to |
| computer. Excel is a powerful BI tool that is | | | | get what the big companies are getting. Using Excel, |
| commonly used in Europe and US. The question is: Do | | | | you can make the data become valuable to your |
| you know how? | | | | business without the need to purchase any software. |
| Using Excel, a travel agency was able to profile their | | | | All you need is to make Excel comes in power and |
| customers using the data they have diligently | | | | you will be able to gain insights into your business like |
| captured into Gilboa, a travel management system. | | | | never before. |
| They were able to identify their niche and to allocate | | | | A combination of Excel and MsQuery provide the |
| the optimal amount of resources to grow their | | | | most direct way to tap into databases and retrieve |
| customer base. And they spent only a fraction of the | | | | those information real-time so that you could prepare |
| cost big companies are paying because they use | | | | your report with ease. I used to use Excel to tap |
| tools they already owned, that is, Microsoft Excel. | | | | into our accounting database server directly and |
| For big companies, an expensive system does not | | | | create my financial statements. When it is set up, I |
| necessary mean they are able to get the data they | | | | just need to open the file and the statements will be |
| want. From system design to implementation will take | | | | refreshed without me having to do anything. It |
| at least 6 month and as long as 2 years. By the time | | | | makes closing the account a breeze for me. |
| the system is launched, the business environment | | | | Is the evidence strong enough for you to use Excel |
| would have changed and the information they need | | | | as a tool for business intelligence? |