{"id":2865,"date":"2026-10-04T11:05:05","date_gmt":"2026-10-04T11:05:05","guid":{"rendered":"https:\/\/skti.co.th\/site\/?page_id=2865"},"modified":"2026-10-08T07:10:05","modified_gmt":"2026-10-08T07:10:05","slug":"analytics-tool-power-bi","status":"publish","type":"page","link":"https:\/\/skti.co.th\/site\/courses\/data-visualization-storytelling\/analytics-tool-power-bi\/","title":{"rendered":"Analytics Tool – Power BI"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Analytics Tool - Power BI<\/h1><\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Build practical data analytics skills with Microsoft Power BI, from connecting and preparing data to developing models and dashboards. This course introduces Power Query, table relationships, and DAX, then brings these skills together through a workshop based on departmental business questions. Participants develop a working dashboard prototype, explore its findings, and consider how to apply the insights in their work. The course scope can also include advanced DAX, performance optimization, and Row-Level Security, depending on the agreed learning needs.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tEnquire About This Course<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"collaborative\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Course at a Glance<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n\n\n\n\n\n\n\n\n
Description<\/th>\nDetail<\/th>\n<\/tr>\n<\/thead>\n
Duration<\/td>\n2 days; a 1-day foundation program is also available.<\/td>\n<\/tr>\n
Format<\/td>\nClassroom workshop.<\/td>\n<\/tr>\n
Learning Approach<\/td>\nPractical exercises, dashboard development, and presentation with feedback.<\/td>\n<\/tr>\n
Prerequisites<\/td>\nData connections, Power Query, data modelling, DAX, and dashboard development.<\/td>\n<\/tr>\n
Course Output<\/td>\nA working Power BI dashboard prototype for a departmental use case.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Learning Objectives<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

By the end of the course, participants will be able to:<\/p>\n

    \n
  • Connect Power BI to relevant data sources.<\/li>\n
  • Clean and transform data using Power Query.<\/li>\n
  • Build a data model with appropriate table relationships.<\/li>\n
  • Use DAX to support analytical calculations.<\/li>\n
  • Develop a dashboard that addresses departmental business questions.<\/li>\n
  • Interpret dashboard findings and identify practical next steps.\u00a0<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t

    Course Outline<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Day 1 \u2014 Prepare Data & Build the Foundation<\/h3>\n

    Module 1: Power BI Fundamentals & Data Connections<\/strong>
    Explore the Power BI workflow and connect to data sources for analysis.<\/p>\n

    Module 2: Data Preparation with Power Query<\/strong>
    Practice cleaning and transforming data into a structure suitable for reporting and analysis.<\/p>\n

    Module 3: Data Modelling & Table Relationships<\/strong>
    Organize data into a model and establish relationships between tables.<\/p>\n

    Module 4: Dashboard Development Workshop<\/strong>
    Begin building a dashboard based on a departmental business question.<\/p>\n

    Day 2 \u2014 Develop the Dashboard & Apply Insights<\/h3>\n

    Module 5: Analytics Model & Dashboard Workshop<\/strong>
    Continue developing the model and dashboard, applying calculations and visuals relevant to the selected use case.<\/p>\n

    Module 6: Insight Discovery & Action Planning<\/strong>
    Explore the dashboard to identify meaningful findings and discuss how they can support business actions.<\/p>\n

    Module 7: Presentation & Feedback<\/strong>
    Present the dashboard, explain its findings, and receive feedback to refine the output.<\/p>\n

    Optional 1-Day Foundation Program<\/h3>\n

    A focused introduction covering data connections, basic Power Query, introductory data modelling and DAX, followed by a dashboard workshop and presentation with feedback.<\/p>\n

    Advanced Topics<\/h3>\n

    Advanced DAX, performance optimization, and Row-Level Security can be included according to the agreed course scope and participant readiness.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t

    Who Should Attend<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Professionals, analysts, and departmental teams who want to use Power BI to prepare data and build reports or dashboards for their work. The foundation program suits participants starting with Power BI, while the broader program supports those seeking to develop their modelling, calculation, and analytical reporting skills.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

    Analytics Tool – Power BI Build practical data analytics skills with Microsoft Power BI, from connecting and preparing data to developing models and dashboards. This course introduces Power Query, table relationships, and DAX, then brings these skills together through a workshop based on departmental business questions. Participants develop a working dashboard prototype, explore its findings, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2715,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"full-width-container","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_zipai_imported":false,"_zipai_import_id":"","footnotes":""},"class_list":["post-2865","page","type-page","status-publish","hentry"],"spectra_blocks_featured_image_url":null,"spectra_blocks_author_info":{"display_name":"skti","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/d19f1cd11f61dda1f5a6bb64202cfeceb9d2ba31d0872c307b67a0d6c2fc09bb?s=96&d=mm&r=g","author_link":"https:\/\/skti.co.th\/site\/author\/skti\/","description":""},"_links":{"self":[{"href":"https:\/\/skti.co.th\/site\/wp-json\/wp\/v2\/pages\/2865","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skti.co.th\/site\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/skti.co.th\/site\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/skti.co.th\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skti.co.th\/site\/wp-json\/wp\/v2\/comments?post=2865"}],"version-history":[{"count":10,"href":"https:\/\/skti.co.th\/site\/wp-json\/wp\/v2\/pages\/2865\/revisions"}],"predecessor-version":[{"id":3218,"href":"https:\/\/skti.co.th\/site\/wp-json\/wp\/v2\/pages\/2865\/revisions\/3218"}],"up":[{"embeddable":true,"href":"https:\/\/skti.co.th\/site\/wp-json\/wp\/v2\/pages\/2715"}],"wp:attachment":[{"href":"https:\/\/skti.co.th\/site\/wp-json\/wp\/v2\/media?parent=2865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}