Tiny Lizard

Power Pivot Consulting and Training

  • About
  • Blog
  • Power Pivot
  • Training
  • Contact

Review: Analyzing Data with Power BI and Power Pivot for Excel

June 20, 2017 By Scott Senkeresty 2 Comments

AnalyzeDataI ran into The Italians at the Data Insight Summit and naturally… gave them a very-Scott-like very-awkward group-hug.   I don’t actually know these guys super well, but I certainly love them… so they get hugs.  Suck it up.

My love comes from a genuine admiration of both their deep technical knowledge/skills and their amazing desire to help people learn these technologies.  Hell, if you make a mistake in your blog… Marco is gonna show up to correct you.  He is awesome like that.  And I legitimately don’t understand how they find the time to teach and travel and consult… and still have time to write books?!  Impossible.  When I get busy with clients, I don’t even find the time to write blog entries.  Do they sleep!?

Their previous book, The Definitive Guide to DAX is not misnamed.  It starts off with simple foundational concepts and then… crushes your brain with knowledge.  It’s probably about time for me to re-read it… even though there are some paragraphs I read a dozen times.

Their newest book, Analyzing Data with Power BI and Power Pivot for Excel is… once again… required reading.

If I was super glib (and knew if I was using the term “glib” correctly) I would say the book could be summarized with “Look, you rat bastards… if you don’t create a star schema, YOU GONNA DIE!”.  But, that would be both a bit excessive and a bit simplistic.  The examples are great at reinforcing why other models will create complications and super un-fun DAX… and reinforces this through a series of examples as it related to Calendar tables, snapshot data, currencies, etc.  The insights on thinking about and handling mismatched granularities is just excellent.

While I love to give Marco and Alberto a hard time about creating books and lectures that are too technical and a bit hard to read… they get mad props for making this book super accessible.  There are a few gnarly DAX expressions… but they are primarily provided to show you how complicated things can get without a proper data model.

A “Great Job!” to The Italians and strong recommendation that you pick up this great book.

  • About Scott
  • Latest Posts
  • Contact

About Scott Senkeresty

Scott Senkeresty here… Founder and Owner of Tiny Lizard. Yes, I have done some stuff: A Master’s Degree in Computer Science from California Polytechnic State University in beautiful San Luis Obispo, California. Over twelve years developing software for Microsoft, across Office, Windows and Anti-Malware teams… Read More >>

  • The streak is alive! – August 10, 2017
  • DAX KEEPFILTERS Plus Bonus Complaining! – July 20, 2017
  • VAR: The best thing to happen to DAX since CALCULATE() – July 11, 2017
  • Review: Analyzing Data with Power BI and Power Pivot for Excel – June 20, 2017
  • Power BI Date Table – June 2, 2017

View All Posts

Scott Senkeresty here… Founder and Owner of Tiny Lizard. Yes, I have done some stuff: A Master’s Degree in Computer Science from California Polytechnic State University in beautiful San Luis Obispo, California. Over twelve years developing software for Microsoft, across Office, Windows and Anti-Malware teams… Read More >>

VAR: The best thing to happen to DAX since CALCULATE()
DAX LASTDATE( ) function

Filed Under: Power Pivot

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 307 other subscribers

Comments

  1. Marco Russo says

    June 20, 2017 at 3:22 am

    I’m so glad we have been able to convey exactly the message we needed to transfer. DAX is powerful, but you can do amazing things before you need it. Keep your model simple, do your homework preparing data, and life is much easier.
    Regarding your summary… yes, it’s really excessive and simplistic… but it’s absolutely funny!
    Thanks!

    Reply
  2. John McNally says

    June 20, 2017 at 1:47 pm

    Hi Scott,
    Agreed… Just finished reading the book, and it is superb. A must for gaining a deeper understanding of the impact data modeling has on the DAX formulas you create. Your review is right on target.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Latest Blog Posts

  • The streak is alive! August 10, 2017
  • DAX KEEPFILTERS Plus Bonus Complaining! July 20, 2017
  • VAR: The best thing to happen to DAX since CALCULATE() July 11, 2017
  • Review: Analyzing Data with Power BI and Power Pivot for Excel June 20, 2017
  • Power BI Date Table June 2, 2017

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 307 other subscribers

Copyright © 2025 Tiny Lizard

MENU
  • About
  • Blog
  • Power Pivot
  • Training
  • Contact