Power BI is a cloud-based data visualization tool from Microsoft. Power BI is arguably the fastest growing Cloud BI tool from Microsoft. The product went into GA in 2015 and from thereon it is on a roll. In order to get started, a lot of users have requested for samples to play with. Microsoft already provides various samples across industry verticals to being with. Since the list of samples is spread all across the web, I have decided to collate them in a single post. Here is my list of Power BI Service & Desktop Samples available for download. [Read more…]
How to Create Troubleshoot and Resolve PowerBI Gateway Issues
The Power BI gateway is a Windows based application which allows you to connect to your on-premises data-source. Typically, you would need to install the application on an always-on server machine in the same network where your data-sources reside which you would need to connect. Power BI has become popular in the BI world and a lot of users use the gateway app. During the process of using the gateways, Users have faced issues either installing or trying to connect to a data-source. In this post, I am going to talk about how to create troubleshoot and resolve PowerBI gateway issues. [Read more…]
SQL Server Master Data Services Performance Tuning Guidelines
Master Data Services is a MDM (Master Data Management) system from Microsoft and ships as a part of the SQL Server distribution. Most of the computational tasks are done on the SQL Server side and hence SQL Server performance tuning is important for an optimal MDS deployment. In this post I am going to talk about the SQL Server Master Data Services performance tuning guidelines. [Read more…]
What are Data analysis expressions DAX with Examples
DAX is an expression language from Microsoft comprising of a collection of functions, operators, and constants that can be used in a simple excel based formula, or an expression. The only purpose of DAX is to calculate and return one or more values. DAX should not be confused as a programming language. Think of DAX as a formula language. You can use DAX to define custom calculations, calculated columns and measures. DAX helps you create new information and data insights from data already present in your data model. It is similar to MDX, but not exactly the same. In this post, I am going to talk about What are Data analysis expressions DAX with Examples. [Read more…]
Data Analytics in Excel 2016
- Extract Enterprise data easily using PowerQuery built into Excel.
- Supports New Data Sources like Hadoop, Azure HDInsight, SharePoint List, Relational Databases and much more.
- Data Shaping, Cleansing & Transformations
- Bringing data into the data model or to Excel sheets using PowerQuery & PowerPivot
BI Features in SharePoint 2016 On Premises
The BI features in SharePoint 2016 on premises have been unified, enhanced and more scalable. Unlike in SharePoint 2013, where you had to make a choice between Excel Services and Excel Web App, in 2016 you get a single solution providing all Excel web functionality including Self-Service BI. You can Scale-out only the “Office Online Server” farm to enable all Office web applications and BI capabilities. This has limited impact on the main SharePoint Farm from the performance perspective.
Excel Online now matches all of the new features which its counterpart on the cloud, aka Office 365 provides.
Excel Services are now a part of Excel Online 2016. Excel Online on Office Online Server 2016 (OOS) was formerly known as Office Web Application (WAC) Server.
Power Map Samples for Excel 2013 and 2016
Microsoft Power Map is an Excel based Add-In which provides a three-dimensional (3-D) data visualization tool that allows you to do deeper data insights. Using power map you can do insights which might not been seen in traditional two-dimensional (2-D) tables and charts.
You need to have a subscription for Microsoft Office 365 ProPlus, and excel installed. Power Map for Excel is a part of the self-service business intelligence tools from Microsoft. Whenever any new Power Map features and performance enhancements are released, you’ll get them as part of your O365 subscription plan.
Download Power Map Samples
Download Power Map for Excel 2013
For users who have Excel 2013, they need to download and install the Excel Power Map from the Microsoft website. For Excel 2016 users, Power-Map is already pre-installed as 3D maps.
There is a video that I found on YouTube which explains the PowerMap capabilities nicely. See below
Disclaimer: The data, opinions and content provided on this website is my personal opinion. Please visit the respective vendor website for official content and data.
SQL Server 2016 Business Intelligence Features
SQL Server 2012 and 2014 didn’t had many new features and functionalities as you would have liked. With the release of SQL Server 2016, brings you a complete revamp of features and functionalities with a steep learning curve. I have already spoken about High Availability Enhancements, Performance Improvements & Security Features on separate posts.
So, let’s explore the new BI features! [Read more…]