This workshop is a complete video course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language.

The goal of the course is to teach all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios. The course is made of more than 15 hours of lectures, and other 15-20 hours of individual exercises. You can watch the videos at anytime and the system will keep track of your advances. Within the course you can download the material for all the exercises.

Students of the video course have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.


  • Presentation of Mastering DAX 2nd Edition

    • Presentation of Mastering DAX 2nd Edition
  • Exercises, labs, slides, and demos

    • How to download and complete exercises
    • Download demos
    • Download exercises
    • Slides of the video course
  • Introduction to DAX

    • Introduction to DAX
    • What is DAX?
    • DAX data types
    • Calculated columns
    • Measures
    • Aggregation functions
    • Counting values
    • Conditional functions
    • Handling errors
    • Using variables
    • Mathematical functions
    • Relational functions
    • Exercises
  • Table functions

    • Table functions
    • Introduction to table functions
    • Filtering a table
    • Ignoring filters
    • Mixing filters
    • Distinct
    • How many values for a column
    • Tables and relationships
    • Tables with one row and one column
    • Table variables
    • Exercises
  • Evaluation contexts

    • Evaluation contexts
    • Introduction to evaluation contexts
    • Filter context
    • Row context
    • Context errors
    • Filtering a table
    • Using RELATED in a row context
    • Ranking by price
    • Evaluation contexts and relationships
    • Filters and relationships
    • Exercises
  • The CALCULATE function

    • The CALCULATE function
    • CALCULATE examples
    • CALCULATE recap
    • What is a filter context?
    • CALCULATE operators
    • Use one column only in compact syntax
    • Variables and evaluation contexts
    • Exercises
  • Advanced evaluation contexts

    • Advanced evaluation contexts
    • CALCULATE modifiers
    • ALL
    • Context transition
    • Context transition /2
    • Circular dependency
    • CALCULATE execution order
    • Exercises
  • Iterators

    • Iterators
    • Working with iterators
    • MINX and MAXX
    • Useful iterators
    • RANKX
    • Exercises
  • Building a date table

    • Building a date table
    • Introduction to date table
    • Auto Date/Time
    • Mark as date table
    • Using multiple dates
  • Time intelligence in DAX

    • Time intelligence in DAX
    • What is time intelligence?
    • Time intelligence functions
    • Running total
    • Mixing time intelligence functions
    • Semi-additive measures
    • Calculations over weeks
    • Exercises
  • Hierarchies in DAX

    • Hierarchies in DAX
    • What are hierarchies?
    • Percentages over hierarchies
    • Parent-child hierarchies
  • Querying with DAX

    • Querying with DAX
    • Working with tables and queries
    • Tables and relationships
    • Query measures
    • Exercises
  • Data lineage and TREATAS

    • Data lineage and TREATAS
    • What is data lineage?
  • Expanded tables

    • Expanded tables
    • Filters are tables
    • Difference between base tables and expanded tables
    • Filtering a column
    • Exercises
  • Arbitrarily shaped filters

    • Arbitrarily shaped filters
    • What are arbitrarily shaped filters?
    • Example of an arbitrarily shaped filter
  • ALLSELECTED and shadow filter contexts

    • ALLSELECTED and shadow filter contexts
    • Shadow filter contexts
  • Segmentation

    • Segmentation
    • Static segmentation
    • Circular dependency in calculated tables
    • Dynamic segmentation
    • Exercises
  • Many-to-many relationships

    • Many-to-many relationships
    • How to handle many-to-many relationships
    • Bidirectional filtering
    • Expanded table filtering
    • Comparison of the different techniques
    • Exercises
  • Ambiguity and bidirectional filters

    • Ambiguity and bidirectional filters
    • Understanding ambiguity
  • Relationships at different granularities

    • Relationships at different granularities
    • Working at different granularity
    • Using TREATAS
    • Calculated tables to slice dimensions
    • Leveraging weak relationships
    • Scenario recap
    • Checking granularity in the report
    • Hiding or reallocating
  • Additional exercises

    • Exercises
Student Rating
1360 ratings

