Power Platform

  Use visuals in Power BI Introduction                      Microsoft Power BI is a collection of apps, software services and connectors that come together to turn unrelated data into visually impressive and interactive insights. Power BI can work with simple data sources like Microsoft Excel and complicated ones like cloud-based or on-premises hybrid Data warehouses. Power BI has the capabilities to easily connect to your data sources, visualise and share and publish your findings with anyone and everyone. Visuals allow you to present data in a compelling and insightful way, and help you show the important components of it. Power BI has many compelling visuals and many more that are released frequently. Create and customize simple visualizations Two ways to create a new visualization in Power BI Desktop are: • Drag field names from the Fields pane and then drop them on the report canvas. By default,  your visualizati...

  Model data in Power BI Introduction          Power BI is simple and fast enough to connect to an Excel workbook or a local database. It can also be robust and enterprise-grade, ready for extensive modeling and real time analytics. This means it can be used in a variety of environments from a personal report and visualisation tool to the analytics and decision engine behind group projects, divisions, or entire corporations.         As Power BI is a Microsoft product and has built in connections to Excel, there are many functions that will be familiar to an Excel user. A data model can be defined as the organisation and relationships of a set of two or more data tables. There are several ways to represent data models, one of the most commonly used method is the Entity-Relationship Diagram (ERD). Power BI’s data model view represents the report’s data model with an ERD: In power BI desktop The Model view in Power BI Desktop allows yo...

  How to build a basic chatbot Introduction Power Virtual Agents are adaptable Artificial Intelligence (AI) chatbots, at your service. They can solve common customer and internal-facing issues automatically, freeing up staff to focus on complex requests and high-value interactions. You can easily create your own virtual agents, powerful chatbots, without the need for developers or data scientists, by using a guided, no-code graphical interface.    Power Virtual Agents allows you to create bots that can help answer questions from your customers, employees, or viewers of your website. These powerful chatbots use built-in content building blocks, trigger phrases, and pre-authored bot conversations to keep you connected in real time. Create a chatbot 1) Open Chrome, and Firefox. On the website, select Start Free, and then sign in with your work email       address.  2) Next, you’ll choose a name for your chatbot.  3) Once you select Create, the p...

  Introduction to Power Virtual Agents Introduction Power Virtual Agents are adaptable Artificial Intelligence (AI) chatbots, at your service.  They can solve common customer and internal-facing issues automatically, freeing up staff  to focus on complex requests and high-value interactions. You can easily create your own virtual agents, powerful chatbots, without the need for developers or data scientists, by using a guided,  no-code graphical interface. Power Virtual Agents allows you to create bots that can help answer questions from your customers, employees, or viewers of your website. These powerful chatbots use built-in content building blocks,  trigger phrases, and pre-authored bot conversations to keep you connected in real time. What is Power Virtual Agents? - Power Virtual Agents empowers teams to easily create powerful chatbots using a guided, no-code graphical    interface without the need for data scientists or developers.  - Power V...

    How to build a simple dashboard Introduction We need data to help us make these decisions. Power BI Desktop is a free application for PCs that lets you gather, transform, and visualize your data. Power BI Desktop and the Power BI  Service work together. You can create your reports in Power BI Desktop and then publish them to the Power BI Service for others to consume. In this module, you will: • Learn to connect to data in Power BI desktop • Transform and model the data you import • Build basic visualizations • Create and share a dashboard • Discover how to collaborate in Power BI Connect to data Power BI Desktop connects to many types of data sources, including local databases, worksheets,  and data on cloud services. Sometimes when you gather data, it's not quite as structured, or clean,  as you want it to be. To structure data, you can transform it, meaning that you can split and rename  columns, change data types, and create relationships between co...

  Analyze data with Power BI How do you analyze data in Power BI? Report authors can use more features to enhance their reports for analytical insights in their data with features like Q&A and exporting. In this module, you will closely examine your data and Power BI reports and then extract value with deeper analysis.   Filter data with Power BI Data is the core of Power BI. As you explore reports, each visual draws its underlying data from sources that often contain far more data than you need. Power BI offers several ways to filter and highlight reports. Knowing how to filter data is the key to finding the right information. Slicers A simple type of filtering that you can use directly on the report page is called a slicer. Slicers provide clues to ways you can filter the results in the visuals on a report page. There are several different types of slicers: numeric, categorical, and date. Slicers make it easy to filter all the visuals on the page at once. Explore the Fil...

         Publish and share in Power BI Introduction :- To publish a report to the web, you have to navigate to Power BI service → My Workspace. Once you open the report that you want to publish, navigate to the File tab → Publish to Web. Once you select this option, it opens a new dialog that creates an embed code for this report to include in the website or email.  you will want to share your reports and dashboards with your coworkers and friends at some point. With Power BI, publishing and sharing your reports and dashboards is straightforward. Publish Power BI Desktop reports Publishing your reports to the Power BI service is fast and simple. After you've completed writing your report, select the Publish button on the Home tab. Power BI packages your report and data, including visualizations, queries, and custom measures,  and uploads them to the Power BI service.  Print and export dashboards and reports In the Power BI service, select File in ...