Technofocus
 

Power Apps, Power BI and Microsoft Flow

 

The way we do work today is fundamentally different than just a few years ago. Work happens on our phones, tablets and laptops everywhere we go: on manufacturing floors, in airplanes or at customer meetings. And yet, the apps we use to do business have been slow to keep pace with employee demand. Not every business problem can be solved with off-the-shelf solutions but developing custom solutions has traditionally been too costly and time consuming. PowerApps, CDS, and Microsoft Flow are aimed squarely at these gaps. With Power BI you will learn how to connect, import, shape, and transform data for business intelligence (BI). Learn how to visualize data, author reports, and schedule automated refresh of your reports. Create and share dashboards based on reports in Power BI desktop and Excel.

 

Duration
3 days


Audience
Business Analysts
Data Professionals
BI professionals
Data visualisation
Presentation consultants

 

DAY 1


Discover Apps via AppSource
Introduction to PowerApps
Introduction to Model-driven Apps
How do I find and run apps?
Find apps via the AppSource organization gallery
Creating Apps in PowerApps


Introduction to Canvas Apps
What are Canvas apps in PowerApps?
Explore Sample Apps
Create your first app
Introduction to Forms
How PowerApps and SharePoint interact
Building an app from SharePoint
Building a canvas app with galleries and connected screens


Introduction to Common Data Services
Introduction to CDS for Apps
Creating an Environment
Working with Entities, fields, relationships and business rules
Connecting CDS in a Canvas App


Introduction to Model Driven Apps
Model Driven Apps Overview
Model Driven App Features
Sharing and Publishing model driven apps
Incorporating Business Process Flows


DAY 2


Introduction to Microsoft Flow

Flow Overview
Creating a Flow
Different types of Flows
Managing Approval Process
Importing and Exporting Flows
Monitoring and Repair
Integrating PowerApps and Flow


Introduction to Power BI
Power BI Overview
Transforming Data Using Power BI Desktop
Connecting to Database
Basic Transformations
Connecting to Files and Folders
Merge Queries
Transforming less structured data


Data Modelling in Power BI Desktop
Introduction to data modelling
Managing Data Relationships
Optimizing Models for Reporting
Creating Calculated Measures
Creating and Managing Hierarchies
Using Calculated Tables
Time Intelligence


Visualizing Data
Visualizing Your Data
Pie and Tree map
Hierarchical Axis and Concatenating
Analysis Pane
Clustering (and Machine Learning)
Slicer
Map Visualisations
ESRI Map
Table Styles
Working with Multiple Visualizations
Visual Relationship
Categories with No Data
Custom Hierarchies
R-Visual Integration


DAY 3


Power BI Service
Dashboards and Service
Quick Insights
Configuring a Dashboard
Featured and Favourite Dashboard
Natural Language Queries
Features Questions
Custom URL and Title
Power BI Notifications
Personal Gateway
Admin Portal
Publishing to Web
Viewing Dashboard in mobile App


Connecting and Collaborating with Excel
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
Analysing Data in Excel


Direct Connectivity
Direct Connectivity to SQL Database
Direct Connectivity to SSAS
Using SSAS Connector
SSAS Multi Dimensional Preview


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


Mobile App experience
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