Transcript balanced data distributor

Less known component in SSIS
and cool features of Power BI
This presentation is a walk through Balanced
Data Distributor Component and new features
in Power BI
Sponsors
Gold sponsors:
Silver sponsors:
Bronze sponsors:
About me …
Ivan Miliovsky is a Senior IT Consultant
working in Adastra Bulgaria with over 7 years
of experience in various project in Telco and
Software Development sector
 Business Intelligence
 ETL processes
 Data Quality
 Performance and tuning
 Database Administration
3 |
Agenda of …
 Balanced Data Distributor
• What is …
• How to …
• When to …
• Drawbacks of …
• Bottleneck in …
• Alternatives as …
 Demo
4 |
BALANCED DATA DISTRIBUTOR
What is …
 Multithreading dataflow transform tool
 Advantage of modern CPUs
 Integrated in SQL Server 2016
How it …
 Parallelism
 1 Input = Multiple outputs/separated threads
 Each thread ~ 1 input / number of outputs
Each thread ~ 1 input / number of outputs
When to …
 Large amount of data
 Fast reading of data
 Target support parallelism
Drawbacks of …
 Copy of integration components
 Targets without parallelism support
 Small amount of data
Workaround of …
Bottleneck in …
 Source
 Transformation
 Target
Alternatives as…
 Conditional Split
 Script Component
 Straight insert
ATTENTION!
HOUSTON
WE
HAVE
A
DEMO!
About
Stefan Damyanov is a Line Manager and Senior IT
Consultant working in Adastra Bulgaria with over 13
years of experience in various projects in the Banking
and IT sectors.
 Business analysis
 Business Intelligence
 ETL processes
 Microsoft, IBM, Oracle and SAP BI tools
 Performance and tuning
15 |
Agenda of Power BI







Long way to Microsoft Power BI
Architecture
Power BI Desktop (Demo)
Power BI Web (Demo)
Power BI Mobile (Demo)
How we use it?
Q&A
Long way to Microsoft Power BI









1987 – Excel
1991 – Cristal reports
1992 – MS Access
1993 – R Programing Language
1998 – SQL Server 7 OLAP cubes (MDX)
2000 – Analysis Services cubes + Data mining
2001 – .Net – Andres Hejlsberg
2004 – SRS 2005 (.RDL)
2007 – PerformancePoint Server 2007
 Revolution Analytics (R)
Long way to Microsoft Power BI
 2010 – PerformancePoint Server for SharePoint 2010
 2010 – Power Pivot (Excel, tabular, DAX)
 2012 – SQL Server 2012 Analysis Services (tabular)
 Power View (web - Silverlight) for SharePoint Enterprise
 Integrated Mode for SQL R2
 2013 – Power Query (Excel)
 Power Pivot
 Power Map
 Office365 Q&A (natural language)
 2015 – PowerBI.com (.PBIX) – 2800 people working
in this project
Architecture
Power BI Desktop
We are on the start, do you have a ticket?
Power BI Web
Power BI Mobile
 Mobile devices
How we use it?
Q&A
Sponsors
Gold sponsors:
Silver sponsors:
Bronze sponsors: