Intelligence for your Business (Part 2)

On part 1 I have introduced Business Intelligence. On this part I will discuss the components that are important for BI.

  1. Data Sources – It’s going to be the sources of your data like from the warehouse to the cashier or other processes that your business have. A good question here is what data are you going to store and how are you going to input them? The ideal here is to have a tool that will make it easy for your employee to input data. The easier they input data without error the better. Another important point here is the quality of data that they are accurate. You’ll need to select the best Point of Sale (POS) out there. MS Excel can also be a good tool with it’s automation capability because of Visual Basic for Application.
  2. Data Storage/Warehouse – It is how and where are you or your tool is going to store your data. Are you going to use a database, spreadsheets or text files? What is important here is that you can query or retrieve data easily when you need it. Here where ETL process happen (Extraction, Transformation and Loading) <br />
  3. Online Analytical Processing (OLAP) – resides between the database server and the reporting tools.  It summarizes some of the data during off hours to make querying of information faster.
  4. Data Visualization and Analysis  –  Here’s when you extract data and present the data visually using graphs, dashboards, OLTP and tables so you can easily analyze it and gain insight from it.




Intelligence for your Business (Part 1)

If you are operating a small cafeteria or a small sari sari store business, maybe you can make business decision easily using your gut without a need for any computer systems. However, if you want to expand your business and increase your revenue and be competitive in the market, You’ll need some kind of system that will provide a timely information or insight about your product or services and operation that will help you make intelligent business decisions, that’s what Business Intelligence (BI) is for, because  it is going to be very costly to make a wrong business decision without it.  Basically, BI is about having a system or tool that can gather information in different areas of your business and store and retrieve those data to be able to analyze and visualize them at any given time to produce useful information and insight about your business that you can use when you need to make some decision,

With BI you’ll be able to answer questions critical to the growth of your business such as,

What are your bottlenecks or challenges? What are your opportunities.
What are your top problems?

What are your top 10 or best selling products?

What hour your employees are most productive?

How long should you wait buying new stocks?

What products are trending down or trending up based on season?

What time of day you should have more staffing?

Big corporations like BPOs and Electronic Manufacturing are big when it comes to BI, They hire a lot of people who are expert on it.  It is the only way they can remain competitive and survive or else the competition will eliminate them. They use BI to  project their growth and set their objectives and goals on the next 5 or 10 years,

Having said these things, Here are the front-runners BI systems out there.


Source :

But if your business is still small, you don’t need these sophisticated software yet. You can just use MS Excel and MS Access to build your  BI.

In the future I’ll discuss how you can use Excel as your BI tool and also I’ll talk about the components of BI.

That’s all for now. If you like this blog please click follow and subscribe to my YouTube channel (

Mr. Pro Mike – An Introduction. 

Hello World!

This is Mr Pro Mike and welcome to my blog site.

I created this blog site to share and talk about my expertise in data analysis and programming. Hopefully, you can gain insights and new knowledge that will help you do better in your job or in your business.

What is Mr Pro Mike?

Mr Pro Mike stands for Mr obviously I am a guy, Pro means three things, 1) Professional, 2) Problem Solver and 3) Programmer, and Mike is my nick name.

A Little Background

I’m a graduate of Computer Engineering at Adamson University batch 1999. My first job was with Fujitsu hard disk drive manufacturing. I was at first a diagnosis/process engineer, then a failure analysis engineer and lastly a Test Schedule Development Engineer. I worked there for seven years and seven months.  My 2nd and current company is Sykes Asia. At first I was a Database Analyst then I became a Report Writer and now I’m a Software Engineer. I am with Sykes now for more than eight years.

In more than 14 years of my working life I do data analysis and programming almost every working day.  I have created hundreds of tools and automatons. I became a seasoned programmer using several tools and programming languages like C#, Visual Basic,  Bash Unix Scripting,  JavaScript, SQL to name a few but my expertise really is problem solving. My company hired me not because I can write cool programs but because I can help solve a lot of their problems. My objective is to help you solve your problems at work or in your business.

If you are interested to know more about me and the details of my skill set feel free to check my LinkedIn profile (

If you like this blog, please subscribe also to my YouTube channel where I am going to post all my thoughts, tips, tricks in programming . Just seach Mr Pro Mike or click this link (