<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Mark Silas on Medium]]></title>
        <description><![CDATA[Stories by Mark Silas on Medium]]></description>
        <link>https://medium.com/@marksilas?source=rss-e3cec0e9e8ff------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*cU4mpcW2n3P0FHzizTucZQ.jpeg</url>
            <title>Stories by Mark Silas on Medium</title>
            <link>https://medium.com/@marksilas?source=rss-e3cec0e9e8ff------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 20:26:36 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@marksilas/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Data Analysis With SQL Part 2]]></title>
            <link>https://marksilas.medium.com/data-analysis-with-sql-part-2-3e394f7d6f7f?source=rss-e3cec0e9e8ff------2</link>
            <guid isPermaLink="false">https://medium.com/p/3e394f7d6f7f</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[microsoft-sql-server]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-analytics]]></category>
            <dc:creator><![CDATA[Mark Silas]]></dc:creator>
            <pubDate>Mon, 08 Aug 2022 20:38:18 GMT</pubDate>
            <atom:updated>2022-08-08T20:38:18.992Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*LSy97AJJccRZvAxPIOWbNA.jpeg" /><figcaption>credit: unsplash.com</figcaption></figure><p>The Data Analysis With SQL Part 2 is a step further in data analysis with Microsoft SQL. I will be adding some Windows functions to our analysis this time.</p><p>You might be curious about what window functions in SQL are all about and how they are applied. In this article, we will be exploring some particular windows functions and how they are applied, also, we will look at a simple example on how to calculate cumulative sum.</p><p>We will continue our use of Adventureworks2019 database which I have already installed in my Microsoft SQL Server Management Studio(SSMS). This time around, I will make use of the Sales.SalesPerson table in the Adventureworks2019 database.</p><p>let’s have an eyeball look at the data frame</p><pre>SELECT * FROM Sales.SalesPerson</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jNaL9qL4xwyX_plKb-aM5Q.png" /></figure><p>This table contains 9 columns of data. Next, we will count the rows.</p><pre>SELECT COUNT(*) FROM Sales.SalesPerson</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/152/1*s5rszLHhj7j0svkCoYuihg.png" /></figure><p>There are 17 rows of data or records and 9 columns in total</p><p>Our analysis here will begin by comparing the difference between regular aggregation and windows functions.</p><p><strong>WINDOW FUNCTIONS</strong></p><p>Window functions in SQL act on a set of rows known as a <strong>window frame</strong>. For each row from the underlying query, they return a single value.</p><p>Example of windows functions are:</p><ul><li>OVER</li><li>DENSE_RANK()</li><li>COUNT()</li><li>RANK()</li><li>SUM()</li><li>LEAD()</li><li>ROW_NUMBER()</li><li>LAG()</li></ul><p>The <strong>window frame</strong> (set of rows) is usually defined by an<strong> OVER</strong> clause.</p><p><strong>OVER</strong></p><p>The OVER clause performs functions as:</p><p>Divides rows into groups (The clause <strong>“PARTITION BY” </strong>is utilized).</p><p>Secondly, It orders partitioned rows in a certain sequence. (The clause <strong>ORDER BY </strong>is utilized). We have looked into the use of ORDER BY in the part 1 of this article.</p><p><strong>PARTITION BY</strong></p><p>The PARTITION BY clause divide rows and group them retaining their separate identities. In regular aggregation, aggregate functions causes rows to be grouped into a single output.</p><p>Here we will explore the difference in using regular aggregation and windows functions.</p><pre>SELECT TerritoryID, AVG(SalesYTD) AS avg_ytd_sales</pre><pre>FROM [Sales].[SalesPerson]</pre><pre>GROUP BY TerritoryID</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/221/1*NwzLkMUdMtSvMLle8-V_7g.png" /></figure><p>The above code applies the regular aggregation method without windows function. Notice that the records which we initially know to be 17 is now 10. What happened? The regular aggregation finds the average of grouped records into a single output row. Records with identical TerritoryID are represented with a single output.</p><p>lets look at how windows function handles same aggregation.</p><pre>SELECT TerritoryID, AVG(SalesYTD) OVER (PARTITION BY TerritoryID) AS avg_ytd_sales</pre><pre>FROM [Sales].[SalesPerson]</pre><pre>ORDER BY TerritoryID</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/218/1*PNAmd6MjuUAifoXRw85G-g.png" /></figure><p>The window function did not collapse records with identical TerritoryID into one. The average was rather applied over all the partitioned records without tempering with their individual identities. We can see we still retained our original 17 records.</p><p>What will happen if we decide to omit the PARTITION BY clause? Our aggregate will not be applied over partitions but over the entire table.</p><pre>SELECT TerritoryID, AVG(SalesYTD) OVER () AS avg_ytd_sales</pre><pre>FROM [Sales].[SalesPerson]</pre><pre>ORDER BY TerritoryID</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/215/1*ShdOtFUUquQXHWWijSxyww.png" /></figure><p><strong>RANK()</strong></p><p>The RANK() function is a window function that assigns a rank to each row within the records of each partition. The rank of a row is one plus the number of ranks that come before the row in question. The rank of the first row within a partition is usually one one.</p><pre>SELECT TerritoryID, SalesYTD, rank() OVER (PARTITION BY TerritoryID </pre><pre>ORDER BY SalesYTD) as Rank_</pre><pre>FROM [Sales].[SalesPerson]</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/284/1*pL9RXRzOUG2qbWnf0XgTFg.png" /></figure><p>Notice that the ranking is done partition by partition. The first record of each partition begins with rank 1, then 2, and so on. <strong>Rank()</strong> can be used to identify duplicate values, as it gives the same rank to duplicate values within same partition.</p><p><strong>Running Total</strong></p><p>The running total, sometimes known as the cumulative sum, is a data analysis approach that is particularly helpful when you want to show how a measure has accumulated or increased over time. The <strong>sum() </strong>function in particular is essential for calculating running totals.</p><pre>SELECT *, SUM(SalesYTD) OVER (PARTITION BY SalesQuota ORDER BY SalesYTD) as Cum_SalesYTD</pre><pre>FROM Sales.SalesPerson</pre><pre>WHERE SalesQuota = 250000</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sRbXNL09maYWPSnRMGo2_w.png" /></figure><p>Looking at the last column, we can observe a cumulative increase in the sales amount as we go down the column. The running total is calculated over the SalesQuota.</p><p>let’s take a long coffee break here….</p><p>See you in the next article after the coffee break…..</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3e394f7d6f7f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Afrobeat Trends With Power BI: Burna Boy, Wizkid And Davido]]></title>
            <link>https://marksilas.medium.com/afrobeat-trends-with-power-bi-burna-boy-wizkid-and-davido-6f42f39e52e2?source=rss-e3cec0e9e8ff------2</link>
            <guid isPermaLink="false">https://medium.com/p/6f42f39e52e2</guid>
            <category><![CDATA[microsoft-power-bi]]></category>
            <category><![CDATA[visulaization]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[afrobeat]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Mark Silas]]></dc:creator>
            <pubDate>Tue, 28 Jun 2022 19:16:15 GMT</pubDate>
            <atom:updated>2022-08-24T07:40:55.533Z</atom:updated>
            <content:encoded><![CDATA[<p><strong><em>Introduction</em></strong></p><p>Power BI is a group of software services, applications, and connectors that combine to transform your different data sources into coherent, visually engaging, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI makes it simple to connect to your data sources, view the data, identify the key information, and share it with whoever you choose.</p><p>This project shows a simple but entrancing three-paged power BI report. The report comes with a homepage carrying three buttons that will direct you to the respective pages when clicked. Each report has a button to take you back to previous report or forward.</p><p><strong><em>Dataset</em></strong></p><p>The dataset for this project was extracted from <a href="https://trends.google.com/trends/?geo=NG">Google Trends</a>.</p><p><strong><em>Tools</em></strong></p><p>Tools applied for this projects includes Microsoft excel and Power BI. Both tools were used for data preparation. Visualization was done on Microsoft Power BI.</p><p><strong><em>Homepage</em></strong></p><p>The homepage carries all the buttons that will lead you to each page. You can go to any of the report by clicking any of the buttons at the top right of the homepage.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZaEFSwmqBj2YSnFkCJX6sQ.jpeg" /><figcaption>Image Credit: Unsplash</figcaption></figure><p><strong><em>First Page</em></strong></p><p>Here we see line charts of the global interest for Burna Boy, Wizkid and Davido from Feb 7, 2021 to Jan 30, 2022.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8rjhsPR-6uZuPfSQh4U0WA.jpeg" /></figure><p><strong><em>Second Page</em></strong></p><p>Regional Interest shows us the interest these artists were able to garner across different countries from Feb 3, 2021 to Feb 3, 2022.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ABf0bWNIc4zJtnnY2Rk95g.jpeg" /></figure><p><strong><em>Last Page</em></strong></p><p>City Interest visualizes the interests people have for these artist by cities from Feb 3, 2021 to Feb 3, 2022.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yItbH04Gr-WMvRXnp_M-Uw.jpeg" /></figure><p>You can find the power BI template and the data to this repost <a href="https://github.com/marksilas/AfrobeatTrends">here</a> and the <a href="https://github.com/marksilas/AfrobeatTrends/blob/main/Top%20Acts.pbix">pbix</a> file here.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6f42f39e52e2" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Azure Machine Learning Designer]]></title>
            <link>https://marksilas.medium.com/azure-machine-learning-designer-e4d4b29dc536?source=rss-e3cec0e9e8ff------2</link>
            <guid isPermaLink="false">https://medium.com/p/e4d4b29dc536</guid>
            <category><![CDATA[azure]]></category>
            <category><![CDATA[azure-machine-learning]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[no-code]]></category>
            <category><![CDATA[machine-learning]]></category>
            <dc:creator><![CDATA[Mark Silas]]></dc:creator>
            <pubDate>Fri, 20 May 2022 11:28:19 GMT</pubDate>
            <atom:updated>2022-05-21T16:13:32.355Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-6HhemojYulOWvXm8Ku3gg.jpeg" /><figcaption>Credit: unsplash.com</figcaption></figure><p><strong>Training your first machine learning model with Azure machine learning designer.</strong></p><p>The Azure machine learning designer is a drag-and-drop interface that helps everyone in your data science team, from beginners to experts, develop and deploy models faster.</p><p>After learning about the Azure cloud, especially the machine learning studio. I prepared my first video on how to use the Azure machine learning studio’s designer. The video shows you how to get started with the machine learning designer. It will first demonstrate how to create a resource group and then a resource. It also demonstrates how to get to the machine learning studio and use the drag-and-drop designer to create your first machine learning model. From importing your dataset to assessing your trained model, you’ll learn how to build a comprehensive end-to-end training pipeline.</p><p><strong>You can do the following with the Azure machine learning designer</strong></p><p><strong>Connect and prepare data with ease</strong><br>Connect to Azure Blob Storage, Azure Data Lake Storage, Azure SQL, or upload data from a local file by dragging and dropping a registered dataset. With just one click, you may preview and visualize the data profile. Preprocess data with a variety of built-in data transformation and feature engineering modules.</p><p><strong>Create and train models without having to write code.</strong><br>Create and train machine learning models using cutting-edge machine learning and deep learning techniques for computer vision, text analytics, recommendation, and anomaly detection. Drag and drop modules for no-code models, or use Python and R code to customize.</p><p><strong>Validate and evaluate the model’s effectiveness.</strong><br>Run machine learning pipelines interactively. Validate models and datasets using cross-validation. With a few clicks, you may access data visualizations to evaluate models. For debugging and troubleshooting, use graphs, preview logs, and outputs to perform a quick root cause analysis. Validate and assess the model’s performance.</p><p><strong>With only a few clicks, you can deploy models and publish endpoints.</strong><br>With a few clicks, deploy models for real-time and batch inferencing via REST endpoints to your environment. Create the scoring files and the deployment image automatically. For machine learning operations (MLOps) tracking and lineage, models and other assets are saved in the central registry.</p><p>Find below is a link to the video I recorded on how to create your first machine learning model using the Azure machine learning designer.</p><p><a href="https://www.youtube.com/watch?v=7k898XIQt98&amp;list=PLbXuEmA3eejWuOadoVYMdLWD0c93ZSi2x"><strong>How To Use The Azure Machine Learning Designer — YouTube</strong></a></p><p>If you find this video enlightening, kindly drop a comment.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e4d4b29dc536" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Analysis With SQL Part 1.]]></title>
            <link>https://marksilas.medium.com/data-analysis-with-sql-part-1-f4d6b21cea6?source=rss-e3cec0e9e8ff------2</link>
            <guid isPermaLink="false">https://medium.com/p/f4d6b21cea6</guid>
            <category><![CDATA[database]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[ms-sql-server]]></category>
            <dc:creator><![CDATA[Mark Silas]]></dc:creator>
            <pubDate>Thu, 19 May 2022 13:46:22 GMT</pubDate>
            <atom:updated>2022-05-20T15:27:32.709Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*9mshVRvLCjO8curgX_rS2Q.png" /><figcaption>Credit: <a href="https://hevodata.com/learn/database-systems/">Database Systems: A Simplified Analysis (hevodata.com)</a></figcaption></figure><p>The Structured Query Language (SQL) is a computer language that was created for managing data in a relational database management system (RDBMS) or stream processing in a relational data stream management system (RDSMS). It’s especially beneficial for dealing with structured data, or data that has relationships between entities and variables. It is used for storing, manipulating and retrieving data in databases.</p><p>Example of database systems that SQL is used for include MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, etc.</p><p>In this data analysis project, we will be using the Microsoft SQL for our data analysis. The database used here is the Adventureworks2019 database which can be found in the Microsoft SQL Server Management Studio. We will make use of two tables in the database namely, the <strong>Sales.SalesTerritory </strong>and <strong>Sales.SalesTerritoryHistory </strong>tables.</p><p><strong>TABLES</strong></p><p><strong>Table 1: (Sales.SalesTerritory)</strong></p><p>To view the entire Sales.SalesTerritory table we run the following code:</p><pre>SELECT * FROM Sales.SalesTerritory</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*urx4xEq3b56eitHAJghFaQ.png" /></figure><p><strong>COUNT</strong></p><p>Lets count the total number of records on this table using the COUNT() function. The count function is an aggregate function that returns the number of rows returned by a query. COUNT(*) returns all the number of rows returned by a query.</p><pre>SELECT COUNT(*) FROM Sales.SalesTerritory</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/121/1*KSQWln2O0uD5nYv4rglzgA.png" /></figure><p><strong>Table 2: (Sales.SalesTerritoryHistory)</strong></p><p>To view the Sales.SalesTerritoryHistory table we run the following code:</p><pre>SELECT * FROM Sales.SalesTerritoryHistory</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/919/1*XrjFT8VVJUXLwzmrCWZBvg.png" /></figure><p>Lets count the total number of record on the Sales.SalesTerritoryHistory as well.</p><pre>SELECT COUNT(*) FROM Sales.SalesTerritoryHistory</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/126/1*Bnh4MCnRfXr8Hp2bHHPU2Q.png" /></figure><p><strong>JOINING TABLES</strong></p><p>We will be joining the two tables above for easier analysis. Meanwhile, we are going to be working with some selected columns, that is, we will not include all columns from both tables. We will use the Inner join to join this two tables. The INNER JOIN is applied when you want to return records that have matching values in both tables.</p><pre>SELECT t.Name, t.SalesYTD, h.StartDate, h.EndDate</pre><pre>FROM Sales.SalesTerritory t</pre><pre>JOIN Sales.SalesTerritoryHistory h</pre><pre>ON t.TerritoryID = h.TerritoryID</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/528/1*LctLxo5qbFizUym4aOpg9Q.png" /></figure><p><strong>ORDER BY</strong></p><p>Lets sort our table using the ORDER BY clause. The ORDER BY clause sorts the fetched data in an ascending or descending manner according to one or more columns. By default, it sorts the result in an ascending order.</p><p>We will be ordering our result by the ‘Name’ column in a descending order</p><pre>SELECT t.Name, t.SalesYTD, h.StartDate, h.EndDate</pre><pre>FROM Sales.SalesTerritory t</pre><pre>JOIN Sales.SalesTerritoryHistory h</pre><pre>ON t.TerritoryID = h.TerritoryID</pre><pre>ORDER BY Name DESC</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/559/1*i5SoTbuY4j5zHaTTWwgXdA.png" /></figure><p>Take note that the DESC function was used to order the ‘Name’ column in a descending order.</p><p><strong>GROUP BY</strong></p><p>The GROUP BY command is used in conjunction with SQL aggregate function such as SUM or COUNT to group the resulting dataset by a specific database table column (s)</p><p>The code below checks for duplicate records in our table using the GROUP BY clause and COUNT. A record can be duplicated once or many times.</p><pre>SELECT t.Name, t.SalesYTD, h.StartDate, h.EndDate, COUNT(*) as CNT</pre><pre>FROM Sales.SalesTerritory t</pre><pre>JOIN Sales.SalesTerritoryHistory h</pre><pre>ON t.TerritoryID = h.TerritoryID</pre><pre>GROUP BY Name, StartDate, EndDate, SalesYTD</pre><pre>HAVING COUNT(*)&gt;1</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/472/1*NGsqaVLWenPAONoWFm913w.png" /></figure><p>The Name ‘Southwest’ has one duplicate record.</p><p><strong>HAVING</strong></p><p>The Having clause replaces the WHERE clause whenever one is working with aggregate functions. The WHERE clause cannot be used with aggregate functions like SUM, COUNT, MAX, etc.</p><p>Can we find the total sales of SalesYTD for a particular Name? The code below calculates the total sales made for a given date for Name =‘Canada’</p><pre>SELECT t.Name, SUM(t.SalesYTD) as Total_Sales, h.StartDate, h.EndDate, COUNT(*) as CNT</pre><pre>FROM Sales.SalesTerritory t</pre><pre>JOIN Sales.SalesTerritoryHistory h</pre><pre>ON t.TerritoryID = h.TerritoryID</pre><pre>GROUP BY Name, StartDate, EndDate, SalesYTD</pre><pre>HAVING Name = ‘Canada’</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/546/1*VgW_SlzyGtzOsO5ZFn-ORQ.png" /></figure><p>we can replicate the above code for both ‘Canada’ and ‘Northwest’</p><pre>SELECT t.Name, SUM(t.SalesYTD) as Total_Sales, h.StartDate, h.EndDate, COUNT(*) as CNT</pre><pre>FROM Sales.SalesTerritory t</pre><pre>JOIN Sales.SalesTerritoryHistory h</pre><pre>ON t.TerritoryID = h.TerritoryID</pre><pre>GROUP BY Name, StartDate, EndDate, SalesYTD</pre><pre>HAVING Name in (‘Northwest’, ‘Canada’)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/556/1*X7BolGKtcHeFIjs67lE3OA.png" /></figure><p><strong>TOP</strong></p><p>The TOP clause is used to select the number of records to return.</p><p>In the code below, we calculated the sum of the SalesYTD column, ordered it in a descending manner and returned only the first record. By doing this, we are able to return only the highest total sales.</p><pre>SELECT TOP(1) t.Name, SUM(t.SalesYTD) as Total_Sales, h.StartDate, h.EndDate, COUNT(*) as CNT</pre><pre>FROM Sales.SalesTerritory t</pre><pre>JOIN Sales.SalesTerritoryHistory h</pre><pre>ON t.TerritoryID = h.TerritoryID</pre><pre>GROUP BY Name, StartDate, EndDate, SalesYTD</pre><pre>ORDER BY SUM(t.SalesYTD) DESC</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/472/1*HH8voP2V2VXaQ7XSjmZZBw.png" /></figure><p>Note that our highest total sales is from the Name = ‘Southwest’ which we formerly realized has a duplicate record. The two same records were summed up to give us what we are now seeing.</p><p>I will take a break here for you to chew the content. Kindly feel free to use Google or Stackoverflow to aid your understanding of this content.</p><p>See you in the next lesson……</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f4d6b21cea6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How I Passed The Microsoft Azure AI Fundamentals(AI-900)]]></title>
            <link>https://marksilas.medium.com/how-i-passed-the-microsoft-azure-ai-fundamentals-ai-900-275005bc7bbb?source=rss-e3cec0e9e8ff------2</link>
            <guid isPermaLink="false">https://medium.com/p/275005bc7bbb</guid>
            <category><![CDATA[machine-learning]]></category>
            <category><![CDATA[azure]]></category>
            <category><![CDATA[microsoft]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Mark Silas]]></dc:creator>
            <pubDate>Thu, 18 Mar 2021 15:52:52 GMT</pubDate>
            <atom:updated>2021-03-18T22:42:59.280Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IIake1GxpzeMLuBTU9stng.jpeg" /><figcaption>Microsoft Certified Azure AI Fundamentals</figcaption></figure><p>The Microsoft Azure AI Fundamentals certification is a beginner cloud certification for those who have interest in AI.</p><p>Candidates that would enroll for this exam are expected to have acquired foundational knowledge of machine learning (ML) and artificial intelligence (AI) concepts and related Microsoft Azure services.</p><p>The exam therefore tests your ability to implement ML and AI workloads on Azure cloud.</p><p>The exam has a total scoring scale of 1000 with a cut-of of 700; that is, those who must pass this exam must aim to score 700 marks or above. It has 51 questions you are suppose to answer, although number of questions may vary. The exam is for 60 minutes and the cost varies from country to country, for instance, people from the US pay $99, UK pay £69, while people from Nigeria pay $55.</p><p>The area of skills the exam will measure includes:</p><ul><li>Describe AI workloads and considerations (15–20%)</li><li>Describe fundamental principles of machine learning on Azure (30–35%)</li><li>Describe features of computer vision workloads on Azure (15–20%)</li><li>Describe features of Natural Language Processing (NLP) workloads on Azure (15–20%)</li><li>Describe features of conversational AI workloads on Azure (15–20%</li></ul><p>This exam is designed for candidates with both technical and non-technical backgrounds. Data science and software engineering experience are not required; however, some general programming knowledge or experience would be beneficial.</p><p>Azure AI Fundamentals can be a preparatory exam to the other Azure role-based certifications like Azure Data Scientist Associate or Azure AI Engineer Associate, it is however not a prerequisite for any of the role based certification.</p><p><strong>When I sat for this exam, I passed with a score of 896/1000.</strong></p><p>I didn&#39;t pay to sit for the Microsoft Azure AI Fundamentals Examination. I was given a free voucher to sit for this exam after attending the free Microsoft Azure AI Fundamentals Virtual Training. As at the time of the exam, I was already in my 6th month of learning ML and AI, so you can guess I had some knowledge already. I advice that potential candidates for this exam should also have some experience before sitting for this entry level exam.</p><p><strong>How I read for the exam</strong></p><p>I used three resource to study for this exam:</p><p>I. <a href="https://www.examtopics.com/exams/microsoft/ai-900/">Examtopics free Microsoft AI-900 exam practice</a>: I went through this free exam practice about 4 times to be very familiar with the questions.</p><p>II. <a href="https://docs.microsoft.com/en-us/learn/certifications/exams/ai-900">The official Microsoft study guide</a>: which contains the learning paths to gain the skills needed to become certified.</p><p>III. <a href="https://www.youtube.com/watch?v=E9aarWMLJw0">Study guide review video for AI-900</a> by John Savill.</p><p>These materials are sufficient to pass the exam if studied keenly. Alternatively, you can take the prep AI-900 course on <a href="https://www.udemy.com/course/exam-microsoft-azure-4/">Udemy</a>. You can prepare for this exam in a week or two and pass, depending on your experience level.</p><p><strong>How I scheduled the exam:</strong></p><ol><li><a href="https://www.microsoft.com/en-us/learning/dashboard.aspx">I signed up for the exam using my email</a></li><li>Scheduled the exam from the dashboard in my profile.</li></ol><p>I scheduled to take this exam at home via an online proctoring(invigilation) by Pearson Vue. You can also schedule to take this exam online in the office or at a nearby local test center.</p><p><strong>Note: This exam can be rescheduled, but only 24hrs before the initial scheduled exam time.</strong></p><p>The first screenshot below shows my dashboard after signing up. The second screenshot shows a link at lower left where exam can be scheduled.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HJABa-BFrmtGF5fCb29TkQ.jpeg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JD4S8MqNXUyYL5lNIRvY_w.jpeg" /><figcaption>A sample of my dashboard after signing up.</figcaption></figure><p>Since I got a free voucher to sit for the exam, I simply entered my email to check for discount eligibility before scheduling the exam.</p><p><strong>On Exam day</strong></p><p>On the exam day, I logged into my email to check in for the examination. After scheduling the exam, an email will be sent to you carrying the details of your scheduled exam from where you will find the link that says “check in to start exam”.</p><p>On checking in for the exam, you will be required to run a test on your “webcam”, “internet speed“ and “microphone” to ensure they are suitable and functional for the exam; this will be done by sending you an app to download. The Pearson VUE app carries access codes you will copy and paste on the portal for the test.</p><p>After the test, you be will sent a link to your mobile number. This link will be used to capture and upload a national identity card, the four perspectives of your online exam environment at home or office and a snapshot of your face. If you did this successfully, then your exam is ready to be served.</p><p><strong>Conclusion</strong></p><p>Cloud skills are very essential, it is expected that soon enough, all tech workloads and applications would be deployed on the cloud. Cloud presents the advantages of reduced IT costs, easy accessibility and reliability. It is hence obvious that the demand for cloud skills will continue to increase and people with such skills will be highly sought after.</p><p>All the best!</p><p><strong>END</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=275005bc7bbb" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>