PowerApps AI Builder Hands-On Lab Binary Classification

The PowerApps AI Builder product team did a great job of creating Labs for PowerApps AI Builder. The challenge I found is they actually put the content in a couple of different locations: Two different GitHub Repos with two different locations in docs that need to be knit together to get it all working. This post simply brings all that content to a single location until the Team makes the demo an installable component.

PowerApps AI Builder needs a large enough dataset size as to train your models. This being the case to get started you need to import data into your CDS instance.

Data Preparation:

    1. Download the AI Builder sample datasets solution, AIBuilderOnlineShopperIntention_1_0_0_0.zip, from here.
    2. In PowerApps, select Solutions in the left-side navigation pane, then select Import at the top of the screen.
    3. In the pop-up screen, select Choose File, and then select AIBuilderOnlineShopperIntention_1_0_0_0.zip that you downloaded in step 1.
    4. Follow the on-screen instructions to import the solution, and then select Close after you finish.

    Next, import the sample data into the entity. In this example, we use the aib_onlineshopperintention.csv file:

    1. In the list of AI Builder samples, select the aib_onlineshopperintention.csv file, and then select Download to open the raw version of the file.
    2. Copy the URL from the address bar in your browser. In this case, the URL to copy is: https://raw.githubusercontent.com/microsoft/PowerApps-Samples/master/ai-builder/aib_onlineshopperintention.csv.
    3. In PowerApps, select Entities in the left-side navigation pane, select Get data > Text/CSV, and then paste the copied URL from the last step into the File path or URL box.
    4. Set the following properties, and then select Next:
      • On-premises data gateway = (none)
      • Authentication kind = Anonymous
    5. On the Map entities screen, make sure Load to existing entity is selected, and under Destination entity, select aib_onlineshopperintention in the drop-down menu.
    6. Select the Delete rows that no longer exist in the query output check box, and then select the Auto-map function that is on the upper right of the Field mapping screen. Select Next.
    7. On the Refresh settings screen, select the Refresh manually check box, and then select Create to start the import process.

    Allow some time for the import to complete. Then, make sure the data is imported correctly.

    1. In PowerApps, go back to Entities under Data and select Online Shopper Intention.
    2. Select Views and then select Active Online Shopper Intention.
    3. Add fields on the left side to validate that all the fields have been imported correctly.
    4. Select Publish to save the current view with the selected fields.

Now that you some data you can use AI Builder!!

This section of the Lab is found in the following Git Repo: https://github.com/microsoft/PowerApps-Samples/blob/master/ai-builder/labs/AIBuilder_Lab.zip

Binary classification

Binary classification uses historical data to predict whether new data falls into one of two categories. You can use these insights to develop actionable intelligence for your business.

In this lab, we will build and train a binary classification model. We will also review the level of influence of the selected criteria. Finally, we will make a model-driven application to review this data prediction.

The data used here will help us predict online shopper intentions. We have details of a shopper’s site visit as well as if that visit resulted in a sale (revenue). Once we have the prediction information, we can use that to help guide marketing plans, website updates, promotional communications, and more.

Note: If you are building the first model in an environment, click on Explore Templates to get started.

Exercise 1

In the first exercise you will build and train your model.

  1. From the left navigation, expand AI Builder and select Build.

  1. Select Binary Classification.

  1. Name your model. Because you are working in a shared environment make sure to include your name as part of the model name. This will make it easier to find later. Click create.

  1. Your screen should look like the following image.

  1. Notice the progress indicator on the left.

  1. You will see Quick tips on the right.

  1. In the center we will build our model. Click in the Entity field and select Online Shopper Intention. This is a custom entity that collects the data we are storing regarding the online shopper’s visit to our site.

  1. From the selected entity we will now see available binary fields for prediction. The only fields we will see here are of type “Two option.” Select Revenue. Click Next.

  1. The next screen will show us available fields on the entity. Each field selected will be evaluated by the model for the fields influence on the end result. By default, all fields will be selected, do not remove any fields. Click Next.
  2. Notice our progress indicator has moved to the next item. Click Train.

  1. Your Binary Classification model will now train. Go to Models.

  1. Locate and open your saved model. If you need help finding it, type your name into the search box.

  1. After each training, AI Builder uses the test data set to evaluate the quality and accuracy of the new model. A summary page for your model shows your model training result, including a Performance score. The score we have is 65% and we should expect it to change over time. And now we can view some details about our trained model. Click on View Details.

  1. Our details report will show the data influencers and how much influence that data has on our prediction model. Close the details.

  1. Publish your model. Once published the data will get scored, and scoring will happen daily for a published model.

