General Inquiries
(281) 624-6864
Home | Articles by: admin
Project Manager, Stafford, TX: Responsible & accountable for managing & delivery of end-to-end large scale info tech projects including technical team mgmnt, deliverables, resources & capacity planning using Azure DevOps, MS Project, Primavera tools. Provide domain knowledge on implementation ofMore…
Lead Software Engineers, Stafford, TX: Participate & lead dev teams in construction, implementation & support of s/w. Design apps & systems based on business reqs documentation & architectural designs. Analyze, code, test, & debug apps. Create system prototypes, create abstracts,More…
Thanks to everyone who attended my short presentation on “Learning Microsoft BI – Where to Start?”. Following is the link to download presentation slides. Learning Microsoft BI – Where to Start Thanks to everyone who encouraged me. I will beMore…
When designing ETL solution for a data warehouse, it is very important to make sure your ETL process is optimized. We usually Extract data from one or more data sources, Transform the data by applying data transformations and then LoadMore…
Calling a sub-report when user clicks on detail row cell of a Tablix control is straight forward. You can right click on the detail cell, select textbox properties. Select Action and then select ‘Go to report’ option. Select the reportMore…
Loading Dimensions Using SSIS Packages This blog is continuation of my previous blog Migrating Data From Hyperion to Analysis Services – Part 1. In this blog we will discuss how to load dimensional data into the Warehouse database. The dimensionMore…
On 2nd day of PASS Business Analytics Conference, Microsoft announced a new 3D analytics tool “GeoFlow” for Excel 2013. GeoFlow is a powerful 3D visualization tool which used data from PowerPivot or Excel data model to plot up to aMore…
Extracting data from Hyperion Essbase I recently did a project where we moved dimension and fact data from Hyperion Essbase to SQL Server Analysis Services. In general we cannot use an OLAP cube as a data source for another cube.More…
I came across an interesting scenario to troubleshoot in Analysis Services. When I was browsing cube, I was not getting any values for any of the measures. I looked into the data source view and checked all relations. I checkedMore…
SQL Server 2012 developers training kit is an excellent resource for developers and administrators to get familiar with new features and key improvements in SQL Server 2012. It has technical presentations, demos, hands-on labs and videos to implement database andMore…
