In this series we look at building a Streaming ETL with Azure Data Factory and CDC – Enabling CDC. This is Part 1, The rest of the series is below. Enabling CDC Setting up Audit Tables Provisioning Azure Data Factory Provisioning Azure Blog Storage Create Data Source Connection in ADF Create Incremental Pipeline in ADF … Read more
If you need to connect your Azure Data Factory to an on-premise SQL server you will need help Setting up Azure Data Factory Integration Runtime for On-Prem Connections Set up On-Prem Integration Run Time Click on Author & Monitor from Azure Data Factory Create two new linked services Linked Service to Database. Since we are … Read more
When building drill to / drill thru reports in Power BI Paginated Reports & Multi Select URL Parameters, the best way to do this is using an Action URL as the basic default linking does not work. Here are the steps to call a child report using multiselect parameters to a child report. Side Note: … Read more
The SDLC process is a core part of having a well governed Power BI environment. Let’s take a look at Setting up Power BI Deployment Pipelines and Parameters Side Note: Want to learn SQL or Python for free. In less then 10 minutes a day and less than an hour total? Signup for my free … Read more
Power BI’s On-Premises Data Gateway acts as a bridge between on-premises data such as a SQL Server and Microsoft cloud services. A Power BI Gateway is installed on computer (preferably a VM) that has the capacity to handle brokering data between the database or data source and app.powerbi.com. But for a simple tool, things can … Read more
If you long for the days for pixel perfect reports of SSRS or Cognos but find yourself lost in the world of Power BI’s and Tableaus, this post is for you. Some times these new tools just cannot do the job of exactly formatted canned report runtime queries that the older tools used to be … Read more
If you are planning to use Power BI on top of Denodo sometimes a base view or a Power Query won’t be enough. If you need to embed your own complex query to pull data from Denodo, there are a few items you must be aware of. See below on how to Direct Custom SQL … Read more
Yardi can be a very complicated tool and with all the modules and features to set up, It is important you know How to find the best Yardi Consultant. Modules such as investment manager, rentcafe, or just basic task as setting up an account tree should be done correctly so that your real estate business … Read more
Interview questions can range far and in between a large range based on the person, company, and level you are interviewing for at a consulting firm. First round of interviews are probably one-on-one interviews and it is best to prepare ahead of time. Let us look at some popular Interview Questions for Entry Level Consultants … Read more
Sometimes you do not want to spend money to do things are are really easy. Tools like Hootsuite or Buffer can run you 100’s a month for something you can roll out yourself for free and a hour or so worth of work. Let’s learn how to Automate your Twitter with API and Python Setting … Read more