About that score

:

Performance score calculations

AI Builder calculates the performance score for your model based on the precision and recall of the prediction results:

Performance score: This is the harmonic mean of precision and recall. It balances both for an imbalanced class distribution. Performance score values are between 0 – 100. Generally, the higher the performance score, the better your model performs.

Precision: The fraction of correct predictions among all the positive predictions.

Recall: The fraction of correct predictions among all true positive cases.

Exercise 2

We will make a small model driven application to view the data. This approach allows us a quick look at the data. You could also make a canvas app that allows users to interact with the data from a mobile device.

  For the purposes of this lab, we have taken some shortcuts in the interest of time. In general, you should always be working in a specific solution, you should rename items with smart names for better team development and more. A full lesson on customization and solution strategy is beyond the scope of these labs. However, Microsoft has many learning choices available. Please ask your instructor if you’d like more information.
  1. In your PowerApps maker portal, from the left side navigation, navigate to Apps and select Create an app and select Model-driven.
  2. If this is your first time connecting to a canvas app in this environment, you might be prompted to choose your region. Select the default.
  3. Give your app a name, remember to include your own name as part of it. Leave all other options as they are and click Done.
  4. You should see something like the image below. 
  5. We will now add our online shopper intention entity to the site map. Click the edit icon on the Site Map.

  1. With focus set on the Area give the area a name such as Online Shopper Intentions. Select and name the Group as well.

  1. With the New Subarea selected select Type of Entity and Online Shopper Intention as the entity. Leave other fields as defaults.

  1. Save your Site Map and go back to the App Designer.
  2. You should now see the assets needed for the Online Shopper Intention entity are included in our model-driven app.
  3. Let’s add a view to our app so we can better see the prediction data. Click on Views and then Create New.

  1. If prompted with unsaved changes, you can dismiss by clicking OK (assuming you’ve followed our steps so far!).

 

  1. Click Column Attributes Primary Entity.
  2. Drag and drop the following fields to the view: revenue-predicted(modelname); revenue-probability(modelname); and revenue.Note:

    You will see fields added for the models of all of the students working in the same environment, look for the ones with your model name in the field name.

  1. Adjust column widths to make them wider and easier to view. With the column selected, increase the width using the options on the right side of the view designer.

  1. Save your view, remember to include your name as part of the view name.

  1. Return to App Designer. Save your app and publish it.

  1. Play your app.

  1. You should now be in your new model-driven app. Select the view you just created.

  1. View the data. You can see the prediction score, and the prediction that follows. With this information you can create automation such as a flow that would trigger based on a customer’s expected revenue and send discount emails to customers likely to complete a purchase. Creating such automation is beyond the scope of this workshop.

 

A “cliff notes version of these direction are also in the docs here: https://docs.microsoft.com/en-us/ai-builder/binary-classification-model-driven-app

  • Sign in to PowerApps, select Apps from the menu, and then select Create an app > Model-driven at the top of the screen.
  • On the Create a New App screen, complete the fields and then select Done.
  • On the App Designer screen, you need to:
    • Create a view of your entity that contains the predicted fields from prediction output.
    • Add the view to the site map.
  • Select Entities on the Components menu, select your entity, and then select Back.
  • Select Save at the top of the screen so that you don’t lose your progress when you create a view, then select Views under Entity view and select Create New on the Components tab.
  • Select Column Attributes – Primary Entity on the Components tab, and then select the fields generated by prediction output.
  • Select Save And Close, give your view a name, and then select the view you just created. Then, select Save again.
  • Select the pencil icon next to Site Map and rename New Group appropriately.
  • Select New Subarea and select Entity as the Type, and then select your entity from the Entity drop-down menu.
  • Select Save And Close and then select Publish.
  • Select Play. Your output should look something like this

Power Platform Training Materials

This week I have had a couple of requests for PowerApps training.

I typically direct these requests to the great page Saurabh put together: PowerApps and Microsoft Flow: Learning Resources

That said of the four pages of content only a subset is dedicated to training and step by step walk throughs.

Hands on Labs:

Step by Step Guides:

Videos:

Samples:

The list above includes some great training content, I do recommend bringing in one of our amazing trainers…end of the day this will save you time!

To get expert help from PowerApps partners please see: https://powerapps.microsoft.com/partners/

PowerApps Training Content:

Older Content Power BI Training Content

(The new owner is on the process of onboarding)

In addition to all the training by the Power BI Partners, the development team works on additional courses that may assist you in your training efforts.  This page was created to serve as a directory for these efforts:

Finished that are updated regularly

Being Created Now:

NEW:  Excel “Better Together” BI training

