Power BI
Description
The Power BI course is comprehensive and teaches how to build spectacular interactive reports that will help decision makers in organizations see the full picture and take steps that will improve the company's situation. Students who complete the course will be able to build dynamic reports themselves in an advanced graphic configuration that allows for unique statistical analysis capabilities.
The course was built based on best practice in the implementation of the system based on the lecturer's many years of experience while emphasizing familiarity with the important components for successful assimilation.
Intended audience
people who wish to learn how to build interactive reports and improve the process of decision making
Topics
Connect & Transform the Raw Data
Intro to the Power BI Query Editor
Types of Power BI Data Connectors
Basic Table Transformations
Text, Number & Date Tools
Index & Conditional Columns
Grouping & Aggregating Data
Pivoting & Unpivoting
Modifying, Merging & Appending Queries
Connecting to Folders
Defining Hierarchies & Categories
Query Editing & Power BI Best Practices
Add Calculated Fields with DAX
Intro to Data Analysis Expressions (DAX)
Calculated Columns vs. Measures
Row Context vs. Filter Context in Power BI
DAX Syntax & Operators
Common Power BI Functions
Basic Date & Time Formulas
Logical & Conditional Statements
Text, Math & Stats Functions
Joining Data with RELATED
CALCULATE, ALL & FILTER Functions
DAX Iterators (SUMX, AVERAGEX)
Time Intelligence Formulas
DAX & Power BI Best Practices
האם אתה בטוח שאתה רוצה לסגור את הטופס ולאבד את כל השינויים?
