Search Results for "many to many"

Many to Many Relationships in DAX Explained

Level: Advanced (but explained in detail so everyone can understand) There is a lot to learn in DAX if you want to be a ninja.  A couple of the more complex and important things to learn and understand are filter propagation and context transition.  It is not so much that you need to be a […]

Relationships in Power BI and Power Pivot

Level: Beginners Power Pivot is a database that has been designed from the ground up to be optimised for reporting and analysis in Power BI, Power Pivot for Excel and SSAS Tabular.  The technology is essentially the same across all of these products so I will generically refer to Power Pivot in this article. Power […]

Learn to Write DAX Online ANZ Time – Semester 4 2017

This training course  “Learn to Write DAX Online” is based on my book “Learn to Write DAX  – A Practical Guide to Learning Power Pivot for Excel and Power BI”.  The course uses the book as a study and learning guide so that you can learn remotely where ever you are while still having the benefit of 6 live Webinars where Matt reviews the major concepts and gives you a chance to ask questions to enhance your learning and understanding.

The book “Learn to Write DAX” is not included in the purchase price of this Online training due to the logistical challenges of shipping globally and the fact that many people may already own the book.  You must however have a copy of the book to complete the course. If you already have a copy of the book then you can use that, or you can refer to my book page here to find a suitable place to purchase the book.  Note if you purchase from me or MrExcel, you will receive a free Digital copy with the purchase of the physical book.

Benefits of This Course

The course has been specifically designed to provide the following benefits.

  • You get to learn incrementally over a 5 week period in your own time.  Just find 20-30 minutes per day.
  • You get direct access to me (Matt Allington) to ask for clarification to any questions you have.
  • There is a weekly Webinar where I explain the concepts that are harder to learn yourself.  You can ask any questions you have at these sessions.
  • The cost is very affordable compared with a comparable live training course (about 80% cheaper)

This is an Australia/NZ friendly time zone semester of the course however anyone else from any other country is welcome to join if the time windows suit your needs.

Schedule for Online Webinars
The online Webinar sessions are scheduled as follows:
[table caption="" width="650" colwidth="150|100|100|100|100|100" colalign=”left|left”]
Date,Topic,Time Auckland,Time Sydney,Time Perth,Duration
Wed 21st Jun 2017,Kick Off,2 pm,12 noon,10am,30 minutes
Wed 28th Jun 2017,Week 1,2 pm,12 noon,10am,60 minutes
Wed 5th Jul 2017,no,session,this, week,planned
Wed 12th Jul 2017,Week 2,2 pm,12 noon,10am,60 minutes
Wed 19th Jul 2017,Week 3,2 pm,12 noon,10am,60 minutes
Wed 26th Jul 2017,Week 4,2 pm,12 noon,10am,60 minutes
Wed 26th Jul 2017,Week 5,2 pm,12 noon,10am,60 minutes

[/table]

Learn to Write DAX Online EU Time – Semester 3 2017

This training course  “Learn to Write DAX Online” is based on my book “Learn to Write DAX  – A Practical Guide to Learning Power Pivot for Excel and Power BI”.  The course uses the book as a study and learning guide so that you can learn remotely where ever you are while still having the benefit of 6 live Webinars where Matt reviews the major concepts and gives you a chance to ask questions to enhance your learning and understanding.

The book “Learn to Write DAX” is not included in the purchase price of this Online training due to the logistical challenges of shipping globally and the fact that many people may already own the book.  You must however have a copy of the book to complete the course. If you already have a copy of the book then you can use that, or you can refer to my book page here to find a suitable place to purchase the book.  Note if you purchase from me or MrExcel, you will receive a free Digital copy with the purchase of the physical book.

Benefits of This Course

The course has been specifically designed to provide the following benefits.

  • You get to learn incrementally over a 5 week period in your own time.  Just find 20-30 minutes per day.
  • You get direct access to me (Matt Allington) to ask for clarification to any questions you have.
  • There is a weekly Webinar where I explain the concepts that are harder to learn yourself.  You can ask any questions you have at these sessions.
  • The cost is very affordable compared with a comparable live training course (about 80% cheaper)

