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 Add My Power BI Report in My PowerPoint Presentation?

Had a great week after conducting two-day sessions on Data Warehousing and How to do Business Intelligence with Microsoft Power BI . During the sessions, I got an interesting question from the audience. The question was “how its possible to show the Power BI report or visuals in my Powerpoint slides, at the same time the data need to be up-to-date same as in report”. I love these sort of questions and find solutions because these are real-world problems they have. I thought to write a simple post to address that problem, and in this post, I explain how to achieve it. Pre-requisites You have already Power BI report created and published to the Power BI service. If you missed how to do it read this blog . If your source is a file like Excel or CSV the deployment is even simple. You don't want to worry about to configure the gateway and you can simply click Publish and publish your report. Steps to Follow Open the MS PowerPoint and go to Insert tab and My-Addins It will ...
2 comments
Read more

Get Started with Azure Machine Learning

Azure Machine Learning is a Microsoft cloud solution which allow us to do end-to-end experiments using the samples, experiments provided. Further, it allows us to write custom algorithms using popular data science languages like R and Python.  Lets start to create preview account on Azure and create Azure Machine Learning Experiment workspace. Microsoft gives 30 days trial period for free to do experiments on Azure. You can start to create an Azure account from here. When you sign-up you might need to provide credit card details that only for validate the user. As far as I know we only need to pay if we are going to upgrade the free subscription for Pay-as-you-go model. Lets start to create a machine learning experimentation. For that click on left down below "More services" and from the search bar, type "Machine Learning". Then click the Machine Learning Experimentation in order to create new environment. Then it will open new blades to provide d...
1 comment
Read more

How to Create a Date Table in Few Steps Using Power BI

Calendar Dimension or Calendar Table is one of the crucial table in a Power BI model. I never have seen any data warehouse data model which does not have a Calendar table so far in my development. Because, when it comes to data warehousing or dimension modeling you may storing various business processes or events as Facts. So those events anyway occur in particular date or time. So simply there wouldn’t be a Power BI data model without a date table. In this post, I’m going to share with you how to create a date table within few steps. Actually, there are two DAX measures which we can use to create a date table. Calendar(DAX) and CalendarAuto(Auto). Calendar(DAX) = You can pass start date and End date as parameters you need to create date table. CalendarAuto(DAX) = You can use this function without passing any parameter. Then it will generate the dates based on your data model dates.  You can simply copy the below DAX code and paste in your Power BI Desktop DAX e...
7 comments
Read more