Announcing soon on, Demos.Microsoft.Com you will find an entire walk through demo of how to use Excel as both the presentation tier and data model in a BI solution.   Additionally this link will take you to an entire day long Excel based BI class delivered internal to Microsoft to show Excel practitioners how they can solve their BI needs with the tool they are already familiar with  -Excel.

*For reference only not for distribution.

Dashboard in a Day

Dashboard in a Day (DIAD) is a 1 Day hands-on workshop for Business Analysts, covering the breadth of Power BI capabilities.

At the end of the day, attendees will better understand how to:

  • Connect to, import, and transform data from a variety of sources
  • Define business rules and KPIs
  • Explore your data with powerful visualization tools
  • Build stunning reports
  • Share your dashboards with your team and/or the world

All DIAD workshop assets; presenter deck, demo scripts, step-by-step student Hands-on-Lab and dataset, plus a train the trainer video on how to execute a successful event, are updated monthly by the Power BI engineering team and are offered for free to all Partners.

The DIAD assets are split into 2 parts:

Instructor content: which includes Presentation decks, Demo Scripts and train the trainer materialcan be downloaded here.


Attendee content: which includes the Lab Manual and datasets, can be downloaded here.

The guidance for using the content is:

  1. Partners cannot make any changes to the dataset.
  2. If partners want to make any changes to the content, then they should brand the event as DIAD.
  3. The person presenting should be very familiar with Power BI and be able to answer any customer questions related to the workshop or Power Bi in general.

We are definitely open to feedback and enhancing the content and would love to hear and take feedback and iterate.

Please send your feedback to diadq@microsoft.com

If you are a customer looking to attend a DIAD, please reach out to your Microsoft representative or check our partner training offers in the Consulting Services Marketplace.

Feel free to print and distribute to students.

Power BI Developer in a Day

Power BI for Developers  Full Day Workshop Level: 300 (Advanced). This course targets developer who want to leverage Power BI in their applications, or want to extend Power BI features with custom visuals. It’s an advanced course where you will learn what Power BI platform has to offer developers including:

• Embedding Power BI content into web applications

• Power BI REST API and using it in custom .NET applications

• Streaming data concepts; pushing data into real-time dashboards.

• Introduction to Custom Visuals; creating new visuals (overview only)

Prerequisites:Familiarity with Power BI content creation (i.e., modeling, report building, publishing to service)Familiarity with .Net, PowerShell and JavaScript basics are highly desirable Power BI Pro account (60 day free trial is sufficient)

Feel free to print and distribute to students.

Administrator in a Day

Need to come up to speed fast on the administration for Power BI? Then this all-day course is for you!

 Advanced Modeling with Power BI

This course will walk through parsing data modeling formulas, using DAX to create calculations, consequences of data model design decisions, concepts of calculated columns and measures, with particular focus on patterns & CALCULATE.

Feel free to print and distribute to students.

Advanced Visualization with Power BI

Gain familiarity with Power BI report layouts and structure the agile process to creating Power BI data visualizations. Understand the art behind visualizations, implications behind choosing the right charts, the impact of color, shape and size, and finally the use of Power BI custom visuals.

Feel free to print and distribute to students.

Advanced Data Shaping with Power BI

At high level this session will cover, using Power BI Desktop to import and shape data from a variety of different sources. Specifically, you will be able to: Understand the Power BI Desktop data model, the components of effective schemas, gain an understanding of the Power Query M language, import data from a variety of sources (including XLS and CSV files), create queries using toolbar navigations and Advanced Editor, understand parameters and finally, organize queries using folders.

Feel free to print and distribute to students.

Getting the Simrad NSS8 to receive AIS and DSC

 

Finally getting my Pursuit back the water and realized that neither Simrad: NX40 nor NSS8 is communicating with my Standard Horizon 2150.

…I know the NX40 has a couple of issues but got the NSS8 working on the other boat.

Then i remembered this was a replacement NSS8…and all my settings would have been lost.   After a quick search i found the very very good Standard Horizon documention (see below) but those were the settings were still on the radio from before i parked the Pursuit.

http://www.standardhorizon.com/downloadFile.cfm?FileID=7527&FileCatID=86&FileName=Wiring%20to%20SIMRAD%20NSE%20%26%20NSS%20to%20GX2150%20%282%29.pdf&FileContentType=application/pdf

SH

After a LOT more searching turns out the Simrad defaults to not transmitting NMEA and that too needs to be turned on…and the settings changed to match the 2150

http://www.simrad-yachting.eu/globalassets/lowrance/manuals/dansk-manual/nmea-0183-til-nss–hds-gen-3-enheder-brugermanual-skandinavisk.pdf

