Azure Synapse Analytics (Azure SQL Data Warehouse)
34 Ratings
ThoughtSpot
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
178 Ratings
Free Trial

Azure Synapse Analytics (Azure SQL Data Warehouse)

34 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Based on 34 reviews and ratings

ThoughtSpot

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
178 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.4 out of 100

Based on 178 reviews and ratings

Free Trial

Feature Set Ratings

    BI Standard Reporting

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    7.2

    ThoughtSpot

    72%
    ThoughtSpot ranks higher in 3/3 features
    ThoughtSpot ranks higher in 3/3 features

    Pixel Perfect reports

    N/A
    0 Ratings
    6.0
    60%
    21 Ratings

    Customizable dashboards

    N/A
    0 Ratings
    7.9
    79%
    72 Ratings

    Report Formatting Templates

    N/A
    0 Ratings
    7.7
    77%
    25 Ratings

    Ad-hoc Reporting

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    7.7

    ThoughtSpot

    77%
    ThoughtSpot ranks higher in 4/4 features
    ThoughtSpot ranks higher in 4/4 features

    Drill-down analysis

    N/A
    0 Ratings
    8.0
    80%
    72 Ratings

    Formatting capabilities

    N/A
    0 Ratings
    7.4
    74%
    71 Ratings

    Integration with R or other statistical packages

    N/A
    0 Ratings
    7.0
    70%
    42 Ratings

    Report sharing and collaboration

    N/A
    0 Ratings
    8.3
    83%
    70 Ratings

    Report Output and Scheduling

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    7.9

    ThoughtSpot

    79%
    ThoughtSpot ranks higher in 5/5 features
    ThoughtSpot ranks higher in 5/5 features

    Publish to Web

    N/A
    0 Ratings
    8.3
    83%
    42 Ratings

    Publish to PDF

    N/A
    0 Ratings
    7.7
    77%
    62 Ratings

    Report Versioning

    N/A
    0 Ratings
    7.9
    79%
    18 Ratings

    Report Delivery Scheduling

    N/A
    0 Ratings
    8.0
    80%
    51 Ratings

    Delivery to Remote Servers

    N/A
    0 Ratings
    7.5
    75%
    27 Ratings

    Data Discovery and Visualization

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    7.7

    ThoughtSpot

    77%
    ThoughtSpot ranks higher in 3/3 features
    ThoughtSpot ranks higher in 3/3 features

    Pre-built visualization formats (heatmaps, scatter plots etc.)

    N/A
    0 Ratings
    7.9
    79%
    67 Ratings

    Location Analytics / Geographic Visualization

    N/A
    0 Ratings
    7.8
    78%
    64 Ratings

    Predictive Analytics

    N/A
    0 Ratings
    7.4
    74%
    52 Ratings

    Access Control and Security

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    8.4

    ThoughtSpot

    84%
    ThoughtSpot ranks higher in 4/4 features
    ThoughtSpot ranks higher in 4/4 features

    Multi-User Support (named login)

    N/A
    0 Ratings
    8.6
    86%
    65 Ratings

    Role-Based Security Model

    N/A
    0 Ratings
    8.4
    84%
    58 Ratings

    Multiple Access Permission Levels (Create, Read, Delete)

    N/A
    0 Ratings
    8.1
    81%
    62 Ratings

    Single Sign-On (SSO)

    N/A
    0 Ratings
    8.4
    84%
    54 Ratings

    Mobile Capabilities

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    8.4

    ThoughtSpot

    84%
    ThoughtSpot ranks higher in 3/3 features
    ThoughtSpot ranks higher in 3/3 features

    Responsive Design for Web Access

    N/A
    0 Ratings
    8.6
    86%
    38 Ratings

    Mobile Application

    N/A
    0 Ratings
    8.2
    82%
    26 Ratings

    Dashboard / Report / Visualization Interactivity on Mobile

    N/A
    0 Ratings
    8.2
    82%
    35 Ratings

    Application Program Interfaces (APIs) / Embedding

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Feature Set Not Supported
    N/A
    8.1

    ThoughtSpot

    81%
    ThoughtSpot ranks higher in 6/6 features
    ThoughtSpot ranks higher in 6/6 features

    REST API

    N/A
    0 Ratings
    8.9
    89%
    32 Ratings

    Javascript API

    N/A
    0 Ratings
    9.0
    90%
    27 Ratings

    iFrames

    N/A
    0 Ratings
    8.4
    84%
    23 Ratings

    Java API

    N/A
    0 Ratings
    7.0
    70%
    13 Ratings

    Themeable User Interface (UI)

    N/A
    0 Ratings
    8.2
    82%
    25 Ratings

    Customizable Platform (Open Source)

    N/A
    0 Ratings
    7.1
    71%
    15 Ratings

    Attribute Ratings

    • Azure Synapse Analytics (Azure SQL Data Warehouse) is rated higher in 3 areas: Likelihood to Recommend, Usability, Support Rating

    Likelihood to Recommend

    8.8

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    88%
    8 Ratings
    8.4

    ThoughtSpot

    84%
    72 Ratings

    Likelihood to Renew

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    N/A
    0 Ratings
    9.0

    ThoughtSpot

    90%
    3 Ratings

    Usability

    9.5

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    95%
    2 Ratings
    8.4

    ThoughtSpot

    84%
    67 Ratings

    Support Rating

    9.5

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    95%
    2 Ratings
    7.0

    ThoughtSpot

    70%
    2 Ratings

    Implementation Rating

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    N/A
    0 Ratings
    7.0

    ThoughtSpot

    70%
    2 Ratings

    Contract Terms and Pricing Model

    10.0

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    100%
    1 Rating

    ThoughtSpot

    N/A
    0 Ratings

    Likelihood to Recommend

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    In terms of a well-suited scenario - the Azure Synapse can be used to capture data from multiple sources (especially from onPrem sources apart from Dataverse) and update the transformed data based on the given conditions (eg: refresh data based on the specified date/time ranges). Also, the transformed data can simply be transferred to Azure Data Lake for further processing by utilizing other analytics tools such as PowerBI.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    ThoughtSpot

    The dashboard is intuitive and can be customized in different ways and gives us the option to include what we want to show in the data analysis. I can say that ThoughtSpot's artificial intelligence is more improved than other software already tested and much faster to show all the collected data in real-time in a short time. Based on usability, I highly recommend ThoughtSpot as it is excellent value for money, easy to use, and collaborates a lot in decision making and business processes based on concrete and assertive data.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 72 answers on this topic

    Pros

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    • Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
    • Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
    • Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    ThoughtSpot

    • Beautiful visualizations. The visuals are distinct, clean, and easy to discern from one another.
    • Intelligent querying functionality. When looking to manipulate the data, the search function makes it easy to manipulate the features in the data, along with aggregating them in the way you'd like.
    • Embedding! It has been a smooth process thus far for our product & technical teams to work with ThoughtSpot and bring it into our product.

    Read full review

    Keenan Singh | TrustRadius Reviewer
    Keenan Singh
    View all 72 answers on this topic

    Cons

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    • Integrating external 3rd party data sources is very easy in Snowflake and it’s missing in Azure Synapse
    • Master data services and data quality services are missing in Azure Synapse. They are useful features present in on Orem Sql server
    • Resource usage reports (top 10 expensive queries, most frequently run queries, etc) are a feature that can be added in Azure Synapse. It’s present in an on-prem SQL server. DMVs are there but viewing it visually as a report is more helpful.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    ThoughtSpot

    • It would be great if ThoughtSpot can add the feature to filter by clicking on visualizations. i.e if I click on a particular data point in the chart if the full dashboard can filter just for that particular data point.
    • Color coding the heatmap with different colors like green to orange to red.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 72 answers on this topic

    Pricing Details

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    General

    Free Trial
    —
    Free/Freemium Version
    —
    Premium Consulting/Integration Services
    —
    Entry-level set up fee?
    No

    Starting Price

    —

    ThoughtSpot

    General

    Free Trial
    Yes
    Free/Freemium Version
    —
    Premium Consulting/Integration Services
    Yes
    Entry-level set up fee?
    Optional

    Starting Price

    —

    Likelihood to Renew

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    No score
    No answers yet
    No answers on this topic

    ThoughtSpot

    ThoughtSpot 9.0
    Based on 3 answers
    We have had success with the initial use cases and there are more use cases that can receive return on investment. I don't give it a 10 because other products like Tableau are building functionality that may start to compete in the coming years.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 3 answers on this topic

    Usability

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5
    Based on 2 answers
    The data warehouse portion is very much like old style on-prem SQL server, so most SQL skills one has mastered carry over easily. Azure Data Factory has an easy drag and drop system which allows quick building of pipelines with minimal coding. The Spark portion is the only really complex portion, but if there's an in-house python expert, then the Spark portion is also quiet useable.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    ThoughtSpot

    ThoughtSpot 8.4
    Based on 67 answers
    The tool is easy to use if you know what you are doing and looking for. I know as they work towards improvements and simple language it will become even easier, but as of now they are doing a great job but there is room for improvement.

    Read full review

    Kevin Clarke | TrustRadius Reviewer
    Kevin Clarke
    View all 67 answers on this topic

    Support Rating

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Azure Synapse Analytics (Azure SQL Data Warehouse) 9.5
    Based on 2 answers
    Microsoft does its best to support Synapse. More and more articles are being added to the documentation, providing more useful information on best utilizing its features. The examples provided work well for basic knowledge, but more complex examples should be added to further assist in discovering the vast abilities that the system has.

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 2 answers on this topic

    ThoughtSpot

    ThoughtSpot 7.0
    Based on 2 answers
    No answer on this topic is available.

    Implementation Rating

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    No score
    No answers yet
    No answers on this topic

    ThoughtSpot

    ThoughtSpot 7.0
    Based on 2 answers
    Understand use case and model and design accordingly

    Read full review

    Surya Ravi | TrustRadius Reviewer
    Surya Ravi
    View all 2 answers on this topic

    Alternatives Considered

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    We also looked at Oracle Data Warehouse as part of our short list of products to implement as a solution. Oracle's product turned out to have less support by way of easily accessible internet blogs. Oracle was also considerably more expensive and we would have needed to hire the skillset needed to implement.

    Read full review

    Samir Patel, PMP | TrustRadius Reviewer
    Samir Patel, PMP
    View all 8 answers on this topic

    ThoughtSpot

    We also explored Tableau Ask Data. Tableau is our standard for BI in our organization. We want to use the smallest amount of tools in our company to have the best adaption. ThoughSpot will fill a few gaps that we have with our current set up and will also enhance out offering for our employees in the transition of being more data driven within in near future

    Read full review

    Torsten Wiegel | TrustRadius Reviewer
    Torsten Wiegel
    View all 72 answers on this topic

    Contract Terms and Pricing Model

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    Azure Synapse Analytics (Azure SQL Data Warehouse) 10.0
    Based on 1 answer
    Basically, the billing is predictable, and this all about it.

    Read full review

    Vladimír Mužný | TrustRadius Reviewer
    Vladimír Mužný
    View all 1 answers on this topic

    ThoughtSpot

    No score
    No answers yet
    No answers on this topic

    Return on Investment

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    • Azure Synapse has predominately reduced the time being used for processing data being extracted from multiple sources
    • Ability to integrate multiple data sources and create a single dataset that could be used for further analytics to find KPIs

    Read full review

    Anonymous | TrustRadius Reviewer
    Verified User
    View all 8 answers on this topic

    ThoughtSpot

    • Time to market ROI is massive vs hiring the full-time dedicated team to build and maintain a frontend multi-tenant SaaS data viz product.
    • It will be interesting to see over time how the advanced features play out in terms of usability and end value, such as Natural Search, which we are very excited about, and the machine learning tools.

    Read full review

    Chris Mann | TrustRadius Reviewer
    Chris Mann
    View all 72 answers on this topic

    Screenshots

    Azure Synapse Analytics (Azure SQL Data Warehouse)

    —

    Add comparison