About
LearnDesk
Learn  
Topics
Topics
Topics
Topics
Topics
Topics
Topics
Teach
  Teach Online
  Schedule
  Items
  Billing
  Users
  Marketing
  Analytics
  Settings
  Change School
Account
 

Microsoft Power BI: A Complete Introduction

Getting Started
Welcome to This Course
Preview
Understanding the Power BI Tools
Initial Project 1/3: Installing Power BI Desktop and Connecting to Data
Initial Project 2/3: Working in the Query Editor
Initial Project 3/3: Working in the Data Model and Creating a Visualization
Course Outline
How to Use the Attached Project Files
An Introduction to Power BI Desktop
An Overview of the Workflow in Power BI Desktop
Introducing the Different Views of the Data Model
Taking a Closer Look at the Query Editor Interface
Before we Dive Deeper: Recommended Settings
An Introduction to the Query Editor
Just to Be Sure: What is the Query Editor?
Connecting Power BI Desktop to our Data Sources
Editing Rows
Understanding Append Queries
Editing Columns
Replacing Values
Formatting Data
Pivoting and Unpivoting Columns
Splitting Columns
Creating a New Group for Our Queries
What we Achieved Until Now and How to Continue
Introducing the Star Schema
Duplicating and Referencing Queries
Creating the DIM Region Table
Entering Data Manually
Merging Queries
Finishing the DIM Region Table
Introducing the DIM AgeGroup Table
Creating an Index Column
Duplicating Columns and Extracting Information
Creating Conditional Columns
Creating the Fact Population Table
Performing Basic Mathematical Operations
Improving Performance and Loading Data Into the Data Model
Module Summary
Working on our Data Model: Data and Relationship View
Module Introduction
Query Editor vs. Data Model
Introducing and Understanding Relationships
Editing Relationships
Understanding Cardinality
Cross Filter Selection and Many-to-Many Relationships
Active Properties
Understanding the Differences Between the M-Language and DAX
M vs. DAX Applied: Calculated Columns
M vs. DAX: Conclusion
DAX - Basic Information
DAX and Calculated Columns
Calculated Columns vs. Measures
Introducing DAX-Measures
DAX-Measures Continued
Categorizing Data
Module Summary
Working in the Report View to Visualize our Results
Module Introduction
Understanding the Interface of the Report View
Creating our First Visualizations
Editing Interactions and Adding Tooltips
Adding Color Saturation
Understanding Hierarchies and Adding Drill-Down
Formatting Charts and Sorting
Introducing Slicers
Adding Treemaps and Tables
Applying Different Filter Types
Creating (Multi-Row) Cards
Understanding Combined Visualizations and Waterfalls
Module Summary
Power BI Service and Power BI Mobile - How to Continue?
Module Introduction
Continuing our Work and Why we Need Power BI Service
Comparing Power BI Free, Pro and Premium
Logging in to Power BI Service
Understanding the Interface
Importing our Data From Power BI Desktop to Power BI Service
Understanding the Dataset Menu
Working on Reports
Introducing Dashboards
Exploring our Workspace
Understanding Gateways
Comparing Personal and On-Premise Gateway and Installing a Gateway
Working Alone or Collaborating With Colleagues
Collaborating in App Workspaces
Sharing the Results
Publishing the App
Content Packs From Online Services
Power BI Mobile: Installing and Understanding the Mobile App
One Last Thing: Excluding Datasets From Sharing
Module Summary
Other Data Sources
Module Introduction
Importing JSON Data
Importing Data From REST APIs
Preparation: Setting Up a MySQL Server
Importing Data From a MySQL Server (and other SQL Servers)
Wrap Up
Creating Custom Visuals (Power BI for Developers)
Module Introduction
How do Custom Visuals Work?
Using Data Driven Documents (D3)
Creating and Using a Visual
Installing an IDE (Code Editor)
Understanding the Visuals.ts File
Understanding the Project Structure
Installing d3.js (Data Driven Documents)
Adding a First Shape
Connecting Shapes to Data
Scaling Shapes
Managing Visual Capabilities to Allow Data Input
Starting the Data Extraction
Limiting the Data Input
Extracting Data
Displaying the User Data
Optimizing the Code
Adding Dynamic Coloring
Making Bars Selectable (Cross-Visual)
Adding X-Axis Labels
Adding Custom Visuals Settings
Extracting the Visual Configuration
Informing Power BI About the Custom Configuration
Next Steps
Packaging the Custom Visual
Wrap Up
Course Roundup
Congratulations

DAX and Calculated Columns

Microsoft Power BI: A Complete Introduction Working on our Data Model: Data and Relationship View
By: Packt Publishing
8 minutes
Share the link to this page
Copied
  Twitter
  Email
Add the class to your calendar
Print
  Completed
You need to have access to the item to view this lesson.
One-time Fee
R2,455.99
₹11,993.99
₨11,993.99
$173.99
€149.63
£131.53
CA$243.31
A$265.65
S$225.36
HK$1,355.06
CHF 139.68
NOK kr1,762.53
DKK kr1,117.56
NZ$303.51
د.إ638.97
৳21,188.78
RM718.75
₦251,097.14
฿5,560.72
₺7,390.94
B$936.39
Лв292.92
₩255,599.51
₪567.82
₱10,183.37
¥27,013.01
MX$3,180.87
QR632
P2,480.73
KSh22,505.60
E£8,266
ብር26,758.72
Kz158,599.71
CLP$161,043.40
CN¥1,230.42
RD$10,862
DA22,639.05
FJ$395.17
Q1,328.32
GY$36,277.14
ISK kr22,206.34
DH1,608.65
L2,917.84
ден9,233.03
MOP$1,390.71
N$2,969.35
C$6,380.77
रु24,813.49
S/583.56
K745.27
SAR652.93
ZK3,975.08
L761.65
Kč3,614.66
Ft56,945.48
SEK kr1,641.13
ARS$252,335.52
Bs1,198.19
COP$648,238.73
₡86,446.33
L4,565.94
₲1,212,581.06
$U6,870.02
zł632.76
Already have an account? Log In
Previous
Next
Home
Search
Saved
Trending Classes
Filter
The latest and the best classes on LearnDesk
Filter by Interest
Close
All Topics
Academics
Business
Creative
Health and Fitness
LifeStyle
Personal Development
Software
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Other
Pharma
Research
Science
Social Science
Teaching
Test Preparation
K-12
School
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
Internet of Things
Digital Transformation
Human Resources
Industry
Management
Marketing
Media
Operations
Other
Project Management
Public Relations
Real Estate
Sales
Strategy
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
Self Defense
Sports
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
Travel
Career Development
Learning
Religion and Spirituality
Self-Improvement
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
Content Management System
Customer Relationship Management
Database
Data Mining
E-Commerce
Enterprise Asset Management
Enterprise Resource Planning
Game Development
Google Cloud
Linux
Artificial Intelligence
Machine Learning
Master Data Management
Microsoft
Music Software
Network and Security
Open Source
Operating System
Other
Process Management
Productivity Software
Programming Languages
Robotics
Supply Chain Management
Testing
Teaching
Web Development

Sign Up

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.