Learn Pivot Tables for data analysis (Pivot Tables from A to Z)

All what you need to know about pivot tables, from the very beginning to the advanced level including:

Basics: create, design, layout, refresh and update
Grouping of dates, text fields, and numeric values
Calculations inside Pivot Table: Calculated fields and items
Creation of multiple reports based on filter options
Visualization: custom layout, pivot charts and slicers, conditional formatting and dashboards
Pivot Tables and Power Query, Pivot Tables and Power Pivot and more

Watch Now

Welcome to Power Query, learn it from the very beginning

Power Query is life changing tool for professionals working with data. No matter if you are an accountant, banker, analyst, teacher, HR professional or an engineer, if you are working with data, power query is your Swiss Army Knife that you have to keep in your pocket

A series of power query tutorials for beginners, taking you from the very beginning to the intermediate level. below each video you will find a link to the working file (solved and unsolved) to help you to practice and to apply concepts explained in the video.

Watch Now

Drive from a beginner to the advanced level (APQ)

This series begins with a strong introduction to "M" language in 3 parts that are indispensable to understand the query structure & how it works. It also explains and simplify how custom functions and parameters work. Then, it will take you around a selection of "M" language functions that are essential for importing & transforming data in a professional way

Watch Now

It is not enough to watch, participate in Power Query Challenges

This group of tutorials aims to motivate followers & mobilize their skills to solve Power Query challenges. The target is the serious followers of intermediate/advanced level

The challenge is presented in a short video, participants can share their solutions via e-mail, in a separate video, the solution is presented in details, along with the names of the participants at the end of the video

Watch Now

Take your Excel knowledge to the next level (PP for Power Pivot)

This Series will take you step by step in the Power Pivot journey, starting from the very beginning and every episode will advance you smoothly one level up. In the later chapters, you will see how you can apply the exact same techniques in Power BI. Videos are inclusive of a simplified explanation for each topic supported by a practical example to link the theory with the application. You can download the working files and follow along, or practice after watching

Read Now

Articles

Data Cleaning

AFP Roundtable

Pricing Strategy & Cost Management

CAIRO, April 23

I was horned to speak at and facilitate the roundtable that took palce in CAIRO and sponsored by AFP (Association for Financial Professionals).

The roundtable was discussing Pricing & Cost management and the role of FP&A analyst to evaluate pricing strategy & to drive cost management.