{"id":1246,"date":"2021-10-30T17:31:41","date_gmt":"2021-10-30T12:01:41","guid":{"rendered":"https:\/\/www.symbizsolutions.com\/academy\/?page_id=1246"},"modified":"2022-03-17T13:24:07","modified_gmt":"2022-03-17T07:54:07","slug":"analysing-and-visualizing-data-with-power-bi","status":"publish","type":"page","link":"https:\/\/symbizsolutions.com\/academy\/analysing-and-visualizing-data-with-power-bi\/","title":{"rendered":"Analysing and Visualizing Data with Power BI"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1246\" class=\"elementor elementor-1246\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f6c1352 elementor-section-height-min-height elementor-section-boxed elementor-section-height-default elementor-section-items-middle\" data-id=\"7f6c1352\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5ead6463\" data-id=\"5ead6463\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-15a84ba0 elementor-widget elementor-widget-heading\" data-id=\"15a84ba0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">ANALYZING AND VISUALIZING DATA WITH POWER BI<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6feff937 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6feff937\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-733e9a1\" data-id=\"733e9a1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6b9b0edd elementor-widget elementor-widget-heading\" data-id=\"6b9b0edd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">About the Course<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-742df188 elementor-widget elementor-widget-text-editor\" data-id=\"742df188\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Power BI is a cloud-based business analytics service that helps create live operational dashboards from on- premises and cloud data in one central location that you can access across a range of devices. Power BI helps you stay up to date with the information that matters to you. You can connect to multiple datasets to bring all of the relevant data together in one place. With Power BI, dashboards help you keep a finger on the pulse of your business. Your dashboards display tiles that you can click to explore further with reports.<\/p><p>\u00a0<\/p><p>Power BI Desktop puts visual analytics at your fingertips with intuitive report authoring. You can drag-and-drop to place content exactly where you want it on the flexible and fluid canvas. Quickly discover patterns as you explore a single unified view of linked, interactive visualizations.<\/p><p>As you start your data analysis and visualization journey with Power BI, this course will give you an overview of Power BI and what how you can use it to connect to multiple data sources, create and enhance the data model, explore the data, create stunning visualizations, upload reports and create dashboards, share all of these with your co-workers, and much more!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-577772e2 elementor-widget elementor-widget-heading\" data-id=\"577772e2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Course Takeaway<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50c21791 elementor-widget elementor-widget-text-editor\" data-id=\"50c21791\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>Master concepts like Data Visualization and Integration<\/li><li>Learn about Power Pivot, Power View, Power Map etc<\/li><li>Understand DAX and SSBI<\/li><li>Use and implement Custom Visuals<\/li><li>Explore Power BI Q&amp;A<\/li><li>Perform Data Binding and Formatting<\/li><li>Master Power BI Embedded and Workspace Collection<\/li><li>Understand and use Data Gateways, Content packs, Power BI Report Server<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fbddb72 elementor-widget elementor-widget-heading\" data-id=\"fbddb72\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">System Specifications<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d742f14 elementor-widget elementor-widget-text-editor\" data-id=\"d742f14\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>For a 32-bit machine, you need to install the 32bit Power BI<\/li><li>For a 32-bit Office installed (regardless of your machine), you need to install<\/li><li>the 32 bit Power BI<\/li><li>Otherwise, you can install the 64-bit PBI<\/li><li>Windows 7 \/ Windows Server 2008 R2, or later<\/li><li>.NET 4.5<\/li><li>Internet Explorer 10 or later<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7210522a elementor-widget elementor-widget-heading\" data-id=\"7210522a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Duration: 40 hours<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-982595b elementor-widget elementor-widget-heading\" data-id=\"982595b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Mode: Classroom or Online Session<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-27ccdf8 elementor-tabs-view-horizontal elementor-widget elementor-widget-tabs\" data-id=\"27ccdf8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-tabs\">\n\t\t\t<div class=\"elementor-tabs-wrapper\" role=\"tablist\" >\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-4171\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-4171\" aria-expanded=\"false\">Outline<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-4172\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-4172\" aria-expanded=\"false\">Who can Join<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-4173\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-4173\" aria-expanded=\"false\">Course Outcome<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-4174\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"4\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-4174\" aria-expanded=\"false\">Instructor<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"elementor-tabs-content-wrapper\" role=\"tablist\" aria-orientation=\"vertical\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-4171\" aria-expanded=\"false\">Outline<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-4171\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-4171\" tabindex=\"0\" hidden=\"false\"><p><strong>Introduction to Power BI<\/strong><\/p><ul><li>Business Intelligence<\/li><li>What is Power BI<\/li><li>Why Power BI?<\/li><li>Key Benefits of Power BI<\/li><li>Flow of Power BI<\/li><li>Components of Power BI<\/li><li>Architecture of Power<\/li><li>Building Blocks of Power BI<\/li><\/ul><p><strong>\u00a0 \u00a0 \u00a0 Power BI Desktop<\/strong><\/p><ul><li>Overview of Power BI Desktop<\/li><li>Data Sources in Power BI Desktop<\/li><li>Connecting to a data Sources<\/li><li>Query Editor in Power BI<\/li><li>Clean and Transform your data with Query Editor<\/li><li>Combining Data \u2013 Merging and Appending<\/li><li>Cleaning irregularly formatted data<\/li><li>Views in Power BI Desktop<\/li><li>Modelling Data<\/li><li>Manage Data Relationship<\/li><li>Cross Filter Direction<\/li><li>Create calculated tables and measures<\/li><li>Optimizing Data Models<\/li><\/ul><p><strong>Data Analysis Expressions<\/strong><\/p><ul><li>Essential concepts in DAX<\/li><li>Why is DAX important<\/li><li>DAX Syntax<\/li><li>Data Types in DAX<\/li><li>Calculation Types<\/li><li>DAX Functions<\/li><li>Measures in DAX<\/li><li>DAX Operators<\/li><li>DAX tables and filtering<\/li><li>DAX queries<\/li><li>DAX Parameter Naming<\/li><\/ul><p><strong>Data Visualization<\/strong><\/p><ul><li>Introduction to visuals in Power BI<\/li><li>\u00a0Charts in Power BI<\/li><li>Matrixes and tables<\/li><li>Slicers<\/li><li>Map Visualizations<\/li><li>Modifying colors in charts and visuals<\/li><li>Shapes, text boxes, and images<\/li><li>What Are Custom Visuals?<\/li><li>Page layout and formatting<\/li><li>KPI Visuals<\/li><li>Z-Order<\/li><\/ul><p><strong>Power BI Service<\/strong><\/p><ul><li>Introduction to Power BI Service<\/li><li>Dashboard vs. Reports<\/li><li>Quick Insights in Power BI<\/li><li>Creating Dashboards<\/li><li>Configuring a Dashboard<\/li><li>Power BI Q&amp;A<\/li><li>Ask questions of your data with natural language<\/li><li>Power BI embedded<\/li><\/ul><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-4172\" aria-expanded=\"false\">Who can Join<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-4172\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-4172\" tabindex=\"0\" hidden=\"hidden\"><div>This is\u00a0 Software testing basic course\/ IT Tester course for professionals who want to learn and gain insights into software testing:<\/div><div>\u00a0<\/div><div class=\"ul-li-content-clp\"><ul><li>Software Engineers<\/li><li>Software Developers<\/li><li>System Admins<\/li><li>Managers<\/li><li>Fresh graduates and students<\/li><li>Homemakers willing to make career in IT<\/li><li>Ladies with career break willing to move to IT<\/li><\/ul><\/div><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-4173\" aria-expanded=\"false\">Course Outcome<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-4173\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-4173\" tabindex=\"0\" hidden=\"hidden\"><p>Here are the benefits of using Software Testing Fundamentals Course<\/p><ul><li><strong>Product quality:\u00a0<\/strong>Testing ensures a quality product is delivered to customers.<\/li><li><strong>Customer Satisfaction:\u00a0<\/strong>The main aim of any product is to give satisfaction to their customers.<\/li><li><strong>Cost-Effective:\u00a0<\/strong>Testing any IT project on time helps you to save your money for the long term.<\/li><\/ul><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"4\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-4174\" aria-expanded=\"false\">Instructor<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-4174\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"4\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-4174\" tabindex=\"0\" hidden=\"hidden\"><p><strong>Ganesh Kannan&nbsp;<\/strong>has more than 15 years of IT experience in Software testing, test Consulting, Project and Change management. He has worked for Investment Banks like Barclays Capital and IT services firm like Zensar Technologies. He has managed the testing tools and process function for a top tier investment bank and have managed large off-shore testing teams. He possess extensive project management and consulting experience in delivering IT applications and spearheads the classroom Fundamentals of software testing in Singapore.<\/p><\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-1b38c452\" data-id=\"1b38c452\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-11366ca7 elementor-widget elementor-widget-heading\" data-id=\"11366ca7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Related Course<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-403ddf11 elementor-widget elementor-widget-text-editor\" data-id=\"403ddf11\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n \t<li><a style=\"text-decoration: none;\" href=\"https:\/\/www.symbizsolutions.com\/academy\/data-science-with-python\/\">Data Science with Python<\/a><\/li> \t<li><a style=\"text-decoration: none;\" href=\"https:\/\/www.symbizsolutions.com\/academy\/tableau-desktop-developer\/\">Tableau Desktop Developer<\/a><\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-13aa91af elementor-align-center elementor-invisible elementor-widget elementor-widget-button\" data-id=\"13aa91af\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInUp&quot;}\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md elementor-animation-shrink\" href=\"https:\/\/www.symbizsolutions.com\/academy\/contact\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">jOIN now<\/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\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>ANALYZING AND VISUALIZING DATA WITH POWER BI About the Course Power BI is a cloud-based business analytics service that helps create live operational dashboards from on- premises and cloud data in one central location that you can access across a range of devices. Power BI helps you stay up to date with the information that [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"default","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":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","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":""}},"footnotes":""},"class_list":["post-1246","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/symbizsolutions.com\/academy\/wp-json\/wp\/v2\/pages\/1246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/symbizsolutions.com\/academy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/symbizsolutions.com\/academy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/symbizsolutions.com\/academy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/symbizsolutions.com\/academy\/wp-json\/wp\/v2\/comments?post=1246"}],"version-history":[{"count":19,"href":"https:\/\/symbizsolutions.com\/academy\/wp-json\/wp\/v2\/pages\/1246\/revisions"}],"predecessor-version":[{"id":2409,"href":"https:\/\/symbizsolutions.com\/academy\/wp-json\/wp\/v2\/pages\/1246\/revisions\/2409"}],"wp:attachment":[{"href":"https:\/\/symbizsolutions.com\/academy\/wp-json\/wp\/v2\/media?parent=1246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}