An Intelligent Approach to Business Intelligence Tools

In my previous job as an external auditor, I remember being assigned as a trainer to promote a new business intelligence tool internally developed by a new venture team in one Ernst and Young (EY) office in the United Kingdom.  Our office here in the Philippines, being a local affiliate of EY needed to stay attuned to the latest trends in the global scene.  The tool aimed to simplify the audit process by providing quick links and dashboards to users to assess engagement status at a glance.  It also enabled the uploading of data from spreadsheets and the performance of financial analysis within the tool itself, allowing users to easily view year-to-year comparison of balances, as well as streamline the organization of audit evidences with the audit procedures within every milestone in the audit roadmap.  It provided a systematic approach to gathering, sorting, and filing the soft copies of audit working papers as well as handle the tedious task of monitoring their preparation and reviews.  At a glance, teams can say how far they have gone with their audits.

Business intelligence (BI) as a tool is relatively new and many business users still do not know how to actually take advantage of this technological innovation.  To inject this abruptly in an organization would prove detrimental due to resistance of people to change.  So, what now? After your organization has spent a big chunk of this year’s budget to these BI tools, how can the business users be influenced to utilize these?  How can organizations encourage a more effective use of business intelligence tools?

 

The tool developed by EY was a very helpful tool, and of course at a very expensive cost.  It was a giant move for EY to introduce this tool worldwide.  The promotion lasted for over a year before pilot testing was done on selected teams which included the team I was in during that time.  Based on my experience, in order to effectively implement this modern concept, a marketing approach needs to be considered during its introduction.  Here are some steps on how to do about this approach and why this has actually worked.

 

  1. Start with the “big fish”

A sudden full blown implementation is destined to fail.  Whether the tool is directed for use of customers or employees, it is always advisable to start with your organization’s big players since they are the ones with the most significant impact on the use of BI tools.  Begin the implementation roll-out with the top management, the biggest project teams, the higher-profit customers — their voice is the voice of the majority and is loud enough to cause revisions on the tool or on its implementation before a 100% roll-out is achieved.  Doing a pilot testing of the tool and focusing first on the few important players will help you fine-tune the tool before exploding to the repulse of the big crowd.

 

  1. Encourage co-creation

Once you have tapped the “big fish” in the organization, the next thing to do is gain their support.  You sold them the BI concept which they willingly bought.  Now is the time to make them partners in promoting the tool.  This is best achieved by making them feel part of the implementation process.  Gather their feedback and see which are valuable enough to be considered to give more value to the tool.  Doing this gives the big players a sense of ownership over the tool.

In my previous job, the big teams were selected for our tool’s pilot testing.  We had to meet weekly to attend webinars with other participants from all over the globe.  Webinar topics include the basic guidance on the proper usage of the tool and the required equipment.  We were also tasked to submit reports at certain points during the testing where we document our own team’s implementation plan and feedbacks on how effective the tool is for its purpose. In the process, the pilot teams were assigned to cascade the webinars to the other teams, thereby providing a venue for co-creation and collaboration.

 

  1. Implement a rewards program

To give credit to the teams that contributed valuable knowledge in the further development of the tool, a rewards system would prove enticing.  An organization may do this by compensating the efforts of the pilot teams through bonuses.  Another fun way is by letting everyone join a slogan-making contest or a propaganda video making for the new tool in exchange for prizes.

These will encourage more participation and support from the business users.

 

  1. Go big on ads and promos
Photo credit:  EY Global

 

Inform your business users of the upcoming improvements.  Release regular advisories or teasers to give everyone a heads-up that something big is about to land on your organization.  Create infographics and promotional videos to get people to start talking about this and also to lay out what these users may expect out of this new tool.  This will also help you gather initial reactions from the rest of your business users that will also facilitate the proper fine tuning to suit specific needs of the smaller players in the organization.

 

Aside from the pilot testing done for the big teams in EY, we also had a second wave of pilot testing for the small teams using the EY Canvas version applicable for smaller engagements.  Based on the pilot testing done for the big teams, small teams already had an idea of the common functionalities of the tool also through the help of email blasts, posters, banners, roadshows, and of course, knowledge sharing.

 

  1. Provide support and proper training