This is a European time zone semester of the course however anyone else from any other country is welcome to join if the time windows suit your needs.

Schedule for Online Webinars
The online Webinar sessions are scheduled as follows:
[table caption="" width="650" colwidth="150|100|100|100|100|100" colalign=”left|left”]
Date,Topic,Time London,Time Berlin,Time Moscow,Duration
Wed 21st Jun 2017,Kick Off,8am,9am,10am,30 minutes
Wed 28th Jun 2017,Week 1,8am,9am,10am,60 minutes
Wed 5th Jul 2017,no,session,this,week,planned
Wed 12th Jul 2017,Week 2,8am,9am,10am,60 minutes
Wed 19th Jul 2017,Week 3,8am,9am,10am,60 minutes
Wed 26th Jul 2017,Week 4,8am,9am,10am,60 minutes
Wed 26th Jul 2017,Week 5,8am,9am,10am,60 minutes

[/table]

Learn to Write DAX Online US Time – Semester 2 2017

This training course  “Learn to Write DAX Online” is based on my book “Learn to Write DAX  – A Practical Guide to Learning Power Pivot for Excel and Power BI”.  The course uses the book as a study and learning guide so that you can learn remotely where ever you are while still having the benefit of 6 live Webinars where Matt reviews the major concepts and gives you a chance to ask questions to enhance your learning and understanding.

The book “Learn to Write DAX” is not included in the purchase price of this Online training due to the logistical challenges of shipping globally and the fact that many people may already own the book.  You must however have a copy of the book to complete the course. If you already have a copy of the book then you can use that, or you can refer to my book page here to find a suitable place to purchase the book.  Note if you purchase from me or MrExcel, you will receive a free Digital copy with the purchase of the physical book.

Benefits of This Course

The course has been specifically designed to provide the following benefits.

  • You get to learn incrementally over a 5 week period in your own time.  Just find 20-30 minutes per day.
  • You get direct access to me (Matt Allington) to ask for clarification to any questions you have.
  • There is a weekly Webinar where I explain the concepts that are harder to learn yourself.  You can ask any questions you have at these sessions.
  • The cost is very affordable compared with a comparable live training course (about 80% cheaper)

This is a USA time zone semester of the course however anyone else from any other country is welcome to join if the time windows suit your needs.

Schedule for Online Webinars
The online Webinar sessions are scheduled as follows:
[table caption="" width="650" colwidth="150|100|100|100|100|100" colalign=”left|left”]
Date,Topic,Time US Pacific,Time US Central,Time US Eastern,Duration
Tues 20th Jun 2017,Kick Off,2pm,4pm,5pm,30 minutes
Tues 27th Jun 2017,Week 1,2pm,4pm,5pm,60 minutes
Tues 4th Jul 2017,happy,independence,day,USA, people
Tues 11th Jul 2017,Week 2,2pm,4pm,5pm,60 minutes
Tues 18th Jul 2017,Week 3,2pm,4pm,5pm,60 minutes
Tues 25th Jul 2017,Week 4,2pm,4pm,5pm,60 minutes
Tues 1st Aug 2017,Week 5,2pm,4pm,5pm,60 minutes

[/table]

Learn to Write DAX Online

Overview Learn to Write DAX Online is a combination of self paced remote learning using the book “Learn to Write DAX” and weekly Webinars with Matt Allington that will give you deeper explanations of the topics plus Q&A sessions. This training course has been specifically designed to provide the following benefits. You get to learn […]

Power BI Free is the Main Problem Here

I am an enthusiastic sponsor of Microsoft BI. I have been fortunate enough to build a new career off the back of the great products Microsoft has developed, specifically Power BI, Power Pivot and Power Query.  Having said that, I am definitely disappointed with the new licensing agreement changes have been released in the last […]

