Power BI DAX

Name: Power BI DAX | A Guide to Using Basic Functions in Data Analysis
Brand: Kiet Huynh
Price: 4.49 EUR
Availability: OnlineOnly

A Guide to Using Basic Functions in Data Analysis

Kiet Huynh(Autor*in)

Kiet Huynh (Verlag)

1. Auflage

Erschienen am 23. August 2023

153 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-1-0882-6798-1 (ISBN)

4,49 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Inhalt

Intro
CHAPTER I Introduction to Power BI and DAX
1.1 Power BI - A Comprehensive Data Analysis and Visualization Tool
1.2 DAX (Data Analysis Expressions) - Concepts and Role in Power BI
1.3 Objectives and Scope of the Book
CHAPTER II Basics of DAX Language
2.1 Syntax and Basic Characteristics of DAX
2.2 Data Types in DAX and Data Conversion Rules
2.3. Using DAX formulas in Power BI
CHAPTER III Basic DAX Functions
3.1 SUM, AVERAGE, MIN, and MAX Functions - Calculating Total, Average, Minimum, and Maximum Values
3.2 COUNT and COUNTA Functions - Counting Rows and Non-Empty Values
3.3 IF and SWITCH Functions - Handling Conditions and Replacing Values
CHAPTER IV Calculating Strings and Text with DAX
4.1 CONCATENATE Function - Combining Text Strings
4.2 LEFT, RIGHT, and MID Functions - Extracting Parts of a String
4.3 LEN function - Counting characters in a string
CHAPTER V Calculating Time and Dates with DAX
5.1. DATE and TIME functions - Creating date and time values
5.2 DATEDIFF and DATEADD Functions - Calculating Time Spans and Adding/Subtracting Time Intervals
5.3. NOW and TODAY functions - Retrieving current time and date
CHAPTER VI Calculating Financial Data with DAX
6.1. NPV and IRR functions - Calculating Net Present Value and Internal Rate of Return
6.2. PV and FV functions - Calculating Present Value and Future Value of cash flows
6.3. RATE and NPER functions - Calculating interest rates and number of periods
CHAPTER VII Logic and Relationship Functions in DAX
7.1 AND, OR, and NOT Functions - Handling Logical Expressions
7.2 RELATED Function - Linking Data Tables
7.3 CALCULATE and FILTER Functions - Customizing Calculations and Data Filtering
CHAPTER VIII Handling Errors and Blank Values in DAX
8.1 IFERROR and ISBLANK Functions - Dealing with Errors and Blank Values
8.2 COALESCE Function - Selecting the First Non-Empty Value
CHAPTER IX Combining DAX with Power Query and Power Pivot
9.1 Power Query - Extracting and Transforming Data
9.2 Power Pivot - Building Data Models and Table Relationships
9.3 Combining DAX, Power Query, and Power Pivot in Power BI
CHAPTER X Optimizing Performance with DAX
10.3 Tips and Tricks for Handling Large Data Volumes
CHAPTER XI Real-World Applications and Practical Exercises
11.2 Creating Smart Reports and Charts with DAX
11.3 Step-by-Step Guidance for Practicing DAX Usage

Systemvoraussetzungen

Als PDF speichern Als Link merken