Student Reviews (1393)
  • Yves Goux (Sep 24, 2019)

    very good learning course

  • Aaron Saunders (Sep 16, 2019)

    An incredibly detailed course! Highly recommend it to anyone using Power BI and wanting to improve their DAX skills/knowledge.

  • Claudio Trombini (Sep 14, 2019)

    Corso fantastico!! Consueta qualità!!! Davvero complimenti

  • CAROLINE NDUTA (Sep 5, 2019)

    I have just finished my course only to find out that I have only done 97% How do I locate the 3% not covered?

    • You should check in your course what are the lessons that are not marked as "completed" - you can change them manually (maybe the browser did not send the notification for some video you already watched).

      Reply by SQLBI (Sep 5, 2019)

  • Ciro Gómez Parssian (Aug 29, 2019)

    Best BI Course I ever did. Thank you very much!

  • Wouter de Wit (Aug 29, 2019)

    Great course, lot of information, good practice examples. All in all a great way to learn DAX. Really worth the money and effort.

  • Izacc Moreira (Aug 23, 2019)

    Fantastic Work!!!!

  • David Kofod Hanna (Aug 6, 2019)

    Great course!

  • Alberto Daccarett (Aug 5, 2019)

    Best DAX training out there.

  • cosmin ioan (Aug 2, 2019)

    the most in-depth DAX course on the market! Great presentation & mix of demos and scripts! many thanks, Alberto, Marco, for the wealth of knowledge and effort put into creating such a fantastic course!!

  • Elly Winters (Jul 24, 2019)

    Fantastic course! I feel like I levelled up a lot in my journey to learn DAX with this course. I really appreciated how complex concepts were presented in an easy to understand way. Thank you Alberto and Marco for delivering such great content.

  • Muhammad Bilal Azim (Jul 15, 2019)

    I will describe this course by by using a line from first Avengers movie "The DAX video course has shown me so much. It's more than knowledge. It's truth" The content and flow of topics from start to finish is so elegantly structured, its perfect. I am from accounting background without any background in coding or programming and still able to understand the concepts taught in the course as they have been delivered in such an elegant manner Thank you Marco and Alberto

  • Thomas Kwakman (Jul 10, 2019)

    Hard to find better. Very hard.

  • Iva Vucak (Jul 5, 2019)

    This course is excellent. I have never seen complex functions explained in such easy to understand way. 2nd edition is even better, context transition is better explained, I think. You helped me so much, thank you for amazing course!

  • Nghia Tran Trong (Jun 27, 2019)


  • Gary Friend (Jun 19, 2019)

    Great course, brilliantly presented. Certain I will go through from the beginning again to make sure I pick up all of the insights it delivers.

  • Paul Talbot (Jun 16, 2019)

    You can't take this course, do all the exercises, and not come away with a much higher understanding of DAX. The last 'Relationships at different granularities' module is an excellent capstone to all the learning. I personally benefited from a much better understanding of TREATAS, CROSSFILTER, ALLSELECTED, and DAX Studio / querying using the SUMMARIZE-type functions. The only thing I would say is that I would probably still not recommend this material to someone who hasn't touched DAX before (e.g. to a person completely new to Power BI who has to learn DAX as well), but that doesn't reduce the overall 5-star rating for me.

  • Fernando Luís (Jun 7, 2019)

    Congratulations Alberto and Marco. This course is very well structure, very complete and effective. It help me a lot. With this course I could understand things that were not totally clear, after the read of your book “The Definitive Guide to DAX” .

  • Kenneth Barber (Jun 7, 2019)

    Mastering DAX is nearly perfect and absolutely essential to understanding DAX. I have not found this level of detail presented so clearly and concisely elsewhere. The 2nd Edition is a great improvement over an already great course. There are many examples of mistakes that you might make. Approaches to each problem are compared and contrasted. This course uses lots of guided critical thinking, which helps you understand the material, not just know it. Every Excel and Power BI developer must take this course to be able to handle large or complex data sets, otherwise you will waste lots of time coming up with poor solutions. I recommend that you watch the videos at double speed to get more ideas in your head faster and make more connections between ideas, otherwise each individual idea might come and go.

  • Matt Ballinger (Jun 5, 2019)

    Marco and Alberto have provided tremendous insight into the internal workings of the DAX language in a consumable and powerful course. After taking this course I feel fully equipped to face situations with a stronger understanding of the underlying concepts related to the DAX functions and capabilities. Thanks SQL BI!

  • youssef zaki (Jun 1, 2019)

    Perfect course. can't wait for the next ssas training ! thanks guys for your efforts

  • Claudio Trombini (Oct 14, 2019)

    Best course of Data Modeling!!!

  • Carlos Barboza (Oct 13, 2019)

    This is the best ideal introductory course on Data Modeling with Power BI I have encountered! Marco and Alberto makes it really easy to understand such complex topics and it trains you as you go along so that once you're finished with the course you have a very strong concept on what proper data modeling is. I totally recommend this course to anyone who is interested in learning "what the heck is" Data Modeling with Power BI. Grazie Mille Marco & Alberto. Cheers from Lima, Perú!.

  • Miguel Brei (Oct 10, 2019)


  • Stef Bols (Oct 10, 2019)

    Great Introduction course, enjoyed it!

  • Simen Schikulski (Oct 7, 2019)

    Might be one of the best video courses I've ever seen. Thank you.

  • Thomas Allan (Oct 7, 2019)

    A thorough review of model scenarios (simple to complex) covering date and time, historical attributes, snapshots, intervals, many-to-many relationships, differing granularities, segmentation, and multiple currencies.

  • Michael Nishimura (Oct 5, 2019)

    Overall, very good. I learned a lot. Star Schema makes sense and examples how to manage around multiple fact tables is helpful. Thanks!

  • Benjamin Kormos (Oct 5, 2019)

    It was great and clear, though the layout of the tables in presentation slides should be the same as in the PBI files for more clarity.

  • Robert Williams (Oct 5, 2019)

    What a fantastic course. I stumbled into a role a few years ago that led me to working daily with SQL and SSRS. I've never looked back and really enjoy working with data, but until now I've never truly understood (and therefore never practiced) the benefits of pushing data models into star schemas. I knew people kept recommending it, but because my last employer and current employer do not have any data warehouse or lakes, I've always just built reporting off the OLTP databases. I get by. But now, even though I know my employer won't fork out the money to put in place a proper data warehousing (and the task will only fall on me which I don't really want) I can at least start putting together a SQL Server data model using views and a new db schema, to suit my needs to improve my data-modelling and report building processes. Thank you so much! Love to see you deliver a course in London (or Hemel Hempstead, Watford, Aylesbury, or near by) one day soon.

  • Robert Williams (Oct 4, 2019)

    Thank you so much for the course, it was great to work through and really helped me get an introduction to DAX and give me the foundation and confidence I need to move forwards and not get lost in starting out to learn the language. I would love to have seen something that forces more hands-on training, as in some practices + test questions at the end of each module or video. WiseOwl does some nice practices for example (although a bit hidden) perhaps doing this will help build a better foundation before people then move onto the next (paid) courses.

  • Christine Rowe (Oct 2, 2019)

    This course is just what I was looking for! There's lots of how to videos, but they don't explain the concepts or help to create a foundation from which I could build and grow. This course has filled many gaps I didn't even know I had in my foundational knowledge. Thank you!!

  • Luigi Bissolotti (Oct 2, 2019)

    lessons and examples are very clear discussion sections are very useful

  • Markku Kolehmainen (Oct 1, 2019)

    Just great! Presentation was really clear and easy to follow. Content was also sufficient.

  • Mahdi Ghazali (Sep 27, 2019)

    Thank you

  • Michal Suplinčák (Sep 27, 2019)

    I think, It was perfect introduction to this language. I will recommend to my colleagues and friends. Only one thing, your font does not support letters from my native language.

  • PABLO MORICZ DE TECSO (Sep 27, 2019)

    It's a really good introductory course for people like me who know nothing about DAX and want to start learning about it. Still, as a suggestion I would recommend checking for mistakes while explaining during the videos which can confuse the audience. In general you after correct yourselves, but that leads to confusion sometimes. Also, in some videos you both speak at the same time, making it complicated for the viewer to understand what's happening. I hope this can be corrected in future versions of the introductory course for future viewers to make the most of this amazing course.

  • Lucas Liendo (Sep 25, 2019)

    Excellent introduction to Data Modeling. Highly recommended!

  • Enrico Galli (Sep 25, 2019)

    Great free course from the very masters of DAX and Data modeling, who help you lay a solid foundation to your journey in becoming a BI specialist. Few basic concepts on which you can build with further reading and studying of their huge work on these subjects. Thanks Marco and Alberto!

  • Yves Goux (Sep 24, 2019)

    very good learning course

  • Alessandro Farolfi (Sep 24, 2019)

    GREAT!!! Thanks a lot!

  • Luis Angel Mezones Maldonado (Sep 22, 2019)

    This is a fantastic introduction to the DAX language, done in a clear and concise way. Thank you.

  • Dirk Lyall (Sep 21, 2019)

    One of the best and interactive sessions, I have indulged myself in. Thanks and keep up the good work!

  • Ibrahima MBAYE (Sep 20, 2019)

    Great courses! Very enjoyed learning so mouch think about DAX in so few videos. Thank you very much

  • Trudy Mendis (Sep 20, 2019)

    I loved the training, it has given me answers to some of the problems I have been encountering, and more that I can do with my data.

  • jhampier tapia (Sep 19, 2019)


  • Kim Beck (Sep 18, 2019)

    Great introduction to Power BI modelling

  • Ahmad Askar (Sep 18, 2019)

    Again, awesome course by the champs Thanks a ton

  • Sarasi Dias (Sep 18, 2019)

    Very good. Very much simplified and explained with prompt examples.

  • Kim Beck (Sep 17, 2019)

    Very good getting started review. Just wish that would be some "workshop" included in order to get some hands on with the basics and this help remember better.

    • Thanks for the feedback! The Mastering DAX video course has more than 70 exercises that requires at least 10 hours to be completed - take a look at that!

      Reply by SQLBI (Sep 17, 2019)

  • Mirza Babur Baig (Sep 17, 2019)

    very interactive course, starting from no base in DAX I feel quite confident after completing this course. I become a fan of Alberto Ferrari

  • Luis Felipe Valenzuela Calderara (Sep 16, 2019)

    Thanks for the course, now can i go directly to Mastering Dax course! Try to aggregate spanish subs, because there are a lot of interest in this subject.

  • Ahmad Askar (Sep 16, 2019)

    What a great course and so clear. I really appreciate your efforts guys

  • Вадим Горбаль (Sep 16, 2019)

    Good Job! Many thanks for simplifying explanation and making things clear!

  • Aaron Saunders (Sep 16, 2019)

    An incredibly detailed course! Highly recommend it to anyone using Power BI and wanting to improve their DAX skills/knowledge.

  • Santos Enrique Rivero Rodriguez (Sep 16, 2019)

    Great content!

  • Manoj Shinde (Sep 14, 2019)

    Now I understood evaluation contexts and contexts transition very well. Thank you Alberto and Marco! you guys are super duper genius! :)

  • Claudio Trombini (Sep 14, 2019)

    Corso fantastico!! Consueta qualità!!! Davvero complimenti

  • Disary Nath Sarkar (Sep 13, 2019)

    It was truly awesome

  • rajgopal Tummala (Sep 12, 2019)

    The Best that there is.... You both GOAT..

  • Xiao (Sep 11, 2019)

    12/12 star! Thank you!

  • Peter van den Bosch (Sep 11, 2019)

    A very interesting course, where you can learned a lot about starting with DAX and it's FREE.

  • padma kondaveti (Sep 11, 2019)

    very useful

  • Danilo Mendes (Sep 10, 2019)


  • Abhishek Mani Tripathi (Sep 10, 2019)

    Great content, structured, best modeling and very valuable information about Power BI..Thank you very much Alberto and Marco..

  • Ajay Shah (Sep 10, 2019)

    amazing. Reading the book now, and its even better

  • Francisco Avalos (Sep 9, 2019)

    It is the best course I have taken, with a lot of practical examples

  • Paul Ranschaert (Sep 9, 2019)

    Excellent training!

  • Matthew Snow (Sep 9, 2019)

    Excellent overview-so well done

  • Ashley Finney (Sep 8, 2019)

    Fantastic introduction into DAX.

  • Ramin Zarrasvand (Sep 7, 2019)

    Very helpful, thanks for making and sharing this course with us!

  • Oaj Gokhale (Sep 7, 2019)

    This Course is Designed for everyone who wants to learn DAX and the most informative and easy course for DAX Untill now. Thank you.

  • Madelyn Dedal (Sep 7, 2019)

    This is very helpful free course for someone like me who is just a beginner in using the Power BI Tool in our organization. It is pretty cool how the DAX perform behind the data visualization. Great speakers as well. I hope you could include me in all other free courses that you offer as I am really happy to learn more. Thank you!

  • Bryan legge (Sep 6, 2019)

    It took a bit to get use to the accent, but strangely enough it grew on me. I enjoyed the examples and the back and forth comentary.

  • Otgonbayar Baival (Sep 6, 2019)

    I'm a beginner in Power BI. I learned a lot from this Online Course. I want to learn more deeply. Thank you so much.

  • Ruben Jovan Flores Velazquez (Sep 5, 2019)

    A very easy way to explain DAX Language. Thanks for the videos and congratulations for that

  • Wayne Legg (Sep 5, 2019)

    Too much talking, debate between two presenters. No enough practical actual 'doing' for the receiver of the training.

    • We are sorry you did not like the training. The purpose is to clarify the design principle rather than explaining how to use the user interface of Power BI. The sample files available should help the student getting practical examples to apply to their own reports. Thanks for your feedback - it will help future students to set the right expectations from the course!

      Reply by SQLBI (Sep 5, 2019)

  • CAROLINE NDUTA (Sep 5, 2019)

    I have just finished my course only to find out that I have only done 97% How do I locate the 3% not covered?

    • You should check in your course what are the lessons that are not marked as "completed" - you can change them manually (maybe the browser did not send the notification for some video you already watched).

      Reply by SQLBI (Sep 5, 2019)

    • You should check in your course what are the lessons that are not marked as "completed" - you can change them manually (maybe the browser did not send the notification for some video you already watched).

      Reply by SQLBI (Sep 5, 2019)

  • STANISLAV GODIN (Sep 4, 2019)

    Very helpful course and I intend to go back and review some parts of the course wherever I have a question.

  • Bill Ted (Sep 4, 2019)


  • Leonardo Nunes Couto (Sep 3, 2019)

    Very good training. Instructor knows in deep about the proposed subject. He presents it in a pretty simple language making it very clear even for for beginners. Other DAX training videos I watched on Internet were so superficial and the presenters seems to be reading a teleprompter. Completely different from this one. Very good job, Alberto.

  • Mark Fillingham (Sep 3, 2019)

    Just enough detail explained brilliantly!!

  • Malgorzata Poniatowska (Aug 30, 2019)

    Clear explanations and good examples. Great learning!

  • Placide Roy (Aug 30, 2019)

    Thank you so much. This course is very clear, very complete (although only an introduction to the topic), very smart in the way the concepts are exposed. For sure, I will come back on the whole presentation that I discovered today since it was so rich and consistent _ before steping to a next course. Thanks again, for offering the quality and consistency of information that one expects when registering to a course. Regards.

  • MICHAŁ ROBAK (Aug 30, 2019)

    Great course ! ;)

  • Bert Forbes (Aug 30, 2019)

    Lots of great information. Excellently organised. Good basic ground rules to follow. I'm very pleased to have completed the course!

  • Andrew McDonald (Aug 29, 2019)

    I learned some great tips. I have been using Power BI for a while and apparently all wrong; well not really wrong, just not the best practice. Very helpful stuff and I am planning to take the full course too.

  • Ciro Gómez Parssian (Aug 29, 2019)

    Best BI Course I ever did. Thank you very much!

  • Wouter de Wit (Aug 29, 2019)

    Great course, lot of information, good practice examples. All in all a great way to learn DAX. Really worth the money and effort.

  • Rasheed Kareem (Aug 29, 2019)

    This is a good lecture and I think its a nice one for every newt in DAX

  • Raul Faba (Aug 28, 2019)

    Super good course, highly recommended!! Very good structure, super good balance of simplicity and concept depth. I will strongly recommend to anyone who wants to have a fast start on DAX. Thanks guys for sharing this for free. I am now willing to do an advanced one and pay, to learn more and to give back. Best Raul

  • Rick Wegmann (Aug 27, 2019)

    Outstanding! Thank you.

  • Francisco Cláudio Gomes de Souza (Aug 25, 2019)

    Ótimo! Curso de muita excelência!

  • Manfred Cruz Aguirre (Aug 25, 2019)

    Excelente curso

  • Asim Naeem (Aug 24, 2019)

    great course

  • Izacc Moreira (Aug 23, 2019)

    Fantastic Work!!!!

  • Andreas Ratz (Aug 22, 2019)

    Again a perfect course. Very useful are the patters provided. So all you have to do is to identify the right pattern and apply ;-)

  • Gilbert Ciobanu (Aug 22, 2019)

    Thank you!

  • Wneiton Luiz Gomes (Aug 20, 2019)

    Very useful examples!

  • Jose Luis Baldivieso (Aug 20, 2019)

    Great Intro to data modeling!

  • John Houston (Aug 19, 2019)

    Excellent Introduction to Dax. Covers all the main aspects and sets it up for the advanced courses.

  • Mohammed Aslam (Aug 17, 2019)

    Excellent Keep it up.

  • Thomas Rice, PMP (Aug 16, 2019)

    Great course! I am very close to taking exam 70-779! Thanks again! Highly recommended for all Excel users.

  • Sergio Murru (Aug 15, 2019)

    This course covers different scenarios, from the simplest to the most complex ones, using them as examples to give a clear explanation of the different techniques that can be used when building the data models for our reports.

  • Marco Rodolfi (Aug 14, 2019)

    Simply excellent! The best help I had on the DAX and even if it is introductory, clarifies very important and fundamental concepts on which I have always had a bit of confusion. Now I will have to practice, a lot of practice, but the guidelines are there !!! Congratulations to you, I will certainly take the book thank you!

  • Abhijith Titus DSouza (Aug 13, 2019)

    Excellent introduction course by Marco and Alberto. They stress the importance of data modelling for Power BI and give many examples which can be solved by resorting to good old star schema. Thank you for your efforts.

  • Rodrigo Palomino (Aug 13, 2019)

    All Good!

  • Darwin A Benavides M (Aug 11, 2019)

    Excelente introducción al modelado de datos, la explicación muy correcta ya que va de lo general a lo particular y se enfoca en mostrar las ventajas y desventajas de cada decisión que se toma en el modelado con ejemplos sencillos y muy bien explicados

  • Tariq (Aug 8, 2019)

    Great Training Session !!!

  • ANTONY MARQUES PIRES (Aug 7, 2019)

    Congratulations, simply the best free content of the theme on the web! Thanks

  • David Kofod Hanna (Aug 6, 2019)

    Great course!

  • Robert Christiano (Aug 5, 2019)

    This is a great course for starting to learn DAX. Thank you!

  • Alberto Daccarett (Aug 5, 2019)

    Best DAX training out there.

  • Nick Poulis (Aug 4, 2019)

    A really good course. It helps a lot clarifying some dark corners of how DAX works and a better undersanding of the contexts. It already helped me in a few cases to optimise my reports without having to do tricks in my SQL Views. I'm proceeding to Mastering DAX course. Thank you.

  • Rasheed Kareem (Aug 3, 2019)

    What a very nice course. good to learn from sqlbi

  • cosmin ioan (Aug 2, 2019)

    the most in-depth DAX course on the market! Great presentation & mix of demos and scripts! many thanks, Alberto, Marco, for the wealth of knowledge and effort put into creating such a fantastic course!!

  • Ignacio Barrau (Aug 1, 2019)

    Very nice course. I think it has almost all introduction topics. If I had to add something I would explain what to do when you have a fact table and a chain of conections like Product, ProductSubCategory and ProductCategory. Explain how to model dimensions in that scenario that is very frecuent.

  • john keegan (Aug 1, 2019)

    Really great breadth and depth of material. I have reviewed the course several times over the years. It helps reinforce lessons that you need over your entire Power BI journey.

  • Neil Fernandes (Aug 1, 2019)

    Thank you. Very informative course.

  • JOVIANO SILVEIRA (Aug 1, 2019)

    the best course

  • Fernando Camargo da Silva (Jul 31, 2019)

    Amazing course, it helps to understand and memorize the basic concepts of data modelling in our mind.

  • James Baldwinson (Jul 30, 2019)

    Excellent course.

  • Benjamin Swift (Jul 30, 2019)

    Fantastic content as usual! Thank you.

  • Joanna Boniecka-Grzelak (Jul 30, 2019)

    Fantastic course!

  • Abdunnaser M Erwemi (Jul 29, 2019)

    Very good Intro course!

  • cosmin ioan (Jul 29, 2019)

    The best course anywhere on the market, bar none, taught by the leading experts in the field! Many thanks, Marco, Alberto, for the great course, excellent format and appropriate presentation and mix of demos and exercises! Cos

  • Khai Boon Chai (Jul 29, 2019)

    This is a fantastic introduction to DAX language and done in a clear and concise way. Great stuff!

  • ANTONY MARQUES PIRES (Jul 28, 2019)

    Great content for an introductory 'just' course! Soon I will be attending Master Dax! Congratulations and thanks!

  • Simon Forthun (Jul 28, 2019)


  • Carlos Moreno (Jul 28, 2019)

    Aewsome Intro, thanks

  • Ingrid Aulike (Jul 27, 2019)

    The Introducing DAX video was great! I feel very prepared to watch the Data Modelling video now.

  • Elly Winters (Jul 24, 2019)

    Fantastic course! I feel like I levelled up a lot in my journey to learn DAX with this course. I really appreciated how complex concepts were presented in an easy to understand way. Thank you Alberto and Marco for delivering such great content.

  • Frank Acquaah (Jul 23, 2019)

    Great Videos! Perfect step by step explanation for a rookie like me. Thank you.

  • JOVIANO SILVEIRA (Jul 23, 2019)

    Great! very great!

  • Bohdan Kryszczuk (Jul 21, 2019)

    Thank you for the excellent lecture.

  • Andreas Ratz (Jul 21, 2019)

    Very helpful, very funny presented!

  • JAYME SAMPAIO (Jul 18, 2019)

    Very nice course.

  • Greg Coopman (Jul 17, 2019)

    Excellent Course. Thanks!

  • Andreas Ratz (Jul 17, 2019)

    Very experienced coaches present the content excellent and with and with the typical Italian charm ;-)

  • Gogi Putkaradze (Jul 17, 2019)

    A very good introduction to DAX

  • Federico Rodriguez (Jul 17, 2019)

    Thank you very much. Greetings from Uruguay, South America

  • Alphonce Wanjala (Jul 16, 2019)

    I highly recommend this course as an gateway to more advanced DM. Thanks to Marco and Alberto for the great content.

  • Muhammad Bilal Azim (Jul 15, 2019)

    I will describe this course by by using a line from first Avengers movie "The DAX video course has shown me so much. It's more than knowledge. It's truth" The content and flow of topics from start to finish is so elegantly structured, its perfect. I am from accounting background without any background in coding or programming and still able to understand the concepts taught in the course as they have been delivered in such an elegant manner Thank you Marco and Alberto

  • Gogi Putkaradze (Jul 15, 2019)

    Great content!

  • Ciro Gómez Parssian (Jul 13, 2019)

    Excellent and astonishing course.

  • Abel Mhlanga (Jul 11, 2019)

    Well Explained.

  • Thomas Kwakman (Jul 10, 2019)

    Hard to find better. Very hard.


    Excellent course!


    The course is excellent! A very well explained, and technically perfect introduction!

  • André Pinheiro (Jul 9, 2019)

    Excellent course. I learned a lot. Thank you.

  • Alejandro Sánchez (Jul 9, 2019)

    Excellent introduction!, it has all you need to get a strong foundation on understanding how DAX works

  • Marcelo Salata (Jul 8, 2019)


  • André Pinheiro (Jul 8, 2019)

    Pretty good for beginners.

  • Helmar Träger (Jul 8, 2019)

    Very interesting and presented in an easy to understand why though the subjects are a bit difficult

  • james robim ramos raymondi (Jul 7, 2019)

    Es muy importante saber desnormalizar para poder generar los indicadores de alto impacto.

  • Ciro Gómez Parssian (Jul 6, 2019)

    Excellent course, I've learned a lot of things.

  • Iva Vucak (Jul 5, 2019)

    This course is excellent. I have never seen complex functions explained in such easy to understand way. 2nd edition is even better, context transition is better explained, I think. You helped me so much, thank you for amazing course!

  • JOVIANO SILVEIRA (Jul 5, 2019)

    Great Course!

  • Patricia Rodrigues (Jul 4, 2019)

    You're a great communicator. your knowledge it great and totally aligned with the business needs.

  • Vicente III Tangcueco (Jul 3, 2019)

    Clear and easy to follow. Would definitely recommend

  • Ciro Gómez Parssian (Jul 2, 2019)

    Excellent, I am probably purchasing the full data modeling course and the Power BI course.

  • Paul Ramírez (Jul 2, 2019)

    Top quality course, amazing for the price of $0! Clear and concise explanations that focus on the key aspects of writing efficient and effective DAX code.

  • Jancarlos Ascencio Acuña (Jul 1, 2019)

    Excelente videos esta informacion no se encuentra asi de facil en otras paginas

  • Shawn Gallagher (Jun 28, 2019)

    Coming from the Excel side, for me this intro was invaluable. Marco has put into words here much of what I had discovered intuitively in getting my dozens of PowerPivot (PP) models to work, over the years, and translated into BI assets to share- so special meaning to me; a real eye opener. This year I began a tech-immersion to really learn Power BI and serious DAX programming since I've had so much fun unleashing my creativity thorugh PP. I am putting this training to good use immediately normalizing the publicly available Medicare data I have begun to work with. I can see how it will help with simplify some complex ranking that I have been struggling with. Also, I will definitely seek more patterns to avoid reinvention. This was great in helping me on my journey - keep it up guys!

  • Nghia Tran Trong (Jun 27, 2019)


  • Shawn Gallagher (Jun 26, 2019)

    Solid intro, thanks! I noticed one lecture maintenance issue. Note that the Power BI team is apparently listening; no longer is "Cross filter direction" defaulting to "Both", but rather "Single". I am using the June 2019 Power BI update. Edit relationship | Cross filter direction | Single {default}

  • harm bons (Jun 25, 2019)

    Course was good.

  • Helmar Träger (Jun 25, 2019)

    Really good video course

  • Andy Stepas (Jun 25, 2019)

    Outstanding introduction!

  • Janderson Macedo Araujo (Jun 24, 2019)

    It's just incredible. It's an incredible course. It makes us want to go further..

  • Carlos (Jun 24, 2019)

    I knew more than thought. Thank you for the clear a quick explanations.

  • carry Zhou (Jun 23, 2019)

    good,especially for star schemas

  • carry Zhou (Jun 23, 2019)

    The course is pretty good for providing the basic idea of DAX

  • Steele Carr (Jun 21, 2019)

    Excellent. Especially for a free course. Its not designed to give you everything you need but gives you a very good understanding. Only negative thing to talk about is the way they jump around sometimes during the explanations.

  • Gary Friend (Jun 19, 2019)

    Great course, brilliantly presented. Certain I will go through from the beginning again to make sure I pick up all of the insights it delivers.

  • Isabelle Palaster (Jun 18, 2019)

    I really enjoyed this course and got a lot out of it. Thank you

  • Luca Priano (Jun 17, 2019)

    Fully satisfied ;-)

  • Marshall Joubert (Jun 17, 2019)

    Despite covering a previous version of Excel, the material was still relevant.

  • Paul Talbot (Jun 16, 2019)

    You can't take this course, do all the exercises, and not come away with a much higher understanding of DAX. The last 'Relationships at different granularities' module is an excellent capstone to all the learning. I personally benefited from a much better understanding of TREATAS, CROSSFILTER, ALLSELECTED, and DAX Studio / querying using the SUMMARIZE-type functions. The only thing I would say is that I would probably still not recommend this material to someone who hasn't touched DAX before (e.g. to a person completely new to Power BI who has to learn DAX as well), but that doesn't reduce the overall 5-star rating for me.

  • James Ulatowski (Jun 14, 2019)

    Strong course for an introduction. Leaves one very interested in further study and intent to use the newly acquired knowledge in BI tasks at hand. The presenters are clearly expert in these topics and it was both very informative and intellectually satisfying to watch and listen to them. The chats between them are typical of the dialog of smart people at work, no need to say excuse me and thank you - that is a given and wastes time.

  • Daniel Melo (Jun 14, 2019)

    Cool and well explained

  • Pradeep Ramakrishna Musham (Jun 13, 2019)

    Excellent explanation of concepts.

  • Marta Santos (Jun 13, 2019)

    Phenomenal Training. Marco Russo is amazing! This is my first introduction to the subject. Now I see it is possible to advance...Many thanks!

  • Mothilal T (Jun 13, 2019)

    Greetings, I learned DAX formulas previously and this course will be easy to understand more and thank you so much for free tutorial.

  • hemchand chowdary (Jun 12, 2019)

    this course dives through the data modeling with great granularity.

  • Dave Mason (Jun 12, 2019)

    Very interesting and useful introduction to data modelling. Suggests good ways to think about transforming your data to allow straight-forward analysis, whether in Power BI or other analysis tools.

  • Saurabh Pandit (Jun 12, 2019)

    A Must Do! Its a great course even for someone doing data modelling for years. The fundamental concepts have been so clearly explained. Just set the video playback speed to 2x and finish it in your lunch break! AMAZING! Thank you so much guys!

  • Beng Hwa Chan (Jun 9, 2019)

    An excellent introduction to Data Modeling with Power BI covering fundamental concepts and methodologies !

  • Eduardo Rocha Clemente (Jun 9, 2019)

    Good Initiative, but I´ve expected in this course an example for normalization from a denormalized table in excel. It´s a very common situation that we face... Many thanks for this free video. Your classes are becoming even better like Italian wine!!!!

  • Fernando Luís (Jun 7, 2019)

    Congratulations Alberto and Marco. This course is very well structure, very complete and effective. It help me a lot. With this course I could understand things that were not totally clear, after the read of your book “The Definitive Guide to DAX” .

  • Marta Joanna Maciejczyk (Jun 7, 2019)

    Great content, easy to follow and understand. Very specific and technical. Nice presentation and interesting examples. I feel like have learnt a lot within very short time.

  • Kenneth Barber (Jun 7, 2019)

    Mastering DAX is nearly perfect and absolutely essential to understanding DAX. I have not found this level of detail presented so clearly and concisely elsewhere. The 2nd Edition is a great improvement over an already great course. There are many examples of mistakes that you might make. Approaches to each problem are compared and contrasted. This course uses lots of guided critical thinking, which helps you understand the material, not just know it. Every Excel and Power BI developer must take this course to be able to handle large or complex data sets, otherwise you will waste lots of time coming up with poor solutions. I recommend that you watch the videos at double speed to get more ideas in your head faster and make more connections between ideas, otherwise each individual idea might come and go.

  • Matt Ballinger (Jun 5, 2019)

    Marco and Alberto have provided tremendous insight into the internal workings of the DAX language in a consumable and powerful course. After taking this course I feel fully equipped to face situations with a stronger understanding of the underlying concepts related to the DAX functions and capabilities. Thanks SQL BI!

  • Ketil Lidahl (Jun 5, 2019)

    These courses that Marco and Alberto makes has high value, and I can definitely see the value of paying for the complete course after having watched this. Very good tutoring skills and good use of practical examples to ease the understanding.

  • Andy Stepas (Jun 4, 2019)

    Excellent and easy way to understand the basics of DAX!

  • Olanrewaju Oyinbooke (Jun 3, 2019)

    I found so much value in this course than what I ever expected. The facilitators are great at explain complex concepts and making them simple. I will surely recommend this course. Gracias.

  • youssef zaki (Jun 1, 2019)

    Perfect course. can't wait for the next ssas training ! thanks guys for your efforts

  • BHASKAR JAIN (May 31, 2019)

    May I am also learning dax with book "The Definitive Guide to DAX", video course away some, very easy to understand

  • Vasko Bashoski (May 29, 2019)

    Great Course, continuing to Mastering and Optimization

  • Saurabh Pandit (May 29, 2019)

    Good content overall. There could be more example so the rules are explained better. Also some of the rules for design by Stephen Few or Gestalt principles should be explained and covered. One of the key missing point on the final Dashboard or PowerBI Report page was that of information overload. Limiting the number of items on the front-end makes the Dashboard easy to focus on and simple to use.

  • Daniel Pantie (May 28, 2019)

    I am a beginner and this is what I needed to kick off my data modelling journey. Great explanation supported by good examples in a very pleasant narrative. Simply 5 stars!

  • Maisie Han (May 27, 2019)

    You guys are awesome! But it would be good if there are some parts where you both didn't talk over each other.

  • Pablo J Moreno (May 27, 2019)

    This is the best DAX course that I ever had. Alberto Ferrari and Marco Russo are the real DAX masters and they know how to teach. Thank you

  • Richard Svensson (May 25, 2019)

    I have followed SQLBI since 2015 and got a lot of good experience from Alberto and Marco. For me it solved a lot of how to think when it comes to what should be done in SQL, Power Query and/or DAX, and especially, what are the pros and cons in different situations. The course is a very good introduction to data modeling using Power BI.

  • Luca Argentiero (May 25, 2019)

    Great Course and well done. Sometimes a bit fast but you can always pause and try out if you understood the topics. Thanks for putting the course out !!

  • JOSE VICENTE DOÑATE (May 24, 2019)

    Sois muy grandes !!!!!!!!!ª

  • Branislav Klimo (May 22, 2019)

    One of the best courses on DAX out there - easy to follow and very practical. Good job!

  • Mathew Westwood (May 22, 2019)

    This was a very good free intro to DAX course, I was however I did have issues with the comments sections, the comments not loading or loading very slowly

    • We use DISQUS to manage comments. We noticed that it is slow on Microsoft Edge but it works much better on Chrome and the new Edge version based on Chromium (not released yet). Which browser version are you using?

      Reply by SQLBI (May 22, 2019)

  • Noel (May 22, 2019)

    Very useful especially for new Dax developers

  • Bruce Xie (May 22, 2019)

    It is good

  • Paulo Rocha (May 21, 2019)

    I read "The Definitive Guide to DAX", "Analyzing Data with Power BI and Power Pivot for Excel", attended "Mastering DAX Workshop" with Alberto, "Mastering DAX Videocourse", and the full "Data Modeling for Power BI". All content produced by SQLBI is excellent. I did this intro course as a recap and still learned new insights! Keep up the good work Maestros!

  • Sani Garba (May 21, 2019)

    Dax is more than a functional language, it is a gateway to endless possibilities. I am privileged and opportune to learn from the Dexterous Masters of Dax

  • Mario carvajal (May 20, 2019)

    Excellent presentation!

  • Norman Ocampo (May 20, 2019)

    Very great intro course to those starting to Data Modeling.

  • Evelin Yasmyn Padilla Sulca (May 20, 2019)

    Very interesting

  • Christopher Jones (May 19, 2019)

    Very good. About the only thing I would've like to have also seen is consideration of query performance. Example: There was discussion of RELATEDTABLE and also of CALCULATE. If one is creating a calculated column in the Customer table for TotalSales, there is the option of basing the calculation on either function. Would be nice to know the performance implications of the choice. But maybe that's for the Mastering class.

    • There is a specific course for this: Optimizing DAX! However, RELATEDTABLE and CALCULATE have the same behavior because RELATEDTABLE is just an alias for CALCULATETABLE. Performance is the same.

      Reply by SQLBI (May 19, 2019)

  • Lucy LI (May 19, 2019)

    Great course!

  • Gavin Welsh (May 16, 2019)

    A very good course.

  • Rasitha Chathuranga (May 15, 2019)

    This introduction course was really giving fundamental but very important to know those who are working with report creation through power query , data modelling and Power BI. Thank you for providing such a introductory video course on free . We are really looking into learn more on this as we are moving with out report creations and Analytics.

  • Luca Gusmini (May 15, 2019)

    great course

  • Guilherme Maciel (May 15, 2019)

    Marco Russo is the God of Power BI. This is a perfect Data Modeling Intro Course! Going to recommend it to all my colleagues.

  • Carol Bond (May 14, 2019)

    fantasist course, if you are a beginner or need a refresh. The explanations are always easy to follow and make it a joy to learm

  • Helge Schroeder (May 14, 2019)

    Super! I will try the data modellng for power bi course next.

  • Heike Holubek (May 14, 2019)

    good introduction, mostly easy to follow

  • Rodrigo Palomino (May 13, 2019)

    Excellent course. They keep it simple. Useful and beautiful!

  • SAI TEJA AKHIL MADIVADA (May 12, 2019)

    Great course!! Thank you, Alberto Ferrari and Marco Russo

  • Roman Emelyanov (May 12, 2019)

    Thank you very much for the Course! It's Great! Labs was interesting and difficult for me. Now I need more practice after it. I think that at this moment I understand more about filter and row context, propagation, date lineage, filtering, querying, relationships. Waiting your new book "The Definitive Guide to DAX" second edition. Thank you again!

  • Usama Fazzal Ahmed (May 12, 2019)

    Absolutely amazing. This is how all courses should be made. Simple to understand and thorough.

  • tomasz halas (May 9, 2019)

    Great Course!

  • Janet Grant (May 9, 2019)

    I'm not new to data manipulation, having spent many years with Excel (prior to Power Pivot) and SQL, and I enjoy teaching myself new software by jumping in and making things. But I was totally new to DAX and Power BI, and I was struggling even with the most basic calculations - getting correct answers just by trial and error. This course was exactly what I needed to get a running start on making my own data models and visualizations! If you're not familiar with databases, relationships, and data queries, you might be a little lost. But with a basic background, these guys walk you through the logic of DAX in a very common sense kind of way. I found myself constantly thinking, "Ohhhh!!! *That's* how that works! Now it makes sense!" Thanks Alberto and Marco!

  • Nathan Prats (May 9, 2019)

    Thanks, very nice

  • Santosh Raghunath (May 9, 2019)

    Amazing Course. Learnt a lot :-)

  • Laura Arlandis (May 8, 2019)

    Great introductory course for the DAX language

  • Darren Weinstock (May 8, 2019)

    Great introduction to Data Modeling. The course takes complex topics and makes them make sense to a layperson. Thanks Marco and Alberto.

  • Donald Wiesmann (May 7, 2019)

    very useful, thank you very much! Good addition (or basically the same ideas as) to IBCS/Hichert :-)

  • Derrick Dugas (May 7, 2019)

    Very informative. I have some Power BI hours under my belt, so the speed of the video lectures was not much of an issue for me, however, for those who have less experience, I can imagine them having to watch certain lectures multiple times, or at a minimum, pause and start again, which might discourage some individuals from completing the course.

  • Cristian Sopán Chuquipul (May 7, 2019)

    i learn some concept that i work by default

  • Hannes Windisch (May 5, 2019)

    Very good introduction to this topic, well explained and interesting! Thank you!

  • Vivek Rawat (May 5, 2019)

    Concepts are explain technically and how they behave, how using different things for example sumx or calculate can result into similar calculation, these things are really useful to know. In addition to this, I believe putting a use case or scenario showing when one will use one technique against other will of great use. I am learning all behavior of different technique but there is only question in my mind why i am learning different ways of calculating same things, only if there are examples which showing when one thing will be use against other will be of great use. I am happy discuss things in more details.

    • This is an introductory course which goal is to introduce the basic concepts of the DAX language. A more complete course is the Mastering DAX, which has the same approach going deeper in each topic. If you are more interested in learning practical solutions to common patterns, we have DAX Patterns, where you can find many practical examples without the explanation of how DAX works behind.

      Reply by SQLBI (May 5, 2019)

  • MAHESH CAROICAR (May 4, 2019)


  • Graham Getty (May 4, 2019)

    Best explanation / demonstration of importance of star schemas I've ever seen. As a business user of Power BI, I want to go directly to the visualizations of my data - this course was important reminder to review and optimize the data models as how the data is stored by a data vendor is not always (ever?) the best method for reporting and visualization.

  • Rup Rizal (May 2, 2019)

    Awesome intro. Any PowerBi model and reports I am going to work on in future will definitely focus on modeling and get efficient and simpler DAX measures.

  • Renu Gehring (May 1, 2019)

    These are amazing videos. Thank y

  • Marcelle Georgiev (Apr 30, 2019)

    Thank you! Excellent!

  • BRUNO CIPPITELLI (Apr 29, 2019)

    It is really an amazing course. I Learned new powerfull techniques and reenforced others I had. Very clear and righ to the point. Thanks for it!!!. Grazie mille amici italiani.

  • Pawel Kwiecinski (Apr 29, 2019)

    Very useful information for beginners, this course is unique because it highlights with due focus some of the most important information in all of DAX, specifically regarding evaluation contexts.

  • Alice Revere (Apr 26, 2019)

    Excellent advice.

  • John Nickell (Apr 26, 2019)

    Very good! I've been stumbling around in Dax/PowerBI and watching this course explained some of the rules behind things that I had inferred. Understanding the rules (especially filters context and how calculate modifies the context) may have gotten me past the road block I have been beating my head against! Thank you!

  • Jorge Funes (Apr 26, 2019)

    Great !! very usefull

  • Dayo Solaru (Apr 25, 2019)

    Very well explained

  • Ariful Islam (Apr 25, 2019)

    Excellent Presentation

  • Davide Tringanelli (Apr 24, 2019)

    Grazie Marco e Alberto, molto interessante e ottime spiegazioni!

  • Livia Canet (Apr 24, 2019)

    Very Good!

  • Chingiz Gavryushkaev (Apr 24, 2019)

    You did a great job. I like the way you present the material. I wish you continued success.

  • Phil Armstrong (Apr 23, 2019)

    Great intro to data modelling. Perfect for anyone wanting to get the best out of PowerBI without existing BI modelling experience.

  • Cathy Yan (Apr 23, 2019)

    Excellent introduction course and presentation, Thanks!

  • fatima Essahibi (Apr 23, 2019)

    thank you for this great introduction

  • Donald Wiesmann (Apr 21, 2019)

    thank you very much! very detailed and helpful!

  • José Daniel Zerpa Avila (Apr 20, 2019)

    Outstanding classes. Thanks your clarify some concepts that were impossible for me to understand.

  • Deepak Chauhan (Apr 20, 2019)

    Wow!! Is it possible to get the sample dataset used in the exercises? So we can practise side by side on each topic.

    • There is an initial section where you can download the file used for the examples. This course does not have exercises, they are included in the full Mastering DAX video course.

      Reply by SQLBI (Apr 20, 2019)

  • Jimmy Tuck (Apr 19, 2019)

    This is an excellent primer for the Mastering Dax course. Also, the ability to use Dax within PowerBI opens a vast array of tools for the data analyst. Understanding evaluation contexts is key to unlocking the power of PowerBI.

  • Grace Carpio (Apr 19, 2019)

    Thanks so much. I loved it

  • Carlos Castro (Apr 18, 2019)

    Excellent intro. Easy to understand and follow. Good PBI files resources with interesting measures and DAX queries to learn from

  • Egor Klimov (Apr 18, 2019)

    Thank you so much guys for the such a beatiful course. It is something that opening your eyes and instantly promoting you to the higher level. Thank you one more time and see on other courses! Best regards, Egor K.

  • Ricardo Alves (Apr 18, 2019)

    Was my first online course, and exceed my expectations. Videos have a good pace, the speaker presents the topic with ease so is very easy to keep up. I enjoyed the segmentation and lenght of the videos, really easy to pause the course and be back at it after a while. It was the first but probably not the last. Congratulations.

  • Carlos Castro (Apr 18, 2019)

    Excellent course. Baby step video to learn DAX. After months of completed, time on time I come over when I want to refresh knowledge and solve issues on my models/report. Marco and Alberto are highly professional and "maestros.

  • Bagus Deddy andri Suharto (Apr 18, 2019)

    very good

  • ERIC SCOPINHO (Apr 18, 2019)

    Amazing course. Very clear and concise but at the same time covered a lot for an introductory course. The visual aids and instructor are great! By far, the best DAX intro I've seen online.

  • Manal Malek (Apr 18, 2019)

    Very Informative Presentation. Thank you so much. You are the best.

  • Bagus Deddy andri Suharto (Apr 18, 2019)


  • Camilo Barrón (Apr 17, 2019)

    Great, great course!! Congratulations to both instructors. Keep teach us.

  • Susannah Bentley (Apr 16, 2019)

    Excellent introduction to data modelling.

  • Josué López (Apr 16, 2019)

    Very Interesting and helpful

  • Mark Beedle (Apr 15, 2019)

    This was a wonderful introduction to DAX. I found it very helpful how the course builds on itself, starting from basic concepts and then adding more complexity as the course moved forward! I recommend this to anyone who is thinking about tinkering around with DAX/PowerBI.

  • harm bons (Apr 15, 2019)

    Nice introduction in relation to data modeling!

  • Nahid Sarowar (Apr 15, 2019)

    Its very helpful for me, and this the basic of Data modeling for Power BI. Thanks, Marco & Alberto

  • Christon Petersen (Apr 14, 2019)

    Loved it!

  • Julian Ignacio Yepes Arroyave (Apr 12, 2019)


  • Donald Parish (Apr 12, 2019)

    Very nice introduction. I've read the book, and this complements it. I very much enjoy watching the instructor stand and point to screen like a real lecture instead of a talking head imposed on a video.

  • Jeremy Schlosberg (Apr 11, 2019)

    Very informative and the videos are easy to follow

  • Javier Vazquez (Apr 11, 2019)

    Thank you so much for this training, very clear and neat explanations!

  • Mourad BENKADOUR (Apr 11, 2019)

    Thank you a lot for this excellent course. it would be better if we can test our dax knowledges by some exercices, quiz, so by that we can decide if we able to upload to next level.

  • David Hastings (Apr 9, 2019)


  • Andrew Mundt (Apr 8, 2019)

    Generally, I think that the course is good. It could be improved to be excellent by adding more detail in the exercises and their solutions. For example, although most tables and pivot tables are obvious to set up, some are not. So, clear descriptions of which fields to use for the rows, columns, and values would improve the courses. In addition, explanations, perhaps in the form of comments in the DAX code, describing the rationale and logic for the solutions would be good (e.g. why something had to be done a specific way).

    • Thanks for the feedback. In a few weeks we'll release a new version of this video course (and you will get automatic access, of course), which will include a brand new set of exercises. We considered all the feedbacks we received and while we are not able to satisfy all the requests, I hope that you will enjoy the new format.

      Reply by SQLBI (Apr 8, 2019)

  • James Moore (Apr 7, 2019)

    I can't think of anyone I would rather learn DAX from than from Alberto and Marco. I have read a lot of their articles and seen some of their seminars regarding Power BI and DAX. Also, their books are excellent regarding this subject. This was an introductory course, but I highly recommend it for anyone just starting out with writing DAX code to understand the various filter contexts. Thank you, Alberto and Marco for these free videos starting with introducing Power BI and this introducing DAX course. I plan on moving forward with your more advanced DAX courses soon.

  • Smiljka Nikolic (Apr 7, 2019)

    Very nicely explained. I truly enjoyed the course.

  • dave ritchie (Apr 6, 2019)


  • Antonio Junior (Apr 6, 2019)

    An amazing approach. Very clear about basics of DAX. Many thanks!

  • Usman Ahmed (Apr 5, 2019)

    Excellent Course

  • shweta joshi (Apr 4, 2019)

    Amazing Course! Thank you

  • Christopher Hastings (Apr 4, 2019)

    This is a very good introduction to Data Modeling. If you included examples of using Power Query, that would probably be helpful for beginners.

  • John Mathews (Apr 4, 2019)

    Excellent course and presentation, especially with the (deliberate) mistakes and interactions. The row explosion implications of (S/F)CD-Type2 were eye opening. Would like to see some of the scalability modelling issues discussed such amount splitting by order of magnitude, albeit you did mention date/time splitting, and how patterns change to deal with it. Now it's time to rip up my model and do it properly!

  • Donald Wiesmann (Apr 4, 2019)

    Thank you very much, very good in depth explanations, shows in a detailed way philosophy and specialities for data modeling with DAX in Power BI with still following the Kimball method.

  • Colin Scarr (Apr 4, 2019)


  • Yan Yan (Apr 4, 2019)

    very useful! thanks very much for the share!!!

  • Wveimar López Marin (Apr 3, 2019)

    What an excellent video course. As usually, Marco and Alberto is sharing their knowledge to all the community all over the world interested in learning some tips and techniques for BI. Thank you very much.

  • Carlos Goncalves (Apr 3, 2019)

    Great introduction Course. Many thanks for your way to teach

  • Bruno Zurita (Apr 3, 2019)

    Excelent work guys!! Thanks a lot for the course

  • Dirk Surmont (Apr 3, 2019)

    Very good structured course about the Data Modeling subject for Power BI!

  • Joire Rodrigues (Apr 3, 2019)

    Excellent course with a simple and direct didactics to the point. A course with a corporate vision for clear communication with your customers using the right information in the right way. Congratulations

  • Gary Netherton (Apr 3, 2019)

    I loved it. I’ve been trying to be self-taught, but going through the videos with the authors of the books that I am using helped clarify a lot of things and made me pay more attention to the details in the books that they wrote. As they say, “DAX is simple, but it it not easy.”

  • Wayne Walker (Apr 3, 2019)

    Good introduction.

  • Dannelly Ramos (Apr 2, 2019)

    Great course! Practical and useful. I recommend it. Thank you.

  • Massimiliano Alpigno (Apr 2, 2019)

    Very clear explanation. thank you.

  • Alejandra Sevilla (Apr 2, 2019)

    Amazing introduction to DAX! It is a lot more clear now. Thank you!

  • Jerome Louvel (Apr 2, 2019)

    Great content, as always! Blew away some misconceptions I had about normalized schemas always being the way to go. Thanks!

  • Frank Arendt-Theilen (Apr 2, 2019)

    Thank you very match for this very helpful introductional course. In my seminars I advice the attendees to take a very close look at the data modelling and your very well explanations confirms me to do so. Thanks's again. Frank

  • Steven Renders (Apr 2, 2019)

    Super interesting course!!!

  • Iretiola Fola-bolumole (Apr 2, 2019)

    Amazing work and step by step guide to the foundation of data modeling. Explaining the model for dealing with multiple dates was easy to understand and crucial for all modelers to understand. Great work again

  • Mary Fealty (Apr 1, 2019)

    Brilliant! I loved getting reassurance of the importance of the data model and star schema in particular. Marco has a great talent of explaining things in a methodical way that cements learning. Thanks

  • Bruno Zurita (Apr 1, 2019)

    this is a nice course video, i learn so much.

  • Abdelkader Gharbi (Apr 1, 2019)

    very useful to get the basics of data modeling

  • Jan Sutkowski (Mar 30, 2019)

    Really good course. Marco is a great teacher, sharing his knowledge in a simple and understandable way for begginer in data modeling.

  • Jose Almeida (Mar 30, 2019)

    Fantastic Training videos. It's unbelievable how we keep doing the same mistakes after all this year when a Star Schema is the answer in most of the cases. The lectures are easy to follow and examples reflect real life problems. Well done.

  • Aysha Hamisi (Mar 30, 2019)

    Very clear and a great format & pace.

  • William Eunice (Mar 30, 2019)

    Outstanding overview of DAX. It really answered some of my basic misunderstandings. I was relying heavily on the Quick Measures in Power BI but this really gives me a platform to start producing measures that give better insight than can be had out the box. Bravo!

  • Daniel Lázaro (Mar 29, 2019)

    Great course. Grazie mille!

  • Nir robinson (Mar 29, 2019)

    GREAT intrudaction course. Many thanks.

  • Ruben Perez (Mar 29, 2019)

    Very good quality and content!

  • Micah Kline (Mar 28, 2019)

    Very informative. I was struggling with a few concepts but this has allowed me to see how I needed to approach the problems I was having from a different angle. THANKS!!!

  • jorge luna (Mar 28, 2019)

    well done more advanced than expected

  • Brendan Togher (Mar 28, 2019)

    Always good to touch base with SQLBI, it makes you realise simplicity is the key to creating something good. Thank you for sharing your knowledge and enthusiasm.

  • Stefan Uzunov (Mar 28, 2019)

    Professional and well presented. Good definition and clarification of the example problems. Highly recommended for beginners as it provides a very good base for a data modeling analysis. Thank you

  • Lucas Silva (Mar 28, 2019)

    Very Good!

  • Rolando Temporale (Mar 27, 2019)

    Despite I've been already working with data models in power pivot and power bi, this course is very good to refresh and learn essential concepts to work better in data analysis. Thank you Marco & Alberto for share this useful material.

  • Musa Momodu (Mar 27, 2019)

    Straight to the point and an eye-opener. Thanks to the best DAX teachers in the universe. ----Musa Momodu (Lagos, Nigeria)

  • Imran Naseem (Mar 27, 2019)

    Fantastic Course as always

  • John Fugate (Mar 26, 2019)

    Excellent intro to DAX!

  • Sergio Murru (Mar 24, 2019)

    This course teaches DAX by a theoretical and a practical point of view, clarifying DAX inner working aspects, when needed to understand its behaviour. The teachers' exposition is very clear and their knowledge of the subject is astounding.

  • Dave Weatherill (Mar 22, 2019)

    Brilliant course. Really enlightening about the DAX language I have been experimenting with and full of powerful tips. Excellent delivery guys!! Fully recommend this

  • Donald Wiesmann (Mar 20, 2019)

    very interesting and professionally done, lot's of important insights teached! thank you very much!

  • Rodrigo Osses (Mar 20, 2019)

    Me ha parecido excelente, la recomiendo totalmente.

  • Bala krishna (Mar 19, 2019)

    Its Simply Superb and Awesome. Looking forward to learn Mastering DAX as well when i get time.....

  • Antoine Khan (Mar 18, 2019)

    This course was an excellent primer for DAX coding. Being new to Power BI and having no exposure to DAX, this course provided me with valuable insights that allowed me to immediately begin building reports that required custom fields and tables.

  • Jorge Cervantes (Mar 17, 2019)

    Awesome course!

  • Steven Fortier (Mar 17, 2019)

    Wow, this course was so amazing. Marco and Alberto are really good teachers and I recommand taking this course together with the other other one Mastering Dax. The only complain I might have is there's no chapter on handeling different langage in reports. Like if I want to show a reports to my customer in Europe and he talk spanish and the othe one wants it in French. I know there isn't a proper way to do it in Power BI but maybe talk about different possibilities and what are the possible solutions. Except that, everything is well covered. Thank you!

    • That is not a limitation of Power BI and the Tabular modeling where we do not have a good solution yet. The Tabular model supports translations of metadata only, but there are not good solutions for translating entity names (e.g. product names) or report labels. You can figure out workarounds, but any solution has implementation and execution costs - so a feature in Power BI to manage those scenario is really required.

      Reply by SQLBI (Mar 18, 2019)

  • Joshua James (Mar 14, 2019)

    Fantastic course :)

  • Joost Romijn (Mar 12, 2019)

    Very good explanation of the theory and good practical examples. Learned a lot from this.

  • Michael Ajih (Mar 9, 2019)

    You guys have really done a great job. DAX was previously my area of serious concern; however, I feel more confident now. Thanks to you guys @SQLBI

  • Alain Doucet (Mar 9, 2019)

    very nice !

  • Patricia Montgomery (Mar 7, 2019)

    Alberto & Marco are serious SME's! Their rapport is excellent and funny; they work well together by interrupting, correcting and supporting each other. Mainly they're WAY above other DAX tutelage & videos; you can understand their advanced concepts because they explain it so well.

  • Preston Reynolds (Mar 7, 2019)

    I WISH I would have found this a year ago :) What a great course! Thanks, Alberto and Marco!

  • Amit Shukla (Mar 6, 2019)


  • Simon Walmsley-white (Mar 3, 2019)

    Very good introduction!

  • Yadhuram MC (Mar 2, 2019)

    Easy to follow and very specific

  • Yadhuram MC (Mar 2, 2019)

    Very easy to follow

  • Geert Koetje (Mar 1, 2019)

    Thanks to the two of you this is a great introduction. It does help understanding first steps in DAX.

  • Paul Pollock (Mar 1, 2019)

    Being new to Power BI I found this video course to be easy to understand and I learned a lot about DAX and how it can be used. Thank you for providing this free video course!

  • Katherine Jewell (Feb 27, 2019)

    This course was extremely beneficial for just getting the concept of DAX before diving in.

  • Peter Vaneff (Feb 26, 2019)

    An excellent course. Finished it in one sitting. I wish there were a quiz/exercise section, though. Interspersed throughout the lectures. For example, right after CALCULATE is introduced, do a bunch of CALCULATE drills. Maybe even you could mix these dills up a bit, i.e. do a drill on CALCULATE a few topics later. Overall, though, an excellent course! And free :). Thank you.

    • Thanks for the feedback! Please note that the Mastering DAX course includes exercises at the end of each module.

      Reply by SQLBI (Feb 26, 2019)

  • Katherine Jewell (Feb 22, 2019)

    Easy to follow and easily kept my attention! Thank you!

  • Jordi Andres Aguiñaga Gonzalez (Feb 21, 2019)

    Great course, I really enjoyed it! I'll continue with the DAX advanced course! Regards!

  • Jacky Gabizon (Feb 21, 2019)

    Great course ! I enjoyed it very much and dentally will revisit. Hope to see the 2017 updates coming soon to this course.

  • Alec Kamukombe (Feb 20, 2019)

    Very Interesting course, now going for Mastering DAX

  • Julius Fowler (Feb 18, 2019)

    This is a great course! I've learned an incredible amount of information! Looking forward to getting started with our data!

  • Raja kumar (Feb 17, 2019)

    Thanks for this Free demo course, much appreciated.

  • Gavin Clark (Feb 16, 2019)

    Excellent introduction ! Only feedback I'd give is wasn't always possible to follow examples due to different data sets ?

  • Michael Weiner (Feb 16, 2019)

    Mi è piaciuto moltissimo !

  • jesse zhang (Feb 12, 2019)

    fantastic waby to get into the dax world

  • Guus Bollen (Feb 11, 2019)

    Very informative and clear course, it gave me a good understanding of the basics of DAX.

  • Eva Vackova (Feb 5, 2019)

    Thanks Marko & Alberto for organizing the course. Best practices and scenarios solved during the course are often daily on tables of the data analysts. I enjoyed the course a lot and still need to go back tor review some more complex scenarios :)

  • PABLO GUZMAN (Feb 4, 2019)

    This is an excellent class as introduction to DAX. Complex concepts are clearly explained and demos help to visualize such concepts.

  • Thijs Nijhuis (Feb 1, 2019)

    Excellent course! Great balance between theory and practise. The only thing I found hard was to compare my own solution (if different from the given anwer) to yours. I assume my solution would be less good but why? And how would it compare in terms of performance. Perhaps providing different solution would be helpful in that case.

  • Ben Mills (Jan 29, 2019)

    Fantastic Introduction, thank you. I'm looking forward to the other DAX courses now. :)

  • Usama Siddiqui (Jan 25, 2019)

    Just amazing :)

  • Rajshree Ramki (Jan 24, 2019)

    Fabulous . I had to watch the same content many times , packed with concepts.

  • Syed Ali Raza (Jan 24, 2019)

    This video course is the best course ever on DAX which includes the live examples and explanation given by Alberto Ferrari. I am very thankful to the Sqlbi team for providing this best course

  • Thijs Nijhuis (Jan 22, 2019)

    Excellent course. Good to understand samples which gives me a much needed theorethical basis. Thanks you very much!

  • Manuel Clavijo (Jan 21, 2019)

    It´s a great introductory course to anyone who wants to make amazing reports in any BI tool!

  • Georgi Petkov (Jan 20, 2019)

    Great content and teaching techniques!

  • Ji (Jan 15, 2019)

    I really enjoyed your classes. I look forward to reading your books. Thank you

  • Kabir Laiwalla (Jan 15, 2019)

    Excellent introduction to DAX, couldn't have asked for anything better. Thank you.

  • Asier Barbarin (Jan 14, 2019)

    Clear and to the point. It gives you core concepts about how to create proffesional dashboards and what charts and when to use, now that there are tons of different visuals.

  • Francesco Bergamaschi (Jan 11, 2019)

    Very nice and beautifully managed, a real pleasure

  • Ezequiel Matos (Jan 11, 2019)

    Excellence Course!! Just simple like that.

  • Eric LEE (Jan 8, 2019)

    very helpful and opens a new door for my tool weapons

  • Randy Howard (Jan 5, 2019)

    Excellent Course, I have been using Power BI for a few years now and wish I had taken this course from the beginning.... "Would have saved me many sleepless nights"

  • Alice Sinclair (Jan 3, 2019)

    This video course was very helpful. Thank you.

  • Jürg Jenny (Jan 2, 2019)

    This exceptional course provides 10 hours of high quality video tutorials. All the concepts of DAX are explained in detail and in a comprehensible and pleasant way. To sum it up: This course the way to go if you want to become a DAX master. Thank you very much for creating such great content! The only point that could be improved in my opinion: Provide more exercises. The contained labs are very good and I think working through them helps the most to really learn the DAX language. But there are so many functions introduced in the course that are not used in the labs. Having a larger set of exercises (including the solutions) would help to dive even deeper in the DAX world. Apart from that: GREAT WORK!

  • Pablo Amuchastegui (Jan 1, 2019)

    Excellent course!

  • Anatoli Titarev (Jan 1, 2019)

    Great course. I've learned a lot. I will come for reviews and with some questions in the discussions.

  • Luigi Neri (Dec 28, 2018)

    I really enjoyed the course. It is really well taught. The thing I liked the most is your approach. Out there you can find many people who can show you how to do things but that do not explain the theory behind. In your course, instead, you go deep showing the theory and try to teach the correct way to think DAX. The part I like the most is that related to table calculation and context. You explain difficult concepts in a good way. I acknowledge that in order to master these concepts, someone needs to spend a lot of time using the language but in your course, you show the way. Thank you very much for making this course free.

  • Irvin Barrera (Dec 27, 2018)

    Very clear explanations, this course was eye opener in many ways.

  • Akila Shashith (Dec 24, 2018)

    Learnt a lot of clears lot of confusing things.

  • Yusuf Hamzah (Dec 23, 2018)

    Outstanding materials. The contents are "meaty" and of high-quality.

  • Helvio Pedreschi (Dec 21, 2018)

    Very enlightening, will definitely continue with the other trainings!

  • Rega Sanyoto (Dec 18, 2018)

    Outstanding explenations and study materials. Thank you for everything Marco and Alberto !

  • Asier Barbarin (Dec 11, 2018)

    Excellent. It helped me a lot to understand key concepts

  • Witold Dudek (Dec 9, 2018)

    Very simple course with big information about Power BI visualization. Good trainers.

  • Alex Zidkov (Dec 9, 2018)

    Thank you! This course is very useful for beginners and is available even if people with no advanced English! But, I think file-example in excel would be plus.

  • ido peled (Dec 7, 2018)


  • Alejandro Cabanchik (Dec 7, 2018)

    Very good, it was useful to order my ideas about the best way to use graphics and not feel so alone in this world :)

  • Charlie Abramson (Dec 7, 2018)

    Simply excellent. I have some background knowledge from using Excel and Access and wanted to learn Power BI. After learning a bit about Power BI I realised I needed a better understanding of DAX and this course absolutely hit the spot. If I have a need to learn more about DAX, I'll be back to for the Mastering DAX course. Thank you both!

  • Thomas Williams (Dec 7, 2018)

    Great overview of key concepts in DAX.

  • Eugene Nabatov (Dec 6, 2018)

    I feel that the course content is great yet the video can edited and trimmed. Multiple instances of Marco and Alberto not being on the "same page". I hope the pay per view courses are better rehearsed.

  • Alejandro Cabanchik (Dec 6, 2018)

    Excellent, I have all your books (from "Expert Cube Development ...", and had learned to optimize DAX in an empirical way, but without discussing or exchanging with others, the video helped me to develop a more orderly method, even to be able to transmit effectively to others, thank you very much, with the hope that some day you will do some activity in Argentina !!!

  • Stijn Verhoeven (Dec 5, 2018)

    Very informative!

  • Wendy Rodriguez (Dec 4, 2018)

    Loved it!!

  • JP Davey (Dec 2, 2018)

    Excellent. This really pulls everything together so I can fully understand what I'm doing in Power BI and SSAS Tabular. I'm in the Mastering DAX workshop in the classroom starting tomorrow. Thanks for the great course!

  • Yadhuram MC (Nov 30, 2018)

    This is Awesome. This would be like a Bible of DAX and I will refer this always

  • Taras Koniukhov (Nov 30, 2018)

    Magical introduction into DAX! Thank you!

  • Alejandro Giraldo (Nov 28, 2018)

    This is basically the best online course i've done so far, thank you

  • Oscar Fok-Hing Chau (Nov 27, 2018)

    Excellent course

  • Abhijith Titus DSouza (Nov 27, 2018)

    Thank you Alberto and Marco for this wonderful course. It is clear, concise and greatly beneficial to people starting to learn DAX.

  • Garth Zoller (Nov 25, 2018)

    Before the course, I knew nothing about coding in DAX. The course instructors and content were clear, relevant, and accommodated a variety of skill levels. Also, the labs are helpful to practice and recall what I learned. After completing the course, I am already using DAX to solve common data challenges.

  • Debbie Vozniak (Nov 21, 2018)

    This was outstanding! I learned a tremendous amount and I'm looking forward to the advanced classes. I've recommended this course to several colleagues who are just starting with Power BI and DAX so I think the benefits will be great for my company!

  • Ben Hainsworth (Nov 20, 2018)

    Excellent content and delivery. Best resource yet for maturing my understanding of dax calculations.

  • Cecilia Brusatori (Nov 17, 2018)

    This course is the best introduction to DAX I have found over the internet!! thank you so much and congratulations on the superb work you do!

  • Austin McLaughlin (Nov 15, 2018)

    Great content. For the most part easy to follow. Really helpful to understand the underlying logic behind the formulas.

  • David Bruna (Nov 15, 2018)

    Excellent! The Know How of the Marco and Alberto is huge and they explain everything clearly and easily. Essential to start working with DAX. Thanks a lot for this free course. I appreciate it a lot.

  • Alexander Behrmann (Nov 13, 2018)

    Very Helpful and well organized !!

  • Chidiebere Agbara (Nov 13, 2018)

    I enjoyed the DAX programming.

  • Adolfo Gonzalez (Nov 9, 2018)

    Really good basic course on DAX. It is a must to know this basics to continue learning PowerBI. Thank You!

  • Umberto Actis Perino (Nov 8, 2018)

    Very good course with lots of tips and technical insights. It would be great to add exercises and quizzes in each module, to practice and test the necessary skills.

  • Guilherme Benassi (Nov 7, 2018)

    Great course

  • Iva Vucak (Nov 6, 2018)

    This is absolutely brilliant! Clear and easy to understand. Thank you!

  • tho le thi tuyet (Nov 6, 2018)

    Thanks a lot! Good Course

  • Bruce Xie (Nov 1, 2018)

    Very Good Course.


    Very good free online course which really get me to know more about "DAX" . Thank you for making this great work.I will keep learning DAX. Congrat!!!!!! J.Biey

  • Gianpiero Pruneri (Oct 29, 2018)

    Very clear and useful. Thanks guys

  • Paras Singh (Oct 28, 2018)

    I am your fan. You are the best. All my doubts cleared.

  • Mr Amadin (Oct 26, 2018)

    What an introduction! Perfect. You guys are a light and a force. Thanks for being the answer to the cry of many.

  • Adam Harshman (Oct 26, 2018)

    Awesome and entertaining!

  • Juan Carlos Aranibar (Oct 25, 2018)


  • Christopher Hind (Oct 24, 2018)

    Great course! Very useful

  • Julio Venero (Oct 24, 2018)

    Great Intro to DAX

  • tiri Khaled (Oct 23, 2018)

    This course is amazing, very instructive and very simple to understand, thanks a lot :D

  • Leger DJIBA (Oct 19, 2018)

    It's a very nice and usefull course. Congratulation Guys !!!

  • Zolly (Oct 19, 2018)

    Useful, to not make stupid mistakes.

  • Joe Klingaman (Oct 18, 2018)

    Fantastic. Very thorough and explained in a clear and concise manner.

  • paul john (Oct 18, 2018)

    I found the course very interesting and helpful. Coming into DAX without any training is tricky, and this course was a great way to understand some of the key basics with DAX. I thoroughly recommend it.

  • Shanavas Kanhikoth (Oct 17, 2018)

    Its absolutely awesome

  • youssef za (Oct 17, 2018)

    excellence as always. thank you so much guys

  • Juhani Salo (Oct 17, 2018)

    This course explains the logic behind DAX. So it's great place to start learning DAX.

  • Fran Peris (Oct 16, 2018)

    Conceptos básicos muy bien explicados.

  • Aziz Quazi (Oct 16, 2018)

    This is my second visit learning DAX functions incl. relationship and time intelligence. I really learned a lot, even I go through some other videos from other resources, in my second time even and from a FREE course provided by these two gentlemen. I simply cannot imagine what's inside the "Mastering-DAX". I will definitely try there. Thank you very much Sirs AF and MR for this help to this community. Rgds..Aziz

  • Dmitry Novikov (Oct 15, 2018)

    Awesome course! Highly recommended for PowerBI users.

  • Pablo Del Real (Oct 14, 2018)

    Just FANTASTIC!!! It is a great review that gives you the flavor of all you may want to do with DAX.

  • Eduardo Rocha Clemente (Oct 10, 2018)

    The course is very dense, as I expect but the many growing concepts and the hard exercises are in a level that not correspond to the video classes. Video classes are easy and in a lower level presented. Perhaps , as a suggestion you could send us videos about the exercises resolution. The forum in that case is not enough. I realized that was a "jump" between the classes and exercises. Intermediate exercises between them could be another strategy to consolidate the concepts before going direct to the complex exercises.

    • Eduardo, thanks for the feedback. Any example of intermediate exercises would be useful - we know that we have several exercises that we consider basic or intermediate, and we can imagine what you consider advanced, but a more detailed explanation would be very useful for our evaluation. Thanks!

      Reply by SQLBI (Oct 10, 2018)

  • Ryan Davis (Oct 9, 2018)

    Thanks guys!

  • Hari Krishna Gunturi (Oct 6, 2018)

    I Really enjoyed the course and learn the theory behind each DAX formula, thank you

  • manel omani (Oct 5, 2018)

    Perfect for beginners...The course has a global view of what you can do with DAX in Power BI / Power Pivot

  • David Poynton (Oct 2, 2018)

    Awesome! I need to understand the detail behind the calculations and you got that across very succinctly. Thank you

  • Naveen Prabhu (Oct 1, 2018)

    Loved it!

  • Shivakumar Konar (Sep 23, 2018)

    This course is absolutely brilliant and covers all the topics of DAX in depth. The lectures very quickly go into advanced mode right from the word go, so this is not something you can just watch on the go. You truly have to get your hands dirty and watch all the videos multiple times(I am on 4th iteration :D). What makes this course more valuable is ablility to get in touch with Marco & Alberto. Marco has helped me solve so many problems, not just the ones mentioned in the course, any real life problem you encounter, Marco was able to solve it and give the approach of solving the problem. Moreover, I was able to clear the Micro 70-778 exam. Although this course does not cover all the sections required to clear the 70-778 exam, but it definitely covers the largest section relating to DAX. Thanks Marco & Alberto for putting this course together

  • Virgo Farooqui (Sep 19, 2018)

    Excellent Video tutorial series, which enable a person like a master of BI, Thanks to you and your team.

  • Babalo Mpunga (Sep 15, 2018)

    A great appetizer - I have been working on Power BI & this introduction course has been an eyeopener.

  • Cristian Anghelache (Sep 14, 2018)

    Excellent presentation, what I liked the most were the explanations regarding the way the functions work, what is actually happening in the background, understanding how the functions actually work not just what they do, brought me a high level of awareness and new I can take better use of them. Thank you very much!!!

  • Ernesto Rodriguez (Sep 14, 2018)

    Excellent introduction to the DAX. Alfredo and Marco are masters of the language.

  • Muhammad Nauman (Sep 14, 2018)

    Awesome course, but you must provide a link of sample file of source data to practice so as to see whether we are doing as per tutorial

    • The module 2 Slides and Examples has instructions to download them.

      Reply by SQLBI (Sep 14, 2018)

  • Leonardo Miralles de Oliveira (Sep 13, 2018)

    Very good

  • Leonardo Miralles de Oliveira (Sep 13, 2018)

    Very good, useful information for who is just on begining

  • Sebastiaan Schmidt (Sep 13, 2018)

    Very Nice! Really well explained, a must for everyone who starts working with PowerBI

  • Wharley Ferreira (Sep 12, 2018)

    This course opened my mind of extraordinary form! Congratulations for wonderful course!!!

  • Vibhuti Verma (Sep 12, 2018)

    Excellent course esp for beginners.

  • Steven Fortier (Sep 11, 2018)

    Thank you so much for this course. Alberto and Marco are really the best teacher you can get to teach you DAX. I had already 1 year of experience with Power Pivot but this course helped me a lot to understand all the works under the hood. I will definitely buy their book in the next months.

  • Joseph Sorrenti (Sep 11, 2018)

    Excellent. The video quality was really good. The examples were clear and concise and easy to understand. The course provided a good foundation for dashboard design and taught techniques that can be implemented immediately. The lectures provided just the right level of detail.

  • Nestor Negrin (Sep 11, 2018)

    Very dynamic and entertaining, the most important thing is that it is very well structured. Congratulations, excellent work !!!

  • Adrian Roe (Sep 11, 2018)

    Excellent refresher course thanks. Learnt a few new things along the way. Highly recommended.

  • D V (Sep 9, 2018)

    simply superb !!!!!!!

  • Sascha Schober (Sep 9, 2018)

    Hi guys, great course! This course really helped me getting accustomed to the product. You gave me a really quick start into PowerBI and DAX and I bought one of your books to continue learning. Thank you.

  • Gustavo Rojas (Sep 8, 2018)

    Thanks for your amazing course.

  • Maria Luz Munoz (Sep 6, 2018)

    Thanks, I would say let us make the rules to design dashboards the standards. Very helpful course to avoid falling into the creation of visualizations that nice and colorful but missing clarity.

  • john keegan (Sep 3, 2018)

    Outstanding!! Even better the third and forth time viewing.

  • Robin Sarac (Aug 29, 2018)

    I thought this was a great course and I'm looking forward to continuing to the Mastering course and exploring the rest of your catalogue. You folks obviously know your stuff!

  • JORGE LUNA (Aug 29, 2018)

    Just wow! amazing introduction, congratulations!

  • Miguel Ángel Diaz (Aug 29, 2018)


  • Sergey Morarian (Aug 29, 2018)


  • luthfur rahman (Aug 27, 2018)

    Great comprehensive intro

  • Edinaldo Dultra Souza (Aug 24, 2018)

    I 've started to understanding much better.

  • Gines Pagan (Aug 21, 2018)

    I really liked Introducing DAX Video Course. The way in which the contents are explained is clear and enjoyable. Thank you very much!

  • Manlio Rolon (Aug 20, 2018)

    Excellent to have a broad view of the language.

  • Enrico Vezzalini (Aug 20, 2018)

    congratulazioni, il corso è molto ben fatto ed efficace! Se posso, vorrei aggiungere 2 suggerimenti: - sarebbe utile pensare ad un nuovo modulo orientato alla gestione e controllo dei modelli e del flusso dei dati in un'organizzazione complessa in relazione ai vari modelli di deployment - sarebbe molto interessante apprendere quali soluzioni si possano sviluppare mediante il data modeling per facilitare l'applicazione di tutti i requisiti di privacy by design e di compliance control nella creazione di una piattaforma di BI aziendale (sempre in relazione ai modelli di deployment di cui sopra ed all'utilizzo o meno dei filtri di confidenzialità di Power BI)

  • Martin Zukovec (Aug 20, 2018)

    Greate guided course. Detailed explanations. I really liked the comments of the guys behind the PC. It's good to have someone who thinks in a way of a listener and not as a lecturer, who has much more experience and sometimes unknowingly misses an important aspect of a function or clicking specific button etc. Best regards

  • Plamen Ivanov (Aug 19, 2018)

    Great course! Started my Power BI journey a months ago and what I really wanted to find is a well-structured lectures, step-by-step training in order to progress with limited waste of time digging into too advanced stuff at the time of learning - sqlbi learning path is all I was looking for! One recommendation - put on a more easily to find place at your site, I don't even remember how I find this link , but I am on it for the next months:) already bought next training (Data modeling) and can't wait for your 2nd edition of DAX book in the beg of Jan.

  • Christopher Hastings (Aug 17, 2018)

    This course was super helpful. Especially in understanding CALCULATE() and the "X" functions. Thank you so much!

  • Moshe Slonim (Aug 13, 2018)

    This is a great course for introducing DAX. Thank you very much!

  • Dave Polhill (Aug 8, 2018)

    Very informative and a wonderful presentation style.

  • Maria Luz Munoz (Aug 8, 2018)

    It gave me the confirmation of thoughts and also gave me new ideas. I thank you for publishing this good course.

  • Ryan Racelis (Aug 8, 2018)

    Very informative!

  • Min Thein Aung (Aug 6, 2018)

    Extremely useful for my career allowing my capability in analysis of transactions which are almost impossible to processed in Excel without using Power Pivot. If the course is programmed with explanation of each formula that are introduced along the chapters in a way what is their nature, how they work or when they are useful, it would make the course more compelling!

  • Diptesh Rane (Aug 1, 2018)

    Great Course !

  • Peter Warren (Jul 30, 2018)

    Your video course was extremely helpful in providing me with an introduction to DAX. Your explanations were extremely clear, concise and practical. I was able to follow them in the sample Power BI file you provided. The next step is to put into practice all that you covered. Thanks

  • Bill Brown (Jul 27, 2018)

    Now have a much better understanding of data modeling.

  • Zulay Sandrea (Jul 27, 2018)

    Excellent course, very explicit, and help to understand how the functions work.

  • Mary Gambles (Jul 25, 2018)

    This was an excellent course. Thank you...

  • Paul Barnabas (Jul 20, 2018)

    I love this course! It was very informative and helpful in preparation for my Microsoft 70-779 and 70-778 certification Exams. By the way, I passed both exams within 10 days. Marco Russo and Alberto Ferrari are awesome instructors.

  • Ezequiel A. Costa (Jul 19, 2018)

    I really enjoyed this course from the beginning to end.

  • Lex Smeets (Jul 16, 2018)

    I am working with DAX in SSAS Tabular and Power BI for a while but some things finally start to make sense now. Thanks for the great video lectures

  • Ravinder Sunkara (Jul 16, 2018)

    Always the best

  • Johann Krugell (Jul 16, 2018)

    Fantastic course! Applied the principles shown in the course straight away and received some very positive feedback from the dashboard users. Thank you.

  • Emmanuel Dubosson (Jul 13, 2018)

    after using Power Pivot for some years, I could with this course improve my data modeling skills to the next level. The core principles explained in the sections are good understable. Some topics have some (DAX) magic in it. I appreciated the ways proposed in many examples to simplify the data model. Doing it right, it's much more easier and performant. Thanks a lot! With this video course, I'm just only missing eating a pizza with Alberto or Marco.

    • Thanks!!

      Reply by SQLBI (Jul 13, 2018)

  • Mariano Irvin Lopez Jaramillo (Jul 13, 2018)


  • Brandon Rademan (Jul 11, 2018)

    Excellent start to learning the powerful language of DAX. Definitely worth understanding the basics before diving deeper.

  • Hicham Asfour (Jul 11, 2018)

    Helpful and Easy to follow

  • Hicham Asfour (Jul 11, 2018)

    Very helpful and easy to follow

  • Zubin Ordoñez Delgado (Jul 7, 2018)


  • Shahzad Hanif (Jul 6, 2018)

    It is excellent course specially for those who don't have an IT background. This video course helps in enhancing understanding although i have the latest book The Definitive Guide to DAX written by these two guys however their effort in bringing the basic video course for free is much appreciated.

  • P G (Jul 2, 2018)

    A good intro - thanks very much. Still having trouble getting my head around some of it so will have to do more training. ciao

  • Sergio Murru (Jul 1, 2018)

    It's a very well structured course that introduces the DAX language in a never boring, clear and precise way.

  • Jason Brooks (Jun 30, 2018)

    I’ve completed other courses that covered the basics of DAX but this has the best explanation of context transition that I have come across. I wish that I had taken this course first.

  • Paulo Costa (Jun 29, 2018)

    Very Good!! Congratulations!!

  • Eduardo Rocha Clemente (Jun 24, 2018)

    The last Module that I really have done the exercises was the "Analyzing date and time intervals". I think that the previous course that you advised me to do "Introducing Dax", the free one, was not enough to understand the solution that was depeloped in DAX code. I intend to do the "Mastering Dax" course, and do all the exercises again in this course to a better understanding . I feel that a roadmap to master DAX is needed

    • Thanks for the feedback! Please, keep in mind that the goal of the Data Modeling for Power BI course is to teach how to set the goal in designing the data model, not in implementing the transformation. The way you have to consider the exercise is in practicing the definition of the data model. It would be better to use SQL or Power Query (M) to obtain such a result. For practical reasons, we used DAX to accelerate the creation of the required table, otherwise the course would have dedicated 70% of the time describing how to use SQL and/or Power Query, with a more complex setup for the exercises required.

      Reply by SQLBI (Jun 24, 2018)

  • Steve Wilde (Jun 21, 2018)

    Overall this was good. I previously completed my first dashboard and I had already done 95% of the things listed in your 15 items. It was a good confirmation for me. I do however disagree with the donut chart. It is very useful if you're using the interactivity aspect of PBI. Especially when you're looking at something like employee levels within a company. (e.g. Staff, Senior, Manager, Sr. Manager, Director, etc.)

  • Tom Foltz (Jun 21, 2018)

    Excellent introduction into DAX. For future courses have the slide content more easily readable. Some of the slide contents and screen displays weren't fully displayed throughout some of the videos. I was able to obtain the full content by pausing & refreshing. The interaction was very important as it provided perspectives on various ways to do things in DAX.

  • Piero Quinto (Jun 19, 2018)

    Thank you by this sample free. I understood pretty well. Very thank you. From Lima,Perú.

  • Maria Luz Munoz (Jun 19, 2018)

    I liked it, very clear explanation and demos. Thanks for making this video..

  • Karin Rehers (Jun 18, 2018)

    Erst hatte ich Bedenken, ob ich dem englischen Vortrag werde folgen können. Das ging erstaunlich gut, und wenn es mal hakte, konnte ich den Teil ja mehrfach ansehen. Danke, jetzt habe ich endlich die Dax-Grundlagen verstanden.

  • Ezequiel A. Costa (Jun 17, 2018)

    Wonderful workshop! Congratulations Marco Russo and Alberto Ferrari

  • Joe Chamberlain (Jun 15, 2018)

    Excellently explained and delivered, will find this very useful. If I'm honest I found the exercises very difficult, but I probably didn't allow myself enough time. Keep up the good work. :)

  • Rachel Hill (Jun 14, 2018)

    Excellent, really well explained

  • Romeu Wolfgramm (Jun 8, 2018)

    would be possible to enable the legen in the videos? to the Portuguese for example ;-)

    • Romeu, currently the subtitles are available in English and Spanish. You can enable them clicking on the CC icon in the lower right corner of the video player. We will consider creating Portuguese subtitles in the future depending on requests. Thanks!

      Reply by SQLBI (Jun 8, 2018)

  • Akhil Sharma (Jun 8, 2018)

    This is very nice course.

  • Mahadev Vasista (Jun 7, 2018)

    Awesome.I learned a lot

  • Aziz Quazi (Jun 5, 2018)

    A fantastic training provided by you, Alberto. Thank you.

  • L RE (Jun 2, 2018)

    Do not miss this even if you have gone through "The definitive guide to DAX (book)". Different mediums of learning reinforce concepts even better.

  • Don Forbush (May 31, 2018)

    Great beginners course for familiarizing yourself with the basic principles of DAX. Looking forward to Mastering DAX and Optimizing DAX courses.

  • Yoann Jeffrey CLOMBE (May 30, 2018)

    15 RULES Amazing Content, Thanks , looking forward to see you at the Montreal Power BI WORLD TOUR in November ;). LAST Part Repetition no Value , No Return on Time.

  • David Rua (May 24, 2018)

    Really good methodology, is kind of interactive. Totally recommended as an introduction to DAX!

  • Luca Priano (May 23, 2018)

    simply great!

  • Mychell Laurindo De Souza Sá (May 21, 2018)

    Very intuitive and easy to follow

  • Eduardo Rocha Clemente (May 20, 2018)

    Thanks a lot for this free course!!! Anyone who´ll learn and visit these classes will be very grateful. One single advice... Don´t miss each sentence. This course has a speed for beginners, but many concepts are told in a very short time.

  • rohit bharwani (May 18, 2018)

    Well the course was amazing, for the beginners I must recommend all to subscripe to this course. Well explained

  • Guilherme Oliveira (May 17, 2018)

    Very good, simply english

  • Emre Ozden (May 15, 2018)

    A must follow course for anyone who's entering the world of DAX!

  • Wveimar López Marin (May 12, 2018)

    I have been using DAX for several months and I must recognize I have learned just a little in comparison with the real power of the language. Thanks Alberto and Marco for sharing your deep knowledge and expertise.

  • Hana Palkova (May 10, 2018)

    Many interesting new insights. Thanks Marco & Alberto!

  • Michael Tan (May 8, 2018)

    Great for introduction

  • Paulo Rocha (May 7, 2018)

    Wonderful! SQLBI, Marco and Alberto not only are the best in the field, bust also know how to share their knowledge. This approach of focusing in the Data Modeling and making more efficient DAX expressions takes us to a whole new level in Business Intelligence and Big Data. I'm very pleased with the content and the professional way everything was presented. Keep up the excellent work.

  • Yeneneh Abebe (May 7, 2018)

    Great Tutorial!

  • Laura Arlandis (May 7, 2018)


  • Jaderson Almeida (May 3, 2018)

    Excellent content and I loved the way instructors interact each other. It brings a more realistic and live training session feeling. If this was one of the targets, so, well done!

  • Mehdi HAMMADI (Apr 29, 2018)

    This course is very accessible and allows in a few hours to get an idea of the DAX language. A big thank you for this great job.

  • Francis MacIsaac (Apr 28, 2018)

    Brought together in a logical fashion, the theory of Dax, with examples and lecture. Turns on the light, allowing advancement with understanding. I will be re-watching several time, and will gain a deeper knowledge. Job well done.

  • Pekka Kytösaho (Apr 27, 2018)

    Good teachers. Great course.

  • Jack Wells (Apr 27, 2018)

    Wish I had watched this when I first started using Power BI.

  • Rega Sanyoto (Apr 25, 2018)

    The video courses are very good and simple to understand !

  • Daniel Åkerhielm (Apr 24, 2018)

    Some of the changes you guys made was made during the other one was speaking or covering the way the things were changed

  • Eduardo Rocha Clemente (Apr 18, 2018)

    As an introduction course is good enough to taste, but it doens't show a kind of roadmap for mastering DAX. Perhaps is a good idea to add this information right in the beginning of the course

  • Bare Udusegbe (Apr 15, 2018)

    Great intro to the "beautiful language" DAX!

  • Alec Guerenstein (Apr 14, 2018)

    Amazing, as usual. thanks a lot for the intro!

  • Justice Leoma Lekhoana (Apr 14, 2018)

    It's interesting and exciting course, which will help me do my work faster and differently.

  • Bill Brown (Apr 13, 2018)

    Found good tips on dashboards and am using them in my presentations about Power BI, in my actual dashboards and designs. Ready to get to the next course.

  • Joan Stuart (Apr 11, 2018)

    Excellent overview! Very helpful. Thank you.

  • Ada Lei (Apr 7, 2018)

    The course is really enriched by the two presenters' hands-on business knowledge and practical technical skills. The examples are easy to follow and contents are just excellent ! Well done and a big thank-you to you Marco and Alberto !

  • Farman Ali Shah (Apr 4, 2018)

    Thanks for the amazing course of DAX. Learned a lot from the course.

  • Cees van Diermen (Apr 3, 2018)

    Very good step by step intro. I especially liked the way the evaluation context were introduced and demonstrated and will definitely return to this part every now and then.

  • Long Truong (Mar 30, 2018)

    Thank you very much for this video course. It is very informative. I love the way the student interacts with the instructor during the course. If I could, I would give this course 10-star.

  • Ihthisham Hazard (Mar 28, 2018)

    Thanks Alberto and Marco for this. I bought the Book (Definitive Guide to DAX) in 2016 and started reading until advance filter context and then thought I want to learn from Video. The Video was a great boost for my dax knowledge.

  • Marcilio Eloi da Silva (Mar 28, 2018)


  • Vishal Sanap (Mar 26, 2018)

    I have learned so many important concepts through this course, it was wonderful experience with you, thanks for valuable guidance and videos

  • Sergio Linares (Mar 21, 2018)


  • Jose (Mar 21, 2018)

    Thank you Alberto and Marco, this was a great introductory course.

  • Zachary Thomson (Mar 19, 2018)

    Great introductory course - WELL worth the time to see what this incredible language can do for you!

  • Andres Taroco (Mar 19, 2018)

    Muy buen curso.

  • Raheel Rana (Mar 18, 2018)

    Learned a lot ...Thanks, Alberto and Marco ... you guys have made many lifes easy :)

  • Ezequiel A. Costa (Mar 18, 2018)

    I really appreciated this course. I'm reading the Definitive Guide to Dax Book and wachting these videos it became more clear for me. Thank you guys for the quality in this course. Congratulations.

  • Koen Verbeeck (Mar 15, 2018)

    As the title also makes clear, this book is based on the Microsoft Data Platform and more specifically with the self-service tools Power BI Desktop or Power Pivot (which are the same except Power Pivot doesn’t have all those shiny new features). However, almost everything you learn in this book can also be applied to Analysis Services Tabular and Azure Analysis Services. And if you just look at the concepts and forget about the DAX code and the bi-directional filters and everything, you can also apply that knowledge to Analysis Services Multidimensional. But it’s mostly geared towards people working in Power BI Desktop who aren’t BI professionals. Read more

  • zhano abner (Mar 13, 2018)

    Very very good video for me.Thank you !

  • Fredy Antonio Carpintero Mendoza (Mar 9, 2018)

    Excelente curdo.

  • robert dowrick (Mar 8, 2018)

    good introduction, coupled with the downloaded example file its easy to follow and try out the examples which reinforces the learning.

  • Oscar Vargas (Mar 4, 2018)

    Excellent course from a very talented guys and for free, thanks a lot

  • Julian Isphording (Mar 2, 2018)

    Very helpful, cleared up some issues I had when viewing other online video's. Also like the emphasis on some theory (eg. CALCULATE). Cheers, Julian

  • David Linnemann (Mar 2, 2018)

    If you need to learn DAX, these instructors will get you what you need!

  • Izacc Moreira (Feb 26, 2018)

    Thats a great course!!!!

  • Claudio Trombini (Feb 25, 2018)

    Simply the best!!! Perfect!!!

  • Daniel Tuma (Feb 25, 2018)

    Excellent course. The explanations are easy to understand and are demonstrated effectively. The two presenters seem to complement each other very well. I would definitely recommend this course.

  • German Henriquez (Feb 23, 2018)


  • Juan Zuniga (Feb 22, 2018)

    Great presentation, very clear, straightforward and useful. Thank you Alberto and Marco!

  • Sergey Altukhov (Feb 22, 2018)

    Great course, thanks a lot

  • Sarah Bessard (Feb 22, 2018)

    Very nice ! Thanks

  • Sarah Bessard (Feb 22, 2018)

    Great job ! Thanks for this training

  • ARIEL FERNANDEZ (Feb 21, 2018)

    Excelente mini curso inicial, con muy buenas explicaciones, que lo deja a uno con ganas de seguir con lo próximo para completar el conocimiento.

  • Clay Seifert (Feb 20, 2018)

    This video course was outstanding. It's a pleasure to have instructors with hands-on experience in using the product because they can present the material that includes suggestions on matters to be aware of. Let me close out this review by giving my unrestrictive recommendation to those considering taking this video course. It is money well spent!!!!! Clay Seifert

  • Matthew Smith (Feb 15, 2018)

    Great course!

  • Ezequiel A. Costa (Feb 15, 2018)

    It was great! Very simple to understand and practice.

  • Martin Halse Præsius (Feb 14, 2018)

    This was a really great intro to DAX, there is no doubt that i will take the next course once it is approved by my manager

  • João Augusto Pereira Júnior (Feb 13, 2018)

    Really useful!!!

  • Scott Powell (Feb 9, 2018)

    This course was absolutely fabulous. Will definitely be taking the masters level course, trying to decide whether to take it online or in person. Thanks for posting the intro video. Scott

  • Paulo Alpoim (Feb 9, 2018)

    Great materials.

  • Chantal Souliere (Jan 27, 2018)

    Well structured! Well presented! Simple et efficace. Merci SQLBI!

  • Peter Kötzing (Jan 27, 2018)

    I find this course very useful, and having 2 presenters adds another dimension to it: It's very entertaining too - exactly because there are sometimes 2 voices at the same time. Who cares? I like the vivid Italian style much better than those boring Indian monologues. Just bought the 'mastering' course ...

  • Olga Avtushko (Jan 24, 2018)

    The course is wonderful. Thank you. Clear explanation of the important points, especially for DAX beginners like me.

  • Abdelkader Gharbi (Jan 22, 2018)

    I think , without compliment it's great, i think all web site is great and i found lot of things usefull for to fix some issues in my model at work , for this i give five stars. ......and as alberto said "DAX is simple , but it is not easy", it's need time , work and patience.

  • Rajayoganandha Sekaran (Jan 11, 2018)

    This is a great course for equipping oneself with enough tools to work on any data model. Thanks for explaining in great detail about the nuances of various function.

  • Victor Jemio (Jan 11, 2018)

    Great course. Very clear and the lenght of the videos is just perfect.

  • Ana Garcia (Jan 5, 2018)

    I believe it would be better if we could complete some exercises at the same time.

  • Adilson Costa (Jan 5, 2018)

    This is the most interesting free course I am did about one tool! This is an amazing DAX course. You are to be congratulated for this grating job.

  • Bart Titulaer (Jan 2, 2018)

    Thank you very much. I really liked this way of presenting. Also compliments for your assistant who asked very good questions in between and also gave some good intermediate remarks. Good team!!

  • Wyn Hopkins (Jan 2, 2018)

    Great for people starting their journey in DAX for Power Pivot and Power BI. Strong emphasis on understanding why things work the way they do.

  • Omar Amrani (Dec 31, 2017)

    Wonderful presentation!

  • Mariano Irvin Lopez Jaramillo (Dec 30, 2017)

    muy bueno

  • John Gooden (Dec 30, 2017)

    This has been very helpful! Thank You!

  • Namrud Askhrya (Dec 29, 2017)

    Thank you very much for this very useful introduction, it is really helpful to understand the basics of DAX language.

  • Cristina Lobo (Dec 28, 2017)

    Very usefull.

  • Alex Powers (Dec 28, 2017)

    As a proud owner of The Definitive Guide to DAX this series was a fantastic complement to the book. To be honest I can not believe the amount and wealth of content that was given away for free in the course. I'm excited to look into the other courses as I continue on my DAX journey.

  • Edwin Rotgans (Dec 28, 2017)

    The course name is misleading: it is a layout course for one-page Power BI Reports.

  • Sony Thomas (Dec 25, 2017)

    Very good presentation. Completed the course by one week. It will help me prepare better dashboards and reports based on the 15 golden rules.

  • Sanjeev Soni (Dec 25, 2017)

    Excellent no words of thanks touched all the key aspects of DAX

  • Natarajan Ganapathi (Dec 22, 2017)

    It will be unfair, if I give anything below a 5*.

  • Sony Thomas (Dec 22, 2017)

    Very good presentation. It satisfied my requirements. I have gone through all the topics by one week and will refresh it from beginning again . From last few months I was doing projects for my company on Power BI with few DAX equations like SUM , SUMX and few equations with Filters, now I will be able to use the power of DAX to provide powerful reports. Once I refresh the course and able to practise it , I prefer to take the DAX Optimization course. Once again thanks for the good presentation.

  • Bhavesh Patel (Dec 21, 2017)

    The Best DAX Course in the World!

  • Andrés Lagerlöf (Dec 20, 2017)

    Great course! Thank you!!!

  • minshen liang (Dec 20, 2017)


  • Claudio Trombini (Dec 17, 2017)

    Il corso è davvero ottimo sia nei contenuti che nell'esposizione, inoltre il materiale fornito, come in altri videocorsi è sempre chiarissimo e veramente utile. Davvero un fantastico lavoro. Complimenti

  • Gunther Verleger (Dec 17, 2017)

    Great course - keep up the good work!

  • Francisco Tapia (Dec 16, 2017)

    This a very through explanation of Tabular with SSAS. If you are familiar with Sql and are getting into business intelligence, this course is perfect for getting you started with the engine.

  • Lyn Taylor (Dec 13, 2017)

    Very helpful and well organized to understand Analysis Services. Will refer to this course as we build and deploy models.

  • Giuseppe Fenzi (Dec 13, 2017)

    Well done!!

  • Feiwei Yang (Dec 11, 2017)


  • JORGE BUSTILLO (Dec 10, 2017)

    This course makes the difference between designing a good dashboard and designing the best dashboard.

  • Michael Sidley (Dec 8, 2017)

    Excellent! Thank you

  • Flora Zhao (Dec 8, 2017)

    This course is definitely the must-learn if anyone wants to use Power BI in a proficient way. From my own experience, it would be more efficient to follow the course and at the same time read the book . I appreciate that Marco and Alberto answer to all questions I posted on the web with as many details as possible. Thanks a lot and keep up the terrific work!

  • Dave Sheppard (Dec 3, 2017)

    Excellent presentation of foundational theory. Very helpful for those who wish to pursue a deeper understanding of DAX, or use DAX in their careers.

  • Juan Aranibar (Nov 24, 2017)

    Great course. Probably a final test would be useful in order to you to see the impact. Thanks for the feedback. JCA

  • Stéphane CAMUS (Nov 21, 2017)

    Very good course. Clear and easy to follow. Very useful for an introduction into DAX language. Thanks a lot.

  • Jasper Dijkman (Nov 16, 2017)

    Very clear rules and a great guideline while making dashboard design decisions. Links to the literature to deepen one's knowledge would be nice.

  • Robin kettring (Nov 1, 2017)

    Can't recommend enough. Contains the details needed to truly understand DAX. Alberto and Marco are Rock Stars for all they have done to develop the DAX community.

  • Larry Casey (Oct 31, 2017)

    Not enough real world examples. None of the examples will ever be used in the real world so it is very difficult to learn something when it is not taught correctly. My suggestion, don't give us some stupid unrealistic examples to work with, give us real examples that relate to real business needs. Not once do you provide examples of using dates to filter multiple tables or how to create relationships that calculate balances etc.... Everything is just a real water downed single table.

    • The examples included in the course are intentionally focused on explaining how the DAX language works. For this reason, they isolate specific issues that can help to understand each behavior of the language and of specific functions. If you want to get more real-world examples, we suggest you to take a look at where you can find a number of templates (completely free) that can be applied to real world issues. On that site, the focus is to apply the language to the business, so you will not find there an explanation of how the language work, which is probably needed when you have to adapt a pattern to your specific scenario. Thanks for your feedback, it will help us in clarifying the goals of the course in our marketing content.

      Reply by SQLBI (Nov 3, 2017)

  • Lyn Taylor (Oct 24, 2017)

    Excellent presentation which greatly helped build my understanding of DAX fundamentals.

  • Carlos Niz Puig (Oct 24, 2017)

    Excelent book.
    Great explanation, examples and content in general.

  • Martina Sanchez (Oct 23, 2017)

    Great course. I learned a lot. Thanks.

  • Andrew Mackay (Oct 21, 2017)

    What can I say, you guys are great at what you do and in short this course is what is says on the can.I feel like I can Master DAX with more time and practice and the material covered allows me to know I can do it by understanding these areas as a foundation. Very cool thanks

  • Iulian Voaides (Oct 21, 2017)

    Thank you Marco and Alberto! Your course helped me see how wrong is the "Excel table mentality" when working in DAX.

  • Richard Martinez (Oct 17, 2017)

    Great course. I highly recommend starting out with DAX to take this course.

  • Dave Shepherd (Oct 6, 2017)

    Great! Helped explain early chapters of your book. Reading can get a bit tiring, so nice to sit back and watch and listen. Thanks!

  • Sujata Mehta (Oct 6, 2017)

    It is said that it is the mark of a genius to explain complex concepts in a simple manner. Thank you Alberto and Mark, you are geniuses!

  • Giedrius Vegys (Oct 5, 2017)

    This is great course. One thing I am still missing - does CALCULATE add row context to existing filter or completely change existing filter?

  • Wynand Coetzee (Oct 5, 2017)

    Nice intro into DAX , thanks guys. Sometimes I still want to write DAX like I do it is a mind set change that I am learning and enjoying.

  • Luiz Fernando (Oct 2, 2017)

    No matter if you have good data modeling skills or not, this book will be a nice refresher which serves as both to formalize as to structure your knowledge or to introduce you to data modeling. Worth every cent.

  • Shannon GILL (Sep 27, 2017)

    Great course. I will refer back over and over again. My only suggestion is to add a transcript so I can easily refer back to a certain section.

  • Puneet Dobriyal (Sep 26, 2017)

    Very nice explanation and course outline.!!

  • Elbina Rizakhanova (Sep 23, 2017)

    Very, very good! Many thanks! I after this course I'll definitely apply Mastering DAX course

  • Elbina Rizakhanova (Sep 23, 2017)

    Excellent! Many Thanks! After this course I'm sure that I apply to Mastering DAX workshop course!

  • Jayson Chabot (Sep 23, 2017)

    Wow, I didn't expect an introduction course to teach me about the iterator functions ...what an amazing tool to replace my reliance on calculated columns! I would have awarded five (5) stars if there was a bit more story telling would be nice to have a few laughs from your many years of experience teaching DAX.

  • Anton Kwang (Sep 22, 2017)

    Excellent & Informative

  • kalina ligmanowska (Sep 21, 2017)

    Thank you guys, that has been extremely helpful :)

  • Mikkel Nissen (Sep 20, 2017)

    To fast pace, specially the "not visible" guy running the demo in PowerBI - some extent annoying to hear the two discuss typos etc. Otherwise fine for a free course.

  • Jeffrey Mensah-Roberts (Sep 15, 2017)

    Fantastic is an understatement, can't find a word for the overstatement though, i will try brilliant ! ! Thanks for the early bird offer as well.

  • Michael Dillon (Sep 14, 2017)

    Fantastic! Thank-you Macro and Alberto. Excellent compliment to the Book. Michael Dillon Community College of Batimore County

  • Michael Girvin (Sep 7, 2017)

    Thank you so much for presenting this class. I have learned a lot!

  • Wil Maui (Sep 2, 2017)

    There aren't too many books out there on Power BI. This is a must have among the ones out there. It puts a lot of thing in perspective, in addition to showing you some good specific how tos.

  • David Bravo Sánchez (Aug 28, 2017)

    It's a great introduction, thanks for offering this training for free.

  • Mark Walter (Aug 27, 2017)

    I've been using and learning DAX over the last three years. This course helped highlight the concepts I needed to advance my understanding over and above what I already knew of evaluation context and the subtleties of how the engine works. Thanks!!

  • David Edelman (Aug 24, 2017)

    Very well put together and very informative. I was immediately able to take some of my initial design and transform them using the rules to make impressive dashboards.

  • Roberto Santamaria (Aug 24, 2017)

    Good course! it's clear and usefull to learn making good dashboard. Now it's DAX time!

  • Daniel Labarca Zucker (Aug 23, 2017)

    Great course to start learning DAX! It helped me a lot and made me understand how powerful can this programming language be.

  • Mark Haring (Aug 23, 2017)

    Great online course. Covers all aspects of SSAS tabular and gets you up and running. For a non-programmer the actual set-up of the automated processing methods of the SSAS databases (via SSIS, SQL server Agent or PowerShell) is not really clear. This seems understandable as a lot of topics need to be covered.

  • Mariana Calonico (Aug 22, 2017)


  • Bill Leffler (Aug 21, 2017)

    Excellent for learning and for reference later on. Would recommend to anyone who wants to learn about dash-boarding.

  • William Kiarie (Aug 14, 2017)

    This is a great primer that gives one a better grip of the various concepts relating to DAX. Great job guys!

  • Michael Girvin (Aug 11, 2017)

    Thank you very much for the amazing DAX Course!!!! : )

  • Marcelo Silva (Aug 9, 2017)

    Fantastic course!

  • Andriy Kramarenko (Aug 7, 2017)

    Great course! Thanks a lot Alberto and Marco!

  • Marek Zawadzki (Aug 6, 2017)

    Good work! I like that method of presenting, never saw this one. Now its time to work alone for make some test about DAX exprtessions. Thank you!

  • William Satoru (Aug 5, 2017)

    Incredible and extremely well done! In a simple way, solved most of my doubts in my first steps using Power BI! Thank you so much!

  • Greg Regan (Aug 4, 2017)

    Excellent resource for anyone (technical or not) looking for a very solid introduction to Power BI.

  • Blessing Madondo (Aug 2, 2017)

    Best bi course ever!

  • Rafal Slomkowski (Jul 26, 2017)

    I think this is a wonderful introduction and frankly a necessary complement to your "Definitive Guide to DAX" textbook. Great job!

  • Arthur Arthur (Jul 26, 2017)

    Video will be interesting for everyone who work with DAX. Thanks!

  • Mario Anzaldua (Jul 24, 2017)

    This is a fabulous course. I spent many hours with The Definitive Guide to DAX and still struggled to write the formulas I needed. Finally, I took this course. Marco and Alberto have built a course that takes you from the very basics and has you writing complex formulas by the end. The course is filled with real-world examples of calculations you can use. If you struggle at all with DAX, this course is well worth the investment.

  • Marta Ramos (Jul 24, 2017)


  • James Tallman (Jul 22, 2017)

    Good learned lots can't figure out why it will not show complete

  • Jorge Diaz Infante (Jul 21, 2017)

    Great Course with a lot of examples and material. Now time to improve my current Dashboards. Thanks

  • Patrick Guo (Jul 20, 2017)

    It's extremely helpful for beginners!

  • Marcelo Silva (Jul 19, 2017)

    just great!

  • Maxim Zelensky (Jul 19, 2017)

    This is MUST READ for all who want to create fast and convenient data models in Power Pivot / Power BI. Best practices and tips from gurus. Thank a lot for this excellent book!

  • Oleksandr Petelvyi (Jul 18, 2017)

    It is excellent course! Thanks a lot!

  • Hana Palkova (Jul 18, 2017)

    Wonderful course with practical examples which I will apply/use step by step in my real work case where I am preparing PowerBI dashboards for management! Thanks Alberto & Marco! Good work!

  • Kevin Hankins (Jul 17, 2017)

    This is fantastic, thank you very much.

  • Neale Blackwood (Jul 17, 2017)

    Great course! The explanations were all well presented and understandable - well done!

  • Cable (Jul 15, 2017)

    Very useful course. Thanks.

  • Paulo Rocha (Jul 15, 2017)

    Amazing course provided for free. I already did the Mastering DAX Workshop and it was refreshing seeing a summary of the most important topics in DAX. Thanks Marco and Alberto for leading the way into BI Excellence!

  • Robert Jansen (Jul 13, 2017)

    Great! I think for beginners it is still a lot to understand. Only with a lot of practice you can master it.

  • David Linnemann (Jul 12, 2017)

    This was a great intro to give you an understanding if the Mastering DAX course is for you.

  • Émerson Corrêa (Jul 12, 2017)

    Excellent introduction course. Can’t wait to start the full one!

  • Thomas Martens (Jul 11, 2017)

    Even if I consider myself as a data visualization expert this course provides new insight especially how to "tweak" certain visuals to accomplish the visualization.

  • Gene Konov (Jul 10, 2017)

    Fantastic job guys, thanks a lot!

  • Ezequiel A. Costa (Jul 10, 2017)

    It was a great course. Congratulations.

  • Beng Hwa Chan (Jul 9, 2017)

    An excellent introduction to DAX course that is useful not only for beginners but also for some at the intermediate level. Helped to bridge gaps in the understanding DAX.

  • Juergen Fassbender (Jul 6, 2017)

    What a clear and good to understand introduction to DAX. Thank you!

  • Hafiz Gafurov (Jul 6, 2017)

    Good course. There is many great ideas.

  • Ben Lay (Jul 5, 2017)

    Great information laid out in an easy to understand way.

  • Paulo Rocha (Jul 4, 2017)

    I highly recommend this course to everyone who is in BI area and congratulate Alberto and Marco for providing us such a comprehensive and well structured material. Keep up the good work!

  • Yusuf Hamzah (Jul 4, 2017)

    Even if you are a very artistic person and very proficient with Excel, I would still recommend the course. It is explained very clearly. You might not agree with all the rationale but still the exposition (of good or bad) is acceptable. It consolidates and polishes my Excel reporting skills in a much more refined way.

  • Raisur Rahman (Jul 2, 2017)

    Finest course I have ever purchased. If your want to learn DAX it is a must.

  • Hans Bamesberger (Jul 1, 2017)

    I think that Alberto´s and Marco´s video courses cannot be topped. Simply the best. Not just professional content but also a lot of passion. I think after attending their course every student wants to become a BI professional. Many thanks to the twins Alberto and Marco.

  • Hongyuan Lin (Jun 29, 2017)

    Excellent Course for DAX beginners. Look forward to additional courses!

  • James Tallman (Jun 29, 2017)

    Awesome introduction. Gives you a good round exposure for different functions to entice you to go play with your models.

  • LOGAN MERAZZI (Jun 28, 2017)

    It's the best DAX course I've ever made. Pretty much detailed and very mind opening. Thank you all and congrats!!! Keep up the good work!

  • Paulo Rocha (Jun 26, 2017)

    SQLBI is the leading company in BI nowadays! The material provided and the expertise of Maestros Marco and Alberto are unmatched. After reading "The Definitive Guide do DAX" and attending the DAX Workshop in London, I have no doubt this is the best course available today. I'm also enjoying the new course Power BI Dashboard by SQLBI.

  • Tim Stacy (Jun 25, 2017)

    I am only half way through and absolutely love the video. I very much appreciate the back and fourth dialog, which keeps my interest...not to mention for the entertainment value. Great team work! Tim:)

  • Yusuf Hamzah (Jun 25, 2017)


  • Yusuf Hamzah (Jun 24, 2017)

    I have read a book about Power Pivot before watching this webinar. But I still find the webinar to be helpful in consolidating many ideas. Overall, I would recommend for anyone starting on Power Pivot.

  • Eugene Polonichko (Jun 23, 2017)

    Thank you. It was amazing!!!

  • Burovtsev Vyacheslav (Jun 23, 2017)

    This is the best course I`ve ever wathed!

  • Jacky Fu (Jun 23, 2017)

    great course.

  • Michael Woodman (Jun 23, 2017)

    Really helpful introduction. This sort of input is really needed in order to avoid frustration and poor understanding. Thank you.

  • Donald Parish (Jun 22, 2017)

    Great use of screen with instructor. Much more like watching a real class than just watching a screen. Especially with the Italian hand gestures!

  • Peter Hofmann (Jun 20, 2017)

    This is a wonderful course! I like the way it explains the best usage of visuals and get's to the point that dashboards are supposed to provide information to the user. At this point I have enough arguments to go back to my business users and ask "what information is this dashboard providing you or the audience you wish to target"? In my opinion the money I spent for the course is well worth it! Thanks to the team at SQLBi for putting this together.

  • Mark Bond (Jun 20, 2017)

    A great reference point for designing dashboards. The checklist is very useful.

  • Vanessa van Gelder (Jun 20, 2017)

    An excellent way to jump start into DAX as well as being valuable to to those like me who have been doing it a while but are always trying to fill in the gap, returning to the basics when you know more etc.. Definitely one that will be watched more than once though as DAX is not an easy language to get your head around at first. I enjoyed the banter too. My only suggestion is; which might be a bit cheeky because its free, is to have a short assessment in the end, to identify what learnings you need to focus on.

    • Hi Vanessa, thanks for the feedback! It is not easy to add video content - the studio recording requires a certain amount of planning and preparation. Do you think that a written guide could be useful?

      Reply by SQLBI (Jun 20, 2017)

  • Kenny McMillan (Jun 18, 2017)

    Very nice course and I have already started to alter my dashboards based on the recommendations. The section on colour blindness was very helpful. Would be nice to have a section on R visuals also in the future. Very helpful handouts also contained in the course. Bravo

  • Julian Chen (Jun 18, 2017)

    It's a wonderful learning journey to DAX. I watched the lecture of context transition repeatedly to gain a better understanding. It's worthy to spend the time on it.

  • Hong Nguyen (Jun 17, 2017)


  • Oscar Zapata (Jun 16, 2017)

    Excelent , very detailed and specially useful for excel pros that have little experience with database concepts (normalization,modeling, querying, etc.,)

  • Tom Littlejohn (Jun 15, 2017)

    One of the most effective video courses that I've ever taken. Very well organized, wonderfully communicated. Well done!

  • Sobieslaw Kulej (Jun 15, 2017)

    Really good one; especially the practical usage cases

  • Mario Anzaldua (Jun 13, 2017)

    Great introduction to DAX. Even with a few DAX books on my shelf, this video course clearly outlined the essential concepts necessary to start coding with many of the basic functions. By the end of the course, I could author formulas needed to generate key BI calculations in a tabular model--including functions like CALCULATE, FILTER and Time Intelligence. This course was well worth the investment. Highly recommended for beginners and those needing a firm DAX foundation.

  • Angela Dimmick (Jun 12, 2017)

    Great help in starting to use this easy to understand language.

  • orxanbabashov (Jun 12, 2017)

    Thanks so much.It was so useful!

  • Arkadius Bombka (Jun 10, 2017)

    Like the 2 Masters of DAX always say, you have to learn first the theory. This tutorial in combination with the DAX Guide is a very good start. Slowly some code make finaly sense. Truly a very good way to approach into the BI world.

  • Viorel Ca (Jun 10, 2017)

    Outstanding presentation. A lot of complex concepts explained very simply. Very useful! Thanks a lot! Viorel

  • Gerson Viergutz (Jun 9, 2017)

    Amazing. Congratulation.

  • Elena Shuvalova (Jun 9, 2017)

    Great course! Thank you!

  • Andras Ujszaszy (Jun 7, 2017)

    Was a great course. Thank you.

  • Yoshi Deguchi (Jun 6, 2017)

    Why you guys are arguing? Hard to follow the course.

    • Yoshi, can you explain what you mean with your question? Is it something related to specific part of the training, or is it a general comment? If you can provide some more detail, it could help us understanding the issue and improving the course. Thanks!

      Reply by SQLBI (Jun 7, 2017)

  • Eric Theil (Jun 6, 2017)

    Received some excellent tips, advice, and guidance during this course. Highly recommend for anyone getting started with representing data visually.

  • John McNally (Jun 6, 2017)

    Superb work by the SQLBI team. Alberto and Marco explain the visual design skills that are needed to create effective dashboards. They distill the design approach into 15 Rules and describe each one with clarity. The course starts out with a "pretty" looking dashboard (typical of what you might encounter on the web or in slide presentations), and is slowly decomposed, repaired, and improved. Through this process, the viewer gains valuable insight into the reasons why some visuals do not work. This is just as important as knowing which visuals do work, and under what circumstances. Having recently read several books on dashboard design, I can see how masterfully the SQLBI team presents this material. The course covers the best practices and fundamental skills for the effective display of quantitative information on a dashboard. Highly recommended!

  • Amazon Customer (Jun 5, 2017)

    Marco and Alberto are modern-day Rock Stars in the World of Power BI, and by rock star, I mean all the positive attributes: highly talented and always put on a great show, and with non of the negatives, as in trying to show they are clever and working the audience for applause. I had previously owned the first edition, which I was quite satisfied with, but the technology moves fast, and it just makes sense to pop for the 2nd Edition as well.

  • Walter Biffi (Jun 5, 2017)

    I found the overall material interesting and appropriate but a bit pricy. I like the approach taken by showing how to find miss used visuals and using the outline rules to refactor an existing document. However, I think that the final result was still too crowded and difficult to read. There was still too much information to digest and not enough breathing white spaces, too clattered. I am a consumer of your various material and I do appreciate everything you're providing to the community. Thank you!

    • Balancing density and readability is one of the challenges of a dashboard - the risk is creating too many of them. It's certainly useful to get constructive feedback, we'll consider it in future revisions. Thanks!

      Reply by SQLBI (Jun 5, 2017)

  • Darren Weinstock (Jun 5, 2017)

    I give it a 4.5. I think a conclusion chapter would be great! Overall great job guys! Look forward to completing your SSAS 2016 book and the Mastering DAX recorded course! Keep up the good work.

    • Thanks for the feedback! We will consider it in future revisions.

      Reply by SQLBI (Jun 5, 2017)

  • Chris Turnbull (Jun 1, 2017)

    Absolutely fantastic, the best £60 that I have ever spent. I have seen a lot of Dashboard Courses but this is done in a very different way. Not only do Alberto and Marco tell you what you should be doing but just as importantly they tell you not what to do and why. The methodology of starting with a bad Dashboard and turning it into something special is absolute genius. Thanks boys

  • VICTOR RUIZ (May 31, 2017)

    It was exactly what I was looking for! THANK YOU! EXCELENT JOB!

  • ronan dodworth (May 30, 2017)

    excellent !

  • Sadek Alaoui (May 18, 2017)

    Extremely satisfied.

  • Vanessa Cerda (May 15, 2017)

    It easy to follow, cover in detail a lot of information

  • Sadek Alaoui (May 14, 2017)

    Highly Satisfied!

  • Tamas Polner (May 11, 2017)

    I just got it a couple days ago, ordering from MS Press. It's a great book from Alberto Ferrari and Marco Russo again. Not completely a beginner book, but good for those people as well, who already have some experience with Power Pivot/Power BI or some other BI solutions, and want to move to SQL Server Analysis Services Tabular mode. It's a completely revised version of a previous book on SQL Server 2012. Since they published a detailed book on DAX (The Definitive Guide to DAX - which is a great book btw) more than a year ago, this has less focus dedicated to DAX. It covers the DAX basics, but you would need the other book as well for a professional level. This book now focuses more on setting up, loading data, operating and working with Analysis Services. MS is doing a great job on developing Analysis Services (in Azure as well) - so it is difficult to keep up with all the developments. The book is as current as possible (currently covering compatibility level 1200) - with even some glimpse into the future, but would not be able to cover everything from future updates. Probably would be a great idea to publish small booklets to update the book with new developments in the future. What I really like - there is a dedicated chapter for TMSL - Tabular Modeling Scripting language - a JSON format, which was introduced in compatibility level 1200. So even if you know most of the things from previous books, this chapter is worth buying this book as well. All in all, it's a great addition to a BI professional's library, but definitely buy the Definitive Guide to DAX with it, if you don't have it already. The two books go together well hand in hand.

  • Larry Johnson (May 11, 2017)

    I've just started reading the book. Looks great. It's not a big book at just over 200 pages but in some ways that's good. It's focused on concepts of building data models which is a critical skill for finance analysts. Is focused on practical examples and illustrations. I've bought all of the previous books by these authors and found them all to be great.

  • Wim Peers (Apr 12, 2017)

    Excellent course!
    Essential material if you want to learn what happens under the hood of Dax. When you are using Dax and you are unable to explain the results you obtain in your pivot tables, this is the course to follow! Crystal clear explanations, very good exercise labs and discussion boards that are closely followed, whenever you have questions. The quality of the videos is of the highest standard and it is no coincidence that all users are giving the course a 5-star rating. If you are working with Dax, this course will teach you everything there is to know and then some more. Thank you Marco and Alberto, hope to see many more video courses from your team in the future!

  • Greg C Coopman (Feb 18, 2017)

    Best Course Ever Taken !!!!
    I have been a SQL Server BI learning machine for 20 years (at least.) I have watched countless video courses and this course is the BEST !!! Why do I say this? I say this for one reason, the more advanced concepts around DAX are very difficult to understand. It is much harder than any regular database/programming type subjects/courses I have taken. Microsoft, I believe made a mistake, stating that DAX was easy because it used many Excel functions. To really benefit from DAX you must go deep and clearly understand the concepts (otherwise everything just merges together into a nonspecific understanding), and this course finally explained and differentiated these DAX concepts in a way that clicked. In this course, Marco and Alberto filled in the gaps, with more extensive focus on these concepts. I am no stranger to difficult languages. I have been doing MDX for over 15 years and really like it. It also had a steep learning curve. I almost did not buy this course, because of earlier courses / books that were just not getting me there. I reluctantly purchased the course as a last ditch effort (I know DAX is critical to the future of BI), and I am so glad I did. Absolutely thrilled with this course. Thanks Alberto and Marco, Greg Coopman

  • Ron Sonntag (Jan 3, 2017)

    The Best of the Best
    Marco Russo and Alberto Ferrari are consummate and masterful teachers and presenters. The course materials are organized expertly with a gradual progression towards the more complex. While intellectually challenging, Marco and Alberto manage to keep your interest with applicable examples and explanations - and some humor mixed in. Even though the course covers a vast space of DAX concepts, I would strongly recommend buying "The Definitive Guide to DAX" as a companion to the course and for further in-depth study. Bravo to you both!

  • John M. Mcnally (Oct 18, 2016)

    The Definitive Guide to DAX is the BEST, most in-depth treatment of the DAX language and DAX engine (VertiPaq). It is best suited for someone who already is familiar with the DAX language. Every aspect of the DAX language is introduced in a logical progression, including Evaluation Contexts, Time Intelligence, and Relationships. The insight and low-level details that Marco and Alberto provide are unique to this book. Later chapters describe the Vertipaq engine, and how to optimize both the data model and DAX queries. There's also plenty of examples on using DAX Studio (this is something I couldn't find in any other books). If you are looking to REALLY learn DAX, then this book is for you. It takes time and effort to get through all of this material, but it is well worth it. Marco and Alberto are the DAX Masters! Their DAX Workshop video is based upon the content in this book, and is excellent. Highly recommended.

  • John McNally (Jul 8, 2016)

    Master DAX from the Masters themselves!
    This is the video equivalent of the Mastering DAX Workshop training. The DAX masters themselves, Alberto Ferrari and Marco Russo, teach the course together. It is very organized and well thought out. There are video lectures and an associated exercise workbook to reinforce the material. All the sample Excel files can be downloaded, along with the lecture slides. Video lectures are guided by the slides, and include demonstrations of the DAX concepts using PowerPivot. Questions can be posted and the authors will answer them! Alberto and Marco provide in depth explanations and insights to the inner workings of DAX. They also give recommendations based upon their years of experience working with DAX. This is exactly what is needed to become a DAX master. I am extremely pleased with this video course. It offers tremendous value for the price and I highly recommend it to anyone wanting to attain DAX Master status!

  • Thomas Tucha (Jul 2, 2016)

    How can one train better DAX?
    Amazing - in my view this team is unbeatable when it is about SSAS Tabular or DAX training. I love the clear concept & perfect format of this DAX course. Alberto & Marco are pointing out each hurdle that may pop up by applying DAX formulas, supporting your learning curve with online samples discussed from different angles and great accompanying self-training material.

  • Jolanda Schut (Jun 29, 2016)

    I followed your 3-day course 2 months ago and this video course is a great reference guide! When the explanation is going too fast I can rewind :)

  • tahoedenizen (Jun 9, 2016)

    This is certainly the definitive guide to the DAX language, which is growing in popularity since it can be used in Excel, Power BI, SQL Server Analysis Services, and other Microsoft tools. DAX is quite easy to use in common cases such as creating a calculated column, but in more advanced cases it offers incredible power, provided you know what you're doing. For users who want to go beyond "recipes" and really understand how DAX works, this book provides clear and thorough explanations of the concepts underlying DAX. Further, it offers great insights into the operation and performance of the Vertipaq / xVelocity engine that processes DAX expressions, enabling you to write queries that run as fast as possible. You have to invest time to get the most out of this book, but if you're using DAX in serious BI applications, the payoff is well worthwhile.

  • Jean (Mar 30, 2016)

    I am only at the middle of chapter 12 but I feel compelled to recommend this book to anyone who wants to get serious about PowerPivot. After completing the whirlwind introductory tour of PowerPivot in Kasper DeJong's book, the Russo-Ferrari book takes you up to an entirely unsuspected new level. This time, ditch the inflatable arm cushions and get ready for a deep-dive into the core of it all. Be warned: this is one serious book worth both every penny and every hour spent on it. It should probably not be the first book to start up from zero - a rank beginner will most be likely be completely overwhelmed. Kasper de Jong's looks like a more suitable kickstart book. It begins easily enough, until you land in chapters 7 and 8 regarding the evaluation context. The confidence you gained so far is in for a major challenge. This is the land mine field where the first wrong turn puts a swift end to your illusions of being PowerPivot-ready. Chapter 12, covering Time Intelligence is also great at explaining what is involved. The authors made a special effort to highlight a few cases where it is better to use Excel instead of DAX and the PowerPivot data model. For instance, enriching a calendar table to identify working days and statutory holidays. It is shown how it could be done by forcing a new relationship but conclude that the extra effort and complication is totally unwarranted as there is no corresponding return for doing it the hard way. In addition to the crystal-clear explanation of the key topic (evaluation context), this book is accompanied with a large set of ready-made Excel spreadsheets (from an open Internet site). I am simply amazed at the level of detail that was put in producing these spreadsheets which consistently match exactly the screenshots in the book. Up to chapter 13, I have not found a single instance where the results shown in the book do not match what I can experiment with using the spreadsheets. That alone is a tour de force.

  • Gonzalo Rengifo (Sep 8, 2015)

    Very comprehensive and detailed patterns for PowerPivot.

  • Larry Johnson (Mar 19, 2015)

    Fantastic book for more advanced users. I've learned so much from all the books by this author on powerpivot. This is great in going into detail on several advanced ways of doing complex analysis reporting.

  • Peter Heller (Mar 8, 2015)

    Excellent book. It brief and succinct with excellent examples. I have lent my copy to others at work to look at too get an overview. I then suggested that they buy their own copy as a reference tool.

  • John M. Mcnally (Dec 10, 2014)

    The authors are well known BI gurus, who have unique insight into how the PowerPivot DAX engine functions under different conditions. This book was a slow read for me, with so much technical depth to comprehend. But it provides information on PowerPivot that I haven't encountered in other PowePivot books. I found myself reading sections over and over again to try to understand what was being explained. The material can be complex, and maybe I would have preferred a few modifications to the way the material is explained. But the information is there, and it is worth the work to conquer it, to become, as the authors say, a "DAX master". The only aspect I was disappointed with are the sample excel workbooks that go along with each chapter. At times I found them to be incomplete, in terms of following the examples that are cited in the text. This can be frustrating when trying to understand new concepts. However, the book is brilliant, so this doesn't discourage me from giving it 5 stars.

  • Rick Oller (Jul 30, 2014)

    Expert Cube Development with SSAS Multidimensional Models is a thorough, in-depth tour of SSAS 2012 from the Multidimensional models perspective. The authors state up front that this is not a book about SSAS Tabular models and this is an important distinction to keep in mind, as it affects the entire approach to SQL Server BI, from the installation of SSAS forward. We are taken through a basic cube setup, mercifully not using the Northwinds sample database. I like how the authors repeatedly caution that a number of key elements need to be gotten right in the data mart before cube setup begins. While these elements can also be dealt with in the cube definition, it doesn’t mean they should be, and that distinction is borne out by experience, which the authors clearly have, in spades. We are presented with a number of useful components of SSAS Multidimensional Models including Measure Groups, Drillthroughs, Calculations (with a smattering of MDX code, about as much as I could handle) and some useful chapters on security and performance tuning. I was relieved that this was not a 1,000+ page book designed to monopolize shelf space in the tradition of old school technical book publishing. For me, it struck a good balance between level of detail and keeping things moving, so I was able to productively work through it in a reasonable amount of time. For a fairly dry topic the authors managed to keep it interesting, although it helps as a reader if you have some cube exposure (as I did) prior to attempting this book.

  • Philippe Geiger (May 25, 2014)

    First, the authors are not unknown, it is the best experts in their field. Chris Webb, Alberto Ferrari, and Marco Russo are known for their decision-making skills. Then, the content of the book is at the height of the quality of these authors: in a Word, perfect. When many books introduce basic information for who want to begin to create a cube, this one goes further: the examples are well chosen and sufficiently complete. In a few words, it's the book that anyone must have (like me) to improve the functioning of their multidimensional models.

  • Gilbert Quevauvilliers (Mar 26, 2014)

    This book is a must read if you are looking for some useful and practical information in your SSAS Multidimensional models. But it must be noted that this is not an introduction into SSAS Multidimensional modelling, rather practical real world examples. I found that the book is a wealth of information that can be applied to your working environment. There are a lot of real world examples that I have had a look at and made me check and update my SSAS Multidimensional models so that they can be that much faster and quicker. It is also a great reference book, for when you are looking for a specific issue, where you can find the requirement and how to solve your particular issue. I also really enjoyed the book, because it got straight into the requirement and then explained how to potentially solve or improve your requirement. Along with this I found that it was great where they applied their working experience in what they encountered and how they overcome an issue. It is written by the guys who I consider to be some of the leaders in SSAS Multidimensional modelling. And you can see by the context of the detail in the book, as well as their examples that this happens often in the working environment, and how to get the best performance from your SSAS Multidimensional models. A great read and I would recommend this book to anyone who is looking for a wealth of information as well as some great insight into the inner workings of SSAS Multidimensional models.

  • Cab (May 21, 2013)

    This book is is targeted at Excel users who want or have to learn about Powerpivot and Dax. . It not only explains how to write calculated fields (or measures) and columns, but also gives you a lot of Information about databases and business intelligence and of courese, all things you can do with Dax and Powerpivot. The great thing about this book is that the authors were able to combine their great technical knowledge with the experience of having teached Dax for the last two years to Excel users all over the world. They know where the difficulities lie, which concepts are difficult grasp for an Excel user and how to best explain them so that they are easily understood. In case you are using Excel 2010, it is still extremely useful, as only a small portion of the book is limited to things only available in Excel 2013, and it might be good to know about them anyway.

  • roberbaron (Sep 7, 2012)

    This is simply the best book out there to understand the great power that is behind this tool. If you take short time to sit down and read it, it can save you endless hours of work and thousands of dollars - not to mention an enhanced understanding of databases. Yes, there are some parts that take a little work to follow, but its worth it trust me. I 've read all the other books - many are good - but if I had to choose one, this is it. It is now required reading for all my staff and coworkers. It saves time, money and allows us to do things we were never able to do before.

  • Daryl Turk (Feb 5, 2012)

    This is a must have book. One of the biggest problems with PowerPivot is the translation of Denormalizatied tables into Excel Pivot Tables. This basic knowledge is required for people performing Data Analysis or Business Analytics. This book talks about master tables and one to one relationships, one to many relationships, and discusses ways to denormalize the data. Trying to search for the topic of "how to convert this information into Excel format", is difficult and confusing. Many of the business Analytics Reports I receive are derived from Excel Pivot Tables. Many of these reports are wrong because the person creating the reports does not understand the pit falls of averages aggregated data. This book clearly defines the issue and show how to detect and solve the problem.

  • PaulH (Sep 10, 2011)

    This is an outstanding book that is easy to read and understand, and progresses at just the right pace. I am a power Excel User with a strong understanding of our system data structure but I am not a SQL programmer. When I heard about Powerpivot I was immediately excited at the possibilities of ad hoc user access to data on the fly. I loaded powerpivot and quickly became frustrated and disillusioned, as there is no real documentation to help you on the way. After downloading "Powerpivot for Excel 2010 - Give your Data meaning", I was unable to put the book down, and the real power of Powerpivot is now clear to me. The book explains in simple logical progression, in language that is clear to a non programmer. Within hours of starting to read, powerpivot has been opened up to me, and I am again excited at the possibilities.

Do you prefer a course in classroom?

This video course is based on a live, classroom course we teach all around the world. If you prefer a live learning experience, take a look at the dates below for a list of our upcoming events!
 Copenhagen, DK Oct 22-24, 2019
 Seattle, WA, US Nov 12-14, 2019
 Toronto, ON, CA Nov 12-14, 2019
 Amsterdam, NL Dec 10-12, 2019
 Amsterdam, NL Feb 18-20, 2020
 Munich (München), DE Mar 31-Apr 2, 2020