Excel PRO TIP: CUBE Functions | Udemy Instructor, Chris Dutton [Best-Seller Udemy Course]

No video

Excel PRO TIP: CUBE Functions | Udemy Instructor, Chris Dutton [Best-Seller Udemy Course]

Рет қаралды 39,765

Күн бұрын

In this video, Excel PRO TIP: CUBE Functions, you'll learn how to use CUBE functions to connect external SQL data sources to provide data analysis.
Take the full course on Udemy with the following discount: bit.ly/2TFW1bE
Discover 75+ Excel tips & techniques to work smarter, boost productivity, and become a certified Excel POWER USER
What you'll learn
- Build tools to help you automate, streamline, and absolutely revolutionize your workflow with Excel
- Explore 75+ unique tips, tools and case studies that you won't find in ANY other course, guaranteed
- Get LIFETIME access to resources, Excel project files, quizzes, and 1-on-1 expert support
- Master data analysis tools like Goal Seek, Scenario Manager, - Solver, and Analysis ToolPak
- Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor
- Become an absolute Excel POWER USER
#LearnExcel
#ExcelCubeFunctions
#Excel
#Udemy
#ITeachOnUdemy
Share your story with #BeAble

Пікірлер: 21

@Accelerate-Excel Ай бұрын

Cube functions should be much more popular, given how powerful they are

@shakingAami11 11 ай бұрын

Excellent work. I must say Chris is a serious master of his craft and on top, his teaching skills related to complicated concepts are exceptional. Thanks a lot for sharing.

@ckcalvins 4 жыл бұрын

In your example, what if you wanted to rank brands by multiple dimensions? Let's say you wanted to rank the top brands for the month of April by descending transactions? How would you manipulate the cubeset formula to be able to add multiple dimensions?

@carlorf 3 жыл бұрын

How can I display a CUBEVALUE including more than a single CUBEMEMBER? Let's say Transactions of Silver & Golden together?

@stevennye5075 3 жыл бұрын

Complex but useful

@chavelooo33 3 жыл бұрын

Excelent, Excelent & Excelent. Thanks for sharing

@future62 2 жыл бұрын

Thanks for posting this. This will def help me on my way to building dashboards from Data Models. One question though- and I will try this later. But could you use the INDIRECT function to be able to avoid using the CUBEMEMBER functions in the row/column headers? The CUBEVALUE functions would be long, but then the tables would become dynamic and easier to manipulate in the future. I will give it a try and report back.

@jaiconruedas 3 жыл бұрын

This is really amazing..better than getpivot and all

@m.bouguerra Жыл бұрын

salut ... grand merci pour cette vdéo très intéressante.. est-ce que vous pouvez mettre le fichier utilisé dans cette vdéo en téléchargement

@SyedMuzammilMahasanShahi 2 жыл бұрын

Wow. Great. Learnt new thing today

@AbhishekGuptaDoha 7 ай бұрын

Where can I find the video where you built the measures.

@rashadalexander3270 Жыл бұрын

Would you able to use if statements in conjunction with the cube functions?

@ngunghuong6938 2 жыл бұрын

Thank you so much!

@krishnamurthy7721 2 жыл бұрын

Great fantastic keep it up and thanks

@naimishsiddhpura2433 9 ай бұрын

I followed you and wrote Cubemember formula but instead of returning values like Planned, Actual, Committed; it returned values like 0, 02, 03 and 04. Can you advise why this formula didn't work for me?

@telclissonperes 3 жыл бұрын

Nice video! Could I use references with ?, * signs?

@stuartsaint4581 4 жыл бұрын

Wish I'd known about this video when I first learnt about cube functions, had to learn the backwards way of pulling data from Power BI. One question: on the CUBERANKEDMEMBER I always use .children instead of .members, will this produce any variance in results?