UDEMY_EXCEL_BI_LEARN_POWER_PIVOT_AND_DAX_FUNCTIONS_TUTORIAL-kEISO
- Section
-
Appz
- Group
- kEISO
- Size
- 304,71 MB
- Files
- 9
- Date
- 2015-07-07
NFO
█▀▀▀▀
▓ ████████ ░
░ ████████ ▓
█▀▀▀ ████████ ▀▀▀▀ ▀▀▓
▓ ███████████▓████████████ ▒
████████ ▄ ░ ██████████▓▒▓███████████ ░
████████ █▓▄ ▄▓█▄▄ ████████▓▀ ░ ▀▀▀▓███████
████████▌▄ ████████ ▀▀▀▀ ▄▓███████ ░ ▄▄▄▄ ▄█▄ ▄██▄ ▓▄▄ ▄ ████████
▀▀▀█████▌█ ██████████████▄ ▄▓███████▀▄▄ ▓▐████████ ░ ████████
███████▌█ █████████████▌█▓▄ ▄▓█████████████▓▄▄ ░ ▀█████▀ ▐▄▄█████▌████████
███████▌ ▄████████▓████▌█▀▀▀ ▀▀████████████████▄█▄▀█▀ ▄▌░███████▌████████
███████▓▀▄████████▓▀▄████ █ ████████▄▄█▀████████████████ ▄██▌▓████████████████
▓█████▄█████████▀ ▓██████ ▀ █████▄ ▐██████▌▀▓████████▓██████▌▀██████████▀▀▀▀▀▀
▀▀▓████████▓▀ ████████▄ ███████▐██████▌ ▀██████▀███████ ▄▀██▓████▄ ▀██▀
▐▄▄ ▀▀▓███████▄▄█▀▀▓██████▄▄▐▀▓██▐███████ ▄████▓▀ ███████ ▓ ▀░██████▄▀
▐███░▄▄ ▐████████ ░░ ▀▀▓█████████ ███████▄██▓██▀ ▀▀█████ ░ ▀▀▓████░▄
▄▄▄▄▄█▓██ ▐████████▄▄▄▄▄▄▄ ▀▀██████ ▀▀█▀███▀▀███▄ ▄▐████████▌▄▄▄░████████▓██
▐████████ ▓███████▓██████▓ ██▄▓███████████▌██████▄▀ ████████▌███▒████▀▀▀
████████ ▓█████▄▄ ▄▄████▌ █████▐█████████▌████████▄████████▓███▓████ ███████
███▀▀▀▀▀▐███ ███ ██████████████ █████████▌ ▀██▓█████▀▀▀ ▐███████▌ ███████
▄▄████ ▐█ █▄▄▄▄▄▄ ▀▀▀▀▀▓██ ███▌▀▀▀ ▄▄█▄ ▀░███████▄ ▄██████████▓███████▀▀
▀▓▀▀▀ ▐███░ ███████▌▐▀█████▄▄▄▄▀▄▄▄██▀ ▀▓███▄ ▀███████████▌▐█▄▄▀▀▀▀▀▀▀█████
▓███ ███████▌██▄▀▀▀▀▓████▄▀▓██ ▓ ▀▓███▄ ▀▀████████▌▓█████████▄▄▄▄▄
▀▀▀▀▀▀▀▀▀▐ ██ ███ ▀▀ ▓█▓ ▀▀▀ ▄██████████ ▀▀▀▀▓███▀
▀▓█▀▀▀▀▀▀▀▀▀▀███ ░░ ▀▀█▓█████▀▀▄▄▓▄▄ ▀▀███████ ▓▄▄
▀ ████████ ▀▀▀ ▄▄▄▓▓▌ ▄██▀██▄ ▀▀▓██▄ ▀▀███ ████▓▄
▄▄▄████████▄▄▄▄▓▓█████▀▀ ▐▓▀ █▄▀▓█ ▀ ▄██▄▄ ▀ ▀█▀███▌
░▄▄▄▄██████▀██████▓██████████████ ▀ ▄████▄██▄▄▄▓██ ██████▀ ▄█████ ███▄▄▄▄▄
██▓█████▓███████████░▓█████████████ ▐████████████████░█████▌ ▄▓██▀███▌████████
▓███████░██████████████████ █▓▓▀▀▀ ▐██████▓███▌█████▓█████ ▄███▀▐████▌███████▌
░▓█████▀ ███▀▀▀█████▌▀▓█████▄ ▄▓█ ▐██████▒███████▀▀▀▐██████▓▀ ▐████▌█████▄
▀██████▄ ▄▓▐██████▄ ▀▓██████ █▀▀ ███████░▀███████▄ ░█████▀▄ ▄████▓███████▌
▀▓██████ ▀▀▐█████▓▓ ▄▄██████ ▄ ███████▄▐▄▀██████▓▓▄███▄█████████░███████▌
▄▄██████ ▄█████████████▌ ███▄▄███████ ▀▓███ ▄▄▄▄▄▄▄▄ ▀▀██▓▀ ███████
░███████▌ █████▐███████████ ▐████████████████ ▐█ █████████▓▄▄ ▐███████
▌▄▄█████ ▐█████▐█████▐██████▄█████▄███████▀███▌ ██ ▀▀░▓█████████▓▄▐███████
▐███████▄█████▌▐█████ ▀█████████ █▀███████▓████▄██████▓████████████████████
▀▓█████████▓▀▄██████ █▄▄▀▀██▓▀▀ ▓▄▀█████▀▓████████▐███████▀▓█████▀▀▀████▌
▀▀▓░░▀▀▄▄███████ ▀ ▄▄▄▄█████ ▄▀█▄▀███▐▄ ▀▀░░▓▀▀▐███████ ▄▄▀▀ ░▄ ▀█▌
▄▀ ▄ ▀▄ ████████████████▓███ ██ ▓█▄▄█ ▀██▄▄▄██▀▄▄▄▄▄▄▄▄ ██▀ ▄▀ ▄ ▀▄ ▌
▐▌ ■░■ ▐▌ ████████████████████ ███ ▀▓██ ▀▀▓▀▀▄██████▓▀ ▀ ▐▌ ■░■ ▐▌
▀▄ ■ ▄▀ ███████▓▓▀▀▀▀▀▓▓▄▄▄▄ ▀▓ ▀▀▀▀▀▀▀▀ ▀▄ ■ ▄▀
▄ ▀ ▐ ▓ ▌ ▀ ▄ ▄▄▄▄▄███████████▀ ▄■▀▀▀▀▀■▄ ▄ ▀ ▐ ▓ ▌ ▀ ▄
■ ▐ ▒ ▌ ■ ▀████▓▓▓░░░▀▀▀ ▄▀ KYRIE ▀▄ ■ ▄ ▐ ▒ ▌ ■
▌ ▄▀▐ ░ ▌▀▄ ▐ ▀▀ ▄▄▄▄▄▄▄▌ ELEISON ▐▄▄▄▄▄▄▄░ ▌ ▀▄▀▐ ░ ▌▀▄ ▐
▀▄ ▄▄▓▐ ░ ▌▓▄▄ ▄▀▀▀▄ ▄▄▓▀▀▀ ▄ ▄ ▄▀▄ ▄▄▀▀▀▄▄ ▄▀▄ ▄ ▄ ▀▀▀▓▄▄ ▄▀▀▀▄ ▀▄▓▐ ░ ▌▓▄▄ ▄▀
▐▀▀▀▀▄▀▄▀▀▀▀▐ ▓▀ ▐▌ ▄ ▀ ▄▄▄▄▄▄█▀░ ░▀█▄▄▄▄▄▄ ▀ ▄ ▐▌ ▀▓ ▌ ▀▀▀▄▀▄▀▀▀▀▌
▄ ▀▀▀▓ ▀ ▀▀▀ ▀▄▄▄▀ ▓██ █▓▀▀ ▀▌▄ ▄▐▀ ▀▀▓█ ██▓ ▀▄▄▄▀ ▐▀▀ ▀ ▓▀▀▀ ▄
█▄ ▀▐ ▄██▄ ▄ ▄▄█▀ ▀▀▀▀▀ ▀█▄▄ ▄ ▄▄██▄ ▌▀ ▄█
▓█▓▄ █▄▀▀█▌ ▄ ▄█▓▀ ▀▓█▄ ▄ ▀█▀▀▄█ ▄▓█▓
▀▓█▓▄▄▓████▄▄▄██▀▀ RELEASE INFORMATION ▀▀██▄ ▄████▓▄▄▓█▓▀
▀▓████▀▓█▀ ▀▓▀ ▀▓ ▀█▓▀████▓▀
█ ▀█▓▓██▄▄██ TITLE: Excel BI - Learn Power Pivot and DAX ██▄▄██▓▓█▀ █
█▀ ▐█▒▓██░██ functions ██░██▓▒█▌ ▀█
█▀ █▓███▒█▌ ▐█▒███▓█ ▀█
█▀ ▐█▓███▓█░ ░█▓███▓█▌ ▀█
█▀ ▐██████▌ PUBLISHER..........: UDEMY ▐██████▌ ▀█
█▀ ▀▀████▓ LINK...............: http://is.gd/GGxJdW ▓████▀▀ ▀█
▌ ▓██▌▄ ▀▀ AUTHOR.............: Paula Guilfoyle ▀▀ ▄▐██▓ ▐
▌▐███░▒███▌ LEVEL..............: all level ▐███▒░███▌▐
▌ ████▓████ RUNTIME............: 3 hours ████▓████ ▐
█ ▐▓█▀█████░ LANGUAGE...........: ENGLISH ░█████▀█▓▌ █
█▀ ▀▄█▄▄▀▀█▓ RELEASE TYPE.......: RETAIL ▓█▀▀▄▄█▄▀ ▀█
█▀▄ ▄▀███▓▄ RELEASE FORMAT.....: ISO ▄▓███▀▄ ▄▀█
█▀█ ▐▓▄▀████ STORE DATE:........: 2013.05.23 ████▀▄▓▌ █▀█
█▀█ ▐█▌▓██▓ RELEASE DATE.......: 2015.07.07 ▓██▓▐█▌ █▀█
▓▀█ ▓▌░██▓ ISO SIZE...........: 319,498,240 ▓██░▐▓ █▀▓
▒▀█ █ ▓█▓ ISO CHECKSUM.......: 9CB7BBAF ▓█▓ █ █▀▒
░ █ ▌░██ DISKCOUNT..........: 7 * 50MB ██░▐ █ ░
▓█▌▓█▌ SAVED MONEY........: YOU DID! ▐█▓▐█▓
░ ▒█▐██ DISKNAME...........: keiso_uebilppdaxf ██▌█▒ ░
░▀ ▀ ▀ ▀░
░ ░
░▄░ ░ ██ ▄▄▄▄▄▓█▀█▀ ▀ ░ ▀ ▀█▀█▓▄▄▄▄▄ ██ ░ ░▄░
▒▄▒ ▓░ ████████ ▄▄▓█▌▀▀█▄▄▀▀ ▀▀▄▄█▀▀▐█▓▄▄ ████████ ░▓ ▒▄▒
▌▓▄▓▀ ▀▀▄ ██ ▄▄▐██▀ ▄██▀ ▀██▄ ▀██▌▄▄ ██ ▄▀▀ ▀▓▄▓▐
█▀ ▓░ ▄ █▄▌██ ▄ ▀ ▀█▌▐▓▀ TUTORIAL ▀▓▌▐█▀ ▀ ▄ ██▐▄█ ▄ ░▓ ▀█
▄▀ ▄ ▀▄ ▀▌▓█ ▀▄▄ ▀ ▀▄ ▄▀ ▀ ▄▄▀ █▓▐▀ ▄▀ ▄ ▀▄
▐▌ ■░■ ▐▌ ▄▌░▓ ▄██ ▀ ▓ ▓ ▀ ██▄ ▓░▐▄ ▐▌ ■░■ ▐▌
▀▄ ■ ▄▀ ▀▀▀▀ ▄▄█▀▀▀ ▀ ▀ ▀ ▀ ▀▀▀█▄▄ ▀▀▀▀ ▀▄ ■ ▄▀
█▀█ ▄▓ ▄ █▀▀ ▀▀█ ▄ ▓▄ █▀█
█▀█ ▄▓ ▄ ▐▌ ▐▌ ▄ ▓▄ █▀█
█▀█ █▓ ▄▓▄▀ Power Pivot is an Excel add-in, available in Excel ▀▄▓▄ ▓█ █▀█
█▀█ ▓▒ ▒ 2010 and certain versions of Excel 2013. You can ▒ ▒▓ █▀█
█▀█ ▒░ ░ use Power Pivot, with its own DAX functions to ░ ░▒ █▀█
▓▀█ ▒░ perform powerful data analysis and create ░▒ █▀▓
▒▀█ ░▓ sophisticated data models. With Power Pivot, you can ▓░ █▀▒
░ █ ▒ mash up large volumes of data from various ▒ █ ░
▓ ░ sources, perform information analysis rapidly, and ░ ▓
░ ▒ ░ share insights easily. ░ ▒ ░
░ ░
░ LEARN HOW SET UP POWERPIVOT REPORTS AND CHARTS AND MASTER DAX ░
░ FUNCTIONS USED TO PERFORM POWERFUL CALCULATIONS AND ANSLYSIS. ░
░ ░
░ MICROSOFT'S EXCEL, WHICH INCLUDES POWER PIVOT, IS NOW PART OF A BI ░
░ SYSTEM. IF YOU WANT TO IMPROVE YOUR EXCEL SKILLS FAR BEYOND ░
░ THE BASIC LEVEL THEN THIS COURSE IS FOR YOU ░
░ ░
░ CONTENTS AND OVERVIEW ░
░ ░
░ In section one of this course we will start at the ░
░ very basics and learn how to set up and import ░
░ data to Power Pivot. In this section you will find ░
░ sample data to download, so you can practice ░
░ along. ░
░ ░
░ Section two and three will cover the basic elements of Power Pivot ░
░ such as tables, table relationships, calculated columns ░
░ slicers and measures. ░
░ ░
░ Once we are working well with these basic's we are going to power ░
░ things up using DAX functions. DAX functions such as the ░
░ Calculate function and filter and distinct will give you greater ░
░ debt to your analysis. ░
░ ░
░ Finally we will look in detail at the Time ░
░ intelligence functions Power Pivot has to offer. ░
░ ░
░ Who Should Attend? ░
░ ░
░ This course is suited to those with an interest in ░
░ Excel, Data Analyst's, Data Mining, BI, Reporting and Pivot ░
░ tables and is well suited for Accountants, Auditors, Internal ░
░ Auditors, Business Analysts, Finance staff, Banking staff, ░
░ Management and those involved with Compliance and Risk assessment ░
░ and BI. ░
░ ░
░ ò This course is meant for those involved in the Analysis of ░
░ Data, Finance & Accounting and Reporting roles. ░
░ ░
░ ò This course is not a traditional functions and ░
░ formulas based course but instead this course ░
░ covers Excels Add in Power Pivot and is own function ░
░ language DAX ░
░ ░
░ ò This course is suited to those with an interest ░
░ in Excel, Fraud and Audit and is well suited for ░
░ Accountants, Auditors, Internal Auditors, Business Analysts, ░
░ Finance staff, Banking staff, Management and those involved with ░
░ Compliance and Risk assessment and BI. ░
░ ░
░ ò This course is for you if you are looking to learn advanced ░
░ Excels functions. ░
░ ░
░ ò This course is not for you if you are new to Excel. ░
░ ░
░ ░
░▄░ ░ ██ ▄▄▄▄▄▓█▀█▀ ▀ ░ ▀ ▀█▀█▓▄▄▄▄▄ ██ ░ ░▄░
▒▄▒ ▓░ ████████ ▄▄▓█▌▀▀█▄▄▀▀ ▀▀▄▄█▀▀▐█▓▄▄ ████████ ░▓ ▒▄▒
▌▓▄▓▀ ▀▀▄ ██ ▄▄▐██▀ ▄██▀ ▀██▄ ▀██▌▄▄ ██ ▄▀▀ ▀▓▄▓▐
█▀ ▓░ ▄ █▄▌██ ▄ ▀ ▀█▌▐▓▀ NOTES / NEWS ▀▓▌▐█▀ ▀ ▄ ██▐▄█ ▄ ░▓ ▀█
▄▀ ▄ ▀▄ ▀▌▓█ ▀▄▄ ▀ ▀▄ ▄▀ ▀ ▄▄▀ █▓▐▀ ▄▀ ▄ ▀▄
▐▌ ■░■ ▐▌ ▄▌░▓ ▄██ ▀ ▓ ▓ ▀ ██▄ ▓░▐▄ ▐▌ ■░■ ▐▌
▀▄ ■ ▄▀ ▀▀▀▀ ▄▄█▀▀▀ ▀ ▀ ▀ ▀ ▀▀▀█▄▄ ▀▀▀▀ ▀▄ ■ ▄▀
█▀█ ▄▓ ▄ █▀▀ ▀▀█ ▄ ▓▄ █▀█
█▀█ ▄▓ ▄ ▐▌ ▐▌ ▄ ▓▄ █▀█
█▀█ █▓ ▄▓▄▀ ▀▄▓▄ ▓█ █▀█
█▀█ ▓▒ ▒ Huh? No news are good news! ▒ ▒▓ █▀█
█▀█ ▒░ ░ ░ ░▒ █▀█
▓▀█ ▒░ ░▒ █▀▓
▒▀█ ░▓ ▓░ █▀▒
░ █ ▒ ▒ █ ░
▓ ░ ░ ▓
░ ▒ ░ ░ ▒ ░
░ ░
░ ░
░▄░ ░ ██ ▄▄▄▄▄▓█▀█▀ ▀ ░ ▀ ▀█▀█▓▄▄▄▄▄ ██ ░ ░▄░
▒▄▒ ▓░ ████████ ▄▄▓█▌▀▀█▄▄▀▀ ▀▀▄▄█▀▀▐█▓▄▄ ████████ ░▓ ▒▄▒
▌▓▄▓▀ ▀▀▄ ██ ▐██▀ ▄██▀ ▀██▄ ▀██▌▄▄ ██ ▄▀▀ ▀▓▄▓▐
█▀ ▓░ ▄ █▄▌██ ▄░ ▀█▌▐▓▀ RESPECTS ▀▓▌▐█▀ ▀ ▄ ██▐▄█ ▄ ░▓ ▀█
▄▀ ▄ ▀▄ ▀▌▓█ ▀▄▄ ▀ ▀▄ ▄▀ ▀ ▄▄▀ █▓▐▀ ▄▀ ▄ ▀▄
▐▌ ■░■ ▐▌ ▄▌░▓ ▄██ ▀ ▓ ▓ ▀ ██▄ ▓░▐▄ ▐▌ ■░■ ▐▌
▀▄ ■ ▄▀ ▀▀▀▀ ▄▄▓▀▀▀ ▀ ▀ ▀ ▀ ▀▀▀█▄▄ ▀▀▀▀ ▀▄ ■ ▄▀
█▀█ ▄▓▄ ▄▄█▀▀▀ ▀▀█ ▄ ▄▓▄ █▀█
▌ ▐▄▄▓ ▄ ▐▌ ▐▌ ▄ ▓▄▄▌ ▐
▌ ▀█▓ ▄▓▄▀ BBL - DDU - EEn - iNTENSiTY - JGT - RBS ▀▄▓▄ ▓█▀ ▐
▌░ ▓ █ █ ▓ ░▐
▌▒ ▒▄█▀ ▀█▄▒ ▒▐
▌▓▌ ░ ░ ▐▓▐
▌██ ░ SHOUTOUTS ░ ██▐
▌▐▓█ █▓▌▐
▌ ░▓█ █▓░ ▐
█ ░██ ██░ █
█▀▄ ▓██▄ DVT - FONT - iRONiSO - LAXiTY - PARADOX - SO ▄██▓ ▄▀█
█▀ ▄ ▓███▄ ▄███▓ ▄ ▀█
█▀ █▄▀▓█▀██▄ ▓ ▄██▀█▓▀▄█ ▀█
█▀ ▀ ▀█▄▀▓█▄▀▀▓▄▄ ▄▀ ▄ ▀▄ ▄▄▓▀▀▄█▓▀▄█▀ ▀ ▀█
█▀▄ ▀▄▀██▄▀▀█▄ ▀▀▓▄▄ ░ ▄▌▐▌ ■░■ ▐▌▐▄ ░ ▄▄▓▀▀ ▄█▀▀▄██▀▄▀ ▄▀█
█▀█ ▄ ▀▄▀███▄▀▀█▄▄ ▀▀▓▄ ▄▄▄▓▓█▀ ▀▄ ■ ▄▀ ▀█▓▓▄▄▄ ▄▓▀▀ ▄▄█▀▀▄███▀▄▀ ▄ █▀█
█▀█ █ ▀█▄▀█▄▀█▄▀▀█▄ █▓ ▀█ ▄ ▄ ▀ ▐ ▓ ▌ ▀ ▄ ▄ █▀ ▓█ ▄█▀▀▄█▀▄█▀▄█▀ █ █▀█
█▀█ █ █ ▀█▄▀█ ▀██▄▀█▄ ▐█▓░ ▀ ■ ▐ ▒ ▌ ■ ▀ ░▓█▌ ▄█▀▄██▀ █▀▄█▀ █ █ █▀█
█▀█ █ █ ▐▌▐██▐█▄ ▓██▐█▌██░ ░▌ ▄▀▐ ░ ▌▀▄ ▐░ ░██▐█▌██▓ ▄█▌██▌▐▌ █ █ █▀█
▀█ ▀████ ██▀████▐████▓▀ ▄▀▀▀▄ ▄▄▓▐ ░ ▌▓▄▄ ▄▀▀▀▄ ▀▓████▌████▀██ ████▀ █▀
▀█▄ ▀▀▀████▓▀▄█▓▀▀ ▐▌ ▀▓ ▌▀▀▀▀▄▀▄▀▀▀▀▐ ▓▀ ▐▌ ▀▀▓█▄▀▓████▀▀▀ ▄█▀
▀ ▄▄ ▀▀▀▀▀▀▀ ▄▌ ▀▄▄▄▀ ▀▀▀▄ ▀ ▄▀▀▀ ▀▄▄▄▀ ▐▄ ▀████▀▀ ▄▄ ▄▄ ▀
▀▀█▄▄▄▄▄▄▄▄▄████▄ ▄ ██▌▐ █ ▌▐██ ▄ ▄████▄▀ ▀▄▄
▀▀▀▀▀▀▀▀██▓▓░░ ▄ ▀ ▐ ▓ ▌ ▀ ▄ ░░▓▓██▀▀▄ H7/BREAK ▄▀
▄▀ ▄ ▀▄ ▓ ▄▐ ▒ ▌▄ ▓ ▄▀ ▄ ▀▄ ▀▐▄ ▄▌▀
▐▌ ▌ ▐ ▐▌ ░ ▐ ░ ▌ ░ ▐▌ ▌ ▐ ▐▌
▀▄ ▀ ▄▀▄▄ █ ░ █ ▄▄▀▄ ▀ ▄▀
▀▀▀ █ █ █ ░ █ █ █ ▀▀▀
▀▀ ▐▐ ░ ▌▌ ▀▀
█▐ ░ ▌█
▀▄▐ ░ ▌▄▀
▐ ▒ ▌
▐ ▓ ▌
▄▀ ■ ▀▄
▐▌ ■░■ ▐▌
▀▄ ▀ ▄▀
▀░▀
Files
| Path | Size |
| keiso_uebilppdaxf.nfo | 15,38 KB |
| keiso_uebilppdaxf.r00 | 47,68 MB |
| keiso_uebilppdaxf.r01 | 47,68 MB |
| keiso_uebilppdaxf.r02 | 47,68 MB |
| keiso_uebilppdaxf.r03 | 47,68 MB |
| keiso_uebilppdaxf.r04 | 47,68 MB |
| keiso_uebilppdaxf.r05 | 18,60 MB |
| keiso_uebilppdaxf.rar | 47,68 MB |
| keiso_uebilppdaxf.sfv | 224 B |