Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

MS Power BI

This Power BI - Essentials training course teaches to build and share Power BI dashboards. You will learn to shape, combine, and present visualizations of the data for maximum impact. You can take your new skills and immediately apply them to their current projects.

This Power BI - Advanced training course builds on the Essentials course, teaching the advanced dashboard skills you need for building more sophisticated data visualizations. During class, you will connect to various data sources, shape and combine data, work with reports, and create and share more sophisticated dashboards.

By attending Power BI - Essentials workshop, delegates will learn to:

  • Navigate the Power BI service
  • Integrate Power BI with other Office 365 services
  • Use workspaces
  • Prepare data for building reports
  • Design your Power BI reports for maximum clarity and impact
  • Generate actionable insights from your data
  • Create and style Power BI dashboards

By attending Power BI - Advanced workshop, delegates will learn to:

  • Plan Power BI projects with organization goals in mind
  • Use the Power BI Query Editor for a wide range of operations, including joining multiple data sources
  • Connect to diverse data sources and transform data
  • Design import and DirectQuery data models
  • Develop DAX measures and implement security roles
  • Apply custom visuals, animation, and analytics
  • Build more sophisticated Power BI dashboards
  • Manage the on-premises data gateway
  • Deploy the Power BI Report Server
  • Administer Power BI
  • Implement Power BI security
  • Integrate Power BI with Azure DevOps

For Power BI - Advanced

  • Attend a training on Power BI - Essentials or have the equivalent experience.

COURSE AGENDA

Power BI - Essentials
(Duration : 3 Days)

1

Overview & Eco System

  • What is Power BI?
  • What is Power BI service?
  • How does Power BI fit in your role?
  • Working in Power BI service
  • Use cases for Power BI service
  • Future of Power BI
2

Licensing for Power BI

  • End user licensing with O365
  • Difference between Pro and Free
  • Premium licensing
    • Capacities and the importance
3

Navigating the Power BI Service

4

Collaborating in the Power BI Service

  • Leveraging comments
  • Subscribed email alerts
5

Integration with other O365 services

  • Power Apps
  • Visio
  • Flow
6

Business Use Cases

7

Key Concepts and Terminology

8

Understanding Workspaces and How to Use Them

  • My Workspace
  • Workspaces
9

Preparing Data for Building Reports

  • Data preparation
  • Connecting to external data sources
  • Importing data sources
  • How to share datasets
10

Visualization and Design

  • How to captivate an audience
  • Styling best practices
  • How to tell a story with data
11

Building Reports in the Power BI Service

  • Using the Report Editor
  • Connecting to data sources
  • Understanding datasets and data refresh
  • Filters and highlighting
  • Building simple charts
  • Choosing the right visuals
  • Optimizing for mobile
  • Designing report best practices
  • Dynamic interaction with a report
  • Exporting Reports
  • Publish and share your work
  • Leveraging Bookmarks
  • Automate report delivery
12

Gain Business Insights From Your Data

  • Using Quick insights
  • Create Q&A questions
  • Leverage Q&A for ad-hoc visualization
  • Optimize data for quick insights
13

Creating and Formatting Power BI Dashboards

  • Understanding tile interaction
  • Live reports
  • Kinds of tiles
  • Positioning tiles
  • Designing a dashboard
14

Dataflows

  • What are dataflows?
  • How do they integrate with your organization
  • Connecting to different data sources
  • Building a dataflow
  • Sharing it with others
  • Building reports from dataflows
15

Power BI Apps

  • What is an app?
  • Advantages of using apps
  • How to build an app and share it with others
Power BI - Advanced
(Duration : 3 Days)

1

Introduction

2

Planning Power BI Projects

  • Power BI deployment modes
  • Project discovery and ingestion
  • Power BI project roles
  • Power BI licenses
  • Data warehouse bus matrix
  • Dataset design process
  • Data profiling
  • Dataset planning
    • Sample project analysis
3

Power BI Desktop

  • Overview
  • Use Cases
  • Architecting a PBIX file
  • Preview features
  • Visualizations
  • Data Models
  • Analyzing data in the PBIX tables
  • Navigation
4

Power BI Query Editor

  • Loading data models
  • Leveraging parameters
  • Advanced query editor
  • Data transformation
  • Data manipulation
  • Joining multiple data sources
    • On-premise
    • Cloud
    • Hybrid
  • Understanding query process
5

Connecting to Sources and Transforming Data

  • Query design per dataset mode
  • Data sources
  • SQL views
  • M queries
  • Query folding
  • M Query examples
  • M editing tools
6

Designing Import and DirectQuery Data Models

  • Dataset layers
  • The Data Model
  • Relationships
  • Model metadata
  • Optimizing performance
7

Developing DAX Measures and Security Roles

  • DAX measures
  • Base measures
  • Date intelligence metrics
  • Dimension metrics
  • Ranking metrics
  • Security roles
  • Performance testing
8

Applying Custom Visuals, Animation, and Analytics

  • Drill through report pages
  • Bookmarks
  • ArcGIS Map visual for Power BI
  • Waterfall chart breakdown
  • Analytics pane
  • Quick Insights
  • Custom visuals
  • Animation and data storytelling
9

Data Visualization

  • End User Interaction design
  • End User Experience design
  • How to select the right visual
  • Understanding visual data alignment
  • Data Architecting
  • Snowflake schema
  • Star schema
  • Designing to leverage relationships
  • Dynamic filtering
10

Designing Power BI Dashboards and Architectures

  • Dashboards versus reports
  • Dashboard design
  • Multi-dashboard architectures
  • Dashboard tiles
  • Live report pages
  • Mobile-optimized dashboards
11

Managing Application Workspaces and Content

  • Application workspaces
  • Staged deployments
  • Dashboard data classifications
  • Version control
  • Metadata management
12

Managing the On-Premises Data Gateway

  • On-premises data gateway planning
  • Gateway clusters
  • Gateway architectures
  • Gateway security
  • Gateway configuration
  • Managing gateway clusters
  • Troubleshooting and monitoring gateways
  • Scheduled data refresh
  • DirectQuery datasets
  • Live connections to Analysis Services models
  • Dashboard cache refresh
13

Deploying the Power BI Report Server

  • Planning for the Power BI Report Server
  • Installation
  • Configuration
  • Upgrade cycles
  • Report Server Desktop Application
  • Report Server Web Portal
  • Power BI mobile applications
  • Report server administration
    • Scale Power BI Report Server
14

Creating Power BI Apps and Content Distribution

  • Content distribution methods
  • Power BI apps
  • Self-Service BI workspace
  • Sharing dashboards and reports
  • SharePoint Online embedding
  • Custom application embedding
  • Publish to web
  • Data alerts
  • Email Subscriptions
  • Analyze in Excel
15

Administering Power BI for an Organization

  • Data governance for Power BI
  • Azure Active Directory
16

Power BI Admin Portal

  • Usage metrics reports
  • Audit logs
  • Power BI Premium capacities
  • Managing user access
  • Controlling what is shared
  • Customizing with company branding
  • Controlling workspaces and rights
  • Managing embed codes
  • Types of Administrators
  • Administrative tasks
  • Track service health
  • Data protection
17

Scaling with Premium and Analysis Services

  • Power BI Premium
  • Power BI Premium capacity allocation
  • Premium capacity estimations
  • Analysis Services
  • Migration of Power BI Desktop to Analysis Services
18

Power BI Dataflows

  • Build an ETL
  • Distributing Dataflow
  • Connecting to Dataflows
  • Management
19

Power BI Security

  • Role-based access
  • Designing for RLS
  • Dynamic Role level security
  • Leveraging the AAD
  • Implementing in the Power BI Service
20

Integration with Azure DevOps

  • PBIX version control
  • Continuous integration
  • Continuous deployment
  • Aligning as an Agile/Scrum BI team
  • Pull requests
  • Builds
  • Releases
  • Pipeline management
  • Automatic deployment to Power BI Service
  • Gated deployments with approvals
  • Security
  • Projects

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X