Sunday 26 August 2018

Mobile APP

Report Gallery and Search
Mobile Dashboard Layout
Sharing and Annotating in Power BI Mobile
Taking Your Mobile Content Offline
Platform Specific Features
Search and Recent
Limiting Access to Mobile + MAM

Developer API

Interactive API Console
Registering a Client App and Embedding a Tile
Using PubNub to Push Data to a Tile
Creating Custom Visuals
Using Custom Visuals
Power BI Embedded

Direct Connectivity and PBI service

Direct Connectivity to SQL Azure
Direct Connectivity to SQL Database
Direct Connectivity to SSAS
Using SSAS Connector
SSAS Multi Dimensional Preview
SAP HANA

Organization packs, Security and groups

Creating a Group
Creating a Content Pack
Using a Content Pack
Editing a Content Pack
OneDrive for Business Integration
Row Level Security
Data Classification

Working with excel- Power Bi service

Importing Excel Data using Simple Table
Excel Workbook with Excel Data Model
Connecting to Excel Workbook on OneDrive for Business
Pinning Excel Tables or Visuals
Analyzing Data in Excel

Viewing Power BI Dashboard

Viewing in Windows App
Viewing in Android App
Viewing in Ipad
Viewing in iPhone

Working With Power BI service

Overview of Dashboards and Service
Uploading to Power BI Service
Quick Insights
Configuring a Dashboard
Adding Textbox, Image Widgets
Featured and Favorite Dashboard
Filtering Dashboard
Dashboard Settings
Natural Language Queries
Featured Questions
Sharing a Dashboard
In-Focus Mode
Pinning a Live Page
Custom URL and Title
TV Mode and Collapse Navigation
Printing Dashboard and Exporting Data
Export to CSV and Excel
Power BI Notifications
Alerts in the Power BI Service
Personal Gateway
Publishing to Web
App Build and share
Admin Portal

PBI Desktop - Data Visualisation

Visualizing Data: 

Introduction
Pie and Treemap
Hierarchical Axis and Concatenating
Filter (Including TopN)
Bar Chart with Line (Combo Chart)
Analytics Pane
Clustering (and Machine Learning)
Slicer
Focus Mode and See Data
Date Slicer
Map Visualizations
ESRI Map
Table and Matrix
Table Styles
Scatter Chart
Waterfall
Gauge, Card, and KPI
Coloring Charts
Shapes, Textboxes, and Images
Gridlines and Snap to Grid

Working with multiple Visualization:

Page Layout and Formatting
Visual Relationship
Duplicate Page
Categories with No Data
Default Summarization and Categorization
Positioning, Aligning, and Sorting Visuals
Custom Hierarchies
R - Visual Integration
Python - Visual Integration

PBI desktop- Data Modeling


Introduction
Managing Data Relationships
Creating Calculated Columns
Optimizing Models for Reporting
Creating Calculated Measures
Creating and Managing Hierarchies
Using Calculated Tables
Time Intelligence
Manually Typing in a Data Table
Include / Exclude
Grouping / Binning

PBI desktop- Data transformation

Introduction to Power BI Desktop
Changing Locale
Connecting to a Database
Basic Transformations
Managing Query Groups
Splitting Columns
Changing Data Types
Working with Dates
Removing and Reordering Columns
Conditional Columns
Connecting to Files in a Folder
Merge Queries
Query Dependency View
Transforming Less Structured Data
Enter Data
Query Parameters

Introduction

What is Power BI?

  • Introduction
  • overview of power bi

Set Up and Installation

Power BI Installed