Enterprise Data Warehousing for SMBs

This three-week course explores Cloud Data Warehousing and Data Lakes, covering critical aspects weekly. In the first week, participants delve into understanding the distinctions from traditional databases, exploring use-cases, evaluating Cloud Native vs Third-Party Data Warehouses, and comparing trade-offs between speed, convenience, and cost. The second week focuses on data loading, pipelines, and security, addressing differentiation of data types, ETL processes, real-time data integration, and security considerations. The final week delves into data preparation, modeling, and actionable insights, covering transformations, data modeling, BI tool connections, and activation for Business Process Automation. Designed for professionals in marketing, sales, product, and operations, the course equips participants to understand, implement, and optimize Cloud Data Warehousing solutions.

Obsessive Analytics tailors data solutions, from small databases to large projects. This training clarifies data warehouse benefits, helps identify the right type, and outlines necessary resources. Participants gain insights to build a robust business case, showcasing real-world benefits and costs beyond buzzwords.

The term data warehouse is extremely broad and can range from small “reporting databases” all the way to multi-million dollar infrastructure projects. Finding the right data infrastructure solutions for clients is what Obsessive Analytics does and this training is meant to provide some much needed clarity around:

1. The benefits a data warehouse can bring to your business
2. What kind of data warehouse – if any – would suit you best
3. What kind of resources are required to make it work

This should enable participants to make a proper business case that goes beyond the buzzwords and provides concrete examples of real-world benefits a data warehouse can provide and at what cost.

Course Outline

This training is split into three 4-hour sessions. Besides this, every organization in attendance will receive one hour of one-on-one time to be scheduled after the conclusion of the training. This time so that companies are able to ask questions that are specific to its business processes and use-cases in a private setting.

Who should take this course?

This course is designed for professionals performing data & business analysis activities in marketing, sales, or product or their respective operations levels. It is equally beneficial for front-line analysts as well as their managers as this course both covers the operational planning aspects of modern cloud data warehousing and practical considerations that help optimize costs and performance to fit the SMB segment. Positions that this course would be beneficial for include but are not limited to:

• Data / business analysts
• Data / marketing / sales operations professionals
• Product Managers
• SEO & Paid Advertising professionals, both internal and external (agencies, freelancers, etc.)
• Marketing leaders like Chief Marketing Officers (CMOs), directors, managers