Law

Thailand’s PDPA Law Highlights

Thailand PDPA Law was enacted in May 2019 and is going to be effective on 27 May 2020. Here are some key highlights from the EDTA workshop.

Read more

What is Business Dashboard and how we should do it?

So-called ‘Dashboards’ are heard in our analytics driven world but what exactly is dashboard and why we should do it?

Read more

Data Visualization Techniques

The easiest way to explain your data to someone else is actually to visualize it. Data Visualization could be considered as story-telling or how to tell your story to your audiences or as analysis tool to make you understand your data better.

To be able to visualize data, there is a very useful knowledge called ‘Semiology of Graphic’ which many seems to overlook and go to what chart I should use. Semiology of Graphic deals with how we can actually play with different aspects of the chart to reflex the differences in data.

Read more

Segmentation by Analytics

Segmentation is to split the market into different groups – each group with similar characteristics. Why do we do this? Because, STP or Segmentation, Targeting, Positioning will help the company select the right segment to target with right positioning. You could not sell your product or services to all people on earth.  For example, not all people will buy fruit juices, only those who concerned about health will be interested.

Read more

What are CLV and CAC?

With the raise of Data Analytics, the most common concept we have heard about from Marketing side of Data Analytics is ‘CLV’ and ‘CAC’. So, what are CLV and CAC?

Read more

Power BI vs Tableau Buying guide

Which Licensing type should i get…

Do you know the differences in licensing type for each tools?
Today we are going to explore these licensing type and show you how you can save cost by choosing the right type for your business!

 

Let’s start with Power BI,

Exploring Different types of User Licenses

Power BI offers three tires of service – Free, Pro, and Premium based on their usage and pricing. 

  1. Power BI Free – User for content creation: Use the free Power BI Desktop tool to author reports and prepare, model, and create data visualizations.
  2. Power BI Pro – User for content publication: Collaborate with colleagues, model data, author content, share dashboards, publish reports, and perform ad hoc analysis.
  3. Power BI Premium – User for content consumption: Read and interact with pre-published dashboards and reports with either a per-user Power BI Pro license or a Power BI Premium license for large-scale databases.
 Power BI FreePower BI ProPower BI Premium**
For:IndividualIndividual/SMESME/Large enterprise
Cost in USD$:FREE$9.99 per user/ month-$20 per user / month
-From $4,995 per node/ capacity / month
Desktop/Mobile:DesktopBOTHBOTH
Features:Access:
-Developmental features

Interact:
-Data streaming up to 10k row per hour
-Dataset refresh frequency x1 a day

Access:
-Content Pack

Interact:
-Model Size limit 1GB
-Max storage 10 GB/user
-Direct query
-Gateways
-Unlimited Data streaming
-Dataset refresh frequency x8 a day
-Create reports and visualizations with Power BI Desktop4

Collaborate:
-Publish reports to share and collaborate
-Mobile app access
-Workspaces
-AI visuals
-Embed APIs and controls
-Connect to more than 100 data sources

Govern:
-Row level security
-Metrics for content creation, consumption, and publishing
-Data security and encryption
Access: (All in Power BI Pro and) :

Interact: (All in Power BI Pro and) :
-Model Size limit 100-400GB
-Max storage 100 TB
-Dataset refresh frequency x48 a day

Collaborate: (All in Power BI Pro and) :
-On-premises reporting with Power BI Report Server
-Consume content without a per-user license
-Paginated (RDL) reports
-Dataflows (direct query, linked and computed entities, enhanced compute engine)
-XMLA endpoint read/write connectivity
-Advanced AI (text analytics, image detection, automated machine learning)

Govern: (All in Power BI Pro and) :
-BYOK Bring your own key
-Multi-geo deployment management
-Application lifecycle management
Add ons:  > Autoscale (preview)
** Depending on per user or capacity features differ. For latest update and features visit https://powerbi.microsoft.com/en-us/pricing/

 

