Record Display for the EPA National Library Catalog

RECORD NUMBER: 19 OF 106

Main Title Creating business applications with Office 365 : techniques in SharePoint, PowerApps, Power BI, and more /
Author Rhodes, Jeffrey M.,
Publisher Apress,
Year Published 2019
OCLC Number 1112129729
ISBN 1484253302; 9781484253304
Subjects Business--Computer programs
Holdings
Library Call Number Additional Info Location Last
Modified
Checkout
Status
ELBM  HF5548.4.M525R525 2019 AWBERC Library/Cincinnati,OH 08/17/2022
Collation xviii, 241 pages : illustrations, portraits ; 24 cm
Notes
Includes index.
Contents Notes
Take your Office 365 and SharePoint projects to a higher level by using PowerApps, Flow, Power BI, JavaScript/jQuery jQuery UI widgets, Cascading Style Sheets (CSS), and more. This book will help you create easier solutions to client-side problems and applications. Additionally, you will be able to effectively visualize your data with Power BI. This book starts with configuration of SharePoint and Office 365 followed by your first example of PowerApps. You will lay the foundation for a help ticket application and see how to update a SharePoint list with PowerApps. You then will work with the jQuery open source library and learn how to use the developer tools within your browser. This allows you to customize data displays in SharePoint. Next, you will add jQuery UI widgets such as buttons and dialogs to SharePoint, learning how to configure and manipulate them via JavaScript. You will use these new skills to convert a normal SharePoint announcement into a visually compelling page of network alerts. You also will use JavaScript and styles to hugely improve native SharePoint calendars by color-coding them by category or location. To prevent overlapping events in calendars, you will work with SharePoint's web services and JavaScript. You will use similar concepts to make appealing accordion SharePoint pages. You then will explore Microsoft Forms, Flow, and Power BI, including building surveys in both Forms and SharePoint and using Power BI to show results over the last week, month, quarter, and year. Using advanced Power BI you will see how to deal with JSON, XML, and Yes/No data. Next, you will look at how to display Office documents as well as interact with them via JavaScript. Switching back to PowerApps, you will build the final help ticketing system before using Power BI to see how to visualize the ticket information. After a quick detour on using iFrames in SharePoint, you will jump into building a power routing application using InfoPath and SharePoint Designer. You will even call SharePoint's web services from Designer to customize email notifications. You end the InfoPath set of chapters with a highly useful application for signing up for and managing attendance for training and other classes. Finally, you will add Google Analytics to track SharePoint usage. Enabling SharePoint designer and custom scripting -- Updating a SharePoint list using PowerApps -- Customizing date displays with jQuery -- Adding jQuery UI controls -- Customizing an announcement list with jQuery -- Creating a color calendar -- Preventing double-booking of calendar events -- Building an accordion interface -- Creating an approval process with Microsoft flow -- Creating a survey response dashboard with Microsoft Power BI -- Creating a survey solution with Microsoft forms, flow, sharePoint, and Power BI -- Power BI challenges with JSON, XML, and Yes/No data -- Power BI case study: monitoring BNC remedy help tickets -- Displaying and working with Office documents -- Building a help ticketing system in PowerApps and SharePoint: new ticket form -- Continuing the help ticketing system: technician form -- Using Power BI for the help ticketing system -- Leveraging an iFrame to display another SharePoint page -- Creating system using InfoPath and designer workflows -- Using SharePoint REST services to control email notifications -- Creating a class sign-up solution in SharePoint: InfoPath -- Creating a class sign-up solution in SharePoint PowerApps -- Adding Google analytics.