Download Yellowbrick Data

Getting Started with Yellowbrick ​Welcome to the Getting Started Guide for Yellowbrick Data Warehouse!What's New in Yellowbrick Version 6 ​Yellowbrick Data Warehouse runs natively in a Virtual Private Cloud (VPC), using a Cloud Data Warehouse Manager (CDWM) control plane built on Kubernetes. The data warehouse is provisioned with Amazon AWS or Microsoft Azure hardware instances and provides a cloud-based SaaS platform for in-depth analysis of high volumes of data.The Yellowbrick Manager GUI provides quick and simple access to the system. You can use this single web-based interface to:Provision and manage Yellowbrick instances within your deployment, setting limits and policies for hardware resources. You can use the auto-suspend feature to set an idle timeout value and manage the cost of resource consumption in the cloud.Create and manage one or more Yellowbrick clusters per instance, with flexibility for assigning workloads or specific queries to different hardware resources as needed. Databases are independent of clusters; work within a particular database can be attached to different clusters with adjustable hardware and WLM resources.Create and manage users and roles, databases, schemas, tables, and other database objects.Bulk load tables from object storage via the Load Assistant or a SQL command (LOAD TABLE). Loads from parquet files are supported, as well as text and csv.Run queries, create database objects, and monitor activity.You can also connect to clusters using your own ODBC and JDBC applications and Yellowbrick ybtools.Prerequisites ​Yellowbrick Manager supports the current version and the last two public releases of the following browsers:ChromeFirefoxEdgeBefore loading your own data from object storage, make sure you have your AWS or Azure account credentials ready at hand.Be sure to install Version 6.3 ybtools before using these tools to connect to Version 6.3 databases.Additional Resources ​Videos to help you get started, available directly from Yellowbrick ManagerSample data sets for load and query testing, available from the Query Editor in Yellowbrick ManagerYellowbrick Manager Profile ​You may prefer running Yellowbrick Manager in "dark mode"; to switch from light to dark mode, go to the far-right "login" menu and select Profile.A few other profile settings are also available.In This SectionProvisioning the Data WarehouseTutorial: Creating and Using ClustersSQL-Based Loads from External StorageConnecting Tools and ApplicationsParent topic:Yellowbrick Documentation

In the current economic climate, CIOs are rethinking their cloud strategy. They face challenges on several fronts - the need to continue innovating and driving growth while reducing the cost of cloud data programs and bringing tangible value. As cloud economics practices mature, private cloud and hybrid cloud are regaining strategic impetus. Organizations need the flexibility to manage data in private cloud, public cloud, co-lo, and at the edge. Yellowbrick delivers on this “Your Data Anywhere” vision.Alongside new data management approaches such as data lakes, SQL based Data Warehouse technologies continue to prove their value as the primary business interface, with data lake vendors rushing to emulate their capabilities.With Dell Technologies’ this solution is designed and optimized to provide an elastic data management platform for SQL analytics at any scale.Business Challenges and BenefitsYellowbrick data warehouse meets these challenges with a unique architecture designed to maximize efficiency with hardened security and simplified management. Yellowbrick delivers everything you would expect from a modern high-performance SQL cloud data warehouse.It comes with cloud SaaS simplicity and elasticity with performance perfected through years of delivering value to customers in weeks and months and bills natively to exploit the power agility of the cloud.Yellowbrick uniquely combines its MPP database software, and highly engineered systems design, with an agile elastic modern Kubernetes-based architecture that delivers high efficiency and maximizes performance in every deployment scenario.Yellowbrick is engineered for maximum efficiency and price performance, supporting thousands of concurrent users on 1/5 of the cloud resources compare with competitors, maximizing data value with the simplicity and familiarity of SQL but with a unique pricing model that alleviates concerns over unpredictable cost overruns.Who is Yellowbrick? The Yellowbrick Data Warehouse is an elastic massively parallel processing (MPP) SQL database that runs on-premises, in the cloud, and at the network edge, it was designed for the most demanding batch real time and ad hoc and mixed workloads and can run complex queries at up to petabyte scale with guaranteed sub second response times. Yellowbrick is proven, providing business critical services at many large global enterprises with thousands of concurrent users. It is available on AWS, Azure, and Google Cloud as well as on-premises.SQL Analytics for The MassesCost-effectively supporting thousands of concurrent users running hundreds of concurrent ad-hoc queries, Yellowbrick leapfrogs competitors while still providing full elasticity with separate storage and compute. Meet Mission-Critical Service LevelsIntelligent workload management dynamically optimizes resources to ensure SLAs

