learn power query

Career Data

Introduction To Statistics For Data Analysts — New Course!

Considering a new career path? Then check out this video from Enterprise DNA. As Data Analysts, we are constantly drawing conclusions from sample data about larger populations. Here at Enterprise DNA, our goal is to equip Data Analysts like you with the full suite of knowledge and skills you need to excel and continue to grow […]

Read More
PowerBI

How to Use DAX In Power BI to Do Multi-layered Scenario Analysis

Expand your thinking around what’s possible with Power BI! What you can achieve from an analytical perspective with DAX is incredible. In this video, Sam demonstrates how you can layer multiple scenarios into your analysis through supporting tables and slicers applied in a Sales & Profit data.

Read More
PowerBI

Harvest Power BI Slicer Selections To Use With Other Measures — Advanced DAX [2022 Update]

In this tutorial, Sam shows how to write an advanced DAX formula to harvest (capture) a selection made within a slicer visual then integrate that back into other measure calculations.

Read More
PowerBI

An Introduction to Deneb: Declarative Visualization In Power BI – New Course!

Deneb is a custom visual for Power BI, which allows the use of declarative JSON syntax of the Vega or Vega-Lite languages to build custom data visualizations, without having the need to learn web development. In this video, Brian chats with our resident Deneb expert, Greg Philps, as they introduce and give an overview on […]

Read More
Data

How Power Query Will Change the Way You Use Excel

Leila Gharani explains why PowerQuery is such a powerful tool. Excel Power Query has been a part of Excel since Excel 2016! It’s in the Data tab under Get and Transform. Unfortunately many people haven’t explored what it has to offer! They continue doing things the old “manual” way, Or the “complex” way with difficult […]

Read More