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

    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

          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

          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

          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