- Big Data Analytics (Bank of Sulselbar)
- Ruhimat Game of Trust
- Data-Driven-Banking (Bank of DKI)
- IT Risk Management
- System Analyst
- Data-Driven-Banking
- Data Driven Decision
- Data Visualization
- Data Storytelling
- Knime Academy Data Science
- Gertaone Trading School-Preschool
- Pinbar Trading Strategy
- Price Action Trading Strategy
- Price Action Trading Intro
- Dow Theory Trading
- Knime Academy 101
- Data-Driven Impact
- Elliot Wave Trading
- Chart Pattern Trading
- Candlestick Price Action Trading
- Support & Resistance Trading
- Fundamental-News Trading
- Fundamental Analysis of Trading
- BI & Visual Analytics-Tableau Overview
- Use Case Business Intelligence
- Knime Data Science & ML
- Knime Text Mining
- Knime Advanced Training
- Knime Beginner Training
- BI & Visual Analytics-Tableau
- Intro to Web Development
- Applied Statistics
- Tableau Desktop Specialist
- Hands-On Tableau Workshop
- Tableau Public
- DWBI
- Operations Research 101
- Machine learning 101
- DataViz in R
- Regression 101 in R
- HOPR
- Data cleaning 101 in R
- Zeitreihenanalyse-DE
- Open Refine 101
- Colorology in R
- Default R Graphs
- Python for Data Science
- Data Science-HR
- EDA with R
- People Analytics
- Cevipedia
- R-Shiny
- Github
- BI-Tableau
- BI-Power BI
- Codepedia
- Power Pivot-DAX
- Power Query
- Certification Wiki
- KPI-Dashboard
- Insta-DE
- WKR-DE
- Desta-DE
- R Programming
Power Pivot-DAX
Powerful data analysis and data modeling in Excel
What is Power Pivot and DAX?
Power Pivot is an Excel add-in you can use 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. More about Power Pivot: Power Pivot
Power Pivot has DAX (Data Analysis Expressions) as data modelling tools (Functional Programming).
We can use DAX to define custom calculations for Calculated Columns and for Measures (also known as calculated fields). DAX includes some of the functions used in Excel formulas, and additional functions designed to work with relational data and perform dynamic aggregation. More about DAX: DAX
I learn Power Pivot and DAX formula during my work as working student at my university (HTW Berlin-University of Applied Sciences), from start: September 2016.
The Power Pivot and DAX supported my project to automating reporting for Federal Statistical Office of Germany (destatis) .
