{"id":1877,"date":"2017-12-19T17:27:58","date_gmt":"2017-12-19T11:57:58","guid":{"rendered":"http:\/\/stepbystepschools.net\/?page_id=1877"},"modified":"2020-02-02T14:03:37","modified_gmt":"2020-02-02T08:33:37","slug":"analyzing-data-with-power-bi","status":"publish","type":"page","link":"https:\/\/www.stepbystepschools.net\/?page_id=1877","title":{"rendered":"Learn Power BI\u00a0in\u00a01 day"},"content":{"rendered":"<h2><span style=\"text-decoration: underline; color: #800000;\">Course Name<\/span><span style=\"color: #800000;\">: &#8211;\u00a0<\/span>Learn Power BI\u00a0 in\u00a01 day<\/h2>\n<h2><span style=\"text-decoration: underline; color: #800000;\">Date<\/span><span style=\"color: #800000;\">: &#8211;\u00a0\u00a0<\/span>Saturday 21st March 2020 .<\/h2>\n<h2><span style=\"text-decoration: underline; ;color: #993300;\">How to Join?<\/span><\/h2>\n<p>Click <a title=\"How to Register\" href=\"http:\/\/stepbystepschools.net\/?page_id=96\" target=\"_blank\" rel=\"noopener\">Here<\/a><\/p>\n<h2><span style=\"text-decoration: underline; ;color: #993300;\">Discounts<\/span><span style=\"color: #993300;\">: &#8211;<\/span><\/h2>\n<h2>Booking between\u00a002nd Feb 2020 to 29th Feb 2020 \u2013 500 INR discount, you pay 3000 INR<br \/>\nBooking between 01st Mar to 14th Mar 2020 \u2013 200 INR discount, you pay 3300 INR<br \/>\nBooking between 15th Mar to\u00a020th Mar 2020 \u2013 0 INR discount, you pay 3500 INR<\/h2>\n<h2><span style=\"text-decoration: underline;\"><span style=\"color: #800000; text-decoration: underline;\">Below is the syllabus<\/span><\/span><span style=\"color: #800000;\">: &#8211;<\/span><\/h2>\n<p>What is Power BI?<br \/>\nDownloading and Installing Power BI<br \/>\nImporting Data in Power BI<br \/>\nViewing data, fields, designer and model<br \/>\nTable, bar chart and line chart components.<br \/>\nFormatting visualization components<br \/>\nApplying Analytics<br \/>\nAuto filtering.<br \/>\nExporting report to PDF<br \/>\nAdding a calculated column.<br \/>\nAdding a measure column.<br \/>\nAdding Pages.<br \/>\nStacked bar chart, Column chart components.<br \/>\nLegend, Axis and values.<br \/>\nApply filters using Power Query Editor.<br \/>\nLine Chart, Pie chart, Map and Card Components.<br \/>\nSlicer component.<br \/>\nModeling relationship<br \/>\nPublishing and sharing report online.<br \/>\nThe Market place and Themes.<br \/>\nPivot and unpivot<br \/>\nDrill through, Templates and Tool tip<br \/>\nConnecting Power BI with SQL Server<br \/>\nRunning R and Python with Power BI<\/p>\n<p><strong>Installation and System Required<\/strong><\/p>\n<p>Software required: Power BI Desktop Installation and SQL Server 2019 Developer Edition<br \/>\nHardware requirement: i3 processor with minimum 4 GB or above RAM<\/p>\n<h2><span style=\"text-decoration: underline; color: #800000;\">Venue<\/span><span style=\"color: #800000;\">: &#8211;<\/span><\/h2>\n<p>3D4, 3rd Floor, D-Wing, Gundecha Onclave, Kherani Road, Next to Post Office, Sakinaka, Andheri (East), Mumbai &#8211; 400072.<\/p>\n<h2><span style=\"text-decoration: underline; color: #800000;\">Key Features<\/span><\/h2>\n<ul>\n<li>No PPT showcase, complete step by step Hands-on Power BI training.<\/li>\n<li>Personal attention given to each candidate till topic is clear.<\/li>\n<li>You have to just come with your laptop.<\/li>\n<li>Tea will be provided.<\/li>\n<li>All at only 3500 INR.<\/li>\n<\/ul>\n<p><strong>Power BI Demo video teaching<\/strong><\/p>\n<p>Here we have bought a video through which you can see teaching style which will help you to judge and can get decide. So you will get exact teaching as demonstrated in the video without keeping you wait and giving your valuable time to view following almost 1 hr Power BI video by the same MSBI trainer.<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/1b92aR55iaI\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><strong>Overview<\/strong><\/p>\n<p><strong>About this course<\/strong><\/p>\n<p>This one-day instructor-led course provides students with the practical execution knowledge and hands-on skills to analyze data with Power BI.<\/p>\n<p><strong>Audience profile<\/strong><\/p>\n<p>The primary audience for this course is BI professionals who need to analyze data utilizing Power BI.<br \/>\nThe secondary audiences for this course are technically proficient business users.<\/p>\n<p><strong>Duration<\/strong><\/p>\n<p>1 day<\/p>\n<p><strong>At course completion<\/strong><\/p>\n<p>After completing this course, students will be able to:<br \/>\n\u2022\u00a0Describe key features of a self-service BI solution<br \/>\n\u2022\u00a0Describe Power BI and its data sources<br \/>\n\u2022\u00a0Model, shape, and combine data<br \/>\n\u2022\u00a0Describe Power BI data visualizations<\/p>\n<p><!--<span style=\"text-decoration: underline;\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\"><\/span><strong>Course Outline<\/strong><\/span>\n\n<strong>Module 1: Introduction to Self-Service BI Solutions<\/strong>\n\nIn this module students will be introduced to the key concepts in business intelligence, data analysis, and data visualization. In addition they will learn the rationale for self-service BI, considerations for using self-service BI, and how Microsoft products can be used to implement a self-service BI solution.\n\n<strong>Lessons<\/strong>\n\n\n<ul>\n \t\n\n<li>Introduction to business intelligence<\/li>\n\n\n \t\n\n<li>Introduction to data analysis<\/li>\n\n\n \t\n\n<li>Introduction to data visualization<\/li>\n\n\n \t\n\n<li>Overview of self-service BI<\/li>\n\n\n \t\n\n<li>Considerations of self-service BI<\/li>\n\n\n \t\n\n<li>Microsoft tools for self-service BI<\/li>\n\n\n<\/ul>\n\n\n<strong>Lab : Exploring an enterprise BI solution<\/strong>\n\nAfter completing this module, you will be able to:\n\u2022\u00a0Describe key concepts in business intelligence\n\u2022\u00a0Describe key concepts in data analysis\n\u2022\u00a0Describe key concepts in data visualization\n\u2022\u00a0Describe the rationale for self-service BI\n\u2022\u00a0Describe considerations for self-service BI\n\u2022\u00a0Describe how Microsoft products can be used to implement a self-service BI solution\n\n<strong>\nModule 2: Introducing Power BI<\/strong>\n\nThis module introduces Power BI.\n\n<strong>Lessons<\/strong>\n\n\n<ul>\n \t\n\n<li>Power BI<\/li>\n\n\n \t\n\n<li>The Power BI service<\/li>\n\n\n \t\n\n<li>Power BI mobile apps<\/li>\n\n\n<\/ul>\n\n\n<strong>Lab : Cresting a Power BI dashboard<\/strong>\n\nAfter completing this module, you will be able to:\n\u2022\u00a0Describe Power BI\n\u2022\u00a0Describe the Power BI Service\n\u2022\u00a0Implement Tenant Management\n\u2022\u00a0Describe Power BI mobile apps\n\u2022\u00a0Create a simple dashboard\n\n<strong>\nModule 3: Power BI Data<\/strong>\n\nThis module describes Power BI data sources.\n\n<strong>Lessons<\/strong>\n\n\n<ul>\n \t\n\n<li>Using Excel as a Power BI data source<\/li>\n\n\n \t\n\n<li>Using databases as a Power BI data source<\/li>\n\n\n \t\n\n<li>The Power BI service<\/li>\n\n\n<\/ul>\n\n\n<strong>Lab : Import data into Power BI<\/strong>\n\nAfter completing this module, you will be able to:\n\u2022\u00a0Use Excel as a Power BI data source\n\u2022\u00a0Use databases as a Power BI data source and describe the R language\n\u2022\u00a0Configure the Power BI Service\n\n<strong>\nModule 4: Shaping and Combining Data<\/strong>\n\nThis module describes how to shape and combine data.\n\n<strong>Lessons<\/strong>\n\n\n<ul>\n \t\n\n<li>Power BI desktop queries<\/li>\n\n\n \t\n\n<li>Shaping data<\/li>\n\n\n \t\n\n<li>Combining data<\/li>\n\n\n<\/ul>\n\n\n<strong>Lab : Shaping and combining data<\/strong>\n\nAfter completing this module, you will be able to:\n\u2022\u00a0Create Power BI Desktop queries\n\u2022\u00a0Shape data\n\u2022\u00a0Combine data\n\n<strong>\nModule 5: Modelling Data<\/strong>\n\nThis module describes how to model data in Power BI.\n\n<strong>Lessons<\/strong>\n\n\n<ul>\n \t\n\n<li>Relationships<\/li>\n\n\n \t\n\n<li>DAX queries<\/li>\n\n\n \t\n\n<li>Calculations and measures<\/li>\n\n\n<\/ul>\n\n\n<strong>Lab : Modelling data<\/strong>\n\nAfter completing this module, you will be able to:\n\u2022\u00a0Configure the Power BI Service\n\u2022\u00a0Create Relationships\n\u2022\u00a0Write simple DAX queries\n\u2022\u00a0Create calculations and measures\n\n<strong>Module 6: Interactive Data Visualizations<\/strong>\n\nThis module describes Power BI visualizations.\n\n<strong>Lessons<\/strong>\n\n\n<ul>\n \t\n\n<li>Creating Power BI reports<\/li>\n\n\n \t\n\n<li>Managing a Power BI solution<\/li>\n\n\n<\/ul>\n\n\n<strong>Lab : Creating a Power BI report<\/strong>\n\nAfter completing this module, you will be able to:\n\u2022\u00a0Use Power BI Desktop to create interactive data visualizations\n\u2022\u00a0Describe the management of a Power BI solution--><\/p>\n<p><strong>Pre-requisites<\/strong><\/p>\n<p>This course requires that you meet the following prerequisites:<br \/>\n\u2022\u00a0Basic knowledge of the Microsoft Windows operating system and its core functionality.<br \/>\n\u2022\u00a0Basic knowledge of data warehouse schema topology (including star and snowflake schemas).<br \/>\n\u2022\u00a0Some exposure to basic programming concepts (such as looping and branching).<br \/>\n\u2022\u00a0An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.<br \/>\n\u2022\u00a0Familiarity with Microsoft Office applications \u2013 especially Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Course Name: &#8211;\u00a0Learn Power BI\u00a0 in\u00a01 day Date: &#8211;\u00a0\u00a0Saturday 21st March 2020 . How to Join? Click Here Discounts: &#8211; Booking between\u00a002nd Feb 2020 to 29th Feb 2020 \u2013 500 INR discount, you pay 3000 INR Booking between 01st Mar &hellip; <a href=\"https:\/\/www.stepbystepschools.net\/?page_id=1877\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":40,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Learn Power BI\u00a0in\u00a01 day - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai<\/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:\/\/www.stepbystepschools.net\/?page_id=1877\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn Power BI\u00a0in\u00a01 day - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"og:description\" content=\"Course Name: &#8211;\u00a0Learn Power BI\u00a0 in\u00a01 day Date: &#8211;\u00a0\u00a0Saturday 21st March 2020 . How to Join? Click Here Discounts: &#8211; Booking between\u00a002nd Feb 2020 to 29th Feb 2020 \u2013 500 INR discount, you pay 3000 INR Booking between 01st Mar &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stepbystepschools.net\/?page_id=1877\" \/>\n<meta property=\"og:site_name\" content=\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-02T08:33:37+00:00\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\",\"url\":\"https:\/\/www.stepbystepschools.net\/\",\"name\":\"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"description\":\"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stepbystepschools.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?page_id=1877#webpage\",\"url\":\"https:\/\/www.stepbystepschools.net\/?page_id=1877\",\"name\":\"Learn Power BI\u00a0in\u00a01 day - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai\",\"isPartOf\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/#website\"},\"datePublished\":\"2017-12-19T11:57:58+00:00\",\"dateModified\":\"2020-02-02T08:33:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stepbystepschools.net\/?page_id=1877#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stepbystepschools.net\/?page_id=1877\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stepbystepschools.net\/?page_id=1877#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stepbystepschools.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn Power BI\u00a0in\u00a01 day\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn Power BI\u00a0in\u00a01 day - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","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:\/\/www.stepbystepschools.net\/?page_id=1877","og_locale":"en_US","og_type":"article","og_title":"Learn Power BI\u00a0in\u00a01 day - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","og_description":"Course Name: &#8211;\u00a0Learn Power BI\u00a0 in\u00a01 day Date: &#8211;\u00a0\u00a0Saturday 21st March 2020 . How to Join? Click Here Discounts: &#8211; Booking between\u00a002nd Feb 2020 to 29th Feb 2020 \u2013 500 INR discount, you pay 3000 INR Booking between 01st Mar &hellip; Continue reading &rarr;","og_url":"https:\/\/www.stepbystepschools.net\/?page_id=1877","og_site_name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","article_modified_time":"2020-02-02T08:33:37+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.stepbystepschools.net\/#website","url":"https:\/\/www.stepbystepschools.net\/","name":"Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","description":"MVC 5\/Core, AngularJS 1.x, 2.0, 4.0, Design Pattern, Architecture, SSIS, SSAS, SSRS, Data Science, Big data, Hadoop classroom training","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stepbystepschools.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.stepbystepschools.net\/?page_id=1877#webpage","url":"https:\/\/www.stepbystepschools.net\/?page_id=1877","name":"Learn Power BI\u00a0in\u00a01 day - Learn MVC, Angular, Architecture, MSBI, Data Science in Mumbai","isPartOf":{"@id":"https:\/\/www.stepbystepschools.net\/#website"},"datePublished":"2017-12-19T11:57:58+00:00","dateModified":"2020-02-02T08:33:37+00:00","breadcrumb":{"@id":"https:\/\/www.stepbystepschools.net\/?page_id=1877#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stepbystepschools.net\/?page_id=1877"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.stepbystepschools.net\/?page_id=1877#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stepbystepschools.net\/"},{"@type":"ListItem","position":2,"name":"Learn Power BI\u00a0in\u00a01 day"}]}]}},"_links":{"self":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/pages\/1877"}],"collection":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1877"}],"version-history":[{"count":11,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/pages\/1877\/revisions"}],"predecessor-version":[{"id":2924,"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=\/wp\/v2\/pages\/1877\/revisions\/2924"}],"wp:attachment":[{"href":"https:\/\/www.stepbystepschools.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}