After the introductory phase, comes the trainings conducted to properly guide users on how to use the BI tools.  Organizations should dedicate a significant time to better condition their business users before laying their hands on these new applications.  Trainings should include keywords familiarization, lectures, and simulations, among others.  It will also help to send manuals and infographics to the emails of these users or maintain a portal specifically for the purpose of hosting all materials related to this new BI tool.

 

For the EY Canvas, we conducted weeklong trainings for the new users before the use of the tool was formally fully rolled out to the whole organization.  At the end of the trainings, timelines were defined for every audit team to follow so as to gather feedback from the users based on their initial use of the tool and relay these insights in the Global office.

 

  1. Incorporate its use in users’ KPIs

The most effective way that users will be encouraged to make use of the tool is through enforcing it as part of the users’ key performance indicators (KPIs).  Find an aspect of the tool which can be translated into performance indicators and set the applicable measures.  Also, find an area in your business process which can become measure of individual or team’s performance and is dependent on the use of the BI tool.

 

EY Canvas being a project management tool, provides statistics on how far the engagement team has gone.  Managers can easily pick up information from the dashboard and reflect the same to the team members’ collective and individual performance assessment forms.  Further, an archiving period of 60 days has been established after the final engagement sign-off.  Late archiving would mean a big blow to the engagement team’s performance evaluation.  This way, users will dedicate more time in understanding the tool and thinking of ways on how to use it more effectively and efficiently.

In implementing business intelligence tools, a marketing approach is the best way to go, coupled with rewards system and corresponding sanctions once KPIs are not met.  It involves studying human behaviour and applying the concept of rewards and punishments.  Make them interested, entice them to participate. In the end, it is the users’ insights that are always more valuable.  It is up to the organization how to add flavor to this approach.  The ultimate goal is complete diffusion of the tool to the intended business users and making them advocates for these BI tools in the process.  Let us not take for granted the organization’s efforts in trying to maintain quality of work and making tasks more operatively effective and efficient.  It always pays to be intelligent when handling business intelligence tools.★

 

References:

http://www.docurated.com/all-things-productivity/50-best-business-intelligence-tools

https://blogs.sap.com/2013/09/05/internal-marketing-efforts-promoting-your-bi/

 

This blog claims no credit for any images posted on this site unless otherwise noted. Images on this blog are copyright to its respectful owners. If there is an image appearing on this blog that belongs to you and do not wish for it appear on this site, please email with a link to said image and it will be promptly removed.

 

 

 

Point, Click, Buy!

dass

Retail therapy is something I enjoy.  However, with the busy schedule that I have – Sunday being my only free day – there seems to be less time to do some shopping.  This may be a common ordeal for working professionals who get to earn money they can’t spend simply because of the lack of time for shopping.  Thanks to technology, online shops were created.  Online shopping offers an alternative shopping venue which is more accessible, less expensive, and basically more convenient!

clip1.png
My favorite online shops right at my fingertips!

I started to became a fan of online shopping about four years ago.  I actually have on my phone the mobile versions of some online store platforms like Zalora, Etsy, Lazada, and Uniqlo.  I usually purchase clothes, shoes, and computer parts and accessories.  Having done this for quite some time now, I’ve had my fair share of ups and downs when it comes to online shopping.  To share some, here are my lists of Yays and Nays of online shopping:

Image result for i love online shopping memes

YAYS: Why I love online shopping:

  • It offers a wide selection of items for purchase

When you go to the mall, not everything you’re searching for may be available.  You may not even finish visiting all the boutiques and floor in the mall within just an hour of shopping.  But with online shopping, you get to check out international and local brands.  You have a variety of items to choose from ranging from fashion items, home and living, arts and crafts, books and references, music, games, electronics, and even groceries.  Your selection is endless.  You may also choose between new and secondhand items, whichever fits your budget.

  • Makes finding the specific item easier

After I became engrossed with online shopping, going to the mall to find the exact item I am looking for became a very tedious task.  How I wish that when I step in the mall building, I can filter all the jeans from the different stores and pick exactly which one I want.  That would be kind of cool, right?  That’s exactly one advantage of doing online shopping.  You simply type in “Jeans” and voila! With some quick swipes and clicks, you can easily trim down your choices from a plethora of suggestions.

  • Can be done any time of day, anywhere