simrad2

Related Posts:

 

https://sterlingsdotlife.wordpress.com/2015/04/27/displaying-a-buddies-boat-on-a-simrad-nss-8-using-standard-horizon-21502200-and-dsc/

https://sterlingsdotlife.wordpress.com/2012/01/16/displaying-dsc-information-with-a-standard-horizon-chartplotter/

https://sterlingsdotlife.wordpress.com/2012/01/16/how-to-wire-your-dsc-vhf-to-a-nmea-0183-chartplotter-so-you-can-remove-them/

https://sterlingsdotlife.wordpress.com/2011/11/28/displaying-ais-data-on-a-simrad-nx40-using-a-standard-horizon-matrix-2150/

 

Microsoft Business Application Summit Power Platform Workshop

 

Hands on workshop walking attendees through integrating PowerApps and Power BI to create a scoreboard application.

Step 1.  Create an app workspace to host the application. 

To do this: Log in to PowerBI.com and click on Workspaces > New Workspace.

For people doing this at Microsoft Business Applications Summit we have created accounts for you to use with the names MBASUser201@Powermvps.com through MBASUser400@Powermvps.com (Yes we have 200 people signed up!!) …I will give out the Pass word at the event.  As I used the name MBAS please name yours MBAS### with the number being your assigned account.

SCOREBOARD1

Step 2.  Navigate to the Workspace content view

SCOREBOARD2

Step 3.  Create a streaming dataset

Click on create and select streaming Dataset

SCOREBOARD3

Step 4.  Set the streaming dataset to be API based.

Click on API and select Next

SCOREBOARD4

Step 5.  Set the streaming dataset properties

Add the fields:

Score > as number

Person > as Text

Contest > as Text

Date > as DataTime

SCOREBOARD5

Step 6.  Create a report displaying the streaming dataset

Select Datasets and then select that chart glyph for the dataset you just created in the above step

SCOREBOARD6

Step 7.  Add a visual to display the score by Person

Drag the Score field to the Power BI report design canvas.  This should default to a clustered Column chart, if not change it one and add the person as the axis.

SCOREBOARD7

Step 8.  Pin the Column Chart to a Scoreboard dashboard.

Click the push pin glyph in the visual you just created and save the report with the name “Scoreboard”

SCOREBOARD8

Step 9.  Create a new Dashboard

Select New dashboard and give the dashboard name “Scoreboard” and click pin.

The reason for using a dashboard rather than a report is the fact that reports are not real time yet. (written 6/3/2019).   Do NOT navigate to the dashboard yet. 

Scoreboard9

Step 10.  Adding a PowerApps to the Power BI Report (using the PowerApps custom visual)

In the Power BI visuals section click the ellipsis select the “Import from marketplace”, search for PowerApps and select the visual “PowerApps (Preview)”.

SCOREBOARD11

Step 11.  Creating the PowerApps application with the Power BI custom visual.

Drag the fields Contest, Person and Score to the PowerApps custom visual.

SCOREBOARD12

Step 12.  Add a Rating control to the PowerApps application

SCOREBOARD14

Step 13.  Add a Button control to the PowerApps application

SCOREBOARD15

Step 14.  Add a Text Input control to the PowerApps application

SCOREBOARD16

Step 15.  Add a Label control to the PowerApps application

SCOREBOARD17

Step 16.  Creating a new Flow and attaching it to the PowerApps button

SCOREBOARD18

Step 17.  Add the Power BI Action to the Flow

SCOREBOARD19

Step 17.  Add the Power BI action to the Flow.

Set the workspace to the workspace you created in step one i.e. MBAS####.

Set the dataset to “Scoreboard” that you created in step #5.

The table will be called “Real Time Data” (this set automatically)

SCOREBOARD20

Step 18.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.

SCOREBOARD21

Step 19.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.   In this image that option has been set and now shows “See Less”

SCOREBOARD22

Step 20.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.   In this image that option has been set and now shows “See Less”

SCOREBOARD23

Step 21.  Set every field to “Ask in PowerApps”

Set every field every field in your dataset to “Ask in PowerApps.  For the first field you will see this option by default.  For subsequent fields you will need to click the “See More” option.   In this image that option has been set and now shows “See Less”

SCOREBOARD24

Step 22.  Save your Flow

Now save your Flow.  While not done in this screen shot it is recommended that you name your Flow by default called “from PowerApps” before saving.

SCOREBOARD25

Step 23.  Connect your button to the Flow

Navigate back to the PowerApps tab and select the Flow you have saved in the step above.  This will add a parameter to the Flow call for every field in the streaming dataset.

