POWERPLATFORM COMBO Training in Pune/ Online

Courses Included:-

POWER BI + POWERAPPS + POWER AUTOMATE

Duration of Training  :  4 months

Batch type  :  Weekdays/Weekends

Mode of Training  :  Classroom/Online/Corporate Training

POWER BI

COURSE CONTENT

Data Transformations :

• 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
• Merge Queries
• Query Dependency View
• Transforming Less Structured Data
• Query Parameters

Data Modelling :

• Managing Data Relationships
• Creating Calculated Columns
• Optimizing Models for Reporting
• Creating Calculated Measures
• Creating and Managing Hierarchies
• Using Calculated Tables
• Time Intelligence
• Include and Exclude features
• Grouping and Binning

Visualizing your Data :

• Introduction to charts: Pie, Tree map, Combo charts, Map Visualizations, Scatter plot, Table, Matrix, Gauge, Card, Shapes, Textboxes, Images and KPI
• Filter (Including TopN), Date Slicer
• Coloring Charts
• Page Layout, Positioning, Aligning, Sorting Visuals and Formatting
• Visual Relationship
• Custom Hierarchies

Working with PBI Service :

• Overview of Dashboards and Service
• Uploading to Power BI Service
• Configuring a Dashboard
• Dashboard Settings
• In-Focus Mode
• Pinning a Live Page
• Custom URL and Title
• Export to CSV and Excel
• Power BI Notifications
• Publishing to Web

Working with Excel :

• Importing Excel Data using Simple Table
• Connecting to Excel Workbook on OneDrive for Business
• Pinning Excel Tables or Visuals

Organization Packs, Security and Groups :

• Creating a Group
• Creating, Using and Editing a Content Pack
• Row Level Security
• Data Classification
• Creating and Using Custom Visuals

POWER PLATFORM

Microsoft PowerApps

This course delivers an instructor-led breakdown of Microsoft PowerApps. Students will be taught how to design, test and publish new applications that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.

Module 1: An introduction to Microsoft PowerApps

Let’s get started with an introduction to Microsoft PowerApps. Traditionally building customized solutions for a business involved using a coding language to build an application from scratch. Typically, these solutions could often only be used within the business, making external use of the application a large hurdle to overcome. With PowerApps we can now not only easily build solutions, but we can also share them with users in our business. Deployment takes seconds and you could by testing your own app on your phone in no time. This module will overview the features of PowerApps, its benefits to a business and the variety of ways you can build and access your apps on different devices.

Topics Covered

• What is PowerApps?
• The benefits of apps
• How to get to PowerApps
• Canvas Apps and Model-Driven Apps
• License Options and Costs

Module 2: Getting started with PowerApps

To begin our journey through the PowerApps product, we will begin by looking at some of the templates that are available to view and edit. Microsoft’s templates are a good starting point to discover what the product is capable off and how it can be achieved. We will also take the chance to have a tour of the editor so that students are familiar with the interface that they will be using over the two-day course. We will then build our first app from a static data source, showing students how to test their changes in the app instantly without the need to publish. We will also discuss how to configure your apps settings and how to access the app once it has been saved and shared.

Topics Covered

• Discover PowerApps with templates
• Building a new app with a data source
• Add, edit and remove controls
• Testing an app
• App settings
• Publish and share an app
• Mobile app

Module 3: Branding and Media

In our next module, we will look at the options available to designers that allow them to implement their business branding. Not only will this deal with the aesthetics of your app, it will also introduce time-saving tips to help keep your branding consistent. We will also be discussing how to embed media into your app which can be useful if you are planning on an app that might promote video content.

Topics Covered

• Linking control properties
• Backgrounds
• Colours and transparency
• Duplicating screens
• Copying the look and feel
• Using images
• Embed and play audio and video

Module 4: PowerApp Controls

So far in the course, we would have covered the basics of adding, editing and removing controls from our applications. The drive behind this module is to provide more depth on the categories of controls which can be used on a form. Your instructor will take you through each control and discuss its purpose and configuration. Tackling the wide selection of controls will help students recognise when to use the right control.

Topics Covered

• Labels
• Buttons
• Text inputs
• Controls
• Galleries
• Data tables
• Forms
• Media
• Charts
• Icons