And Tableau.

Exploring Different types of User Licenses

  1. Viewer – Users with Viewer license can access Tableau Desktop/Mobile, add comments to workbooks, download .png and .pdf versions of workbooks, download workbook summary data, create subscriptions for themselves, and receive data-driven alerts. 
  2. Explorer – Users with Explorer license include all actions of Viewers. They can build workbooks from scratch directly in Tableau Server/Online and with appropriate site roles, they can also edit published workbooks (create calculations, change chart types etc.)  and save them as a separate workbook or overwrite existing workbooks (with permission required). 
  3. Creator – is the developer’s license. Users with creator license will have access to Tableau Prep Builder, Desktop and Server/Online 
 Tableau ViewerTableau ExplorerTableau Creator
For:IndividualIndividual/SMESME/Large enterprise
Cost in USD$:$12 for Server
$15 for Online
$35 for Server
$42 for Online
$70 for Server/Online
Desktop/Mobile:BOTHBOTHBOTH
Features:Access:
-Embedded content

Interact:
-Interact with Visualization and dashboards
-Create and share custom views
-Download Viz as image
-Download summary data

Collaborate:
-Comment, Subscribe, Receive alert
Access: (All in Tableau Viewer and) :
-Edit existing workbook / Viz
-Create new and publish new workbook from existing data source
-Explore data source via AskData
-Prepare schedule flow

Interact: (All in Tableau Viewer and) :
-Download full data

Collaborate: (All in Tableau Viewer and) :
-Create Subscription / alerts for others

Govern:
-Manage user & permission
-Manage content & certify data
Access: (All in Tableau Explorer and) :
-Create new and publish new workbook from new data source
-Create new and publish new workbook on pre-built Dashboard starters
-Create / edit/ modify new data flow (.tfl)
-Export Data (.tde / .hyper / .csv)
-Publish and run flows

Interact: (All in Tableau Explorer)

Collaborate: (All in Tableau Explorer)

Govern: (All in Tableau Explorer and) :
-Server Administration
Add ons:>Tableau Data Management Add-on
>Einstein Discovery in Tableau
>Server Management Add-on
>Tableau Data Management Add-on
>Einstein Discovery in Tableau
>Server Management Add-on
>Tableau Data Management Add-on
>Einstein Discovery in Tableau
>Server Management Add-on
** Depending on per user or capacity features differ. For latest update and features visit https://www.tableau.com/pricing/individual

 

Our Summary:

Tableau and Power BI have different price points and the associated features for those costs. Keep in mind that there are many unique variables with every organization that could decrease or increase costs for each of these tools and features. Organizations will also need to weigh the capabilities and limitations of each tool and what you want you want to accomplish with them when making your ultimate decision. Once you have decided which tool to use, contact Power BI / Tableau concierge for the exact pricing for your business. I hope you find this blog useful to make better decision for your business.

Need Help ……?

Based on your business needs we can recommend which tool is suitable for your needs. If you’re concern about the cost go for Power BI. Whilst Tableau offer some features and functionality that Power BI don’t.

If you do not want to handle data and want to outsource your data to an analytics solution provider do feel free to reach out to us for a quick discussion on how our team of experts can manage your end to end data.

Contact us



Email: julian@davoy.tech
Phone/Whatsapp: +65 9474 2701

