{"id":4127,"date":"2023-02-13T17:57:35","date_gmt":"2023-02-13T12:27:35","guid":{"rendered":"https:\/\/caddeskindia.com\/online-training\/?post_type=traning_course&p=4127"},"modified":"2026-02-28T15:08:11","modified_gmt":"2026-02-28T09:38:11","slug":"power-bi","status":"publish","type":"traning_course","link":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/","title":{"rendered":"Power BI"},"content":{"rendered":"

About Course<\/strong><\/h3>\n

Power BI is a business intelligence and data visualization application that transforms information from many data sources into interactive dashboards and reports. Power BI desktop, Power BI service based on SaaS, and mobile Power BI apps accessible for various platforms are all part of the Power BI package, which offers a variety of products, connectors, and services. Business customers utilize this group of services to gather data and create BI reports.<\/p>\n

Reports are created using the Power BI desktop programme, published using the Power BI Services (Software as a Service – SaaS), and viewed using the Power BI mobile app.<\/p>\n

Topics Include<\/strong><\/h3>\n
    \n
  • Introduction to Business Intelligence\n
      \n
    • Introduction to Tools and Terminology<\/span><\/li>\n
    • Overview of Dashboard<\/li>\n
    • Data Visualization & Reporting<\/li>\n
    • Business Intelligence (BI), Traditional BI, Self-Serviced BI<\/li>\n
    • Power BI Desktop (Power Query, Power Pivot, Power View)<\/li>\n
    • Power BI Report Server, Power BI Service, Power BI Mobile Flow<\/li>\n
    • Work in Power BI \/ Power BI Architecture.<\/li>\n<\/ul>\n<\/li>\n
    • Basics of Excel and Database(Microsoft SQL Server)\n
        \n
      • Basics of Excel<\/li>\n
      • Basics of SQL Server<\/li>\n
      • Data from multiple Data Sources<\/li>\n<\/ul>\n<\/li>\n
      • Power Query\n
          \n
        • Data Transformation, Benefits of Data Transformation<\/li>\n
        • Overview of Power Query \/ Query Editor, Query Editor User Interface<\/li>\n
        • Ribbon (Home, Transform, Add Column, View Tabs)<\/li>\n
        • The Data View \/ Results Pane, The Query Settings Pane, Formula Bar.<\/li>\n
        • Data types, changing the Data type of a Column Filter.<\/li>\n
        • Auto Filter \/ Basic Filtering<\/li>\n
        • PIVOT, UNPIVOT Columns<\/li>\n
        • Transpose Columns<\/li>\n
        • Header Row or Use First Row as Headers<\/li>\n
        • Group Rows \/ Group By<\/li>\n<\/ul>\n<\/li>\n
        • M Language\n
            \n
          • IF and ELSE Conditions, Transform Column () Types<\/li>\n
          • Remove Columns (), Split Columns (),Replace Value()<\/li>\n
          • Distinct Options and GROUP BY Options Table<\/li>\n
          • Group (), Table. Sort () with Type Conversions PIVOT<\/li>\n
          • Operation and Table. Pivot (). List Functions<\/li>\n
          • Parameters with M Language.<\/li>\n<\/ul>\n<\/li>\n
          • Data Modeling\n
              \n
            • Data Modeling Introduction<\/li>\n
            • Relationship, Need of Relationship<\/li>\n
            • One-to-One, One-to-Many (or Many-to-One), Many-to-Many.<\/li>\n
            • AutoDetect the relationship, Create a new relationship, Edit existing relationships<\/li>\n
            • Make Relationship Active or Inactive.<\/li>\n<\/ul>\n<\/li>\n
            • DAX\n
                \n
              • What is DAX, Calculated Column, Measures<\/li>\n
              • DAX Table and Column Name Syntax<\/li>\n
              • Creating Calculated Columns, Creating Measures Calculated.<\/li>\n
              • DAX Syntax & Operators<\/li>\n
              • DAX Operators<\/li>\n<\/ul>\n<\/li>\n
              • DAX Function\n
                  \n
                • Date and Time Functions<\/li>\n
                • Logical Functions<\/li>\n
                • Math & Statistical Functions<\/li>\n
                • Filter Functions<\/li>\n<\/ul>\n<\/li>\n
                • Date and Time Functions\n
                    \n
                  • YEAR, MONTH, DAY<\/li>\n
                  • WEEKDAY, WEEKNUM<\/li>\n
                  • FORMAT (Text Function) \u00e0 Month Name, Weekday Name<\/li>\n
                  • DATE, TODAY, NOW<\/li>\n
                  • HOUR, MINUTE, SECOND, TIME<\/li>\n
                  • DATEDIFF, CALENDAR<\/li>\n<\/ul>\n<\/li>\n
                  • Text Functions\n
                      \n
                    • LEN, CONCATENATE<\/li>\n
                    • LEFT, RIGHT, MID UPPER<\/li>\n
                    • LOWER<\/li>\n
                    • TRIM, SUBSTITUTE, BLANK<\/li>\n<\/ul>\n<\/li>\n
                    • Logical Functions\n
                        \n
                      • IF<\/li>\n
                      • TRUE, FALSE NOT<\/li>\n
                      • OR, IN, AND<\/li>\n
                      • IFERROR SWITCH<\/li>\n<\/ul>\n<\/li>\n
                      • Visualizations\n
                          \n
                        • Visualizing Data, Why Visualizations<\/li>\n
                        • Visualization types, Create and Format Bar and Column Charts<\/li>\n
                        • Create and Format Stacked Bar Chart Stacked Column Chart Create<\/li>\n
                        • Create and Format Scatter Charts<\/li>\n
                        • Create and Format Table Visual, Matrix Visualization<\/li>\n
                        • Create and Format Line Chart, Area Chart, Stacked Area Chart<\/li>\n
                        • Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                          Course Duration: 45 days<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

                          Turn multiple unrelated data sources into valuable and interactive insights<\/p>\n","protected":false},"author":1,"featured_media":5137,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"course_category":[5],"class_list":["post-4127","traning_course","type-traning_course","status-publish","has-post-thumbnail","hentry","course_category-cs-it"],"yoast_head":"\nPower BI - Live online training<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI - Live online training\" \/>\n<meta property=\"og:description\" content=\"Turn multiple unrelated data sources into valuable and interactive insights\" \/>\n<meta property=\"og:url\" content=\"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Live online training\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-28T09:38:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/caddeskindia.com\/online-training\/wp-content\/uploads\/2023\/02\/10.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"370\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/training-course\\\/power-bi\\\/\",\"url\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/training-course\\\/power-bi\\\/\",\"name\":\"Power BI - Live online training\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/training-course\\\/power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/training-course\\\/power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/10.jpg\",\"datePublished\":\"2023-02-13T12:27:35+00:00\",\"dateModified\":\"2026-02-28T09:38:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/training-course\\\/power-bi\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/training-course\\\/power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/training-course\\\/power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/10.jpg\",\"contentUrl\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/10.jpg\",\"width\":370,\"height\":200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/training-course\\\/power-bi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training Courses\",\"item\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/training-course\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Power BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/#website\",\"url\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/\",\"name\":\"Live online training\",\"description\":\"India's Best e-learning Platform\",\"publisher\":{\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/#organization\",\"name\":\"Cad Desk India\",\"url\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/logo-1-e1592914952499.png\",\"contentUrl\":\"https:\\\/\\\/caddeskindia.com\\\/online-training\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/logo-1-e1592914952499.png\",\"width\":330,\"height\":50,\"caption\":\"Cad Desk India\"},\"image\":{\"@id\":\"https:\\\/\\\/caddeskindia.com\\\/caddesk-ot\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI - Live online training","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Power BI - Live online training","og_description":"Turn multiple unrelated data sources into valuable and interactive insights","og_url":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/","og_site_name":"Live online training","article_modified_time":"2026-02-28T09:38:11+00:00","og_image":[{"width":370,"height":200,"url":"https:\/\/caddeskindia.com\/online-training\/wp-content\/uploads\/2023\/02\/10.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/","url":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/","name":"Power BI - Live online training","isPartOf":{"@id":"https:\/\/caddeskindia.com\/caddesk-ot\/#website"},"primaryImageOfPage":{"@id":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/#primaryimage"},"image":{"@id":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/caddeskindia.com\/online-training\/wp-content\/uploads\/2023\/02\/10.jpg","datePublished":"2023-02-13T12:27:35+00:00","dateModified":"2026-02-28T09:38:11+00:00","breadcrumb":{"@id":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/#primaryimage","url":"https:\/\/caddeskindia.com\/online-training\/wp-content\/uploads\/2023\/02\/10.jpg","contentUrl":"https:\/\/caddeskindia.com\/online-training\/wp-content\/uploads\/2023\/02\/10.jpg","width":370,"height":200},{"@type":"BreadcrumbList","@id":"https:\/\/caddeskindia.com\/online-training\/training-course\/power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/caddeskindia.com\/online-training\/"},{"@type":"ListItem","position":2,"name":"Training Courses","item":"https:\/\/caddeskindia.com\/caddesk-ot\/training-course\/"},{"@type":"ListItem","position":3,"name":"Power BI"}]},{"@type":"WebSite","@id":"https:\/\/caddeskindia.com\/caddesk-ot\/#website","url":"https:\/\/caddeskindia.com\/caddesk-ot\/","name":"Live online training","description":"India's Best e-learning Platform","publisher":{"@id":"https:\/\/caddeskindia.com\/caddesk-ot\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/caddeskindia.com\/caddesk-ot\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/caddeskindia.com\/caddesk-ot\/#organization","name":"Cad Desk India","url":"https:\/\/caddeskindia.com\/caddesk-ot\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/caddeskindia.com\/caddesk-ot\/#\/schema\/logo\/image\/","url":"https:\/\/caddeskindia.com\/online-training\/wp-content\/uploads\/2020\/06\/logo-1-e1592914952499.png","contentUrl":"https:\/\/caddeskindia.com\/online-training\/wp-content\/uploads\/2020\/06\/logo-1-e1592914952499.png","width":330,"height":50,"caption":"Cad Desk India"},"image":{"@id":"https:\/\/caddeskindia.com\/caddesk-ot\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/traning_course\/4127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/traning_course"}],"about":[{"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/types\/traning_course"}],"author":[{"embeddable":true,"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/comments?post=4127"}],"version-history":[{"count":2,"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/traning_course\/4127\/revisions"}],"predecessor-version":[{"id":5356,"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/traning_course\/4127\/revisions\/5356"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/media\/5137"}],"wp:attachment":[{"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/media?parent=4127"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/caddeskindia.com\/online-training\/wp-json\/wp\/v2\/course_category?post=4127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}