Profile
Data is the most essential commodity for the next generation. I worked with the data for many sectors throughout my career. It amazes me how the data is getting extracted, transformed(cleansed) and Loaded into the powerful engines before being served to the next available customer. Often businessess never have the clear visibility into business. I use better resources and strategy to put all those pieces at your fingertips, so you can make the job faster, more effective decisions for your business.

Three Key element I always use to for better deliverance to all my clients.
Strategy - I always assess, plan and build a roadmap by begin with the end in mind.
Architecture - We as a partner will always discuss on for best approach to move to the cloud, modernise or scale the business solutions for the best approach towards visulasing the data.
Implementation - Several methods of implementing a high quality output through Microsoft PowerBI, Sql server data tools.

Workflows

Automation on Data

  1. Microsoft Azure- Cloud services, Azure SQL DB.
  2. Powerapps- App designer, Logic flow designer and app service management.
  3. Microsoft Flow- Triggers, approvals logics, conditions set and automate processess.

Data Development

  1. PowerBI- Powerpivot,powerquery,M-language, DAX, Visualisation tricks, Report server.
  2. Reporting Process- Report processing, Model processing, Scheduling.
  3. Analysis Process- MDX queries, Facts and Dimensions, KPI Indicators, Partitions,Aggregations.
  4. ETL Process- Conditional split, Merge, Multicast, Aggregate.
  5. T-SQL- Joins, Keys, Performance tuning, Query Optimisation techniques, Index, Stored Procedures, Views, Triggers.
  6. Machine Learning- R, ggplot, shinysheets

Apart from this, I am an ardent fan of books and failure. I read a book each week, fail each week and I always try to rejuvenate my work each day.

You can find me always here:

  




Difference between Database Dimension and Cube Dimension in SSAS

12-June-2019

In SQL Server Analysis Services, there are Two types of Dimensions

Database Dimension
Cube Dimension
Database Dimension in SSAS
All the dimensions that are created using the Dimension Wizard of the Solution Explorer are treated as database dimensions. In other words, the dimensions which are at Database level are called Database Dimensions.

Database dimensions are independent to the cubes so single Database dimension can be used in multiple cubes. Please refer Create Dimensions in SSAS article to understand, How to create Database Dimensions in SQL Server Analysis Services

From the above figure, all the dimensions such as Dim Customer, Dim Product etc.., which are placed under the Dimensions folder are Database Dimensions.

Cube Dimension in SSAS
A cube dimension is an instance of a database dimension within a cube. Cube dimension are accessible inside that particular cube, We can’t access cube dimension in another cube. Please refer Create Cube Dimension in SSAS article to understand, How to create Cube Dimensions in SQL Server Analysis Services.

 


WE ALWAYS WORK WITH :