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

          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

            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

            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

            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