Save Outlook Emails as Text Files effortlessly using PowerShell to automate the archiving process. In the vast digital workspace, managing an overflowing inbox can be a daunting task for professionals across all sectors. The need to efficiently archive important emails for compliance, reference, or decluttering purposes is more pressing than ever. Automation, specifically through PowerShell, …
The PL-300 Power BI Data Analyst certification marked an important moment in my career, validating my skills in using Power BI for data-driven decisions and directly contributing to a more than 20% increase in my earning capacity right after I got certified. In the dynamic field of data analytics, choosing the right certification can significantly …
In this blog post, I’ll focus on the practical use of Pivot Unpivot and Transpose in Power BI Power Query, key tools for restructuring your data to better align with your analysis goals. We aim to share useful tips and insights to enhance your efficiency and understanding of these functions, making it easier to tailor …
Calculating MODE in DAX is a key statistical task when working with data in Power BI or other platforms that employ Data Analysis Expressions (DAX). Given that DAX lacks a native MODE function, it’s necessary to devise our own method for determining the most frequently occurring value in a dataset. This blog post will delve …
Have you ever faced the challenge of managing hundreds of Power BI reports and found yourself unsure about the data sources they connect to? I offer a straightforward solution which is tested in the real world – extracting data from Power BI reports with Python and Power Automate. Essentially, we are going to build a …
Automate folder renaming with Python and Excel to make managing data and keeping your files organized more efficient in today’s digital age. Handling vast amounts of data as a professional or simply maintaining personal files in order can be time-consuming and complex. To address this challenge, I’ve developed a comprehensive step-by-step guide that demonstrates how …
In today’s data-driven world, the ability to combine Excel files using Python and Pandas is essential for handling large amounts of data from various sources. We often find ourselves working with multiple Excel files that need to be merged into a single file for further analysis. In this blog post, we’ll delve into a straightforward …
The power of data analysis lies in the ability to manipulate and transform data to suit your business requirements. The Data Analysis Expressions (DAX) language plays a pivotal role in helping you achieve this within Power BI. In this blog post, I will dive into a practical example, demonstrating how to create a SLAStandard column …
In different environments we as IT professionals have to approach matters in various ways. Data comes in many forms, shapes, and sizes. One of the issues I recently had was how to insert data from a .xlsx file into a MySQL database with Python. I will dive into it and share the code, as well …
Often when I’m preparing a dataset in Power BI just importing tables from sources does not suffice. Because of the intricate requests from the business side – I continuously need to use data manipulation with SQL. In this blog post, I will share how to make the best of an annoying situation with SQL. Some …