SCOREBOARD26

Step 24.  Supply the Flow parameters

Set the score flow parameter for score to value property of the Rating1 control.  Set the person parameter to the TextInput1.Text control property.  Set the contest parameter to the harded coded string “MBAS”.  Set the Date parameter to “Now()”.

SCOREBOARD27

Step 25.  Save the PowerApps application

Under the file menu select “Save”

SCOREBOARD28

Step 26.  Save the PowerApps application (cont)

Name your application and select the “Save” button in the lower right hand corner.

SCOREBOARD29

Step 27.  Pin the PowerApps application to the dashboard to the Power BI Dashboard.

Navigate to the Power BI Tab.  You will notice the application is already visible in the Power BI.  In the upper right hand corner of the Power BI visual select “Pin visual”.

Select the “Scoreboard” dashboard created above.

SCOREBOARD30

Step 28.  Test the PowerApps/Power BI integration .

In the Power BI Dashboard type a persons name and select a score.  Hitting the button should update the column chart created above.

finished

Congratulations you have created a streaming dataset, a PowerApps application and a real time dashboard!

Meet Community stars at Microsoft Business Applications Summit

One of the primary reasons people go to conferences is to meet the presenters.

At the Microsoft Business Applications Summit (MBAS), we have an entire “Ask the Experts” experience to make this easy.

We have created a community lounge and will be scheduling a subset of those community stars for you to interact with. Here are some highlights of the community members and topics you will find at this year’s MBAS.

 

Starting and Running a World Class PowerApps User Group by Keith Whatling

In addition to being a PowerApps MVP and one of the earliest/best PowerApps developers, Keith Whatling also started one of the first (and just recently recognized as one of the best) PowerApps user groups on the planet. Keith will be discussing the tactics that helped him in his community journey.

See the source image

Keith Whatling is an experienced analyst with a demonstrated history of award-winning innovation in transportation. “I have a wealth of experience from digital content creation and data analysis to Microsoft’s Power Platform, using PowerApps and Flow to drive digital transformation. I can hold my own with Python, VBA and have some C# experience.”

 

Collaboratively Organizing One of the Largest Power BI Groups by Prathy Kamasani

Prathy Kamasani helps organize one of the largest Power BI user groups in the world and in this session she will share with the community how she manages this process and continues growing their membership.

See the source image

 

Prathy Kamasani is a Microsoft Valuable Professional (MVP) working as an independent MSBI contractor based in London. She specializes in Power BI, SSIS, SSAS and SSRS. Prathy is active in the Microsoft Data community as a speaker, volunteer, and organizes the London Power BI User Group.

 

Running the Largest Power BI Community Site in the World by Mike Carlo

In addition to co-managing one of the most successful US Power BI user groups, Power BI MVPs Mike Carlo and Seth Bauer also manage to find time to host the largest Power BI community site in the world. Wondering how? Then this session is for you!

See the source image

Mike is a user group leader and frequent conference speaker that is Passionate about data, analytics and helping people learn same has developed a website knowledge repository for all things PowerBI, (www.PowerBI.Tips). This site is uniquely set up for people to read and learn about data modeling and visualizations within Power BI with over 60 kudos to date!

 

How to Leverage the Microsoft Communities Platform and Grow to a Super Community by Seth Bauer

In addition to co-managing one of the most successful US Power BI user groups, Power BI MVPs Seth Bauer and Mike Carlo also manage to find time to host the largest Power BI community site in the world. Additionally, Seth Bauer finds the time to answer many of the Power Service questions in the community forums. Find out how he gets his information.

Bauer_Seth-1

About Seth Bauer

I am a Director of Business Intelligence at Syndigo. I’m a Microsoft Data Platform MVP (Power BI). I’ve been working with the Microsoft stack for over 10 yrs, but my major focus area now is Power BI, and sharing what I’ve learned with the User Community. I am a Microsoft Certified Professional, a co-leader of this Microsoft Power BI User Group, and a PUG Board of Advisors member. I enjoy working with clients across the Midwest implementing BI / Power BI solutions.

How to use Microsoft Forums to Learn DAX by Phil Seamark

Author, conference organizer, User Group leader, MVP Alumni, and now Microsoft employee, Phil Seamark is recognized as one of the foremost DAX experts. He recently confided in a community gathering that most of what he learned in DAX was through his participation in community forums. In this informal get together, discuss with Phil his techniques for leveraging community forums into his incredible resume of experiences.

See the source image

