Looker vs i2 Analyst's Notebook

Last Updated:

Our analysts compared Looker vs i2 Analyst's Notebook based on data from our 400+ point analysis of Business Intelligence Tools, user reviews and our own crowdsourced data from our free software selection platform.

Looker Software Tool

Product Basics

Looker is a web-based analytics solution that offers businesses the ability to explore, discover, visualize and share data insights. Enterprises can view data sources and drill down into data to better understand their business and metrics.

Using a simple proprietary modeling language, this system helps define data relationships while bypassing SQL. It facilitates data literacy and accessibility, irrespective of technical skill levels. It was acquired by Google on June 6, 2019, for $2.9 billion.
read more...

i2 Analyst's Notebook is a sophisticated software tool designed to facilitate advanced data analysis and visualization, particularly in the realm of Business Intelligence. It excels in transforming complex data sets into comprehensible visual representations, such as link charts and timelines, which aid in identifying patterns, relationships, and trends. This software is particularly well-suited for analysts in law enforcement, military, and financial sectors due to its robust capabilities in handling large volumes of data and uncovering hidden connections.

Key benefits include enhanced decision-making through clear visual insights, improved efficiency in data analysis, and the ability to integrate data from multiple sources. Popular features encompass advanced search functions, customizable visualization options, and powerful analytical tools. Users often highlight its intuitive interface and the depth of analysis it provides as standout aspects.

In comparison to similar products, i2 Analyst's Notebook is frequently praised for its comprehensive feature set and reliability. Pricing typically varies based on the number of licenses and specific organizational needs, with options for annual subscriptions or perpetual licenses, making it adaptable to different budgetary requirements.

read more...
$2,900 Monthly
Get a free price quote
Tailored to your specific needs
$7,160 Annually
Get a free price quote
Tailored to your specific needs
Small 
i
Medium 
i
Large 
i
Small 
i
Medium 
i
Large 
i
Windows
Mac
Linux
Android
Chromebook
Windows
Mac
Linux
Android
Chromebook
Cloud
On-Premise
Mobile
Cloud
On-Premise
Mobile

Product Assistance

Documentation
In Person
Live Online
Videos
Webinars
Documentation
In Person
Live Online
Videos
Webinars
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support
Email
Phone
Chat
FAQ
Forum
Knowledge Base
24/7 Live Support

Product Insights

  • Real-Time Data: Keep up to date on the most recent numbers through real-time updates to dashboards and other visualizations.
  • Local Database: Uses an organization’s proprietary database to collect data — no need to rely on parallel data pipelines or data extracts.
  • Self-Service BI: Explore data through the self-serve function and then refine the automatically generated visualizations. Create custom dashboards to reflect specific KPIs based on the business’ specific needs.
  • Virtual Schema: Create live connections to over 35 SQL databases through a code-based virtual query-time schema. Keeps data visualizations secure and up-to-date.
  • Embedded Analytics: Embeddable through SSO, it can deploy into third-party solutions like a CRM or ERP as an embedded iframe or through Javascript. Empowers other software solutions with BI capabilities including reliable data, self-service analytics, actionable insights and intuitive dashboards.
read more...
  • Enhanced Data Visualization: Transforms complex data sets into intuitive visual formats, making it easier to identify patterns and relationships.
  • Improved Decision Making: Provides actionable insights through advanced analytics, aiding in more informed and timely business decisions.
  • Streamlined Investigations: Facilitates quicker and more efficient investigations by consolidating disparate data sources into a single, cohesive view.
  • Increased Collaboration: Enables teams to share and collaborate on data and findings in real-time, fostering a more integrated approach to problem-solving.
  • Enhanced Security: Offers robust security features to protect sensitive information, ensuring that data integrity and confidentiality are maintained.
  • Customizable Workflows: Allows users to tailor workflows to their specific needs, enhancing productivity and operational efficiency.
  • Scalability: Supports large volumes of data and can scale with the growth of your organization, ensuring long-term usability.
  • Reduced Operational Costs: By automating routine tasks and improving data accuracy, it helps in reducing the overall operational expenses.
  • Regulatory Compliance: Assists in meeting regulatory requirements by providing comprehensive audit trails and documentation capabilities.
  • Time Savings: Speeds up data analysis and reporting processes, allowing teams to focus on strategic initiatives rather than manual data handling.
