{"id":10,"date":"2025-10-06T19:17:14","date_gmt":"2025-10-06T19:17:14","guid":{"rendered":"http:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/?page_id=10"},"modified":"2025-11-26T21:13:04","modified_gmt":"2025-11-26T21:13:04","slug":"content","status":"publish","type":"page","link":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/content\/","title":{"rendered":"CONTENT"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong>Module 1: Introduction to Business Intelligence (2 hours)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>BI foundations and value chain: data to decision<\/li>\n\n\n\n<li>User profiles (&#8220;user hats&#8221;): decision-makers, data engineers, analysts<\/li>\n\n\n\n<li>Organizational and technological context<\/li>\n\n\n\n<li>Use cases and cross-sector applications<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Module 2: Data Warehousing (15 hours)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Architectures (2h): Data warehouses, data marts, centralized vs distributed models<\/li>\n\n\n\n<li>Multidimensional Modeling (3h, incl. 1 lab): Star and snowflake schemas, fact and dimension tables<\/li>\n\n\n\n<li>Data Integration &amp; ETL (3h, incl. 1 lab): ETL pipeline, tools and practical design scenarios [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/15I20Oo1VjY1yhSwGbRAAjvxlMHNmP6_a\/view?usp=sharing\">PDF<\/a><\/strong>] <\/li>\n\n\n\n<li>Physical Implementation (2h): Storage optimisation, indexing, partitioning [<a href=\"https:\/\/drive.google.com\/file\/d\/1XMwQASPxBfyIWV64OR4CrgIIUf3-ex8w\/view?usp=sharing\"><strong>Part-<\/strong>1<\/a>]<\/li>\n\n\n\n<li>OLAP &amp; Querying (3h, incl. 2 labs): SQL challenge, OLAP cube exploration (<strong>see Hands On<\/strong>) [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/1kLQuJWaJypoK8lkHJTceb2-XO-ACmlmk\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">PDF<\/a><\/strong>]<\/li>\n\n\n\n<li>Project Design Lab (2h, incl. 1 TD): Requirements gathering, governance, data quality [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/1xStpkiXTxWehWaB5t3-VMRGWuxFk-sR9\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">PDF<\/a><\/strong>]<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Module 3: Data Lakes &amp; Lakehouses (4 hours)<\/strong> [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/19jebRoYWJUMzChxr1cVCd54qPfIVcf6e\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">PDF<\/a><\/strong>]<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Architectures (1h): Data lakes vs lakehouses, hybrid architectures<\/li>\n\n\n\n<li>Metadata Management (1h, incl. 1 lab): Data catalogs, schema-on-read, lineage tracking<\/li>\n\n\n\n<li>ELT &amp; Data Processing (1h): Metadata extraction, pre-processing strategies<\/li>\n\n\n\n<li>Maintenance &amp; Analytics (1h, incl. 1 lab): Dashboards, user access policies<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Module 4: BI in the Cloud (4 hours)<\/strong> [<strong><a href=\"https:\/\/drive.google.com\/file\/d\/11hXQQffcmDZ8fXmU-z--P9iNcC-sabz7\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">PDF<\/a><\/strong>]<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Deployment Models (1h): Edge, fog, and cloud strategies<\/li>\n\n\n\n<li>Strategic Deployment Decisions (1h, incl. 1 lab): Economic vs human cost trade-offs<\/li>\n\n\n\n<li>Technological Independence &amp; Sustainability (2h): Vendor lock-in, open standards, green IT<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Module 5: Final Project \u2013 BI Demo Fest (13 hours)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>BI Project Management (4h): Agile frameworks, team roles, planning tools<\/li>\n\n\n\n<li>BI Lifecycle (5h): From data sourcing to dashboarding<\/li>\n\n\n\n<li>Final Presentation &amp; Demo (4h): Project pitch, visual storytelling, peer review<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Module 1: Introduction to Business Intelligence (2 hours) Module 2: Data Warehousing (15 hours) Module 3: Data Lakes &amp; Lakehouses (4 hours) [PDF] Module 4: BI in the Cloud (4 hours) [PDF] Module 5: Final Project \u2013 BI Demo Fest &hellip; <a href=\"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/content\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":11,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-10","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/pages\/10","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=10"}],"version-history":[{"count":12,"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/pages\/10\/revisions"}],"predecessor-version":[{"id":154,"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/pages\/10\/revisions\/154"}],"wp:attachment":[{"href":"https:\/\/vargas-solar.com\/data-ware-lake-houses-bi\/wp-json\/wp\/v2\/media?parent=10"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}