How to develop in Tableau and PowerBI
Tags: analytics, analyzer, deepsee, programming
Published: 2023-01-21 21:27:09

<h1 style="line-height:1.38; margin-top:27px; margin-bottom:8px">
  <span style="font-size:18pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Power BI</span></span></span></span></span></span>
</h1>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Connecting to a Data Source</span></span></span></span></span></span>
</h2>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">To connect to AtScale, we will use the SQL Server Analysis Services database. Let's open it in the Power Query editor. To do that, select </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Transform Data</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> on the </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Home.</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> </span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:99px"><img src="https://lh6.googleusercontent.com/Vkc8EYSF6TL-zDPjFUmorCZcDNrmPdz3AALJi8yFd3MQtT6rgxmjE1XNpa2G-dkGhIWfhwFR6AhuRoB3nYvqrcvqLav8vx_AOjJpMcRPhB0oHIkLIzSAG7ezuWqtASUOIv1LKA04yNDF5v-tKzxV_l5NNBHXCNAnGdYKIohQq_r7CCnGP9l40aK_czlAFw" /></span></span></span></span></span></span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In the window that appears, go to the </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Home, </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">expand </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">New Source </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">and select </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Analysis Services.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:537px"><img src="https://lh6.googleusercontent.com/AMV0YBz78U1bM7DqO0dTwu17Q5M7t8XKtWlKd604vap0VP7pWkk0YtfoIQXQm3yzu1Lz-mxLojoVbpm8g9B2x0OPAW6hxRPfnGi9v0xJV6uVM2GSjp_Jyk0BpzLCIP3fS76kH-FzS8Xmzuve39ffVEWHC0hMgp0Wq-ZiL9Dv87ejaROnlOY1tEyERBW0FA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <!--break-->
  
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In the Server line, you need to specify the MDX link to the published project in AtScale. You can also immediately indicate the name of the project in the Database line if you wish to.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:273px"><img src="https://lh6.googleusercontent.com/v_AI5j3Oce1P4HTuixpbAo3TTtf1z2pXVeoCeNW3SNTsB_LDr7-nWDbv9grL4dNouPMR9vLGldDQ4FA6-8ITLvWz-m3pbh6_oMTopM4CLwASu67EG0OBXUC90MZoCNZyei_fcRg8MMAXUCg0V0c-9rlHgIhod717PwKhkr9zWaRR0d_zeM3O8m0Ww8OZYw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:148px"><img src="https://lh6.googleusercontent.com/OVszwQu96KS9V8ebju3ya535QF89nkYoBwquQe28wHHPcxHYz__MUQ9zm-8eJljAYFH64qJdAPkYn6IZtHB7bMij1LQ199HzK8ySPz5LqgnVwzmyvoMt1EjPzX90JDsypShRG78zH_bw0yC0GMaAT-8T2ciNoZvjYgy98nPBCwNvuHH5Jt9EL266vPT9Cw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Next, you need to select the </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Basic </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">type of authorization and specify the login/password from AtScale.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:581px"><span style="height:236px"><img src="https://lh5.googleusercontent.com/bTAj_zhxISeW6cMsNtXJLyLBUseRE7ylZh8Kc9iLgNRQlF9ta3b5f5WtXjimbPCxEc87iiT6UnlDgG__dW5q9HaXmYv_F5Z9p4jYBuQlGwws9U1DPXwH2wnJCjNJWxGXUYlEjkXasPObcCg7upPcjspfB15Wunlw-LuR-sV8RcXdWLrZx_kyhVEcunrgZA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In the </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Navigator</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">, you need to specify the necessary measures and dimensions (keep in mind that if there is no connection between the fields, you will not be able to build a correct query). It is also a good idea to split the cube into several tables, depending on the task. It will help you improve performance and avoid errors.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:581px"><span style="height:461px"><img src="https://lh5.googleusercontent.com/e-ra5db8seZvDSCbocgOD_Ym9QdecI76AQeGq7AFPiC2IYq1eqOpeBfqXzakXUu7MxLKL0Ujl7ROTa6Z6PEQlPppAQWvhAqIUvJp-ebs5-DpMnRonKbzAlinzupjfQVB4w2YJHIShTkVw5Md8C6eHZuG-rtVS0keo9BaklPjo-nX_8ysEFnU8h4fsO7ibw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">In order to set up automatic updates, you must use Power BI Gateway and Windows authorization. In this article, we will skip these steps. </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">However, you can read more about this subject in </span></span></span></span></span></span><a href="https://documentation.atscale.com/"><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#1155cc"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:underline"><span style="text-decoration-skip-ink:none">the AtScale documentation</span></span></span></span></span></span></span></a><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Features of creating queries in Power Query.</span></span></span></span></span></span>
</h2>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">After adding columns, you can make changes to the table (modify the column name, data type, add/change columns, replace values, etc.). </span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">For instance, you can alter the name of a column. To do this, double-click on the column name. It is advisable to make sure that there are no blank fields in the numeric values. All empty values ​​must be marked as </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">null</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">. If you have vacant fields, just override the field type. To make it happen, click on the type icon to the left of the column name and pick the required type.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:243px"><span style="height:161px"><img src="https://lh5.googleusercontent.com/dN7MH-S27n0iktPmVes8IRA6w84zti4jlpxDEkCAAfELMc6XnwPY0SwCq7FRxVKVUtRsFQHmYvjlgIgvKbxt7scl7yyeLkO6gtZqF2sTpCK1YOjeZmCtUkPQrosCuDNz5KkPQ_3qb0oxMbt-ai4IYQPn6FLqFOjCjAm_GQDu2Ihq93m_NvfWVyhXepXDcQ" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Power Query may not correctly identify the data type. In this example, it incorrectly recognized the date format.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:343px"><span style="height:300px"><img src="https://lh4.googleusercontent.com/8oVCbqAXaUTzy6pg5QoN_V0G-N8Cw-jnwHvG1XGoGEgC6BoRGZ9FT5qeM2mOLhzBBkOjhuXGUMPVOCqNNuSXPOD7GaqLA6K2UXhPC9e5-RmMBDEmmCRcF735G9wDL9qYm4eYW5muDBAve7okJL1JScDqV50wXvIBGONyHbEDu_DlOQSfLDH_DnnZQeGgjQ" /></span></span></span></span></span></span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">To fix this, we appoint a specific date format. To do that, click on the icon</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"> </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">data type, </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Use Locale…</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:307px"><span style="height:402px"><img src="https://lh3.googleusercontent.com/ge27bcnSCCqIHmImzvqGGRxbA9jEGmm8TgqxA0K0w-bYJCFzV5IkyOnD_ebF0n5VEHebUhwEN_2-cB-A2CVIAwBsE4G7IoYM64gDDmwaKkzprHL2eug-GpBeZRZMlLAdpUavZ5KVZYHzcn7XXbekibDqUMGybWPfQ93A-8I1eaRgweIzXgVwsHl_BCKlJw" /></span></span></span></span></span></span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In our case, we'll pick the </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Date </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">and the English (United States) locale.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:321px"><img src="https://lh5.googleusercontent.com/BHg2gGPWp_7tbCE1bYA3GCTOn8HBQJ9425Gmj05KfyiSN9qDDqdINGGqlfw8_EczmdDjWHDiTDnKZxhLYsduTm6r41XVa5LLneicm73_yJzhSRwo-RG7xWahOpPoY6TJb2QEDhCKYa-4emD_c3Suv2ZrzkCux70ZLZzTmMktuxr4udEqJtQrbYstnsXOrA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Now the date is displayed correctly.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:340px"><span style="height:291px"><img src="https://lh4.googleusercontent.com/6DGac1dL-Mn32ZpDZlNVvfzrZEwlEL87KF5EXfZjLMAMltj6tfUxhHXE5Ib-5KNSZO8jooBRWXDKrG3pkzMOBHUNjRalbr_wa61JNCKn5skw6X5uewkPhsomHYVSnH1Hg_8cJCHJbvFnuPsFWOA4RRd4ZbsBbS9iQ46MN88as1PnbkGNd_JiyKKhuB7jUw" /></span></span></span></span></span></span></span></span></span></span></span><br /><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">You can learn more about working in Power Query from the </span></span></span></span></span></span><a href="https://learn.microsoft.com/en-us/power-query/"><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#1155cc"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:underline"><span style="text-decoration-skip-ink:none">official documentation</span></span></span></span></span></span></span></a><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Working in Power BI and creating visualizations.</span></span></span></span></span></span>
</h2>

