In simple words, Azure Data Factory is nothing but an Extract, Transform and Load (ETL) tool, which does more than what an ETL tool can usually do and has been designed for the Cloud technology. You may say it’s a data integration service in the cloud. It’s just two and half years old kid of the Azure team, which is getting mature with the passage of time.
As per the MSDN documentation, Azure Data Factory is a cloud-based data integration service, to compose data storage, movement, and processing services into automated data pipelines.
From a BI developer perspective, it just a Cloud-based ETL tool. You can design connections (Linked Services), data store schema (DataSet/Table) and an Activity, which help you to connect to a data source, pull the data out, transform it and then dump into a data destination. The beauty of this tool/service is that it can connect to diverse data stores i.e. relational to non-relational, big data to analytical data, which is very difficult to process using existing ETL tools such as SSIS or Informatica. And, the bonus is we can utilize Azure services i.e. Hardware/Software to improve the performance of the pipelines.
I have just given you an brief overview of Azure Data Factory. Click here if you wish to know more about it.
Yes! I begin to write about the Cloud, the buzzword… 🙂 Will be writing on the Azure Data Services and the Data Factory…Stay tuned!
Wow! Just amazing!
Power BI can connect to anything and everything on this planet. Not much to write over here about the data sources supported by the Power BI. Just take a look at below images.
Power BI Desktop team provides upgrades in the first week of every month, earlier it was scheduled at the end of every month. Keep you Power BI Desktop upgraded all the time n get all new Data Sources released, if any. It’s just amazing to connect to so many different types data sources using this tool. Good job team!
Yes! There is difference between the SQL Server Reporting Services (SSRS) and the Power BI.
The bottom line is the SSRS is the developer-oriented enterprise-level reporting/visualization tool while the Power BI is client-oriented Self-Service BI tool. I’m sure this statement makes it pretty clear what I am going to say next.
SSRS is the developer-oriented tool means you need to know how to design a report, get the data from the data source and deploy it. If any change is required in the report, it should be done by the developer of the report and redeploy back on to Report Server. This creates a lot of problem when the client wants to view data from different perspectives. He has to come back to the development team and request for the same. The client has no control over report designing and digging out the data himself, at any point in time. And, that’s why lots of clients prefer to analyze financial and statistical data using Microsoft Excel tool, perfect for them.
Let me put it in simple words – Pay us and use Power BI visuals in your app, out-of-the-box. No Office365 subscription required. That’s it!
If you wish to use Power BI, you need to have Office365 subscription with you. Even if you wish to share the reports/dashboards with the client, you need to get him an Office365 subscription for him. It means pay up, and then you can bring your client in your network. That’s how he can use the Dashboards/Reports in Power BI. But, what if wish not to buy Office365 subscription for him? Can he still look into the Dashboards/Reports???
Yes, very much possible now. And, that’s where Power BI Embedded comes to your rescue.
Power BI Embedded is a part of Microsoft Azure infrastructure. It helps you to use REST APIs and the Power BI SDK to call the data visuals into your app. Yes! You need to pay for that as well but you can definitely share your visuals out-of-the-box i.e. Power BI Service. If you wish to use Power BI Embedded, the Microsoft Azure is the place to start off.
I tried this component and I think it’s pretty good. More to explore yet!