Product

Unified Business Intelligence Starts With Your Data Warehouse

Having a high-performance data warehouse is critical to running a successful business. It serves as your single source of truth, the end point for you data pipeline before analytics begins, and the central location for you analytics work.  Your data warehouse is the location where, in theory, all your data comes harmoniously together, breaking down the silos that crop up as a business grows. Whether it’s product usage, sales pipeline or marketing performance data it needs to be available in one location with the capability to provide fast, insightful analytics. 

That’s why Periscope Data has unveiled the Periscope Data Warehouse as a key component of the Unified Data Platform. With our experience running thousands of nodes across hundreds of clusters we can ensure your data warehouse is always operating with high-performance and high security — and is always ready to scale as your business grows.

If you want a detailed breakdown of the Periscope Data Warehouse we will be hosting a 30 minute webinar on Wednesday, Nov 15th. Click here to register — but for now let’s take a look at the challenges of database administration and the benefits of the Periscope Data Warehouse.

Hidden Challenges in Database Administration

The rise of cloud infrastructure has made it relatively easy to spin up a database. The ease of getting started, however, can hide the difficulties of database administration you’ll face down the line. Managing data warehouses is a daunting task, and it’s worth considering the complexity of administration. Things you’ll need to consider include:

  • Uptime — You need to ensure uptime for your analysts and dashboard users.
  • Fail overs — If your database has a hardware failure or becomes unhealthy, you must be ready to quickly move and restore it to healthy status.
  • Backups — Backup plans need to be put in place, and you need to be able to rapidly execute on them.
  • Optimization — Databases are challenging to run optimally even with experience, especially at organizations with lots of users. You need to account for concurrency, bad queries, indices, skew and more.
  • Workload management — Concurrency can kill a database, and unless you are carefully watching your database you can end up with a painfully slow experience.
  • Security & Compliance — Security is critically important, and very difficult to do well. If you require certifications such as HIPAA or SOC2 you’ll have a significant time investment on your hands.
  • Scaling — When your database is full and you need more disc space, you’ll need to smoothly manage the transition to more powerful infrastructure.

Simply put, to run a cloud warehouse well means a full-time DBA, or you’ll have the engineering or analytics teams spending their time learning the arcane art of database administration — and that means less product development, fewer insights and lost opportunities.

The Periscope Data Warehouse

Periscope Data solves those challenges for you with our next-generation Periscope Data Warehouse. Running on high-speed, dense compute AWS Redshift nodes, the Periscope Data Warehouse provides easy scaling, workload management, top-tier security and automated backups and fail-overs. We take care of administration for you, leaving you free to focus on driving your business. 

Our warehouse connects to any other existing data warehouse, and through our native integrations and our partners can ingest data from anywhere with easily scheduled refreshing — no more Python and cron to move data around, although you are free to connect to the warehouse with Python if you'd like.

Once data is in the warehouse it’s simple to perform cross-database joins from across your data sources. The results of your query can then be stored in version controlled, always-fresh views. This allows you to build your full ETL flow within the platform, and easily visualize your data’s transformation from source to chart in interactive dependency maps.

Periscope Data is also HIPAA and SOC2 certified, and conducts a variety of audits to ensure continuous compliance with industry-standard best practices. All Periscope Data certifications require an independent 3rd party to audit, and all data transferred across the Periscope Data network is encrypted with SSL/TLS connections. We also provide user level access control to your data, allowing you to control the flow of information within your company. Read more about our security here.

More Than a Warehouse

And the best part about this? You’re not simply buying the perfect data warehouse — you are getting a full analytics solution that will drive value from day one.

Using Periscope Data Analytics, a full featured SQL (and soon Python and R) editor and reporting solution, you can easily turn your newly transformed data directly into charts and dashboards you can share easily share with your colleagues.

It’s time to stop putting together solutions piece-by-piece and get a comprehensive solution. Once you’ve taken control of your data from source to sharing, you can build the data-driven organization you need to be — and it all starts with the proper infrastructure. Sign up for a trial today!

Want to discuss this article? Join the Periscope Data Community!

Sean Cook
Sean has chased the best tech from San Diego to NYC to SF working in GIS, data science and marketing. You can find him alternatively creating dazzling new analyses and driving content strategy at Periscope Data.