Monthly Archives: February 2015

Operational Data Store (ODS) Defined

I see a lot of confusion on what exactly is an Operational Data Store (ODS).  While it can mean different things to different people, I’ll explain what I see as the most common definition.  First let me mention that an … Continue reading

Posted in Data warehouse, SQLServerPedia Syndication | 7 Comments

Presentation slides for “Building a Big Data Solution”

Thanks to everyone who attended my session “Building a Big Data Solution” (Building an Effective Data Warehouse Architecture with Hadoop, Cloud and MPP) for Pragmatic Works today.  The abstract for my session is below and the recording will be available here tomorrow.  I hope you enjoyed it! … Continue reading

Posted in Data warehouse, Presentation, Session, SQLServerPedia Syndication | Leave a comment

Power BI Made Simple

In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to hopefully make things easy for you: Power BI Made Simple. It is a presentation that covers all the products under the Power … Continue reading

Posted in Power BI, Power Map, Power Pivot, Power Query, Power View/Project Crescent, SQLServerPedia Syndication | 4 Comments

What is Advanced Analytics?

Advanced Analytics, or Business Analytics, refers to future-oriented analysis that can be used to help drive changes and improvements in business practices.  It is made up of four phases: Descriptive Analytics: What is generally referred to as “business intelligence”, this … Continue reading

Posted in SQLServerPedia Syndication | Leave a comment

Microsoft product roadmap now public

Ever wonder about Microsoft’s product roadmap?  With Microsoft rapidly releases products and services, they realized the need to provide better transparency.  Well wonder no more!  They have released the Cloud Platform Roadmap Site (visit here). Roadmaps are given for: Microsoft … Continue reading

Posted in Microsoft, SQLServerPedia Syndication | 1 Comment