Philip Seamark is an author, Microsoft Data Platform MVP employee of the Power BI CAT Team, and an experienced database and business intelligence (BI) professional with a deep knowledge of the Microsoft B.I. stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. He has 25+ years experience in this field and is an active member of Power BI community. He is a Super User with 1,945 answers and 590 kudos on the community website http://community.powerbi.com

 

The Value of Joining the Dynamics Online Community by Fawad Khan

Strategy and operations leader with 15+ years of experience managing businesses from $10-20M and leading global IT teams of 100+. “I have helped deliver over $5M in cost savings in Service Delivery along with a 5% improvement in Customer/Partner Experience.” Fawad is a Digital and Cloud Computing strategist in today’s world of AI, Machine Learning, IoT and Hybrid Computing.

See the source image

https://www.linkedin.com/in/fawadakhan1/

 

The Magic Around Delivering an Amazing Presentation by Mico Yuk

Based on requests and feedback on her story-telling presentation, Mico has agreed to share with the community her best practices on delivering an amazing presentation.

Mico Yuk (@micoyuk) is the founder of BI Brainz (the leader in enterprise visual storytelling) and the BI Dashboard Formula (BIDF) methodology. She has trained thousands globally on how to use the power of data visualization strategically to enhance the decision-making process. In the last nine years, her company has worked with Fortune 500 companies like Procter & Gamble, Honda, Kimberly-Clark, Royal Dutch Shell, Nestle, Qatargas, Ericsson, and FedEx. She has also authored Data Visualization for Dummies (Wiley 2014).

 

The Art of Creating a Microsoft Flow Presentation by Kent Weare

Kent Weare is an experienced leader who possesses strong technical skills. Passionate about architecture with a specialty in integration, he is recognized by Microsoft as an Integration MVP.

Kent, a graduate of the University of Regina, has 10+ years of IT experience. This experience includes working on projects for Provincial and Federal Governments, a multi-national bank in the United States, Health Care projects in Eastern and Western Canada and he is currently employed by a large Electricity Distribution company in Calgary, Alberta, Canada.

Kent started working with BizTalk in 2004 and has experience with BizTalk Server 2004/2006/2006 R2/2009/2010.

 

How to Use Community to Make the World a Better Place by Shannon Lindsey

Shannon Lindsay of the Informatics Team at the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF) runs the Power BI User Group (PUG) community in Washington, DC. Her associate, Stephanie Bruno, runs the PUG in Pittsburgh, PA. They also run an internal PUG at EGPAF in which they invite all countries to meet (via conference calls) to share resources and ideas and collaborate on projects.

In this session, Lindsay will share her story of how “Community has been the key to our success in relation to the implementation of Power BI (among other technologies) here at EGPAF. In fact, it is because of our relationships with the community that these trainings happened at all! Stephanie heard about the Microsoft MySkills4Afrika program a few years ago from a volunteer at the Data Insights conference in Seattle.”

See the source image

Shannon Lindsey is a data and analytics professional specializing in collection, management, and use of targeted data for program improvement and strategic decision making, solving problems for non-profit and government.

 

What It Takes to Be a PowerApps Flow MVP by Anton Robbins

Discuss with Anton his journey and experiences in becoming a Microsoft PowerApps MVP.

See the source image

Anton Robbins is the CTO of Seisay IT Solutions, a PowerApps and Flow MVP, PowerApps Champion, DC PowerApps User Group Leader and slayer of bow ties. That he has a passion for the Microsoft Power Platform (Flow, Power BI, and PowerApps) communities is an understatement. “It takes a community to elevate technical brethren.” When he is not speaking at an event, he is usually volunteering or organizing events. He has been, in the past and currently is, a speaker at Microsoft conferences and local User Groups. In his spare time, which he rarely has, he likes to roller skate.

Becoming a Community Super User by Gilbert Quevauvilliers

While there are roughly 500 Business Applications MVPs including Power BI, Dynamics, PowerApps, and Flow, there are fewer than 50 community super users who answer the unanswerable questions in the Microsoft forums. Gilbert Quevauvilliers will share his process for getting this knowledge and how to best use the Microsoft forums.

Image result for gilbert quevauvilliers

“Currently, I’m working as a Power BI & Data Analytics Consultant. I have over 10+ years’ experience working with data of any size and any source. By leveraging my skills, I am able to provide insights into customers’ data quickly and efficiently. And this has enabled my customers to gain a better understanding of their business. Which relates to better sales, or significant cost savings.

“I was recently awarded a Microsoft MVP award for Power BI. Power BI, in my opinion, is the logical choice for creating insights, being cost-effective and providing dashboards and reports on Web, Mobile, or in Apps out of the box.