or you can drop your contact in the form below

    lighted dj controller

    API (Application programming interface)

    Do you know what API is & How API benefit us?

    API is a tool that is most complex yet frequently used.

    In short, It is the brain of the machine.

    A modern day car/bike ECU (electronic Control Unit)

    An API just like a car/bike’s control unit. It send signals/message to the engine from the input of the driver.
    When a driver step on the gas, the control unit send signals to the engine to the combustion engine thus moving the vehicle forward. The dedicate input of the driver foot to the pedal send different signals to the engine to determine the amount of fuel injected and air sucking in to produce the power for lateral acceleration. Not only it controls the engine but also various part of the vehicle such as air-condition, safety lock/unlock, windows, tyre monitoring pressure system, airbag system etc.

    Can you imagine a car without a control unit?
    There will be no remote control, keyless start ignition instead a traditional keys to unlock and starting a car by cranking the key to the keyhole.

    Benefits of API

    The end day, uses of API is to make our lives easier and convenient.

    • Connectivity & Productivity
    • Innovation
    • Marketing
    • Cost
    • Customer/client experience

    Connectivity & Productivity

    API boast connectivity and productivity just like a car example where modern key fob can be use to display many parameters of the vehicle status as compared to early days manual key fob that serve only specific purpose thus increase productivity through many uses.

    Innovation

    API allow business to be creative & innovate new products / services to meet customer’s demand and explore new avenue for growth / revenue. Gartner affirms that APIs are important in reducing the friction usually caused by a bimodal IT strategy; that is, where legacy systems (Mode 1) are run alongside flexible, innovative solutions and approaches (Mode 2).

    APIs can act as the connecting layer that allows for a more coherent interaction of the two modes, leading to the deployment of innovative and feature-rich applications. With APIs, you can flawlessly extract value from legacy data sources and enhance your current systems’ capabilities.

    Marketing

    While opening up to new avenue of products / services, API allow them to expand their reach and penetrate new market frontiers that otherwise could not have been fronted.

    For example, IBM released the Watson API to allow developers to take advantage of its state-of-the-art AI technology and implement it into various use cases. As a result, IBM has galvanized a large number of third-parties and expanded its reach in a wide range of industries, including travel, shopping, and medical care etc.

    Cost

    The greatest benefits of APIs for businesses is the ability to save costs. Since APIs significantly reduce the development effort, using them to create applications is a great way of reducing costs.

    Consuming APIs frees developers to concentrate on refining the unique capabilities of their apps faster, which assists enterprises to save resources and money.

    Customer/client experience

    By leveraging APIs’ capabilities, businesses can create new and effective ways of interacting with client / customers, especially in the current digital age when consumers demand top-notch experiences.

    With APIs, developers can create solutions that meet specific client expectations, something that could be difficult to achieve without them.

    For example, many brands use APIs to deploy innovative artificial intelligence and predictive analytics technology that analyzes a buyer’s unique journey and recommends the “next possible action”. This improves the customers’ shopping experience and yields more sales.

    Example of API uses:

    Have you seen advertisement pop-up whenever you visit social media platforms like Facebook?

    In this example of API, we are going to demonstrate how to harness the capabilities of Facebook ads API.
    Over 6 million advertisers are using Facebook Marketing as Facebook offers highly specific targeting capabilities combined with the massive reach to be able to scale winning campaigns. However it is not easy as it sound to start campaigning your advertisement.

    There is multiple purpose to leverage Facebook Advertising data:

    • Performance Measurement
    • Analytics Insight (such Attribution Modeling)
    • Customer Profile Enrichment

    These require a different set of information from Facebook. While it is possibilities to exports campaign performance data from Facebook’s Ads Manager backend, the process can quickly become time consuming and cumbersome if you are running operations at different scale and use multiple accounts.

    Facebook’s API automate the process of sourcing the data to empower these use cases. Performance monitoring can then be done on a daily basis, merging the data with other channel information. Ad Spend time series can then be used to automate the training of an attribution model, and Customer Profile can then be automatically populated based on targeting information from Facebook.

    Ad Insight Reports

    Ad insight reports can be run from the Ad API. These provide performance reports for your specific account and allow you to define the fields you want to extract as well as the granularity of the information. These can be defined in a parameters dictionary.

    This dataset provides a holistic of the performance of our ads across different metrics; previously defined custom metrics would also fall within the actions dictionary. 

    Targeting Settings

    Facebook offers extensive targeting options for their ads, from the basic targeting setting such location, age, gender, and language to more advanced like those based on custom audiences or behavioral or interest-based characteristics.

    These options offer data on user demographic & behavioral characteristics that can help personalize the website or get a better on the performance of the campaign using these characteristics to gaining an understanding of value for different user segments.

    There is ton of things you can do from the data provided through the Facebook API. From generating standard performance report, combining it with other data to run attribution models, or to giving personalization on the website for users which have been targeted.

    In Conclusion,

    The business benefits of APIs are vast. They are powerful tool that allow businesses to generate a good return on investment. APIs have become a critical catalyst that drives the advances of most modern organizations. Separating the contender from the pretender.

    It’s what you need to revolutionize the way you do business in the current digital age.

    Want to know how API can benefit your data and your business?  Chat with us more about API X Data Analytics!

     

    Contact us



    Email: julian@davoy.tech
    Phone/Whatsapp: +65 9474 2701

    or you can drop your contact in the form below

      wood flowers industry dog

      Analytics Case Study: (XZL) Plywood

       

      This is Part 2 series of different types of analytics
      Check out of Part 1 if you haven’t done so!

       

      In this series, we are going to analyze one of our client’s existing software and system, discuss what are the issues and how we provide our client useful information and more importantly making full use of the data so as to make better business decisions.


      Picture by XZL Plywood Company Limited

      Background of the Company:

       

      XZL Plywood Company Limited is a manufacturer and distributor of quality compass plywood sheets. ISO certified production, research and development of plywood sheet to serve various purpose being functional & aesthetic furniture / piece of art.


      Current Issues/ problem faced by client:

       

      Our client currently using ERP/Accounting Program. These program are operational however they are not specialized for Data Analytics moreover, data generated by these program/software usually serve it’s general purpose and not specific for your business problem. Hence, one of the reason why many businesses hire specialized Data analyst or consult a analytics provider/consultant to seek refinement and understanding of their data.


      Picture from Power BI – Integration of various sources of data and department

      Understanding client’s requirement / needs of the business & Exploring solutions:

       

      There are many steps and tedious process of understanding the requirement of the business. The general basis of consultancy to our client focuses on understanding their business nature, what are their needs, what software they are using, identify the data problems and what do they want to achieve.

      There are many ways to a solution but we always try to achieve the maximum and the best to our clients. Sometimes it involve trial and error as there’s no magical solution to every business problem. We seek, understand and learn along to fine tune our solutions for our clients.


      Picture from Power BI – Accounts Receivable analyzation (Client’s Company are masked for competitive reasons)

      “Data is broken down into finer details for precision and quick decision making”

      Client’s specification and our added customization inputs from a business point of view

       

      Picture from Power BI – Infographic of Cost analysis – Providing each cost breakdown at each department for better cost effectiveness

      Educating client and how we provide solutions , adding value to business:

       

      What we specifically done for this client is download the data from the particular accounting software they are using, not only we analyze their data, we clean up the data, provide a form of data security and into a cloud server where they can access it on the fly. Providing security and convenience to all the stakeholder in the client’s organization. As you can see above, the visualization is broken down into finer details where each department can analysis cost saving measures and overall performance. This interactive data can also be automated reporting to relevant stakeholder with the convenience of your mobile/web version.


      Review / Conclusion:

       

      The end results? In short, Better visualization of Data and overall clearer overview. With different customization, each level of department can seek and sort out information related to their specific target and needs. Depending on our clients we also automate the whole reporting system where live Data can be viewed daily, weekly or monthly, thus reacting with strategies better. You might ask, only automate reports? Definitely not, depending on your requirement we can custom the platform to integrate with your system and having an interactive data not only to specific but also slicing and dicing where each detail of the data can be scrutinized.

       



      We are Davoy, realize your Data potential today.


      Contact us



      Email: julian@davoy.tech
      Phone/Whatsapp: +65 9474 2701

      or you can drop your contact in the form below

        photo of pen on top of notebook

        Understanding different types of Analytics

         

        airport bank board business

        Are you uncertain what analytics to perform for your business?


        Fret not, we are here to help!


        Many of our clients using Enterprise Resource Planning in short, ERP software or any cloud program such as Accounting cloud software capture data differently and may not be suitable to your business. This Data may not be useful if they don’t provide you the information that you want. There are many ERP tools out there promising you with specific analytical function for your business and in fact they are not specialized in handling the complexity and dynamics of your Data which is why sometimes either your data do not make any sense or you do not understand the data that is being captured.

        Data is a valuable resource to your company in making the right decision at the right time giving you the edge among your competitors. Data should be aiding you instead of harming you wasting your time, effort and resources. Many big company have specialized department for Data analyst focusing on getting the precise information needed for each department. Depending on your business, such information enable you to do:

        • Descriptive Analytics.
        • Predictive Analytics.
        • Prescriptive Analytics.
        • Diagnostic Analytics

         

        Types of analytics


        Each data provide you with different information. Below are few of example



        What is happening to your business?
        This is the most common form of analytics where we capture key measures / matrix of the data.
        Such example can be standard reports
        eg: What is the call volume for August? What is the average sales of product for the past week?

        What will likely happen to your business?
        Many business strategies involve around Predictive analysis to predict outcome based on historical trends. They are able to capture these insights automatically using algorithm and technology such as our AI & Machine Learning tools.
        eg: Which customers are likely to call? Which customer are likely to buy certain product on certain days?

        What do you need to do?
        This is the pinnacle of analytics where data are optimized for recommended actions or strategies based on testing strategy outcome. Applying advanced technique of analytics to make specific recommendations
        eg: How many manpower needed required to handle the call volume? How many raw materials for specific product?

        Why is it happening to your business?
        The ability to spot outlier from your data provides you with useful information. Like Six Sigma, the ability to drill-down to the root cause and isolated the segment.
        eg: Why certain calls are specifically long? Why certain product sell well in location A but poorly in B?


        “All in all, analytics can be dynamic and unique to your business. Finding the right tool and the right people may help you to determine business outcome and strategies. There’s not a generic or “a one size fits all” solution.”

        To find out how you can view the data you want it to enable business strategies, stay tune to our next blog where we share a real business case scenario and how we provide solution for our client based on their current ERP/ cloud accounting software.

         

        If you have questions about your Data, you can contact us via the form below!

        Contact us



        Email: julian@davoy.tech
        Phone/Whatsapp: +65 9474 2701

        or you can drop your contact in the form below

          Why should you do NPS survey?

          Nowadays, with fingertips, customers have access to various choices of products and services in the market. This raises business competition especially in B2C sector. The access to choices increases the chance of customer trying new products and services, which is making it harder to keep the customers loyal to your brand. Consequently, it is more crucial than ever to understand your customers; what customers like about your brand? what customers dislike about your brand? what should be focused to retain your customer, and what can make customer happy enough to promote your products and services to their friends and family or even online?

          What is NPS?


          NPS stands for “Net Promoter Score” or how likely your customer want to recommend you to their friends & family, and etc. It could represents how satisfied your customer with your products or services. Usually, there is strong correlation between NPS and Customer Satisfaction. A satisfied customer is definitely more likely to recommend you than others. This also means how many people like your products or services.

          What is Customer Satisfaction?


          Customer Satisfaction is an indicator of customer happiness based on what they get compare to what they hope for. If you can meet or exceed the customer’s expectation, you can make your customers satisfied. On the other hand, customers will show dissatisfaction when the products or services are not met the customer’s expectation. In fact, business owners can use the Customer Satisfaction Survey tools like  online channels, email, telephone auto message, or paper to acquire the customer’s insight such as overall customer satisfaction score, what customer like, what customer dislike, and willingness to recommend brand to friends and family.

          Why Customer Satisfaction Is So Important?


          “Acquiring a new customer usually cost 6-7 times more than retaining current ones. On the average, the loyal customers tend to spend 10 times more than their first purchase.” That’s why the business owners should always value the customer satisfaction more than marketing to get new customer. By nature, when the customers are happy with products or services, they are more likely to promote your brand with their friends and family, which is ultimate goal of running business.

          With how convenience to access options, the customers can be swayed to try other brands at any given time. Especially if the current products or services they are using don’t meet their expectations. Research also found that brands have to create up to 12 positive experiences in order to compensate for a negative experience customer had. On top of this, it is much easier for customers to share bad experience about a product or a service than a good one. It is impossible to stop customer from sharing their experience, but you can implement a channel to gather customer feedback and turn it into a strategy for your products or services improvement.

          Focusing on customer satisfaction trends


          The next problem after having a channel to gather customer feedback such as customer satisfaction survey is you have to go through a large amount of data. It is quite challenging to arrange a sizable data into a sensible format which is required to see customer satisfaction trends. There are a few ways to find the trends in customer satisfaction, for example, using the program that can report the fluctuation of customer satisfaction, focusing on industry-wise or region-wise target, or finding the correlation between customer satisfaction and other inputs.

           

          If you are looking to improve your product or service using the customer satisfaction, Davoy.tech is ready to onboard you to the journey to understand your customer better both for customer satisfaction & NPS. We will hold your hands from creating customer satisfaction survey, data analysis, to building interactive dashboard with our end-to-end customer satisfaction platform.

          If you are ready to embark on this journey, please contact us at below.

          Contact us



          Email: julian@davoy.tech
          Phone/Whatsapp: +65 9474 2701

          or you can drop your contact in the form below

            Microsoft Power BI vs Tableau; The most Talked about..

            I am sure you have come across either of these tools or you have heard of them before. Personally, I have used both tools and, on this blog, I am going to share with you my perspective on both most talked about analytical tools used by many.

            Firstly, let us look at Gartner magic quadrant: it shows a graphical competitive positioning of four types of technology providers in fast-growing markets: Leaders, Visionaries, Niche Players and Challengers.

            Disclaimer:

            Gartner, Magic Quadrant for Analytics and Business Intelligence Platforms, February 15, 2021, James Richardson, Kurt Schlegel, Rita Sallam, Austin Kronz, Julian Sun

            Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

            This graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request here.

            On the Gartner Magic Quadrant, Microsoft and Tableau are seen consistently the leader of the analytics technology provider based on a set of capabilities such as Security, Manageability Cloud analytics, Data source connectivity, Data preparation, Catalog, Automated insights, Data visualization, Data storytelling, Natural language query (NLQ), Natural language generation (NLG) and Reporting.

            We are going to narrow down to the Top 2 reporting tools that have been consistently rank the highest fighting for the top spot.

            Microsoft Power BI:

            There is a high chance that you know Microsoft, well most of us have used their software at least once in our lifetime. Without a doubt, Microsoft has impacted the technology world making us smarter and more efficient. Microsoft Power BI offer a suite of software / programme for all needs and chances are if you are using Microsoft product you would want to stick with this as your top choice as it offers streamline services across the Microsoft product such as Office 365 and Teams. With the increasing integration means that it will increases the Power BI reach in the word of remote working.

            The highlight of Power BI is that it releases many notable visionary features such as augmented analytics and anomaly detection capabilities using AI and ML. With its More affordable with low initial cost and no minimum users means and Easy to use (template), familiar Microsoft interface and Office 365 means that it is a good starting ground for all including people who are either new or already using Microsoft product.

            Tableau:

            Tableau is always seen as a powerful analytical tool giving Microsoft a run for its money. Chances are if you are comparing Tableau means you have an experience in these dashboard/analytics tools.

            In my opinion, Tableau data modelling capabilities are better than in Power BI. It enhances the usability to analyse data between tables at different scope (If you are advanced enough you would use these functionality). It is richer and more intuitive analytical experience would be recommended if you know how these tools work to your advantage. All these functionality and features do come with a premium price and if you require a rich and dynamic function and capabilities it will be worth it. 

            What’s the difference between Power BI and Tableau?:

            Cloud ServicePower BI ProTableau Online
            CostPower BI Pro S$14*/month per user/month *(rounded up) wide range of licensing options depending on the specific role individuals play in the organization. https://powerbi.microsoft.com/en-us/pricing/For Tableau Creator S$93* per user/month *(rounded up) wide range of licensing options depending on the specific role individuals play in the organization. https://www.tableau.com/pricing/individual
            Features and CapabilitiesEasy to use (template), familiar Microsoft interface and Office 365,Interactive drag and drop (build from scratch)
            PerformanceLimited volume of dataHuge volume of data with better performance
            Data visualizationReal-time data manipulation and simplify data reportingComplex scaling and interesting visualizations
            IntegrationAPI access: Microsoft Office 365, Google Analytics, Salesforce dashboard, email platformsNative connectors built and optimized for many databases and files—from spreadsheets and PDFs to big data, cube, and relational databases on-premises
            Quality and convenienceIntegrated Power Query toolsDesigned for already preprocessed data
            Ease of UseEasy to learnSlightly complex
            Great forReports, DashboardsData Exploration and Rich Visualization

            Summary:

            Here is my summary for both the analytical tools.

            Both offers great usability and modelling capabilities but offer different interactive experience you will not go wrong with either of the tools. But regardless of your choice, the main advantage that both tools provide is that users can visualize data so that they can make their decisions faster. Personally, I would recommend Microsoft Power BI for its affordability, ease of use and streamlined services across Office 365 and its efficient dashboards reporting whereas Tableau would lean towards someone with advanced data analytical needs.

            If you are still unsure of which tools to go for or need further advice on your business requirement, you can contact us anytime for a free consultation. We will advice you based on your preference and suitability.

            Drop me an Email here!

            Davoy – Business Analytics Solutions

            Want to do Analytics Project?

            Contact us



            Email: julian@davoy.tech
            Phone/Whatsapp: +65 9474 2701

            or you can drop your contact in the form below

              Start your Data Analytics Journey…

              Get up to 80% subsidy when you digitalize your Data with us. Contact us now!

              Read more

              Creating aesthetic dashboard for visualization

              We design dashboard for visualization to better capture your audience and impacting your business in a different way.

              Read more

              silver imac displaying line graph placed on desk

              Power BI vs Tableau vs Google Data Studio (in 2021)

              Have you wonder which Business Intelligence tool is the best for your organization? There are many BI Tools out there for you to choose from.

              From Gartner’s Magic Quadrant for Business Intelligence tool in 2021, the top 3 BI Tools are Microsoft Power BI, Tableau and Qlik.

              This blog compares the most popular tools : Power BI, Tableau and Google Data Studio for you. For us, we’d say use the right tool for the right objectives. Each tool has it own pros and cons.

              Maslow of Data Analytics

              If you are wondering how to start your Data Analytics Journey, Davoy.tech would like to present you Maslow Hierarchy of Data Analytics.

              Step:1 Physical Need <> Data Driven Decision
              You don’t need fancy models or advanced tools. The first step is to use data to drive your business decisions. For example, instead of just re-order the product your like, you might want to look at historical sales and the inventory level.

              Step 2: Security <> Integrated Data
              Next step is to get data integrated. This is the most overlooked stage to me. Most companies reported different sales revenue from different departments such as Sales, Marketing, Finance. This is due to different business logic and Silo. We should align on the data definition and data usage before moving up the Pyramid.

              Step 3: Social <> Real-time Data
              The world is changing fast. To catch up, you need fast data. Many companies are looking March sales in Mid-April as they need to wait for their staffs to pivot and report them. Wouldn’t it be better if we can see it daily?

              Step 4: Self-Esteem <> Individual Data
              To be able to run advanced models such as Customer Segmentation, RFM in Marketing 5.0, you need individual data points and more profile enrichments.

              Step 5: Self-Actualization : Machine Learning
              Finally, yeahhh we can use machine learning and Artificial Intelligence to enable your business for competitive advantage.

              In reality, most companies, even MNCs, are still struggling with Step 1 or Step 2; some might be in Step 3 or Step 4. However, I can see lots of hypes around ‘AI’ and ‘Machine Learning’. I’d like to remind that we need to set our foundations strong before we can proceed to AI and ML.

              If you want to set your foundations right, you can contact us at lin@davoy.tech

              brown book page

              What is Data and how to derive insights and value?

              Getting started with Data Analytics

              Data is garage in, garage out, good data and bad data, useless data and data with value. With digitalization, data is everywhere, raw data give contexts to help derive Information. Information gives meanings to become Knowledge and Knowledge gives insights to finally become Wisdom. 

              In simple words, we all probably have some data in different ways but how can we derive insights and value from Data? Before that, let’s understand the common problems of Data. 

              Common problems of “Data” 

              1. Offline – Many data are in physical manual hardcopy forms
              2. Limited – Many useful and valuable data points are not collected
              3. Not integrated – Data that are available are in some files like Excel in different workstations
              4. Not usable – Data stored are also inaccurate, not logged properly or not updated
              5. Data hidden somewhere secure – Request to IT for data and reports to be generated. This often takes days or weeks and every time you need it. 

              With such common data challenges, the outcome is mostly basic charts and reports that requires heavy manual work and often results that are inaccurate, incomplete and not 100% trustable.   

              So, what can be done? Our 2-simple approach to get things started.

              1. Set the “Data” foundation so data are available and fit for use  

              1. Convert offline data to online, in other words digitalized hardcopy forms to online whether in database, Google forms or Excel files
              2. Collect data points that are of value: Plan, design and implement data collection process that are useful
              3. Integrated and consolidate them to a database management system such as Microsoft Access or MySQL or Data Lake/Warehouse.
              4. Put in place Data Quality checks by focusing on process, monitoring, profiling and governance for Data to be trusted.
              5. Schedule and automate data pipelines, refresh and alerts so it eliminates manual request or actions and get value from data isolated sitting somewhere.  

              2. Get actionable insights from trusted data

              • Operational Report – Most reports are descriptive in nature and can only tell you what has happened such as sales last week. This is also reactive and operational in nature for measuring efficiency or performance.

              This is the first and important step to understanding and getting value and use from your data.

              • Advanced Reporting – As more data are available and integrated, you can explore data that are connected across multi-dimensions for analysis such as sales by locations by transaction volume and number of transactions over time.

              More questions will be answered but also asked next. Reports will evolve to dashboard for exploration, benchmarking and decision-making.  

              • Actionable Insights – With multi-dimension analysis, apart from “What Happened”, you will be able to answer, “Why did it happen”. For example, why did sales drop in quarter, is it due to the products, stores, existing customers or new customers conversion. Actionable insights can now be derived, and proactive actions can be taken.

              About 70% organizations are not getting value from data especially small to medium organizations and struggle with data challenges.

              We believe that data can be easily unlocked and realized in today’s digitalization world.

                shopping

                What is Consumer Journey & Marketing Funnel

                Not all people will purchase once they see the product, this blog explains how consumer journey through the purchase decision

                Read more

                Likert Scale : From 1-5, how much would your rate…?

                In questionnaires, it is very common to see the questionnaire asking you “From 1 to 5, how much would you rate…?” (1 is totally negative and 5 is totally positive or vice versa). 

                Read more

                Power BI Pivot & Unpivot

                ome cases, you might wonder why you couldn’t get the graph or chart you wanted from your raw data. The fact is that sometimes you might need to ‘shape’ your data before visualization. This is what PowerBI is really strong at.

                Read more