As someone who is constantly busy, you sometimes wish you could teleport to an F21 store and  forget all your deadlines through just a few minutes of shopping.  With the many online stores available in the internet or through phone applications, you are sure to have access to your dose of retail therapy.  You can do it while while watching TV, in between your morning exercises, while on your way home, or even before you go to sleep.

  • Offers convenient payment methods

Avoid the inconvenience of queuing for payment.  With online shopping, you may choose from among the different ways of settling your order.  You may pay through cash on delivery basis, credit cards, bank transfers, online payment systems (e.g., PayPal, PesoPay, GCash, DragonPay, 7Connect, etc.), and authorized payment centers.

  • Helps you avoid extra expenses

Aside from the cost of the items you bought, when you decide to go to malls, you are also obliged to pay for your gasoline, meals, or even service fees for using pay restrooms! There are just a lot of additional charges that come with it. Through online shopping, you only pay for the items plus of course, shipping costs (which could sometimes be free if you purchase over a certain amount).  Plus points from all of us, financially conscious people.

  • Gives a more controlled shopping experience

Sometimes, the mall could be a temptation island.  You leave your house to buy medicine and swear to yourself that medicine is all that you will buy.  However, the mall’s drugstore is strategically located at the heart of the ground floor.  This means you will be passing by a lot of clothing stores.  And as you did, what a twist of fate:  the dress you have been eyeing for months now suddenly becomes on sale! So you say to yourself, it must have been written in the stars that the dress is for you.  So you exit the mall with the medicine you planned on buying plus a paper bag from clothing store!  When you arrive home, remorse is all that you will feel over being weak and easily swayed by things on sale.  That is one thing that online shopping aims to do — help people lessen the practice of impulsive buying.  Put in the virtual cart whatever you want, “heart” them, place them on your wishlist. After quite some time, review your list and eliminate those items you think you can live without. Tadaaah! Sound shopping judgment, right?  That is what I personally do.  I usually give myself one to two days before I make my final decisions on my purchase.

  • Provides more privacy, no crowds

Do you sometimes feel ashamed of buying something because you feel like you are being judged?  Yeah, fellow introverts, please stand up 🙋🏻! I sometimes hate it when the salesperson would ask me a lot of questions while I am trying so hard to concentrate and decide whether I should buy the gray or the black shirt.  It is even more cringe-y when they follow me around, trail behind me, and rearrange the displays I skimmed through, flash a suspicious look as if I am going to steal the items I took off the rack.  Maybe I am just overthinking but we do want some privacy in shopping sometimes, right?  Online shopping eliminate this.  Also, you avoid going through the rush when malls get crowded.  It gets you hard to find a parking space and you simply have a lot of competitors for the things you want to buy.  This also lessens your chances of contracting germs (I am not a hypochondriac, okay?).

Image result for expectations vs reality product meme

NAYS: Why I sometimes shun shopping online:

  • Uncertainty on the quality of the products

I am reluctant in buying items which I have not physically inspected.  Everyone is.  It is really hard to trust online advertisements that when you receive a product, you just wanted to do a vlog on “Expectations versus Reality”.  I have had a lot of experiences on online shopping disappoints like purchasing a dress with a different material as described online, or receiving a defective product.  Before purchasing, make sure these are brands you have tested before and grew to be trusted.   Do check the feedback section for ratings and reviews.  Make sure to be alert for any “horror” stories, if any.

  • Risky payments

When paying online, you cannot ensure that payments are secured since you will be sharing confidential information regarding your bank accounts and/or credit cards.  My personal pick for a term is cash on delivery (COD).  You are sure to pay only for orders you have actually received.

  • More difficult procedures for returns

When shopping in physical stores, returns are processed easy breezy that you may already get a replacement within seven days from purchase.  In online shopping though, it will require you to ship back your items and process for reimbursement or replacement.  You may have to wait a few more days as processes like this could actually take time especially when your location is far from the supplier.

Three products I would have no hesitation buying over the internet:

  • Kitchenware and home decors