“I have proven competencies in the implementation of data analytic solutions from the ground up, which included developing data warehouses, SSAS Cubes and, most recently, Power BI solutions for customers in various business sectors.

“I have worked within teams, managed teams, as well as worked alone on various successful data analytics projects.

“I have focused on providing Power BI Solutions to customers since the inception of Power BI in July 2015.”

https://www.fourmoo.com

 

Demystifying the MVP Process by Julie Yack

In addition to running a Dynamics User Group conference, Julie Yack is one of the most distinguished of the Dynamic MVPs. In this informal get together, Julie will be happy to field any questions about the MVP program and nomination process.

See the source image

Julie Yack is a Colorado-based Microsoft Dynamics CRM MVP serving clients across the globe, providing training, implementation, analysis and insight for companies wanting to take their service to the next level. Julie’s blog, http://www.julieyack.com addresses pertinent topics of the day, ranging from Dynamics CRM to technology in education to travel to voting rights.

 

Lounge Hosts

This all-star community will be joined by the entire Microsoft community team with members like Charles Sterling, Jon Levesque, Brian Dang, and Purvin Patel.

Jon Levesque

See the source image

Jon Levesque is an entrepreneur and strategist with an expertise in brand engagement, community building and creating winning evangelism strategies. He is a Senior Program Manager on the Microsoft Flow product team focusing on helping Flow evangelize the product and how to use it, helping customers understand the platform and its benefits.

Jon’s background has ranged from project management to customer experience, to support and marketing. He has over 12 years in the industry and has helped lead community and engagement efforts in the low code/no code space since its inception. He has worked with large brands like Microsoft & HTC and smaller, local brands like Forterra NW Inc, as well as musical artists like Jethro Tull & DJ Nano.

As a speaker and educator, Jon has created the first Microsoft Flow EdX Course, The official Guided Learning material for Microsoft Flow and Ehang Drones and also created a series of YouTube videos guiding users on how to transform business process digitally using Microsoft Flow.

Brian Dang

See the source image

Brian Dang now a program manager on the PowerApps team is helping shape the product to make it easier to use and adopt the world of citizen developers. Formerly a third and fourth grade teacher, Brian Dang (known as Mr. Dang by his students) used PowerApps to create several education apps for teaching, managing his classroom, and gamifying the learning experience. In this in-depth interview, Brian shares his experience meeting Bill Gates, how he got started with PowerApps, how students and teachers are using apps in the classroom, and his vision for PowerApps in the education space. Teachers and students are very excited about using apps in the learning process. Not only do the kids get engaged in the subjects they are learning, but they also explore the technology and authoring tools used to create the custom apps, like the spelling and banking apps. His fourth graders even collaborated in teams to create their own apps, such as one with a Harry Potter theme. Since recording this video, Brian has joined the PowerApps team to execute his vision of bringing PowerApps into the classroom and enabling teachers, students and administrators to “not settle for the apps they have, but create the apps they want.”

May 2019 updates for Microsoft PowerApps

For people that can not wait here is a mid-month roll up for all the new features we have shipped in PowerApps for the month of May.  Please note when the month is over i will publish this on the product blog:  https://powerapps.microsoft.com/en-us/blog/

Also To see what was new in April for PowerApps be sure and check out:

April 2019 updates for Microsoft PowerApps

Import Canvas app components from cloud apps

Components just go better!  With this update, you can share components using cloud apps.

https://powerapps.microsoft.com/en-us/blog/import-components-from-cloud-apps/

Provisioning and administration is getting easier

Now you have a single place to manage and visualize the  storage of your organization. Check your organization storage capacity here. Read more here.

https://powerapps.microsoft.com/en-us/blog/provisioning-and-administration-is-getting-easier/

 

Owner, Customer, and Regarding for canvas apps

Common Data Service polymorphic lookups are now available from canvas apps.  You can now:

  • Access, set, and filter on the Owner field of any record.
  • Access and set the Company Name field (a Customer data type) of the Contacts entity.
  • Access and set the Regarding field of activity entities such as Faxes, Phone Calls, Email Messages, etc.
  • Access the list of all Activities for a record.
  • Access the list of Notes for a record.

https://powerapps.microsoft.com/en-us/blog/owner-customer-and-regarding-for-canvas-apps/

 

On-premises data gateway May 2019 update is now available

The On-premises gateway now features monitoring gateway usage and performance. Traditionally, for monitoring performance, gateway admins have had to depend on manually monitoring performance counters through the Windows Performance Monitor tool. This feature is an out of the box feature which includes additional logging regarding queries and system counters along with a Gateway Performance PBI template file to visualize these. This would insights into gateway usage and allow troubleshooting slow performing queries.

