Consolidate data to one source with Azure SQL Managed Instance | Komatsu

Published 05-04-2021 12:54 PM 1,077 Views
Contributor

Modernize your existing data at scale, and solve for operational efficiency with Azure SQL Managed Instance. Azure SQL MI is an intelligent, scalable, cloud database service and fully managed SQL server.

 

Screen Shot 2021-05-04 at 2.16.51 PM.png

 

Nipun Sharma, lead data architect, joins Jeremy Chapman to share how the Australian subsidiary of large equipment manufacturer, Komatsu, built a scalable and proactive sales and inventory management and customer servicing model on top of Azure SQL Managed Instance to consolidate their legacy data estate on-premises. See what they did to expand their operational visibility and time to insights, including self-service reporting through integration with Power BI.

 

 

QUICK LINKS:

 

 

Unfamiliar with Microsoft Mechanics?

 

Keep getting this insider knowledge, join us on social:

Video Transcript:

 

 
%3CLINGO-SUB%20id%3D%22lingo-sub-2323452%22%20slang%3D%22en-US%22%3EConsolidate%20data%20to%20one%20source%20with%20Azure%20SQL%20Managed%20Instance%20%7C%20Komatsu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2323452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EModernize%20your%20existing%20data%20at%20scale%2C%20and%20solve%20for%20operational%20efficiency%20with%20Azure%20SQL%20Managed%20Instance.%20Azure%20SQL%20MI%20is%20an%20intelligent%2C%20scalable%2C%20cloud%20database%20service%20and%20fully%20managed%20SQL%20server.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-05-04%20at%202.16.51%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278002iB0AAD4D9A081CB02%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-05-04%20at%202.16.51%20PM.png%22%20alt%3D%22Screen%20Shot%202021-05-04%20at%202.16.51%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ENipun%20Sharma%2C%20lead%20data%20architect%2C%20joins%26nbsp%3B%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Ftwitter.com%2Fdeployjeremy%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3EJeremy%20Chapman%3C%2FA%3E%26nbsp%3Bto%20share%20how%20the%20Australian%20subsidiary%20of%20large%20equipment%20manufacturer%2C%20Komatsu%2C%20built%20a%20scalable%20and%20proactive%20sales%20and%20inventory%20management%20and%20customer%20servicing%20model%20on%20top%20of%20Azure%20SQL%20Managed%20Instance%20to%20consolidate%20their%20legacy%20data%20estate%20on-premises.%20See%20what%20they%20did%20to%20expand%20their%20operational%20visibility%20and%20time%20to%20insights%2C%20including%20self-service%20reporting%20through%20integration%20with%20Power%20BI.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252FfnLwBz1Cegk%253Ffeature%253Doembed%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DfnLwBz1Cegk%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252FfnLwBz1Cegk%252Fhqdefault.jpg%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22600%22%20height%3D%22337%22%20scrolling%3D%22no%22%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CARTICLE%3E%0A%3CDIV%3E%0A%3CSECTION%20class%3D%22dp%20gn%20go%20dk%20gp%22%3E%0A%3CDIV%20class%3D%22n%20p%22%3E%0A%3CDIV%20class%3D%22ap%20aq%20ar%20as%20at%20gq%20av%20w%22%3E%0A%3CH2%20id%3D%22622c%22%20class%3D%22ln%20in%20gs%20ba%20io%20lo%20lp%20lq%20is%20lr%20ls%20lt%20iw%20lu%20lv%20lw%20ja%20lx%20ly%20lz%20je%20ma%20mb%20mc%20ji%20md%20ho%22%20data-selectable-paragraph%3D%22%22%20id%3D%22toc-hId--469763985%22%20id%3D%22toc-hId--469763985%22%3EQUICK%20LINKS%3A%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20jo%20ir%20jp%20jq%20jr%20iv%20js%20jt%20ju%20jv%20jw%20jx%20jy%20jz%20ka%20kb%20kc%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfnLwBz1Cegk%26amp%3Bt%3D30s%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3E00%3CSPAN%3E%3A%3C%2FSPAN%3E30%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%80%94%20Komatsu%E2%80%99s%20background%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfnLwBz1Cegk%26amp%3Bt%3D208s%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3E03%3A28%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%80%94%20Komatsu%E2%80%99s%20modernization%20path%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfnLwBz1Cegk%26amp%3Bt%3D252s%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3E04%3A12%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%80%94%20Consolidating%20data%20to%20one%20source%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfnLwBz1Cegk%26amp%3Bt%3D350s%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3E05%3A50%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%80%94%20Data%20migration%20and%20consolidation%20of%203%20core%20systems%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfnLwBz1Cegk%26amp%3Bt%3D500s%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3E08%3A20%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%80%94%20Example%20reports%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfnLwBz1Cegk%26amp%3Bt%3D589s%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3E09%3A49%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FA%3E%E2%80%94%20Self-service%20reporting%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfnLwBz1Cegk%26amp%3Bt%3D677s%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3E11%3A17%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FA%3E%E2%80%94%20Built-in%20auto%20tuning%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfnLwBz1Cegk%26amp%3Bt%3D765s%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3E12%3A45%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%80%94%20What%E2%80%99s%20next%20for%20Komatsu%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfnLwBz1Cegk%26amp%3Bt%3D825s%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3E13%3A45%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%80%94%20Wrap%20up%3C%2FP%3E%0A%3CH2%20class%3D%22ln%20in%20gs%20ba%20io%20lo%20lp%20lq%20is%20lr%20ls%20lt%20iw%20lu%20lv%20lw%20ja%20lx%20ly%20lz%20je%20ma%20mb%20mc%20ji%20md%20ho%22%20data-selectable-paragraph%3D%22%22%20id%3D%22toc-hId-2017748848%22%20id%3D%22toc-hId-2017748848%22%3E%26nbsp%3B%3C%2FH2%3E%0A%3CH2%20id%3D%22742c%22%20class%3D%22ln%20in%20gs%20ba%20io%20lo%20lp%20lq%20is%20lr%20ls%20lt%20iw%20lu%20lv%20lw%20ja%20lx%20ly%20lz%20je%20ma%20mb%20mc%20ji%20md%20ho%22%20data-selectable-paragraph%3D%22%22%20id%3D%22toc-hId-210294385%22%20id%3D%22toc-hId-210294385%22%3EUnfamiliar%20with%20Microsoft%20Mechanics%3F%3C%2FH2%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20jo%20ir%20jp%20jq%20jr%20iv%20js%20jt%20ju%20jv%20jw%20jx%20jy%20jz%20ka%20kb%20kc%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3EWe%20are%20Microsoft%E2%80%99s%20official%20video%20series%20for%20IT.%20You%20can%20watch%20and%20share%20valuable%20content%20and%20demos%20of%20current%20and%20upcoming%20tech%20from%20the%20people%20who%20build%20it%20at%20Microsoft.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20jo%20ir%20jp%20jq%20jr%20iv%20js%20jt%20ju%20jv%20jw%20jx%20jy%20jz%20ka%20kb%20kc%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%20class%3D%22%22%3E%0A%3CLI%20id%3D%22d85d%22%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20me%20mf%20mg%20ho%22%20data-selectable-paragraph%3D%22%22%3ESubscribe%20to%20our%20YouTube%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fc%2FMicrosoftMechanicsSeries%3Fsub_confirmation%3D1%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fc%2FMicrosoftMechanicsSeries%3Fsub_confirmation%3D1%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%20id%3D%223eb9%22%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20mh%20ir%20jp%20jq%20mi%20iv%20js%20jt%20mj%20jv%20jw%20jx%20mk%20jz%20ka%20kb%20ml%20kd%20ke%20kf%20me%20mf%20mg%20ho%22%20data-selectable-paragraph%3D%22%22%3EJoin%20us%20on%20the%20Microsoft%20Tech%20Community%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-mechanics-blog%2Fbg-p%2FMicrosoftMechanicsBlog%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-mechanics-blog%2Fbg-p%2FMicrosoftMechanicsBlog%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%20id%3D%221f2b%22%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20mh%20ir%20jp%20jq%20mi%20iv%20js%20jt%20mj%20jv%20jw%20jx%20mk%20jz%20ka%20kb%20ml%20kd%20ke%20kf%20me%20mf%20mg%20ho%22%20data-selectable-paragraph%3D%22%22%3EWatch%20or%20listen%20via%20podcast%20here%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fmicrosoftmechanics.libsyn.com%2Fwebsite%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fmicrosoftmechanics.libsyn.com%2Fwebsite%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CH2%20class%3D%22ln%20in%20gs%20ba%20io%20lo%20lp%20lq%20is%20lr%20ls%20lt%20iw%20lu%20lv%20lw%20ja%20lx%20ly%20lz%20je%20ma%20mb%20mc%20ji%20md%20ho%22%20data-selectable-paragraph%3D%22%22%20id%3D%22toc-hId--1597160078%22%20id%3D%22toc-hId--1597160078%22%3E%26nbsp%3B%3C%2FH2%3E%0A%3CH2%20id%3D%223990%22%20class%3D%22ln%20in%20gs%20ba%20io%20lo%20lp%20lq%20is%20lr%20ls%20lt%20iw%20lu%20lv%20lw%20ja%20lx%20ly%20lz%20je%20ma%20mb%20mc%20ji%20md%20ho%22%20data-selectable-paragraph%3D%22%22%20id%3D%22toc-hId-890352755%22%20id%3D%22toc-hId-890352755%22%3EKeep%20getting%20this%20insider%20knowledge%2C%20join%20us%20on%20social%3A%3C%2FH2%3E%0A%3CUL%20class%3D%22%22%3E%0A%3CLI%20id%3D%227d76%22%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20jo%20ir%20jp%20jq%20jr%20iv%20js%20jt%20ju%20jv%20jw%20jx%20jy%20jz%20ka%20kb%20kc%20kd%20ke%20kf%20me%20mf%20mg%20ho%22%20data-selectable-paragraph%3D%22%22%3EFollow%20us%20on%20Twitter%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Ftwitter.com%2FMSFTMechanics%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftwitter.com%2FMSFTMechanics%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%20id%3D%225d7a%22%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20mh%20ir%20jp%20jq%20mi%20iv%20js%20jt%20mj%20jv%20jw%20jx%20mk%20jz%20ka%20kb%20ml%20kd%20ke%20kf%20me%20mf%20mg%20ho%22%20data-selectable-paragraph%3D%22%22%3EFollow%20us%20on%20LinkedIn%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fmicrosoft-mechanics%2F%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fmicrosoft-mechanics%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%20id%3D%22e075%22%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20mh%20ir%20jp%20jq%20mi%20iv%20js%20jt%20mj%20jv%20jw%20jx%20mk%20jz%20ka%20kb%20ml%20kd%20ke%20kf%20me%20mf%20mg%20ho%22%20data-selectable-paragraph%3D%22%22%3EFollow%20us%20on%20Facebook%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20class%3D%22bv%20ll%22%20href%3D%22https%3A%2F%2Ffacebook.com%2Fmicrosoftmechanics%2F%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ffacebook.com%2Fmicrosoftmechanics%2F%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FSECTION%3E%0A%3CDIV%20class%3D%22n%20p%20cz%20mm%20mn%20mo%22%20role%3D%22separator%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CSECTION%20class%3D%22dp%20gn%20go%20dk%20gp%22%3E%0A%3CDIV%20class%3D%22n%20p%22%3E%0A%3CDIV%20class%3D%22ap%20aq%20ar%20as%20at%20gq%20av%20w%22%3E%0A%3CH2%20id%3D%22cf6d%22%20class%3D%22ln%20in%20gs%20ba%20io%20lo%20lp%20lq%20is%20lr%20ls%20lt%20iw%20lu%20lv%20lw%20ja%20lx%20ly%20lz%20je%20ma%20mb%20mc%20ji%20md%20ho%22%20data-selectable-paragraph%3D%22%22%20id%3D%22toc-hId--917101708%22%20id%3D%22toc-hId--917101708%22%3EVideo%20Transcript%3A%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20jo%20ir%20jp%20jq%20jr%20iv%20js%20jt%20ju%20jv%20jw%20jx%20jy%20jz%20ka%20kb%20kc%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Up%20next%2C%20we%E2%80%99re%20joined%20by%20Lead%20Data%20Architect%20Nipun%20Sharma%2C%20to%20learn%20how%20the%20Australian%20subsidiary%20of%20large%20equipment%20manufacturer%2C%20Komatsu%2C%20built%20its%20scalable%20and%20proactive%20sales%20and%20inventory%20management%20and%20customer%20servicing%20model%20on%20top%20of%20Azure%20SQL%20Managed%20Instance%20to%20consolidate%20their%20legacy%20data%20estate%20on%20premises%20and%20drive%20more%20self-service%20reporting%20with%20Power%20BI.%20So%20Nipun%2C%20welcome%20to%20Microsoft%20Mechanics.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20jo%20ir%20jp%20jq%20jr%20iv%20js%20jt%20ju%20jv%20jw%20jx%20jy%20jz%20ka%20kb%20kc%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Thanks%20for%20having%20me%20here.%20It%E2%80%99s%20a%20pleasure%20to%20be%20on%20the%20show.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20And%20thanks%20so%20much%20for%20joining%20us%20all%20the%20way%20from%20Australia%20today.%20So%20before%20we%20get%20into%20this%2C%20if%20you%E2%80%99re%20new%20to%20Komatsu%2C%20they%E2%80%99re%20a%20leading%20manufacturer%20of%20mining%20and%20earth%20moving%20equipment%20for%20construction%20around%20the%20world.%20In%20Australia%20alone%2C%20Komatsu%20has%20more%20than%2030%2C000%20machines%20in%20daily%20operation.%20And%20as%20a%20company%2C%20they%E2%80%99re%20at%20the%20forefront%20of%20several%20leading%20edge%20solutions%20in%20their%20industry%2C%20including%20smart%20and%20autonomous%20self-driving%20machinery.%20Incidentally%2C%20the%20Australian%20subsidiary%20spans%20three%20different%20countries%20in%20seven%20regions.%20So%20Nipun%2C%20with%20all%20the%20expansive%20area%20of%20coverage%2C%20what%20were%20you%20trying%20to%20solve%20for%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20So%20the%20short%20answer%20is%20operational%20efficiency.%20When%20we%20started%20down%20a%20modernization%20path%2C%20we%20were%20struggling%20with%20getting%20an%20accurate%20and%20timely%20view%20of%20parts%2C%20demand%2C%20and%20inventory%20requirements%20to%20meet%20a%20customer%E2%80%99s%20specific%20needs.%20Our%20customers%20are%20mainly%20in%20mining%20and%20construction%20industries.%20The%20uptime%20of%20their%20machines%20is%20of%20critical%20importance%20for%20them%20and%20for%20us.%20So%20having%20the%20right%20part%20at%20the%20right%20place%20at%20the%20right%20time%20is%20vital%20for%20operations.%20From%20an%20aftermarket%20care%20perspective%2C%20to%20get%20ahead%20of%20inventory%20requirements%20we%20needed%20more%20perspective%20and%20insight%20into%20the%20drivers%20behind%20what%20customers%20are%20requesting.%20Secondly%2C%20on%20the%20resource%20planning%20side%2C%20machine%20servicing%20is%20based%20on%20usage.%20Heavy%20usage%2C%20for%20example%2C%20will%20accelerate%20service%20milestones.%20At%20the%20same%20time%2C%20beyond%20sourcing%20the%20parts%20needed%20for%20servicing%2C%20we%20need%20to%20make%20sure%20the%20right%20skilled%20technicians%20are%20also%20available.%20So%20we%20wanted%20to%20be%20able%20to%20plan%20those%20needs%20more%20proactively.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20And%20Komatsu%20has%20been%20around%20for%20a%20long%20time%2C%20but%20can%20you%20tell%20us%20what%20were%20some%20of%20the%20established%20systems%20that%20were%20already%20in%20play%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20So%20yes%2C%20this%20year%20in%20fact%20marks%20our%20hundredth%20anniversary.%20As%20you%20can%20imagine%2C%20we%20had%20a%20blend%20of%20legacy%20and%20modern%20applications%20in%20our%20environment%20used%20by%20the%20business.%20All%20systems%20are%20fully%20on-premises.%20There%20are%20around%20two%20dozen%20different%20source%20business%20systems%20that%20spans%20across%20our%20Australian%20subsidiary%20and%20our%20headquarters%20in%20Japan.%20In%20Japan%2C%20we%20manufacture%20our%20machinery.%20We%20have%20systems%20hosting%20our%20satellite%20telemetry%20data%20for%20our%20customer%20machines%20and%20other%20source%20systems%20that%20has%20component%20and%20equipment%20information%2C%20machine%20contracts%2C%20distribution%20center%20inventory%2C%20and%20parts%20ordering%20systems.%20Our%20warehouse%20management%20system%2C%20including%20one%20for%20stock%20forecasting%20and%20other%20for%20planning%20and%20logistics%20is%20also%20in%20Japan.%20In%20our%20Australian%20subsidiary%2C%20we%20have%20various%20ERP%20systems%20and%20customer%20relationship%20management%20systems%20in%20use%20for%20aftermarket%20sales%20and%20operations.%20And%20we%20have%20various%20source%20systems%20for%20field%20servicing%20to%20deploy%20technicians%2C%20local%20on-board%20machine%20systems%20for%20diagnostics%2C%20branch%20stock%2C%20service%20meter%20reading%2C%20and%20more.%20We%20maintain%20a%20global%20equipment%20master%20system%20and%20keep%20our%20financial%20data%20in%20SAP.%20Additionally%2C%20when%20we%20started%20there%20were%20several%20dozen%20Access%20and%20SQL%20server%20databases%20in%20use%20for%20file-based%20source%20systems.%20This%20was%20managed%20by%20our%20business%20teams%20to%20collate%20spreadsheets%20and%20query%20volumes%20of%20data%20for%20weekly%20snapshot%20and%20KPIs.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Right%2C%20that%E2%80%99s%20a%20huge%20amount%20of%20data%20spread%20across%20oceans%20and%20multiple%20distributed%20systems%20that%20you%20were%20managing.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Right%2C%20we%20had%20terabytes%20of%20data%20distributed%20everywhere%2C%20but%20nothing%20was%20connected%20or%20available%20in%20a%20consistent%20manner.%20People%20were%20connecting%20to%20data%20sources%20through%20Excel%2C%20loading%20data%20and%20files%20manually%20for%20reporting.%20Pulling%20a%20report%20to%20get%20an%20accurate%20view%20of%20our%20parts%20inventory%2C%20for%20example%2C%20would%20require%20connecting%20to%20five%20different%20source%20systems%20across%20Japan%20and%20our%20Australian%20subsidiary%2C%20with%20different%20schema%20and%20different%20tooling.%20And%20the%20hard%20part%20was%20out-of-date%20reporting.%20We%20were%20limited%20to%20running%20a%20batch%20process%20once%20a%20week.%20It%20took%208%20to%2010%20hours.%20So%20we%20ran%20it%20on%20Saturday%20to%20avoid%20impacting%20our%20business%20transactions%20during%20the%20week.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20And%20these%20systems%20were%20baked%20into%20your%20everyday%20operations%2C%20but%20what%20was%20your%20approach%20then%20that%20you%20took%20for%20modernizing%20all%20of%20this%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20To%20move%20fast%2C%20we%20took%20a%20hybrid%20approach%20to%20consolidate%20our%20data%20to%20a%20single%20source%20of%20truth%20across%20our%20data%20estate.%20We%20wanted%20to%20move%20to%20Azure%20for%20its%20data%20and%20AI%20platform%20capabilities.%20And%20we%20chose%20Azure%20SQL%20Managed%20Instance%20for%20two%20reasons.%20The%20first%20was%20compatibility%20with%20our%20SQL%20implementations.%20There%20was%20almost%20no%20code%20changes%2C%20and%20we%20were%20able%20to%20leverage%20the%20existing%20skills%20within%20the%20team.%20We%20also%20took%20advantage%20of%20SQL%20MI%20VNet%20support%20to%20access%20the%20environment%20from%20an%20on-prem%20network.%20The%20second%20was%20performance%2C%20cost%2C%20and%20dynamic%20scale.%20So%20we%20could%20comfortably%20scale%20to%20our%20needs%20without%20any%20concerns.%20For%20example%2C%20you%20can%20see%20here%2C%20scaling%20is%20very%20easy.%20We%20can%20independently%20scale%2C%20compute%20and%20storage.%20So%20during%20our%20normal%20business%20hours%2C%20we%20allocate%2016%20cores%20and%20we%20can%20manually%20scale%20up%20for%20ad%20hoc%20needs%20like%20data%20refreshes%20without%20interrupting%20our%20daily%20operations.%20We%20have%20also%20built%20custom%20event-based%20automation%20in%20PowerShell.%20This%20adds%20more%20compute%20as%20we%20load%20the%20data%20for%20overnight%20refreshes.%20It%20is%20a%20simple%20scripted%20procedure%20that%20we%20can%20use%20on%20schedule.%20See%2C%20if%20I%20do%20a%20Get-Command%2C%20you%E2%80%99ll%20see%20I%E2%80%99m%20at%20eight%20cores.%20And%20if%20I%20do%20a%20set%20command%2C%20you%20will%20see%20it%20takes%20a%20moment%20to%20scale%20up%20to%2024%20cores.%20In%20our%20case%2C%20we%20scale%20up%20to%2024%20cores%20at%209%3A00%20PM%20each%20day%2C%20so%20we%20don%E2%80%99t%20interfere%20with%20business%20traffic.%20The%20data%20from%20our%20source%20systems%20is%20refreshed%20before%20the%20start%20of%20the%20workday%2C%20and%20we%20scale%20down%20in%20morning%20at%204%3A30%20AM.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Okay%2C%20so%20now%20you%20had%20a%20lot%20of%20systems%20that%20were%20in%20use%2C%20but%20where%20did%20you%20focus%20then%20your%20data%20migration%20and%20consolidation%20efforts%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20We%20started%20by%20identifying%20three%20core%20systems%20and%20we%20brought%20this%20data%20into%20Azure%20SQL%20MI.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Okay%2C%20so%20how%20did%20these%20systems%20then%20provide%20an%20initial%20foundation%20for%20your%20reporting%20needs%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20They%20were%20instrumental.%20Our%20Dynamics%20AX%20system%20holds%20the%20key%20insights%20for%20understanding%20our%20customer%20demands%20for%20parts.%20Then%20our%20ICT%20telemetry%20systems%20contains%20satellite%20data%20on%20machine%20usage%2C%20as%20well%20as%20data%20from%20onboard%20systems%20for%20specific%20alerts%2C%20events%2C%20and%20warning%20codes.%20And%20it%20also%20brings%20basic%20time-series%20data.%20So%20based%20on%20the%20hours%20of%20usage%20for%20a%20specific%20machine%2C%20we%20can%20determine%20how%20close%20it%20is%20for%20specific%20recommended%20service%20milestone.%20And%20the%20actual%20machine%20usage%20shows%20up%20in%20our%20reports%20as%20a%20Service%20Meter%20Reading.%20Specific%20events%20on%20the%20machine%20helps%20us%20identify%20potential%20failures%20and%20proactively%20support%20our%20customers.%20To%20add%20to%20that%2C%20our%20CMS%20system%2C%20which%20collects%20lab%20data%20on%20our%20oil%20samples%2C%20also%20provide%20valuable%20information%20about%20machine%20health.%20All%20this%20data%20feeds%20into%20our%20Power%20BI%20service%20via%20the%20Power%20BI%20gateway%2C%20which%20we%20set%20up%20to%20provide%20self-service%20dashboards%2C%20analytics%20and%20reporting.%20And%20we%20also%20use%20a%20logic%20app%20to%20refresh%20our%20data%20models%20once%20the%20data%20is%20loaded%20into%20SQL%20MI.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Okay%2C%20so%20how%20quickly%20then%20were%20you%20able%20to%20expand%20beyond%20this%20kind%20of%20core%20set%20of%20services%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20It%20was%20radical.%20Within%20six%20to%20seven%20months%2C%20we%20started%20to%20expand%20further.%20We%20were%20able%20to%20go%20from%20almost%20a%20working%20day%20to%20pull%20reports%20to%20just%2020%20minutes%20with%20our%20first%20iteration.%20And%20now%20by%20caching%20the%20data%20in%20Power%20BI%2C%20we%20can%20do%20this%20in%20seconds.%20Since%20the%20initial%20implementation%2C%20we%20have%20added%2017%20more%20business%20systems%20without%20worrying%20about%20scaling%20or%20performance.%20We%20were%20also%20able%20to%20bring%20in%20data%20from%20various%20file%20sources%20available%20only%20within%20departments.%20And%20we%20went%20from%20300%20gigs%20to%206%20terabytes%20of%20data%20quickly%2C%20and%20from%20a%20hundred%20users%20to%20over%20a%20thousand%20consumers%20of%20information.%20In%20fact%2C%20you%20can%20see%20the%20types%20of%20reports%20the%20users%20are%20generating%20here.%20All%20of%20these%20reports%20were%20not%20even%20possible%20before.%20We%20are%20streamlining%20data%20sets%2C%20sources%20and%20models%20so%20that%20everyone%20is%20working%20from%20one%20source%20of%20the%20truth.%20We%20now%20have%20around%2070%20Power%20BI%20citizen%20developers%20sitting%20across%20business%20teams%2C%20building%20reports%20around%20the%20same%20data.%20And%20we%20can%20refresh%20and%20pull%20reports%20in%20just%20a%20few%20seconds%20now.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Nice%2C%20so%20can%20we%20see%20some%20of%20the%20reports%20then%20that%20you%E2%80%99re%20now%20able%20to%20build%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Sure%2C%20let%20me%20pull%20up%20a%20few%20for%20you.%20Here%E2%80%99s%20an%20example.%20I%20can%20see%20upcoming%20service%20milestones%20by%20equipment%20type%20and%20location%20and%20required%20parts%20for%20the%20same.%20If%20I%20want%20to%20know%20how%20many%20excavators%20are%20due%20for%20their%20thousand%20hour%20service%2C%20I%20can%20click%20here%20in%20the%20excavator%20bar.%20Here%20I%20can%20see%20the%20regions%20where%20the%20machines%20are%20running%20and%20the%20parts%20required%20for%20them.%20This%20is%20something%20that%20was%20not%20possible%20before%2C%20because%20the%20data%20was%20either%20locked%20into%20our%20system%20or%20just%20not%20available.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20How%20does%20this%20now%20help%20with%20your%20inventory%20reporting%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Oh%2C%20we%20have%20completely%20transformed%20the%20visibility%20we%20had.%20So%20let%20me%20show%20you.%20Here%E2%80%99s%20an%20inventory%20report%20that%20our%20business%20team%20were%20able%20to%20create%20to%20track%20parts%20on%20hand%20for%20customer%20service%20requests.%20The%20data%20from%20this%20report%20is%20sitting%20across%20multiple%20sources%20and%20all%20put%20together%20in%20SQL%20MI.%20We%20can%20see%20part%20stock%20levels%20per%20region%20represented%20by%20DC%2C%20Distribution%20Center%20values.%20I%20can%20drill%20into%20parts%20available%20for%20specific%20machine%20type%2C%20like%20excavator%2C%20and%20see%20quickly%20the%20status%20of%20this%20machine.%20Now%20the%20teal%20color%20means%20we%E2%80%99re%20covered%2C%20but%20doesn%E2%80%99t%20tell%20the%20entire%20story%20because%20some%20of%20the%20parts%20categories%20don%E2%80%99t%20need%20inventory%20on%20hand.%20If%20I%20filter%20the%20national%20demand%20ranking%20here%20to%20look%20at%20the%20top%20ranked%20parts%20indicated%20by%20A%2C%20you%20see%20we%20have%20nothing%20to%20worry%20about%2C%20we%20have%20a%20healthy%20supply.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20And%20of%20course%2C%20the%20dashboard%20is%20only%20half%20the%20story.%20So%20what%20are%20you%20doing%20then%20to%20support%20this%20type%20of%20self-service%20reporting%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Right%2C%20the%20amazing%20thing%20for%20us%20is%20having%20the%20data%20in%20one%20source.%20And%20depending%20on%20the%20question%20our%20business%20is%20trying%20to%20answer%2C%20we%20obviously%20prep%20the%20data%20and%20connect%20the%20dots%20at%20the%20backend.%20For%20example%2C%20here%E2%80%99s%20the%20backend%20data%20model%20behind%20these%20fields%20that%20our%20business%20users%20have%20created%20linking%20various%20tables.%20Even%20if%20you%20knew%20where%20to%20find%20the%20data%20as%20a%20business%20analyst%2C%20most%20of%20these%20tables%20and%20the%20underlying%20data%20fields%20don%E2%80%99t%20exist.%20My%20team%20implements%20the%20business%20logic%20to%20map%20the%20data%20into%20business%20semantic%20layer%2C%20to%20make%20it%20more%20consumable%20and%20consistent%20across%20the%20business.%20Let%20me%20give%20you%20an%20example%20of%20what%20goes%20into%20this.%20Here%E2%80%99s%20SQL%20Server%20Management%20Studio%2C%20we%20build%20custom%20views%20correlating%20data%20from%20different%20sources.%20In%20the%20first%20query%20and%20tab%2C%20we%20are%20pulling%20all%20the%20different%20sources%20where%20our%20inventory%20currently%20sits.%20Main%20indicates%20our%20primary%20inventory%20system.%20Then%20as%20I%20scroll%20down%2C%20you%20will%20see%20we%20are%20connecting%20related%20data%20from%20distribution%20center%20and%20also%20from%20branch%20locations.%20This%20paints%20an%20accurate%20picture%20of%20inventory%20across%20all%20our%20repos.%20Next%2C%20in%20the%20second%20tab%2C%20this%20query%20is%20all%20about%20calculating%20minimum%20inventory%20levels%20to%20ensure%20we%20have%20enough%20stock%20on%20hand.%20You%20can%20see%20here%2C%20we%20are%20also%20including%20incoming%20deliveries%20as%20you%20see%20with%20the%20items%20marked%20on%20order.%20This%20helps%20ensure%20that%20we%20keep%20the%20inventory%20in%20line%20with%20demand.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20So%20then%2C%20with%20so%20much%20growth%20then%20in%20your%20data%2C%20how%20were%20you%20able%20to%20maintain%20consistency%20in%20performance%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20So%20Azure%20SQL%20MI%20has%20built-in%20auto%20tuning.%20It%20will%20automatically%20index%20your%20main%20updates%20and%20your%20queries.%20But%20there%E2%80%99s%20also%20optimizations%20that%20you%20can%20do%20to%20help%20auto%20tuning%20to%20work%20better%20for%20you.%20When%20indexes%20are%20created%2C%20tables%20need%20to%20be%20republished.%20Otherwise%20the%20ordering%20of%20data%20on%20the%20disk%20becomes%20fragmented%2C%20impacting%20your%20IOPS.%20To%20solve%20this%2C%20we%20update%20the%20statistics%20by%20prioritizing%20which%20tables%20are%20most%20required%20at%20the%20semantic%20layer%20for%20querying.%20The%20nice%20thing%20with%20SQL%20MI%20is%20that%20management%20is%20very%20consistent%20compared%20to%20SQL%20server%20running%20on%20a%20physical%20or%20a%20virtual%20machine.%20We%20have%20a%20diagnostic%20script%20that%20we%20can%20run%20and%20list%20out%20all%20big%20tables%20and%20look%20at%20the%20percentage%20of%20fragmentation%20and%20page%20counts.%20If%20fragmentation%20is%20over%2080%25%2C%20we%20can%20run%20another%20script%20to%20fix%20the%20fragmentation.%20To%20automate%20this%20process%2C%20we%20run%20a%20stored%20procedure%20to%20defragment%20the%20index%20tables%20weekly.%20This%20is%20a%20standard%20script%20from%20Microsoft%2C%20and%20we%E2%80%99ve%20just%20added%20a%20filter%20for%20our%20biggest%20schema%20called%20DSA%20for%20our%20semantic%20querying%20layer.%20This%20re-indexes%20and%20reformats%20the%20table%20and%20updates%20the%20stats%20to%20keep%20everything%20under%2070%25%20fragmentation.%20These%20procedures%20run%20every%20Saturday%20morning%20and%20it%20takes%20few%20hours%2C%20but%20afterwards%2C%20all%20the%20big%20tables%20are%20tuned%20for%20best%20performance.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20I%E2%80%99m%20going%20to%20say%20great%20work%20from%20you%20and%20the%20team%20to%20really%20modernize%20data%20and%20the%20operations%20at%20Komatsu.%20So%20where%20do%20the%20things%20then%20go%20from%20here%3F%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20The%20great%20thing%20about%20being%20in%20the%20cloud%20is%20that%20our%20implementation%20grows%20with%20us.%20As%20you%20saw%2C%20our%20data%20has%20grown%2020x%20and%20our%20users%2010x%2C%20and%20we%20have%20added%20additional%20managed%20instances%20to%20support%20the%20demand.%20We%20also%20have%20a%20great%20option%20to%20grow%20as%20we%20need%20in%20Azure.%20And%20the%20next%20journey%20is%20more%20ad%20hoc%20exploration%20and%20predictive%20analytics.%20We%20are%20looking%20at%20Azure%20Synapse%20Analytics%20to%20take%20advantage%20of%20data%20warehousing%20as%20our%20data%20footprint%20grows%2C%20especially%20with%20our%20increased%20investment%20in%20IoT%20and%20connected%20machinery%20at%20the%20Edge.%20Here%2C%20you%E2%80%99re%20seeing%20the%20data%20we%20have%20pulled%20in%2C%20and%20these%20are%20the%20linked%20services%20that%20we%20are%20using%20with%20Synapse.%20We%20have%20already%20started%20experimenting%20with%20bringing%20in%20our%20source%20system%20data%2C%20like%20SAP%20HANA%2C%20to%20integrate%20across%20data%20sets%20and%20even%20better%20insights%20and%20data%20exploration.%20And%20we%E2%80%99ll%20continue%20to%20use%20Azure%20SQL%20MI%20for%20new%20apps%20that%20we%20build%20on%20Azure.%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22jk%20jl%20gs%20jm%20b%20jn%20lg%20ir%20jp%20jq%20lh%20iv%20js%20jt%20li%20jv%20jw%20jx%20lj%20jz%20ka%20kb%20lk%20kd%20ke%20kf%20dp%20ho%22%20data-selectable-paragraph%3D%22%22%3E-%20Thanks%20so%20much%20Nipun%2C%20for%20joining%20us%20today%20and%20also%20sharing%20Komatsu%E2%80%99s%20story%20and%20implementation%20for%20Azure%20SQL%20Managed%20Instance.%20And%20also%20for%20more%20hands-on%20deep%20dives%20like%20this%2C%20keep%20checking%20back%20to%20Microsoft%20Mechanics.%20Subscribe%20to%20our%20channel%20if%20you%20haven%E2%80%99t%20yet%2C%20and%20we%E2%80%99ll%20see%20you%20soon.%3C%2FP%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FSECTION%3E%0A%3C%2FDIV%3E%0A%3C%2FARTICLE%3E%0A%3CDIV%20class%3D%22nz%20ck%20fn%20mz%20w%20un%20fp%20mx%20tl%22%20data-test-id%3D%22post-sidebar%22%3E%0A%3CDIV%20class%3D%22n%20p%22%3E%0A%3CDIV%20class%3D%22ap%20aq%20ar%20as%20at%20au%20av%20w%22%3E%0A%3CDIV%20class%3D%22tm%20n%20aj%22%3E%0A%3CDIV%20class%3D%22wl%22%3E%0A%3CDIV%20class%3D%22ps%20tq%20n%20ax%20th%22%3E%0A%3CDIV%20class%3D%22ni%20nj%20tr%20ts%20n%22%3E%0A%3CDIV%20class%3D%22n%20o%22%3E%0A%3CDIV%20class%3D%22s%20ao%20nk%20nl%20nm%20nn%20no%22%3E%0A%3CDIV%20class%3D%22%22%3E%0A%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2323452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EModernize%20your%20existing%20data%20at%20scale%2C%20and%20solve%20for%20operational%20efficiency%20with%20Azure%20SQL%20Managed%20Instance.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2323452%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎May 04 2021 12:54 PM
Updated by: