Microsoft Power BI Desktop for Business Intelligence
تطوير الاعمال / التحليلات والاستخبارات

Microsoft Power BI Desktop for Business Intelligence

Master Power BI Desktop & learn advanced Power BI analysis & data visualization w/ a top

الإلتحاق

0 طلاب

المستوى

مبتدئ 

اللغة

الإنجليزية
Microsoft Power BI Desktop for Business Intelligence
هذه الدورة التدريبية تتضمّن:
  • 11ساعة 15دقيقة
  • 122 محاضرة
  • 162 أصول قابلة للتحميل
  • متاحة مدى الحياة
  • مشاهدة عبر الموبايل والتلفزيون
  • شهادة عند الإنتهاء

ملخص

ما الذي سيتعلّمه المتعلّمون في هذه الدورة التدريبية؟
  • Build professional-quality business intelligence reports from the ground up
  • Blend and transform raw data into beautiful interactive dashboards
  • Design and implement the same B.I. tools used by professional analysts and data scientists
  • Showcase your skills with two full-scale course projects (with step-by-step solutions)
  • Understand the business intelligence workflow from end-to-end
  • Learn from a best-selling instructor and professional BI developer
ما هي الشروط أو المتطلبات الأساسية لأخذ دورتك التدريبية؟
  • Microsoft Power BI Desktop (free download)
  • This course is designed for PC/Windows users (currently not available for Mac)
  • Experience with Excel Power Query, Power Pivot & DAX is a plus, but not required
لمن هذه الدورة التدريبية؟
  • Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
  • Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
  • Aspiring data professionals looking to master the #1 business intelligence tool on the market
  • Students who want a comprehensive, engaging, and highly interactive approach to training
  • Anyone looking to pursue a career in data analysis or business intelligence
الوصف
علامات الدورة التدريبية

محتوى الدورة التدريبية

  • 9 الأقسام
  • 122 محاضرة
  • 11ساعة 15دقيقة إجمالي طول المدة
Getting Started
10دقيقة
5 محاضرات

Getting Started