https://powerapps.microsoft.com/en-us/blog/on-premises-data-gateway-may-2019-update-is-now-available/

PowerApps Canvas App Accessibility Guidelines

accessibility

This white paper is for the enterprise application developer (maker) responsible for designing, building, testing, deploying, and maintaining PowerApps in a corporate or government environment. This white paper is a collaborative effort of the Microsoft PowerApps team, Microsoft IT, and industry professionals. Adherence to the guidelines and standards in this document will assist developers in making their PowerApps canvas apps accessible to all app users.

https://thriveproduct.blob.core.windows.net/thrivedocs/PowerApps%20Accessibility%20Standards%20and%20Guidelines.pdf

 

Performance enhancements to the PowerApps portal

we have built and are deploying a new UI framework that significantly reduces the number of calls and download size of PowerApps.

https://powerapps.microsoft.com/en-us/blog/the-powerapps-portal-is-now-significantly-faster-to-load/

 

Add new fields while creating your canvas app

While creating apps using the Common Data Service, makers select an entity as the data source and bind it with data controls. This allows them to add fields in the selected data source to a gallery, data table, or form. This is good for fields that are already present in the data source. However, if there is a need to add an additional field, the maker would need to save the app, switch to the entity designer to add the additional field before returning back to the app. This results in unnecessary deviation from their original goal of making an app.

Adding new field in Entity Designer

https://powerapps.microsoft.com/en-us/blog/add-new-fields-while-creating-your-canvas-app/ 

Extend the power of WYSIWYG Model based form authoring to quick create and quick view forms

The new form designer now supports authoring quick create and quick view formsAll the beneficial features of the new form designer such as WYSIWYG preview, enhanced fields pane, quick-access property pane, tree view and more now extend to quick create and quick view form authoring to help enable a rich and productive experience.

Quick create form as it appears to end-users

https://powerapps.microsoft.com/en-us/blog/extend-the-power-of-wysiwyg-form-authoring-to-quick-create-and-quick-view-forms/

 

Announcing general availability of Model based Apps Solution Checker

To deliver on complex business requirements, model-driven app makers often can end up with highly advanced solutions that customize and extend the Common Data Service platform. With advanced implementations comes an increased risk where performance, stability, and reliability issues become introduced, which can negatively impact the user experience. Identifying and understanding how to resolve these issues can be complicated and time consuming. With the solution checker feature, you can perform a rich static analysis check on your solutions against a set of best practice rules and quickly identify these problematic patterns. After the check completes, you receive a detailed report that lists the issues identified, the components and code affected, and links to documentation that describes how to resolve each issue.

Install solution checker

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/use-powerapps-checker 

 

Please note this is a work in progress and I will continue adding new features through out the month.

Also To see what was new in April for PowerApps be sure and check out:

April 2019 updates for Microsoft PowerApps

https://powerapps.microsoft.com/en-us/blog/april-2019-updates-for-microsoft-powerapps/

 

 

Sharing PowerApps at scale made easy

Last week on the April PowerApps community call one of the viewers indicated the process to share their PowerApps application with ~600 users wasn’t as fast as they wanted.

In digging into what they were doing it turns out they were trying to add 600 people directly is the application sharing dialog (Note: PowerApps only supports adding 200 identities at a time).  In addition to being slow this a security anti-pattern as typically you don’t grant people to resources; you grant security groups access to resources and add people to the security groups.

Luckily sharing at scale with PowerApps can be simple!

Here are the steps to make your PowerApps sharing experience a lot easier -and more secure.

Step 1. Create an Active Directory security Group.

You can either do this with PowerShell using the New-ADGroup or manually.   Since you don’t tend to create a lot of security groups; including the manual steps below.   Note while this is done through the Azure portal an Azure subscription is NOT required!

1. Navigate to https://portal.azure.com and select the Azure Active Directory Blade.

AAD

 2. Select Groups

aad3

3. Supply the security group details…and possibly add members.  Likely you will find it easier to add your members with PowerShell as it is something you will find yourself doing all the time….particularly after people find out how fun it is to use PowerApps!

aad4

Step 2. Share your PowerApp with a security group.

Sharing with a security group is just like sharing with a user…i.e. type in the name of the security group created in step 1. and select the access permissions those users should receive.

aad5

3. (Optional) Add members via PowerShell

While you can add security group members directly in the Azure portal, I find it much easier to actually keep track of my members in a dedicated file like CSV – and add them via PowerShell command: Add-ADGroupMember with an example here: 

Using Add-Adgroupmember and CSV Files