Image result for kitchenwareRelated image

I have quite a knack for home decorating and cooking (though my skills are not reliable at all). But I am not that particular of the brand for my home ornaments or kitchenware.  Items like these have standard qualities, and can be very cheap when purchased online.  

  • Kids’ toys

Image result for kids' toysImage result for kids' toys

Most kids I know break their toy after a few minutes of handing it to them.  So, when purchasing kid’s toys, quality is not a main concern.  

  • Books and art supplies

Image result for booksImage result for art supplies

If the book title has the same author and same publishing house, then I would not worry about buying them online at all since the quality is standard.  Anyway, the most important thing for me is content.  For art supplies, i need to buy online for items that are hard to find in malls nearby.  You can hit great bargains for paintbrushes if you buy it directly from the online shop of the manufacturer.

Three products I may want to think about before buying:

  • Shoes, bags, and wallets

Image result for bags and shoes, wallets

I only buy shoes online from tried and tested brands.  Buying from brands that are new to me could be risky since the size may not fit as shoe sizes tend to vary significantly between brands.  Also, bags and wallets sold online could be of substandard quality.  When I buy, I make sure to know which party actually fulfills the order.  If it is exactly the manufacturer, I may give it a go.  If not, the clear answer, is no.

  • Clothes

Image result for clothes

I am a bit flexible in terms of clothing sold online.  I only pick medium-sized clothing since my weight tends to fluctuate.  Sometimes I like using loose clothing so any size variances would be okay with me.  However, I have experienced not getting the level of quality I expected from a jumper I recently bought that is why now, I become more skeptic before adding any clothing items in my virtual shopping cart.

  • Computer parts and accessories

Image result for computer accessories

Items like these could cause you a fortune sometimes.  Just like clothes, shoes, bags and wallets, I buy computer parts as well as accessories only when directly fulfilled by the manufacturers I trust.  Sometimes, the only source could really be online shops, so I do not have a choice but buy online.  However my skepticism is on high alert in situations like this.  I read tons of reviews before finally hitting “Buy Now”.

Three products I will never consider buying online:

  • Appliances, furniture, and gadgets

Related image

Image result for furnitureRelated image

These are quite expensive things that I would prefer buying from a brick-and-mortar store.  Not being able to personally inspect these could result to safety and quality issues which are hard to resolve.

  • Food and medicine

Image result for canned goodsImage result for medicine

I simply do not recommend buying anything that you will eat, drink, or take from online shops.  If you buy a fake version, it could simply cost your health, and even your life.

  • Beauty products

Image result for beauty products

Same as with food and medicine, anything you apply on your skin could be risky if not well-inspected.  A lot of fake beauty products may be advertised on online stores, waiting for your click, so be careful!

Online shopping is one of the most important gifts of technology.  It is up to us, consumers whether we are up for the related risks and rewards. The most important thing is making informed decisions before you finally decide to point, click, and buy! ★

References:

https://www.lifewire.com/shopping-online-pros-and-cons-3482632

https://www.techinasia.com/10-alternative-online-payments-consumers-merchants-philippines

This blog claims no credit for any images posted on this site unless otherwise noted. Images on this blog are copyright to its respectful owners. If there is an image appearing on this blog that belongs to you and do not wish for it appear on this site, please email with a link to said image and it will be promptly removed.

Less is More

In the language of technology, the word “wireless” has become synonymous to “a cut above the rest”.   When we hear that something is wireless, we often consider it better and more advanced than its wired counterparts.  Wireless technology is not something new.  The earliest forms appeared back in 1896 in the form of wireless telegraph to the communications satellites in the 1960s.  In the present age, these forms continue to evolve with increased sophistication and functionality.

Related image

Bluetooth and Wi-Fi have become everyday household words.  The use of GPS has become a staple when hailing a cab through online applications and navigating around cities.  Our life is defined by the battery life of our cellular phones.  These wireless technologies have surfaced due to their increasing demand as consumers, most significantly business organizations discover the related business value from these breakthroughs.

