“Start Small and Grow Big” with

PowerBI & Azure AS

Rui Romano, Joana Barbosa

▪ @RuiRomano

▪ Data Platform MVP

▪ https://ruiromanoblog.wordpress.com/

▪ @JoanaVBarbosa

“Start Small and Grow Big” step by step• Customer case study• Start w/ simple Power BI model• Evolve to Azure AS• Lots of tools to help in the process…

This session is not:

• Intro to Power BI• Intro to Azure Analysis Services (Chris Webb)• Deep dive

• Analysis Doc vs Prototype

• Data -> Report vs Report -> Data

• Waterfall vs Agile

Azure AS

PBI

Case Study: Contidis

EXCEL Files

Cloud

Power BI

Sales

1st Month

Cloud

SAP HANA

SAP Hana

Sales

Stocks

Purchases

Accounting

EXCEL Files

Excel Files

Sales

Budgets

Accounting

Budgets

Power BI2nd..5th Month

Cloud

Power BI

From SAP Hana

Sales

Stocks

Purchases

Accounting

…

From EXCEL Files

Sales

Budgets

Accounting

Budgets

…

ETL Processes

Azure SQL DB

(DW)

Accounting. HR

Accounting Budgets

6th MonthAzure Analysis Services

EXCEL

• Monthly Newsletter

• New Features

• Usage (from Power BI & Azure AS)

https://customers.microsoft.com/en-us/story/contidis

Near Future

Internal Sources

Data Zone Analytical Zone

Analytics Layer

Corporate Model

Sources

SAPA HANA

POS Data

Excel Files

Office 365

…

…

…

ETL Processes (Metadata driven)

ETL

Pro

cess

es

(Me

tad

ata)

External Sources

…

…

Other

Data Streaming

Data Cleansing

Semantic Model

Self-Service Layer

SemanticModel

Semantic Model

Information Zone

Visualization & Data Exploration

Corporate Reporting

Data Discovery

Dashboards & Scorecards

BI Portal

Self-Service Reports

Power BI

DataWarehouse Layer

Data Warehouse

Data Mart

Data Mart

Data Mart

Data Archive

Encryption

Multiple Sources

Hadoop Cluster

Azure Data Lake + Analytics / HDInsight

Advanced Analytics

Machine LearningAzure ML / WB / ?

IOT Devices

Azure SQL DBAzure SQL DW

Azure ASPolybase

Demos

1. Convert PBI to AS

2. Convert M to SQL

3. Convert PBI Reports

4. Rebind PBI Reports

5. Usage Monitoring

6. Resource Automation

7. Partitioning & Processing

Just like Jimi Hendrix …

We love to get feedback

Please complete the session feedback forms

SQLBits - It's all about the community...

Please visit Community Corner, we are trying this year to get more people to

learn about the SQL Community, equally if you would be happy to visit the

community corner we’d really appreciate it.

Contacts

https://ruiromanoblog.wordpress.com/

@RuiRomano

@JoanaVBarbosa

http://daxstudio.org/

https://github.com/DevScope/powerbi-powershell-modules

https://ruiromanoblog.wordpress.com/2018/02/01/convert-a-power-bi-desktop-report-from-import-to-live-query/

https://github.com/DevScope/azure-powershell-resourcemanager

https://github.com/DevScope/ssas-powershell-modules

Links