About

Welcome to BIInsight.

My name is Soheil. I started working in IT industry from late 90s. During my journey, I’ve done lots of different interesting IT projects. From programming with Delphi 5 and 6, Paradox database, SQL server 7, to creating beautiful and flashy dashboards in Tableau software and Power BI. In the beginning I’ve done several projects involved with Delphi, SQL Server 7, SQL Server 2000. My first experience with SQL Server Analysis Services was in 2004 when I designed a database for a cost control project and a colleague asked me to create something like an Excel pivot table. The database was designed in SQL Server 2000 and I was thinking of writing a T-SQL codes to meet the requirements. I searched a lot around this and finally I found the answer which was Analysis Services. Fantastic!

After that I got involved with Microsoft BI  stack gradually. Like when I needed to integrate tons of flat files and put them all together in a SQL Server database. DTS 2005 was the magical solution. Yeaay!

As a senior Business Intelligence Consultant I have concrete experience in the following areas:

  • Conferring with clients to identify their requirements, conducting business intelligence best practices and providing professional consultancy on business intelligence systems strategies, policy, management and security
  • Design, develop, integrate and implement business intelligence solutions including:
    • Relational database design and implementation in SQL Server
    • Designing and implementing data warehouses (Kimball approach)
    • ETL solutions using SQL Server Integration Services (SSIS) and Power Query
    • Business Intelligence Semantic Model (BISM) tabular and multidimensional models using SQL Server Analysis Services (SSAS) and PowerPivot
    • Data visualisation and data analytics using SQL Server Reporting Services, Microsoft Excel, Power View, Power Map, SharePoint Performance Point and Tableau Software
    • Data visualisation with Power BI Desktop and Power BI Service
    • Providing professional consultancy for Cloud BI based on Microsoft Azure technologies

I learnt a lot from the internet so I’m willing to share my knowledge and I hope I can help somebody somewhere.

Cheers!

6 thoughts on “About”

  1. Hello Soheil,

    It was very informative post on Power BI. I would like more post in Power BI, Which will be helpful for people like me to get an more insight and try to implement in our works.

    I would like to know about the gateways, How to setup the reports in Power BI & All.

    Once again thanks for your efforts..

    Cheers..

    1. Hi Lokesh.
      Welcome to Biinsight and thank you for nice words.
      You can find some information about “Power BI Personal Gateway“.
      I’ve also written another post awhile ago named “Refreshing ON-Prem SQL SERVER Database on Power BI using Power BI Personal Gateway” which expresses some more information about the “Power BI Personal Gateway”.
      I’ll post about Microsoft Power BI Analysis Services Connector in near future.
      You’re most welcome to subscribe my website to be informed about new posts.
      Cheers

      1. Thanks Soheil, I am looking forward to it.

        I want to know i am exploring some of the topics , i have one doubt can we setup Power BI personal gateway in the same system where like local system and the schedule refresh is showing disable .. Can you help me out

        1. Welcome back Lokesh.

          I encourage you to read this post.
          Check if the user you use to run the gateway has sufficient access rights.
          Please note that on-prem data refresh is a BI-Pro feature so you need either buy a BI-Pro licence or use it for free for a two months trial period.
          Cheers

Leave a Reply

Business Intelligence and Data Visualisation Articles