<?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 Derrick Kuria on Medium]]></title>
        <description><![CDATA[Stories by Derrick Kuria on Medium]]></description>
        <link>https://medium.com/@derrickkuria44?source=rss-b517bb42ccb1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*AelPP7o4CuEbzy9uHCpIgw.jpeg</url>
            <title>Stories by Derrick Kuria on Medium</title>
            <link>https://medium.com/@derrickkuria44?source=rss-b517bb42ccb1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 14:56:21 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@derrickkuria44/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[MIXPANEL — The Analytics tool you are possibly ignoring]]></title>
            <link>https://medium.com/@derrickkuria44/mixpanel-the-analytics-tool-you-are-possibly-ignoring-4b06ce23f45f?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/4b06ce23f45f</guid>
            <category><![CDATA[mixpanel]]></category>
            <category><![CDATA[mixpanel-analytics]]></category>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Sat, 08 Feb 2025 13:51:28 GMT</pubDate>
            <atom:updated>2025-02-08T13:51:28.630Z</atom:updated>
            <content:encoded><![CDATA[<h3>MIXPANEL — The Analytics tool you are possibly ignoring</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/259/1*E4kkmPJQ64hm0QaA9AWOcQ.jpeg" /><figcaption>Mixpanel</figcaption></figure><p>In the fast-paced world of data analytics, staying ahead of the curve is crucial. Yet, amidst the plethora of tools available, one powerful platform often flies under the radar: Mixpanel. If you’re looking to gain deeper insights into user behavior, optimize your product, and drive growth, Mixpanel might just be the secret weapon you’ve been overlooking.</p><p>Mixpanel isn’t just another analytics tool; it’s a comprehensive solution designed to help you understand how users interact with your product in real-time. From tracking user actions to analyzing engagement and retention, Mixpanel provides the granular data you need to make informed decisions. Whether you’re a product manager, marketer, or data analyst, this tool can transform the way you approach data-driven strategies.</p><p>In this article, we’ll explore the key features of Mixpanel, how it can be used to supercharge your analytics, and what the future holds for this innovative platform. Get ready to discover why Mixpanel is the analytics tool you can’t afford to ignore.</p><h3>Key Concepts in Mixpanel</h3><ol><li>Events: These are actions that users take within your product. For example, clicking a button, making a purchase, or watching a video.</li><li>Users: The individuals who interact with your product. Each user has a unique identifier, which helps track their activity.</li><li>Properties: Attributes that provide additional context about events and users. For example, the type of product purchased or the user’s location</li></ol><h3>How is Mixpanel Used in Data?</h3><p>Mixpanel is used to collect and analyze data on user interactions. Here’s how it works:</p><ol><li>Event Tracking: Mixpanel tracks specific actions users take within your product. This data is then used to create custom reports and dashboards.</li><li>User Profiles: Each user has a profile that stores information about their interactions and attributes. This helps in understanding user behavior over time.</li><li>Cohort Analysis: Mixpanel allows you to group users based on shared characteristics or behaviors. This helps in identifying trends and patterns.</li><li>A/B Testing: You can run experiments to see how different changes impact user behavior. This is crucial for optimizing your product and marketing strategies.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Y_hWhdLN4awDaZjUmxJAHw.png" /><figcaption>A/B Testing</figcaption></figure><p>The best practices and tips for using Mixpanel effectively:</p><ol><li>Clear Event Naming: Use clear and consistent names for your events to make your data easier to understand and analyze. For example, instead of naming an event “click,” use “button_click” to specify the action</li><li>Regular Data Audits: Regularly audit your data to ensure accuracy and consistency. This helps in maintaining the quality of your analytics. Timo suggests setting up a schedule for these audits to catch any discrepancies early</li><li>Leverage Mixpanel’s Integrations: Mixpanel integrates with various tools and platforms, making it easier to connect your data and gain deeper insights. For instance, integrating with your CRM can provide a more comprehensive view of your customer journey.</li></ol><h3>The Future of Mixpanel</h3><p>The future of Mixpanel looks incredibly promising. Here are some trends and advancements to look out for:</p><ol><li>Enhanced Marketing Analytics: Mixpanel is evolving to provide robust marketing analytics out of the box. This means better insights into acquisition channels and the ability to measure the full user journey from acquisition to retention</li><li>Unified Data Platform: Mixpanel aims to unify all your data in one place, breaking down silos and providing a comprehensive view of your business metrics</li><li>Accessibility for All: Mixpanel is working towards making analytics accessible to everyone, not just technical teams. This includes intuitive dashboards and easy-to-use tools that require no SQL or analytics background</li><li>Advanced Identity Resolution: With improved identity resolution, Mixpanel can unify logged-out and logged-in user data, providing a seamless view of user interactions across different platforms</li></ol><h4>Practical Examples of Mixpanel</h4><ol><li>Tracking User Onboarding: By setting up events for each step of the onboarding process, you can see where users drop off and optimize those steps to improve completion rates</li><li>Analyzing Feature Usage: Track how often users engage with specific features. This helps in understanding which features are most valuable and which might need improvement</li><li>Monitoring Marketing Campaigns: Use Mixpanel to track the effectiveness of your marketing campaigns. By analyzing the data, you can see which campaigns drive the most engagement and conversions</li></ol><p>I hope this guide helps you get a better understanding of Mixpanel and its potential. If you have any questions or need further clarification, feel free to ask. Happy analyzing! 😊</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4b06ce23f45f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Azure Data Factory Tips ,Tricks and Best Practices.]]></title>
            <link>https://medium.com/@derrickkuria44/azure-data-factory-tips-tricks-and-best-practices-d848fed184e9?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/d848fed184e9</guid>
            <category><![CDATA[adf]]></category>
            <category><![CDATA[azure-data-factory]]></category>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Sat, 08 Feb 2025 13:38:21 GMT</pubDate>
            <atom:updated>2025-02-08T13:38:21.125Z</atom:updated>
            <content:encoded><![CDATA[<h3>Azure Data Factory Tips ,Tricks and Best Practices.</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/303/1*A9CehkAIol_b-T0HFcBGIw.png" /><figcaption>Azure Data Factory</figcaption></figure><p>Hey there! If you’re working with Azure Data Factory (ADF), I’ve got some handy tips and tricks to make your life easier. SOme of this are gathered from other Azure Developers as well. Let’s jump right in!</p><h3>1. Save and Refresh Before Publishing</h3><p>Imagine you’re working on a project with a colleague. You’ve both made changes to the same feature branch in ADF. If you hit the publish button without saving and refreshing first, your changes might overwrite each other’s work. To avoid this, always save your changes, refresh ADF, and then publish manually. This ensures that everyone’s work is preserved and nothing gets lost in the process.</p><h3>2. Check Dependencies Before Modifying Objects</h3><p>Before you dive into modifying any objects like pipelines, datasets, data flows, or linked services, it’s a good idea to check for dependencies. Why? Because sometimes an object you’re about to change is being used by other parts of your project. If you change it without checking, you might break something else. In ADF Studio, you can easily find dependencies in the properties section of each object. This way, you can make informed changes without causing any unintended issues.</p><h3>3. Clone Objects for Safe Modifications</h3><p>When you’re troubleshooting or making significant changes, it’s safer to clone the object first. For example, if a data flow isn’t working as expected, clone it and make your changes on the clone. This way, you can test your changes without affecting the original object. If something goes wrong, you still have the original intact. It’s like having a backup plan!</p><h3>4. Dynamically Access Activity Outputs</h3><p>Sometimes, you need to capture the output of an activity, like an error message or the number of records processed. To do this, run the task first and check the output JSON. This will show you which properties you need to use. For example, if a pipeline fails, you can capture the error message and store it for reporting. This helps you understand what went wrong and how to fix it.</p><h3>5. Use Annotations for Better Tracking</h3><p>Annotations are super helpful for tracking details like which URLs, storage accounts, or containers were used during pipeline runs. You can add annotations in the properties section of your pipeline. This feature works for triggered pipelines and provides valuable insights during debugging. It’s like leaving little notes for yourself to understand what happened during each run.</p><h3>6. Utilize Parameters and Variables</h3><p>Parameters, variables, and global parameters are your best friends in ADF. They allow you to create flexible pipelines that can handle multiple business outcomes without duplicating logic. For example, you can use global parameters to store environment-specific URLs. This way, you can easily switch between different environments (like development, testing, and production) without changing your pipeline logic.</p><h3>7. Leverage Expressions for Complex Logic</h3><p>ADF doesn’t support nested if activities directly, but you can use expressions to achieve similar functionality. Write expressions to handle complex conditions within your pipelines. This allows you to create more sophisticated logic without getting stuck by the limitations of the interface.</p><h3>8. Create Child Pipelines for Reusable Logic</h3><p>For common tasks like sending emails, create child pipelines. This avoids duplicating logic across multiple pipelines and makes maintenance easier. Child pipelines can be called from parent pipelines, providing better visibility and modularity. It’s like having a toolbox with all your essential tools ready to use whenever you need them.</p><h3>9. Clear Pipeline Structure</h3><p>Having a clear and organized pipeline structure is crucial for maintaining and troubleshooting your ADF pipelines. Use meaningful names for your pipelines, activities, and datasets to make it easier to understand and manage your data flows. Think of it as keeping your workspace tidy so you can find everything you need quickly.</p><h3>10. Parameterization is Key</h3><p>Utilize parameterization to make your pipelines more flexible and reusable. By using parameters, you can easily adapt your pipelines to different environments or scenarios without hardcoding values. It’s like having a universal remote that works with all your devices.</p><h3>11. Incremental Loading</h3><p>When dealing with large datasets, opt for incremental loading instead of full loads. This approach reduces the amount of data processed and improves performance. Incremental loading can be achieved by using watermark columns or change data capture (CDC) techniques. It’s like taking small bites instead of trying to eat the whole cake at once.</p><h3>12. Robust Error Handling and Monitoring</h3><p>Implement robust error handling and monitoring mechanisms in your pipelines. Use try-catch blocks, custom logging, and alerts to ensure you can quickly identify and resolve issues. This helps maintain the reliability and stability of your data workflows. Think of it as having a safety net to catch any problems before they become big issues.</p><h3>13. Metadata-Driven Ingestion Patterns</h3><p>Create metadata-driven ingestion patterns to dynamically generate pipelines and activities based on metadata. This approach allows you to onboard new data sources quickly and efficiently without extensive manual coding. It’s like having a smart assistant that sets everything up for you.</p><h3>14. Optimize Performance</h3><p>Optimize the performance of your ADF pipelines by tuning the settings of your activities, such as batch sizes and parallelism. Monitor the performance of your pipelines regularly and make adjustments as needed to ensure they run efficiently. It’s like fine-tuning a car to get the best mileage.</p><h3>15. Manage Costs Effectively</h3><p>Keep an eye on the costs associated with your ADF pipelines. Use cost management tools and best practices to optimize your resource usage and avoid unnecessary expenses. This includes scheduling pipelines during off-peak hours and using cost-effective data storage options. It’s like being a savvy shopper who always finds the best deals.</p><h3>16. Use Linked Services and Integration Runtimes Wisely</h3><p>Configure linked services and integration runtimes appropriately to ensure secure and efficient data movement. Use managed virtual networks and private endpoints to enhance security and performance. It’s like setting up a secure and fast highway for your data to travel on.</p><p>I hope these tips help you get the most out of Azure Data Factory! If you have any questions or need further clarification, feel free to ask. Happy data engineering! 😊</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d848fed184e9" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Why Data Engineers Should Embrace SSAS]]></title>
            <link>https://medium.com/@derrickkuria44/why-data-engineers-should-embrace-ssas-0c9e8e87fe36?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/0c9e8e87fe36</guid>
            <category><![CDATA[microsoft-sql-server]]></category>
            <category><![CDATA[databases-big-data]]></category>
            <category><![CDATA[sql-server]]></category>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Tue, 21 May 2024 08:28:13 GMT</pubDate>
            <atom:updated>2024-05-21T08:28:13.542Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*gEq7GUW7pJWDxRad1Na8FQ.jpeg" /></figure><p>SQL Server Analysis Services (SSAS) may not be the most popular big data solution on the market, but for data engineers, it remains a valuable asset in the data warehouse. SSAS provides a distinct set of capabilities that supplement a data engineer’s primary responsibilities, particularly in data preparation and presentation for advanced analytics.</p><p>In the ever-evolving world of big data, it’s easy to get caught up in the hype of the latest shiny tools. But for data engineers, this is a hidden gem sitting right under their noses.</p><p>Understanding SSAS and its place in the data analysis workflow can be your secret weapon for creating high-performance data pipelines that power ground-breaking insights. Here are some of the functionalities that make SSAS to stand out.</p><h4><strong>1. Beyond Basic Transformations: Complex Calculations at Your Fingertips</strong></h4><p>SSAS allows you to define custom calculations and KPIs (Key Performance Indicators) within the data cube itself. This eliminates the need for advanced post-processing steps, saving you time and ensuring accuracy and consistency throughout the analysis.</p><h4>2. Multidimensional Mastery: Unlocking Hidden Insights</h4><p>The brilliance of SSAS lies in its basic functionality: Online Analytical Processing (OLAP) cubes. These are not your conventional spreadsheets. They organize data on various dimensions (such as product category, time period, and geographical location). This multidimensional view enables analysts to ask advanced questions and find hidden trends that would otherwise be missed in flat data structures. As a data engineer, you have control over how data is structured within these cubes, which directly affects the ease and depth of future analysis.</p><h4>3. Granular Security: Protecting Your Data</h4><p>Data security is essential. SSAS provides a strong security concept that enables you to implement granular access controls. You can limit access to certain data cubes, dimensions, or even individual measures within the cube. This guarantees that only authorized individuals can view the data they require, protecting your data fortress against unauthorized access.</p><h4>4. Version Control for Peace of Mind</h4><p>Have you ever regretted making a modification to the data model? SSAS includes built-in version control tools. You can keep track of modifications, revert to prior versions, and compare different iterations of the data model. This gives you peace of mind, knowing that you can easily roll back if problems emerge.</p><h4>5. Seamless Integration: The Microsoft Powerhouse</h4><p>For those that have invested in the Microsoft environment, SSAS shines even brighter. It works well with other Microsoft data products, such as SQL Server and Azure Analysis Services. This streamlined procedure makes it easier to use familiar tools and migrate data between platforms.</p><p>I believe these reasons are testament enough of the powerhouse behind the tool SSAS and data engineers using SSAS become the architects of powerful data pipelines. In the future, I will do a blog on the difference between SSAS and Power BI which is a question I get a lot.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0c9e8e87fe36" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Breaking the 100-Get Items Barrier : Working with Larger Datasets in Power Automate]]></title>
            <link>https://medium.com/@derrickkuria44/breaking-the-100-get-items-barrier-working-with-larger-datasets-in-power-automate-79abcfb3cbed?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/79abcfb3cbed</guid>
            <category><![CDATA[powerplatform]]></category>
            <category><![CDATA[power-automate]]></category>
            <category><![CDATA[sharepoint]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[get-item]]></category>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Wed, 08 May 2024 12:38:52 GMT</pubDate>
            <atom:updated>2024-05-08T12:38:52.111Z</atom:updated>
            <content:encoded><![CDATA[<h3>Breaking the 100-Get Items Barrier : Working with Larger Datasets in Power Automate</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kFxJzQhuJvSBmQhsbAIheA.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@sortino?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Joshua Sortino</a> on <a href="https://unsplash.com/photos/worms-eye-view-photography-of-ceiling-LqKhnDzSF-8?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Unsplash</a></figcaption></figure><p>Microsoft Power Automate (formerly Microsoft Flow) is a powerful tool for automating workflows, but sometimes you need to work with more data than the default limit of 100 items for “Get Items” and “Get Rows” actions.</p><p>This are functions that are used to get data from Microsoft Excel and SharePoint. By default, Power Automate retrieves a maximum of 100 items at a time. To access everything beyond that initial chunk, we need to leverage pagination. This built-in functionality allows the flow to iterate through multiple pages of results, effectively gathering all your data.</p><p>Here’s How to Do It:</p><ol><li>Locate the “Get Items” or “Get Rows” action within your flow. This will reveal a menu with additional options. For classic SharePoint views, you might see a toggle for “Pagination.” Ensure this is turned on.</li><li>Under the “Pagination” section, locate the “Top” or “Limit” field. Here, enter the desired maximum number of items you want to retrieve. Be mindful of potential performance impacts when setting very high limits.</li><li>If you have multiple “Get Items” or “Get Rows” actions working with the same data source, you’ll need to adjust the limit for each action individually.</li></ol><p>4. Remember to Save.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=79abcfb3cbed" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unleashing Email Insights: Importing Excel Attachments into Power BI with Power Query]]></title>
            <link>https://medium.com/@derrickkuria44/unleashing-email-insights-importing-excel-attachments-into-power-bi-with-power-query-d6a99d0d9266?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/d6a99d0d9266</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[power-query]]></category>
            <category><![CDATA[email]]></category>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Sat, 04 May 2024 05:55:22 GMT</pubDate>
            <atom:updated>2024-05-04T05:55:22.542Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0wYrd6ZVGkYT0uMOKr78cQ.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@campaign_creators?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Campaign Creators</a> on <a href="https://unsplash.com/photos/person-using-macbook-pro-pypeCEaJeZY?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Unsplash</a></figcaption></figure><p>Imagine a world where you don’t have to manually copy and paste data from Excel attachments scattered across your inbox into Power BI.</p><p>With the magic of Power Query’s Exchange.Contents function, that world is within reach! This blog post will guide you through the process of automatically extracting data from Excel attachments in emails and transforming them into beautiful visualizations in Power BI.</p><h3>Prerequisites</h3><ul><li>A Microsoft Exchange mailbox (e.g., Outlook) connected to Power BI.</li><li>Basic familiarity with Power Query Editor (get data -&gt; Transform Data).</li><li>Some Excel files floating around in your inbox (let’s put them to good use!).</li></ul><h3>Step 1: Connecting to Your Exchange Mailbox</h3><ol><li>In Power BI Desktop, navigate to the “Get Data” section on the Home tab.</li><li>Select “From Other Sources” -&gt; “From Microsoft Exchange.”</li><li>Enter your mailbox address and authenticate with your credentials.</li></ol><h3>Step 2: Identifying the Treasure Trove (Emails with Attachments)</h3><p>Power Query will display a list of available folders in your mailbox. Navigate to the folder containing the emails with Excel attachments you want to analyze.</p><p><strong>Pro Tip:</strong> You can filter the emails by sender, subject line containing keywords related to the reports, or received date range to focus on specific datasets.</p><h3>Step 3: Unleashing the Power of Exchange.Contents</h3><ol><li>Select the desired email(s) containing the Excel attachments.</li><li>In the preview pane on the right, locate the “Attachments” column. This is where the magic happens.</li><li>Expand the “Attachments” column by clicking the dropdown arrow. You’ll see details about each attachment, including its name and a crucial element — “Content.”</li></ol><h3>Step 4: Diving into the Binary with Table.FromBinary</h3><p>The “Content” field holds the binary representation of the Excel attachment. To transform it into usable data, we’ll leverage the Table.FromBinary function. Here&#39;s the code snippet that goes into the formula bar:</p><pre>Table.FromBinary(Attachment[Content], BinaryEncoding.Utf8)</pre><p>Replace “Attachment” with the actual name of the attachment column in your query. This function essentially decodes the binary data and attempts to create a table structure based on the Excel sheet’s layout.</p><p><strong>Heads Up:</strong> The data format might not be perfect at this stage. Don’t worry, we’ll wrangle it into shape in the next step.</p><h3>Step 5: Data Transformation Magic</h3><p>The Table.FromBinary function might not always get the table structure exactly right. Here&#39;s where Power Query&#39;s transformation capabilities come into play. Use the Power Query Editor to:</p><ul><li>Rename columns with clear and descriptive names.</li><li>Remove unnecessary rows or columns.</li><li>Adjust data types (e.g., convert text to numbers).</li><li>Filter or sort data based on your analysis needs.</li></ul><p><strong>Remember:</strong> Consistent column headers across all your Excel attachments are crucial for seamless data integration.</p><h3>Step 6: Importing the Transformed Data</h3><p>Once you’re happy with the transformed data structure, you can import it into your Power BI model. Click “Close &amp; Apply” in the Power Query Editor. Power BI will load the data, ready for visualization.</p><h3>Step 7: Visualization Time!</h3><p>Now comes the fun part! Drag and drop the imported data fields into the Power BI workspace. Create charts, graphs, and other visualizations to bring your email-derived insights to life.</p><p><strong>Congratulations!</strong> You’ve successfully automated the process of extracting data from Excel attachments in emails and visualizing them in Power BI using Power Query’s Exchange.Contents function.</p><h3>Bonus Tip: Scheduling Regular Data Refresh</h3><p>Power BI allows you to schedule data refresh at regular intervals. This ensures your visualizations stay up-to-date whenever new reports arrive in your inbox.</p><p>By implementing this approach, you can transform your email inbox from a data graveyard into a treasure trove of insights, all seamlessly integrated into your Power BI dashboards. Now go forth and conquer your data analysis goals!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d6a99d0d9266" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[MICROSOFT SENTINEL: SECURITY WITH CLOUD AND AUTOMATION]]></title>
            <link>https://medium.com/@derrickkuria44/microsoft-sentinel-security-with-cloud-and-automation-4da8370da83c?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/4da8370da83c</guid>
            <category><![CDATA[microsoft-sentinel]]></category>
            <category><![CDATA[security]]></category>
            <category><![CDATA[microsoft-azure]]></category>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Mon, 15 Apr 2024 07:14:05 GMT</pubDate>
            <atom:updated>2024-04-15T07:14:05.621Z</atom:updated>
            <content:encoded><![CDATA[<p>In the current digital era, data is an organization’s essential resource. It strengthens customer relationships, encourages innovation, and powers operations. But safeguarding this asset necessitates strong security measures, just as the crown jewels require a vault. <br> <br>If you are reading this, you are aware that data security is now a must for businesses of all sizes in all sectors and is no longer an option. breaches of data. Any organization, regardless of size, shudders at the mere mention of the term. The consequences are dire: destroyed trust, crippled operations, and lost customer records. However, a new tool in the constantly changing arsenal for data security is the<strong> cloud</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*slQsrlcZZou7QhIqrCgyuQ.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@flyd2069?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">FlyD</a> on <a href="https://unsplash.com/photos/purple-and-pink-light-illustration-C5pXRFEjq3w?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Unsplash</a></figcaption></figure><p>Forget the days of relying on on-premises servers, vulnerable to physical attacks and outdated software. Cloud computing offers a robust, scalable, and constantly upgraded security infrastructure. There are different cloud platforms, but we will concentrate on the Microsoft Azure.</p><p>This article dives into the transformative power of cloud technologies such as <strong>Microsoft Sentinel,</strong> exploring how they’re redefining data security and helping organizations weather the storm of cyber threats. <br> <br> Microsoft Sentinel is a cloud-native Security Information and Event Management (SIEM) platform.</p><p>Think of it as a central command center, collecting data from across your entire IT infrastructure — on-premises, cloud-based applications, user activity, devices, and more. This comprehensive view allows Sentinel to analyze massive datasets, identifying potential threats and suspicious activities that might slip through the cracks of traditional security solutions. In simpler terms It provides a single solution for alert detection, threat visibility, proactive hunting, and threat response.<br> <br> Microsoft Sentinel simplifies onboarding by offering pre-built connectors for various Microsoft security sources, including Defender XDR and Microsoft 365 (Office 365, Entra, etc.), enabling real-time data integration.<br> As a cloud-native solution, Microsoft Sentinel offers several advantages over traditional on-premises SIEM systems.</p><p>Here’s how the cloud empowers your security posture:</p><p><strong><em>1.Scalability: Cloud infrastructure scales effortlessly to accommodate growing data volumes, ensuring your security posture remains robust even as your organization expands.</em></strong></p><p><strong><em>2 . Enhanced Security: Microsoft Sentinel leverages the robust security practices built into the Azure platform, providing a constantly updated and fortified environment for your data.</em></strong></p><p><strong><em>3. Simplified Management: Gone are the days of managing complex hardware and software infrastructure. With Sentinel, management becomes a breeze, allowing your team to focus on what truly matters — securing your organization.</em></strong><br> <br> The real power of Microsoft Sentinel lies in its ability to automate the response. This is where playbooks and automation come into play, transforming threat detection into a well-oiled security machine.<br> <br> <strong>Playbooks: The Symphony of Response</strong></p><p>Imagine a pre-defined script that outlines the steps to take upon detecting a specific threat. That’s the essence of a playbook.</p><p>These customizable workflows automate a series of actions, such as:</p><p>·<strong> Isolating infected machines</strong></p><p><strong>· Blocking malicious IP addresses</strong></p><p><strong>· Enacting password resets</strong></p><p><strong>· Launching forensic investigations</strong></p><p><strong>· Sending notifications to security personnel</strong></p><p>By automating these actions, playbooks ensure a swift and consistent response, saving valuable time for your security team and minimizing the damage caused by an attack.</p><p><strong>The Power of Automation: Streamlining Security</strong></p><p>Playbooks are powerful, but they become truly unstoppable when combined with automation rules. These rules act as triggers, automatically launching the appropriate playbook based on specific criteria within an alert or incident.</p><p>Imagine an alert for suspicious login activity. An automation rule could be configured to automatically trigger a playbook that isolates the device, resets the user’s password, and notifies the security team for further investigation. This eliminates the need for manual intervention, allowing your team to focus on more complex threats.</p><p>With all these mentioned, how does the client benefit?</p><p><strong>The Benefits of Automation:</strong></p><p><strong><em>1.Faster Response Times: Automating actions minimizes human reaction time, ensuring a swift and effective response to threats.</em></strong></p><p><strong><em>2.Reduced Errors: Human error is a significant factor in security breaches. Automation removes this risk, ensuring consistent and accurate execution of response procedures.</em></strong></p><p><strong><em>3.Improved Efficiency: By automating routine tasks, your security team is freed to focus on high-level threat analysis and investigation.</em></strong></p><p>A Secure Symphony:</p><p>Playbooks and automation, working in tandem within Microsoft Sentinel, orchestrate a well-rehearsed security response.</p><p>By automating repetitive tasks and ensuring a consistent response, you can significantly enhance your organization’s security posture and minimize the impact of cyber threats.</p><p>In conclusion, Microsoft Sentinel transcends the realm of a simple data security tool. It’s a comprehensive threat detection and mitigation platform that empowers organizations to safeguard their data in the cloud.</p><p>By harnessing the power of AI, automation, and a vibrant community, Sentinel equips your security team to proactively hunt threats, swiftly respond to incidents, and ensure the ongoing security of your organization’s most dear asset — its data.</p><p>As the threat landscape continues to evolve, Microsoft Sentinel stands as a powerful guardian, offering peace of mind and a secure foundation for your cloud journey.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4da8370da83c" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Noisy Neighbor Syndrome(cloud computing performance)]]></title>
            <link>https://medium.com/@derrickkuria44/noisy-neighbor-syndrome-cloud-computing-performance-02a7d298688e?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/02a7d298688e</guid>
            <category><![CDATA[noisy-neighbors]]></category>
            <category><![CDATA[docker]]></category>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Thu, 25 Jan 2024 08:58:02 GMT</pubDate>
            <atom:updated>2024-01-25T09:12:34.206Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/640/1*na6TS0U7UE2esvUoiag3fQ.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@thips?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Thiébaud Faix</a> on <a href="https://unsplash.com/photos/brown-wooden-human-face-carved-wall-FafRV4gMZ0Q?utm_content=creditCopyText&amp;utm_medium=referral&amp;utm_source=unsplash">Unsplash</a></figcaption></figure><h4>a. What is it?</h4><p>I will first explain this using this analogy. <br>Now, picture yourself sharing a large toy box with your pals. You have your toys, and your friends each have theirs. Let’s imagine for a moment that one of your pals gets thrilled and begins to play loudly and noisily with their toys.</p><p>The “noisy neighbor syndrome” in cloud computing is similar to that noisy friend. This is what happens when one program or computer (like your friend with the noisy toys) utilizes a lot of memory or processing power and interferes with the functionality of other programs or computers that share the same area, in this case, the cloud.</p><p>Thus, in the same way, that you find it difficult to focus on your toys while your friend is making a lot of noise, other programs in the cloud might have trouble working properly if one program is using too many resources. The different programs need to play nicely and not be too loud so that everyone can do their work without any problems.<br>The cloud is a multi-tenant environment, which means that a single architecture hosts multiple customers’ applications and data.</p><p>In the context of Docker, the &quot;<strong>Noisy Neighbor Syndrome</strong>&quot; refers to a situation where one container consumes a disproportionate amount of system resources, negatively impacting the performance of other containers running on the same host. Containers in Docker share the host system&#39;s resources, such as CPU, memory, and I/O, and if one container becomes resource-intensive, it can affect the overall stability and efficiency of the entire system.</p><h4>b. Disadvantages of Noisy Neighbor Syndrome in Docker:</h4><ol><li><strong>Performance Degradation:</strong> When one container uses excessive resources, it can lead to performance degradation for other containers on the same host. This might result in slower response times and overall reduced system efficiency.</li><li><strong>Unpredictable Behavior:</strong> Noisy neighbors can cause unpredictable behavior, as containers might not get the resources they need when required. This can lead to application instability and unexpected downtime.</li><li><strong>Resource Contention:</strong> Containers may compete for resources like CPU and memory, causing resource contention. This contention can affect the responsiveness of applications and lead to bottlenecks.</li></ol><h4>c. How to Avoid or Mitigate Noisy Neighbor Syndrome in Docker:</h4><ol><li><strong>Resource Limits and Reservations:</strong></li></ol><ul><li><strong><em>Resource Limits:</em></strong> Set resource limits for each container to ensure they don&#39;t consume more than a specified amount of CPU, memory, or other resources. This helps prevent one container from monopolizing resources.</li><li><strong><em>Resource Reservations:</em></strong> In addition to setting limits, you can also use reservations to guarantee a minimum amount of resources for a container. This helps ensure that critical containers receive the necessary resources even if the system is under heavy load.</li></ul><p>2. <strong>Use Docker Compose:</strong></p><ul><li>Docker Compose allows you to define and manage multi-container Docker applications. By using Docker Compose, you can specify resource constraints for each service, helping to prevent one service from impacting others.</li></ul><p>3. <strong>Container Orchestration:</strong></p><ul><li>Container orchestration tools like Kubernetes or Docker Swarm can automatically distribute containers across multiple hosts, preventing resource contention on a single host. These tools also provide features for resource allocation and scaling based on demand.</li></ul><p>4.<strong> Monitoring and Alerts:</strong></p><ul><li>Implement monitoring solutions to keep track of resource usage by containers. Set up alerts to be notified when resource usage exceeds predefined thresholds, allowing you to address potential issues before they impact other containers.</li></ul><p>5.<strong> Periodic Review and Optimization:</strong></p><ul><li>Regularly review and optimize container configurations. Ensure that resource limits are appropriate based on the application&#39;s requirements, and make adjustments as needed.</li></ul><h4><strong>d. Conclusion</strong></h4><p>By implementing these strategies, you can minimize the impact of Noisy Neighbor Syndrome in Docker environments and maintain a stable and efficient containerized infrastructure.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=02a7d298688e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[DataFlows vs DataMarts for Power BI]]></title>
            <link>https://medium.com/@derrickkuria44/dataflows-vs-datamarts-for-power-bi-c9244dd17288?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/c9244dd17288</guid>
            <category><![CDATA[dataflow]]></category>
            <category><![CDATA[data-mart]]></category>
            <category><![CDATA[microsoft-fabric]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Wed, 20 Dec 2023 12:07:39 GMT</pubDate>
            <atom:updated>2023-12-20T12:07:39.615Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/696/1*Jm_XUR7m_d8smVksevnFNg.png" /></figure><p>What is a dataflow? What is a Datamart? <br> Is there a significant difference between the two? <br> Can they be used alternatively or does each of them have their use case? <br> If you have asked yourself either of these questions, then I believe you are at the right place and I hope you can get your answer here. Let&#39;s go!</p><p>DATAFLOWS</p><p><strong><em>Definitions</em> </strong><br> <br> 1. A dataflow is positioned as a packaged transformation ETL that you want to do. A good example would be a calendar table for organization<br> 2. It is simply a collection of tables that are created and managed in workspaces in the Power BI service.<br> A table is a set of columns that are used to store data, much like a table within a database. This means this solution does not work on the Power BI desktop. Using dataflows can enhance the development and maintenance of your Power BI solutions significantly.</p><p>Dataflows provide reusable extract, transform, and load (ETL). After loading the Data through Power Query Online, they store the data in a built-in SQL database instead of a data lake.<br> Dataflows are quite extensive when generating SQL queries. This is achieved by the click GUI actions. <br> <br> Multiple scenarios would work perfectly for using dataflows. <br> <br><em> </em><strong><em>Example 1.</em></strong><em> </em><br> Instead of creating a view on your Database, one can load in the tables and create a dataflow with the query steps that would need to replicate the view, and this would create the same sort of functionality. <br> <br><strong><em> Example 2.</em></strong> <br> Creating a calendar table that can be reused by other users. <br> <br><strong><em> Example 3. </em></strong><br> Hierarchies and groupings that exist in an organization. <br> <br> <strong><em>Example 4.<br></em></strong>Sometimes, in your Power Query (Power BI Desktop) you may have many/ heavy steps that make the refresh process longer. You can use Dataflows and have them refresh before the rest of the Semantic models refresh hence relieving the refresh process.</p><p>In Dataflows Tables can’t be browsed, queried, or explored without a semantic model, but can be defined for reuse. The data is exposed in Power BI or CDM format if you bring your own data lake. Dataflows are used by Power BI to ingest data into your Datamarts. You should use dataflows whenever you want to reuse your ETL logic.<br> Now what is a DataMart?</p><p>DATAMARTS</p><p>This is the new feature announced at Build2022 by Microsoft. It is a subset of an organization’s data warehouse that is designed to serve a specific business function or group of users.<br> Datamarts are self-service analytics solutions, that enable users to store and explore data that is loaded in a fully managed database. Datamarts provides a simple and optionally no-code experience to ingest data from different data sources, extract transform, and load (ETL) the data using Power Query, then load it into an Azure SQL database that’s fully managed and requires no tuning or optimization.<br> <br> Although it sounds almost the same as dataflows, Datamarts are smaller and are a more focused database that is tailored to the needs of a particular department or business unit. However, Datamarts could pull from various data sources and have different dimensions that are connected by relationships.</p><p>Some minimal disadvantages to Datamarts include refreshing issues. By this I mean, if there is a need to refresh the Datamarts, it is not possible as of June 2023 to refresh a table only in the Datamarts. It would need to refresh all the tables. For Such scenarios, it would be better to use the Datasets for this. <br> <br> Datamarts are also quite useful to users who do not have access to Power BI Desktop. It allows the modeling capabilities by allowing a web experience to non-Windows users without relying on Power BI desktop that can only be accessed on a Windows OS. <br> <br>.The best distinction between the two is that Dataflows are about specific and individual Dimensions/ tables. Datamarts however is more heroic and fully fledged where it has multiple tables from multiple sources. <br> <br> I hope you now have more answers than questions. Feel free to leave a comment on other functionalities and differences.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c9244dd17288" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Dealing with multiple currencies in Power BI]]></title>
            <link>https://medium.com/@derrickkuria44/dealing-with-multiple-currencies-in-power-bi-3b0ba4ce6190?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/3b0ba4ce6190</guid>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Thu, 06 Jul 2023 14:02:32 GMT</pubDate>
            <atom:updated>2023-07-06T14:02:32.250Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*M4O2sSedV7sIIZdf9mqbFg.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@snowjam?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">John McArthur</a> on <a href="https://unsplash.com/s/photos/currencies?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>In most monetary data or data that has a monetary column, it is highly likely that that column is not in the same currency. This will then mean that there will be an additional Currency column that will stipulate all the transactions&#39; currency.</p><p>For such a case, we will need to convert all the monetary currency figures into one base currency so that when we do basic descriptive statistics like sum and mean we can have the expected value.</p><p>But remember, all the currencies represented in the data are important as the base currency we convert to. This means we will have to use a slicer to check the aggregations in the constituent Currencies. This blog will explain how we go about that.</p><h4>Step 1</h4><p>Load the Data.</p><p>Mostly these data rows will be transactions. Identify the Monetary column which could be Amount, Sales, Price, Purchase Amount, Cost, etc.</p><p>Also, Identify the currency column. This could have the currencies in the entries eg. USD, EUR, JPY, AUD, etc.</p><h4>Step 2</h4><p>Have the currency conversions</p><h4><strong>USD to USD =1</strong></h4><h4><strong>EUR to USD =1.09</strong></h4><h4><strong>JPY to USD = 0.0069</strong></h4><h4><strong>AUD to USD = 0.67</strong></h4><h4>Step 3</h4><p>Convert the Monetary Column to one currency base currency column. For our example, we shall fix our Cost column to have a base currency of USD. We will assume our data has the above currencies. Our table is the sales table.</p><p>Here is the DAX to create the column in the Sales table.</p><p><em>Cost_USD = SWITCH(TRUE(),</em></p><p><em>sales[CurrencyCode] = “USD”,sales[Cost]* 1,</em></p><p><em>sales[CurrencyCode]= “AUD”, (sales[Cost]*0.67,</em></p><p><em>sales[CurrencyCode]= “JPY”,(sales[Cost]*0.0069,</em></p><p><em>sales[CurrencyCode]= “EUR”, (sales[Cost]*1.09)</em></p><p>With this, you can now perform aggregates on this column and the</p><h4>Step 4</h4><p>To view the aggregations in different currencies, we will need a table with the conversions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/190/1*PifnZrJlAnfVBcBm_gRjyA.png" /><figcaption>Currency table in Power BI</figcaption></figure><p>For the sum of the Sales Cost, We will create three measures. These measures are the SUM of Sales Cost in USD and the SUM of Sales Cost in other currencies.</p><p>i)Sales in USD</p><p><em>Sales_Cost = SUM(Sales[Cost_USD])</em></p><p>ii) This is a measure to select the currency. We will reference the values of the Currency codes</p><p><em>Selected_currency = VALUES(‘Currency Table’[Currency])</em></p><p>iii) The third measure for the SUM in different currencies will be as follows.</p><p><em>Sales_Cost (Selected Currency) = SWITCH (TRUE(),</em></p><p><em>[Selected_currency] =”USD”,[Sales_Cost]/VALUES(‘Currency Table’[Rate]),</em></p><p><em>[Selected_currency] =”JPY”,[Sales_Cost]/VALUES(‘Currency Table’[Rate]),</em></p><p><em>[Selected_currency] =”EUR”,[Sales_Cost]/VALUES(‘Currency Table’[Rate]),</em></p><p><em>[Selected_currency] =”AUD”,[Sales_Cost]/VALUES(‘Currency Table’[Rate]),</em></p><p><em>[Sales_Cost])</em></p><p>This enables the conversion of Currencies to different other currencies</p><h4><em>Step 5</em></h4><p>Add a slicer to the dashboard. Select the currencies from the currency table and in the slicer settings ensure to have the Single Select turned on.</p><p>Now you can add a card with the <em>Sales_Cost (Selected Currency) </em>value and try to see if the value changes as you select different currencies.</p><p>Thank you very much. Reach out to me on twitter @Kuria_Muiru for any issues. Also I would appreciate a follow on my Medium blog.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3b0ba4ce6190" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power BI DAX — Aggregation Functions]]></title>
            <link>https://medium.com/@derrickkuria44/power-bi-dax-aggregation-functions-16240c637184?source=rss-b517bb42ccb1------2</link>
            <guid isPermaLink="false">https://medium.com/p/16240c637184</guid>
            <category><![CDATA[aggregation]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[dax]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[bi]]></category>
            <dc:creator><![CDATA[Derrick Kuria]]></dc:creator>
            <pubDate>Mon, 03 Jul 2023 07:24:42 GMT</pubDate>
            <atom:updated>2023-07-03T07:24:42.358Z</atom:updated>
            <content:encoded><![CDATA[<h3>Power BI DAX — Aggregation Functions</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Tw6ayPHSIR7mIa0JoukMlg.jpeg" /><figcaption>Aggregations</figcaption></figure><p>Power BI is a powerful business intelligence tool that provides various functions for data aggregation and analysis. A number of aggregation features in Power BI can be utilized to condense and summarize the data. These operations can be used to determine a set of data’s sum, average, minimum, maximum, count, and other statistics. They simply calculate a scalar value. for all rows in a column or a table.</p><ol><li>SUM — The SUM function calculates the sum of all the values in a numeric column. <em>Example: If you have a table of sales data with a “Sales Amount” column, you can use the SUM function to calculate the total sales amount:</em></li></ol><pre>Total Sales = SUM(SalesData[Sales Amount])</pre><p>2. AVERAGE — The AVERAGE function calculates the average of all the values in a numeric column. This simply means it sums all values in the numeric column and divides it by the count of values. <em>Example: A perfect example would be a company taking ratings of customer service from its clients.</em></p><pre>Average Rating = AVERAGE(Clients_feedback[Rating_Score])</pre><p>3. MIN — The MIN function returns the smallest value from a numeric column. It finds the smallest value in the specified column. <em>Example: If you have a table of employee salaries with a “Salary” column, you can use the MIN function to find the minimum salary:</em></p><pre>Minimum Salary = MIN(EmployeeData[Salary])</pre><p>4. MAX: The MAX function returns the largest value from a numeric column. It finds the largest value in the specified column. <em>For exampl</em>e<em>, the following code would return the largest sales value in the “Sales” column:</em></p><pre>Maximum Sales = MAX(Sales[SalesAmount])</pre><p>5. COUNT: The COUNT function counts the number of rows in a table or column. It returns the total count of values in the specified column. <em>Example: If you have a table of Sales data with a “Salesperson” column, you can use the COUNT function to count the number of Salespersons:</em></p><pre>Total Customers = COUNT(SalesData[Salesperson ID])</pre><p>6. COUNTA: The COUNTA function counts the number of non-blank cells in a column. It returns the count of all non-empty values in the specified column. The COUNTA function counts rows that contain the following kinds of values: numbers, dates, strings, and logical <em>Example: If you have a table of client orders with a “Product Name” column, you can use the COUNTA function to count the number of products ordered:</em></p><pre>Total Products Ordered = COUNTA(OrderData[Product Name])</pre><p>7. COUNTAX: The COUNTAX function counts nonblank results when evaluating the result of an expression over a table. It takes two arguments: a table or an expression that evaluates to a table, and a Boolean expression that defines the condition. <em>Example: Let’s say you have a table of sales transactions called “SalesData” with columns like “Product”, “Region”, and “Quantity”. You want to count the number of sales transactions where the quantity is greater than 10. You can use the COUNTAX function as follows:</em></p><pre>Sales Transactions &gt; 10 = COUNTAX(FILTER(SalesData, SalesData[Quantity] &gt; 10), SalesData[Product])</pre><p>8. DISTINCTCOUNT: The DISTINCTCOUNT function counts the number of unique values in a column. It returns the count of distinct values in the specified column.</p><p><em>Example: If you have a table of sales transactions with a “Product ID” column, you can use the DISTINCTCOUNT function to count the number of unique products sold:</em></p><pre>Unique Products Sold = DISTINCTCOUNT(SalesData[Product ID])</pre><p>9. STDEV.P: The STDEV.P function calculates the population standard deviation of a numeric column. It measures the amount of variation or dispersion in the data.</p><p><em>Example: Let’s consider a table called “SalesData” with a column named “Revenue” that represents the revenue generated by different products. You can use the STDEV.P function to calculate the population standard deviation of the revenue:</em></p><pre>Population Standard Deviation = STDEV.P(SalesData[Revenue])</pre><p>This formula will compute the population standard deviation of the “Revenue” column in the “SalesData” table. It provides a measure of how spread out the revenue values are across the entire population.</p><p>10. STDEV.S: The STDEV.S function calculates the sample standard deviation of a numeric column. It estimates the population standard deviation based on a sample of data.</p><p><em>Example: If you have a table of student test scores with a “Score” column, you can use the STDEV.S function to calculate the sample standard deviation of scores:</em></p><pre>Score Standard Deviation = STDEV.S(TestData[Score])</pre><p>11. AVERAGEA — The AVERAGEA function in Power BI is an aggregation function that returns the average of the values in a column, including non-numeric data types. This means that the AVERAGEA function will consider the text and logical values as well as numbers when calculating the average.</p><p>The AVERAGEA function works according to the following rules:</p><ul><li>Values that evaluate TRUE count as 1.</li><li>Values that evaluate to FALSE count as 0 (zero).</li><li>Values that contain non-numeric text count as 0 (zero).</li><li>Empty text (“”) counts as 0 (zero).</li></ul><p>12. Averagex — Calculates the average (arithmetic mean) of a set of expressions evaluated over a table. This means that the AVERAGEX function can be used to calculate the average of a set of values that are not necessarily in the same column. <em>For example, the following code would calculate the average of the sales for each product category, excluding any rows where the sales value is null:</em></p><pre>Average Sales =AVERAGEX(<br>    SalesTable,<br>    If(Sales &lt;&gt; Null, Sales, 0)<br>)</pre><p>13. Countblank — Counts the number of blank cells in a column. The COUNTBLANK function is similar to the COUNT function, but the COUNT function will count all cells in a column, including blank cells.By using the COUNTBLANK function, you can get an accurate representation of the number of blank cells in a column.</p><p>14. SUMX — Returns the sum of an expression evaluated for each row in a table. The SUMX function takes as its first argument a table, or an expression that returns a table. The second argument is a column that contains the numbers you want to sum or an expression that evaluates to a column. <em>Example: Suppose you have a table named “Sales” with columns like “Product”, “Quantity”, and “Price”. You want to calculate the total revenue by multiplying the quantity and price of each product. You can use the SUMX function as follows:</em></p><pre>Total Revenue = SUMX(Sales, Sales[Quantity] * Sales[Price])</pre><p>These are just a few examples of Power BI aggregation functions. I will be doing other blogs of other subsections of DAX Functions. Happy Learning!</p><p>Feel free to follow my blog and share a post. Tag me on Twitter @Kuria_Muiru</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=16240c637184" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>