Microsoft Power BI Info

This David Papkin page has course info on Microsoft PowerBI

Apps

Publish an app in Power BI

Charts

Scatter charts, bubble charts, and dot plot charts in Power BI (tutorial)

 

Bidirectional cross-filtering for Power BI Desktop whitepaper

Binning and Grouping Data with Power BI

Dax

Apply DAX basics in Power BI Desktop

Data Analysis Expressions (DAX) Reference

 

Power BI and Esri ArcGIS

Filters

Power BI Top 10 Filters

 

Power Query M formula language

Data Profiling in Power BI

Real-time streaming in Power BI

Model relationships in Power BI Desktop

Power BI Report Server

Power BI Security

Labs

1) Make a new folder C:\Labfiles using

File Explorer or

From Powershell or Cmd prompt

Md C:\Labfiles (command line)

3) Download and extract into C:\Labfiles

DA-100 labs

4 ) Download and install Visual Studio Code  Visual Studio Code. This is used to view the labs.

Q & A

Q

What are some information display types that is useful for BI?

A

  • Charts – Bar and column, Line and area, Line and column,Ribbon,Scatter and bubble, Funnel, Gauge
  • Maps – Map Chart, Filled Map Chart, Tree Maps
  • Tables

Q

What are some business factors to help decide which information display types?

A

organizational standards, stakeholder requirements, regulatory standards, compliance standards

Q

Why would you put a QR code in a report?

A

When a report is shown, the QR code can display the tiles in greater detail

If a dashboard shows some metrics, you can scan the QR code with your phone.

Q

What application can be used to display BI reports on an iOS device , such as a tablet?

A

Power BI for iOS

Q

What if a organization requires that an iOS tablet be used for reporting?

A

iOS 9 or later is a requirement for the iOS device.

End of David Papkin Microsoft Power BI page

Helpful learning links

Learn Power BI

Use DAX in Power BI Desktop

Microsoft Learn – https://docs.microsoft.com/en-us/learn – Learn new skills and discover the power of Microsoft products with step-by-step guidance. Start your journey today by exploring our learning paths and modules.

Microsoft Azure Forums  The Azure forums are very active. You can search the threads for a
specific area of interest. You can also browse categories like Azure Storage, Pricing
and Billing, Azure Virtual Machines, and Azure Migrate.

Azure Architecture Center  Gain access to the Azure Application Architecture Guide,
Azure Reference Architectures, and the Cloud Design Patterns.

Microsoft Learning Community Blog  Get the latest information the certification
tests and exam study groups.

https://channel9.msdn.com/  Channel 9 provides a wealth of informational videos, shows, and
events.

Azure Tuesdays With Corey  Corey Sanders answers your questions about
Microsoft Azure – Virtual Machines, Web Sites, Mobile Services, Dev/Test etc.

Azure Fridays  Join Scott Hanselman as he engages one-on-one with the engineers
who build the services that power Microsoft Azure as they demo capabilities,
answer Scott’s questions, and share their insights.

Microsoft Azure Blog  Keep current on what’s happening in Azure, including what’s
now in preview, generally available, news & updates, and more.

A collection of Azure Exam Resources

End of David Papkin Microsoft Azure page.

http://davidpapkin.org/

David Papkin favorite movies

Robert Deniro in GoodFellas