Your new analysts spend half their time looking for data, your experienced analysts spend half their time helping recent hires, and when senior analysts leave the company, they take lots of data knowledge with them. In a complex data environment, writing a single query can take days. Sometimes an analyst will work on a question for weeks before realizing that someone else had previously produced an answer. Yet often, when two analysts try to answer the same question, the resulting numbers differ, so the decision makers can’t trust either one! Your analysts’ time is valuable: every hour they spend on actual, accurate analysis could yield thousands of dollars for your company. They shouldn’t have to waste so much time just finding the right dataset, learning how to use it, reinventing the wheel, or making avoidable mistakes and then backtracking.
Reduce analyst on-boarding by up to 50%
Increase the productivity of your analysts
Yield faster time-to-insight for your business
Reduce data infrastructure costs
Analysts: Get your work done, faster.
First, you have to find the right data: Where—among the many databases and file systems in your organization—is the right table (it could be in any one of the many databases and file systems in your organization)? When was it last updated? How is the revenue column calculated? Are people using it? Then, you need to figure out how to use the data: How do you join these two tables? What’s the right definition for retail products and which column should you use? Often, you have to find the expert and wait for them to have the time to answer your questions. And more often than not, you are at the mercy of the expert’s limited time because they have a lot to do.
Find data faster
Want to find written queries by a trusted teammate using a particular table? Or to find tables on a certain topic? Search by keywords and filter by a variety of facets to radically accelerate your data exploration process.
Searchable, Comprehensive Data Documentation
Alation automatically builds a Catalog of useful data documentation, covering all of your data sources. Access relevant information (including experts, lineage, keys and indexes, relevant queries) and documentation on all tables, across your organization’s data sources, in seconds.
Lists of Top Tables and Queries
First day on the team? Alation helps you understand which tables and queries to start your learning with. See which tables are most often used using automatically calculated popularity ratings. Find most executed queries using Query Search across your company’s entire SQL code base.
As you write SQL, Alation auto-suggests relevant data objects based on what others have used in similar contexts. Analysts can even search and pick SQL snippets (e.g., filters or join conditions) using keywords. It’s the most helpful tool you’ve ever used for writing SQL.
Profiles & Data Preview
Preview a table as you’re writing your query to make sure you’re using the right data. See sample rows, understand the usage patterns, see tips and warnings from your peers. Get the context behind the data you’re about to query. It’s a heads-up display for your data.
Instead of looking up country codes and enumerated types in a bunch of wiki tabs whenever you write a query, just type in English, and watch as Alation “translates” words into filters and functions (e.g. when you type “China,” Alation can suggest “cntry_cd = 156”). It works like magic and saves lots of time since you’ll avoid research and mistakes.
Query Sharing & Discovery
No more emailing CSV files and SQL code. Share queries and results with team members using web links accessible from any machine and any browser. Or discover colleagues’ queries with ease, using Query Search over all the SQL ever written at your company.
Tagging and Workspaces
Organize your work by tagging conversations, queries, tables, or query results. For example, you could create a “Traffic” tag to identify useful SQL snippets for the Traffic team.
Conversations & Articles
Alation offers wiki and forum functionality specifically designed for sharing knowledge about data. Instead of copying SQL into a page as text, with Alation you can just type ‘@’ to insert a live link to a query—it will be beautifully formatted and will reflect the latest updates. Visitors can then execute it with a click, or branch off their own version. And if you reference a table in a document, a reader can expand it in place to see sample rows, column types, and documentation without switching contexts.
Discover the Expert
Have a question about a table or column? Alation examines prior querying behavior to find the expert fast. And when an expert responds to a questions once in Alation, the answer will persist for all users in the future.
Powerful query IDE
Querying Pro Tools
Query across any database in your company with a single, consistent interface. Schedule queries to run as lightweight jobs. Add variables to create template queries. Stream gigabytes of query results. Alation is industrial strength.
R & Python API Extensions
Alation offers APIs to extend your queries and results into your R and Python code. By keeping your SQL and results in Alation, not only can you write SQL faster and with less error, but you can also make your SQL easier to maintain.
Power text editor
Our query tool, Alation Compose, includes features for formatting and error highlighting, script mode, and more, with unified access to all data sources in your company. Query warnings appear to guide you if you’ve written a query that might not be up-to-snuff with your DBAs, and SmartSuggest helps you write accurate queries, quickly.
Query Anywhere! Offline Execution
After pushing ‘Run’ in Alation Compose, you can close the window, quit the browser, shut down the computer, or even spill coffee on the hard drive. No matter what happens, the next time you connect—from any machine—your query results will be waiting for you.