<h3 style="line-height:1.38; margin-top:21px; margin-bottom:5px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#434343"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Creating a date table using DAX functions. </span></span></span></span></span></span>
</h3>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In order for our tables to be related by date, we will create a calendar based on the available dates using the built-in DAX language.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">One way to create a date table is to use the built-in DAX function recommended, as there may be extra start or end dates, such as employee birthdays, so it's better to set them manually in the </span></span></span></span></span></span><a href="https://docs.microsoft.com/ru-ru/dax/calendar-function-dax"><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#1155cc"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:underline"><span style="text-decoration-skip-ink:none">CALENDAR</span></span></span></span></span></span></span></a><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">. These functions return all days between the minimum and maximum dates. </span></span></span></span></span></span><br /><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:193px"><img src="https://lh6.googleusercontent.com/G_ydeWQ9yzgvR7-WdhoX2bj15WaqonJwuvkOPpe0Q4nemqQXpbWglyh9MuCiavFtnvgqgC0CWDJPAuABu_ROdyWv4jupAssxO4nkcblDMR2JZ2vzOM2IkLpkLmHw536O08N3Q14zBIHuZS-ZPgWurjvAaDsCwIf6s40ysNOZEGi1T96sko895FhAdyEkpw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.8; background-color:#fffffe">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Calendar = </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#3165bb"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">CALENDAR</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">(</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#3165bb"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">&lt;start_date></span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">, </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#3165bb"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">&lt;end_date></span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">))</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Now let's add a column with the year and the name of the desired name of the month. You can use a date hierarchy to get the year and the name of the month. On the </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Column Tools</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">, click the </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">New Column </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">button and write the formula.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Month = 'Calendar'[Date]</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#09885a"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">[Year]</span></span></span></span></span></span><br /><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:92px"><img src="https://lh5.googleusercontent.com/4uafatTdSNvUpW8tu7qSk27ZUOYscybppob0s0_34tMVRrX0bycQ2UhN_8L5OJnSjqMj6XH3E_dSvIkecJZekd0Z6jm69KSHS53H_Q43VOXpg7dkdWQg8xLmVrsOKWumebSoAFaXP_ndewsYWNzgqHvn7a9E-dhTAmcokSM74f_vR6Q1CDwWFaHHpK3vtg" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In DAX, the formula is preceded by the column name. The </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">= </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">denotes the beginning of a formula. Then the formula itself is written. In our case, we simply take the </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">[Year] </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">from the calendar date. It is always </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">recommended to write the table name</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">, but you can just write [Date].[Year]. Power BI will refer to the existing Date column inside the table.</span></span></span></span></span></span><br /><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Let's add a column in the format (MMM-YYYY). To do this, we will write the </span></span></span></span></span></span><a href="https://learn.microsoft.com/en-us/dax/format-function-dax"><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#1155cc"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:underline"><span style="text-decoration-skip-ink:none">FORMAT </span></span></span></span></span></span></span></a><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">function.</span></span></span></span></span></span><br /><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Month-Year = </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#3165bb"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">FORMAT</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">(</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#001080"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">'Calendar'[Date]</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">, </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#a31515"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">"MMM-YYYY"</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">).</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">However, since the Month and Month-Year fields are text fields, they will be sorted alphabetically. Let's create columns for correct sorting: MonthNum with the numeric value of the month for the Month column, and MonthYearNum for the Month-Year column. </span></span></span></span></span></span>
</p>

