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.

Frontrunners

Source : http://www.softwareadvice.com/bi/#top-products

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 (https://www.youtube.com/channel/UCSpDVQaW2d_lTWswK4MJWWQ).

Advertisements

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 (https://ph.linkedin.com/in/michael-ela-89500125)

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 (https://www.youtube.com/channel/UCSpDVQaW2d_lTWswK4MJWWQ).