Book your free 60-minute call with our software expert.
Launch your online tutoring platform with Yo!Coach
بيت
AR - INR
لغة الموقع
عملة الموقع
Microsoft Power BI Desktop for Business Intelligence
Microsoft Power BI Desktop for Business Intelligence
0.00 (0)
تطوير الأعمال / التحليلات والاستخبارات

Microsoft Power BI Desktop for Business Intelligence

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

Rita Tremblay
Rita Tremblay
7 الطلاب المسجلين
متوسط
الإنكليزية
تتضمن هذه الدورة:
  • 13ح 45م
  • 122 محاضرات
  • 162 الأصول القابلة للتحميل
  • الوصول الكامل مدى الحياة
  • الوصول على الهاتف المحمول والتلفزيون
  • شهادة عند الانتهاء
Rs.990.00

ملخص

ماذا سيتعلم الطلاب في الدورة الخاصة بك؟
  • 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 محاضرات
  • 13ح 45م الطول الاجمالي
Getting Started
35م
5 محاضرات

Getting Started

Course Structure & Outline
معاينة 0:06:12
READ ME: Important Notes for New Students
0:06:12
DOWNLOAD: Course Resources
0:09:13
Introducing the Course Project
معاينة 0:06:54
Setting Expectations
0:06:54
Introduction
0:09:13
Meet Microsoft Power BI Desktop
معاينة 0:03:41
Downloading Power BI & Adjusting Settings
0:07:30
IMPORTANT: Regional Settings
0:09:13
Exploring the Power BI Desktop Interface & Workflow
معاينة 0:06:54
Helpful Power BI Resources
0:09:13
UPDATE: New Power BI Ribbon
0:07:30
QUIZ: Introducing Microsoft Power BI Desktop
0:06:12
Introduction
0:09:13
Types of Data Connectors in Power BI Desktop
0:09:13
The Power BI Query Editor (aka Power Query)
0:06:12
Demo: Basic Table Transformations in Power BI
0:06:12
Power BI Demo: Working with Text Tools
معاينة 0:06:12
Power BI Demo: Working with Numerical Values
0:06:54
Power BI Demo: Working with Date & Time Tools
0:06:12
PRO TIP: Creating a Rolling Calendar in Power BI Desktop
0:07:30
Power BI Demo: Generating Index & Conditional Columns
0:06:12
Power BI Demo: Grouping & Aggregating Records
0:06:12
Power BI Demo: Pivoting & Unpivoting Data
معاينة 0:03:41
Merging Queries in Power BI Desktop
0:07:30
Appending Queries in Power BI Desktop
0:09:13
PRO TIP: Appending Files from a Folder
معاينة 0:09:13
Configuring Power BI Data Source Settings
0:07:30
Configuring Power BI Query Refresh Settings
0:03:41
Additional Data Types & Categories in Power BI
0:06:12
Defining Hierarchies in Power BI Desktop
0:09:13
PRO TIP: Importing Models from Excel to Power BI
0:03:41
Power BI Data Connection Best Practices
0:03:41
QUIZ: Connecting & Shaping Data with Power BI Desktop
0:06:54
HOMEWORK: Connecting & Shaping Data with Power BI Desktop
0:06:12
HOMEWORK SOLUTION: Connecting & Shaping Data with Power BI Desktop
0:06:54
Introduction
0:09:13
What is a "Data Model"?
0:06:54
Principles of Database Normalization
0:07:30
Understanding Data Tables vs. Lookup Tables
0:06:54
Understanding Table Relationships vs. Merged Tables
0:06:12
Creating Table Relationships in Power BI Desktop
0:06:54
"Snowflake" Schemas in Power BI
معاينة 0:03:41
Managing & Editing Table Relationships in Power BI Desktop
0:09:13
Managing Active vs. Inactive Relationships
0:03:41
Understanding Relationship Cardinality
معاينة 0:09:13
Connecting Multiple Data Tables in Power BI Desktop
0:09:13
Understanding Filter Flow
0:07:30
Two-Way Filters in Power BI Desktop (USE WITH CAUTION!)
0:06:54
Hiding Fields from the Power BI Report View
0:06:12
UPDATE: New Power BI Desktop "Model" View
0:09:13
Power BI Data Model Best Practices
0:09:13
QUIZ: Creating Table Relationships & Data Models in Power BI
0:03:41
HOMEWORK: Creating Table Relationships & Data Models in Power BI
0:06:54
HOMEWORK SOLUTION: Creating Table Relationships & Data Models in Power BI
0:07:30
Introduction
0:06:12
Meet Data Analysis Expressions (DAX)
0:06:54
Intro to DAX Calculated Columns
0:03:41
Intro to DAX Measures
0:06:12
RECAP: Calculated Columns vs. DAX Measures
معاينة 0:09:13
Adding Columns & DAX Measures in Power BI Desktop
0:06:54
Implicit vs. Explicit DAX Measures
0:03:41
Filter Context Examples in Power BI
0:03:41
Step-by-Step DAX Measure Calculation
معاينة 0:06:12
Understanding DAX Syntax & Operators
0:06:12
Common DAX Function Categories
0:09:13
DAX Demo: Basic Date & Time Functions
0:03:41
DAX Demo: Conditional & Logical Functions (IF/AND/OR)
0:03:41
DAX Demo: Common Text Functions
0:03:41
DAX Demo: Joining Data with RELATED
0:07:30
DAX Demo: Basic Math & Stats Functions
0:07:30
DAX Demo: COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
0:07:30
IMPORTANT: Order Line Items
0:06:54
DAX Demo: CALCULATE
معاينة 0:06:12
DAX Demo: CALCULATE & ALL
0:06:54
DAX Demo: CALCULATE & FILTER
0:07:30
DAX Demo: Iterator Functions (SUMX, RANKX)
0:06:12
DAX Demo: Time Intelligence Formulas
0:06:54
DAX Best Practices in Power BI Desktop
0:06:12
QUIZ: Analyzing Data with DAX Calculations in Power BI
0:06:12
HOMEWORK: Analyzing Data with DAX Calculations in Power BI
0:06:12
HOMEWORK SOLUTION: Analyzing Data with DAX Calculations in Power BI
0:06:12
Introduction
0:06:54
Exploring the "Report" View in Power BI Desktop
0:03:41
Adding Simple Objects to the Power BI Report Canvas
0:06:54
Inserting Basic Charts & Visuals in Power BI
0:06:54
UPDATE: Conditional Formatting
0:07:30
Power BI Report Formatting Options
0:07:30
Power BI Report Filtering Options
0:07:30
Power BI Demo: Exploring Data with Matrix Visuals
0:09:13
Power BI Demo: Filtering with Date Slicers
0:06:54
Power BI Demo: Showing Key Metrics with Cards & KPI Visuals
معاينة 0:03:41
Power BI Demo: Inserting Text Cards
0:06:54
Power BI Demo: Visualizing Geospatial Data with Maps
0:03:41
Power BI Demo: Visualizing Data with Treemaps
0:06:12
Power BI Demo: Showing Trends with Line & Area Charts
0:06:12
Power BI Demo: Adding Trend Lines & Forecasts
0:06:12
Power BI Demo: Goal Pacing with Gauge Charts
معاينة 0:09:13
Editing Power BI Report Interactions
0:06:12
Power BI Demo: Adding Drillthrough Filters
0:06:54
Using Power BI Report Bookmarks
معاينة 0:09:13
PRO TIP: Testing Scenarios with "What-If" Parameters
0:09:13
Managing & Viewing Roles in Power BI Desktop
0:09:13
PREVIEW: Custom Power BI Visuals (Log-in Required)
0:09:13
PREVIEW: Designing for Phone vs. Desktop Report Viewers
0:09:13
PREVIEW: Publishing to Power BI Service
0:03:41
Power BI Data Visualization Best Practices
0:03:41
QUIZ: Visualizing Data with Power BI Reports
0:07:30
HOMEWORK: Visualizing Data with Power BI Reports
0:06:12
HOMEWORK SOLUTION: Visualizing Data with Power BI Reports
0:09:13
Power BI Demo: Q&A Visual
0:06:12
Power BI Demo: Key Influencers Visual (Part 1)
0:07:30
Power BI Demo: Key Influencers Visual (Part 2)
0:09:13
IMPORTANT: Correlation vs. Causation
0:03:41
Power BI Demo: Decomposition Tree Visual
0:06:12
Introduction
0:06:54
PART 1: Connecting & Shaping the Data
0:03:41
PART 2: Creating the Data Model
0:06:54
PART 3: Adding DAX Measures
0:09:13
PART 4: Building the Report
0:03:41
REFERENCE: Monthly Power BI Updates
0:09:13
BONUS LESSON
معاينة 0:06:54

حول المعلم

Rita Tremblay
0.00 (0)

Rita Tremblay

الدورات 2

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

عرض الملف الشخصي

المزيد من الدورات التدريبية من Rita

The Complete Train the Trainer Bootcamp - Beginners-Advanced
4.00 (1)
The Complete Train the Trainer Bootcamp - Beginners-Advanced
67ح 35م 603 محاضرات

Rs.726.00

Rita Tremblay
Rita Tremblay
يستخدم موقع الويب ملفات تعريف الارتباط لتوفير أفضل تجربة للمستخدم أثناء التصفح بأمان. يمكنك قراءة المزيد عن ملفات تعريف الارتباط في سياسة الخصوصية. Cookies Policy
قبول ملفات تعريف الارتباط اختر ملفات تعريف الارتباط

Please rotate your device for better view