• Skip to main content
  • Skip to footer

T-Shaped Analytics

Making Data Analysts Successful

  • About
    • About
    • Portfolio
    • Work with us
  • Links
    • Helpful Links
    • Job Search App
  • Slides
  • Meetup
  • LinkedIn

DAX and Power BI Training

Session 4 – Data Visualization and DAX

Data Visualization Checklist

Connect Excel to Power BI

Exercise Files: Data Visualization Excercise File, DAX Excercise File

Power BI Desktop and Power BI Service: Power BI YouTube Playlist

Power Query Books: Chris Webb Power Query Book, Ken Puls Power Query Book,

Power Pivot Books: Rob Collie DAX Book, Matt Allington DAX Book

User Group: Nashville Excel & Power BI User Group

 

Session 3 – Power Pivot and DAX

PowerPivot Model Checklist

Exercise Files: PowerPivot Model Files, DAX Excercise File

Resources: Chris Webb Power Query Book, Ken Puls Power Query Book, Rob Collie DAX Book, Matt Allington DAX Book

Nashville Excel & Power BI User Group

 

Session 2 – Power Query and DAX

Requirements: Download and install Power Query for Excel 2013.  If you have Excel 2016, than you already have Power Query (on the Data tab).

Agenda

Exercise and Homework Checklist

Exercise Files: Power Query Exercises Excel File, Pricing Analysis Excel File with Level 1 DAX

Intro to Power Query Slides

DAX Level 4 Slides

 

Session 1 – DAX and Benefits of Power BI

Requirements: Excel 2013 or 2016 (64 bit preferred), Power BI Desktop (free download).
Prerequisites: Basic knowledge of Excel Pivot Tables.

Agenda

Exercise and Homework Checklist

DAX Order of Operations Cheat Sheet

Exercise Files: Pricing Analysis Excel File, Pricing Analysis Power BI Desktop File

Overview Slides

DAX Level 1-3 Slides

Power BI Desktop Slides

Footer

Contact Us

will@t-shapedanalytics.com

(615) 335-3887

Power BI

"The work you guys have done for us has been invaluable...One of the highlights of my time here has been working on our fantastic PowerPivot reports."

- Turner F.

Web Development

"Thank you for being so responsive!"

- Karen S.

Copyright © 2023 · Digital Pro on Genesis Framework · WordPress · Log in