Tech

How to Automatically Save Outlook Emails as Text Files with PowerShell

Save Outlook Emails as Text Files

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, …

Read more

How I Increased my Earning Capacity by 20% with the PL-300 Power BI Data Analyst Certification

PL-300 Power BI Data Analyst Certification

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 …

Read more

Mastering Pivot Unpivot and Transpose in Power BI Power Query

Pivot, Unpivot, and Transpose in Power BI Power Query

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 …

Read more

Extracting Data from Power BI Reports with Python and Power Automate

Extracting Data from Power BI Reports with Python and Power Automate

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 …

Read more

Automate Folder Renaming with Python and Excel: A Step-by-Step Guide

python with data

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 …

Read more

How to Effortlessly Combine Excel Files using Python and Pandas

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 …

Read more

Data Analysis with the SWITCH and RELATED Functions using PowerBI’s DAX

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 …

Read more

How to insert data from an xlsx file into a MySQL database with Python?

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 …

Read more