top of page
Search
Power Query: Mastering Date and Time in "From Date & Time" Section
Dates and times are the backbone of almost every dataset. From analyzing sales trends to tracking project deadlines, your ability to work with temporal data is a key skill for any data professional. Yet, raw date columns can be messy and hard to analyze. Manually extracting years, months, or quarters is a tedious and error-prone process.
Fakhriddinbek
8 hours ago3 min read
Power Query: Deep Dive into Power Query's "From Number" Section in Add Column
Raw data often contains numerical fields that aren't ready for analysis. They might need a simple calculation, a quick rounding, or a change to their sign. While you could write complex formulas in a custom column to handle these tasks, Power Query provides a powerful, user-friendly alternative: the From Number section of the Add Column tab. This suite of tools automates common numerical transformations, allowing you to clean, prepare, and enrich your data with just a few cli
Fakhriddinbek
9 hours ago3 min read
Power Query: Data Cleaning with a Comprehensive Guide for From Text section of Add Column
While many of Power Query's features are designed for structural changes, the Power Query: Data Cleaning with a Comprehensive Guide for From Text section of Add Column and its counterparts are where you do the detailed work of standardizing and correcting your data at a granular level. This guide will walk you through the essential transformations for text, numbers, and dates, showing you how to turn your messy raw data into a clean, trustworthy dataset ready for analysis.
Fakhriddinbek
9 hours ago4 min read
Power Query: Creating Custom Columns a Comprehensive Guide in Add Column's General Section
Power Query is famous for its pre-built transformations, but its true power is unlocked when you start creating your own custom columns. While the Add Column tab offers a wide array of options for adding columns based on text, numbers, or dates, the General section is where you take control. It allows you to build columns with your own custom logic, providing a level of flexibility that is essential for complex data cleaning and analysis.
Fakhriddinbek
9 hours ago3 min read
bottom of page