Module 5: Data Sources and Logic

To help maintain and view essential business information, organisations often have a diverse selection of locations to keep different types of data. This could range from databases to file storage locations. PowerApps offers connections to a wide selection of data sources. We will show students to build their PowerApps to bring in data from a variety of sources as well as how they can utilise the common data source, a storage location unique to PowerApps.

Topics Covered

• Working with files
• Databases
• Filter, sort and search formulas
• If and Select
• Accessing on-premises sources
• The common data source
• Sharing data sources

Module 6: Model-Driven Apps

Module one to five discussed how to work with the original type of PowerApp known as a Canvas App, Microsoft have now introduced a second type of app known as a model-driven app. Model driven apps involve a different development process to canvas apps. We will review this development process during this module.
Model-Driven apps can be quicker to build than canvas apps, but they are less customizable and typically have a higher cost, knowing which type of app to use is not always a simple decision, we will show you the pros and cons of each.

Topics Covered

• What is a model-driven app?
• Where will my data be stored?
• How do create a model-driven app
• Canvas vs model-driven summary
• Mobile App

Module 7: PowerApps Integration

PowerApps is designed to easily connect to other business systems to read and update information. In this module we will discuss some simple ways to integrate PowerApps with key Office 365 systems including Teams, SharePoint Online and Flow. The result, is the ability to use a combination of systems to create solutions for a variety of business requirements.

Topics Covered

• Start a Flow from a PowerApp
• Embed PowerApps in Teams
• Embed PowerApps in SharePoint Online

Module 8: Administration and Maintenance

In our last module for Microsoft PowerApps, we will be looking at how a business can manage their existing apps. This could be using analytics to discover usage trends. We will discover how to export and import apps, so they can be reused in other locations. Finally, we will discuss how Office 365 administrators can shape the PowerApps experience with high-level settings that help ensure data segregation and security.

Topics Covered

• Maintaining an app
• View analytics
• Export and import apps
• Office 365 administration for PowerApps
• Environments
• Data policies
• Data integration

Module 9: Power Automate Editing Interface

In this first module, we will go into creating blank Flows and building them from scratch.  This includes an overview of the interface and options when building Flows, and concepts such as triggers, actions, conditions, and dynamic content.  Flow sharing and collaboration concepts will also be covered, as well as the mobile app.There are hundreds of available triggers in Microsoft Flow.  In this module, you will learn how to use them, and we will deep dive into some specific common and important triggers.  Learn about manual triggers and how initiation parameters work. This module also covers how to trigger a flow from a SharePoint list or library, how to create a flow trigger button on an item, and how to trigger a flow from Teams. Other triggers such as recurrences, Microsoft Forms, and Outlook will be demonstrated as well.

Module 10: Power Automate Approval Processes

In this module, you will learn about your options when it comes to building approval processes.  There is a Flow action called Approvals, that has a lot of built in functionality.  There are also other ways that you can go about it.  Send emails, assign tasks, assign planner tasks, send email with options.  These various ways will be discussed, compared, and demonstrated.  Learn about approval concepts such as dynamic multiple approvers, serial versus parallel, working with SharePoint content approval, and how to build a flow that sends overdue notifications.

Module 11: Power Automate Conditions, Loops & more

This module is about conditions, loops, and some more common actions.  Conditions let you create IF THEN statements and various branches of a workflow.  Learn about the new interface for creating complex conditions, and other related concepts, such as switches and parallel branches.  With more complex workflows, it is also important to understand looping, and different types of loops, such as apply to each, and do until.  In this module, you will also learn about settings that can be configured on each action, and some useful actions such as date time, schedule, and actions that format numbers and dates.

Module 12: Power Automate Variables & Expressions

When building Flows, it is important to understand how variables are used, and how to build expressions.  There are several different types of variables, and there are over twelve different actions relating to variables and other data operations.  In this module, we discuss and demonstrate these, as well as how to work with arrays (lists of things) in Flows.  The expression builder is covered, with examples of how it is used, and what the possibilities are.  You will learn how to parse JSON, work with HTML and CSV table actions, and you will see several advanced demonstrations of how to utilize all these more complex concepts.