Farooq Aziz

Farooq Aziz has extensive experience as a data analytics solution architect with a Bachelor of Business Administration degree and an Associate of Science degree. He holds certifications including Microsoft Certified: Data Analyst Associate, Microsoft Certified: Azure Data Administrator, AWS Partner: Sales Accreditation, and AWS Partner: Technical Accreditation.In various roles, including Managing Consultant, Principal Consultant, Advisory Software Engineer, and Business Intelligence Consultant, Farooq has designed and architected business intelligence standards, policies, best practices, adoption roadmaps, and operating models for enterprise clients.He specializes in leveraging data analytics to provide valuable insights to both existing and potential clients, creating new business opportunities and enabling clients to make more informed decisions for their growth. Farooq has built data models in Power BI, Crystal Reports, SSAS Tabular, and SAP BO Universe, and performed complex transformations in Power Query.He has also implemented Power BI embedded reports for customers and organizations, presented POC and solution designs on data analytics platforms to prospective clients, and published articles on business intelligence technology community platforms to educate global data analytical professionals about possible data analytical solutions and best practices.
  • Tagline: Data Analytics Business Intelligence
  • Interests: Data Analytics, Business Intelligence, Business Analytics, Healthcare Analytics, Retail Analytics,
  • Jobs: Business Intelligence and Data Analytics Consultant
  • Skills: Power BI, SSAS Tabular, SAP BO, Cognos, Data Architect, Data Modeling, Data Governance, Business Intelligence Framework

All authors

All authors

Blogs

Identity Columns Can’t Be Updated: #SQLNewBlogger

By

I’m not sure I knew identity column values could not be updated. I ran...

Rolling Back a Broken Release

By

We had an interesting discussion about deployments in databases and how you go forward...

A bespoke reporting solution doesn’t have to cost the earth

By

You could be tolerating limited reporting because there isn’t an off the shelf solution...

Read the latest Blogs

Forums

SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0

By tim8w

SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

Creating JSON III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON III

Visit the forum

Question of the Day

Creating JSON III

In a SQL Server 2025 table, called Beer, I have this data: 

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin
I run this code: 
SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;
What are the results?

See possible answers