fbpx

Microsoft Power BI Developer

Microsoft Power BI Developer

Overview
Microsoft Power BI is a data visualization tool with concepts like Power BI Desktop, Data Transformation, Power BI Data Analysis Expressions (DAX), SSRS, Power BI Q&A and Data insights, Power BI Content packs, Power BI Custom Visuals, Power BI Integrations.
Curriculum

Getting Started

  • 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
  • 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
  • Important! Before we Dive Deeper: Required Power BI Settings

An Introduction to the Query Editor

  • Just to be sure: What is the Query Editor?
  • Before we Start – About the Attached Project Files
  • 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

Working on our Data Model: Data & Relationship View

  • 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 

Working in the Report View to Visualize our Results 

  • Understanding the Interface of the Report View
  • Creating our First Visualizations
  • Editing Interactions and Adding Tooltips
  • Adding Data Colors
  • Understanding Hierarchies and Adding Drill-Down
  • Formatting Charts and Sorting
  • About the Slicer
  • Introducing Slicers
  • Adding Treemaps and Tables
  • Applying different Filter Types
  • Creating (Multi-Row) Cards
  • Understanding Combined Visualizations and Waterfalls 

Power BI Service & Power BI Mobile

  • 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
  • Excluding Datasets from Sharing

Other Data Sources

  • Importing JSON Data
  • Importing Data from REST APIs
  • Preparation: Setting up a MySQL Server
  • Importing Data from a MySQL Server (and other SQL Servers) 

Creating Custom Visuals (Power BI for Developers)

  • Developer Prerequisites
  • Module Introduction
  • How do Custom Visuals Work?
  • Using Data Driven Documents (D3)
  • Please Read – Creating & Installing a Certificate
  • 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
Features
Real Life Case Studies

Real Life Case Studies

Projects modeled on select use cases with implementation of diverse technology concepts

Assignments

Assignments

All guided classes and courses are mandatorily followed by useful practical assignments

24x7 Expert Support

24x7 Expert Support

Every technical query is resolved on demand with readily available expert assistance

Instructor-led Sessions

Technical session conducted under the guidance of qualified and certified educationists

Course Info

Course Start Date 09/09/2019
Estimated Duration 3/4 Weeks
Maximum Students 20
Levels Advanced

Social Share