{"id":2372,"date":"2021-10-01T09:10:23","date_gmt":"2021-10-01T07:10:23","guid":{"rendered":"https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class"},"modified":"2021-10-01T09:10:23","modified_gmt":"2021-10-01T07:10:23","slug":"powerbi-tool-bringing-big-data-class","status":"publish","type":"event","link":"https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class","title":{"rendered":"PowerBI: A tool for bringing Big Data in class"},"content":{"rendered":"<p><strong>Instructor: <\/strong>Dr Tawei (David) Wang, DePaul University<\/p>\n<p><strong>Live Q&amp;A event: <\/strong>November 16, 2021, at&nbsp;4-5pm CET<\/p>\n<p>Check out the trailer by Dr. Wang &#8211;&nbsp;<a href=\"https:\/\/youtu.be\/Kz-xeOo0_Mc\" target=\"_blank\" rel=\"noopener\">https:\/\/youtu.be\/Kz-xeOo0_Mc<\/a><\/p>\n<p><strong>Learning Objectives<\/strong><\/p>\n<p>After completing this series of videos, participants should be able to:<\/p>\n<ol>\n<li>\n\t\tUnderstand the questions visual analytics can answer<\/li>\n<li>\n\t\tImport data into PowerBI desktop<\/li>\n<li>\n\t\tModel and manipulate data<\/li>\n<li>\n\t\tCreate visualizations and dashboards<\/li>\n<\/ol>\n<p><strong>Asynchronous Material<\/strong> will cover the following topics:<\/p>\n<ol>\n<li>\n\t\tIntroduction to visual analytics<\/li>\n<li>\n\t\tIntroduction to PowerBI and the first visualization (What is it?, Benefits and limitations, Illustrative example in vendor management and datasets)<\/li>\n<li>\n\t\tModel data and data manipulations (Transform data, Working with multiple datasets and relationships, Calculated columns, dimensions, and measures, Aggregation, What do we find?)<\/li>\n<li>\n\t\tPredictive analytics with PowerBI (What is predictive analytics?, Limitations about prediction with visual anlaytics tools, An example, Assumptions and interpretations, Using PowerBI with Azure, R and Python)<\/li>\n<li>\n\t\tBuilding an interactive dashboard<\/li>\n<\/ol>\n<p><a href=\"https:\/\/eaa-online.org\/arc\/portfolio\/power-bi-tool-bringing-big-data-class-0\" target=\"_blank\" rel=\"noopener\"><strong>PowerBI Interactive Session: &ldquo;Designing and Implementing Data Analytics Exercises&rdquo;<\/strong><\/a><\/p>\n<p>During this interactive session, Professor David Wang will share the do&rsquo;s and don&rsquo;ts when designing and implementing data analytics exercises. In addition, different design ideas will be discussed. Questions and comments can be submitted to the speaker under each video or posted on the chat during the live session.<\/p>\n<p align=\"center\"><em>Register<\/em> for this November 16 one hour event <a href=\"https:\/\/us02web.zoom.us\/meeting\/register\/tZMucOyppzMqGdHK8zkwBmG6W3hLa5Ikta9H\">here<\/a><\/p>\n<p><strong>Video Course Schedule<\/strong><\/p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n<tbody>\n<tr>\n<td style=\"width:78px;\">\n<p><strong>1.0.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=E4uFr3pA9Jk&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=1\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">Introduction<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p><strong>2.0.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=WknFFMrV3ts&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=2\"><span style=\"color:#008080;\">Introduction to Power BI<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p style=\"margin-left:6.5pt;\"><strong>2.1.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=2Jer66gGIsk&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=3\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">First visualization&mdash;trend and smart narrative<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p style=\"margin-left:6.5pt;\"><strong>2.2.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=ljU0yeCOc-g&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=4\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">First visualization&mdash;stacked bar (proportion)<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p><strong>3.0.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=beNwFYiOl1c&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=5\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">Transform data<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p style=\"margin-left:6.5pt;\"><strong>3.1.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p style=\"margin-left:12.5pt;\"><a href=\"https:\/\/www.youtube.com\/watch?v=hk9lGmEENAo&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=6\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">Relationships<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p style=\"margin-left:6.5pt;\"><strong>3.2.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p style=\"margin-left:12.5pt;\"><a href=\"https:\/\/www.youtube.com\/watch?v=f54cvsOqQyk&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=7\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">Calculated columns<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p style=\"margin-left:6.5pt;\"><strong>3.3.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p style=\"margin-left:12.5pt;\"><a href=\"https:\/\/www.youtube.com\/watch?v=gc5yqzqWgZ4&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=8\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">Dimensions<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p style=\"margin-left:6.5pt;\"><strong>3.4.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p style=\"margin-left:12.5pt;\"><a href=\"https:\/\/www.youtube.com\/watch?v=dd0mD7PzClc&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=9\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">Measures<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p><strong>4.0.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=G2vML_FaDW4&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=10\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">Predictive analytics<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width:78px;\">\n<p><strong>5.0.<\/strong><\/p>\n<\/td>\n<td style=\"width:372px;\">\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=mayvUGqguC4&amp;list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W&amp;index=11\" target=\"_blank\" rel=\"noopener\"><span style=\"color:#008080;\">Interactive dashboard<\/span><\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The datasets and the slides can be downloaded through the links in the description&nbsp;<a href=\"https:\/\/www.youtube.com\/playlist?list=PLmyDqY0wqcajruXbMD1e51oJo4sw9L41W\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Instructor: Dr Tawei (David) Wang, DePaul University Live Q&amp;A event: November 16, 2021, at&nbsp;4-5pm CET Check out the trailer by Dr. Wang &#8211;&nbsp;https:\/\/youtu.be\/Kz-xeOo0_Mc Learning Objectives After completing this series of videos, participants should be able to: Understand the questions visual analytics can answer Import data into PowerBI desktop Model and manipulate data Create visualizations and [&hellip;]<\/p>\n","protected":false},"author":91,"featured_media":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0},"event_category":[39],"event_tag":[],"event_target_group":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.12 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PowerBI: A tool for bringing Big Data in class - ARC<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PowerBI: A tool for bringing Big Data in class - ARC\" \/>\n<meta property=\"og:description\" content=\"Instructor: Dr Tawei (David) Wang, DePaul University Live Q&amp;A event: November 16, 2021, at&nbsp;4-5pm CET Check out the trailer by Dr. Wang &#8211;&nbsp;https:\/\/youtu.be\/Kz-xeOo0_Mc Learning Objectives After completing this series of videos, participants should be able to: Understand the questions visual analytics can answer Import data into PowerBI desktop Model and manipulate data Create visualizations and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class\/\" \/>\n<meta property=\"og:site_name\" content=\"ARC\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class\/\",\"url\":\"https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class\/\",\"name\":\"PowerBI: A tool for bringing Big Data in class - ARC\",\"isPartOf\":{\"@id\":\"https:\/\/eaa-online.org\/arc\/#website\"},\"datePublished\":\"2021-10-01T07:10:23+00:00\",\"dateModified\":\"2021-10-01T07:10:23+00:00\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/eaa-online.org\/arc\/#website\",\"url\":\"https:\/\/eaa-online.org\/arc\/\",\"name\":\"ARC\",\"description\":\"Advanced Resources Center\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/eaa-online.org\/arc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PowerBI: A tool for bringing Big Data in class - ARC","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"PowerBI: A tool for bringing Big Data in class - ARC","og_description":"Instructor: Dr Tawei (David) Wang, DePaul University Live Q&amp;A event: November 16, 2021, at&nbsp;4-5pm CET Check out the trailer by Dr. Wang &#8211;&nbsp;https:\/\/youtu.be\/Kz-xeOo0_Mc Learning Objectives After completing this series of videos, participants should be able to: Understand the questions visual analytics can answer Import data into PowerBI desktop Model and manipulate data Create visualizations and [&hellip;]","og_url":"https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class\/","og_site_name":"ARC","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class\/","url":"https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class\/","name":"PowerBI: A tool for bringing Big Data in class - ARC","isPartOf":{"@id":"https:\/\/eaa-online.org\/arc\/#website"},"datePublished":"2021-10-01T07:10:23+00:00","dateModified":"2021-10-01T07:10:23+00:00","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/eaa-online.org\/arc\/events\/powerbi-tool-bringing-big-data-class\/"]}]},{"@type":"WebSite","@id":"https:\/\/eaa-online.org\/arc\/#website","url":"https:\/\/eaa-online.org\/arc\/","name":"ARC","description":"Advanced Resources Center","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/eaa-online.org\/arc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/eaa-online.org\/arc\/wp-json\/wp\/v2\/event\/2372"}],"collection":[{"href":"https:\/\/eaa-online.org\/arc\/wp-json\/wp\/v2\/event"}],"about":[{"href":"https:\/\/eaa-online.org\/arc\/wp-json\/wp\/v2\/types\/event"}],"author":[{"embeddable":true,"href":"https:\/\/eaa-online.org\/arc\/wp-json\/wp\/v2\/users\/91"}],"replies":[{"embeddable":true,"href":"https:\/\/eaa-online.org\/arc\/wp-json\/wp\/v2\/comments?post=2372"}],"wp:attachment":[{"href":"https:\/\/eaa-online.org\/arc\/wp-json\/wp\/v2\/media?parent=2372"}],"wp:term":[{"taxonomy":"event_category","embeddable":true,"href":"https:\/\/eaa-online.org\/arc\/wp-json\/wp\/v2\/event_category?post=2372"},{"taxonomy":"event_tag","embeddable":true,"href":"https:\/\/eaa-online.org\/arc\/wp-json\/wp\/v2\/event_tag?post=2372"},{"taxonomy":"event_target_group","embeddable":true,"href":"https:\/\/eaa-online.org\/arc\/wp-json\/wp\/v2\/event_target_group?post=2372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}