Upload File

what you can do with power bi - meetupfiles.meetup.com/10802562/rezarad-powerbi.pdfwhat you can do...

  • Home
  • Documents
  • What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform
28
What You Can Do with Power BI Reza Rad

Upload: others

Post on 05-May-2020

1 views

Category:

Documents


0 download

Report

TRANSCRIPT

Page 1: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

What You Can Do with Power BIReza Rad

Page 2: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

About Reza RadBI Consultant, Trainer

Microsoft Data Platform MVP

Author of SQL Server and BI books

Author of Power BI from Rookie to Rock Star book

Microsoft Certified Trainer

Microsoft Certified Professional

Co-Leader of NZ BI User Group

https://twitter.com/Rad_Reza
https://twitter.com/Rad_Reza
mailto:[email protected]
mailto:[email protected]
http://www.radacad.com/blog
http://www.radacad.com/blog
http://nz.linkedin.com/in/rezarad/
http://nz.linkedin.com/in/rezarad/
Page 3: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Agenda

Power BI Introduction

Power BI Desktop

Power BI Website

Q&A

Custom Visuals

Integration

@Rad_Reza http://www.radacad.com

Page 4: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

@Rad_Reza http://www.radacad.com

Page 5: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power BI

Power Query

Power Pivot

Power View

Power Q&A

@Rad_Reza http://www.radacad.com

Page 6: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power Query: ETLSelf-Service ETL

Functional Language

Online Search

Share Queries

@Rad_Reza http://www.radacad.com

Page 7: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power Pivot: Tabular Model

Tabular Model

Calculated Measures

Hierarchies

DAX

xVelocity In-Memory

@Rad_Reza http://www.radacad.com

Page 8: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power View: Visualization

Dashboards

Reports

Interactive UI

Filters

Scatter with

Play Axis

@Rad_Reza http://www.radacad.com

Page 9: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power Q&A

Ask Questions

Response on

Visualization

Tools

@Rad_Reza http://www.radacad.com

Page 10: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power BI Desktop

@Rad_Reza http://www.radacad.com

Page 11: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

What Is Power BI Desktop

Integration of Three Components‒ Power Query

‒ Power Pivot

‒ Power View

@Rad_Reza http://www.radacad.com

Page 12: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Get Data

@Rad_Reza http://www.radacad.com

Page 13: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Model Data

@Rad_Reza http://www.radacad.com

Page 14: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Visualize Data

@Rad_Reza http://www.radacad.com

Page 15: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power BI Desktop Demo

@Rad_Reza http://www.radacad.com

Page 16: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power BI Website

@Rad_Reza http://www.radacad.com

Page 17: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power BI: Mobile Apps

@Rad_Reza http://www.radacad.com

Page 18: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power BI Website Demo

@Rad_Reza http://www.radacad.com

Page 19: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power Q&A

@Rad_Reza http://www.radacad.com

Page 20: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Ask Questions; Get Response

@Rad_Reza http://www.radacad.com

Page 21: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Custom Visuals

@Rad_Reza http://www.radacad.com

Page 22: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Integration

@Rad_Reza http://www.radacad.com

Page 23: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Cortana

@Rad_Reza http://www.radacad.com

Page 24: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power BI Embedded

Bring the Power Into Your Application

@Rad_Reza http://www.radacad.com

Page 25: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Real-time Dashboards

Restful API

Azure Stream Analytics

PubNub

Page 26: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

References to Study

Power BI from Rookie to Rock star Online Book: FREE

http://www.radacad.com/online-book-power-bi-from-rookie-to-rockstar

Power BI Training, Auckland and Wellington:

Auckland: https://goo.gl/AmaV4R

Discount Code: NZBigDataGroup, Massive $100 discount. Till next Monday.

Wellington: http://goo.gl/zK7vMQ

Power BI Self-Paced Training Course/Videos:

http://learn.radacad.com/course/power-bi-essentials/

@Rad_Reza http://www.radacad.com

http://www.radacad.com/online-book-power-bi-from-rookie-to-rockstar
https://goo.gl/AmaV4R
http://goo.gl/zK7vMQ
http://learn.radacad.com/course/power-bi-essentials/
Page 27: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Power BI Training

Power BI Training, Auckland and Wellington:

Auckland: https://goo.gl/AmaV4R

Discount Code: NZBigDataGroup, Massive $100 discount. Till next Monday.

20th of October

Wellington: http://goo.gl/zK7vMQ

18th of October

https://goo.gl/AmaV4R
http://goo.gl/zK7vMQ
Page 28: What You Can Do with Power BI - Meetupfiles.meetup.com/10802562/RezaRad-PowerBI.pdfWhat You Can Do with Power BI Reza Rad About Reza Rad BI Consultant, Trainer Microsoft Data Platform

Questions?

https://twitter.com/Rad_Reza
mailto:[email protected]
http://www.radacad.com/blog
http://nz.linkedin.com/in/rezarad/

