Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Microsoft Power BI – A Complete Introduction

Video Introducing this tutorial

Welcome to this Course
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 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
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
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
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
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
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
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
Congratulations

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396