![]() Make better business decisions by getting greater insights into your company Don’t need to provide security access for many users to the production systems Easy to create BI solutions on top of it (i.e. Improve data quality and plugs holes in source systems No IT involvement needed for users to create reports Use Master Data Management, including hierarchies Restructure/rename tables and fields, model data Keep historical records (no need to save hardcopy reports) Optimized for read access, sequential disk scans ![]() It acts as a central repository for many subject areas and contains the "single version of truth". What is a Data Warehouse and why use one?Ī data warehouse is where you store data from multiple data sources to be used for historical and trend analysis I tried to figure out all these data platform buzzwords on my own…Īnd ended up passed-out drunk in a Denny’s Author of book “Reporting with Microsoft SQL Server 2012” Presenter at PASS Summit, SQLBits, Enterprise Data World conference, Big Data Conference Been perm employee, contractor, consultant, business owner Worked as desktop/web/database developer, DBA, BI and DW architect and developer, MDM In IT for 35 years, worked on many BI and DW projects Was previously a Data & AI Architect at Microsoft for seven years At Microsoft for most of the last eight years, with a brief stop at EY Microsoft, Data & AI Solution Architect in Microsoft Consulting Services (MCS), now called Industry (the alphabet soup of data architectures) ![]() Data Lakehouse, Data Mesh, and Data Fabric (r2)
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |