Data Engineering with Informatica, Snowflake and Streamlit

سرفصل های دوره

From source, through IICS, to Snowflake tables, dashboards and Streamlit apps in a single stack

1. Introduction

1. Introduction to the course

2. Snowflake Setup

1.1 01 Source Data and Mapping Sheet.xlsx

1. Creating a Snowflake account

2. Loging into Snowflake

3. Creating Databases and Schemas

4. Creating course tables - 1

5. Creating course tables - 2

6. Creating course tables - 3

7.1 07 Source Data and Mapping Sheet.xlsx

7. Creating course tables - 4

3. IICS Setup

1. Creating an IICS Data Integration trial account

2. Installing the local secure agent

3. Creating a flat file connection

4. Creating a Snowflake connection

5.1 12 iicscourse.zip

5. Setting up a parameter file

4. SOS - Changing objects permissionownership on Snowflake

1. Updating objects ownership on Snowflake

5. IICS Data Ingestion

1.1 14 iicscourse.zip

1. Source files overview

2. STG Product Mapping

3. Issue on using mapping task instead of mass ingestion for loading files

4. STG Touchpoint Mapping

5. PSA Calendar

6. STG Media Spend

7. Data Review

6. IICS Delete + Insert

1. PSA Product Mapping

2. PSA Product Mapping

3. PSA Media Spend

7. DWH Logic

1. DWH mapping - 1

2. DWH mapping - 2

3. DWH mapping - 3

4. DWH mapping - 4

5. DWH mapping - 5

6. DWH mapping - 6

7. DWH mapping - 7

8. Snowflake Dashboard

1. Snowflake Dashboard Design - 1

2. Snowflake Dashboard Design - 2

3. Snowflake Dashboard Design - 3

4. Snowflake Dashboard Design - 4

5. Snowflake Dashboard Design - 5

6. Snowflake Dashboard Design - 6

7. Snowflake Dashboard Design - 7

9. Streamlit - Master Product App

1. Product Master app design - 1

2. Product Master app design - 2

3. Product Master app design - 3

4. Product Master app design - 4

5. Product Master app design - 5

6. Product Master app design - 6

7. Product Master app design - 7

8. Product Master app design - 8

9. Product Master app design - 9

10.1 47 st product app.zip

10. Product Master app design - 10

10. Streamlit - Mapping Apps

1. Product mapping app design - 1

2. Product mapping app design - 2

3. Product mapping app design - 3

4.1 51 st product mapping app.zip

4. Product mapping app design - 4

5. Touchpoint mapping app design - 1

6. Touchpoint mapping app design - 2

7.1 54 st touchpoint mapping app.zip

7. Touchpoint mapping app design - 3

11. Course Review

1. Historical load

2.1 56 iicscourse.zip

2. Course Review

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy