tag:blogger.com,1999:blog-62998009288570063642016-09-20T08:51:34.925+05:30 Power BI, MSBI, SQL Server and more..DJhttp://www.blogger.com/profile/13141041465472307938noreply@blogger.comBlogger41125tag:blogger.com,1999:blog-6299800928857006364.post-35924350914621921292016-09-20T08:46:00.003+05:302016-09-20T08:51:34.940+05:30

DJhttp://www.blogger.com/profile/13141041465472307938noreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-52744354283084624862016-03-07T04:22:00.001+05:302016-03-09T09:46:10.472+05:30

Power BI Desktop is a client side report authoring tool which is intuitive and powerful for some stunning Power BI visuals. It allows you to quickly mash up the data from a multitude of sources, shape it and create amazing reports. Below is a step by step procedure of creating your first report in Power BI desktop. Creating your first report in Power BI desktop: Install Power BI desktop:  Power

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-3730168620152272342016-03-06T08:11:00.000+05:302016-03-06T08:49:51.483+05:30

During one of our analytics summits' visualization competition, we were given a fictitious grand-slam dataset to model, analyze & visualize. Below is the analysis I have done using only Excel 2013 built-in components -  Power Pivot and Power View which got me great rewards and recognition :) I have divided my analysis into few levels - Tournament level, Individual game level and Player level.

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-41719443167581794382013-04-05T09:59:00.002+05:302016-03-06T08:13:55.202+05:30

This post is continuation to my earlier post on Power View enhancements came up with SQL Server 2012 SP1. In this post, I am going to introduce the much anticipated features like KPI's, Hierarchies, and drill down/ups in the power view reports. In this post also, I am not going to give much explanation as you can understand better from images. Key Performance Indicators (KPI's): Before SP1,

DhanumjayRamiReddynoreply@blogger.com1tag:blogger.com,1999:blog-6299800928857006364.post-91116854349359909972013-04-05T09:56:00.003+05:302016-03-06T08:14:22.847+05:30

Update: I have written part-2 of this artcle which you can read from this link. Few days back, SQL Server 2012 ServicePack1 was released. It came up with many new features. In this post I'll concentrate on the new features it has brought to the power view (a web based reporting tool which can be launched from SharePoint / it's now also there in Excel 2013) visualizations. I'll take you

DhanumjayRamiReddynoreply@blogger.com1tag:blogger.com,1999:blog-6299800928857006364.post-41175047190872579652013-04-05T09:54:00.001+05:302016-03-06T08:14:54.933+05:30

Using SQL Server Management studio (SSMS), I have created a new login with user name and password using SQL Server authentication. When I have tried to connect to SQL Server with the newly created login, I get the following error. Error: A connection was successfully established with the server, but then an error occurred during the login process. (provider: shared memory Provider, error: 0 -

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-15682141091751744112012-09-18T15:50:00.002+05:302016-03-06T08:15:18.319+05:30

Suppose a business has a database containing the users and their friend's details. As in facebook, we may want to identify the friends of our users and send the notifications about product details to them.This post shows how to get the friends of our users up to the required level using T-SQL. I have created a database 'friends' as shown below which contains the usernames and their

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-35724126852627084012012-08-31T17:01:00.001+05:302012-08-31T17:04:11.127+05:30

As we saw in my earlier post, indexes are organized as B-Trees and they make the accessing or retrieving the data faster and easier. But the insert part is trickier which I am going to explain in this post. As I said B-Tree is self-balanced, meaning that it automatically adjusts when we add data so as to make the tree balanced. One thing we need to know is these nodes in B-Tree are

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-48847088887353078822012-08-31T16:57:00.004+05:302012-08-31T17:03:54.001+05:30

Indexes organize the data in the table in a particular order to make accessing the data easier and faster. As we know, they are crucial in performance tuning exercises. However we need to be careful while creating and using indexes as they can degrade the performance also. I am going to write a series of posts on my understanding of indexes. My series of posts include concepts like:

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-23619087662681297222012-08-10T12:19:00.001+05:302012-08-10T12:20:34.564+05:30

With SQL Server 2012, we (BI developers) have a choice to choose between multi-dimensional and tabular models. Also we have a choice to choose the languages, MDX or DAX. We can query multi-dimensional and tabular models using either DAX or MDX. The issue: Now the issue is, we use SSMS to write DAX / MDX expressions to query the model. But, it was originally designed to suit the

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-61095341005175046942012-08-08T12:32:00.001+05:302012-08-08T12:41:56.061+05:30

Before reading this post you should read my earlier post on Stream Insight architecture and basics. As I said earlier stream insight processes streams of events coming from multiple data sources. To work with Stream Insight it is important to know about streams, events and how they are structured.  In this post I am going to write on streams, events and their structures. Streams: In

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-90601274881860216422012-08-02T17:45:00.002+05:302012-08-07T17:26:25.143+05:30

Sometimes we need to work with the data as it comes (in real time). Few examples I can outline are, sensor-based observation, where have to react as soon as we know something unusual/wrong happens Monitoring and capitalizing on current market conditions with very short windows of opportunities. We have been reading in newspapers recently , about power grid failures because of high

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-52838804446585013882012-07-02T21:17:00.002+05:302012-07-02T21:20:53.567+05:30

Recently, I have got a mail from my friend asking for posts or resources to learn Power Pivot . So I have decided to dedicate this post to provide the best possible links/resources (to my knowledge) to learn power pivot quickly and work with it on your own. This post should guide anyone who are new to Power Pivot as I have learned this way.  1)  What is Power Pivot?       What is Power

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-88644170326614431532012-06-28T20:07:00.000+05:302012-06-28T20:25:33.695+05:30

