Skip to main content

Nisal


     

Big Data engineering and Business Intelligence Professional who has overall 10 years of experience in IT domain, and 8+ years of exposure to the Microsoft Business Intelligence/Analytics stack and data-driven culture. I'm very passionate about Data Engineering/Data Science/ Machine Learning, related tools, and technologies. In my professional life currently, working as an Architect - Data and AI at Zone24x7 where I mainly focus on building data products and advanced analytics solutions to allow customers to make business decisions more effectively and efficiently. I'm a Microsoft Certified Trainer with experience in conducting technical training programs. As a tech community contributor, I share my knowledge with the community by writing technical articles, and speaking at tech forums and conferences locally and overseas.

Specialties:
  •    Business Intelligence
  •    Data Warehouse design
  •    Database Design and development
  •    Microsoft BI (SSAS, SSIS, SSRS, Power BI)
  •    Dimensional modeling skills
  •    Data Analysis
  •    Could Architectures    
  •    Modern Data Warehousing 
  •    Big Data Engineering
  •    Data Lake Design/ Delta Lake 
  •    Data Science
  •    Machine Learning 
  •    Consulting
  •    Training 
  •    Team Management
  •    Leadership 
  •    Mentoring  








Contact Me 














Popular posts from this blog

How to Visualize Images Dynamically using Microsoft Power BI

One of the challenging part of the Power BI report development is handling dynamic images. We can add a static image within few steps and it is pretty straightforward. But, when it comes to dynamic images, available options are countable. Available options: Upload to the Web : You can upload the images to the web and use the image URLs as a reference. But, you need to make sure the data category  of your column where to store the image URL make it as  I mage URL. When we are dealing with clients data we cannot upload it to the public web. So, need to be accountable for data we are dealing with. Azure Blob Storage : If the security is the concern, you can use Azure blog storage to store image files. Only accessible who are in the same domain or security group. You have the full control over managing the authorization. I have an experience of, there are clients they never want to upload any data to the cloud. And if we are dealing with multiple clie...
49 comments
Read more

Run T-SQL Script Files Using Command Line

Most of the time when we need to execute a SQL script or statement, then we go for SQL Server Management Studio to execute our T-SQL scripts. But the same result we can achieve using Command Prompt. This is very simple way to do that just a matter of write a command and pass few arguments. You can see the process status like as in when you execute a query in Management studio. Use-case : There may be having some situations you won't be able to execute T-SQL script using Management Studio. Most of the time when doing data population. In my case, I had a situation I needed to populate a Database without using backup/restore. Once I generated script with all the schemas and related data it took around 400+Mb sql file.  SQL Server Management Studio will not allow you to run the script unless you execute the query in high-end box. Because, when the file loaded to the memory it will too hard to cater our requirement. You may probably get  memory ...
Post a Comment
Read more

Jump Start with Azure Databricks - Chapter 1

Azure Databricks is the latest and greatest way of processing Big Data in Azure cloud. It is an apache spark based analytics platform allow users to setup spark clusters with few clicks, streamlined workflows, collaborate with data engineers and data scientists. I’ve started to write a set of short articles to demonstrate step-by-step how to engage with Azure Databricks. As the first step, you will find how to get into Azure Databricks. Article 1: How to Create Azure Databricks Workspace How to Create a Azure Databrick Workspace Summary This is the first one of article series: Jump Start with Azure Databricks. In this context, I try to cover high-level aspects of how to getting started and play around with the databricks on Azure.  Please, leave a comment below your feedback, which will greatly help to improve my future work. 
33 comments
Read more