var ecs_ajax_params = {"ajaxurl":"https:\/\/academy.credon.eu\/wp-admin\/admin-ajax.php","posts":"{\"page\":0,\"workshop\":\"practical-data-warehousing-with-sql-in-azure\",\"post_type\":\"workshop\",\"name\":\"practical-data-warehousing-with-sql-in-azure\",\"error\":\"\",\"m\":\"\",\"p\":0,\"post_parent\":\"\",\"subpost\":\"\",\"subpost_id\":\"\",\"attachment\":\"\",\"attachment_id\":0,\"pagename\":\"\",\"page_id\":0,\"second\":\"\",\"minute\":\"\",\"hour\":\"\",\"day\":0,\"monthnum\":0,\"year\":0,\"w\":0,\"category_name\":\"\",\"tag\":\"\",\"cat\":\"\",\"tag_id\":\"\",\"author\":\"\",\"author_name\":\"\",\"feed\":\"\",\"tb\":\"\",\"paged\":0,\"meta_key\":\"\",\"meta_value\":\"\",\"preview\":\"\",\"s\":\"\",\"sentence\":\"\",\"title\":\"\",\"fields\":\"\",\"menu_order\":\"\",\"embed\":\"\",\"category__in\":[],\"category__not_in\":[],\"category__and\":[],\"post__in\":[],\"post__not_in\":[],\"post_name__in\":[],\"tag__in\":[],\"tag__not_in\":[],\"tag__and\":[],\"tag_slug__in\":[],\"tag_slug__and\":[],\"post_parent__in\":[],\"post_parent__not_in\":[],\"author__in\":[],\"author__not_in\":[],\"search_columns\":[],\"ignore_sticky_posts\":false,\"suppress_filters\":false,\"cache_results\":true,\"update_post_term_cache\":true,\"update_menu_item_cache\":false,\"lazy_load_term_meta\":true,\"update_post_meta_cache\":true,\"posts_per_page\":10,\"nopaging\":false,\"comments_per_page\":\"50\",\"no_found_rows\":false,\"order\":\"DESC\"}"};
Hey you, are you responsible for implementing a BI solution that is future proof and allows for virtually infinite scaling? Do you recognize the qualities of Power BI as a state of the art reporting tool but feel limited by Power Query’s data transformation capabilities? Do you want to upgrade from a reporting environment to an integrated data analytics platform and leverage your SQL and Power BI skills in the process? Then stop looking, we got you covered!
What is it?
In our new training “Practical data warehousing with SQL in Azure” you will learn how to implement a practical and professional data warehouse solution from A to Z. We do this by following the Kimball dimensional data modeling principles for BI solutions. We build an analytics platform from a selection of Azure Data Services that together offer a rich and comprehensive suite of services, including data integration, data storage, data protection, data warehousing and data visualization.
You will get better at:
Kimball dimensional data modeling principles for BI solutions
Designing low-code pipelines that streamline your data traffic with Azure Data Factory
Shaping Azure Data Lake Gen 2 as the landing zone for your data sources
Writing SQL code in stored procedures for managing staged data transformations with Azure Sql Database
Securing connection strings and passwords with Azure Key Vault
Setting up fact and dimension tables that cook up the menu for self service analytics
Seamlessly plugging in Power BI on these datasets for creating insightful dashboards
What you must have:
Basic SQL knowledge (select, from, where, order by, group by, having, join, union, update, insert, delete, …)
Nice to have: The course is easier to follow if you already have some basic Power BI knowledge, or have are familiar with another BI tool.
Do you fit our brief? Then let’s get going!
Price
€600/day + 1 hour free follow-up with your trainer!
This workshop will be given by Gerrit Van Even. Our technical expert when it comes to data and BI. He’s been immersing himself in the SQL language and is a true data warehouse superhero.
Practical
Workshops start at 9h and are finished around 17h.
Credon provides sandwiches for lunch.
Dijkstraat 6, 2630 Aartselaar or Industrieweg 116, 3980 Tessenderlo
Participants have to bring their own laptop.
Workshops take place at a minimum of three subscribers.
What do you love about BI? Ever since I was a child, I’ve had something with lists. I made neat overviews of my comic strip collection, my music collection, etc. I then combined these to find out which other comics would suit my preferences. My child’s brain was already triggered by data. And not much has changed since then; only more available data and better tools to do something useful with it.
What do you love about teaching? Explaining complex thought patterns in an understandable way is like kneading a multitude of data streams into an accessible story that leads to insights. Witnessing the Aha-erlebnis of the students is simply priceless!
What do you love about BI? Using technology to generate insights that allow me to make factual decisions. I love finally being able to read data.
What do you love about teaching? Being able to spread the “good word” of data literacy. I love seeing people’s reactions when they, finally, figure out how powerful analytics truly are.
var HappyLocalize = {"ajax_url":"https:\/\/academy.credon.eu\/wp-admin\/admin-ajax.php","nonce":"5bb904999b","pdf_js_lib":"https:\/\/academy.credon.eu\/wp-content\/plugins\/happy-elementor-addons\/assets\/vendor\/pdfjs\/lib"};
var ElementorProFrontendConfig = {"ajaxurl":"https:\/\/academy.credon.eu\/wp-admin\/admin-ajax.php","nonce":"c1aa5563d7","urls":{"assets":"https:\/\/academy.credon.eu\/wp-content\/plugins\/elementor-pro\/assets\/","rest":"https:\/\/academy.credon.eu\/wp-json\/"},"shareButtonsNetworks":{"facebook":{"title":"Facebook","has_counter":true},"twitter":{"title":"Twitter"},"linkedin":{"title":"LinkedIn","has_counter":true},"pinterest":{"title":"Pinterest","has_counter":true},"reddit":{"title":"Reddit","has_counter":true},"vk":{"title":"VK","has_counter":true},"odnoklassniki":{"title":"OK","has_counter":true},"tumblr":{"title":"Tumblr"},"digg":{"title":"Digg"},"skype":{"title":"Skype"},"stumbleupon":{"title":"StumbleUpon","has_counter":true},"mix":{"title":"Mix"},"telegram":{"title":"Telegram"},"pocket":{"title":"Pocket","has_counter":true},"xing":{"title":"XING","has_counter":true},"whatsapp":{"title":"WhatsApp"},"email":{"title":"Email"},"print":{"title":"Print"},"x-twitter":{"title":"X"},"threads":{"title":"Threads"}},"facebook_sdk":{"lang":"en_US","app_id":""},"lottie":{"defaultAnimationUrl":"https:\/\/academy.credon.eu\/wp-content\/plugins\/elementor-pro\/modules\/lottie\/assets\/animations\/default.json"}};
var elementorFrontendConfig = {"environmentMode":{"edit":false,"wpPreview":false,"isScriptDebug":false},"i18n":{"shareOnFacebook":"Share on Facebook","shareOnTwitter":"Share on Twitter","pinIt":"Pin it","download":"Download","downloadImage":"Download image","fullscreen":"Fullscreen","zoom":"Zoom","share":"Share","playVideo":"Play Video","previous":"Previous","next":"Next","close":"Close","a11yCarouselWrapperAriaLabel":"Carousel | Horizontal scrolling: Arrow Left & Right","a11yCarouselPrevSlideMessage":"Previous slide","a11yCarouselNextSlideMessage":"Next slide","a11yCarouselFirstSlideMessage":"This is the first slide","a11yCarouselLastSlideMessage":"This is the last slide","a11yCarouselPaginationBulletMessage":"Go to slide"},"is_rtl":false,"breakpoints":{"xs":0,"sm":480,"md":768,"lg":1025,"xl":1440,"xxl":1600},"responsive":{"breakpoints":{"mobile":{"label":"Mobile Portrait","value":767,"default_value":767,"direction":"max","is_enabled":true},"mobile_extra":{"label":"Mobile Landscape","value":880,"default_value":880,"direction":"max","is_enabled":false},"tablet":{"label":"Tablet Portrait","value":1024,"default_value":1024,"direction":"max","is_enabled":true},"tablet_extra":{"label":"Tablet Landscape","value":1200,"default_value":1200,"direction":"max","is_enabled":false},"laptop":{"label":"Laptop","value":1366,"default_value":1366,"direction":"max","is_enabled":false},"widescreen":{"label":"Widescreen","value":2400,"default_value":2400,"direction":"min","is_enabled":false}},"hasCustomBreakpoints":false},"version":"3.24.5","is_static":false,"experimentalFeatures":{"e_font_icon_svg":true,"e_swiper_latest":true,"e_nested_atomic_repeaters":true,"e_onboarding":true,"home_screen":true,"link-in-bio":true,"floating-buttons":true},"urls":{"assets":"https:\/\/academy.credon.eu\/wp-content\/plugins\/elementor\/assets\/","ajaxurl":"https:\/\/academy.credon.eu\/wp-admin\/admin-ajax.php","uploadUrl":"https:\/\/academy.credon.eu\/wp-content\/uploads"},"nonces":{"floatingButtonsClickTracking":"5769da2175"},"swiperClass":"swiper","settings":{"page":{"premium_particles_zindex":0,"premium_particles_responsive":["desktop","tablet","mobile"]},"editorPreferences":[],"dynamicooo":[]},"kit":{"active_breakpoints":["viewport_mobile","viewport_tablet"],"global_image_lightbox":"yes","lightbox_enable_counter":"yes","lightbox_enable_fullscreen":"yes","lightbox_enable_zoom":"yes","lightbox_enable_share":"yes","lightbox_title_src":"title","lightbox_description_src":"description"},"post":{"id":127,"title":"Practical%20Data%20Warehousing%20with%20SQL%20Server%20-%20Credon%20Academy","excerpt":"","featuredImage":"https:\/\/academy.credon.eu\/wp-content\/uploads\/2020\/03\/practical-data-warehousing-1024x684.jpg"}};