<p style="line-height:1.8; background-color:#fffffe">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">MonthYearNum = </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#3165bb"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">FORMAT</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">(</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#001080"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">'Calendar'[Date]</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">, </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#a31515"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">"YYYYMM"</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">)</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Now we need to set the sort column. Go to </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Column Tools </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">select </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Sort by </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">and select the required column. Let's carry out the same manipulation for the rest of the columns with text fields. </span></span></span></span></span></span>
</p>

<p style="line-height:1.8; background-color:#fffffe">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style='font-family:"Courier New"'><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:208px"><img src="https://lh6.googleusercontent.com/xyo0RNZ80B91fGn2LNlh5nBqvTbsYAKA2Yx-WROfKP4tyOSV1QLc-EuglTBevn1kqLseAKd22fWYmEKTKW44XU4cQVN2MGPbmWulIOi-aN7SUNsn5QRdjQLSecDYbMII1Kg2Usg54OQlyvJwlb2zROA16dEVDUNZUD6xpuGRuZ8qUzcy3odabvYjxFcFEA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.8; background-color:#fffffe">
   
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">To better understand DAX formulas, you can take </span></span></span></span></span></span><a href="https://learn.microsoft.com/en-us/training/paths/dax-power-bi/"><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#1155cc"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:underline"><span style="text-decoration-skip-ink:none">lessons on the official website of Microsoft</span></span></span></span></span></span></span></a><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<h3 style="line-height:1.38; margin-top:21px; margin-bottom:5px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#434343"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Managing Data</span></span></span></span></span></span>
</h3>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Model view</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> in Power BI Desktop allows you to define the relationship between tables or items visually. In this case, two or more tables will be linked because they contain related data. It allows users to access related data across multiple tables. In the Model view, you can see a schematic representation of the data.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:181px"><span style="height:227px"><img src="https://lh6.googleusercontent.com/b7xasN8u5gKs2-n9-gKRoSUlnHny4YrEZbp_CpnZt1txH8EEmp6Fd-jlRnVH6ocrUTpnbvG10WID5jgEBxBs8r9xb9J2JJfGVg-qVXaOGdoDIOvZTBdPP5EcW3ok8E9p8rmcUGNRUhqLkFRKViNj4PL3UbeSgvTJiCVokTfWJvhAVIQxt37eN5h7HiU7nw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Adding and removing links is very easy. To </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">create a </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">link, </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">drag </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">the fields you want to a link between tables. To </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">remove </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">a link, </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">right-click</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> and select </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Delete</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:271px"><img src="https://lh3.googleusercontent.com/Peq_jA39XsRLvOVkru4WsqaaesnPLXCnm4g_NJ3ZReZeAYZoazpHf7Pwm9Favrj9UBAEWOGxUwtJiCWU2YEFRE8p6HsqA9_qbZk9ynKII1zTM-WHfBF7wyFHFlGaSXJjY7v0FZbVb3dJahYqdsygeeX7FHqjA5SFvg9ohRwwiR21yQBSdAtQ5AQLLeGvgw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:276px"><img src="https://lh5.googleusercontent.com/amoo1uOIJnU7evF94VbxmqQX_80Rk6d15eFsiqUUW6vcgS_YdMBAQsBbwEQ1132e91VAo6mPOVm4u9s-ZhljQSqDUCrCQurkk0fp-yEVACfi825Rk_9k2Pcsi4U_xo2D919OwWRJcpeHPCL_me25d4Z08S9FPDhYxmtKPpVhgQHA1MOTDW3Pmhn1OcAepw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">For a more detailed understanding of Data Links, on the </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Home </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">go to </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Manage relationships</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">. Dialog box </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Manage</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> displays links as a list rather than a visual diagram. In this dialog box, you can select </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Autodiscover </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">to find relationships between new or updated data. Pick </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Edit </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">to manually modify links. The edit section contains additional parameters that allow you to set the </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:italic"><span style="text-decoration:none">multiplicity </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">and direction </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:italic"><span style="text-decoration:none">of cross-filtering</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> for links.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38; text-align:center">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:344px"><img src="https://lh3.googleusercontent.com/ZYcZJ2LAQSRU_U6s_YapVZ-SymfdgD4AnU-3CApq-FLYXnL-XgDhZGh2uKNri8E4F8usbeeyzgg1gdikMmxBqpU0KysOeuJLHY42MKFoMHtqVqCY7OzogtRERCU_uXBlz8l3V6R4JvsFqYKnk2cKCgomnJDNA_0swbzCd-IldbKLC0t0vtbLJnjBr90tkw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Your options for Cardinality are explained in the following table.</span></span></span></span></span></span>
</p>

|Cardinality Options|Example|
|----------------|----------|
|Many to One|The most common default relationship. A column in the same table can have more than one instance of a value. The associated table (or lookup table) has only one instance of the value.|
|One to One|A column in one table has only one instance of a particular value, and another related table has only one instance of a particular value.|

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Generally, we recommend minimizing the use of bi-directional relationships. They can have a negative impact on model query performance, and possibly deliver confusing experiences for your report users.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Setting accurate relationships between your data allows you to create complex calculations across multiple data elements.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">More information about data models can be viewed </span></span></span></span></span></span><a href="https://docs.microsoft.com/ru-ru/learn/modules/design-model-power-bi/1-introduction"><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#1155cc"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:underline"><span style="text-decoration-skip-ink:none">here</span></span></span></span></span></span></span></a><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<h3 style="line-height:1.38; margin-top:21px; margin-bottom:5px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#434343"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Slicers</span></span></span></span></span></span>
</h3>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">A simple filter that can be used directly on a report page is called a slicer. Slicers provide hints on how you can filter results in visuals on a report page. There are different types of slicers: numeric, by category, and by date. Slicers help you effortessly filter all the visuals on a page at once.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:445px"><span style="height:158px"><img src="https://lh5.googleusercontent.com/6hw9BqonR5cuMTiekRamXiSx3x772B0uam9c21DPYwp5CrnXxVdnnQDMhtiVW9tjRlgdVeUo31gnexBMPvuWbj22CGN62oWdc1mHitWxCwkza-IkCxuI666jgcL9sn-Tv3879vUHuft0_16oRwNMU5SYpWeU3xkgdQltzzJpQpzM8ddbxQ087ny3A4ArHQ" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:italic"><span style="text-decoration:none">This GIF shows the work of a standard slice. You can set up </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:italic"><span style="text-decoration:none">multiple selections</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:italic"><span style="text-decoration:none"> in order to select various options </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:italic"><span style="text-decoration:none">without Ctrl.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">To do this, </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">select </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">slicer; then in the </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Visualizations </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">panel choose the</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"> Format visual </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">tab; open  </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Selection, </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">and toggle </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Multiple selection </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">pick</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"> Ctrl</span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:italic"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:301px"><span style="height:260px"><img src="https://lh4.googleusercontent.com/8jKIa-7E2QV0jtb-1Lv3HdLbewxkiu1M8Y2eYJG2Hw5MGWCczJO8i1n_6z5g9VqJMr5mucnQQZ0pDn0jwgKNfsr9rNBR1pam3nV_VWhCUQlZkDtBKh6uIqPxrgVa4YDY6pW_UEU6BBQlZybAYaKgF4byVeb3DGRHdw9Vj4Px44bunJkIb_QfwcDjp6z6CA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">You can also change the appearance of the slicer. To make it happen, pick the down arrow in the upper right corner of the slicer element.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> </span></span></span></span></span></span><span style="font-size:11pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:228px"><span style="height:208px"><img src="https://lh4.googleusercontent.com/DdlOoADJompHMZS_wDWR57lpTP7eXeJMKYxIwosQPpZbi4t4azT0x7Y1Ozbzk6uJK9XVfHnAVdHFWCyjWrzUpA1cdE9BNn8Eb4EXV4NinfWUgQI0KNddSS5G1OC5EZjAor7o5-HnWRF6UbGTbMh-1zOaeFhaHHzXhctDFr6y_2e4mgukW3Zzlwma6YHYXg" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
   
</p>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
   
</h2>

<h3 style="line-height:1.38; margin-top:21px; margin-bottom:5px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#434343"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Adding a Visual Element to a Page</span></span></span></span></span></span>
</h3>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">To add a visual element, select it in the </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Visualizations</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">. </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Let's add a </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Stacked column chart</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:501px"><span style="height:240px"><img src="https://lh6.googleusercontent.com/3ZAlhebFIL5JBN2ew5XeSPgn2-RcNO7nIi9EKSluq7VX8UhzUxrCyVQ6F7-JdnQo4aBURge3EB1mBlADZ4wn064NDPqrOjpzaV3gFpl_4RDIgjFfGUmh5t1k8RJe52HUBx8fjycoruAfPTFHhzxtJpgJOwSTa3FI1S_u9uK4gyhV-eM3M0_gGwO_fwlx8Q" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Now we need to select the fields we want to display. Let's add the Month-Year field from the Calendar and another numeric value from your table.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">We should get something like this.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:419px"><span style="height:195px"><img src="https://lh4.googleusercontent.com/HuLOAUdc74WvYW1-07DGOZQhwDoytymOZ8Q58bj8Z2FKG-LWGrMuAov5MQYhqoX_7Lr5Gj7J-zBFP5n6KYNbLeagWBTyUlPXh93Hj9iOZF5f5vftFVXfKCdbOb5GyPphWjkBn_VRe44JZHVGOBuAKxM-gne6ZdRQiDoiWmlqZtO5WLgbnhv1dTBeBPndYA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In order to truncate the data, we will add a filter by date. Let's extract the Date field from the Calendar and change its visualization type to slicer, then remove the standard hierarchy and use the usual date format. Afterward, we should immediately change the view type to a </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">relative date.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:631px"><span style="height:296px"><img src="https://lh3.googleusercontent.com/oneq1KOdxhwKy7i9r_TgXIvtawlp8DOBbW0ZAY5GiLcT67iGJrWsdcyNVjUW7gNGkeR_rKhmYkdfUyAFtn9xtSyF75EtLo5msLzPgppwXf3BYgogA_5qRg47wFfSolioTgxW3-iuD2RL0HczRT7hxRiZ6n-JcB8d3j_d7F-pwXuEYYLVKvTAUz0unQjiAw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Now we can apply a filter to screen the last 6 months.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:392px"><span style="height:221px"><img src="https://lh4.googleusercontent.com/K_94mf7mt2RteFqT4_XOp868k50ZU2YA7N3xWhjnyxN6rtkeK5MY2gKtviW3CZuxK8XKDXpSGD5HC1HRtq8vQ8TfWJF2WTKL5YnRj6pCCaWgxcJi4lHO8MqRhVn42n450uilcQJNcAT1NLTxf3bTZpNN26Cn8zmxuiTfQ-H6LQ4g0OXOQpsRyzxwPVe05A" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">You can change the view of the visualization on the formatting tab. Each visual element has special parameters. You can read more about it </span></span></span></span></span></span><a href="https://learn.microsoft.com/en-us/power-bi/visuals/service-getting-started-with-color-formatting-and-axis-properties"><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#1155cc"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:underline"><span style="text-decoration-skip-ink:none">here</span></span></span></span></span></span></span></a><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">. </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:315px"><span style="height:384px"><img src="https://lh3.googleusercontent.com/WMJJ07R6IhPCSERXOQFN0edJDRGjj8_ge9Cj1XRbyToFROlPxiS8q1GRbCgIODKzeoznXrI2yvN8xauQ4yg3xQ8s__1tCzN0wuf1_HC-zCJWqiJdGxmyyxsFZGACVO_zQkdrHzySwwexSiNDpVKQsaHTwL4IEQo0mhM0dN4IC_kdfSa1bkH01E_TmHskSg" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">There is also a tab with general options, such as title and background.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:258px"><span style="height:437px"><img src="https://lh3.googleusercontent.com/YUMXFGud2sk0QcdsPTVmCFE34kR-ZtoU5tLPocZE2X8p5KyUaJJ69fv8Gu-J6F2JCoNvWEo-5rdDzatXwODvs0lwTPFoYetBzM6jewX9TFX9JFObJdHCRxgb4a0v944RX0RvG69lmBO0il-eKgfOel8cuBFKnyNeQ5nyPcVQW5eeoz0INX9ZhpqU2tHBGg" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Let's add a few more visualizations and change their look a bit.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:308px"><img src="https://lh5.googleusercontent.com/Zt26yJ_s2fMeRZKuYBqBob3Rq4MjBNj9mY0f2tVVQoXvxV7YqP1HBNkkHmHn4azLQpZDabpvdEIQhSh9PRAbnuODWjK2dREmOCE1UFyiAaEwDzbooQqlOPxYyx9bVEcI7aqmAmwWGVQhC8l-lAE0gSsbZ8zctZeE_nTX3cTSqwFnCsIc8XVChS39UTUIfg" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Now we have a simple dashboard example.</span></span></span></span></span></span>
</p>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Publishing a report in app.powerbi.com</span></span></span></span></span></span>
</h2>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Reports are always published on the portal </span></span></span></span></span></span><a href="https://app.powerbi.com/home"><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#1155cc"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:underline"><span style="text-decoration-skip-ink:none">https://app.powerbi.com/home</span></span></span></span></span></span></span></a><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Therefore, you must have an account and be authorized in Power BI Desktop. </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">To publish, you need to click </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Publish </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">and, if necessary, select a workspace.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:75px"><img src="https://lh5.googleusercontent.com/qvVnonreRY_iw629AkPNHOaj3Ie5-0jM8Iqpl9ZhqdyaVEJCUhicJc30cjroflZ97LqJNcRc8e_d1Ww5EN9nZQB2xo1x5763ZCiwYvrqIbYoqi9AtbjsrAjHaXSelbXLQIgrpWefLeN_m7NvMRS56wvnTmp62luCrwcaU49S4mfyjCaSY7paDXGNGQ3Ewg" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:418px"><span style="height:244px"><img src="https://lh6.googleusercontent.com/5UuaPqxWW-o6DbXw7urijwcJZIXbygTesDuF0C_SBkFxAxB14LxoIG-MAgosRg7CjfYA3M3jMRc07mo0f4Wa-7yGt6x5uHYL29oRaQKs30U4RrXjXs7obJdFl66Rl1yrd2JUDO2HeDeYQZPZ3PMJHboaVmGhFLHAXwEtkwXfBGXy4tyr7RdeORkmr2_0eQ" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">After successful publication, you should visit the portal and find our report.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:151px"><img src="https://lh4.googleusercontent.com/ijMiQ90t0VOB350LtPRO47rzTzr6D1hFhV9l2ZC5Z3z0M4wQYs_SMosyNUhhFQD21KqkkCxR6ZtbfR1KvLPV0hahLxsPT_6FFynYyWr3gk1v33sJUGPp48yiZh6p4ypj84t8ifBTZUgFVCIhtkU3SneVu42il0OMvVoZnSnLqy2fUNxOuQZYt9iyrxZDUg" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Such a report can be adjusted, but restrictions will apply. They are mainly related to the fact that you cannot add new columns or measures. However, this does not prevent you from adding visualizations based on existing columns. </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:292px"><img src="https://lh6.googleusercontent.com/_HAUgNpY82kEST6kqBCU9DLZa4HG8k3p6K_mVjlAbeMoFJxrBKjezobyAoSrK5PPMzjIY2Gdp_SaUCsZE_M48fC1co66CK_ehCmiHWd_ymfqEml_XO5GGqOjeyLem7kHWZM4u8U49tJhmx_Km_Yo5kn2gNoVnk2sBGNf4er_bmnZEgCPSVGgCr_j9lHibg" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">This report is only available to the Power BI users who you have given access to</span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">. In order to share your report with other people, you can </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Publish it to web (public). </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:229px"><span style="height:207px"><img src="https://lh4.googleusercontent.com/CJWPbZvCG8rbYB0hWKgYR1NiGY-qQLssnbYrCKXCgLVb7BFpVvDf-Xo65UGoqXVCZalGWSQKMJAO2bzVBd00Z3OFauqTQN9Ow6CNen_zPMPjSsUMgn27USNzSQ4H-UwS2Rq4G-WrD7pWy0IEHTfu-IsLRbsl85dOeADCfz8v7-JIsCamIXv-EJp0o7VUcA" /></span></span></span></span></span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> </span></span></span></span></span></span>
</p>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Data Refresh</span></span></span></span></span></span>
</h2>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Since we haven't set up the Power BI Gateway, we won't have automatic refresh enabled. You can update the data only manually. To do that, you need to open the report, click on the button </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Refresh, </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">and publish it again</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">. </span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:76px"><img src="https://lh3.googleusercontent.com/xORAw1qqncp18chlAZc5ieDMxmr0XM3GKIT5d0PZGT-SJm1pj5YV6RgY5vIsALkV1NW0YZhw2cTC7hRV_J3unbNaxNkEbeqx34QELl-Ts1QOvkLkCWgyZXk5YrJ7-O-aH14qsAISWuYglFZe9JeCRMOf4pJzr59bOgJe3mUcfO8KhurzHVzvxG3yLPCRWQ" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<h1 style="line-height:1.38; margin-top:27px; margin-bottom:8px">
  <span style="font-size:18pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Tableau</span></span></span></span></span></span>
</h1>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Preliminary preparation.</span></span></span></span></span></span>
</h2>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">You will need to get a driver to connect. We use Cloudera Hive. You can download it from the </span></span></span></span></span></span><a href="https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-1.html"><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#1155cc"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:underline"><span style="text-decoration-skip-ink:none">official website</span></span></span></span></span></span></span></a><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> (registration is required). You need to know the OS and bit depth to choose the best suited version to download. Installation is simple (no explanation required).</span></span></span></span></span></span>
</p>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Connection to cubes.</span></span></span></span></span></span>
</h2>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">To connect a cube to a Tableau report, you should download the connection file. To do that, </span></span></span></span></span></span><span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">select the desired published project on the project page, then go to the connection tab and select the Tableau option.</span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:519px"><span style="height:340px"><img src="https://lh3.googleusercontent.com/GmYPQFwXEceup2G7FUIK9SC78gyzY3kD21Wcv3q4v2xwEV00nEOyIrBuz3MvRO1nAZDaEfSQTJLGbZSSA1SbbsGRRP-PBSBmsX3BO6gstHAjbwy0Sw-wbZbaUBOiWgK1lARWDMbh8QX-h_86k-0avC_OyMsGMDSg84-qggVNTS4lAy7UWIfy5ywaYRloBA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In the window that appears, select DOWNLOAD TDS</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:386px"><span style="height:285px"><img src="https://lh5.googleusercontent.com/6UtgIkxOGyKhTTXhkrP9HvDm9AZyRSTmgve6vxZimMULofXst5Vd50ldhjQOAAgtjMWtM4cmg3vPWmSd-GBUp-COFS-et_WAj0adkpHCy1Udtp0UHO2ftx7oLavLNFkVp9I0tGF-YPZb6otzw83LWfpqFHl14YpfrIu2Yv4sCPd83L6OxqIU8LexZXpBSA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">When starting Tableau, on the menu to the left, select Connect, To a File, and More… from the list and open your .tds file which you downloaded earlier</span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:266px"><span style="height:380px"><img src="https://lh5.googleusercontent.com/1KTyvRLRO2W84x1wX3BQFe9QSvwe4juOjQ7upUEHOCd29YwMtNC0HhnPyzVkjWF4NtKRzmr9rSI_SkqO_Qp59fOuFqJ6A8ZzRmyujvgEFSECqV2V8yAeBRLjwE9SdTihsL2m9fPCZqom2Wzsb9PmH_6Qvev0endLPecPxQXTZwaHxkpvfqkYPvlqeLy69Q" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:314px"><span style="height:328px"><img src="https://lh6.googleusercontent.com/oeCy1Vz8ruGaBNXeQxrRmB-r8_kYDa4C9ZbyAZ5tDiUIj9LSQu5beGN_xKv-i0EZXzCoujp-p0zOPhs3LQ4QMHFyKFyvmz3SD0k6L0CdHAVY9PlxrFeGMiqzUslOvezOP9btQcyqI2jgPauyeneWjNENunWeA8XEzQ8RUU8tCD8f5JOfaraadXEPJl13cg" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Tableau will ask you to enter your AtScale username and password. After successful authorization, your cube will appear in the data sources and allow you to start working.</span></span></span></span></span></span>
</p>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Creating visualizations.</span></span></span></span></span></span>
</h2>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Unlike Power BI, each visual is created on a separate page. </span></span></span></span></span></span><span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">However, you can later group them on the worksheet. Tableau has rows and columns, but the interface depends on where the dimensions and measures are located.</span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:513px"><span style="height:233px"><img src="https://lh4.googleusercontent.com/PbZh38qkikxbXc-379WN6vl5OiJQT1c8l3z_uxqVSWuFqzAAkaQXAEn0dUjQpIP6hrSqe2wSlljqvhGwemebfyL8nY9YwfSRacOzj4lQKwWuIMp_SH8hL4jkEdGH13ujBht79IEFLENHK9Pj2uiIvSURm5ddpFXTP8AscbmkapGcbDxG1dS8qwH3JEA25g" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:717px"><img src="https://lh5.googleusercontent.com/ftTrYON20bw-2ucVjs66SUwu52l030BBpuSe7PXY6CsZ8Gb4uue1jHv3Regfzpzndm6ZHyvC_LM_qIyoea44UKUNwcncX-rz5FtxRvEr3dcn5vTNByJY2e2KHHIL4VzBZgHlCzv297E-WBmuYllEbatk1vaBCbpjd6Lem4H9mXhyY64JEtTxEQ_C8_H1Rw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:212px"><img src="https://lh3.googleusercontent.com/7-N4yx1Tej8KO0-kye8WNuzkTcifX3tokbn_QmWtvoTfVvKZZmm_svqXX-xX-xxbbBPGVMrln73GHMsyVdOEe4IfsOpw2enxfK0W7qgTRH1r2xtR12-blWAshW3UTFFVszatPiDI978CmtYt2UoE7MLdnFyAIKbpabSfG7Eu3ACluVNtzluvvwREUgn_-g" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">To select the type of visualization, you need to click on Show Me in the upper right corner of the screen (when you modify the type of visualization, the location of the selected values ​​may change).</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:411px"><img src="https://lh6.googleusercontent.com/lSkvLvYsj-V3jKQGyoLe3hI8ArL49EdqCxCpZ5ygp8Yg3Ky7KOwfSimw5zx-COzXDXAHFnZop307nJaowVUA1ratNkAeXlOud6g3NLJ9y1Yov3iDp-f7GNEmrS1y-uw2muwcd-95AdvnIcu35yZhnxDF_rJ_rcn34ddmQ5XjxWP_cx0JzPI6qzFzi5NVzA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:361px"><img src="https://lh4.googleusercontent.com/1JucRwi6QgfZz7A33KSXQSdgj4WpgLefhXuBAyPniZSX4cpsi_9ZwD1TIUx5cO9NaXj5I4NNf2-_QiXlJzr8e075KiuRciVtjdZYQ-xyxhUUPxHyufXwxQ4S3TxoSWyjSq_WwpAAL5-mP7xnAmoJ8hOOhrNeIJhw9tV7veRB6jzNYVcM6BCbpFBAlSPV_w" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">The field for filtering data by default is located on the card on the left.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:411px"><img src="https://lh4.googleusercontent.com/TGtU1OkY2faRhCjHHt83SiNZdHiaxSJ8m28GqsXqtYevxiyr5fD5mDZrizDXWf4IhvfluGiu4r1N0SJpgR2SxBLFoCNdis0AAoLMhEGHyC4oSDcEjTQA2jEk5AIBZDTkN44wSAgQVm1neyeXc5LoaW1rPPya0T2v42vUwRJK3ZdfLOiJBqL1BboI4ZCIPg" /></span></span></span></span></span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Values ​​can be filtered manually, by Wildcard, Condition, or Top(Bottom). </span></span></span></span></span></span><span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">You can also combine these types of filtering</span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:275px"><span style="height:363px"><img src="https://lh4.googleusercontent.com/KyBMVOCJLbAj8sPJPtBG2BsxhjJaaOcNRE2h_SCXS7yUYWRdbH8ecbqbSTYrrrrwBfmRm0350HQ1xwHehjEcbc1nQVxOvMBMm1lsbHmkw3pEVJ_RSV0M4KV7wbsIuUtrIboQLMv-IXYFNuV3QiIg5dYneqxtVnBhbCZpqg9HYS-LhmxoRTD27x0Jeeg77Q" /></span></span></span></span></span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:275px"><span style="height:362px"><img src="https://lh6.googleusercontent.com/kLvnndbbqGyzTI6wJ4ekFwgw1x7IPqWal-8RO8HWC4GNFY_9mzRiz_EmAqDiLf1Y1vuExseSBqBOPW-6UXTs556C1ASLo_DMApvPqrBVCBIykMCFDMlLRUhj22QuRxwDGXfSu6A46xDr16sIkY0TSZegnkPWZqLFq_iVSqBKzGRPSS3wL9x_myksDlSevw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:274px"><span style="height:360px"><img src="https://lh5.googleusercontent.com/z0JEN-L703PWKwMYBKOiGXmozmO8tOa8ta-Yc-9JYI_2mQZ3a9-Oy7ncg-IvDsfBChme0YLzs8wrZ-q4NYtATjrb2MlzS3hg1qewoJqUxB9E3IfWXpXXOoWoKaYbYiKtgWealB_8SMA-NhqaSFeH6iocp6Hl8b87Qc-hUzGKrPXhJKESU6dwzCvOR1VcDw" /></span></span></span></span></span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:269px"><span style="height:357px"><img src="https://lh5.googleusercontent.com/2Q7JWk1eyvM5QCaX182TwQKJo7WlAiqGRunIRmRAyHTUnLGfTuKdTh1Pa2YxZFqLThdLHMO5korOPFNAb7pn2x4NPOSSpoqEnxTuufFyH1Dt5syZWplYEkJQh9J0aorq9y7Td7UIoBUFHg1MaopsBpqa2_rujL2AH_kjZGcs3KwdyXCFHkcA17kqj9wj5g" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">You can alter the visualization format in the </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Marks</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:550px"><span style="height:395px"><img src="https://lh3.googleusercontent.com/tqc2rqprNrx7BTBKeLRhGAOWrkOgHYdThqCbJFqTD3V_C-7gR_lBPAEZLIT5PA0H_QmbBpsdWA-fSJRR1EXSQTHmE1s8IzjBkd3wvM1XwniSHteW7L3tBDzFoTme0nL-oJT6xK0R2bDNsuwNtFEAmVYBoJ50-iyHxJklNs_YHs835U0_rC5mUpu4AaUaBQ" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">A worksheet is used to group sheets. On the left, there is a list of all available sheets that can be dragged and grouped as you wish. Also, on Worksheets in the Objects card, you can select and add text, images, etc. </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:309px"><img src="https://lh4.googleusercontent.com/qvwb1axEdkEn1zNCm2QhPPeksmOh2tUouUvvgfN-iSx4DJVauorEiPpmTt48Ml-uO7GCFAHYfuknJrjD-Dt0ppAsxtxGrR3064yOufgc48yUpr-ZVTLW-kaw1exj0SgZz6-rpFhzGuqUI4EABL2V69y-24A3gVXFGCtew-Lj2CRhBPsbu5B37kHonC_KDA" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<h2 style="line-height:1.38; margin-top:24px; margin-bottom:8px">
  <span style="font-size:14pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Publishing to the server.</span></span></span></span></span></span>
</h2>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In Tableau, you can publish your reports in Tableau Public, Tableau Online, and Tableau Server. The functionality of the last two programs is identical. The only difference is that Tableau Online is maintained by Tableau itself, while Tableau Server will be maintained on the side of your organization. You can publish your reports there with a Live connection, modify published reports without limiting functionality, or edit a published report in Tableau Desktop. </span></span></span></span></span></span><span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">The only disadvantage of servers is the inability to share your reports</span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> with someone who is not registered on the server. </span></span></span></span></span></span><span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">In other words, these reports are intended to be used exclusively within the organization.</span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> </span></span></span></span></span></span><span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Tableau Public allows you to share your reports with those who have a link, but it does not let you use a direct data connection</span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">We will be connecting to </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Tableau Server</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">First, we need to Sign in.</span></span></span></span></span></span><br /><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:333px"><span style="height:250px"><img src="https://lh4.googleusercontent.com/8UJXXmZ9DMifpS_NB61hbaAYDpg9px0qtShwPeHzfcQl_GbVLI4Dv_TXIyxQQhO2i_-2r3EJNmun5umYGETNoXWSQo2f3muJJeZeVjImS-wq4YeG3aS0iNQUsrzdPDWUJjOF2tM3hIjLaBAiRziKTqxzNbskyySmFGaSiIy8eE4BQtS0BTTSGpDeHQwIZQ" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Select the desired server and go through authorization. Then select </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Publish Workbook. </span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Specify the required parameters.</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none"> </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">For viewing convenience, </span></span></span></span></span></span><span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">we recommend selecting</span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Show sheets as tabs.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:379px"><span style="height:445px"><img src="https://lh6.googleusercontent.com/eDTv_BCqeNoFpOv--KRKD3Tih3Ai7w2XRlM8PwVSQV-9hq4-GOxOJjagI0kAmW2yKkArdX0a9xYqHsn9PweyLWo_7o5ARS5AWyrLcR4Yjc_E7yXAqY0L8IEAi8STA4WcwJ_DYXivwB5xAk6n6CYPpRIYIGvBhnOPCVnsnu7w0_jqKen8clXh-B0R34o0Rw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">If you wish, you can embed passwords. Otherwise, you will have to specify the login and password for our data source each time you get into your account.</span></span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> You can embed all passwords at once by clicking on the </span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Embed All Passwords</span></span></span></span></span></span><span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">.</span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:207px"><img src="https://lh6.googleusercontent.com/2zK7qD52xgTKIBoUVVX9Gg09Xgc0WUyxuz53SF9h1k5uJ_c758hSgOovI4Eg-a_KzbDUJV5KLye0NGoa6BSbDZh6LxDwgpXe3HdqnzGevrPBubGZlRyyoc9WHai2M4AIylcdxJmwpByb1NtCEMcQzdohk1Ymub2gLzb2jfVUrAqXlgBDDoD2t8L0fehedQ" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">It is finally time to go to the server, select the </span></span></span></span></span></span></span><span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Explore</span></span></span></span></span></span></span><span style="font-size:10.5pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Roboto, sans-serif"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"> item, and find our book.</span></span></span></span></span></span></span>
</p>

<p style="line-height:1.38">
  <span style="font-size:12pt; font-variant-ligatures:normal; font-variant-numeric:normal; font-variant-alternates:normal; font-variant-east-asian:normal; font-variant-position:normal; white-space:pre-wrap"><span style="font-family:Arial"><span style="color:#000000"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none"><span style="border:none"><span style="display:inline-block"><span style="overflow:hidden"><span style="width:602px"><span style="height:821px"><img src="https://lh4.googleusercontent.com/YOmmWKnZCmWvur7uoo8FT-BYcaCEUUkdezm_-RQHIU-9xSYToPasUMpljShaQFJP1PWGLPnj_MfU_Z4vdLt-RWhvjGoIZYUTzOXLvK2adw91eNm3yOtH5JCzKcCZkRMTQIH4f918yh1c4lyubUXADzS4uJfv2e6su1o_LRdVq5UzDH8nVcRDhfVoIeoyAw" /></span></span></span></span></span></span></span></span></span></span></span>
</p>

<br style="color:#000000; font-style:normal; font-weight:400; text-align:start; white-space:normal; text-decoration:none" />