Ousama EL HOR is a Data & B.I Consultant based in France. He is passionate about SQL Server, Business intelligence, Azure Platform, Power BI, new technologies and more. He loves to share his knowledge, help others and also learn from others as he believes everyone has something which can be learned. In the last years he has been working on multiple MSBI projects using SSIS, SSAS, SSRS with SQL Server and designing, implementing data warehouse projects and administrating of SQL Server.


This is a "User Page" (click for a list of all user pages on TechNet Wiki). User pages on TechNet Wiki exist for the following reasons:

  1. To link to these pages from various online profiles, blog posts, etc.
  2. To allow collaboration on filling out such information.
  3. To allow easy editing for filling out such information.
  4. To act as an aggregation or collection of links that help define what a person does.


Ousama's TechNet/MSDN profile:

↑ Return to Top


Ousama regularly participates in the following Microsoft TechNet forums:
Leaderboard of Database Systems contributors on MSDN: 

↑ Return to Top


Ousama shares his knowledge around SQL Server, SSIS, SSAS, SSRS, Power BI and Azure Platform:

↑ Return to Top

TechNet Wiki

Articles authored: 
  2. What is fragmentation in SQL Server ? - B (Guru Awards - October 2017)
  3. SSRS : Create custom reporting map
  4. SSAS : Parent-child dimension - S (Guru Awards - October 2017)
  5. MPP & Distribution in Azure SQL Data warehouse
  6. Dynamic management of SSAS partitions with SSIS - G (Guru Awards - November 2017)
  7. Power BI : Create a custom Map - G (Guru Awards - April 2018)
* G - Gold, S- Silver, B - Bronze

↑ Return to Top

TechNet Wiki Awards

Top Contributors

TechNet Guru

↑ Return to Top

Code Gallery

Ousama has made the following contributions to the Code Gallery:

↑ Return to Top


Ousama has the following certifications:
  • MCSE: Data Management and Analytics   [13/2018]
  • MCSA: BI Reporting   [13/2018]
  • Microsoft Professional Program : Big Data   [11/2017]
  • MCSA: SQL 2016 Database Development   [04/2017]
  • MCSE: Data Management and Analytics   [03/2018]
  • MCSA: SQL 2016 Business Intelligence Development   [03/2017]
  • MCSE: Data Platform   [12/2016] 
  • MCSE: Data Management and Analytics   [09/2016]
  • MCSE: Business Intelligence   [04/2016]
  • MCSA: SQL Server 2012/2014   [03/2016]
  • MCPS: Microsoft Certified Professional   [04/2012]
  • MCTS: SQL Server 2008, Database Development   [08/2011]
  • MCTS: .NET Framework 4, Web Applications   [06/2011]
Microsoft Certification Profile:

↑ Return to Top


If you need to contact Ousama, just leave a comment on this page or you can reach him through the below :

Email:       elhor.ousama@outlook.com
LinkedIn:  https://www.linkedin.com/in/ousama-el-hor/
Twitter:     https://twitter.com/o_elhor

Facebook: https://www.facebook.com/ousama.elhor

↑ Return to Top

See Also

↑ Return to Top