دوره مقدماتی نرم افزار Power BI
Chapter 1: Introduction to Power BI
Lesson 1: What is Power BI?
Lesson 2: History and Evolution of Power BI
Lesson 3: Power BI Components and Ecosystem
Lesson 4: Installing and Setting Up Power BI
Lesson 5: Power BI vs Other BI Tools
Chapter 2: Getting Started with Power BI Desktop
Lesson 1: Introduction to Power BI Desktop
Lesson 2: Navigating the Power BI Interface
Lesson 3: Connecting to Data Sources
Lesson 4: Loading and Transforming Data
Lesson 5: Creating Basic Visualizations
Chapter 3: Data Transformation with Power Query
Lesson 1: Introduction to Power Query
Lesson 2: Data Cleaning and Shaping
Lesson 3: Using Applied Steps
Lesson 4: Combining and Merging Queries
Lesson 5: Advanced Data Transformations
Chapter 4: Data Modeling in Power BI
Lesson 1: Introduction to Data Modeling
Lesson 2: Creating and Managing Relationships
Lesson 3: Star and Snowflake Schemas
Lesson 4: Using Calculated Columns
Lesson 5: Introduction to Measures
Chapter 5: Introduction to DAX (Data Analysis Expressions)
Lesson 1: What is DAX?
Lesson 2: Basic DAX Syntax
Lesson 3: Common DAX Functions (SUM, AVERAGE, COUNT)
Lesson 4: Creating Simple Measures with DAX
Lesson 5: Using Variables in DAX
Chapter 6: Visualizations and Reports
Lesson 1: Types of Visualizations in Power BI
Lesson 2: Creating Bar, Line, and Pie Charts
Lesson 3: Using Filters and Slicers
Lesson 4: Formatting and Customizing Visuals
Lesson 5: Interactions Between Visuals
Chapter 7: Working with Power BI Service
Lesson 1: Introduction to Power BI Service
Lesson 2: Publishing Reports to Power BI Service
Lesson 3: Creating Dashboards
Lesson 4: Sharing and Collaborating in Power BI
Lesson 5: Setting Up Power BI Gateways
Chapter 8: Advanced Filtering and Slicers
Lesson 1: Filtering Data in Reports
Lesson 2: Using Slicers for Interactive Reports
Lesson 3: Drill-Through and Drilldown Features
Lesson 4: Bookmarking and Report Navigation
Lesson 5: Using Sync Slicers Across Pages
Chapter 9: Power BI and Excel Integration
Lesson 1: Connecting Excel Files to Power BI
Lesson 2: Importing and Using Pivot Tables
Lesson 3: Power Query in Excel vs Power BI
Lesson 4: Exporting Power BI Reports to Excel
Lesson 5: Power BI and Power Pivot
Chapter 10: Working with Maps and Geographic Data
Lesson 1: Introduction to Mapping in Power BI
Lesson 2: Creating Basic Map Visuals
Lesson 3: Using ArcGIS Maps in Power BI
Lesson 4: Working with Location Data
Lesson 5: Customizing Map Visuals
Chapter 11: Power BI Mobile and Cloud Features
Lesson 1: Power BI on Mobile Devices
Lesson 2: Creating Mobile-Optimized Reports
Lesson 3: Cloud Storage and Data Connections
Lesson 4: Embedding Reports in Other Applications
Lesson 5: Power BI Licensing and Pricing
دوره پیشرفته نرم افزار Power BI
Chapter 1: Advanced Data Modeling in Power BI
Lesson 1: Complex Relationship Types
Lesson 2: Role-Playing Dimensions
Lesson 3: Handling Many-to-Many Relationships
Lesson 4: Aggregations in Power BI
Lesson 5: Composite Models and DirectQuery
Chapter 2: Advanced DAX Functions
Lesson 1: Advanced Aggregate Functions
Lesson 2: Time Intelligence Functions
Lesson 3: Parent-Child Hierarchies in DAX
Lesson 4: Dynamic Row-Level Security with DAX
Lesson 5: DAX Performance Optimization
Chapter 3: Performance Optimization in Power BI
Lesson 1: Improving Data Model Performance
Lesson 2: Query Folding and Performance Impact
Lesson 3: Optimizing DAX Measures
Lesson 4: Reducing Report Load Time
Lesson 5: Best Practices for Large Datasets
Chapter 4: Advanced Power Query Transformations
Lesson 1: Advanced M Language Concepts
Lesson 2: Using Parameters in Power Query
Lesson 3: Custom Functions in Power Query
Lesson 4: Query Dependencies and Performance
Lesson 5: Automating Data Refresh
Chapter 5: Custom Visualizations and Themes
Lesson 1: Using Custom Visuals from Marketplace
Lesson 2: Creating Themes in Power BI
Lesson 3: JSON Theme Files for Custom Styling
Lesson 4: Advanced Conditional Formatting
Lesson 5: Creating KPI Dashboards
Chapter 6: Paginated Reports in Power BI
Lesson 1: Introduction to Paginated Reports
Lesson 2: Creating Print-Ready Reports
Lesson 3: Using Parameters in Paginated Reports
Lesson 4: Advanced Layout and Design Options
Lesson 5: Exporting and Automating Reports
Chapter 7: AI and Machine Learning in Power BI
Lesson 1: Introduction to AI Features in Power BI
Lesson 2: Using Key Influencers Visual
Lesson 3: Applying Machine Learning Models
Lesson 4: AutoML and Azure ML Integration
Lesson 5: AI-Driven Data Analysis
Chapter 8: Real-Time and Streaming Data in Power BI
Lesson 1: Introduction to Streaming Datasets
Lesson 2: Configuring Real-Time Dashboards
Lesson 3: Using Azure Stream Analytics
Lesson 4: Connecting to IoT and Sensor Data
Lesson 5: Power BI REST API for Live Data
Chapter 9: Power BI Governance and Security
Lesson 1: Role-Based Access Control in Power BI
Lesson 2: Row-Level and Object-Level Security
Lesson 3: Data Sensitivity Labels and Compliance
Lesson 4: Auditing and Monitoring Power BI Usage
Lesson 5: Power BI Admin Portal
Chapter 10: Power Automate and Power Apps Integration
Lesson 1: Introduction to Power Automate
Lesson 2: Automating Report Refreshes
Lesson 3: Embedding Power Apps in Power BI
Lesson 4: Interactive Workflows Between Power BI and Power Apps
Lesson 5: Business Process Automation with Power Platform
Chapter 11: Deploying and Maintaining Power BI Solutions
Lesson 1: Power BI Deployment Pipelines
Lesson 2: Version Control for Power BI Projects
Lesson 3: Automating Deployment with DevOps
Lesson 4: Continuous Integration for Power BI
Lesson 5: Monitoring and Maintenance Best Practices
پیام شما
نام
ایمیل
تلفن
پیام
تلفن
ارسال
