Snowflake Services

2 days workshop

Your team has done Snowflake onboarding classes and Snowflake certification and understand how Snowflake Data Cloud works.
They have knowledge about Snowflake User interface, user roles and administration, DB navigation, data exploration, warehouses concepts, creating objects, staging data, data storage, data ingestion and transformations (structured and semi structured data, cost monitoring, activity monitoring…).
Our expert Snowflake trainers address your most important questions and bring you to the next level.

OUTCOMES:

• asses your reference future architecture,
• learn best practices, potential pitfalls and possible optimizations,
• understand how to write a code in optimal way to optimize cloud spending,
• know how to utilize unique Snowflake features like: time travel, multi cluster architecture, scaling,
• build a modern ELT pipeline using Snowflake tasks and external functions,
• learn how to prepare data models to best utilize modern BI tools.

Who should attend (technical training):
Data analysts, Data engineers, Data scientists, Data warehouse architects, Database administrators, business intelligence users

Knowledge level needed:
Training is intended for people with existing Snowflake knowledge.

Pricing: 4.000 €

4 days workshop

Read further if your team is new to the cloud solutions. They have been working with traditional analytical solution mostly on-premises and decided to start the cloud journey. You have done self-paced trainings to get basic understanding and concepts of Snowflake Data Cloud. Your fist goal is to learn Snowflake data cloud to an extent that your team would be ready to take the next step, get certified and reap the knowledge of new cloud concepts (how to move data from on premises to the cloud quickly and efficiently, how to automate as much as possible, adopt new modern ELT approach vs. ETL to utilize cloud resources as much as possible, how to write the code optimally, …
Based on your current set up we will suggest a new modern cloud architecture. Our expert Snowflake trainers will tailor the training to your needs and equip your staff with the knowledge and address all aspects of modern cloud solutions and concepts. We will go from theory to hands-on labs (from Zero to Snowflake).

OUTCOMES:

• learn how to plan step by step migration/greenfield approach to the cloud,
• which steps to be taken and in what order,
• what modern tools are available and how to utilize them,
• know expected cloud resource costs,
• learn best practices, potential challenges, and opportunities,
• write a code in an optimal way to optimize cloud spending,
• understand how to utilize unique Snowflake features like: time travel, multi cluster architecture, scaling…;
• how to build a modern ELT pipeline and how to prepare data models to best utilize modern BI tools.

Who should attend (technical training):
Data analysts, Data engineers, Data Scientists, Data warehouse architects, Database administrators, BI users

Knowledge level needed:
Training is intended for people with basic Snowflake knowledge.

Pricing: 7.000 €

You are asking yourself the following questions:
What use cases to start with?
How to prepare a detailed project migration/development plan?
What should be your priorities (business, technical, or both)?
How to set up and steer your team?
Should you outsource or do it in-house?
How to build a detailed architecture, ELT, data marts yes or no?
Introduce new BI and data science tools that would fit better or migrate the old workloads?
How to prepare for testing?
Can you do the lift and shift as is or we need to re-engineer?
What can you automate?
Do you need a backup scenario?
What are the potential bottlenecks and pitfalls you should avoid?

This pack provides you with a guided consultation in a series of in-depth interactive workshops. Our common goal here is to help you address questions of overall architecture, project management, and final services cost.

To really comprehend your organization’s unique needs, we need to deep-dive into your business and industry. We want to know everything about your technical needs, expectations, and priorities.

OUTCOME 1:
Detailed documentation and project plan

• Document the existing solution (architecture, list of dbs, db objects, schemas, security,process and tools that move data into our/out of existing solution- data ingestion tools, ETL/ELT, BI, Data science and AI…)
• Migration use cases (draft of deliverables) and define high level strategy: lift and shift – migration as-is, reingeeniring or lift and shift + modernization and planned future architecutre diagram
• Development and deployment process: list of existing and/or new tools for migration, production/development environment, define deployment process
• Set priorities for migration (what data sets to migrate first, data sets depencencies to lower the challenges down the road)
• Set up the migration team (team members and their roles on the project)
• Migration project timeline (business and technical expectations, detailed migration plan and budget required for the Snowflake resources and migration services)
• Risk factors (asses possible risk factors based on the strategy chosen and possible plan B)
• Success factors (set KPIs and success metrics)

With an agile approach »think big, start small« we define project delivery concept:

• phased project delivery,
• MVP and in the next step deliver a prototype (in case of major uknowns).

OUTCOME 2:

• A defined overall architecture, migration strategy, cut-over strategy, system testing & reconciliation strategy
• Have an assigned project team, project roles and responsibilities
• Get delivered an end-to-end migration schedule, including a detailed plan and list of migration tasks.

Who should attend?
Key project stakeholders. 

A good plan is crucial for successful execution.

Cloud migration is not just about simply moving your existing environment to the cloud, it requires a deep dive into your legacy systems, existing code, tools and business cases. Not going into detail means that 90% of the project may be migrated quickly and without much effort, but the other 10% of issues can kill and delay your execution plan.

In our workshops, we will take you on a journey and look at the skeleton of your existing environment with you. Together we will decide what kind of migration plan is better by going case by case, we will make an overview of your existing ETL/ELT jobs and code, decide what needs to be modernised and what can be reused. The key question is also what tools will be used in your future architecture to optimise the workloads and speed up the migration process.

OUTCOMES:

• Detailed architecture
• Step-by-step migration plan
• Detailed project plan (timeline)
• Effort estimation:
  • Fixed base effort:
    • ETL/ELT jobs
    • Code conversion
  • Variable effort:
    • Modernisation
    • Optimization

Duration: 4-7 weeks (based on complexity)

However, if you are skeptical about your proposed migration path, it may be worth seeking a second opinion for one of the following reasons:
You are not aware if your migration to cloud is simple or complex?
You doubt that cloud technology is right for you?
Your plan was determined without diving deep into your existing environment and code?
You have a list of offerings that vary widely in cost.


Based on our experience with various migration projects, we know that there is no perfect way how migration to the cloud should look like and therefore there is no generic calculator that defines how much effort is required to execute the migration plan.

In these cases, we offer a set of workshops where we assess your current migration plan, overall cloud strategy, intended architecture, current environment, business requirements and provide you with revised plan and potential recommendations.

Whether you’re planning to move to the cloud on your own, with a partner you’ve already selected, or looking for a new service provider, give us a call and we’ll help you make the right move.

Who should attend? Key project stakeholders 

Duration: 2 – 5 day consultation

Pricing: 2.500 – 5.000 €

We can help you properly evaluate modern data warehouse architecture on your data, define the most important use cases and KPIs to measure against your current solution.  With Snowflake data cloud you will be able to reap the benefits of modern cloud solutions by addressing any use case that your business needs, without resource contention or infrastructure limitations. With scalability, concurrency, and access to all of your data, speedy and accurate decision-making will be at your fingertips.

POC services include but are not limited to:

• Introduction of new modern architecture
• Loading data to the cloud
• Concurrency testing (workload isolation)
• Scalability and elasticity
• Modern ELT approach and BI workloads
• Semi-structured data
• Security and user roles
• Spend monitoring (per-second billing)

OUTCOMES

During the POC we will define the project scope and success criteria. The idea is to test End2End architecture including modern ELT tools for data ingestion and transformation to take the cloud advantages and test your existing or new BI/data science tools against Snowflake.

• How to set up and run Snowflake instance on any public cloud
• Define modern end2end solution environment
• How to set up data Pipelines (ETL/ETL) for the specific business use case (for structured and semi-structured data)
• Staging
• Development and Production Environment
• Business Intelligence/data science tools Integration

Services included:

• Methodology revision
• Architecture revision
• Code revision
• Code optimization
• Security revision

A good use case needs to and business value, so your current challenges and desires are at the core of this.

With minimal up-front investment and reduced need for in-house expertise, you are just one step away from realizing different approaches from the latest trends from your industry on how to think big but start small and fast.

Let us reshuffle the cards of your data sets and open a fresh view of your business.  These are the cases where we can unleash creativity and prepare some real mind-boggling insights that you might not be even aware are there for you.

The list of new use cases is endless, from data sharing possibilities to AI and data lake options – whom better to explore them with than with Snowflake’s most Innovative partner of 2021 in EMEA region.

DataMerlin, Data Warehouse Automation Platform – save time, money & heaps of stress by automating your ETL processes.

Meet the wizard

antFarm, Data Migration Solution – Lift ‘n’ shift your data from on-premise to cloud in a single day. 

Meet the diligent ants

Codify, MDM application – manage your master data and process governance.

Meet the MDM master

Parsaur, The Code Transformation and lineage tool – translate code from one language to another and convert platform-specific capabilities and features

Meet our dino