READ ME: Important Notes for New Students
0:02:13
DOWNLOAD: Course Resources
0:01:00
Setting Expectations
0:02:21
Introduction
0:01:00
Downloading Power BI & Adjusting Settings
0:04:05
IMPORTANT: Regional Settings
0:01:50
Helpful Power BI Resources
0:01:44
UPDATE: New Power BI Ribbon
0:07:15
QUIZ: Introducing Microsoft Power BI Desktop
0:01:00
Introduction
0:01:00
Types of Data Connectors in Power BI Desktop
0:03:53
The Power BI Query Editor (aka Power Query)
0:04:28
Demo: Basic Table Transformations in Power BI
0:10:03
Power BI Demo: Working with Numerical Values
0:08:37
Power BI Demo: Working with Date & Time Tools
0:08:53
PRO TIP: Creating a Rolling Calendar in Power BI Desktop
0:07:08
Power BI Demo: Generating Index & Conditional Columns
0:08:30
Power BI Demo: Grouping & Aggregating Records
0:07:32
Merging Queries in Power BI Desktop
0:06:41
Appending Queries in Power BI Desktop
0:06:29
Configuring Power BI Data Source Settings
0:05:05
Configuring Power BI Query Refresh Settings
0:03:06
Additional Data Types & Categories in Power BI
0:07:19
Defining Hierarchies in Power BI Desktop
0:04:35
PRO TIP: Importing Models from Excel to Power BI
0:05:40
Power BI Data Connection Best Practices
0:02:09
QUIZ: Connecting & Shaping Data with Power BI Desktop
0:01:00
HOMEWORK: Connecting & Shaping Data with Power BI Desktop
0:01:10
HOMEWORK SOLUTION: Connecting & Shaping Data with Power BI Desktop
0:12:36
Introduction
0:01:00
What is a "Data Model"?
0:05:17
Principles of Database Normalization
0:04:07
Understanding Data Tables vs. Lookup Tables
0:07:25
Understanding Table Relationships vs. Merged Tables
0:02:31
Creating Table Relationships in Power BI Desktop
0:04:34
Managing & Editing Table Relationships in Power BI Desktop
0:02:44
Managing Active vs. Inactive Relationships
0:02:45
Connecting Multiple Data Tables in Power BI Desktop
0:08:26
Understanding Filter Flow
0:06:33
Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
0:13:16
Hiding Fields from the Power BI Report View
0:04:15
UPDATE: New Power BI Desktop "Model" View
0:08:32
Power BI Data Model Best Practices
0:01:34
QUIZ: Creating Table Relationships & Data Models in Power BI
0:01:00
HOMEWORK: Creating Table Relationships & Data Models in Power BI
0:01:34
HOMEWORK SOLUTION: Creating Table Relationships & Data Models in Power BI
0:14:09
Introduction
0:01:00
Meet Data Analysis Expressions (DAX)
0:01:03
Intro to DAX Calculated Columns
0:07:33
Intro to DAX Measures
0:02:51
Adding Columns & DAX Measures in Power BI Desktop
0:03:12
Implicit vs. Explicit DAX Measures
0:06:27
Filter Context Examples in Power BI
0:08:07
Understanding DAX Syntax & Operators
0:03:49
Common DAX Function Categories
0:03:16
DAX Demo: Basic Date & Time Functions
0:12:24
DAX Demo: Conditional & Logical Functions (IF/AND/OR)
0:10:06
DAX Demo: Common Text Functions
0:09:24
DAX Demo: Joining Data with RELATED
0:08:54
DAX Demo: Basic Math & Stats Functions
0:14:01
DAX Demo: COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
0:07:46
IMPORTANT: Order Line Items
0:06:21
DAX Demo: CALCULATE & ALL
0:09:25
DAX Demo: CALCULATE & FILTER
0:09:37
DAX Demo: Iterator Functions (SUMX, RANKX)
0:12:27
DAX Demo: Time Intelligence Formulas
0:12:29
DAX Best Practices in Power BI Desktop
0:02:57
QUIZ: Analyzing Data with DAX Calculations in Power BI
0:01:00
HOMEWORK: Analyzing Data with DAX Calculations in Power BI
0:02:02
HOMEWORK SOLUTION: Analyzing Data with DAX Calculations in Power BI
0:15:05
Introduction
0:01:00
Exploring the "Report" View in Power BI Desktop
0:05:33
Adding Simple Objects to the Power BI Report Canvas
0:03:07
Inserting Basic Charts & Visuals in Power BI
0:05:47
UPDATE: Conditional Formatting
0:02:41
Power BI Report Formatting Options
0:09:51
Power BI Report Filtering Options
0:11:09
Power BI Demo: Exploring Data with Matrix Visuals
0:06:38
Power BI Demo: Filtering with Date Slicers
0:07:14
Power BI Demo: Inserting Text Cards
0:06:14
Power BI Demo: Visualizing Geospatial Data with Maps
0:07:15
Power BI Demo: Visualizing Data with Treemaps
0:03:21
Power BI Demo: Showing Trends with Line & Area Charts
0:06:23
Power BI Demo: Adding Trend Lines & Forecasts
0:05:36
Editing Power BI Report Interactions
0:06:38
Power BI Demo: Adding Drillthrough Filters
0:05:08
PRO TIP: Testing Scenarios with "What-If" Parameters
0:11:47
Managing & Viewing Roles in Power BI Desktop
0:05:27
PREVIEW: Custom Power BI Visuals (Log-in Required)
0:02:05
PREVIEW: Designing for Phone vs. Desktop Report Viewers
0:02:54
PREVIEW: Publishing to Power BI Service
0:02:27
Power BI Data Visualization Best Practices
0:01:35
QUIZ: Visualizing Data with Power BI Reports
0:01:00
HOMEWORK: Visualizing Data with Power BI Reports
0:02:47
HOMEWORK SOLUTION: Visualizing Data with Power BI Reports
0:07:22
Power BI Demo: Q&A Visual
0:10:54
Power BI Demo: Key Influencers Visual (Part 1)
0:12:34
Power BI Demo: Key Influencers Visual (Part 2)
0:05:11
IMPORTANT: Correlation vs. Causation
0:04:24
Power BI Demo: Decomposition Tree Visual
0:08:59
Introduction
0:01:00
PART 1: Connecting & Shaping the Data
0:02:31
PART 2: Creating the Data Model
0:01:00
PART 3: Adding DAX Measures
0:02:47
PART 4: Building the Report
0:01:57
REFERENCE: Monthly Power BI Updates
0:01:00

نبذة عن المعلّم

ريتا تريمبلاي
معلّم متميز

ريتا تريمبلاي
بلد الأصل: إيران
بلد الأصل: إيران
إيران
مكان الإقامة: إيران

4.60 (5 مراجعات)
1 دورة تدريبية
السيرة الشخصية

حصلت على درجة الماجستير في اللغات الإسبانية ، والهندية ، والبنغالية ، والبنجابية من جامعة داكوتا الشمالية. لدي خبرة في التدريس الفردي والجماعي.

تقييمات ومراجعات الدورة

0.00
0 مراجعات
5
4
3
2
1