Articles by Mubin M. Shaikh (Articles: 7, Tip/Tricks: 5)

Articles: 7, Tip/Tricks: 5

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.71

Database Development
SQL Server	Create and Populate Date Dimension for Data Warehouse 4 Sep 2013 Updated: 4 Sep 2013 Rating: 4.88/5 Votes: 77 Popularity: 9.15 Licence: CPOL Views: 527,429 Bookmarked: 58 Downloaded: 11,553 Please Sign up or sign in to vote. This article shows how to create and populate date dimension for data warehouse.
	Learn to Write Custom MDX Query First Time 14 Jan 2014 Updated: 17 Jan 2014 Rating: 4.77/5 Votes: 91 Popularity: 9.29 Licence: CPOL Views: 357,603 Bookmarked: 76 Downloaded: 3,391 Please Sign up or sign in to vote. Learn Custom MDX Query Step by Step
	Create First SSRS Report with SQL Server Analysis Services OLAP Cube 20 Jul 2014 Updated: 20 Jul 2014 Rating: 4.88/5 Votes: 49 Popularity: 8.20 Licence: CPOL Views: 183,460 Bookmarked: 39 Downloaded: 1,925 Please Sign up or sign in to vote. This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube
Hosted Services
Azure	Export All Tables from Microsoft SQL Server Database in Flat File format (csv, txt) at one Go !! 14 Jul 2020 Updated: 14 Jul 2020 Rating: 3.94/5 Votes: 6 Popularity: 3.07 Licence: CPOL Views: 21,080 Bookmarked: 7 Downloaded: 334 Please Sign up or sign in to vote. Walkthrough of the process for one of the industry best practices to export all SQL tables in Flat file format
Programming Languages
SQL	Create First Data WareHouse 11 Sep 2013 Updated: 14 Sep 2013 Rating: 4.93/5 Votes: 133 Popularity: 10.32 Licence: CPOL Views: 565,870 Bookmarked: 136 Downloaded: 18,272 Please Sign up or sign in to vote. In this article, I am going to show you the importance of data warehouse.
Web Development
ASP.NET	Send Email Alert on Database Schema Change in SQL Server 3 Oct 2013 Updated: 4 Oct 2013 Rating: 4.75/5 Votes: 17 Popularity: 5.72 Licence: CPOL Views: 49,902 Bookmarked: 34 Downloaded: 12 Please Sign up or sign in to vote. Auto Monitoring On Schema Change within Database in SQL Server and Email Alert
HTML	Create First OLAP Cube in SQL Server Analysis Services 25 Sep 2013 Updated: 21 Jul 2014 Rating: 4.83/5 Votes: 281 Popularity: 11.76 Licence: CPOL Views: 1,029,978 Bookmarked: 201 Downloaded: 31,791 Please Sign up or sign in to vote. Learn creation of OLAP Cube in SSAS (SQL Server Analysis Services) using Microsoft BIDS (Business Intelligence Development Studio) Environment and Data Warehouse

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.96

Database Development
SQL Server	Create & Populate Time Dimension with 24 Hour+ Values [Tip/Trick] 25 Aug 2013 Updated: 5 Sep 2013 Rating: 5.00/5 Votes: 31 Popularity: 7.46 Licence: CPOL Views: 117,597 Bookmarked: 21 Downloaded: 3,378 Please Sign up or sign in to vote. Create time dimension with 24 hour plus values and time buckets in your data warehouse
	Introduction to Named Query in Sql Server Analysis Services [Tip/Trick] 29 Sep 2013 Updated: 29 Sep 2013 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 27,602 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Create Named Query in Data Source View While Designing OLAP Cube in SSAS
	Introduction to Named Calculations in SQL Server Analysis Services [Tip/Trick] 30 Sep 2013 Updated: 30 Sep 2013 Rating: 4.83/5 Votes: 3 Popularity: 2.31 Licence: CPOL Views: 42,720 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Create Virtual Column Using Named Calculation in SQL Server Analysis Services
	Run All Subscription Reports At Once in SSRS Manually [Tip/Trick] 24 Aug 2013 Updated: 5 Sep 2013 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 39,689 Bookmarked: 5 Downloaded: 89 Please Sign up or sign in to vote. Manually Run SSRS Scheduled Reports
Programming Languages
SQL	Manually Run All Subscription Reports in SSRS At Once [Tip/Trick] 24 Aug 2013 Updated: 24 Aug 2013 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 12,991 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. How to manually run all subscription reports in SSRS at once

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Mubin M. Shaikh

Architect Cybage Software Pvt. Ltd.

India

Microsoft® Certified Professional (Microsoft Certification ID: 8918672).

Microsoft Certified Technology Specialist with more than 16+ years of expertise to architect and implement effective solutions for Data Analytics, Reporting and Data Visualization solutioning need on Azure Cloud or On-Premise

Technology :
Azure (Data Lake, Data Factory, Synapse Analytics, Databricks, SQL),
Microsoft BI (SSIS, SSAS, SSRS, SQL-Server), C#.Net, Pentaho,
Data Warehousing, Dimension modelling, Snowflake DW, SQL DW, MySQL
Data Visualization using (Tableau, Power BI, QlikView, Pentaho),
Domain : Sales, Retail, CRM, Public Transport, Media & Entertainment, Insurance
Data Integration and Analytics Experience with MS. Dynamic CRM, Salesforce CRM, Dataverse, SAP- FI, Dynamics AX etc.

Linked In Profile:
Click Here to View Linked In Profile

Change will not come if we keep waiting for some other person !!, or keep waiting for some other time !!, We are the one we are waiting for, We are the change that we are looking for.

Articles by Mubin M. Shaikh (Articles: 7, Tip/Tricks: 5)

Articles: 7, Tip/Tricks: 5

Average article rating: 4.71

Database Development

Hosted Services