Category Archives: Power View/Project Crescent

Book: Reporting with Microsoft SQL Server 2012

I am happy to say I have published my first book!  It is called Reporting with Microsoft SQL Server 2012 (order).  Much thanks goes to my co-author and friend Bill Anton.  Below is a brief overview or check out the … Continue reading

Posted in Power View/Project Crescent, SQLServerPedia Syndication, SSRS | Leave a comment

Power BI for Office 365 requirements

“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have a video at Power BI for Office 365 video).  Power BI is an Office 365 marketing offering (see pricing).  Each of … Continue reading

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

Power BI for Office 365 video

A demonstration of Power BI for Office 365, showing you how all the various tools and technologies work together: Power Query, Power Pivot, Power View, Power Map, Power BI sites, Data Management, Power BI Admin center, Power BI for mobile, … Continue reading

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

Power BI first impressions

I have been using Power BI the past few weeks (see my video of all the features) after I was invited by Microsoft to test the Power BI for Office 365 Preview (register here).  I have to say I am extremely impressed. … Continue reading

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

Power BI for Office 365

Announced at Microsoft’s Worldwide Partner Conference 2013 is Power BI for Office 365: Power BI for Office 365 is a cloud-based business intelligence (BI) solution that enables customers to easily gain insights from their data, working within Excel to analyze and visualize … Continue reading

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

Power View for Multidimensional Models Released

As a followup to my blog Power View for Multidimensional Models – Preview Available, the final version is now available via SQL Server 2012 Service Pack 1 Cumulative Update 4. So you can now create Power View reports against multidimensional models … Continue reading

Posted in Power View/Project Crescent, SQLServerPedia Syndication | Leave a comment

Microsoft BI tools: How they use data sources

A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and “Analysis Services” (cubed-based, which can be the multidimensional model or the tabular model).  Note that any reporting tool that supports the … Continue reading

Posted in Excel, PerformancePoint, Power Pivot, Power View/Project Crescent, Report Builder, SQLServerPedia Syndication, SSRS | 1 Comment

Power View for Multidimensional Models – Preview Available

Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012.  Power View can only consume data from tabular models.  At the PASS Summit (see PASS 2012 Announcements) it was revealed that you would soon be able to … Continue reading

Posted in Power View/Project Crescent, SQLServerPedia Syndication | 3 Comments

PASS 2012 Announcements

Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL PASS?): PASS Summit 2012 had 3,894 delegates – up 13% from last year’s previous record attendance – and 1,717 pre-conference … Continue reading

Posted in PASS, PDW/APS, Power View/Project Crescent, SQLServerPedia Syndication | 2 Comments

How to use a multidimensional cube with Power View

The requirements for Power View state that it can only use tabular models as data sources.  So if you want to use Power View against a multidimensional cube, you are stuck.  But there is a work-around: Create a PowerPivot for SharePoint … Continue reading

Posted in Power View/Project Crescent, SQLServerPedia Syndication | Leave a comment