What is Power BI Angela Henry Angela is

What is Power BI?

Angela Henry Angela is a DBA/BI Developer, living in High Point, NC and loves what she does. She's worked with all versions of SQL Server & worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She earned her MSCE: Business Intelligence in 2015. She is also the local group leader for the PASS Triad SQL User Group in Greensboro, NC. Tweets at @SQLSwimmer Blogs at SQLSwimmer. wordpress. com In her spare time you can probably find her in the pool, she's an avid US Masters swimmer.

Overview The What/Who/Why/Flavors What is Power BI How of Power BI Dashboards Why use Power BI Reports Who can use Power BI Datasets Flavors of Power BI Gateway Integration with Reporting Services (SSRS)

What is Power BI? Power BI is an amazing business analytics service that enables anyone to visualize and analyze data. Microsoft Power BI is a collection of online services and features that enables you to find and visualize data, share discoveries, and collaborate in intuitive new ways. Flavors of Power BI Free Power BI Pro

Who Can User Power BI? Based on email address Allowed Not allowed School Personal Work Government/military Telecom/ISP

Why Power BI? Visualize, Visualize!! To ensure all colleagues are on the same page, viewing and using the same information You don’t have a full time report writer at your company You want something quick and EZ

Flavors of Power BI Free Pro Data refresh frequency: Daily Data refresh frequency: Hourly Data capacity Limit: 1 GB/user Data Capacity Limit: 10 GB/user Streaming rate: 10 K rows/hour Streaming rate: 1 M rows/hour Data sources are limited to content packs for services and importing files Data Sources include free ones plus direct query dataset and on-premises data Collaboration with content packs, Office 365 Groups Manage access & sharing via AD

Building Blocks of Power BI Dashboards Reports Datasets

Dashboards Tiles

Dashboard Parts 1. Navigation bar 2. Dashboard with tiles 3. Q&A question box 4. Help/Feedback buttons 5. Dashboard Title 6. Office 365 Launcher 7. Power BI Home 8. Additional Dashboard Actions *Graphic courtesy of MS Power BI site

Demo

Reports Create from scratch within Power BI Create from scratch in Power BI Desktop Import from shared dashboards Created for you when you connect to datasets from Excel, Power BI Desktop, databases, and Saa. S applications and content packs Can be associated with more than one dashboard

Demo

Datasets Import Connect Services Files Local Web. Trends One. Drive Sales. Force Share. Point Sites – Team Google Analytics Databases Azure SQL Database Azure SQL Data Warehouse SQL Server Analysis Services (Tabular) Content Pack

Demos

Special Tiles Image Text box Video Web content Real-Time Data (Pro)

Demo

Q & A Question Box Allows you to ask questions about your data in natural language Comes with common synonyms and phrasings Aggregations (less than, maximum, number of, …) Date keywords and ranges (last month, this year, before, after, …) Plurals (opportunity & opportunities) Display verbs (show, is, what is, are, what are) Create your own synonyms and phrasings

Demo

Gateway for On-Premises Data On-Premises data gateway (pro) Personal Gateway

Integration with Reporting Services (SSRS) Pin SSRS visuals to Power BI Dashboards Does NOT require Pro version!

Resources https: //powerbi. microsoft. com/en-us/documentation/powerbi-service-getstarted/ https: //powerbi. microsoft. com/en-us/documentation/powerbi-videos/ https: //powerbi. microsoft. com/en-us/documentation/powerbi-webinars/ https: //technet. microsoft. com/library/mt 282164. aspx http: //www. sqlchick. com/s/Power. BIEnd. To. End. Features_Melissa. Coates. pdf https: //powerbi. microsoft. com/en-us/documentation/powerbi-gatewayonprem/

More Information Power BI Blog Melissa Coates Blog Reza Rad Blog Chris Webb Blog Adam Saxton Video Blog