|
[ FreeCourseWeb.com ] DAX Power Pivot Time Intelligence - 10 Easy Steps
Download More Latest Courses Visit -->> https://FreeCourseWeb.com
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 48000 Hz
Language: English | VTT | Size: 1.37 GB | Duration: 13 section | 51 lectures | (5h 48m)
What you'll learn
Support the needs of Business Intelligence using Time Period Functions in DAX
Create running-totals with DATESYTD(), DATESQTD() & DATESMTD()
Learn how to use PREVIOUSYEAR() and related DAX functions including PREVIOUSQUARTER(), PREVIOUSMONTH() & PREVIOUSDAY()
Customise DAX ready Time Intelligence functions with DATEADD()
Learn how to create base measures including FIRSTDATE(), LASTDATE(), ENDOFMONTH() & STARTOFYEAR()
Learn how to use CLOSINGBALANCE() family of DAX functions
Understand the benefits of FILTER() to super-charge measures in place of CALCULATE()'s "simple" filters
Create a 4-4-5 Custom Calendar in Excel and relate to the existing Data Model
Learn how to recreate DAX in-built Time Intelligence functions for custom calendars
Use DAX Patterns to master navigating the custom calendar
Learn how to over-ride the incoming filter context with the ALL() function
Suppress totals and subtotals with HASONEVALUE()
Create % growth calculations and generate reports to impress
Requirements
You should be familiar with DAX Power Pivot basics i.e. how to create a data model covered in DAX Power Pivot - 10 Easy Steps for Beginners or DAX Power Pivot - 10 Easy Steps for Intermediates
The course is run in Excel 2016 - however, Excel 2013 & 2010 users can follow along
IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
This course is designed for PC users (Power Pivot is currently unavailable with Excel for Mac)
Description
This course builds upon the skills learned in the first course in this series DAX Power Pivot – 10 Easy Steps for Beginners.
You have already gotten your hands dirty with DAX & Power Pivot and seen how awesome it is. Now you are ready to take your skills to the next level by delving deeper and acquiring a more thorough understanding of how Power Pivot handles Time data.
Data Analysis Expressions (DAX) includes Time Intelligence functions to support the needs of Business Intelligence analysis by enabling you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.
Use Winrar to Extract. And use a shorter path when extracting, such as C: drive
ALSO ANOTHER TIP: You Can Easily Navigate Using Winrar and Rename the Too Long File/ Folder Name if Needed While You Cannot in Default Windows Explorer. You are Welcome ! :)
Download More Latest Courses Visit -->> https://FreeCourseWeb.com
Get Latest Apps Tips and Tricks -->> https://AppWikia.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
|
|
udp://opentor.org:2710/announce udp://p4p.arenabg.com:1337/announce udp://tracker.torrent.eu.org:451/announce udp://tracker.cyberia.is:6969/announce udp://9.rarbg.to:2710/announc udp://explodie.org:6969/announce udp://tracker.moeking.me:6969/announce udp://tracker.opentrackr.org:1337/announce udp://tracker.tiny-vps.com:6969/announce udp://ipv4.tracker.harry.lu:80/announce udp://tracker.coppersurfer.tk:6969/announce udp://tracker.leechers-paradise.org:6969/announce udp://open.stealth.si:80/announce udp://tracker.pirateparty.gr:6969/announce udp://inferno.demonoid.is:3391/announce |