Power BI Licences Changes–The Good, The Bad and The Why

Microsoft today announced that it is changing the way it licences its Power BI service product.  I want to provide my personal view on why it is doing this, what is good and also what is bad about this change. The Problem MS is Trying to Address Let me start by explaining the problem that […]

How and Where to Get Help for Power BI

Regardless of what stage you are at in your Power BI/Power Pivot/Power Query journey, at some stage you are going to need some help.  Believe me I am no different to you – we are all learning and we all need help sometime or another.  There are basically 3 options that I want to talk […]

New Power BI Reports from a Golden Dataset

Last week I wrote an article at PowerPivotPro.com explaining how to create a new report on PowerBI.com that connects to an existing dataset already loaded on PowerBI.com.  I then discovered (thanks to reader feedback) that Microsoft has already delivered a preview of a new feature called “Power BI Service Live Connection”. This new feature allows […]

The Foundations of Power BI

This book “The Foundations of Power BI” is an aggregation of more than 3 years of my hard work in understanding and sharing concepts with people on my website.  This Book is a curated compilation of many of these blog articles I have written over the years. I decided to turn my material into a Book so readers can get a focused and concentrated dose of knowledge and information in a logical, easy to consume and well-structured format. I have edited the content from my blog articles where necessary to make it a standalone book that will take you on a journey from discovery to a point where you can confidently commence to use the tools Power BI, Power Pivot and Power Query.

Which to Use – Power BI or Excel?

Level: Beginners One of my regular blog readers (and graduate of my live training course) Phil Cross asked me last week if I knew of anywhere to find a comprehensive guide for Self Service BI users of when to use Excel vs Power BI to author new data models. I thought this would make a […]

Uses for DAX as a Query Language

This is the final article in my series about DAX as a Query Language.  In my first article I introduced DAX as a Query Language and then in my second article I went in deeper to the specifics on how to use some of the more useful DAX query functions.  In this final article today […]

DAX as a Query Language Part 2

In my last article I introduced DAX as a Query Language and explained why learning to query your data model can be useful.  I covered the basics about using a tool like DAX Studio to query a database and return a table of data as a result.  In this article I am going to go […]

An Introduction to DAX as a Query Language

Level: Intermediate I have written quite a few articles that contain embedded references to DAX Queries and DAX Table functions in the past.  Today I am writing an article that introduces the DAX query language from the beginning so you can learn how to use it and how it will help you to become a […]

Power BI Skills – Thinking of Data in Tables

Level: Beginners One very important concept that Excel users often struggle with when starting on their Power BI and Power Pivot journey is that they need to learn to think about data in tables rather than thinking about data in cells.  In the spreadsheet world every cell can be a different formula or value, but […]

The Top 30 Reasons You Should Be Considering Power BI

I wrote this article to be a definitive list of the top reasons you should consider using Power BI in your organisation (in case you haven’t already made the decision to do so).  In fact there is only one thing that worries me about this list, and that is I think many people may be […]

SQL Saturday Melbourne Feb 2017 Materials

I am currently in Melbourne for PASS SQL Saturday 2017.  SQL Saturday is an annual one day conference event that occurs in many major cities around the world.  It is focussed on helping SQL Server professionals learn more about their profession and also network with other like minded people.  I have a lot of people […]

Best Practices for Power Pivot, Power Query and Power BI

Level: Beginners There are many best practices for Power BI, Power Pivot and Power Query.  I know these things so intuitively now that it is very easy to forget how I incrementally learnt these things along the journey.  Most of these things are not “right” vs “wrong” – they are more often simply “better”.  I thought there […]

DAX Time Intelligence Explained

Level: Beginners I help a lot of people on forums who ask questions about time intelligence for DAX.  If you are just starting out then the chances are that you may not even be clear what time intelligence is and hence sometimes you don’t even know what to ask.  Often the question is something like […]