{"id":17,"date":"2025-10-06T19:23:55","date_gmt":"2025-10-06T19:23:55","guid":{"rendered":"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/?page_id=17"},"modified":"2025-12-05T12:19:58","modified_gmt":"2025-12-05T12:19:58","slug":"hands-on","status":"publish","type":"page","link":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/hands-on\/","title":{"rendered":"HANDS ON"},"content":{"rendered":"\n<ol class=\"wp-block-list\">\n<li>ETL Lab \u2014 Heterogeneous Data Sources to a Snowflake Data Warehouse [<strong>PDF<\/strong>] [<a href=\"https:\/\/gist.github.com\/gevargas\/a5b7ef293914d3c019131d3b61487ed4\"><strong>GIST<\/strong><\/a>]\n<ul class=\"wp-block-list\">\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/design-workshop-towards-the-definition-of-snowflaking-guidelines\/\" data-type=\"page\" data-id=\"38\">Design workshop: towards the definition of snowflaking guidelines<\/a><\/li>\n\n\n\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/etl-reading-control-students-worksheet\/\" data-type=\"page\" data-id=\"52\">ETL unbranched workshop through use cases<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>First steps into the population of a Snowflake Data Warehouse [<a href=\"https:\/\/gist.github.com\/gevargas\/8aeb2529757b559c48dd02ce1827c109\"><strong>GIST<\/strong><\/a>] &#8211; Homework<\/li>\n\n\n\n<li>Initial and mastery activities for addressing OLAP queries\n<ul class=\"wp-block-list\">\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/sql-madness-getting-ready-for-big-challenges\/\" data-type=\"page\" data-id=\"83\">SQL Madness getting ready for big challenges<\/a> [<a href=\"https:\/\/drive.google.com\/file\/d\/1vD_9W5huqejDBzSqXzFKe-f17fu8yALO\/view?usp=sharing\"><strong>PDF<\/strong><\/a>] version<\/li>\n\n\n\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/olap\/\" data-type=\"page\" data-id=\"91\">First touch into OLAP<\/a> [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/1Y3HTvgfEPc5Gd9qkMz5qrvG6DuFtb2f1\/view?usp=sharing\">PDF<\/a><\/strong>] version<\/li>\n\n\n\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/mastering-olap\/\" data-type=\"page\" data-id=\"99\">Mastering OLAP<\/a> &#8211; Homework [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/1Tc5b9UidtKot6I98NphzvltvHYoVSSJy\/view?usp=sharing\">PDF<\/a><\/strong>] version<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Data cleaning and preparation\n<ul class=\"wp-block-list\">\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/experience-cleaning-tabular-data-using-python\/\" data-type=\"page\" data-id=\"119\" target=\"_blank\" rel=\"noreferrer noopener\">Experience cleaning tabular data using Python<\/a> [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/1Fr8_rgGojk0pi1RpCXMeHs0SrpeYJ4jq\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">PDF<\/a><\/strong>] version<\/li>\n\n\n\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/cleaning-tabular-data-using-talend\/\" data-type=\"page\" data-id=\"122\" target=\"_blank\" rel=\"noreferrer noopener\">Experience cleaning tabular data using Talend <\/a>&#8211; Homework [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/1sHBXHi3efjaREA-c58pYm9yd507QfKSD\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">PDF<\/a><\/strong>] version<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Wong exercises towards CaptStone Project specification [<a href=\"https:\/\/drive.google.com\/file\/d\/1I74bDA9SiOnqXCmYOU26nin3GJ9Vl3HT\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>PDF<\/strong><\/a>]<\/li>\n\n\n\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/data-cleaning-lab-towards-a-silver-data-lake\/\" data-type=\"page\" data-id=\"142\" target=\"_blank\" rel=\"noreferrer noopener\">Data Cleaning Lab towards a Silver Data Lake <\/a>[<a href=\"https:\/\/drive.google.com\/file\/d\/1pmNfaPiP7YLlkQVb-Dov4HdQ3xE7bAF3\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>PDF<\/strong><\/a>]<\/li>\n\n\n\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/responsible-cloud-fog-edge-deployment-for-a-lakehouse-data-warehouse\/\" data-type=\"page\" data-id=\"148\" target=\"_blank\" rel=\"noreferrer noopener\">Responsible Cloud\u2013Fog\u2013Edge Deployment for a Lakehouse Data Warehouse<\/a> [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/14YznHCalvuao0f1MKq3JCGbZbdiBVnhN\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">PDF<\/a><\/strong>]<\/li>\n\n\n\n<li><a href=\"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/planning-and-resourcing-a-bi-data-analytics-project\/\" data-type=\"page\" data-id=\"157\" target=\"_blank\" rel=\"noreferrer noopener\">Project management considerations<\/a> [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/1jg0c5VET9kAHmZqBVvRc1JMiNBuuUoK2\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">PDF<\/a><\/strong>]<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":11,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-17","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/pages\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":21,"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/pages\/17\/revisions"}],"predecessor-version":[{"id":160,"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/pages\/17\/revisions\/160"}],"wp:attachment":[{"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/media?parent=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}