從原始數據到真實洞察：構建數據驅動型組織的經驗教訓.pdf

《從原始數據到真實洞察：構建數據驅動型組織的經驗教訓.pdf》由會員分享，可在線閱讀，更多相關《從原始數據到真實洞察：構建數據驅動型組織的經驗教訓.pdf（30頁珍藏版）》請在三個皮匠報告上搜索。

1、Hosted by:Welcome!The presentation will begin shortly If your badge was not scanned at the door,please use the self check-in feature in the session details in the Schedule.April 10,2025Great Lakes Data,AI&Analytics SummitFrom Raw Data to Real Insights:Lessons from Building a Data-Driven Organization

2、Michigan Medical GroupsRachel SandersBusiness Intelligence Analyst IIIn the healthcare industry for 25+years-Experience on the clinical,revenue,and application/EMR support sides prior to joining BI TeamEnjoys training and supporting customers with all their reporting needsProjects include:-Fiscal Ye

3、ar Goals-Referral Reporting-Behavioral Health Program ReportingEvan DelcampBusiness Intelligence Analyst IIBachelor of Business Administration from Eastern Michigan UniversityCurrent University of Michigan Data Science Masters StudentProjects Include:-Provider Messaging-Patient Access-Office Collect

4、ionsP2025 Trinity Health3Speaker IntroductionsIHA was founded in 1994 serving Southeast Michigan.In 2024,we expanded services to include West Michigan medical practices We served 947,000+patients over the last year.250+office locations serving communities in Washtenaw,Livingston,Lenawee,Oakland,West

5、ern Wayne,Allegan,Kent,Ottawa,and Muskegon Counties.60+SpecialtiesBusiness Intelligence Department was initiated in 2017.15 BI Staff and growing.Core technologies are Microsoft SQL Server Database,SQL Server Integration Services(SSIS),SQL Server Analysis Services(SSAS),SQL Server Reporting Services(

6、SSRS),Power BI,and Microsoft Fabric(new)About us:Trinity Health Michigan Medical Groups2025 Trinity Health4Lacking insights on business performanceReports limited in vendor applicationsDifficult to combine data from disparate systems No cross-organizational goals and metricsChallenging to view trend

7、s and performance over timeNo one to focus on data and analyticsExtra responsibility for IT staff with other prioritiesAnalytics limited to individual departments with limited comparison between departments2025 Trinity Health5Original State:Limited Data-Driven Decision MakingLesson:Develop A Central

8、ized Business Intelligence DepartmentA Centralized Business Intelligence Department2025 Trinity Health7Dedicated team for addressing data and insight needsBuilding data warehouse and clear organization-wide toolsCentralizing analytics prioritizationCategorizing reports and soliciting feedbackA Centr

9、alized Business Intelligence Department2025 Trinity Health8Freeing the Data:Improving User AccessEvolving data literacy and BI adoptionProactive InnovationGetting Started:Align expectations with leaders,define customers and data areasBusiness Intelligence Skills and expertise in the technologies,app

10、lications and best practices in Business Intelligence Produces data solutions like data visualizations Works with SME to translate business problems into technical requirements Design and architecture of the Enterprise Data Warehouse.Develops and maintains ETL(Extract,Transform,Load)and refresh proc

11、essesSubject Matter Expert(SME)Knowledge and expertise in a specific area(Finance,HR,Clinical Ops,etc.)Defines metrics for BI to build The go-to person for information on a particular topic Knows the business processes,data systems,and challenges in their department Uses BI tools to interpret meanin

12、g Helps with data validationBusiness Intelligence and Subject Matter Expert2025 Trinity Health9Lesson:Advantages of an Enterprise Data WarehouseAdvantages of an Enterprise Data Warehouse2025 Trinity Health11Centralized Data Storage:Stores integrated data from multiple sources within an organization.

13、Enhanced Data Quality:Ensures consistency,accuracy,timeliness,and reliability of dataEfficient Query Performance:Optimizes data retrieval and analysis speedInformed Decision-Making:Supports comprehensive analysis for strategic insightsLesson:The Importance of Leadership Buy-InThe Importance of Leade

14、rship Buy-In2025 Trinity Health13BI can focus on critical projects like EDW and delegate non-priority tasksBI can align work with organizational goalsSupportive leadership will appoint SMEs,bring expectations for data use and communicate trust in data to staffThe Role of the BI Advisory Group2025 Tr

15、inity Health14Executive Leadership from multiple departments that regularly meets with BITool demonstration helps leadership champion the use of data,dashboards,and self-service tools and leads to an iterative approach for our toolsProvides prioritization of large-scale projects and guidance on crit

16、ical decisions Assists with removing obstacles that prevent us from delivering informationExecutive sponsors that build trust,appoint SMEs,and alert teams about upcoming reporting Lesson:Building Engagement and Empowerment2025 Trinity Health16Building Engagement and Empowerment through Self Serve To

17、ols and Support SystemsBI cant fulfill all data inquiriesDevelop self serve toolsNeed to multiply ourselvesSelf Serve Tools2025 Trinity Health17Keep metrics simpleAvoid Overwhelming with Excessive DataSupport and TrainingSQL:Tabular Model:Demonstration of SSAS Tabular Model2400 lines of code for the

18、 initial load1100 for the incremental load (excluding comments and logging)Strong Support and Training Systems2025 Trinity Health19Training Guides/VideosFlexible toolsOne on One trainingOffice Hours:Open Q&AThe Value of BI Office Hours2025 Trinity Health20Open to all users of BI servicesMonthly meet

19、ing led by BI staff Forum for communication to a wide audienceUsers can bring questions or just listenVirtual meetings so all locations can attendAsk what people are interested in and use for training on a specific topicAlways available crowd-sourced support Online forum(MS Teams,Slack channel)for p

20、osting questions and sharing informationShareable recorded sessionsLesson:Building Data LiteracyFostering Curiosity:Our Community of Analytics2025 Trinity Health22Advanced,Motivated,Positive usersUnderstanding of statistical and analytical conceptsTrains others in their area on BI toolsActs as a lia

21、ison between BI and their departmentChampions the use of data throughout their departmentAttends regular meetings with BI and CoA membersCommunity of Analytics Topic Ideas2025 Trinity Health23How can we ensure the organization never gets insights from data?Visualization best(and worst!)practicesCan

22、you solve these riddles?Lets try a technique!Play on assumptions As we work through the answer,identify what were assuming and/or trying to clarify Ask yes/no questions The process is the most important part of this exerciseRiddles!2025 Trinity Health24A man comes into town on Friday,stays two night

23、s,then leaves on Friday.How is this possible?2025 Trinity Health25A bus driver was heading down a street in Chicago.She went right past a stop sign without stopping,turned left where there was a“No Left Turn”sign,and went the wrong way on a one-way street.She didnt break any traffic laws while doing

24、 this.How is this possible?2025 Trinity Health26 Riddles challenge your critical thinking Keep us asking questions Not only relevant to super users-Users new to analytics will pick this skill up-Dont just give users the answers-Guide them and help their growthApplication2019 Trinity Health27Become a

25、 Data Leader:How Will You Apply These Strategies?2019 Trinity Health28Develop a Centralized BI TeamBuild a Data WarehouseGet that leadership buy inBuild engagement and empower your usersFocus on building data literacyQuestions?2019 Trinity Health29Hosted by:Thank you for attending!We value your feedback!Please rate your speaker in the conference evaluation provided at the end of the event.