read more...
  • Automated Modeling: Connects to relational databases and automatically generates models from the database schema.
  • Intuitive Visualizations: Generates visualizations in real time directly from the specified data source. Choose from an expansive library of visualization options like bar graphs, pie charts, Sankey diagrams, spider web charts, sunburst graphs, chord diagrams, heatmaps, funnels, treemaps and many more.
  • Time Zone Handling: Incorporates data seamlessly into the visualization, regardless of what time zone it is coming from.
  • LookML Data Modeling Language: Create scalable, reusable data models through the proprietary SQL-based data modeling language LookML.
  • Pre-Built Analytics Code: Use its Blocks feature as a starting point for building data analytics models with customizable code blocks. Includes optimized SQL patterns, custom visualization options, pre-built data models and more.
read more...
  • Data Visualization: Transforms complex data sets into intuitive visual charts and graphs, making it easier to identify patterns and relationships.
  • Link Analysis: Allows users to map and analyze connections between entities such as people, organizations, and events, facilitating deeper insights.
  • Temporal Analysis: Provides tools to create timelines and sequence events, helping to understand the chronological order and causality.
  • Geospatial Analysis: Integrates with mapping tools to visualize data geographically, aiding in the identification of location-based trends and patterns.
  • Data Integration: Supports the import of data from various sources including databases, spreadsheets, and other software, ensuring comprehensive analysis.
  • Search and Query: Offers advanced search capabilities to filter and query data efficiently, enabling users to find specific information quickly.
  • Social Network Analysis: Analyzes social networks to uncover hidden relationships and key influencers within a network.
  • Customizable Workspaces: Allows users to tailor their analysis environment to their specific needs, enhancing productivity and focus.
  • Reporting and Presentation: Generates detailed reports and presentations directly from the analysis, facilitating clear communication of findings.
  • Collaboration Tools: Enables multiple users to work on the same project simultaneously, promoting teamwork and information sharing.
  • Pattern Analysis: Identifies recurring patterns within data sets, which can be crucial for predictive analysis and decision-making.
  • Data Cleansing: Includes tools to clean and standardize data, ensuring accuracy and consistency in analysis.
  • Entity Extraction: Automatically extracts entities from unstructured data, such as text documents, to streamline the analysis process.
  • Integration with Other Tools: Seamlessly integrates with other IBM i2 products and third-party applications, enhancing its functionality and versatility.
  • Security Features: Implements robust security measures to protect sensitive data and ensure compliance with regulatory standards.
read more...

Product Ranking

#4

among all
Business Intelligence Tools

#270

among all
Business Intelligence Tools

Find out who the leaders are

User Sentiment Summary

Great User Sentiment 1836 reviews
Excellent User Sentiment 2 reviews
88%
of users recommend this product

Looker has a 'great' User Satisfaction Rating of 88% when considering 1836 user reviews from 5 recognized software review sites.

100%
of users recommend this product

i2 Analyst's Notebook has a 'excellent' User Satisfaction Rating of 100% when considering 2 user reviews from 1 recognized software review sites.

5.0 (20)
n/a
4.4 (1070)
n/a
4.6 (141)
n/a
n/a
5.0 (2)
4.4 (371)
n/a
4.1 (234)
n/a

Awards

we're gathering data

i2 Analyst's Notebook stands above the rest by achieving an ‘Excellent’ rating as a User Favorite.

User Favorite Award

Synopsis of User Ratings and Reviews

Reporting: Looker features strong reporting features that offer a degree of granularity and scheduling that 100% of users who mention reporting evaluate as a strong benefit.
Support: Of the users who say they’ve contacted customer support, 95% say the team’s quick and informative responses are a plus.
Data Accessibility: All users who mention accessibility to data say Looker does this well, distributing insights to employees across departments and teams with ease, with 100% of users mentioning this feature believing it is a benefit.
Show more
Visualizations: Users appreciate the ability to create clear and informative visualizations, such as link analysis diagrams, to quickly identify patterns and relationships in data. This helps them understand complex data sets and communicate insights effectively to stakeholders.
Data Integration: The software's ability to integrate data from various sources, including databases, spreadsheets, and text files, is a major advantage. This allows users to analyze data from different systems in a single platform, providing a comprehensive view of their business operations.
User-Friendly Interface: Users find the interface intuitive and easy to use, even for those with limited technical expertise. This makes it accessible to a wider range of users within an organization, enabling more people to contribute to data analysis and decision-making.
Security Features: The software's robust security features, including access control and data encryption, are essential for organizations handling sensitive data. This ensures that data is protected from unauthorized access and misuse.
Show more
Learning Curve: About 74% of users who touch on the platform’s ease of use say that the confusing documentation, lack of training opportunities and difficulty of using programming language make Looker a tough tool to pick up as a beginner.
Setup: Of the users who mention implementation, 81% say that setting up the platform is difficult, with integrations not being as plug-and-play as competitors and assistance from IT necessary to the setup process.
Speed: Approximately 87% of users who comment on the platform’s speed say that it is slow to render certain queries and often takes a while to load.
Functionality: About 78% of users who talk about Looker’s features say that they are left wanting many functions and find the ones that it does have limited in customization or too complex to use easily.
Show more
Steep Learning Curve: New users often find the interface and functionality overwhelming, requiring significant time and effort to master. This can be especially challenging for analysts who are new to data visualization and analysis tools.
Limited Data Connectivity: Connecting to various data sources can be cumbersome, especially for less common or specialized data formats. This can hinder the ability to integrate data from different systems and create a comprehensive view.
Performance Issues: Large datasets can lead to slow performance and lag, making it difficult to analyze data efficiently. This can be frustrating for analysts who need to work with large volumes of information.
Lack of Advanced Analytics: While Analyst's Notebook offers basic analysis capabilities, it lacks advanced features like predictive modeling or machine learning. This can limit its usefulness for organizations seeking to gain deeper insights from their data.
Show more

Looker is a forerunner in the business intelligence field for a reason; it generates reports that include easy sharing via link, automatic scheduling and a level of granular detail that allows for deeper analysis below the surface. It excels in its filter and drill-down features and creates unique URLs when users make changes to data, leading to enhanced sharing. However, one of its biggest strengths could also be considered one of its biggest weaknesses: its proprietary programming language, LookML which is used to construct SQL queries in the platform. While a flexible and powerful data querying language, of course, LookML isn’t the most accessible to non-technical users, which means that Looker requires an IT or data team to access its full capabilities and has a steep learning curve. Users also note that its data visualizations, while simple and easy to understand, are quite basic and lacking in customization options, particularly in comparison to competitors. Some users say that it may be more appropriate for internal reporting than presentation to shareholders and end-users because of its bare-bones visualization options. However, Looker truly shines when used by enterprises, with its scalability and data accessibility making it a stellar solution that can align departments and provide thousands of users access to data insights. Its price point reflects this, with its pricing being prohibitive to startups as about 88% of users who comment on its cost remark. Overall, Looker is a solid pick for larger businesses that have a team of power users who can maximize its functionality and set it up to deliver to employees across an entire organization.

Show more

User reviews suggest that i2 Analyst's Notebook is a powerful tool for analyzing complex data, but it's not without its flaws. Users praise its ability to visualize data and identify patterns, which is crucial for understanding complex investigations. For example, one user highlighted how the software helped them uncover connections between seemingly unrelated events, leading to a successful prosecution. However, some users complain about the software's steep learning curve and clunky interface, which can be frustrating for new users. One user likened the experience to trying to navigate a maze with a blindfold on. Despite these drawbacks, i2 Analyst's Notebook remains a popular choice for law enforcement and intelligence agencies due to its robust features and ability to handle large datasets. The software's strength lies in its ability to connect the dots, making it ideal for investigations involving complex networks of individuals and organizations. For example, it can be used to track the movement of money, identify potential threats, and analyze social media data. However, the software's complexity can be a barrier for users who are not familiar with data analysis techniques. It's not a tool for casual users; it requires a dedicated team of analysts with the skills and training to use it effectively. Overall, i2 Analyst's Notebook is a powerful tool for organizations that need to analyze large amounts of data and identify patterns. However, it's not for everyone. If you're looking for a user-friendly tool with a gentle learning curve, this might not be the right choice. But if you're serious about uncovering hidden connections and gaining actionable insights, i2 Analyst's Notebook is worth considering.

Show more

Screenshots

we're gathering data

Top Alternatives in Business Intelligence Tools


Cognos Analytics

Domo

GoodData

Grow

Logi Symphony

Looker Studio

MicroStrategy

Oracle Analytics Cloud

Power BI

Qlik Sense

QuickSight

SAP Analytics Cloud

SAS Visual Analytics

Sisense

Spotfire

Tableau

Related Categories

Head-to-Head Comparison

WE DISTILL IT INTO REAL REQUIREMENTS, COMPARISON REPORTS, PRICE GUIDES and more...

Compare products
Comparison Report
Just drag this link to the bookmark bar.
?
Table settings