Tag: Automation

Advanced Analytics in Power BI With R and Python: Ingesting, Transforming, Visualizing

Posted onAuthorKieran Lamb

Pages: 393 Format: EPUB Publisher: APress
Published: 13/10/2020
eISBN-13: 9781484258293

This easy-to-follow guide provides R and Python recipes to help you learn and apply the top languages in the field of data analytics to your work in Microsoft Power BI. Data analytics expert and author Ryan Wade shows you how to use R and Python to perform tasks that are extremely hard, if not impossible, to do using native Power BI tools. For example, you will learn to score Power BI data using custom data science models and powerful models from Microsoft Cognitive Services.

The R and Python languages are powerful complements to Power BI. They enable advanced data transformation techniques that are difficult to perform in Power BI in its default configuration but become easier by leveraging the capabilities of R and Python. If you are a business analyst, data analyst, or a data scientist who wants to push Power BI and transform it from being just a business intelligence tool into an advanced data analytics tool, then this is the book to help you do that.

What You Will Learn

  • Create advanced data visualizations via R using the ggplot2 package
  • Ingest data using R and Python to overcome some limitations of Power Query
  • Apply machine learning models to your data using R and Python without the need of Power BI premium compacity
  • Incorporate advanced AI in Power BI without the need of Power BI premium compacity via Microsoft Cognitive Services, IBM Watson Natural Language Understanding, and pre-trained models in SQL Server Machine Learning Services
  • Perform advanced string manipulations not otherwise possible in Power BI using R and Python

Who This Book Is For

Power users, data analysts, and data scientists who want to go beyond Power BI’s built-in functionality to create advanced visualizations, transform data in ways not otherwise supported, and automate data ingestion from sources such as SQL Server and Excel in a more concise way

Building the Modern Workplace With SharePoint Online: Solutions With SPFx, Power Automate, Power Apps, Teams, and PVA

Posted onAuthorKieran Lamb

Pages: 343 Format: EPUB Publisher: APress Published: 01/07/2021
eISBN-13: 9781484269459

Build a digital workplace solution from scratch using SharePoint Online, Teams, and the Power Platform. The book will help you implement all the modern capabilities of the SharePoint Framework, Teams, and Power Platform into a SharePoint Online solution.You will begin your journey with a short overview of the basics of SharePoint Online. You will then work through a case study with a solutions approach to implement various business requirements using SharePoint Online. Further, you will learn how to provision sites using PnP and build SharePoint forms using out-of-the-box forms. The next section covers Power Apps and Power Automate, followed by a discussion on SharePoint Framework where you will learn to customize SharePoint Online sites using SPFx. Moving forward you will go through configuration and customization of PnP modern search. Wrapping up, you will integrate Microsoft Teams, MS Graph, and Power Virtual Agents with SharePoint Online. After reading Building the Modern Workplace with SharePoint Online you will be able to build SharePoint Online sites according to your business requirements and integrate SharePoint Online with other services for a modern workplace experience. What You Will Learn:

  • Build modern workplace solutions using SharePoint Online out-of-the-box features Use Power App forms, SPFx web parts, SPFx extensions, and modern search
  • Create Power Automate workflows
  • Develop Teams solutions and chatbots
  • Use Microsoft Graph and PnP JS with SharePointCustomize search capabilities
  • Who This Book Is ForAll SharePoint developers and power users.

Workflow Automation with Microsoft Power Automate: Achieve digital transformation through business automation with minimal coding

Posted onAuthorKieran Lamb

Pages: 302 Format: EPUB Publisher: Packt Publishing
Published: 18/09/2020
eISBN-13: 9781781267608

Enhance your organization’s productivity by automating repetitive tasks and simplifying business workflows using Microsoft Power Automate (formerly Microsoft Flow)Key FeaturesCreate basic and advanced workflows for automating Twitter posts, sending emails, push notifications, and much moreManage user inputs, documents, approvals, and database storage using flow controlsCreate flows that integrate with services both inside and outside the Microsoft 365 ecosystemBook DescriptionMicrosoft Power Automate (formerly Flow) is a workflow automation tool built into Microsoft 365 to help businesses and users to automate repetitive tasks or trigger business processes without user intervention. If you are new to Microsoft Power Automate, this book will give you a comprehensive introduction to help you to get up to speed with automating business processes in no time. Complete with hands-on tutorials, projects, and self-assessment questions, this easy-to-follow guide will show you how to configure automation workflows for business processes between hundreds of Microsoft and third-party applications. Once you understand how to use connectors, triggers, and actions to automate business processes, you’ll get to grips with managing user inputs, documents, approvals, and database storage using efficient flow controls. This Power Automate book explains key concepts and takes you through creating your own flows step by step. By the end of the book, you’ll have learned how to use Microsoft Power Automate to replace repetitive tasks with business workflow automation technology.What you will learn:

  • Get to grips with the building blocks of Power Automate, its services, and core capabilities
  • Explore connectors in Power Automate to automate email workflows
  • Discover how to create a flow for copying files between two cloud services
  • Understand the business process, connectors, and actions for creating approval flows
  • Use flows to save responses submitted to a database through Microsoft Forms
  • Find out how to integrate Power Automate with Microsoft Teams

Who this book is forThe book is for technologists, system administrators, and Power users with little or no Microsoft Power Automate experience. Familiarity with basic Microsoft 365 services is expected.