Are consistently met without the need to scale out and spend more.Ultimate Control of Data SecurityYellowbrick’s data warehouse runs in your own cloud VPC or on-premises behind your firewall, allowing you to meet data sovereignty and governance requirements and pay for your own infrastructure.Engineered for Extreme Efficiency and PerformanceGet answers faster with our Direct Data Path architecture. Yellowbrick runs mixed ad-hoc ETL, OLAP, and real-time streaming workloads delivering the maximum benefit from any underlying infrastructure platform. Easy to Do Business WithOptimize your costs with flexible on-demand or fixed subscription – Yellowbrick is invested in your success, not in emptying your wallet. Our NPS of 82 is a testament to our customer partnership model and support excellence.Figure 1 The Yellowbrick AdvantageYellowbrick OverviewDesigned to run complex mixed workloads and support ad-hoc SQL while computing correct answers on any schema, Yellowbrick offers massive scalability and supports vast numbers of concurrent users. This means our clients gain deeper, more meaningful insights into their customers more quickly than ever before possible, setting us apart from other cloud data warehouses (CDWs).Figure 2 Yellowbrick ArchitectureIn an industry-first, full SQL-driven elasticity with separate storage and compute is available within your own cloud account as well as on-premises. Compute resources – elastic, virtual compute clusters (VCCs) – are created, resized, and dropped on-demand through SQL, and cache data persisted on shared cloud object storage. For example, ad-hoc users can be routed to one cluster, business-critical users to a second cluster, and more clusters created and dropped on demand for ETL processing.Each data warehouse instance runs independently of one another. There is no single point of failure or metadata shared across instances. Global outages – when deployed with replication across multiple public clouds and/or on-premises – are impossible.Yellowbrick is secure by default with no external network access to your database instance. Encryption of data at rest is standard with keys you manage. Columnar encryption, granular role-based access control, column masking, OAuth2, Active Directory, and Kerberos authentication are built in. Integrations with best-in-class enterprise data protection solutions secure PII data. Enterprise-class high availability, backups for data retention, and asynchronous replication for disaster recovery are standard. Management capabilities, Vantage offers significant value for your investment.Yellowbrick powered by Dell TechnologiesYellowbrick and Dell share solutions that address a variety of data analytic use cases:Mission-critical Reporting and BIData Warehouse modernization and consolidationData-intensive B2B Apps and Data MonetizationHybrid Cloud Big Data AnalyticsUnified features store for data

And an ecosystem of curated technology and service partners, Dell Technologies provides innovative solutions, servers, networking, storage, workstations, and services that reduce complexity and enable you to capitalize on a universe of data. ConclusionWhether you want to expand your existing capabilities or get started with your first project, Yellowbrick powered by Dell Technologies offers XYZ. For more information about the solutions, please contact the Dell Technologies Teradata Solutions team by email.Your company needs all tools and technologies working in concert to achieve success. Fast, effective systems that complement time management practices are crucial to making the most out of every employee hour. High-level data collection and processing that provides rich, detailed analytics can ensure your marketing campaigns strategically target your ideal customers and encourage conversion. To top it off, you need affordable products that meet your criteria and then some. After switching to Yellowbrick, our customers have seen dramatic gains in efficiency:Streamlined processes.Faster query times.Minimized data turnaround time.Richer, more accurate data.Increased customer growth.Affordable pricing with fixed-rate subscriptions for any deployment.No hidden fees or quotas.Predictable and reliable performance.Compatible with other components and applications.Highly capable system portability and accessibility.Innovative solutions.Little to no performance tuning.Ability to support a multitude of concurrent users.Enjoy quick, easy, and supportive migrationAt Yellowbrick, we are ready to provide you with simple, swift migration services. We complete most migrations in weeks, not months. Our 15-day proof of concept performance and operational testing period allows you to confirm that Yellowbrick is the right fit for your company. During this time, we will work closely with you to understand the requirements and scope a POC in your data center or in the cloud—whichever you prefer. We will set up a test instance, migrate your data, and integrate all necessary applications.Since Yellowbrick is based on PostgreSQL, the world’s most advanced open-source database, and natively supports stored procedures, it works out of the box quickly. Our data solutions are also compatible with common industry tools, such as Tableau, MicroStrategy, SAS, and Microsoft Power BI, as well as Python and R programming languages. Coupled with one day of setup and one week of testing, your team can hit the ground running almost immediately.Additionally, our broad partner network can help plan your transition, understand your data flows, and manage cutover with purpose-built tools and consulting services, so you can migrate from any platform.Additional ResourcesFor more information, please see the following resources: PowerEdge R660 Server Dell