際際滷

際際滷Share a Scribd company logo

Real-Time Graph Analytics in Power BI.pdf

J
Jerod Johnson

A special presentation with two leaders in the data ecosystem from Microsoft Power BI and TigerGraph: Geoff Fawcett, Principal Technical Specialist, Business Intelligence, Microsoft Victor Lee, Director of Product Marketing, TigerGraph Live: https://www.cdata.com/resources/graph-analytics-tigergraph-microsoft/ TigerGraph is a leading graph database, using data relationships to unlock value through advanced analytics. Graph data has long been popular for entity resolution, fraud detection, and customer 360, and more recently for training AI models. But due to their unique format, graphs arent natively compatible with analytics platforms that require SQL standard data. CData and TigerGraph have a solution for this challenge, and we are pleased to demonstrate graph analytics in Microsoft Power BI, a leading data analytics, reporting, and visualization platform.

1 of 19
Download to read offline
The real-time data connectivity company.
Real-Time Graph Analytics in Power BI
3 Introducing CData Introducing TigerGraph Why CData & TigerGraph Introducing Power BI Demo Q & A Agenda
4 Based in Chapel Hill, NC, with offices in Europe, Japan, and India, CData is the leader in real-time data connectivity software for enterprises, developers, and data scientists. 息 2023 CData Software Inc. CONFIDENTIAL DO NOT DUPLICATE OR DISTRIBUTE CData Software EMPLOYEES 400+ ACTIVE CUSTOMERS 10,000+ OEM PARTNERS 180+
Introducing TigerGraph
息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM TigerGraph is a scalable, high-performance graph data platform for Advanced Analytics and Machine Learning On the cloud or on premises Customers include the largest companies in financial services, healthcare, telecom, media, utilities and innovative startups in cybersecurity, ecommerce and retail Who is TigerGraph? 6
息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM Graphs make sense of the relationships in your data 7 Name Address Alice Richmond Bob Richmond Name Account ACME Business Bob Savings Name Directorship Alice ACME Carlos ACME Richmond Bob Alice Carlos Savings ACME Business Pre-learn the relationships into your data so tracing between entities is easy and quick Have to re-learn the relationships in your data every time you use it Conventional databases Graph databases
息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM | Tables vs Graph: Connections Matter! 8 Name Latitude Longitude Line Acton Town 51.5025 -0.278126 District, Piccadilly Aldgate 51.51394 -0.07537 Metropolitan Aldgate East 51.51514 -0.07178 District, Hammersmith & City Alperton 51.54097 -0.30061 Piccadilly Amersham 51.67435 -0.60732 Metropolitan Angel 51.53253 -0.10579 Northern Archway 51.56536 -0.13474 Northern Arnos Grove 51.61625 -0.13355 Piccadilly Arsenal 51.55847 -0.10561 Piccadilly Baker Street 51.52265 -0.15704 Circle, Hammersmith & City, Bakerloo, Jubilee Balham 51.44344 -0.152945 Northern Bank 51.51340 -0.089058 Central, Waterloo & City Barbican 51.52086 -0.097758 Circle, Hammersmith & City, Metropolitan Barking 51.54079 0.08018 District, Hammersmith & City Barkingside 51.58543 0.08854 Central Barons Court 51.49028 -0.21434 Piccadilly, District Battersea Power S 51.4795 -0.142 Northern London Underground Stations
息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM | Real-World Outcomes from Graph Data Science Healthcare: Real-time recommendations Connect patients, symptoms, treatment, drugs, providers Real-time care recommendations Improving healthcare, lowering cost Industrial Supply Chain: Analytics for decisions Connect components, providers, assembly, transit, costs Analytics: weeks minutes Reveal opportunities, optimize tactical & strategic decisions Financial Services: Real-time fraud detection Connect parties, accounts, transactions, known fraud Integrates multiple tools Real-time visual results for investigators 9 Each use case saved the customer $10s millions
息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM | Analytics/Insight from Graph Algorithms 10 Similarity Find vertices with similar surroundings Uses Recommendation Classification Clustering Partition/Group vertices based on connections Uses Target groups by social, business, process interactions Centrality Find most central or "important" vertex Uses Pick best locations Identify critical entities Shortest Path Find the best path/tree from A to B Uses Route/coverage optimization Process optimization Classification Tag similar vertices with the same class Uses Fraud detection Market segmentation
息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM | 11 ML Test, Train, Predict Data Features Model Output Conventional feature engineering pipeline Graph feature engineering 20%+ Uplift in Accuracy Structure as a graph Graph features boost ML performance Combine Features
TigerGraph + CData + Power BI
Business Analysts Data Engineering & Data Science Everyday End Users Low-Code/No-Code Developers Collaboration Data skills & tools Advanced Intermediate Basic
Real-Time Graph Analytics in Power BI.pdf
Visualization
Extend with Azure ML Integrate into reports Python Integration R Integration Create ML models Explore predictions Sentiment Analysis Key Phrase Extraction AI Visualizations Natural Language Advanced Analysis & AI
Demo: Visualizing TigerGraph in Power BI U s e C as e: A n a lyz i n g th e Sa l e s Pi p e l i n e
Q & A
19 Get CData Connectors for free: cdata.com/drivers/tigergraph Get TigerGraph Cloud for free: tgcloud.io Get Power BI for free: powerbi.microsoft.com Next Steps

More Related Content

Real-Time Graph Analytics in Power BI.pdf

  • 1. The real-time data connectivity company.
  • 3. 3 Introducing CData Introducing TigerGraph Why CData & TigerGraph Introducing Power BI Demo Q & A Agenda
  • 4. 4 Based in Chapel Hill, NC, with offices in Europe, Japan, and India, CData is the leader in real-time data connectivity software for enterprises, developers, and data scientists. 息 2023 CData Software Inc. CONFIDENTIAL DO NOT DUPLICATE OR DISTRIBUTE CData Software EMPLOYEES 400+ ACTIVE CUSTOMERS 10,000+ OEM PARTNERS 180+
  • 6. 息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM TigerGraph is a scalable, high-performance graph data platform for Advanced Analytics and Machine Learning On the cloud or on premises Customers include the largest companies in financial services, healthcare, telecom, media, utilities and innovative startups in cybersecurity, ecommerce and retail Who is TigerGraph? 6
  • 7. 息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM Graphs make sense of the relationships in your data 7 Name Address Alice Richmond Bob Richmond Name Account ACME Business Bob Savings Name Directorship Alice ACME Carlos ACME Richmond Bob Alice Carlos Savings ACME Business Pre-learn the relationships into your data so tracing between entities is easy and quick Have to re-learn the relationships in your data every time you use it Conventional databases Graph databases
  • 8. 息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM | Tables vs Graph: Connections Matter! 8 Name Latitude Longitude Line Acton Town 51.5025 -0.278126 District, Piccadilly Aldgate 51.51394 -0.07537 Metropolitan Aldgate East 51.51514 -0.07178 District, Hammersmith & City Alperton 51.54097 -0.30061 Piccadilly Amersham 51.67435 -0.60732 Metropolitan Angel 51.53253 -0.10579 Northern Archway 51.56536 -0.13474 Northern Arnos Grove 51.61625 -0.13355 Piccadilly Arsenal 51.55847 -0.10561 Piccadilly Baker Street 51.52265 -0.15704 Circle, Hammersmith & City, Bakerloo, Jubilee Balham 51.44344 -0.152945 Northern Bank 51.51340 -0.089058 Central, Waterloo & City Barbican 51.52086 -0.097758 Circle, Hammersmith & City, Metropolitan Barking 51.54079 0.08018 District, Hammersmith & City Barkingside 51.58543 0.08854 Central Barons Court 51.49028 -0.21434 Piccadilly, District Battersea Power S 51.4795 -0.142 Northern London Underground Stations
  • 9. 息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM | Real-World Outcomes from Graph Data Science Healthcare: Real-time recommendations Connect patients, symptoms, treatment, drugs, providers Real-time care recommendations Improving healthcare, lowering cost Industrial Supply Chain: Analytics for decisions Connect components, providers, assembly, transit, costs Analytics: weeks minutes Reveal opportunities, optimize tactical & strategic decisions Financial Services: Real-time fraud detection Connect parties, accounts, transactions, known fraud Integrates multiple tools Real-time visual results for investigators 9 Each use case saved the customer $10s millions
  • 10. 息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM | Analytics/Insight from Graph Algorithms 10 Similarity Find vertices with similar surroundings Uses Recommendation Classification Clustering Partition/Group vertices based on connections Uses Target groups by social, business, process interactions Centrality Find most central or "important" vertex Uses Pick best locations Identify critical entities Shortest Path Find the best path/tree from A to B Uses Route/coverage optimization Process optimization Classification Tag similar vertices with the same class Uses Fraud detection Market segmentation
  • 11. 息 2023. ALL RIGHTS RESERVED. | TIGERGRAPH.COM | 11 ML Test, Train, Predict Data Features Model Output Conventional feature engineering pipeline Graph feature engineering 20%+ Uplift in Accuracy Structure as a graph Graph features boost ML performance Combine Features
  • 12. TigerGraph + CData + Power BI
  • 13. Business Analysts Data Engineering & Data Science Everyday End Users Low-Code/No-Code Developers Collaboration Data skills & tools Advanced Intermediate Basic
  • 16. Extend with Azure ML Integrate into reports Python Integration R Integration Create ML models Explore predictions Sentiment Analysis Key Phrase Extraction AI Visualizations Natural Language Advanced Analysis & AI
  • 17. Demo: Visualizing TigerGraph in Power BI U s e C as e: A n a lyz i n g th e Sa l e s Pi p e l i n e
  • 18. Q & A
  • 19. 19 Get CData Connectors for free: cdata.com/drivers/tigergraph Get TigerGraph Cloud for free: tgcloud.io Get Power BI for free: powerbi.microsoft.com Next Steps