Implementing Role Based Access for PowerPivot

This has been a very long week, and I have written a paper which will guide you step by step in implementing role based access for PowerPivot. You can download the file from here.   Share your feedback’s and comment’s below

0

Analyzing LinkedIn Connections using Spatial Query!

Let me confess before I even start! I am an hardcore LinkedIn fan. I love to connect with people who have a similar passion for Technology,Share my thoughts and learn from others experience.   As all of you might know,I am an Analytics Guy and always intrigued by numbers. This led me to understand my…

0

Sparse columns, An oblivious for any data/dimensional modeler !

Have you anytime been knocked on the head by the client on how can you as a data modeler taken actions to reduce space usage in the server? One of the most oblivious to any data/dimensional modeler is the efficient way of minimizing the space used by the database on the disk. So how can…

1

Analyzing Aliens preference using Powerview

The day I watched Aliens, I was always fascinated about that topic. More than Aliens I was more interested in Crop Circles. Crop Circles in particular because it has a lot of fallacy ( As I believe in Aliens!) 🙂 and also due to the reason of its complexity and geometry involved in it. So, I took up a…

0

The Davinci code ( SQL Cryptology)

    Late night, Sitting under the A/C duct relaxing I could hear a grunted words from a near cubicle About a strange requirement which requested by a customer. Keeping my curiosity at bay I thought its not my business …   It dint stop there ! I could here a disappointed words from another…

0

Dynamic Dashboards in Performance point services 2010

For a long time  I wanted to share this  information with the report developers .Performance point services allows you to create dynamic dashboards which means you can connect a scorecard and a report and make each other interdependent. Below are the step by step guide Step 1.Create scorecard has “sales territory” in the rows .    …

1