From Data To Data Model ► Then Analysis with CUBEVALUE Function
8 هزار بار بازدید -
4 سال پیش
-
In this tutorial, We combine
In this tutorial, We combine multiple text files from a folder. Each file contains thousands of records. We clean and Transform the data in Power Query and create an M function. We send the data to the Data Model in Power Pivot and create a DAX function and a Pivot Table. Finally with a drop list we filter the data in the Data Model using a CUBEVALUE function.
Correction: I mistakenly mentioned at 10:37 "Implicit Calculation" for the measure "Total Profit" while it is an "Explicit Calculation" but it skipped my revision.
You can Download All the exercise files and follow along by clicking on the link:
https://www.Officeinstructor.com/from...
************************** Book A Corporate Training ************************************
***************************** With Nabil Mourad ****************************************
************************ www.OfficeInstructor.com ************************************
What is this NEW Series: “Straight To The Point”?
This series is a Fast Production high quality content where I start explaining right away without custom Intro, or Outro and with just the necessary annotation to shorten the video production time considerably.
With the introduction of this Series you will have a much wider variety of Tutorials, that complement each other:
1- My regular “Deluxe” video tutorials with a Story telling Intro, intense annotations, a Step by Step blog article, Exercise File and a custom Outro.
2- My Graphic Series: ”In A Capsule” which is short Fully Graphical explanation targeting everyone using Excel without language barrier.
3- STTP or “Straight To The Point” series: where I dive right into the topic. All the series will offer the high-quality content that you expect from me. I will try to balance between the 3 types but I definitely wish to get your advice and recommendation because All that is done for you.
************************** Book A Corporate Training ******************************
***************************** With Nabil Mourad ***********************************
************************ www.OfficeInstructor.com *******************************
Music Credit: News Theme by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/...) Artist: http://incompetech.com/
Beach Bum - Happy Rock by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/...) Source: http://incompetech.com/music/royalty-... Artist: http://incompetech.com/
Now, let’s go straight to the point. From Data to Analysis!!
Correction: I mistakenly mentioned at 10:37 "Implicit Calculation" for the measure "Total Profit" while it is an "Explicit Calculation" but it skipped my revision.
You can Download All the exercise files and follow along by clicking on the link:
https://www.Officeinstructor.com/from...
************************** Book A Corporate Training ************************************
***************************** With Nabil Mourad ****************************************
************************ www.OfficeInstructor.com ************************************
What is this NEW Series: “Straight To The Point”?
This series is a Fast Production high quality content where I start explaining right away without custom Intro, or Outro and with just the necessary annotation to shorten the video production time considerably.
With the introduction of this Series you will have a much wider variety of Tutorials, that complement each other:
1- My regular “Deluxe” video tutorials with a Story telling Intro, intense annotations, a Step by Step blog article, Exercise File and a custom Outro.
2- My Graphic Series: ”In A Capsule” which is short Fully Graphical explanation targeting everyone using Excel without language barrier.
3- STTP or “Straight To The Point” series: where I dive right into the topic. All the series will offer the high-quality content that you expect from me. I will try to balance between the 3 types but I definitely wish to get your advice and recommendation because All that is done for you.
************************** Book A Corporate Training ******************************
***************************** With Nabil Mourad ***********************************
************************ www.OfficeInstructor.com *******************************
Music Credit: News Theme by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/...) Artist: http://incompetech.com/
Beach Bum - Happy Rock by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/...) Source: http://incompetech.com/music/royalty-... Artist: http://incompetech.com/
Now, let’s go straight to the point. From Data to Analysis!!
4 سال پیش
در تاریخ 1399/06/14 منتشر شده
است.
8,054
بـار بازدید شده