Creating SQL Server Reporting Services Reports

SQL Server Reporting Services (SSRS) is Microsoft most accomplishing reporting tool. No matter which tool you decided to use in the Microsoft Business Intelligence offerings, SSRS will likely play a part if you really want one solution that does most of what you need. SSRS is...

Building Excel Dashboards

Excel Dashboard. In previous videos, I demonstrated the use of PowerView when creating dashboards. Now, I going to demonstrate dashboard creation with a more familiar tool, Excel. Despite the release of several visualization tools by Microsoft, Excel still represents Microsoft...

Introduction To Building PowerPivot Datasource

Creating PowerPivot data sources As I have demonstrated there are a lot of things about PowerBI to get excited about. One of these is Microsoft’s adaption of the technology xVelocity. The true power behind PowerPivot is the xVelocity in-memory analytics engine. Why XVelocity is...

Introduction to PowerView Creating Calculations

Creating Calculations Now that you have a solid understanding of creating some basic PowerView dashboards. You are ready to extend the model with custom calculations. In this next demonstration, I will introduces the Data Analysis Expressions (DAX) language and explains how to...

Introduction to PowerView Maps

Adding Maps For those that have experience with the Map capabilities in SQL Reporting Services, you know Microsoft defiantly had a lot of room for improvement. With PowerBI, Power Map greatly increases the mapping visualizations at your disposal. It can produce visualizations by...

Introduction to Adding Images in PowerView Dashboards

Using Images in PowerView Images give your dashboards a professional look and provide more ease of use. PowerView allows you to use images in about every possible way. One of the most effective usages of images in PowerView is with the Card object. In the last section you saw how...

Introduction to PowerView Creating KPIs by Melvin Black

Creating KPIs KPIs are a staple of many dashboards and provide a great way to quickly see trends and spot areas that need further analysis. One of the nice features about KPIs in PowerBI when it comes to creating KPIs that it allows you enhance existing measures and not create a...

Introduction to PowerView by Melvin Black

Introduction to PowerView Microsoft has been a leader in the Business Intelligence (BI) space. With SQL Server and Excel having been on the market for over 20 years it has always had a presence in data management. Today, one of the new initiatives in BI is self-service BI.  I...
Send