These are the sample reports from the Penton eLearning session today on SSRS Report Expressions:
This view is necessary to add to the AdventureWorksDWxxxx database:
We can now use Visual Studio 2012 to create and edit SQL Server BI projects! Woo Hoo.
In the past, if you wanted to develop and maintain BI projects in the same development environment as other Visual Studio projects, you had to install multiple versions of Visual Studio. This may no longer be necessary if you install the new Business Intelligence for Visual Studio 2012 (SSDT BI). Continue reading
When I started playing with GeoFlow, I just had to find a way to do something interesting with it. This is a short world tour with visits to a few SQL Server community members and leaders around the globe talking about their SQL Server communities. GeoFlow is a new BI tool currently in development at Microsoft. It’s an add-in for Excel 2013 using the SQL Server Analysis Services tabular in-memory aggregation that plots and visualizes data points on the globe using imagery from Bing Maps. After visualizing data on a map, you can create a 3D tour with full zoom and navigation in 3D geographical space.
Thanks to my friends and associates who have contributed to this effort thus far. This is the first draft so please check back and I’ll add more stops on the tour along with more sophisticated data points. The dataset in my current GeoFlow workbook is very light and with more contributions, I’ll can add creative ways to visualize the global SQL Server world community. Enjoy!
GeoFlow is still in development and not yet generally available. It’s too soon to foresee when it will be complete enough for a public preview and then for release but I’ll let you know what I know when I know it.