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 volunteers with PASS in various capacities, ranging from Program Committee to cleanup at local SQL Saturday events. She is also the chapter leader for the PASS Triad SQL User Group in Greensboro, NC. 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 Why use Power BI Who can use Power BI Flavors of Power BI How of Power BI Dashboards Reports Datasets
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
Why Power BI? To see, in one glance, all the information needed to make decisions To monitor the most-important information about their business 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 Your IT department doesn’t have time to create “pretty” reports You want something quick and EZ
Who Can User Power BI? Based on email address Allowed School Work Not allowed Personal Government/military Telecom/ISP
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: 10 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 onpremises data Collaboration with content packs
Building Blocks of Power BI Dashboards Reports Datasets
Dashboard Parts 1. Navigation Pane 2. Dashboard with tiles 3. Q&A text box 4. Help/Feedback buttons 5. Dashboard Title 6. Office 365 Launcher 7. Power BI Home *Graphic courtesy of MS Power BI site
Dashboards Tiles
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 Files Connect Services Local Web. Trends One. Drive Sales. Force Share. Point – Team Sites Google Analytics Databases Azure SQL Database Azure SQL Data Warehouse SQL Server Analysis Services (Tabular) Content Pack
Demos
Widgets Image Text box Video Web content
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
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
More Information Power BI Blog Melissa Coates Blog Reza Rad Blog Chris Webb Blog
- Slides: 21