PinnedDerrick Kuria·Dec 20, 2023DataFlows vs DataMarts for Power BIWhat is a dataflow? What is a Datamart? Is there a significant difference between the two? Can they be used alternatively or does each…
PinnedDerrick Kuria·Jul 3, 2023Power BI DAX — Aggregation FunctionsPower BI is a powerful business intelligence tool that provides various functions for data aggregation and analysis. A number of…
PinnedDerrick Kuria·Aug 6, 2022SEND EMAIL REMINDERS LIKE A BOSS USING POWER AUTOMATEWe, humans, do forget. But Machines do not. 😊So if you find yourself forgetting stuff that you should do at a regular interval like…A response icon1A response icon1
PinnedDerrick Kuria·Sep 27, 2021DATA AND DATA COLLECTION1. What is Data and Data Collection?A response icon1A response icon1
Derrick Kuria·Feb 8, 2025MIXPANEL — The Analytics tool you are possibly ignoringIn the fast-paced world of data analytics, staying ahead of the curve is crucial. Yet, amidst the plethora of tools available, one…
Derrick Kuria·Feb 8, 2025Azure Data Factory Tips ,Tricks and Best Practices.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…
Derrick Kuria·May 21, 2024Why Data Engineers Should Embrace SSASSQL Server Analysis Services (SSAS) may not be the most popular big data solution on the market, but for data engineers, it remains a…
Derrick Kuria·May 8, 2024Breaking the 100-Get Items Barrier : Working with Larger Datasets in Power AutomateMicrosoft Power Automate (formerly Microsoft Flow) is a powerful tool for automating workflows, but sometimes you need to work with more…
Derrick Kuria·May 4, 2024Unleashing Email Insights: Importing Excel Attachments into Power BI with Power QueryImagine a world where you don’t have to manually copy and paste data from Excel attachments scattered across your inbox into Power BI.
Derrick Kuria·Apr 15, 2024MICROSOFT SENTINEL: SECURITY WITH CLOUD AND AUTOMATIONIn the current digital era, data is an organization’s essential resource. It strengthens customer relationships, encourages innovation, and…