Paolacci Reza Bursi

Prognostic Significance of Fluorine-18 Fluorodeoxyglucose ...Ramin Sadeghi ,1 Sara Harsini,2,3,4 Mohammad Ali Qodsi Rad,5 Vahid Reza Dabbagh,1 and Giorgio Treglia 6,7,8 1Nuclear Medicine

TCC/ODU Articulation Agreement · 256 &-~Hu~~-Anatomyan-d-Physiology . I 142 Physiology I & II S BIOL 251 & II 8 HLT HLT RAD RAD SDV RAD RAD ENG RAD RAD RAD MTH RAD 150 ... not meet

@Rad Reza a.raad.g@gmail · Slowly Changing Dimension 101 SSIS Solution for SCD Inferred Dimension Member 101 SSIS Solution for Inferred Members Master Data Services; To Keep Single

 · Program/Project consultant for Enterprise Wide PMO/ End-user RMO RAD/CMD RAD/HRAD RAD RAD RAD RAD RAD RAD RAD RAD RAD CPCD CPCD CPCD CPCD CPCD CPCD CPCD CPCD CPCD HRAD HRAD HRAD

Error Handling in SSIS Reza Rad SQL Server MVP, Author, DW / BI Architect

@Rad Reza a.raad.g@gmail - download.microsoft.com · @Rad_Reza [email protected] ... Seven Samurai City of God Year Remove Remove Other Columns Use First Row As Headers

Sample work reza

Russell Reza

Master Data Management with SQL Server 2012 - rad.pasfu.com · Reza Rad •DW/BI Architect and Consultant •Microsoft SQL Server MVP •Author SQL Server books •Author of RADACAD

Piroozfar Reza

Come, reza, ama

Ferroelectric Field Effect Transistors · Ferroelectric Field Effect Transistors Reza M. Rad UMBC Based on pages 387-403 of “Nanoelectronics and Information Technology”, Rainer

@Rad Reza a.raad.g@gmail - download.microsoft.comdownload.microsoft.com/documents/hk/technet... · SSIS packages Foreword by Phd MVP— SQL Server PACKT] enterpriseæ ... Goa 42.00

Silicon MOSFETs – Novel materials and alternative concepts · 2008-01-21 · Silicon MOSFETs – Novel materials and alternative concepts Reza M. Rad ... ¾MOS capacitor zFigure

Ivan Cankar Kurent - Cloverleaf-mallje dopolnil dvanajsto leto, je vpra‰ala mati Kurenta, ãe bi rad bil Ïupnik in ‰kof in kaj da bi drugaãe rad bil. Kurent je dol-go pomislil,

Reza Negarestani Cyclonopedia

Dataflow Integration Solution for Power BI Reza... · Dataflow is a Power Query process that runs in the cloud independently from any Power BI reports. Where the Output Stored? Dataflow

A predictive algorithm for multimedia data … PAPER A predictive algorithm for multimedia data compression Reza Moradi Rad • Abdolrahman Attar • Asadollah Shahbahrami Published

PowerPoint Presentationdownload.microsoft.com/documents/hk/technet/techdays2013/Day … · PowerPoint Presentation Author: Reza Rad Subject: Microsoft Tech Days Hong Kong 2013 Keywords:

Reza Badrossama3

Meray Khawab Reza Reza by Maha Malik.urduinpage.com

Danish Reza

Rad-Tolerant/Rad-Hard Integrated Circuits · 2019. 2. 12. · Rad-Tolerant / Rad-Hard Integrated Circuits 3 Rad-Tolerant Concept Microchip’s Rad-Tolerant devices are based on components

Data Preparation with Power BI - Meetupfiles.meetup.com/18180827/Reza Rad_Data Preparation with Power BI.pdfData Preparation with Power BI Reza Rad. About Reza Rad DW/BI Consultant,

BOC-REZA JMO No. 1-2015 Mandatory Electronic Processing of Transshipments of REZA Locators to REZA Zones, And Other Procedures

Azure Data Factory vs SSIS - RADACAD · Azure Data Factory vs SSIS REZA RAD. About Reza Rad DW/BI Consultant, Mentor, Trainer SQL Server MVP Author of SQL Server and BI books Author

Reza Revandy

Reza Rejaie CIS Dept. @ UO1 Prof. Reza Rejaie Computer & Information Science University of Oregon reza Fall 2002 Multimedia

Reza cyanosis

Reza fedayavatan 18.09

Reza Alirezaei , SharePoint MVP /MCTS Development Horizon, Corp. blogs.devhorizon/reza

Power BI; Wonderful Things You Can Do - RADACAD€¦ · About Reza Rad DW/BI Consultant, Mentor, Trainer SQL Server MVP Author of SQL Server and BI books Author of MSBI webcast series

Mohammad Reza Faghani

Reza khairunnisa