Thanks to pscorca from msdn forums for steering me to write this post. He asked this question in the msdn forums which was a bit interesting so I decided to work on it.  The actual problem here is,  inside excel there are options to sort alphabetically (A to Z / Z to A) and sort as per source order. There is no option to custom sort directly in Excel so I decided to solve the issue from the

DhanumjayRamiReddynoreply@blogger.com4tag:blogger.com,1999:blog-6299800928857006364.post-22097593780418167872012-06-20T16:10:00.000+05:302012-06-20T16:40:55.682+05:30

As humanbeings, we sometimes tend to forget small things such as the instance names of SQL Server (or) you have been assigned a new SQL Server machine to work with but you don’t know instance names. Whenever you try to connect to SQL Server you get the below error.   Then instead of going for others help to know the instances available, here is a simple trick. Click on cancel in the

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-11916949725565165382012-06-19T17:49:00.003+05:302012-06-19T18:30:51.273+05:30

Dynamic Mangement Vews and Functions (DMVs and DMFs) are very much helpful for the developers to get the internal and instance specific data. There are almost 140+ of those which can be advantageous while working  with SQL server. You can get all the DMV's by writing this query. select * from sys.system_views where name like 'dm%' To know more about DMV's check this link.Today, while I am

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-27507253606660516142012-05-21T16:15:00.002+05:302012-06-01T09:28:12.938+05:30

With the release of SQL Server 2012, Microsoft introduces an excellent user-friendly reporting tool called "PowerView". PowerView is more striking compared to other reporting tools in the following aspects; Visualization, Performance, Interactivity, Intuitiveness, Presentation. In this post, We will delve into each of those aspects. Visulaization: Power view is a silverlight based reporting

DhanumjayRamiReddynoreply@blogger.com1tag:blogger.com,1999:blog-6299800928857006364.post-7005364164934706942012-05-18T17:10:00.003+05:302012-05-18T17:35:24.878+05:30

Whenever many people are accessing the same database at the sametime, the DBMS should take care of all the transactions in a way that no transaction could adversely affects other transactions. This is called concurrency control. Normally this would be done using locking and isolation levels. Locking means, Whenever a user accessing a resource that would be locked until he completes accessing

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-22474347366339058132012-03-21T14:45:00.000+05:302012-04-26T18:12:54.510+05:30

We know how to interact with the analysis services using Excel 2010. Since Excel uses multi-dimensional interface it works with multi-dimensional models quite comfortably. But what if it needs to interact with tabular models. Even if we connect to the tabular models do they understand MDX queries which are sent by Excel 2010? Open Excel 2010 and go to "Data" tab in the top ribbon and

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-61883864691464806412012-03-21T14:12:00.000+05:302012-04-26T18:03:32.403+05:30

In my earlier post we have seen how end users can interact with the models in a common way irrespective of the type of model (tabular/multi-dimensional) because of the hybrid nature of BISM. Here I am going to show you the hybrid nature of BISM with a great example. I am going to interact with the same tabular model with Excel and PowerView and show you the hybrid nature of it.Interacting

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-9486106278721297602012-03-21T12:52:00.000+05:302012-04-26T18:22:09.442+05:30

SQL Server Analysis Services from Microsoft is one of the best BI platforms in the market. But there are some issues with this. One of them is it only supports multi-dimensional modeling which is not easy for the developers to design, more over it uses MDX (Multi-Dimensional expressions) to query the model which is very tough to learn. To overcome this, with SQL Server 2012 Microsoft

DhanumjayRamiReddynoreply@blogger.com0tag:blogger.com,1999:blog-6299800928857006364.post-66566471052554358602012-03-08T10:43:00.000+05:302012-04-26T18:21:45.080+05:30

The much awaited SQL Server 2012 was released yesterday. For more information check out this official blog post. You can download the evaluation edition of SQL Server 2012 here. It is coming with a ton of prominent and exciting features. As I have been working on BI part, this post gives a good initial look at new features in BI part. The brand new BISM model is introduced in place of

DhanumjayRamiReddynoreply@blogger.com1tag:blogger.com,1999:blog-6299800928857006364.post-52693230469548111632012-03-07T18:58:00.001+05:302012-05-23T15:49:10.671+05:30

Before reading this post you should read my earlier posts in this MDX series (you can get earlier posts by clicking on MDX label). In this post we are going to look at an important function in MDX--- DESCENDANTS (). As demonstrated in my previous post, using MEMBER & CHILDREN we can't drill-through all the levels in a hierarchy. To accomplish this, DESCENDANTS function is required. This

DhanumjayRamiReddynoreply@blogger.com1tag:blogger.com,1999:blog-6299800928857006364.post-16822341546405413852012-03-07T18:57:00.001+05:302012-05-23T15:50:01.728+05:30

Before reading this you should read my earlier post on MDX basics. In this post we are going to look at some more useful and important functions in MDX like CHILDREN, DESCENDANTS etc. In the earlier post we have used MEMBERS function. It returns the members of specified dimension or a dimension level.  Now we are going to look at CHILDREN function which returns the child members for a

DhanumjayRamiReddynoreply@blogger.com4tag:blogger.com,1999:blog-6299800928857006364.post-73956410683693647392012-03-07T17:03:00.001+05:302012-05-23T15:50:50.239+05:30

SQL Server Analysis Services (SSAS) provides an easy way to analyze the data you get through transactions. SSAS organize and stores the data in a multi-dimensional structure/cube for rapid response to user queries. To query those multi-dimensional structures SSAS provides a full-fledged language with highly functional syntax called Multi-Dimensional eXpressions (MDX). I am planning to write a

DhanumjayRamiReddynoreply@blogger.com1Hyderabad, Andhra Pradesh, India17.385044 78.48667117.142593 78.170814000000007 17.627495 78.802528