tag:blogger.com,1999:blog-223693932024-03-24T20:21:38.647+13:00My Tech LearningMy day to day ramblings, learnings and research in Technology.Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.comBlogger526125tag:blogger.com,1999:blog-22369393.post-12080391331261553672023-03-03T22:14:00.000+13:002023-03-19T22:17:23.541+13:00Deploy the Azure Machine Learning Model <p>In the previous post I have discussed how to create an Azure Machine Model. In this post I will be discussing how to Deploy this model.</p><p><b>Prerequisites</b></p><p>Before deploying a machine learning model in Azure, there are several prerequisites you need to fulfill:</p><p><b>Prepare your data</b>: You should have a well-prepared and cleaned dataset that has been tested and validated.</p><p><b>Select your model</b>: You need to choose an appropriate machine learning algorithm based on your problem statement and the nature of your data.</p><p><b>Train your model</b>: You need to train your machine learning model on your prepared dataset.</p><p>As you must have seen we have undertaken all these steps and have trained our model in Azure Machine Learning in the previous post.</p><p><br /></p><p>As part of training the model, we have created an inference pipeline. Now if we want to deploy the model, we need to create a real time inference pipeline.</p><p>In order to do that, in the Azure Portal launch the Azure Machine Learning studio as shown below.</p><p><br /></p><p><br /></p><p><br /></p>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-52499411854606808332023-02-27T18:04:00.000+13:002023-02-27T18:04:35.294+13:00Create a Predictive Model in Azure Machine Learning -- Designer mode<p>Today after a long time, I wanted to play around with Azure Machine Learning Designer formerly Machine Learning Studio. </p><p>So I set our to create a Predictive Model using the Sample data that is available in Azure ML -- <span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px; font-weight: 600;">Automobile price data (Raw)</span></p><p>So I logged in to <a href="http://portal.azure.com" target="_blank">Azure Portal</a> -- </p><p><br /></p><p><b>Creating a Machine Learning Workspace</b></p><p>The first step is to create a Machine Learning Resource -- </p><p>So for that Click on Create a Resource Button and search machine learning as shown below:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIeCJTSiYSpt5dgxA9LYdxYku0qRoqgKNXkLWdA8zOkChpcrIhOwMs2ZlQsVDt0m8KZOogr_fM-LZnobY8GH5db6mj7D2RVpTAJUcvXRg160S-KHlRf5AaMooqbJMY3A_eBURXZ9RHfPZPby3Sj5TyjAlaqAAoDMIY5BXGUDfoVngOW0x_LgI/s824/createresource.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="381" data-original-width="824" height="185" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIeCJTSiYSpt5dgxA9LYdxYku0qRoqgKNXkLWdA8zOkChpcrIhOwMs2ZlQsVDt0m8KZOogr_fM-LZnobY8GH5db6mj7D2RVpTAJUcvXRg160S-KHlRf5AaMooqbJMY3A_eBURXZ9RHfPZPby3Sj5TyjAlaqAAoDMIY5BXGUDfoVngOW0x_LgI/w400-h185/createresource.JPG" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3IJHre2XF78NKIbU66VICZH-LZymcwIzuvxzDma8w5xZUFHDsSJhohuyJFXIaQtExfPBXRMcTA8hkef8Rou5h32AWdBxOZ_AT4rsC98V_myU4dGxtaR65fSEsIx1BKL0vnk0m7XMu0jNHm_figlDZRmBMLL52mCqOh0yAj9CYm-di5EK8Vjc/s959/mlsearch.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="732" data-original-width="959" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3IJHre2XF78NKIbU66VICZH-LZymcwIzuvxzDma8w5xZUFHDsSJhohuyJFXIaQtExfPBXRMcTA8hkef8Rou5h32AWdBxOZ_AT4rsC98V_myU4dGxtaR65fSEsIx1BKL0vnk0m7XMu0jNHm_figlDZRmBMLL52mCqOh0yAj9CYm-di5EK8Vjc/w400-h305/mlsearch.JPG" width="400" /></a></div><br /><p>Click on Azure Machine Learning</p><p>The below screen appears. </p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLzCWlXS3R05Tym3OUDIX9iju8m2X-j_d0jkbIoWeclFmL2RuS5trX5WlLubcubwiq1himbIrSTfTolCHcI5ZHMnIn-1wDYoG7E8mHZpJGANKcOQezVcL6KilGDVeHAbKp1CWEaCtmvm_MhRi9m_OhtEdy4YswU8T2SAMPqPh-qL8FCDPupec/s951/createc.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="800" data-original-width="951" height="336" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLzCWlXS3R05Tym3OUDIX9iju8m2X-j_d0jkbIoWeclFmL2RuS5trX5WlLubcubwiq1himbIrSTfTolCHcI5ZHMnIn-1wDYoG7E8mHZpJGANKcOQezVcL6KilGDVeHAbKp1CWEaCtmvm_MhRi9m_OhtEdy4YswU8T2SAMPqPh-qL8FCDPupec/w400-h336/createc.JPG" width="400" /></a></div><div><br /></div>Click on Create. The below screen appears.<div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAxAj4eyUtzFk4cBUG28A_ml-vsRfFPc66o0onWjGCvz-IxgU8l0H_zSCI7KpnUsmCURERcel6SoQivtHy5TtQHjfMDbUUpvPYXlUZ4vYdIrz0NdTM9-Tzrr41g1f0A2A9UmTQ19v0zF8Jg9-aYgE0DpNefImoGqOPgyZFDrjHWeCcya34E_E/s1165/AML.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="884" data-original-width="1165" height="304" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAxAj4eyUtzFk4cBUG28A_ml-vsRfFPc66o0onWjGCvz-IxgU8l0H_zSCI7KpnUsmCURERcel6SoQivtHy5TtQHjfMDbUUpvPYXlUZ4vYdIrz0NdTM9-Tzrr41g1f0A2A9UmTQ19v0zF8Jg9-aYgE0DpNefImoGqOPgyZFDrjHWeCcya34E_E/w400-h304/AML.JPG" width="400" /></a></div><div><br /></div><div><br /></div><div>Fill in the Resource Group, Workspace Name and Region details.</div><div><br /></div><div>Fill in other details in the other tabs if needed and click on Review and Create</div><div><br /></div><div>Now the Azure Machine Learning Workspace is created as below</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFgzNfmz4pgffP_JBD8DUe5kb1jdnomFJHWrgP8F99jcPi5GujthhQHHOVQQVzG5_0C91A6N71TcW1VfBwjysDyxomay-8gPdN64on-1SnslUjbBwM4vNOf3zBYjGjlkjUldAf21NiDlbQ3Yg85DlXaUGzd65dhacAD4RZ0aSizrMRxDQiizE/s1138/AMLws.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="258" data-original-width="1138" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFgzNfmz4pgffP_JBD8DUe5kb1jdnomFJHWrgP8F99jcPi5GujthhQHHOVQQVzG5_0C91A6N71TcW1VfBwjysDyxomay-8gPdN64on-1SnslUjbBwM4vNOf3zBYjGjlkjUldAf21NiDlbQ3Yg85DlXaUGzd65dhacAD4RZ0aSizrMRxDQiizE/w400-h91/AMLws.JPG" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div>Click on the Name of the AML workspace</div><div><br /></div><div>The below screen appears.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRygDQ98qCoHMxuO1-mKxMPWniCkXrsU943avFbziAFuGbD0ho2YSglSlPCxIWZ6ugcraklubpZiq76G9RKN_1fiPIrytpUNXI1imP9xOXsZqxo60qaIbE6z4qsq9VR8vWNz8LTnvNzLjufcXxLP61lIF9-UD4tL7lFJr-LzDSdLmeIbaQR3g/s1832/bbamlpbiover.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="831" data-original-width="1832" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRygDQ98qCoHMxuO1-mKxMPWniCkXrsU943avFbziAFuGbD0ho2YSglSlPCxIWZ6ugcraklubpZiq76G9RKN_1fiPIrytpUNXI1imP9xOXsZqxo60qaIbE6z4qsq9VR8vWNz8LTnvNzLjufcXxLP61lIF9-UD4tL7lFJr-LzDSdLmeIbaQR3g/w400-h181/bbamlpbiover.JPG" width="400" /></a></div><br /><div><br /></div><div><br /></div><div>Click on Launch Studio. This will launch the Azure Machine Learning (AML) interface.</div><div><br /></div><div>Click on the Create New -- This opens up the Menu of what can be created as shown below.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqoagNe_8wpzd4MPtTKuTUn8NO9AzhJ4vBEH8-lXba6VHZY_5ekQ0UVlBa8rAXQ6__sU6O5m5EtUtay2BsQsFR98G0_bi0018LYCAW2GTtucjbrRB6vz1kSXRh0dKlX5M0qu_17sgm4t3WgW-RVE4-9VmEEU1aAp7MUBElSVvMwlz3plC8OrE/s1648/createnewpipeline.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="804" data-original-width="1648" height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqoagNe_8wpzd4MPtTKuTUn8NO9AzhJ4vBEH8-lXba6VHZY_5ekQ0UVlBa8rAXQ6__sU6O5m5EtUtay2BsQsFR98G0_bi0018LYCAW2GTtucjbrRB6vz1kSXRh0dKlX5M0qu_17sgm4t3WgW-RVE4-9VmEEU1aAp7MUBElSVvMwlz3plC8OrE/w400-h195/createnewpipeline.JPG" width="400" /></a></div><br /><div><b>Ingesting Data</b></div><div><br /></div><div>Click on Pipeline. This will create a New Pipeline Menu as shown below</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo7shf0i1oiLXsdWr-QHpyjyP9opvj4eBYY78Skw1s1uwcMbST2PzLTq39qhUI6WoFpVc_Ee9ETsChhHa-r7nkSgG5szMT0UUEk5eOqFlW1zDj-wERlSxWKAr01LvqPYWF_g7o20pR9aAIDWpLYXCfG9eveyhqm4-lQBm25mjgw_ZlqoBM2JM/s1707/designer.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="538" data-original-width="1707" height="126" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo7shf0i1oiLXsdWr-QHpyjyP9opvj4eBYY78Skw1s1uwcMbST2PzLTq39qhUI6WoFpVc_Ee9ETsChhHa-r7nkSgG5szMT0UUEk5eOqFlW1zDj-wERlSxWKAr01LvqPYWF_g7o20pR9aAIDWpLYXCfG9eveyhqm4-lQBm25mjgw_ZlqoBM2JM/w400-h126/designer.JPG" width="400" /></a></div><br /><div><br /></div><div><br /></div><div>As you can see it uses the Designer Authoring tool. Now Click on the Plus button which is Create a pipeline using classic pre-built components.</div><div><br /></div><div>This will open a blank canvas in the designer as shown below:</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOY8e4k0gVSQO-COvzxQkLNvxmyhYS8ip2amkvc4dh68CFWLbXs5mN8KtOpLq7M8Insy70BVR4OKoMmMfCjmfn4KZfEvkcOs3smAjVBS9s-doGY7p0YcCKfHDOAfSVdvjn3UPK_Ppe-eWODLPLAVwB3-Jdanu7sxQQ2cDGyh3bse1fleSk164/s1364/blankcanvas.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="598" data-original-width="1364" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOY8e4k0gVSQO-COvzxQkLNvxmyhYS8ip2amkvc4dh68CFWLbXs5mN8KtOpLq7M8Insy70BVR4OKoMmMfCjmfn4KZfEvkcOs3smAjVBS9s-doGY7p0YcCKfHDOAfSVdvjn3UPK_Ppe-eWODLPLAVwB3-Jdanu7sxQQ2cDGyh3bse1fleSk164/w400-h175/blankcanvas.JPG" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div><br /></div><div>Now we are ready to create a training model. Click on the two arrows beside Undo as shown in the above image. This will open a Menu which contains the components that can be used to build the predictive model as shown below:</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhX-0l2DHaZxjBTEjSjjVwbL-V3V42oabukltwPH5J7oOgSYXmwDhB0NeRHtsR1XoWRF72TrXPfy-DYXB102ZwguGUvGfC7wBkAXdFlmiyW_N5aQblpNnnkPp9LMr1hl8eWKS79KufknXxAJKOJic21hBHK9GnmJSL_kp6-9ymtIKa_qA6CchQ/s1471/component%20menu.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="807" data-original-width="1471" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhX-0l2DHaZxjBTEjSjjVwbL-V3V42oabukltwPH5J7oOgSYXmwDhB0NeRHtsR1XoWRF72TrXPfy-DYXB102ZwguGUvGfC7wBkAXdFlmiyW_N5aQblpNnnkPp9LMr1hl8eWKS79KufknXxAJKOJic21hBHK9GnmJSL_kp6-9ymtIKa_qA6CchQ/w400-h220/component%20menu.JPG" width="400" /></a></div><br /><div>Click on Sample data and drag the dataset named Automobile Price Data (Raw) on to the blank canvas</div><div><br /></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXdfBUWXIbUSG5rwC5GJvL3oJB2PUgD7d9vYe3Dx2WGYE1QAMg4uUAErz8PUEgugFIt9Bx3NbRBAeGGRmxuKtnV67cUHCCHZm-w37Acp9zJEcX43eb_b09hhAgV-72LnbklEoxrpCI_BEQ6Op-wPTmQSx31K6qQNADONWunaSSclguhwyqwgM/s1367/sample%20data.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="644" data-original-width="1367" height="189" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXdfBUWXIbUSG5rwC5GJvL3oJB2PUgD7d9vYe3Dx2WGYE1QAMg4uUAErz8PUEgugFIt9Bx3NbRBAeGGRmxuKtnV67cUHCCHZm-w37Acp9zJEcX43eb_b09hhAgV-72LnbklEoxrpCI_BEQ6Op-wPTmQSx31K6qQNADONWunaSSclguhwyqwgM/w400-h189/sample%20data.JPG" width="400" /></a></div><br /><div><div><br /></div><div>You can right-click the Automobile price data (Raw) component and select Preview Data to understand the dataset. </div><div><br /></div><div>Each row corresponds to an automobile, and the variables associated with each automobile appear as columns. There are 205 rows and 26 columns in this dataset.</div></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJszoxsqs0--_9wKg-gyw_IDIoT2lE5l3DDn4VYNulijJQUGK9v4UHEIYyQW-uZW2butjpch39hk_fSoQrWPxMciJ9HiBVUqvWPJ7e0EKYnEGn1MDT4FrU6maSo2H61uDaVCZykq4hR1xLrDTtT-wy7BYJ1RfgJHCy-mHQCohvNRbC_KjzT4s/s765/preview%20data.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="536" data-original-width="765" height="280" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJszoxsqs0--_9wKg-gyw_IDIoT2lE5l3DDn4VYNulijJQUGK9v4UHEIYyQW-uZW2butjpch39hk_fSoQrWPxMciJ9HiBVUqvWPJ7e0EKYnEGn1MDT4FrU6maSo2H61uDaVCZykq4hR1xLrDTtT-wy7BYJ1RfgJHCy-mHQCohvNRbC_KjzT4s/w400-h280/preview%20data.JPG" width="400" /></a></div><br /><div><br /></div><div><b>Preparing Data</b></div><div><br /></div><div><br /></div><div>Now that we have chosen the dataset we need to clean the data. </div><div>First step in preparing data is to eliminate columns that we do not need </div><div>Second step is to remove the missing values. </div><div><br /></div><div>So if you look at the dataset carefully, there are many values missing from the column normalized-losses. So we need to eliminate this column. To achieve this, we can use the Select Column in dataset component as shown below.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIz2p0tvfDc0ONYDAlf-Uv8_L2Tgri5l1PW3ECd1L_J8VmBO46LINW-gNsDRZ0LZPcef_dx8tg_kQpjgFs9dhdgHZHKsa3EPeIh75_5FzllM5FNMb50uV3woYEZCIuPtXsyMtvgx2G7eOKnuIp4boaqY9VNCJNHGn8Q2L3UesHVk7eIlEkz_I/s992/select.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="551" data-original-width="992" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIz2p0tvfDc0ONYDAlf-Uv8_L2Tgri5l1PW3ECd1L_J8VmBO46LINW-gNsDRZ0LZPcef_dx8tg_kQpjgFs9dhdgHZHKsa3EPeIh75_5FzllM5FNMb50uV3woYEZCIuPtXsyMtvgx2G7eOKnuIp4boaqY9VNCJNHGn8Q2L3UesHVk7eIlEkz_I/w400-h223/select.JPG" width="400" /></a></div><br /><div>Now connect the Dataset component with the Select Columns component.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDnP0KQWOuo6eylp8m_6ao-ngvcuB_pd_HSzNmI5rWAQQNxXM_FKl3ZRLnEQV6sqorylE9d8vyR5MMe4RbdQcujEAXt_cfCx6g-_z2AjAiVVK7bOnu7tb3cxrCrWGzCJVCuUGezXY6GMeg8he0euoSeyJCdy1f4vRMdGe6C0iNo53pgxe0bbc/s905/connection.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="395" data-original-width="905" height="175" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDnP0KQWOuo6eylp8m_6ao-ngvcuB_pd_HSzNmI5rWAQQNxXM_FKl3ZRLnEQV6sqorylE9d8vyR5MMe4RbdQcujEAXt_cfCx6g-_z2AjAiVVK7bOnu7tb3cxrCrWGzCJVCuUGezXY6GMeg8he0euoSeyJCdy1f4vRMdGe6C0iNo53pgxe0bbc/w400-h175/connection.JPG" width="400" /></a></div><br /><div><br /></div><div><br /></div><div>Double click on the New component and choose Edit Columns and create the rules as below to Include All columns Except the column named normalized-losses</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTir-mo1Y6-Cs8DDqCD0hmkSxmCTcvWzJc8PP1H2KqQf5lc_t_5jUk2TKzxQOOcXBbbqZ1c_rP9nxx_LOgP4JRDKA7U0y2N59WMGpymV38JH6E50FOxUwekokiknCv3Hyx98Us6te0OvO_3gzz03KXTE1-vPgZj4z3R31DjNAExJvNaCNeolw/s1123/select%20columns.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="615" data-original-width="1123" height="219" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTir-mo1Y6-Cs8DDqCD0hmkSxmCTcvWzJc8PP1H2KqQf5lc_t_5jUk2TKzxQOOcXBbbqZ1c_rP9nxx_LOgP4JRDKA7U0y2N59WMGpymV38JH6E50FOxUwekokiknCv3Hyx98Us6te0OvO_3gzz03KXTE1-vPgZj4z3R31DjNAExJvNaCNeolw/w400-h219/select%20columns.JPG" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div>Next step is to remove other missing values. For this we will use the <b>Clean missing data</b> component. Drag this component to the Canvas. Connect the <b>Select columns dataset</b> component to the <b>Clean missing data</b> component as shown below.<div><br /></div><div>Double Click on the <b>Clean missing data</b> component and change as shown below.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0PxhqpoBmVP-COd6Jv0qejXjJYcICyMx3l_PjepLZy08GnpbHE0F7Lx6rS_e_qKObkQ0SPqXaa3CjuF42S3l8ffoj2DT92zkCtdU8VqVMRUoHV96x1wwfhKZbH8JA0uuQo0ND9drWyQqJyJk1vNp5FmOUYATgyao0h-9x76fuQ5oiMoJw0is/s665/clean%20missing.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="665" data-original-width="558" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0PxhqpoBmVP-COd6Jv0qejXjJYcICyMx3l_PjepLZy08GnpbHE0F7Lx6rS_e_qKObkQ0SPqXaa3CjuF42S3l8ffoj2DT92zkCtdU8VqVMRUoHV96x1wwfhKZbH8JA0uuQo0ND9drWyQqJyJk1vNp5FmOUYATgyao0h-9x76fuQ5oiMoJw0is/w336-h400/clean%20missing.JPG" width="336" /></a></div><br /><div><br /></div><div>Preparing Training and test data</div><div>Now that we have prepared and cleaned the dataset, the next step is to prepare the train and test data, For this we will use Split Data component. Search for the Split Data component and drag it to the canvas. Connect the Clean Missing data component to the Split Data component. Make sure that the Cleaned dataset port is connected as shown below.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQi2T-Yk9DuYiub5VIL_ukKVofAaonIbGhtRI5g7Y7iO8vnH2H2dNIN8LMqMzgGpusK5LyZk9-gLb7PoYDIXQjLz7qt_JauG2H6in0OkF0REk7Xx_h3bW7woCK306u-6fkpdDbPS_RUR_DjEAIzfhc9vYMbkKNe61kwrIgUEe-cQiidJ2n9Dg/s654/split%20connection.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="412" data-original-width="654" height="202" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQi2T-Yk9DuYiub5VIL_ukKVofAaonIbGhtRI5g7Y7iO8vnH2H2dNIN8LMqMzgGpusK5LyZk9-gLb7PoYDIXQjLz7qt_JauG2H6in0OkF0REk7Xx_h3bW7woCK306u-6fkpdDbPS_RUR_DjEAIzfhc9vYMbkKNe61kwrIgUEe-cQiidJ2n9Dg/s320/split%20connection.JPG" width="320" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div></div><br /><div>Double click the Split Data component and configure as shown below. The 0.7 in the Fraction of rows in the first output dataset. means that the dataset will be split into 70% and 30%. The 70% dataset will be used for training a model and 30% dataset can be used as a test dataset.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQiqwz3i5MVjjU1pLUZwwaVxBa3KWIY5hh-z5u_73vU6bfRVb_WEsqfjfZ7VgOIQW6vMlEKXsSch7WVpe_ue8LGUKPipgetM-eM-F2QCA9wp6U3X79pLXS4syTgXi1WAmw3NJfTGkrVh5TrXGH2GMq1LTfj9_9mlBqRmcxS2ZCrGrIsTGyl9w/s597/split%20config.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="597" data-original-width="514" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQiqwz3i5MVjjU1pLUZwwaVxBa3KWIY5hh-z5u_73vU6bfRVb_WEsqfjfZ7VgOIQW6vMlEKXsSch7WVpe_ue8LGUKPipgetM-eM-F2QCA9wp6U3X79pLXS4syTgXi1WAmw3NJfTGkrVh5TrXGH2GMq1LTfj9_9mlBqRmcxS2ZCrGrIsTGyl9w/w345-h400/split%20config.JPG" width="345" /></a></div><br /><div><br /></div><div><b>Training a Model</b></div><div>The Next Step is to train a model. From the data we are going to Predict the Price of the automobile. So we will use a linear regression model. So Search for the Linear Regression component and drag it to the canvas. Next search for a Train Model and drag it to the canvas. And connect these components as shown below.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEZZzzRlSMN95Hvsj1CRXgYuX3jNrJd3ES8U1BcwH4gwzZ9qS2TfI3MVAz5EYKPyK_D7p6BLDw9_fuK8FxLtG63YJNrldT5Ew0-qTTAgkbZS1SoZT3kEyESMplUSI-vP1xcDLrbRV-DAx3fY_V5_iHMHcrLO6ONonjVJR1lADHnxxDEDQOojs/s925/train%20model.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="491" data-original-width="925" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEZZzzRlSMN95Hvsj1CRXgYuX3jNrJd3ES8U1BcwH4gwzZ9qS2TfI3MVAz5EYKPyK_D7p6BLDw9_fuK8FxLtG63YJNrldT5Ew0-qTTAgkbZS1SoZT3kEyESMplUSI-vP1xcDLrbRV-DAx3fY_V5_iHMHcrLO6ONonjVJR1lADHnxxDEDQOojs/w400-h213/train%20model.JPG" width="400" /></a></div><div><br /></div><div><br /></div><b>Scoring and Evaluating the Model</b><div><br /></div><div>Next add the components -- Score Model and Evaluate Model on to the canvas and connect them as shown below:</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGnJL5V_E7KulJoV3qsy9-fJxTsWMExDZDoe9kMgosJKuPQ2BeHvh4RMInOmT1ZudZbmguVLsBzcZrsCtoDgC9KQKjzzzZxCuCfiqa2XMi6L9-srszh_6fP9bO8Ychz4Pac6SvVr0sa3KwVaJsBFqfiQAm5PAROhpkemcJUw7dN4EbngKuVi8/s898/score.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="588" data-original-width="898" height="262" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGnJL5V_E7KulJoV3qsy9-fJxTsWMExDZDoe9kMgosJKuPQ2BeHvh4RMInOmT1ZudZbmguVLsBzcZrsCtoDgC9KQKjzzzZxCuCfiqa2XMi6L9-srszh_6fP9bO8Ychz4Pac6SvVr0sa3KwVaJsBFqfiQAm5PAROhpkemcJUw7dN4EbngKuVi8/w400-h262/score.JPG" width="400" /></a></div><br /><div><br /></div><div>Now your Pipeline is ready. </div><div><br /></div><div>Next Steps --- </div><div>In order to train this model, you need to click on the <b>Submit button</b></div><div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoDKEqwR34_HfQFR1aPm3-w-5fjstcDYJEpGYNI8aJnIZfSVb9iKZA8tv3TYpULbCR6ooo7ZW_0LiEQw0U8uRR-RiP4VdWnTI0UzdXbJGKfoGkH0kd2p5qc0kCkvmYptqrOhpuwErmDKGNnS2PjGAzII8yZHqpxJImAwbKrHq8F5rS_ZXh3oo/s1631/submit.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="392" data-original-width="1631" height="96" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoDKEqwR34_HfQFR1aPm3-w-5fjstcDYJEpGYNI8aJnIZfSVb9iKZA8tv3TYpULbCR6ooo7ZW_0LiEQw0U8uRR-RiP4VdWnTI0UzdXbJGKfoGkH0kd2p5qc0kCkvmYptqrOhpuwErmDKGNnS2PjGAzII8yZHqpxJImAwbKrHq8F5rS_ZXh3oo/w400-h96/submit.JPG" width="400" /></a></div><br /><div><br /></div><div>Once you submit you will be prompted with the below configuration.</div><div><br /></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVYAgMhxDKNMGtjCl1yY9lSIVs3SCPRXdrLgPKW4GH6o7ispECJse8ZptCh0Mn2atdR7CONl4bAXYTfsPBfarkwJX1hAHWVrNAq5iiJW_UH_Zx9uM5UktFUCAti4i3-2MmFhldKgIQKVvv8PmC8RQvzJvzFtzp-vEmfFKRpJzr08kPKUhPPkY/s791/submit%20config.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="791" data-original-width="695" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVYAgMhxDKNMGtjCl1yY9lSIVs3SCPRXdrLgPKW4GH6o7ispECJse8ZptCh0Mn2atdR7CONl4bAXYTfsPBfarkwJX1hAHWVrNAq5iiJW_UH_Zx9uM5UktFUCAti4i3-2MmFhldKgIQKVvv8PmC8RQvzJvzFtzp-vEmfFKRpJzr08kPKUhPPkY/w351-h400/submit%20config.JPG" width="351" /></a></div><br /><div>Ensure that you have configured the Compute Target as well as shown below</div><div><br /></div><div><br /></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFY1b-dhbCnotLLRN1uKXBYDa8ym--PXqjV1KYmMEUAfmnlXAlR-BtpU16BJxuoru73bxQ8y8M_zkeyDTTo-DD891aV86v4gQP7CAaPsvIRc6L8wwAZB1B_9NqauzIWt_A8qjpaZ8nHhnbfKVg9T5JkquK-se42zccJHOcTEaW4aaUmhO_gyA/s707/compute%20Target.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="463" data-original-width="707" height="263" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFY1b-dhbCnotLLRN1uKXBYDa8ym--PXqjV1KYmMEUAfmnlXAlR-BtpU16BJxuoru73bxQ8y8M_zkeyDTTo-DD891aV86v4gQP7CAaPsvIRc6L8wwAZB1B_9NqauzIWt_A8qjpaZ8nHhnbfKVg9T5JkquK-se42zccJHOcTEaW4aaUmhO_gyA/w400-h263/compute%20Target.JPG" width="400" /></a></div><br /><div><br /></div><div>This will create a pipeline job and a notification will pop up at the top right corner of the page. Since this is your first job, this might take up to 20 mins to run. Once you get the notification that the job is completed, you can look at the job detail page as shown below.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixL1RXXijKrrTLAhQXeGVP16IHT46JLHXscvuuQNl3IBw7GAMkwZL8wqP1j1g1wbPoN4cpO5jxNAtfUmuFIKB2aSkYKugpyBWDdjin7rh9TYxp_h6nhwsTDdbw8dVQh5CzoHmJl8EUDG95weNMk-Ahx8XZEIpB6RSkGBetj_v7g4TuDvdt6WI/s1809/rightclickscore.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="671" data-original-width="1809" height="149" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixL1RXXijKrrTLAhQXeGVP16IHT46JLHXscvuuQNl3IBw7GAMkwZL8wqP1j1g1wbPoN4cpO5jxNAtfUmuFIKB2aSkYKugpyBWDdjin7rh9TYxp_h6nhwsTDdbw8dVQh5CzoHmJl8EUDG95weNMk-Ahx8XZEIpB6RSkGBetj_v7g4TuDvdt6WI/w400-h149/rightclickscore.JPG" width="400" /></a></div><br /><div><br /></div><div>You can then look at the scored labels and price predicted as shown below.</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdbuhEGphgVfK_xW4CMFiM5qdVNyQjqCsmSMos6yLfToC9O0XP0yV2RmIP0l2tac2JHUk7rCQx30m_LQDHdIqGsQ2aZrWz3sn-SWR2GaWA0mp32z5evm0eIf6hQUxI3QSkwLoQiE5Rhm_3xshNHGLCBsWVEHWNPhPLgPRPSQWjNWSElHKJAM4/s1652/scoredataset.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="747" data-original-width="1652" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdbuhEGphgVfK_xW4CMFiM5qdVNyQjqCsmSMos6yLfToC9O0XP0yV2RmIP0l2tac2JHUk7rCQx30m_LQDHdIqGsQ2aZrWz3sn-SWR2GaWA0mp32z5evm0eIf6hQUxI3QSkwLoQiE5Rhm_3xshNHGLCBsWVEHWNPhPLgPRPSQWjNWSElHKJAM4/w400-h181/scoredataset.JPG" width="400" /></a></div><br /><div><br /></div><div>You can u<span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;">se the </span><span style="background-color: white; box-sizing: inherit; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px; font-weight: 600; outline-color: inherit;">Evaluate Model</span><span style="background-color: white; color: #161616; font-family: "Segoe UI", SegoeUI, "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 16px;"> to see how well the trained model performed on the test dataset as shown below</span></div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUwUaHJA4HCl0uexpNPxY04BXuXPXtMtNp8cOuNwqEvlLdiltl_LevzEi63hCoGm5vrZQ1c3dygtpqbcZl4qK4bW3Yt5rmO6wxOqirhBjCsjp3yS9CuftKsLUxhf0j0-qE8JGFoITfS0lZgL60XkqHt_q1t0grk8WwGSqGZ5O4-7BKIs_cOCM/s1134/evaluation.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="476" data-original-width="1134" height="168" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUwUaHJA4HCl0uexpNPxY04BXuXPXtMtNp8cOuNwqEvlLdiltl_LevzEi63hCoGm5vrZQ1c3dygtpqbcZl4qK4bW3Yt5rmO6wxOqirhBjCsjp3yS9CuftKsLUxhf0j0-qE8JGFoITfS0lZgL60XkqHt_q1t0grk8WwGSqGZ5O4-7BKIs_cOCM/w400-h168/evaluation.JPG" width="400" /></a></div><br /><div><br /></div><div>You can see the error statistics above. For each of the error statistics, smaller is better. A smaller value indicates that the predictions are closer to the actual values. </div><div><br /></div><div>For the coefficient of determination, the closer its value is to one (1.0), the better the predictions.</div><div><br /></div><div><br /></div><div>That's it from me for today.</div><div><br /></div><div>In my next blog post I will show you how you can deploy this model.</div><div><br /></div><div><br /></div><div><br /></div><div><br /><div><br /></div><div><br /><div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><br /><div><br /><p><br /></p></div></div></div></div>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-37137097247749946682022-11-22T23:42:00.103+13:002023-02-23T00:26:47.208+13:00Create a Lollipop Chart in Power BI -- Without the use of any Custom Visuals<p> I have been playing around with the newly launched Error Bars functionality in Power BI. The result is this Blog Post. Here I am going to explain how you can create a lollipop chart in Power BI without using any custom visuals or charticulator or deneb </p><p>Step 1: </p><p>Create a simple line chart -- I have sales data and region data. So I created a line chart as shown below.</p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiViA02yOy37-y7yJmWf-IPp-1ZKYyYAnIHsPX2QN2oXT68ZPxXf1WKWCD0_mOlu2ZRzVDrzF0HIcy2D0Bbh06ZutZ1dm_Dynkf7s6oSFLItZA5ngB9uOhIInjrXHVpk51WS7NK9wvL0fnC-iuTDvxs0Tk2T6PT-f4ex17qxx97-5YY_wfw-8/s1001/step%201.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="455" data-original-width="1001" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiViA02yOy37-y7yJmWf-IPp-1ZKYyYAnIHsPX2QN2oXT68ZPxXf1WKWCD0_mOlu2ZRzVDrzF0HIcy2D0Bbh06ZutZ1dm_Dynkf7s6oSFLItZA5ngB9uOhIInjrXHVpk51WS7NK9wvL0fnC-iuTDvxs0Tk2T6PT-f4ex17qxx97-5YY_wfw-8/w400-h181/step%201.JPG" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><p>Step 2: </p><div>Format the line chart to remove the line as shown below. Click on the <b>format </b>icon -- <b>Visual </b>tab -- Line -- Stroke Width -- Change from 3 px to 0</div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGm9rpW1QUZkm_4htRo6V7yvvGE9t9btPOUDImKAuTA16CmxrhJsHAMr05vzQxHvh-En54AAJBQbIe-kxSh6bsTahxH1fTJU3c7YU21EJ5F5KJbT3i9c9Y2YFsFJNwexJySTP--xPArwlwFaMlgEfqfWSk8ci9G1Xen2VJp2K8jvlwT_d9udw/s683/step%202.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="683" data-original-width="342" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGm9rpW1QUZkm_4htRo6V7yvvGE9t9btPOUDImKAuTA16CmxrhJsHAMr05vzQxHvh-En54AAJBQbIe-kxSh6bsTahxH1fTJU3c7YU21EJ5F5KJbT3i9c9Y2YFsFJNwexJySTP--xPArwlwFaMlgEfqfWSk8ci9G1Xen2VJp2K8jvlwT_d9udw/s320/step%202.JPG" width="160" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div>The result of this action is -- the line will entirely disappear as we changed the Stroke Width from 3 px to 0 px.<div><br /></div><div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfUhUOjiApx6n7vP_REwBvrD9qzUdJDYZo3LHxuOSYnMfF3eOlDRcLKv-hUOEcEJUZdJTYeIDkR1skFgoVwzPT7-2t8HJ15M0_LJEBN8SsUZFVDSzOmpFl8wNQAUue8A0N32L150fv4jdd1OItmZT7Ly3ZfzRxaGJb9p_zJfjh39Iu0pHQm48/s1001/step%202b.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="413" data-original-width="1001" height="165" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfUhUOjiApx6n7vP_REwBvrD9qzUdJDYZo3LHxuOSYnMfF3eOlDRcLKv-hUOEcEJUZdJTYeIDkR1skFgoVwzPT7-2t8HJ15M0_LJEBN8SsUZFVDSzOmpFl8wNQAUue8A0N32L150fv4jdd1OItmZT7Ly3ZfzRxaGJb9p_zJfjh39Iu0pHQm48/w400-h165/step%202b.JPG" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div>Step 3: </div><p>Add Markers as shown below and ensure that the shape is a circle resembling the ball of the lollipop and increase the size to 10 px to get reasonable sized balls</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKjd-CndLmQ8PUYIKiYRjKB4Dz-dd455szfxXzQz3VWQ56P5ktfij5gWPMTpnCWcbHjfS-JrDlNqhHb8Lu7Jm4cD773brG7kROrDs4eDDiis8A468q5zens5zb1fIGy7pjaFDNtURjiARaLtnjkpmY5oWqh4emjD-gY_WDw5kSq1cYhekqhLA/s723/step%203.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="723" data-original-width="282" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKjd-CndLmQ8PUYIKiYRjKB4Dz-dd455szfxXzQz3VWQ56P5ktfij5gWPMTpnCWcbHjfS-JrDlNqhHb8Lu7Jm4cD773brG7kROrDs4eDDiis8A468q5zens5zb1fIGy7pjaFDNtURjiARaLtnjkpmY5oWqh4emjD-gY_WDw5kSq1cYhekqhLA/s320/step%203.JPG" width="125" /></a></div><br /><br /><p>The result is as shown below.</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfGXtHh7HRWxP7_v0CLx6CJFcgiduCQCRYfE5jIIcJsA7npHFefCvhU8JiKXGjBRqYWrSrXOVL-gVmTV-9NMqoEQzNSP9WsEQFtc1I3Var7-x0xvMOYin2nuIGnudKaQRxph_3ysc8cvoBrf1FE3nCrJjG4L4JLhWdUdn3oqiAYyoQyE2PPps/s991/step%203b.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="430" data-original-width="991" height="174" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfGXtHh7HRWxP7_v0CLx6CJFcgiduCQCRYfE5jIIcJsA7npHFefCvhU8JiKXGjBRqYWrSrXOVL-gVmTV-9NMqoEQzNSP9WsEQFtc1I3Var7-x0xvMOYin2nuIGnudKaQRxph_3ysc8cvoBrf1FE3nCrJjG4L4JLhWdUdn3oqiAYyoQyE2PPps/w400-h174/step%203b.JPG" width="400" /></a></div></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><div style="text-align: left;">Step 4: </div><div style="text-align: left;">Ensure that the Data Labels are Enabled and choose Position as Above as shown below</div><div style="text-align: left;">You can disable Y-Axis if you need to. </div><div><br /></div></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8UM6v4Xu7bmzpUBXytqpRM9P_kSDXDdQ_bwSYuRVYLu5qxPIiXDTTYosSRorbixiD5jsi3t9wkt0alvI3VJ5MK_k7zdsT2ue2QljxxnmiVL1JO6WL_F9BEOejRGtTc5KQpIcxV14C3t0OQqgC4RrLaysLu_9ZA3XU7olC8UnMCWQffxyLQr0/s1366/step%204.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="414" data-original-width="1366" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8UM6v4Xu7bmzpUBXytqpRM9P_kSDXDdQ_bwSYuRVYLu5qxPIiXDTTYosSRorbixiD5jsi3t9wkt0alvI3VJ5MK_k7zdsT2ue2QljxxnmiVL1JO6WL_F9BEOejRGtTc5KQpIcxV14C3t0OQqgC4RrLaysLu_9ZA3XU7olC8UnMCWQffxyLQr0/w400-h121/step%204.JPG" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><div style="text-align: left;">Step 5: </div><div style="text-align: left;">Here is where we will be using the Error Bars to add the Line to show the lollipop stick.</div><div style="text-align: left;">To go to the Error Bars section -- Go to the Further Analytics icon and click on Error Bars.</div><div style="text-align: left;">Enable the Error Bars. As shown below it needs an Upper Bound and Lower Bound. Upper Bound can be Sum of Sales and the Lower Bound is always 0 (Zero). Since there is no way to input a number, let us create a Measure that returns 0 . </div><div style="text-align: left;">The new Measure is -- <b>Lowerbound = 0</b></div><div style="text-align: left;"> </div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlgqPMgDgzxp-gpE8m0tT7IZNqQXmymX5k0JW9D0q65bvaTObRpmi5A58a0U2HmfrNrr6M472ahwAX5fUN4bKLMJTSkM95upjVeMaX4faNtcXBZc-0PL3x_E3pdTrRNEzhCBAryHm0liZNjWGvrTMOpfSB-X14Zevj0cNY7lP2YGNq4gaGko4/s1404/step%205.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="572" data-original-width="1404" height="163" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlgqPMgDgzxp-gpE8m0tT7IZNqQXmymX5k0JW9D0q65bvaTObRpmi5A58a0U2HmfrNrr6M472ahwAX5fUN4bKLMJTSkM95upjVeMaX4faNtcXBZc-0PL3x_E3pdTrRNEzhCBAryHm0liZNjWGvrTMOpfSB-X14Zevj0cNY7lP2YGNq4gaGko4/w400-h163/step%205.JPG" width="400" /></a></div><br /><div style="text-align: left;">Step 6:</div><div style="text-align: left;">You can see faint lollipop lines. You can increase the width of the line by clicking on the Bar and changing the Width as shown below</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpfn_ZKa_eIBp2GgYaP3cYYK-qeiAX41mxWgqX5bF0PJL-w61xio9ccbmaF9TlnOzZrHAs3x4kPpOu8k4mBB0KQNSlfWoV5rN9ujpi82-_YlrZtlgfMRbnini2byQLaqgOrgmX4YuVBuKt7DkzONexT48qO2FtBxO923MK35HaLcQfJx_8GhY/s1378/step%206.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="556" data-original-width="1378" height="161" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpfn_ZKa_eIBp2GgYaP3cYYK-qeiAX41mxWgqX5bF0PJL-w61xio9ccbmaF9TlnOzZrHAs3x4kPpOu8k4mBB0KQNSlfWoV5rN9ujpi82-_YlrZtlgfMRbnini2byQLaqgOrgmX4YuVBuKt7DkzONexT48qO2FtBxO923MK35HaLcQfJx_8GhY/w400-h161/step%206.JPG" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div>And Viola! Your Lollipop chart is ready!</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;">Hope you liked this Step by Step instruction on creating the lollipop chart.</div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><div><br /></div></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-64647915056253624862022-06-28T22:29:00.070+12:002023-02-28T23:23:27.828+13:00Default your Date Slicer to Today with this trick!<p> Today I had a requirement from a client to Default the Date Slicer to Today.</p><p>I explored different options as to how I can do it -- Like using the Filter Pane -- but this will filter the entire visual or page. So this was not an option.</p><p><br /></p><p>So I thought of creating a new column named <b>Actual Date</b> in my Date table. So I created as below.</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-RkrYt9FlxJd39yZQgtTq2G0giaZrKIXK1RKxSYyjQ74Y3YZCQr-fjeaHg3Rpg0HZIqnCut3pnv3RHTQ48K2rvnQkAkfttdR4joTHnDLz01YTYUGkUwv1R1aAva367ZbZVZ2VJBs9ivGsIM80dHZatm_izOqW4MgCdDBkYsyuDpZHqRnzA-g/s1446/error.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="638" data-original-width="1446" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-RkrYt9FlxJd39yZQgtTq2G0giaZrKIXK1RKxSYyjQ74Y3YZCQr-fjeaHg3Rpg0HZIqnCut3pnv3RHTQ48K2rvnQkAkfttdR4joTHnDLz01YTYUGkUwv1R1aAva367ZbZVZ2VJBs9ivGsIM80dHZatm_izOqW4MgCdDBkYsyuDpZHqRnzA-g/w400-h176/error.JPG" width="400" /></a></div><br /><p>The formula I used was an IF statement, </p><p><span style="background-color: #fffffe; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">Actual Date = </span><span style="background-color: #fffffe; color: #3165bb; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">IF</span><span style="background-color: #fffffe; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">('Date'[Date]=</span><span style="background-color: #fffffe; color: #3165bb; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">TODAY</span><span style="background-color: #fffffe; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">(),</span><span style="background-color: #fffffe; color: #a31515; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">"Today"</span><span style="background-color: #fffffe; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">,'Date'[Date])</span></p><p>But this resulted in an error. When you closely look at the formula I have written, you may notice that the output is in two data types.. One is a <b>Text </b>data type which is Today and the other one is a Date which is a <b>Date </b>data type.</p><p><br /></p><p>So I have now modified the formula as below to convert the date data type into a text data type. Then the error is gone.</p><p><span style="background-color: #fffffe; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">Actual Date = </span><span style="background-color: #fffffe; color: #3165bb; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">IF</span><span style="background-color: #fffffe; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">('Date'[Date]=</span><span style="background-color: #fffffe; color: #3165bb; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">TODAY</span><span style="background-color: #fffffe; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">(),</span><span style="background-color: #fffffe; color: #a31515; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">"Today"</span><span style="background-color: #fffffe; font-family: Consolas, "Courier New", monospace; font-size: 12px; white-space: pre;">,'Date'[Date]&"")</span></p><p>Basically what the If statement is doing is -- If the Date is equal to Today's date then the text <b>Today </b>is going to be populated in the Actual Date column, otherwise the date is going to be populated as shown below.</p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXJxv21msOFlSVHOSWYkm5FJqEcrIcM-ql1MXk1V9JXIePbe-JnkV-GZQxYbVBpL9TVF2v6KrqGEIinNucUnDVnB_YrCy8AtKTpzb48uNti9_VLQ6VpzzDMDEnqMcJ9H78scr3Ivixbt7oGA5qSza3kffw3_iYc1giu1y1Y4mmrn4SND8JLZ4/s591/today.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="385" data-original-width="591" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXJxv21msOFlSVHOSWYkm5FJqEcrIcM-ql1MXk1V9JXIePbe-JnkV-GZQxYbVBpL9TVF2v6KrqGEIinNucUnDVnB_YrCy8AtKTpzb48uNti9_VLQ6VpzzDMDEnqMcJ9H78scr3Ivixbt7oGA5qSza3kffw3_iYc1giu1y1Y4mmrn4SND8JLZ4/w400-h260/today.JPG" width="400" /></a></div><p>Once you create the new column, create a slicer with the new column (Actual Date) and sort the data by descending and choose Today to default the slicer value. </p><p>After this is done, you will notice that the slicer is always defaulted to Today.</p><p><br /></p><p>You can follow a similar approach for Month as well. </p><p><br /></p><p><br /></p><p><br /></p><div><br /></div><p><br /></p><p><br /></p><p><br /></p>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-2171338763557079652021-08-12T22:45:00.000+12:002021-08-12T22:45:55.912+12:00Free Excel Classes for Adults Week 2<p>Yesterday was week 2 of free Microsoft Excel classes. In the beginner class of week 1 there were both kids and adults. Strongly felt the need to separate the kids and adults classes. So yesterday's class was restricted only to adults.</p><p>Thank you Bharatiya Mandir for this wonderful opportunity. The topics covered in this 2 hour session are as below:</p><p></p><ul style="text-align: left;"><li>Working with multiple worksheets</li><li>Text and Date Functions</li><li>Functions for Summarising Data</li><li>Pivot Tables</li></ul><p></p><p>Again enjoyed interacting with everyone. </p><p>Thanks to Krina and Harshavardhan for all your help in running this class.</p><p>Here a few glimpses from the session.</p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGjfAR1IHFeNKh7ZJJJNepfk3alTURZDr2NehCHNXeaixbr7ObiFT3RElcNy8yCWIw1HWEFkVdcwmjfCMThNgIKNdCkX_dntGHZvpawH1jD6Qly-T6ShkXczaMLR18i_zJqqTmiw/s2048/IMG-20210812-WA0001.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1536" data-original-width="2048" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGjfAR1IHFeNKh7ZJJJNepfk3alTURZDr2NehCHNXeaixbr7ObiFT3RElcNy8yCWIw1HWEFkVdcwmjfCMThNgIKNdCkX_dntGHZvpawH1jD6Qly-T6ShkXczaMLR18i_zJqqTmiw/w400-h300/IMG-20210812-WA0001.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_ux6kcC7dpdVzhlgIygV4d9ENzH8esgYCGyCSDbyn96BvdvhAs3aDtA_aKYl9jU4oMq0OiNpLqt6UxmSb6DxUuU6q3v_ytOqwrbvgOCPNXcksC26yUz5rWOdDCvUilffGtihv4g/s2048/IMG-20210812-WA0004.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1536" data-original-width="2048" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_ux6kcC7dpdVzhlgIygV4d9ENzH8esgYCGyCSDbyn96BvdvhAs3aDtA_aKYl9jU4oMq0OiNpLqt6UxmSb6DxUuU6q3v_ytOqwrbvgOCPNXcksC26yUz5rWOdDCvUilffGtihv4g/w400-h300/IMG-20210812-WA0004.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTUImSyPmC02sh4JUHyJ0wDGQnJtJA81oofxUHsQJcecNyxVidcy-fLt2RwU2uMkcqpD-zLlaaB7lvHViYQ8Ih29IuOJzGK1fKhvzHn6j4CysOL3bQp93E6tsZtDnvnRbi9aYk6Q/s2048/IMG-20210812-WA0005.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1536" data-original-width="2048" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTUImSyPmC02sh4JUHyJ0wDGQnJtJA81oofxUHsQJcecNyxVidcy-fLt2RwU2uMkcqpD-zLlaaB7lvHViYQ8Ih29IuOJzGK1fKhvzHn6j4CysOL3bQp93E6tsZtDnvnRbi9aYk6Q/w400-h300/IMG-20210812-WA0005.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg47FckNDak_Ny0k2ujd5pZp6IWqXGugkxq7mlrx9G1a12LnDjfD6-XbI46QhdFPFKhpVlUlj3Tcl8yhowKwQVdhuWkbOUo5kqOaNteGJ-EbLzNp1oWzSZ36Tp2YvrhK0p4oJUImA/s2048/IMG-20210812-WA0020.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1536" data-original-width="2048" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg47FckNDak_Ny0k2ujd5pZp6IWqXGugkxq7mlrx9G1a12LnDjfD6-XbI46QhdFPFKhpVlUlj3Tcl8yhowKwQVdhuWkbOUo5kqOaNteGJ-EbLzNp1oWzSZ36Tp2YvrhK0p4oJUImA/w400-h300/IMG-20210812-WA0020.jpg" width="400" /></a></div><br /><p><br /></p>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-46404109727487992912021-08-06T22:59:00.023+12:002021-08-16T00:10:03.778+12:00Day 4 of #30daysofML Learning<p>Below is my learning for Day 4 of #30daysofML</p><p>The datatype for boolean in python is 'bool'</p><p>Boolean operators are used for comparison</p><p>3.0 == 3</p><p>'3'== 3</p><p>Comparison operators can be combined with the arithmetic operators </p><p>Remember to use == instead of = when making comparisons.</p><p>Booleans are most useful when combined with conditional statements like if then else statement</p><p>Python has a functions as below:</p><p></p><ul style="text-align: left;"><li>int() function which turns things into ints, </li><li>float() functon which turns things into floats, </li><li>bool() function which turns things into bools.</li><li><span style="background-color: white; color: rgba(0, 0, 0, 0.87); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;">Calling </span><code style="border: 0px; box-sizing: unset; color: rgba(0, 0, 0, 0.87); font-family: var(--jp-code-font-family); font-size: 14px; line-height: var(--jp-code-line-height); padding: 1px 5px; white-space: pre-wrap;">bool()</code><span style="background-color: white; color: rgba(0, 0, 0, 0.87); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;"> on an integer returns </span><code style="border: 0px; box-sizing: unset; color: rgba(0, 0, 0, 0.87); font-family: var(--jp-code-font-family); font-size: 14px; line-height: var(--jp-code-line-height); padding: 1px 5px; white-space: pre-wrap;"><b>False</b></code><span style="background-color: white; color: rgba(0, 0, 0, 0.87); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;"><b> </b>if it’s equal to 0 and </span><code style="border: 0px; box-sizing: unset; color: rgba(0, 0, 0, 0.87); font-family: var(--jp-code-font-family); font-size: 14px; line-height: var(--jp-code-line-height); padding: 1px 5px; white-space: pre-wrap;"><b>True</b></code><span style="background-color: white; color: rgba(0, 0, 0, 0.87); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;"><b> </b>otherwise. </span></li><li><code style="border: 0px; box-sizing: unset; color: rgba(0, 0, 0, 0.87); font-family: var(--jp-code-font-family); font-size: 14px; line-height: var(--jp-code-line-height); padding: 1px 5px; white-space: pre-wrap;">int(True)</code><span style="background-color: white; color: rgba(0, 0, 0, 0.87); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;"> is 1, and </span><code style="border: 0px; box-sizing: unset; color: rgba(0, 0, 0, 0.87); font-family: var(--jp-code-font-family); font-size: 14px; line-height: var(--jp-code-line-height); padding: 1px 5px; white-space: pre-wrap;">int(False)</code><span style="background-color: white; color: rgba(0, 0, 0, 0.87); font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 14px;"> is 0.</span></li></ul><p></p><p>We can use non-boolean objects in if conditions and other places where a boolean would be expected. Python will implicitly treat them as their corresponding boolean value:</p><p>Here is the order of precedence of operators in Python</p><p><br /></p><table class="docutils align-default" style="background-color: white; border-collapse: collapse; border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: #222222; font-family: "Lucida Grande", Arial, sans-serif; font-size: 16px; margin: 10px auto; min-width: 20%; text-align: center;"><colgroup><col style="width: 447.438px;"></col><col style="width: 351.562px;"></col></colgroup><thead><tr class="row-odd"><th class="head" style="background-color: #eeeeee; border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Operator</p></th><th class="head" style="background-color: #eeeeee; border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Description</p></th></tr></thead><tbody><tr class="row-even"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">(expressions...)</span></code>,</p><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">[expressions...]</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">{key:</span> <span class="pre" style="hyphens: none;">value...}</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">{expressions...}</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Binding or parenthesized expression, list display, dictionary display, set display</p></td></tr><tr class="row-odd"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">x[index]</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">x[index:index]</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">x(arguments...)</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">x.attribute</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Subscription, slicing, call, attribute reference</p></td></tr><tr class="row-even"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#await" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">await</span></code></a> <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">x</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Await expression</p></td></tr><tr class="row-odd"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">**</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Exponentiation <a class="footnote-reference brackets" href="https://docs.python.org/3/reference/expressions.html#id21" id="id15" style="color: #0072aa; text-decoration-line: none;">5</a></p></td></tr><tr class="row-even"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">+x</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">-x</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">~x</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Positive, negative, bitwise NOT</p></td></tr><tr class="row-odd"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">*</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">@</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">/</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">//</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">%</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Multiplication, matrix multiplication, division, floor division, remainder <a class="footnote-reference brackets" href="https://docs.python.org/3/reference/expressions.html#id22" id="id16" style="color: #0072aa; text-decoration-line: none;">6</a></p></td></tr><tr class="row-even"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">+</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">-</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Addition and subtraction</p></td></tr><tr class="row-odd"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;"><<</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">>></span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Shifts</p></td></tr><tr class="row-even"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">&</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Bitwise AND</p></td></tr><tr class="row-odd"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">^</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Bitwise XOR</p></td></tr><tr class="row-even"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">|</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Bitwise OR</p></td></tr><tr class="row-odd"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#in" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">in</span></code></a>, <a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#not-in" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">not</span> <span class="pre" style="hyphens: none;">in</span></code></a>, <a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#is" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">is</span></code></a>, <a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#is-not" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">is</span> <span class="pre" style="hyphens: none;">not</span></code></a>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;"><</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;"><=</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">></span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">>=</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">!=</span></code>, <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">==</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Comparisons, including membership tests and identity tests</p></td></tr><tr class="row-even"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#not" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">not</span></code></a> <code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">x</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Boolean NOT</p></td></tr><tr class="row-odd"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#and" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">and</span></code></a></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Boolean AND</p></td></tr><tr class="row-even"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#or" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">or</span></code></a></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Boolean OR</p></td></tr><tr class="row-odd"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#if-expr" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">if</span></code></a> – <code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">else</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Conditional expression</p></td></tr><tr class="row-even"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><a class="reference internal" href="https://docs.python.org/3/reference/expressions.html#lambda" style="color: #0072aa; text-decoration-line: none;"><code class="xref std std-keyword docutils literal notranslate" style="background-color: transparent; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">lambda</span></code></a></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Lambda expression</p></td></tr><tr class="row-odd"><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;"><code class="docutils literal notranslate" style="background-color: #ecf0f3; border-radius: 3px; font-family: monospace, sans-serif; font-size: 15.44px; padding: 0px 1px;"><span class="pre" style="hyphens: none;">:=</span></code></p></td><td style="border-radius: 3px; border: 1px solid rgb(221, 221, 221); padding: 0.3em 0.5em; text-align: left;"><p style="hyphens: auto; line-height: 22.4px; margin-bottom: 0px; margin-top: 0px; text-align: justify;">Assignment expression</p></td></tr></tbody></table><p><br /></p>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-12989914293394997752021-08-05T23:21:00.002+12:002021-08-05T23:52:42.467+12:00Free Excel Classes week 1 <p>Yesterday I have started free Microsoft Excel classes for the people in the community who were interested. There was a good turn out of around 30 people. Thank you Bharatiya Mandir for this wonderful opportunity.</p><p>Thoroughly enjoyed interacting with everyone. Thanks to Krina. Smriti, Medha and Harshavardhan for all your help in running this class.</p><p>Here a few glimpses from the session.</p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEges8EH0v44VvrrYIOPrZ7-_GKWCGoHYXXpDb4ZsOK0E_ldo-fA6veynBcOzvLqvoOVKV3nA04fpLHNHjAEcsCi49NgHqiiAWyDdYyEvhGtVmnzIHoeSIXfZIrX7ZniTsfJH0B2Fg/s960/233826529_2963974133930459_3440918967675304323_n.jpg" style="margin-left: 1em; margin-right: 1em;"></a><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEges8EH0v44VvrrYIOPrZ7-_GKWCGoHYXXpDb4ZsOK0E_ldo-fA6veynBcOzvLqvoOVKV3nA04fpLHNHjAEcsCi49NgHqiiAWyDdYyEvhGtVmnzIHoeSIXfZIrX7ZniTsfJH0B2Fg/s960/233826529_2963974133930459_3440918967675304323_n.jpg" style="margin-left: 1em; margin-right: 1em;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDYP9676Eh1UDbfQUQnhq-iOFbRQvRR70vzFZg7CIXRdMjIbxncRQ_ZtGJiTZR6zsYlhB56WUJ03Ef-GX8vVoJvzumVSVjaIOaRqOb2qE0SbR7kfh1w66I1vBDZIIgj3ox97tUdA/s960/234247950_2963973973930475_9060129091760382732_n.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="540" data-original-width="960" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDYP9676Eh1UDbfQUQnhq-iOFbRQvRR70vzFZg7CIXRdMjIbxncRQ_ZtGJiTZR6zsYlhB56WUJ03Ef-GX8vVoJvzumVSVjaIOaRqOb2qE0SbR7kfh1w66I1vBDZIIgj3ox97tUdA/w640-h360/234247950_2963973973930475_9060129091760382732_n.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_wJt5p7tbKl0k55I5qiBfQhS4D2BgT_mu0QbScV6dAH_rZ9Rb2XmQ9OOfi8m3LOXzoWj397cUNJ48avhtqr28km_-ZTL32p8IKNO26mYq73DbLGWEtFffgOQfIVy1eJt-ci5XQw/s960/233674675_2963973910597148_2732565342216065968_n.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="540" data-original-width="960" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_wJt5p7tbKl0k55I5qiBfQhS4D2BgT_mu0QbScV6dAH_rZ9Rb2XmQ9OOfi8m3LOXzoWj397cUNJ48avhtqr28km_-ZTL32p8IKNO26mYq73DbLGWEtFffgOQfIVy1eJt-ci5XQw/w640-h360/233674675_2963973910597148_2732565342216065968_n.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div></div><img border="0" data-original-height="540" data-original-width="960" height="329" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEges8EH0v44VvrrYIOPrZ7-_GKWCGoHYXXpDb4ZsOK0E_ldo-fA6veynBcOzvLqvoOVKV3nA04fpLHNHjAEcsCi49NgHqiiAWyDdYyEvhGtVmnzIHoeSIXfZIrX7ZniTsfJH0B2Fg/w586-h329/233826529_2963974133930459_3440918967675304323_n.jpg" width="586" /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /><p><br /></p>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-5390230028053693622021-08-05T23:07:00.012+12:002021-08-13T23:09:46.699+12:00Day 3 of #30daysofML from Kaggle<p>Below is my learning for today as part of Day 3 of #30daysofML</p><p><br /></p><p>help()</p><p>help(round)</p><p>help(round(-30.18)</p><p>help(print)</p><p><br /></p><p>Defining functions</p><p>Builtin functions are great, but we can only get so far with them before we need to start defining our own functions. </p><p>Example if we want to calculate the least difference between 3 numbers</p><p>def least_diff (num1, num2, num3):</p><p><span style="white-space: pre;"> </span>diff1 =num1-num2</p><p><span style="white-space: pre;"> </span>diff2 =num2-num3</p><p><span style="white-space: pre;"> </span>diff3 =num3-num1</p><p>return min(diff1, diff2, diff3)</p><p>Functions start with a header introduced by the def keyword. The indented block of code following the : is run when the function is called.</p><p>return is another keyword uniquely associated with functions. When Python encounters a return statement, it exits the function immediately, and passes the value on the right hand side to the calling context.</p><p>If there is no return in the function, then the function will not return anything.</p><p>But there are some functions with no return statements inside them. Examples are print() and help()</p><p>Python allows trailing commas in argument lists. How nice is that?</p><p><br /></p>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-43872500128022843042021-08-04T23:10:00.008+12:002021-08-13T23:12:47.764+12:00Day 2 of #30daysofML from Kaggle<p> Below is the learning for today as part of the #30daysofML challenge</p><p></p><ul style="text-align: left;"><li>Variable assignment</li><li>Print function</li><li>#commenting the code in Python</li><li>Variable reassignment</li><li>Writing conditional statements using if</li></ul><p></p><p>The colon (:) at the end of the if line indicates that a new code block is starting</p><p>The * operator can be used to multiply two numbers (3 * 3 evaluates to 9), but we can also multiply a string by a number, to get a version that's been repeated that many times. Python offers a number of cheeky little time-saving tricks like this where operators like * and + have a different meaning depending on what kind of thing they're applied to. </p><p>What is type function used for ?</p><p>type(spam_amount)</p><p>The // operator gives us a result that's rounded down to the next integer.</p><p>print(float(10))</p><p>print(int(3.33))</p><p># They can even be called on strings!</p><p>print(int('807') + 1)</p><p><br /></p><p><br /></p><p><br /></p>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-78420669466946035892021-08-03T21:38:00.000+12:002021-08-03T21:38:37.296+12:00Day 1 of #30daysofML from Kaggle<p>I signed up for the 30 days of ML challenge organised by Kaggle. It started today. </p><p>I am so excited to learn Machine Learning as part of this initiative.</p><p>The tasks that were completed on Day1 were as below :</p><p></p><ul style="text-align: left;"><li>Created a kaggle profile</li><li>Used Titanic Datasets to load the train and test datasets</li><li>Used a Random Forest Algorithm to make predictions for Survival</li><li>Submitted my first prediction for the competition. </li></ul><p></p><p>I am looking forward for Day 2</p><p><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4uqd-bWXXKOHVuyUoasRa7a8Bq8gJVQBTUnvjeePQ9BmIqNnIodMlucINjQRR3GF42SVx82tus01nMaJ3x2a05kLx-6UNPzzUMIRyxrbO-LNu2lNaqMIr3RU1N-B7gadYgvXWmw/s1383/day+1+first+submission.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="420" data-original-width="1383" height="121" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4uqd-bWXXKOHVuyUoasRa7a8Bq8gJVQBTUnvjeePQ9BmIqNnIodMlucINjQRR3GF42SVx82tus01nMaJ3x2a05kLx-6UNPzzUMIRyxrbO-LNu2lNaqMIr3RU1N-B7gadYgvXWmw/w400-h121/day+1+first+submission.JPG" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYV_ne4PCv9F2vkCTBT0zOggr9Ix_FqNzHbfAtg4knVq98KOUnYVrfCjqYIbe843fa0cpK6q_bH5NpqEMjIehXclfARYsushPIuHtBiql_v9oIFCgQGeBC686FiNUEBENZxiRWtQ/s1066/day+1+contributor.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="262" data-original-width="1066" height="99" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYV_ne4PCv9F2vkCTBT0zOggr9Ix_FqNzHbfAtg4knVq98KOUnYVrfCjqYIbe843fa0cpK6q_bH5NpqEMjIehXclfARYsushPIuHtBiql_v9oIFCgQGeBC686FiNUEBENZxiRWtQ/w400-h99/day+1+contributor.JPG" width="400" /></a></div><br /><p><br /></p><div><br /></div><p><br /></p>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-54519899073889876642021-05-25T12:27:00.000+12:002021-05-25T12:27:30.456+12:00Power BI Competition for 10 to 14 year old kids -- India Batch Yesterday was a big day for me as it was the Power BI competition day for 10 to 14 year old kids who have gone through the free virtual Power BI training classes. <div><br /></div><div> This time I started providing free virtual training classes in Power BI for 10 to 14 year old kids who are based in Hyderabad, India. This program was undertaken in conjunction with the Sri Sathya Sai Seva Organisations, Hyderabad, India. Weekly classes started from 14th Feb 2021 continuing for 15 weeks and we concluded these classes by conducting a Power BI competition for Kids on Monday the 24th May virtually. 21 kids aged between 10 and 14 years presented their Data Analysis using Microsoft Power BI which they have learnt during these classes. The topics that kids picked ranged from Avocado, mines in India, candy population to book stations and sales and financial analysis. </div><div><br /></div><div>The judges were Mr. Reza Rad Director Radacad, Microsoft Regional Director and Microsoft MVP and Mrs. Leila Etaati Co-Founder Radacad and Microsoft MVP. Thanks a lot for patiently listening to each and every presentation.</div><div><br /></div><div>Congratulations to the winners Snehith Senkula, Hasini Vanam and Akshara Rao for their winning visualisations. All kids have done a great job in preparing and presenting their visualisations. </div><div><br /></div><div>Many thanks to the District President A. Malleswara Rao and the District Balvikas Coordinator M. Latha for giving us this opportunity to train the Balvikas kids. </div><div><br /></div><div>Thank you for all the huge help extended by Govardhani Tammina and Harshavardhan Tammina for making this whole journey a very smooth one! </div><div><br /></div><div><span style="font-size: x-large;">If you are interested in watching the video, you can <a href="https://www.youtube.com/watch?v=ZJtMVfaYFZc" target="_blank">watch it here </a></span></div><div><br /></div><div> Below are few photos of the final event.
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYKXUfpdxNni-IVsXph_ni0wEqbpem0K-uqmB1oxSMFX-OM-EXoKw1O3P88oTNsXcaak9WwigtIVKOddUMDEnxDf2CMTrvAQUsvo_8HLNYXI0THT_WpZhFLIY27Go8xg7NembWcg/s2048/comp2.jpg" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="1152" data-original-width="2048" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYKXUfpdxNni-IVsXph_ni0wEqbpem0K-uqmB1oxSMFX-OM-EXoKw1O3P88oTNsXcaak9WwigtIVKOddUMDEnxDf2CMTrvAQUsvo_8HLNYXI0THT_WpZhFLIY27Go8xg7NembWcg/s320/comp2.jpg" width="320" /></a></div><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJjFfgQoZoWx9n8koxISftIFJgyOVUjsKne5ojX-NYdyW2Xo_5Yt1lTw4EpDqs-D9FGr-MfSDtt05kTRTnwDPCH6eA3ObgvezFStA8ZQdiDajWIosU3TpEkbP0aGEbR6Nq4b2S9A/s2605/screenshot1.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="1207" data-original-width="2605" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJjFfgQoZoWx9n8koxISftIFJgyOVUjsKne5ojX-NYdyW2Xo_5Yt1lTw4EpDqs-D9FGr-MfSDtt05kTRTnwDPCH6eA3ObgvezFStA8ZQdiDajWIosU3TpEkbP0aGEbR6Nq4b2S9A/s320/screenshot1.JPG" width="320" /></a></div><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZsLewdfQu1lGLgWjtnKu7sVTrBbfNbe6HWbBDnEu7ae8D7aFp8WCH0I-dbxlTm6qMQ_Oy4csokYT2YbLaTAjpgbqes9jc38E-3thY2UB012oYOKQqzKoG4YIu7AMZ8ErLA3f3MQ/s2572/screenshot2.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="1222" data-original-width="2572" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZsLewdfQu1lGLgWjtnKu7sVTrBbfNbe6HWbBDnEu7ae8D7aFp8WCH0I-dbxlTm6qMQ_Oy4csokYT2YbLaTAjpgbqes9jc38E-3thY2UB012oYOKQqzKoG4YIu7AMZ8ErLA3f3MQ/s320/screenshot2.JPG" width="320" /></a></div><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYNuB0Sjp8QHCKhTAxRNZcCYFTVKGcvjct0R_-Z_z-9vLs3PPmxdlDebS812uLgzpsoZveIpiY9W-do4RPIfLxORcaMiXd0597WaCSCDcj3M9L-HGAZKv_GjJgWONUqrbIVw5yrw/s2048/screenshot+3.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="1141" data-original-width="2048" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYNuB0Sjp8QHCKhTAxRNZcCYFTVKGcvjct0R_-Z_z-9vLs3PPmxdlDebS812uLgzpsoZveIpiY9W-do4RPIfLxORcaMiXd0597WaCSCDcj3M9L-HGAZKv_GjJgWONUqrbIVw5yrw/s320/screenshot+3.JPG" width="320" /></a></div><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrjhvNUFvJtw7whRDhi7ZlKyaSXudoP-3TAy1F106YM04JrKplikJ-ICEPzyiwh0NtQZUwzbaj9M8tZDQOGvWXdO_BQgWK_Ab-4NNCYAJoo39qjE8A6shHzj6NeTm9HnNUSjikQQ/s2048/screenshot+5.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="1124" data-original-width="2048" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrjhvNUFvJtw7whRDhi7ZlKyaSXudoP-3TAy1F106YM04JrKplikJ-ICEPzyiwh0NtQZUwzbaj9M8tZDQOGvWXdO_BQgWK_Ab-4NNCYAJoo39qjE8A6shHzj6NeTm9HnNUSjikQQ/s320/screenshot+5.JPG" width="320" /></a></div><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9WDGExltiCItEFNH90HQW_E3QKshyphenhyphenA556vBrAPOdamIyrkAhDM9Sdrh6JbVJ8mJFPCN4NVS6bpuG7w-8QcPaGapKkqotFyzbMCkDdXKZPc0MZAoWT7Pk6NhO-eAruB904CbkW7A/s2048/screenshot+6.JPG" style="display: block; padding: 1em 0px; text-align: center;"><img alt="" border="0" data-original-height="1134" data-original-width="2048" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9WDGExltiCItEFNH90HQW_E3QKshyphenhyphenA556vBrAPOdamIyrkAhDM9Sdrh6JbVJ8mJFPCN4NVS6bpuG7w-8QcPaGapKkqotFyzbMCkDdXKZPc0MZAoWT7Pk6NhO-eAruB904CbkW7A/s320/screenshot+6.JPG" width="320" /></a></div>
</div>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com1tag:blogger.com,1999:blog-22369393.post-55203456897621296652021-04-06T00:09:00.002+12:002021-05-04T22:39:51.692+12:00wellness chatbot<html>
<table style="height: 80%px; width: 80%px;" valign="top">
<tr>
<td valign="top" width="50%">
<iframe src='https://webchat.botframework.com/embed/counselchatrev?s=a_XVZ7ZUBS0.rL_SpNBwT8ytD2gDaxKi3b7heDi6CU-3RtBPrJAtj5o' style='min-width: 400px; width: 100%; min-height: 500px;'></iframe>
</td>
<td valign="top" width="50%">
<!--<img alt="wellness chatbot" bp.blogspot.com="" chatbot.jpg="" d9m="" height="30%" https:="" r9midyogi="" s320="" src="src=" vtxunmdoombk3zimvovhbm6ylqkw70gclcbgasyhq="" wellness="" width="80%" />-->
</td>
</tr>
</table>
</html>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com3tag:blogger.com,1999:blog-22369393.post-73836108439323513442020-12-15T15:22:00.027+13:002020-12-30T15:57:57.123+13:00Power BI Competition for 10 to 14 year old kids -- Batch 3<div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;">Yesterday we concluded the 14 week Databases and Data Visualisation course with a Power BI Competition for #kids</span></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;">Thank you Reza Rad and Leila Etaati for being the judges for this competition. 12 kids presented various visualisations done in #powerbi. The topics ranged from avocado, cereals, candy to a variety of sport topics that included, soccer and arsenal Find below some of the photos of the event. Thank you Govardhani Tammina Indira Bandari Medha Bandari and Harshavardhan tammina for all the help that you have extended to make this a great success</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;">#powerbi #powerbicompetition #kidstechnz</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;">Tagging some of the parents Rajani Amuda, Raj Duptala CA, Achhi Burra, Shamiso Nyoni, Latha Numburi, Rekha Sayapparaju,</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: arial;">Thanks for all your support</span></div><div class="separator" style="clear: both;"><br /></div></div><p></p><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiY2hlpqCuOvrSzHdLSvVSp5Cdab11jbds_TvkQ-6kTNKbn00w7OCXC6GZNQuJqTjY7NUAUME9bk2dD6IfRuW7zuYBicN45rlzc0sGrrARk9G59hnD17Oq4jec5E8Q8clVza1GDcQ/s2642/20201214_182525.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1190" data-original-width="2642" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiY2hlpqCuOvrSzHdLSvVSp5Cdab11jbds_TvkQ-6kTNKbn00w7OCXC6GZNQuJqTjY7NUAUME9bk2dD6IfRuW7zuYBicN45rlzc0sGrrARk9G59hnD17Oq4jec5E8Q8clVza1GDcQ/w400-h180/20201214_182525.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijNGG5ax8AhUy2AGhEKXiyiGMv6C65hdZ34RTyy3x_JQvxEhrqrBjhoteJlOCUNFws8BHvNZ1TvIm4DEWFAB1C8APlti_gxpdPdBRe-NY0Hn5lh2_tFR5QZfIhw3I7CHMaQwu4DQ/s2642/20201214_183045.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1190" data-original-width="2642" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijNGG5ax8AhUy2AGhEKXiyiGMv6C65hdZ34RTyy3x_JQvxEhrqrBjhoteJlOCUNFws8BHvNZ1TvIm4DEWFAB1C8APlti_gxpdPdBRe-NY0Hn5lh2_tFR5QZfIhw3I7CHMaQwu4DQ/w400-h180/20201214_183045.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBh-q4gpnrHt3ORCcgnJgJBbusF3PNzZ26IkmA-7lBMERPujvdEf4VrhH9Ri7ngopjrvO_c2b87nMt2BapbF0YZSBFLlTVYmfHp9VXo320WwG6Bm1dqfQeuPcL63a97gMg1VOAPQ/s2642/20201214_183520.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1190" data-original-width="2642" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBh-q4gpnrHt3ORCcgnJgJBbusF3PNzZ26IkmA-7lBMERPujvdEf4VrhH9Ri7ngopjrvO_c2b87nMt2BapbF0YZSBFLlTVYmfHp9VXo320WwG6Bm1dqfQeuPcL63a97gMg1VOAPQ/w400-h180/20201214_183520.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJ5Zv2ul8yUm-ydEaHkfS_yXSizTlzYm5QFf91JxOXpTtQtVNPFZgtSWN3pHZmFt6AQvZHTjJR7jsnR4OlijZboUmu7RXzo0_ZwZRTrJD0yQei1boZPtwidQKBwYT8H1G65pNa1A/s2642/20201214_184232.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1190" data-original-width="2642" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJ5Zv2ul8yUm-ydEaHkfS_yXSizTlzYm5QFf91JxOXpTtQtVNPFZgtSWN3pHZmFt6AQvZHTjJR7jsnR4OlijZboUmu7RXzo0_ZwZRTrJD0yQei1boZPtwidQKBwYT8H1G65pNa1A/w400-h180/20201214_184232.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7emhyphenhyphen25a5saBMK3CEitnQAFUx5u6KHihzEB2fUwna82Xxfk0oIfwdWfJW1AwSwotdacH5qwhyAeoHVJexYRmdDZXtU7JnWO9G4oItBhl7FWosF-NpG41tclhQ6UcBExNVc07hlQ/s2642/20201214_185107.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1190" data-original-width="2642" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7emhyphenhyphen25a5saBMK3CEitnQAFUx5u6KHihzEB2fUwna82Xxfk0oIfwdWfJW1AwSwotdacH5qwhyAeoHVJexYRmdDZXtU7JnWO9G4oItBhl7FWosF-NpG41tclhQ6UcBExNVc07hlQ/w400-h180/20201214_185107.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuWXcBhgUQOiFi2ATgdEN5lJC2NrnKfQZYzwfCCIUcwcjwXISHixSu7F-HWttpVVyYujA9fZNLlAALfWPwaCgfVGAnJEVg9bz-m2vzGe_3V0XbxeK25OmeVOtNArjjGttjTilscg/s2642/20201214_185438.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1190" data-original-width="2642" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuWXcBhgUQOiFi2ATgdEN5lJC2NrnKfQZYzwfCCIUcwcjwXISHixSu7F-HWttpVVyYujA9fZNLlAALfWPwaCgfVGAnJEVg9bz-m2vzGe_3V0XbxeK25OmeVOtNArjjGttjTilscg/w400-h180/20201214_185438.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOOcLsPZo7W1B2kSSoAq5RmNL6L4exufr1oGRHBpOo9MAA2Yheijx28TwaNGjcScwqvlSKkJqxjGjtGnVQgZ3GUOeQGX9RAQcTb9-EFVnB5hO_X70kjlzRJCwqDcZYMV-jLHQPvQ/s2048/20201214_190657.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1152" data-original-width="2048" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOOcLsPZo7W1B2kSSoAq5RmNL6L4exufr1oGRHBpOo9MAA2Yheijx28TwaNGjcScwqvlSKkJqxjGjtGnVQgZ3GUOeQGX9RAQcTb9-EFVnB5hO_X70kjlzRJCwqDcZYMV-jLHQPvQ/w400-h225/20201214_190657.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigB1GZZekIN_vz3Rs-7OFrBz6CYyU54tcKxYVlBrhuCQCmuAUlJUJ1jciUv3xIqg2n4ADaJw20w1cU7EFKikjRXDklaklexUWWJtTwZ8sse9N5pVYDBiuUB5mOV6bDXJj-9ZgcOA/s2642/20201214_190755.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1190" data-original-width="2642" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigB1GZZekIN_vz3Rs-7OFrBz6CYyU54tcKxYVlBrhuCQCmuAUlJUJ1jciUv3xIqg2n4ADaJw20w1cU7EFKikjRXDklaklexUWWJtTwZ8sse9N5pVYDBiuUB5mOV6bDXJj-9ZgcOA/w400-h180/20201214_190755.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6WjoDlT92awSNoDcWeGoSV8bOtswiLXdtKDLeCrnQz-LHyxv-Ien5s3zigP4GWvENRNEm4sFDP0n7VheyAE8slw-DZJKzjW19UXoyROzUuMuEb9MZ_dr2A-c-gGQevmqFd7E2Zw/s2642/20201214_191550.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1190" data-original-width="2642" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6WjoDlT92awSNoDcWeGoSV8bOtswiLXdtKDLeCrnQz-LHyxv-Ien5s3zigP4GWvENRNEm4sFDP0n7VheyAE8slw-DZJKzjW19UXoyROzUuMuEb9MZ_dr2A-c-gGQevmqFd7E2Zw/w400-h180/20201214_191550.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFJI_FdXGdcb-pOGc5KRGBB3MHmkahy95z8ow-WZ930RZ0iK0kK0IIAeEu7wK_bKP6Gz-eudWb8bCistAA2fn2CanZR-sYFAY_zqN6gPXeoBpZ_Vel1P0-inLEpJOXhiwadnGYFg/s1024/IMG-20201214-WA0004.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="768" data-original-width="1024" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFJI_FdXGdcb-pOGc5KRGBB3MHmkahy95z8ow-WZ930RZ0iK0kK0IIAeEu7wK_bKP6Gz-eudWb8bCistAA2fn2CanZR-sYFAY_zqN6gPXeoBpZ_Vel1P0-inLEpJOXhiwadnGYFg/w400-h300/IMG-20201214-WA0004.jpg" width="400" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZuK2FykqIYQ5JNqiVSrjF8-Q8Uo0SMJRpEA7RWFycVWtR2avfA_Vvzb3kLjhEc4l9zLlazFnv0ZFCcZo0jJhkPHbzLaO7TI8jDJ0sOEjF5Ejn6hvzbpvYUkVyfPSg7HRtD0GDCA/s1080/Screenshot_20201216-001947_Video+Player.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="616" data-original-width="1080" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZuK2FykqIYQ5JNqiVSrjF8-Q8Uo0SMJRpEA7RWFycVWtR2avfA_Vvzb3kLjhEc4l9zLlazFnv0ZFCcZo0jJhkPHbzLaO7TI8jDJ0sOEjF5Ejn6hvzbpvYUkVyfPSg7HRtD0GDCA/w400-h229/Screenshot_20201216-001947_Video+Player.jpg" width="400" /></a></div><br /><span style="background-color: white; color: rgba(0, 0, 0, 0.9); font-family: -apple-system, system-ui, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", "Fira Sans", Ubuntu, Oxygen, "Oxygen Sans", Cantarell, "Droid Sans", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Lucida Grande", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span><p></p>Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com2tag:blogger.com,1999:blog-22369393.post-47657004007303699672020-05-19T23:19:00.000+12:002020-05-21T23:20:05.108+12:00Free Coding classes for 5 to 9 year old -- week 2 update<div dir="ltr" style="text-align: left;" trbidi="on">
Following on from my LinkedIn post last week, I had several of the parents contact me to train their kids to learn the coding basics. I have accepted a few additional kids and conducted the first session on Saturday so that they can get up to speed when they attend the regular session for week 2 on Monday.<br />
<br />
There were 12 kids who attended week 2 course. This week we covered what Pair Progranning is. What the Do's and Don'ts are in a Pair Programming scenario. Now the kids started using blockly to drag and drop and get the object move and get to the destination. I have also introduced the concept of how to debug step by step and how to use the Repeat block. Kids were quite comfortable when using the repeat block. <br />
<br />
In the class we started Lesson 6 and the home work was to complete all the exercises in Lesson 6.<br />
<br />
Here are some photos fro the session.<br />
<br />
<br /></div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com4tag:blogger.com,1999:blog-22369393.post-22408699668630414162020-05-12T20:34:00.000+12:002020-05-12T20:54:21.246+12:00Coding basics class for 5 to 9 year old kids<div dir="ltr" style="text-align: left;" trbidi="on">
Yesterday I have started my first round of technology classes for kids. This time I have started coding classes for 5 to 9 year old kids. The inspiration came from the interest showed by my 5 year old daughter Veda when I introduced her to code.org<br />
<br />
I introduced code.org basics to about 8 kids in an online class. They clearly understood the 3 rules when they start these classes which are outlined as below<br />
<br />
<br />
<ul style="text-align: left;">
<li>Ask your parents if you want to go online</li>
<li>Only talk to people you know on the internet</li>
<li>Stick to places that are right for you on the internet</li>
</ul>
<br />
<br />
The parents were helping their kids to get them signed up and teaching them how to share their screen if they are stuck.<br />
<br />
All the kids enjoyed the session yesterday. I am planning to continue this for 6 weeks and see what they understand. Some photos from the session below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8o1uG6VoFZC_h4DRkjZFkZtST4DuZ5ChyphenhyphenWrThoXW_ockwwZSJ9JP4EVSo7TEqVij6MwVL5IvsCzT9eJHrJrsYvZMdrEFm2EuRf7Px5AqnV2V7KNyW_1ciQ0vK4D6uK2gKUWTyfg/s1600/coding2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="407" data-original-width="1303" height="123" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8o1uG6VoFZC_h4DRkjZFkZtST4DuZ5ChyphenhyphenWrThoXW_ockwwZSJ9JP4EVSo7TEqVij6MwVL5IvsCzT9eJHrJrsYvZMdrEFm2EuRf7Px5AqnV2V7KNyW_1ciQ0vK4D6uK2gKUWTyfg/s400/coding2.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhexVZbq7ArGajisv-mUHA0iCQ17UXU8QYKs_y01QpwWW2VVgPSUQWzG9mgVY9fyINlA_cPhmLyahS2v9QUO4IINCSRe98bQGv-e7bsFP3Thcriy-pdnKDnY5DJmxsvuXhOkR0Wcg/s1600/coding+3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="472" data-original-width="1366" height="137" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhexVZbq7ArGajisv-mUHA0iCQ17UXU8QYKs_y01QpwWW2VVgPSUQWzG9mgVY9fyINlA_cPhmLyahS2v9QUO4IINCSRe98bQGv-e7bsFP3Thcriy-pdnKDnY5DJmxsvuXhOkR0Wcg/s400/coding+3.jpg" width="400" /></a></div>
<br />
<br /></div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-83805144739219313162020-03-12T10:32:00.000+13:002020-03-24T19:04:51.777+13:00Nurturing women data scientists- International womens day<Head>
<!-- Global site tag (gtag.js) - Google Analytics -->
<script async src="https://www.googletagmanager.com/gtag/js?id=UA-161746244-1"></script>
<script>
window.dataLayer = window.dataLayer || [];
function gtag(){dataLayer.push(arguments);}
gtag('js', new Date());
gtag('config', 'UA-161746244-1');
</script>
</Head>
<div dir="ltr" style="text-align: left;" trbidi="on">
Yesterday Leila Etaati and I ran a Azure Machine Learning workshop for Women Data Scientists in Auckland.<br />
<br />
The topics covered in this workshop are as below<br />
<br />
<ul style="margin-top: 0in;" type="disc">
<li class="MsoNoSpacing"><span lang="EN-MY">Introduction
to Machine Learning<o:p></o:p></span></li>
<li class="MsoNoSpacing"><span lang="EN-MY">Setting
up development environment<o:p></o:p></span></li>
<li class="MsoNoSpacing">AzureML Experiments using AML Studio and AML Designer</li>
<li class="MsoNoSpacing">Develop and Consume AzureML Models</li>
<li class="MsoNoSpacing"><span lang="EN-MY">Automated Machine Learning</span></li>
<li class="MsoNoSpacing"><span lang="EN-MY">Introduction to R and Python </span></li>
<li class="MsoNoSpacing"><span lang="EN-MY">AML in Python Notebook<o:p></o:p></span></li>
<li class="MsoNoSpacing"><span lang="EN-MY">Evaluate
model performance in AML<o:p></o:p></span></li>
<li class="MsoNoSpacing"><span lang="EN-MY">Azure
ML Batch Score, Retrain, Production and Automatization<o:p></o:p></span></li>
<li class="MsoNoSpacing"><span lang="EN-MY">Recommendation
System<o:p></o:p></span></li>
<li class="MsoNoSpacing">Azure Cognitive Services Overview</li>
</ul>
<br />
<br />
<div>
About 16 women attended this workshop and there were great discussions initiated by few of the participants. Thanks to Sydhir Rawat from Microsoft for the opportunity. In the end each participant were given a book "Invisible Women"</div>
<div>
<br /></div>
<div>
A few Photos from the event</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjA5OXYusqoR9_WnF8UWHNW9DCaWOiyVuWWx5qjtyZi_IVhzA6xqOB6KJRDXnY0yTKW4ixY1pTm075YDCG2phSrkJGnYA3CrPri875t5aUMViSGXnXYxpK6DCfYfZzuuwAMoERpA/s1600/20200311_090055.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjA5OXYusqoR9_WnF8UWHNW9DCaWOiyVuWWx5qjtyZi_IVhzA6xqOB6KJRDXnY0yTKW4ixY1pTm075YDCG2phSrkJGnYA3CrPri875t5aUMViSGXnXYxpK6DCfYfZzuuwAMoERpA/s400/20200311_090055.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0oVZXlTdTqt4crElEh8Co_ncPuT-8cGBs7K4Ia1Rb8YzbUq8Qiy1lUfZoD9ATBAu4Wqu8FiWgUNPR7-JjEJlZfkP6l0QklUlG9uF34kyShEzloQQa95Xt_LftF1t4vGv48U4Mtg/s1600/20200311_085937.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0oVZXlTdTqt4crElEh8Co_ncPuT-8cGBs7K4Ia1Rb8YzbUq8Qiy1lUfZoD9ATBAu4Wqu8FiWgUNPR7-JjEJlZfkP6l0QklUlG9uF34kyShEzloQQa95Xt_LftF1t4vGv48U4Mtg/s400/20200311_085937.jpg" width="400" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpWmpPdMSH5AK8shWr2WXK-XMoyLOP-lW_WahQthsrJrwxc0W4IgHgsO0Bp7f74dAXgw1gi38amDL0rL2jtAllJ2rFayNJt9l3pBscYzY0g2U5EOEfyFqVeIglRJtsd6P9hZDGjQ/s1600/20200311_094154.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpWmpPdMSH5AK8shWr2WXK-XMoyLOP-lW_WahQthsrJrwxc0W4IgHgsO0Bp7f74dAXgw1gi38amDL0rL2jtAllJ2rFayNJt9l3pBscYzY0g2U5EOEfyFqVeIglRJtsd6P9hZDGjQ/s400/20200311_094154.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIhx1dmU7eB1JR4NcH16HExzNJm3m5eEeQDDtP4v_zWFwKGD73YEGG3DQEtqH_juqVo_2MHiFnm7OMLCkLN_JpOuD3OKsSDOHEdBliCRECo9qCf6UP3Ir809XnkcPonH0kD79tsA/s1600/20200311_154937.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIhx1dmU7eB1JR4NcH16HExzNJm3m5eEeQDDtP4v_zWFwKGD73YEGG3DQEtqH_juqVo_2MHiFnm7OMLCkLN_JpOuD3OKsSDOHEdBliCRECo9qCf6UP3Ir809XnkcPonH0kD79tsA/s400/20200311_154937.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPCe7BTZ-TkUQT-CyjIbKn9Ky00Vy-dAhOQ7iVhbvORBhWUsS8HtB9qqzlsl3na64N4vd9FZqwQYp2fKAL0AWwzdTMQ1bd8yeaK_d3uOTEB0P3b8PxUCh4ORbXIpM_dhMxOlU5Uw/s1600/20200311_164747.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPCe7BTZ-TkUQT-CyjIbKn9Ky00Vy-dAhOQ7iVhbvORBhWUsS8HtB9qqzlsl3na64N4vd9FZqwQYp2fKAL0AWwzdTMQ1bd8yeaK_d3uOTEB0P3b8PxUCh4ORbXIpM_dhMxOlU5Uw/s320/20200311_164747.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBe0hg_aOCR2nM5xNFApP7BiVDwmB-Uu1Bl68vB3HS5bZmdl6jPS71O9D8EiKfR6ZdPLcJavgUGRZQwJ0ihZPFp6RErHUqNCjh1GN8y2032yMxptanmlhArXL3d7m33f1HrT-1NA/s1600/20200311_164749.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBe0hg_aOCR2nM5xNFApP7BiVDwmB-Uu1Bl68vB3HS5bZmdl6jPS71O9D8EiKfR6ZdPLcJavgUGRZQwJ0ihZPFp6RErHUqNCjh1GN8y2032yMxptanmlhArXL3d7m33f1HrT-1NA/s320/20200311_164749.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com1tag:blogger.com,1999:blog-22369393.post-61442456663881159052020-02-24T17:19:00.000+13:002020-02-24T23:09:34.249+13:00My presentation at Conferenz event -- 2020 Management Accountant Conference<div dir="ltr" style="text-align: left;" trbidi="on">
Today I did two presentations to an entirely different audience at one of the <a href="https://www.conferenz.co.nz/" target="_blank">Conferenz </a>events -- <a href="https://www.conferenz.co.nz/events/management-accountant-conference" target="_blank">2020 Management Accountant Conference</a>. As the conference event indicates, the audience were Accountants and Management Accountants and other financial professionals.<br />
<br />
I had two sessions to talk about as below -- About Artificial Intelligence and Business Intelligence.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU0kuTJinanvdRCai1xlTsOMv37AF4Hq3qRei1XMDnThllbU_qB7CJJtr7RP-lNu4XfHUgLlBkgOpBLMhXJXB0A9uYPnME7a9jKS4iIr4plg853UmEH9XPt8NBX_FzbgAN-fMdFA/s1600/agenda.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="415" data-original-width="1260" height="131" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjU0kuTJinanvdRCai1xlTsOMv37AF4Hq3qRei1XMDnThllbU_qB7CJJtr7RP-lNu4XfHUgLlBkgOpBLMhXJXB0A9uYPnME7a9jKS4iIr4plg853UmEH9XPt8NBX_FzbgAN-fMdFA/s400/agenda.JPG" width="400" /></a></div>
<br />
I really enjoyed presenting about Azure Cognitive Services and show off Power BI as most of the audience didn't know much about these tools. Had a great interaction with the audience and it is a really good feeling that they have learnt something new and I could see the excitement in a lot of them as they got to know more about these tools.<br />
<br />
Some of the photos from the event below.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjW210RFneMSgseXxkb94U9FRGkN-mqVXULPzxareSPDeMf3MPCkKsuU-bjfAPMvFRIdVx5gqLccNCNbr0LwMwaVpGvUZcoe1dpSpQMB4NvKk1jxmmQ9WSVIgh65hvNN1WagU50yQ/s1600/20200224_132814.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjW210RFneMSgseXxkb94U9FRGkN-mqVXULPzxareSPDeMf3MPCkKsuU-bjfAPMvFRIdVx5gqLccNCNbr0LwMwaVpGvUZcoe1dpSpQMB4NvKk1jxmmQ9WSVIgh65hvNN1WagU50yQ/s400/20200224_132814.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXENpzlItY2LpaRsxQeBRWMNR4mFMl2rxVRQ110DyS1ZzXjYDGkhGgyytq70GcBHwlrF1QiDQtPcOsXvVUlR6QieLXpXL1BkGG8Tlk5AU8P4BHTYwShB7pIWZYiBiupWcUEx1BTw/s1600/20200224_134236.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXENpzlItY2LpaRsxQeBRWMNR4mFMl2rxVRQ110DyS1ZzXjYDGkhGgyytq70GcBHwlrF1QiDQtPcOsXvVUlR6QieLXpXL1BkGG8Tlk5AU8P4BHTYwShB7pIWZYiBiupWcUEx1BTw/s400/20200224_134236.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCCa6kFKvU7T0ScU1P-rp2kyB7MS5GScwQKptbxbBX2DmI8glkQpEPsG7uLIrJQR1BS21sphyphenhyphenE6gmVg8DhuNfD_LgT92U2CafHe-gPOrGsK3aVKdS3IBVQeUX7ZMwLOb3VZpOjqA/s1600/20200224_134507.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCCa6kFKvU7T0ScU1P-rp2kyB7MS5GScwQKptbxbBX2DmI8glkQpEPsG7uLIrJQR1BS21sphyphenhyphenE6gmVg8DhuNfD_LgT92U2CafHe-gPOrGsK3aVKdS3IBVQeUX7ZMwLOb3VZpOjqA/s400/20200224_134507.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjkvO1Sqc9M7ibF0dJBMFAem77MD4rY1t9apA1n5E_8J273Cd2LAwDu7aDz_eoLa4fBkOY7gngs72R91aTQ2JxdL-FX4VeEhaud08JWT9ChN3yeCSmH6Ru0ielXtBD0LUgYOr0xQ/s1600/20200224_135647.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjkvO1Sqc9M7ibF0dJBMFAem77MD4rY1t9apA1n5E_8J273Cd2LAwDu7aDz_eoLa4fBkOY7gngs72R91aTQ2JxdL-FX4VeEhaud08JWT9ChN3yeCSmH6Ru0ielXtBD0LUgYOr0xQ/s400/20200224_135647.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFlTDKSz9Hh5AOp3lOuL68JzYIunFaJRpl16dKbPWxtN_7zfwIZy7WwwenzB5Gt2nOGy86dhTBm3VDsR4GaJCEtNY4KaYJHL1n_a50dv38AnHaDdl-xhuWX3yT4Xt9dHMf9vR5Bw/s1600/20200224_143823.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFlTDKSz9Hh5AOp3lOuL68JzYIunFaJRpl16dKbPWxtN_7zfwIZy7WwwenzB5Gt2nOGy86dhTBm3VDsR4GaJCEtNY4KaYJHL1n_a50dv38AnHaDdl-xhuWX3yT4Xt9dHMf9vR5Bw/s400/20200224_143823.jpg" width="400" /></a></div>
<br />
<br />
<br /></div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com2tag:blogger.com,1999:blog-22369393.post-27043204600941730392020-02-22T18:36:00.000+13:002020-02-24T16:54:18.254+13:00My presentation at SQL Saturday Wellington 2020<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
I enjoyed presenting at SQL Saturday Wellington today on the topic "Empower your Business Apps using Azure Cognitive Services"<br />
<br />
Thanks to Anupama Natarajan and the SQL Saturday organising team for this wonderful opportunity.<br />
<br />
Here is the <a href="https://github.com/indupriya9/Presentations/blob/master/cognitive%20services%20sqlsat.pptx" target="_blank">link </a>to the slides. Below is a photo of the women speakers of SQL Saturday in Wellington Enjoyed interacting and getting to know each and every one of them.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeOMdI_e5b902i7HVxH8ecjtCcRLBt7pkWNXLGr20CnmEmKouJtn5zyTnrIWzDgmLwncfARSAuqi2qsK1gR5p11SWsKFJP2S7_NmfgTzqAruBKt50R-Gx6fNUcUB-neeqffh5Gow/s1600/20200222_140626.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeOMdI_e5b902i7HVxH8ecjtCcRLBt7pkWNXLGr20CnmEmKouJtn5zyTnrIWzDgmLwncfARSAuqi2qsK1gR5p11SWsKFJP2S7_NmfgTzqAruBKt50R-Gx6fNUcUB-neeqffh5Gow/s400/20200222_140626.jpg" width="400" /></a></div>
<br />
I have given away 1 book titled "
<a 14.85px="" arial="" color:="" dd7700="" font-family:="" font-size:="" freesans="" helvetica="" href="https://www.amazon.com/Crash-Course-hands-introduction-reinforcement-dp-1838645357/dp/1838645357?" none="" sans-serif="" tahoma="" target="_blank" text-decoration-line:="">AI Crash Course</a>" by
<a 14.85px="" arial="" color:="" dd7700="" font-family:="" font-size:="" freesans="" helvetica="" href="https://www.linkedin.com/in/hadelin-de-ponteves-1425ba5b/" none="" sans-serif="" tahoma="" text-decoration-line:="">Hadelin-de-ponteves</a> to 2 of the very interested attendees.. Thanks to <a 14.85px="" arial="" color:="" dd7700="" font-family:="" font-size:="" freesans="" helvetica="" href="https://www.linkedin.com/in/ravit-jain-04647b99/" none="" sans-serif="" tahoma="" target="_blank" text-decoration-line:="">Ravit Jain</a> of @Packt Publication for providing these books to me. This book is really good for those who are starting to understand what Artificial Intelligence is and would like to know about it.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHmOHy-ORqpbx1BH4Dqt1B_T_A06aA-ECdg6mdGKAfVR0cxgBp0PrAY-yaQm6JHV3ivQ2FJgmATBZ8iY4NzzRoZOzzyqOSfvJqhcu8ix1IZNEcs6L695kgxwhxAyrQvWNpds9dgg/s1600/20200222_120219.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHmOHy-ORqpbx1BH4Dqt1B_T_A06aA-ECdg6mdGKAfVR0cxgBp0PrAY-yaQm6JHV3ivQ2FJgmATBZ8iY4NzzRoZOzzyqOSfvJqhcu8ix1IZNEcs6L695kgxwhxAyrQvWNpds9dgg/s400/20200222_120219.jpg" width="400" /></a></div>
<br /></div>
</div>
</div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com1tag:blogger.com,1999:blog-22369393.post-25501941762600462082020-02-19T22:02:00.002+13:002020-02-19T23:01:19.048+13:00Difinity Conference Day 2<div dir="ltr" style="text-align: left;" trbidi="on">
Day 2 of Difinity had yet some more informative sessions. I have attended sessions by Dejan Sarka, Anupama Natarajan, Heidi Hasting.<br />
<br />
My session today was "<b>Web Scraping In Power BI</b>". Really enjoyed presenting to an interactive audience. Once again thanks to Charles Sterling, I could give away some of the can opener USBs.<br />
<br />
Once again I have given away 2 books titled "<a href="https://www.amazon.com/Crash-Course-hands-introduction-reinforcement-dp-1838645357/dp/1838645357?" target="_blank">AI Crash Course</a>" by <a href="https://www.linkedin.com/in/hadelin-de-ponteves-1425ba5b/">Hadelin-de-ponteves</a> to 2 of the very interested attendees.. Thanks to <a href="https://www.linkedin.com/in/ravit-jain-04647b99/" target="_blank">Ravit Jain</a> of @Packt Publication for providing these books to me. This book is really good for those who are starting to understand what Artificial Intelligence is and would like to know about it.<br />
<br />
Thanks to Reza and Leila for organising this event and also to all the volunteers who have helped in this event. Some of the photos of my session below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghQGCVND9hyoAORl_3tK5OrFLafTMA8fCZJw-eyZ9XO5wYkzwZc12hSqraBRIUvnp_woRvrmLhYy8UJant_yqoituM6YLedWZAoiHb6yEOqg2DHkzKyBabGD8GMcQmrjxNZX2sJA/s1600/20200219_123203.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghQGCVND9hyoAORl_3tK5OrFLafTMA8fCZJw-eyZ9XO5wYkzwZc12hSqraBRIUvnp_woRvrmLhYy8UJant_yqoituM6YLedWZAoiHb6yEOqg2DHkzKyBabGD8GMcQmrjxNZX2sJA/s400/20200219_123203.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnyOrXE-fSxTf1Q3_Hqa_ZP_CvgXV43RoejZ0AtO8655Xu6AZomOeLiwwwnek5Nk5Fc6x2QAPiThaekYM4qKcmqC1WE_j4mfRte6m9UoV5FXtfmcJg8-KgfYzKc8J-1DvRVmrI9A/s1600/20200219_123226.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnyOrXE-fSxTf1Q3_Hqa_ZP_CvgXV43RoejZ0AtO8655Xu6AZomOeLiwwwnek5Nk5Fc6x2QAPiThaekYM4qKcmqC1WE_j4mfRte6m9UoV5FXtfmcJg8-KgfYzKc8J-1DvRVmrI9A/s400/20200219_123226.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6PzY4Jitn5Yb_ecw5LzFNLj7jroT0KHonVyyTMLjz7z7UDGoBVmDWqXXwzAqmjFWzoGDRsRHIbWDCLXYiZZi0eC-rJ_Biegb8YDLIBjWKqR1qSvDMXN8ZkZxDl-ydioBmzq0xvg/s1600/20200219_123310.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6PzY4Jitn5Yb_ecw5LzFNLj7jroT0KHonVyyTMLjz7z7UDGoBVmDWqXXwzAqmjFWzoGDRsRHIbWDCLXYiZZi0eC-rJ_Biegb8YDLIBjWKqR1qSvDMXN8ZkZxDl-ydioBmzq0xvg/s400/20200219_123310.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg8SUmoV_p3NHrmH65PyeNVIgpoQV-StzQp84X5Ac2ik1Zl4hXqPSPylMaQ1D6vvralZAqOXzhwdq6LJqw-AGH8_IFg7mmwJgl8omCRJBI2A14tV2s0ShgACShJin-2PIfaHdi0g/s1600/20200219_130235.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg8SUmoV_p3NHrmH65PyeNVIgpoQV-StzQp84X5Ac2ik1Zl4hXqPSPylMaQ1D6vvralZAqOXzhwdq6LJqw-AGH8_IFg7mmwJgl8omCRJBI2A14tV2s0ShgACShJin-2PIfaHdi0g/s400/20200219_130235.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibuh-mhzhcrB75M_-PrCq6cwbmuThQ3zhPAgy9WIl7FUmFs4jdOvA9MrzvLe6HnRIO1PONO-rr3zZ76n3TkGu2yw05TrQT7hyjO5mX5vHHLNWE9fVGk2_UguShtTuQg1Itunz1Og/s1600/20200219_AI+1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibuh-mhzhcrB75M_-PrCq6cwbmuThQ3zhPAgy9WIl7FUmFs4jdOvA9MrzvLe6HnRIO1PONO-rr3zZ76n3TkGu2yw05TrQT7hyjO5mX5vHHLNWE9fVGk2_UguShtTuQg1Itunz1Og/s400/20200219_AI+1.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYF10D-5KpmHUhsGE80x8qrKdKkY-xl5M2GqOQlcSRC69BK3alUyF5wBKC7WGK-tk_Ej64r9a79uKq1jj5zXkDAFHhwIz3VMRkfZlzmGmsGCnkKwdCOo6BGY3Mt3xZrs7Nmx-X2w/s1600/20200219_AI+2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYF10D-5KpmHUhsGE80x8qrKdKkY-xl5M2GqOQlcSRC69BK3alUyF5wBKC7WGK-tk_Ej64r9a79uKq1jj5zXkDAFHhwIz3VMRkfZlzmGmsGCnkKwdCOo6BGY3Mt3xZrs7Nmx-X2w/s400/20200219_AI+2.jpg" width="400" /></a></div>
<br />
<br />
<br />
<br /></div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-85914092246319253082020-02-18T22:31:00.000+13:002020-02-19T22:51:47.125+13:00Difinity 2020 Day 1<div dir="ltr" style="text-align: left;" trbidi="on">
Difinity2020 Day 1 was an amazing day at Cordis. It started with Reza introducing the conference followed by the Keynote Power Platform demos by Charles Sterling, Ken Puls, Leila Etaati, John Liu, Heidi Hastings.<br />
<br />
Highlight of the sessions that I attended was <a href="https://difinity2020.sched.com/event/ZPPY/getting-hands-on-with-microsoft-power-virtual-agent?iframe=no&w=100%&sidebar=yes&bg=no">Getting-hands-on-with-microsoft-power-virtual-agents</a> By Charles Sterling<br />
<br />
In this session all the attendees got to build a #lowcode bot and publish it within 30 min.<br />
<br />
I had an opportunity to present my session <a href="https://difinity2020.sched.com/event/ZPOp/build-your-first-model-with-azure-machine-learning-services?iframe=no&w=100%&sidebar=yes&bg=no">Build-your-first-model-with-azure-machine-learning-services</a> The audience were very responsive to my questions and I am confident that they learnt how to build a Linear Regressoin Model in the 45 min. session.<br />
<br />
Thanks Charles Sterling for providing the gifts for my most interactive participants.<br />
<br />
I am also thankful to <a href="https://www.linkedin.com/in/ravit-jain-04647b99/" target="_blank">Ravit Jain</a> of @Packt Publication for providing me with the books titled '<b><a href="https://www.amazon.com/Crash-Course-hands-introduction-reinforcement-dp-1838645357/dp/1838645357?" target="_blank">AI Carsh Course</a>'</b> written by <a href="https://www.linkedin.com/in/hadelin-de-ponteves-1425ba5b/">Hadelin-de-ponteves</a> to be given to 4 attendees. This book is really good for those who are starting to understand what Artificial Intelligence is and would like to know about it.<br />
<br />
Thanks Ginger Grant, Anupama Natarajan and Leila Etaati for your help with my demo.<br />
<br />
Thanks to Reza and Leila for organising this event and also to all the volunteers who have helped in this event. Some of the photos of my session below<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMt2uZlksGT1iV5SnAD93Nz9eJTeTaunwBzCHS5RmnOGUJ9J5Ggxf3PnCthDHXZVfKBEqxpav6uzyNIwBRbgevmKwEGTGD1JB_Hxs0OGeMSvRY43VAFcJUAJYs1i0YWqck-C3iQQ/s1600/IMG-20200218-Day1+02.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="900" data-original-width="1600" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMt2uZlksGT1iV5SnAD93Nz9eJTeTaunwBzCHS5RmnOGUJ9J5Ggxf3PnCthDHXZVfKBEqxpav6uzyNIwBRbgevmKwEGTGD1JB_Hxs0OGeMSvRY43VAFcJUAJYs1i0YWqck-C3iQQ/s400/IMG-20200218-Day1+02.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKI9a5SfCu7cQ5ZsZsXsKZPU3qD9XRziklkxdVQuXBwyHyTrJgf7DBSO5drcix50rWJv5PCFP9uvm8L8eGdAxb_yVA0RESdl4jFMBc4yzYSRos5wA9LWLG2L_IwDjvF_I8vnIH9g/s1600/IMG-20200218-Day1+11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1600" data-original-width="900" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKI9a5SfCu7cQ5ZsZsXsKZPU3qD9XRziklkxdVQuXBwyHyTrJgf7DBSO5drcix50rWJv5PCFP9uvm8L8eGdAxb_yVA0RESdl4jFMBc4yzYSRos5wA9LWLG2L_IwDjvF_I8vnIH9g/s400/IMG-20200218-Day1+11.jpg" width="225" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9CL28-LGphM-ubX6Mnjd_dfEm5rcYIYsFV6E6BOFwhTVrqLgaCCqJ2uqmCZ-QeTQkukqc42jcqsDpeyHcM8x6XbK8bnK6zvkS5AW1d27ADpx6IfJtOtiQj5gpil4g0WHSwBUFRw/s1600/IMG-20200218-Day1+34.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1600" data-original-width="900" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9CL28-LGphM-ubX6Mnjd_dfEm5rcYIYsFV6E6BOFwhTVrqLgaCCqJ2uqmCZ-QeTQkukqc42jcqsDpeyHcM8x6XbK8bnK6zvkS5AW1d27ADpx6IfJtOtiQj5gpil4g0WHSwBUFRw/s400/IMG-20200218-Day1+34.jpg" width="225" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSWF5y68Q5ADU3yG3tARRsZKoo4qQr8Qf2nuRazzdW9qRRCDUOtLdlmo-2-XwzOM6kjR-iPZ9sWFbBgFf3N2bi71Gbc34t8NYu1a09FU37R86t77wW6qSAZ3Gr58yLwBMg6_60HQ/s1600/IMG-20200218-Day+1+05.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="900" data-original-width="1600" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSWF5y68Q5ADU3yG3tARRsZKoo4qQr8Qf2nuRazzdW9qRRCDUOtLdlmo-2-XwzOM6kjR-iPZ9sWFbBgFf3N2bi71Gbc34t8NYu1a09FU37R86t77wW6qSAZ3Gr58yLwBMg6_60HQ/s400/IMG-20200218-Day+1+05.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmqm9lww_q2L0H8rBF5lf2ByLI0bUXOE2YfskVMXWNikgRI9UXTfsX9VlXj4TVRcTCLOhWfqeurPYUD30kEJqDmculD951abhux12nIJVKRyZH-v0d51IudArGtpKB5w1c7P9e4Q/s1600/IMG-20200218-Day+1+29.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="900" data-original-width="1600" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmqm9lww_q2L0H8rBF5lf2ByLI0bUXOE2YfskVMXWNikgRI9UXTfsX9VlXj4TVRcTCLOhWfqeurPYUD30kEJqDmculD951abhux12nIJVKRyZH-v0d51IudArGtpKB5w1c7P9e4Q/s400/IMG-20200218-Day+1+29.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_F7svVkE6CduK6ibyviA6GTRRqyB-TRKX2nNes8kNsvZc2Zf1KsQijI0TjhqOGqtk98eOt038iBz612pAjkNxjx9DIq-_oTeaZVn76vdyYXaB_eY2N0Qco7sJJzQ7iMhI8Xxl0g/s1600/IMG-20200218-Day+119.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1600" data-original-width="900" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_F7svVkE6CduK6ibyviA6GTRRqyB-TRKX2nNes8kNsvZc2Zf1KsQijI0TjhqOGqtk98eOt038iBz612pAjkNxjx9DIq-_oTeaZVn76vdyYXaB_eY2N0Qco7sJJzQ7iMhI8Xxl0g/s400/IMG-20200218-Day+119.jpg" width="225" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJe6zPvtGuSnTRtEUZPueAtrKJ47gHSV59y3I9cb52kqCxJDjN-GrUpq1U4yQozPVj_26PcsNOus7VCtTn0g2dUAWMTcE4hNbUhG0SF2_dMYqRx-6ULsF9MOjprVty6wz_6vJvVw/s1600/IMG-20200218-Day+130.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1600" data-original-width="900" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJe6zPvtGuSnTRtEUZPueAtrKJ47gHSV59y3I9cb52kqCxJDjN-GrUpq1U4yQozPVj_26PcsNOus7VCtTn0g2dUAWMTcE4hNbUhG0SF2_dMYqRx-6ULsF9MOjprVty6wz_6vJvVw/s400/IMG-20200218-Day+130.jpg" width="225" /></a></div>
<br />
<br />
<br /></div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com9tag:blogger.com,1999:blog-22369393.post-53849205571858718182020-02-15T22:40:00.000+13:002020-02-18T22:41:00.512+13:00MSIgnite The Tour Sydney Day 2<div dir="ltr" style="text-align: left;" trbidi="on">
I really enjoyed being at the Expert Connect sessions on Day 2 of at #MSIgnitethetour<br />
<br />
There were questions about the #Microsoft Azure Starter Pack,<br />
<br />
Some questions from Property NSW regarding how to automate the scanning of the property legal documents into some sort of a database.<br />
<br />
Another question was about using Microsoft Forms with Power BI<br />
<br />
I also had a very detailed session with Pepe fro cushman and Wakefield regarding how to do a rolling 12 month graph.<br />
<br />
Overall enjoyed being there at #MSIgnitethetour and learned a lot of new things.<br />
<br />
<br /></div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-13915309756265324662020-02-14T19:24:00.000+13:002020-02-20T09:23:49.421+13:00MSIgnite The Tour Sydney Day 1<div dir="ltr" style="text-align: left;" trbidi="on">
I really enjoyed presenting at MSIgnite The Tour Sydney event on Day 1. I presented two sessions as below :<br />
<br />
<b>Session 1:</b><br />
<br />
<b>What will kids teach us when they start loving data</b><br />
<br />
In this session I have shared my learnings from helping kids to learn about databases and data visualisations. It was amazing to see 590 people register for this theatre session. I was overwhelmed by the response of the people after the session. More than 10 people lined up with a lot of questions. Thanks to all those who have asked questions.<br />
<br />
<br />
<b>Session 2</b><br />
<br />
<b>Top 5 tips for Azure Cognitive services</b><br />
<br />
In this session I have covered the tips around how to test the text analytics and the qnamaker APIs created in Azure Portal using Postman for Key Phrases Language detection and sentiment analysis.<br />
I have als0 covered how to extract text from images using OCR using Azure cloudshell.<br />
Altogether about 640 attendees have registered to attend.<br />
<br />
It was overall a unique experience. Thanks Shiva Ford for this opportunity.<br />
<br />
Special thanks to Sudhir Rawat for his help on getting my demos for the Language detection and qnamaker work just an hour before my session.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh00NQ1S6zIyX1LMKustEleEPWu3RDtNcjN6dXZKRogmaHshLlUzpwfSAz78eIpAqyhh2Jt-sPV5suXSJSQo8cpGIT9mVaMltn7LLHLpNACdPPMRlMtKOWEZtoJhW6YlRIjCQ_Qfg/s1600/ana+chu.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="900" data-original-width="1600" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh00NQ1S6zIyX1LMKustEleEPWu3RDtNcjN6dXZKRogmaHshLlUzpwfSAz78eIpAqyhh2Jt-sPV5suXSJSQo8cpGIT9mVaMltn7LLHLpNACdPPMRlMtKOWEZtoJhW6YlRIjCQ_Qfg/s400/ana+chu.png" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYcEBU_fCvt1k-t9VXzmBrxxnoqblscdjT0WIK0iaBgt9mbypW_MHbL27M9MVaqKWqLBD0njdtS4ePFyAb2Ms2jtrnb5LMNlOXYEk4pT_Sjwkg85uuNglos6KnhCDRs1a77eUdSw/s1600/20200213_120251.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="778" data-original-width="1600" height="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYcEBU_fCvt1k-t9VXzmBrxxnoqblscdjT0WIK0iaBgt9mbypW_MHbL27M9MVaqKWqLBD0njdtS4ePFyAb2Ms2jtrnb5LMNlOXYEk4pT_Sjwkg85uuNglos6KnhCDRs1a77eUdSw/s400/20200213_120251.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOcw-9ayAnapCzY_v_-LDI872x5FaoqA-ZbNPzcnRAPFs1D5vUEBIxfy56kYNSk-PgpyW5QyrSwF5WPKPnIe1wrzrez4qZvSa_-_R10fs9nWdojDaQAeXLcyW58xN5TDGU0zah8g/s1600/20200213_143542.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="778" data-original-width="1600" height="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOcw-9ayAnapCzY_v_-LDI872x5FaoqA-ZbNPzcnRAPFs1D5vUEBIxfy56kYNSk-PgpyW5QyrSwF5WPKPnIe1wrzrez4qZvSa_-_R10fs9nWdojDaQAeXLcyW58xN5TDGU0zah8g/s400/20200213_143542.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiI37yOtVVbR0iVvGAOzdg2q31JdMBZwIGA5J-gdhNfG_Q6ZReS0SEQSqoMESrTidavQl4hGllTPknCal09bm5Gho7qWQ1V9pcmuQ_xHr8YFfKWxtQlamMoQ8waLC3Nrp6y8oDvpA/s1600/20200213_115545.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="778" data-original-width="1600" height="193" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiI37yOtVVbR0iVvGAOzdg2q31JdMBZwIGA5J-gdhNfG_Q6ZReS0SEQSqoMESrTidavQl4hGllTPknCal09bm5Gho7qWQ1V9pcmuQ_xHr8YFfKWxtQlamMoQ8waLC3Nrp6y8oDvpA/s400/20200213_115545.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKG-afqIzcDewniZqekMC-XNyaBJRkXLPxVvjdsZzUmt5wtZ1ESqE3OygNyqWNfEVRxhesrW3P4ZH4uiX4zTW9jELOtq-0C99UDlAVUQJ7TAfcRrklnet0tuEjl5z3AWPghDQ5Lw/s1600/20200213_111616.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKG-afqIzcDewniZqekMC-XNyaBJRkXLPxVvjdsZzUmt5wtZ1ESqE3OygNyqWNfEVRxhesrW3P4ZH4uiX4zTW9jELOtq-0C99UDlAVUQJ7TAfcRrklnet0tuEjl5z3AWPghDQ5Lw/s400/20200213_111616.jpg" width="400" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMDWefJxppbXOJJQIKCFJZh6rdrOIPbBuTTmTidjfPICsMqX13OTyXuvrD1oUxvBBMm8NhvFSX_PaalfzreYBP3JNrM_oWp45jLjONEtScDs0cl8H9oaREGx6PkqGquZE0OXU3Hg/s1600/20200213_085211.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1600" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhMDWefJxppbXOJJQIKCFJZh6rdrOIPbBuTTmTidjfPICsMqX13OTyXuvrD1oUxvBBMm8NhvFSX_PaalfzreYBP3JNrM_oWp45jLjONEtScDs0cl8H9oaREGx6PkqGquZE0OXU3Hg/s400/20200213_085211.jpg" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
<br /></div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-58488937729782774522020-01-09T23:09:00.000+13:002020-01-09T23:09:33.065+13:00Video of my webinar "Webscraping in Power BI"<div dir="ltr" style="text-align: left;" trbidi="on">
The video of my webinar on "Webscraping in PowerBI" is now available on Microsoft Power BI youtube channel.<br />
<br />
Here is the link for the same<br />
<br />
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/YcdqYCWIozE" width="560"></iframe>
<br />
The presentation materials are at the below link.<br />
<br />
<a href="https://github.com/indupriya9/webscraping">https://github.com/indupriya9/webscraping</a><br />
<br />
<br /></div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com3tag:blogger.com,1999:blog-22369393.post-82296964755000478272020-01-02T17:10:00.000+13:002020-01-07T23:37:06.081+13:00A review of the book "The Art of CRM By Max Fatouretchi"<div dir="ltr" style="text-align: left;" trbidi="on">
Are you thinking of starting a new CRM Project ?<br />
Are you thinking of upgrading your CRM ?<br />
Are you thinking of just learning what lies in a CRM ?<br />
Are you planning to architect any CRM solutions ?<br />
<br />
If the answer to any of the above is "YES", then read on ...<br />
<br />
This is a review on the book titled .... "The Art of CRM by Max Fatouretchi "<br />
<br />
In this book Max starts off explaining what the key ingredients are for a successful CRM design and he says that there is no single method that can be used in all CRM projects.<br />
<br />
Then he goes on and explains how critical it is to know your customer and build a strong 360-degree client view, to enable the customer to improve their product offering and untimely improve their operational costs and revenue.<br />
<br />
He also emphasises that the the CRM design that you conceptualise should reflect both the present and future architectural approach you take towards your processes, applications, data, security and deployment decisions that in turn are driven by business requirement.<br />
<br />
Based on his vast experience, he also outlined that the Agile methodology has proved to be best suited for modern CRM projects with the technological advances such as AI, Big data and Machine Learning.<br />
<br />
He has neatly explained with the case studies and use case examples that AI in combination with CRM processes will improve customer experience and business insights.<br />
<br />
In the last chapter, he concluded that the future of CRM will be more like a Lego Model -- consisting of colourful, interlocking, functional modules accompanying an array of gears, connectors and other services that are well integrated.<br />
<br />
If you would like to implement a successful cost-effective CRM platform, then I definitely recommend to read this book<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYq2PhF7uVevHFXQOi9L1kJoeOd9C2ZNZMBOqyXjgQ1ua5Bzt2d4l2LLSpp9CfdJt4qR5xPZ27gijRGPXQ5oaxloPb02mPyDK8IaEhVt95UC6RaHnwt2t3C_hl7WspSVcmYKxpnA/s1600/art+of+crm.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="855" data-original-width="644" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYq2PhF7uVevHFXQOi9L1kJoeOd9C2ZNZMBOqyXjgQ1ua5Bzt2d4l2LLSpp9CfdJt4qR5xPZ27gijRGPXQ5oaxloPb02mPyDK8IaEhVt95UC6RaHnwt2t3C_hl7WspSVcmYKxpnA/s320/art+of+crm.JPG" width="241" /></a></div>
<br /></div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0tag:blogger.com,1999:blog-22369393.post-87914498918962998642019-12-15T17:42:00.000+13:002020-01-07T17:48:09.480+13:00Video recording of my session at the Global AI Bootcamp Dec 2019 <div dir="ltr" style="text-align: left;" trbidi="on">
I presented a session at the Global AI Bootcamp in Auckland on "Creating Real Time Image Classifiers" -- Custom Vision vs. Computer Vision<br />
<br />
The video of my presentation is <a href="https://youtu.be/8O-G17xRVE8" target="_blank">here</a>. Thanks to <a href="https://www.linkedin.com/in/jonathanjng" target="_blank">Jonathan Ng</a> for recording this.<br />
<div>
<br /></div>
<div>
<iframe allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen="" frameborder="0" height="315" src="https://www.youtube.com/embed/8O-G17xRVE8" width="560"></iframe>
</div>
</div>
Indira Bandarihttp://www.blogger.com/profile/07515677675693533670noreply@blogger.com0