In the organization where I am in, wireless technologies have paved the way to more efficient execution of tasks.  A significant part of our time is spent on fieldworks at remote areas and the team where I belong is based in La Paz, Iloilo City which is 412.2 mi away from our head office in Tondo, Manila.  The geographical distance proved to be a challenged to our team and we owe our smooth operations to these wireless network technologies.

There is increased efficiency due to mobility and improved collaboration.  We can go the distance and not be limited by the length of our wires.  When working on our laptops, we are free to move at our own convenience without fear of losing access.  Our office buildings are equipped with wireless networks that we can access our emails and reports no matter where we are in the office premises.  We can easily work together with our team in Manila through the use of shared folders within our network.  Exchange of information becomes seamless and hassle-free.

Wireless technology allows for better multi-tasking.  Since we are free from the hassle of cables, there is increased freedom of movement which in turn results to getting more things done.  We no longer have to decide whether to print first our report (which has to be done at our office’s printer’s area located at the far end of the floor opposite our work area) or take a call from our boss on our cellular phones.  With wireless technology, we can do both at the same time.

kid

Information exchange becomes more responsive.  No more waiting on long queues at payphones as business can be done right at our fingertips.  We can make calls, send text messages, and even check our emails through our mobile phones anytime and anywhere we like as long as there is available network connection.  Due to this, matters are easily and timely discussed, examined, and resolved.

Further, there is a wider reach through access to remote areas that cannot be reached by wired networks.  Information gathering becomes timelier.  We can easily conduct meetings through the use of videoconferencing facilities in the office and easily obtain feedback from our auditees through virtual sit-down discussions.  GPS technology proved very useful in our audit engagements in the conduct of visits/confirmation/survey with our business partners especially in remote towns all over the country.  We can easily locate their addresses through the use of map applications, and download information through the use of mobile data connection to be used offline when network is not available.

Going wireless also facilitates easier expansion.  There is no need for additional wires or cables and related labour and maintenance costs when new connections are added.  Office furniture are more movable and spaces become more flexible due to the lesser infrastructure requirements of wireless technology.  There is also improved health and safety at work as dangers of tripping over wires are eliminated.  No disposal costs are incurred for old and damaged wires.  Environmental waste is also reduced.  We can maintain tidy desks and become free from the eyesore brought by tangled cables.

cable

For organizations to be able to preserve the business value brought by these wireless network technologies, below standards and guidelines, among others should be complied with to ensure safe usage:

  • Define access requirements

Organizations should develop a remote access policy.  Access should be limited to specific devices or authorized persons only.  Device should prompt the user for username and password before any activity may be started on the device.

  • Change default access details

Do not make it easy for hackers to guess your Wi-Fi name and passwords by sticking to the default access details.  Make sure to regularly change passwords at least every 30 days.  For computers, it would be better if a notification pops out of the screen to remind the user to update the security details.

wifi

  • Use encryption to avoid data theft

Outgoing files may be regulated through the use of encryption on your computer, router, and other devices to prevent hacking attacks.  In order for be the information to still be usable after encryption, protocols on decryption should also be observed, such as controlling the access to decrypt within a group of authorized individuals especially when sensitive information is involved.

  • Develop a system for reporting and responding to security attacks.

Phishing attempts and other security threats should not be swept under the rug.  A system of communicating these incidents should be in place for the IT department to promptly identify risk areas and take action on securing vulnerable data.

As long as security is ensured, wireless network technologies can bring significant changes and advancements in an organization which could most likely spell their success by promoting the achievement of an organization’s primary business objectives.  In wireless technology, businesses grow but most especially, learn.  According to computer researcher John Seely Brown, “If you can design the physical space, the social space, and the information space together to enhance collaborative learning, then that whole milieu turns into a learning technology.”  Indeed, wireless networks offer more.  In less, there is more. ★

 

 

Online References:

http://www.cse.unt.edu/~rakl/class3510/CHAP1.pdf

www.cisco.com/c/en/us/solutions/small-business/resource-center/work-anywhere/why-go-wireless.html

This blog claims no credit for any images posted on this site unless otherwise noted. Images on this blog are copyright to its respectful owners. If there is an image appearing on this blog that belongs to you and do not wish for it appear on this site, please email with a link to said image and it will be promptly removed.