Connect to Excel Data Source in Power BI Microsoft Power BI is a data visualization and Business Intelligence application. It can connect to variety of data sources. In this blog, we will discuss how to Connect to Excel Data Source in Power BI. For this exercise, download a free version of Power BI Connect to…
Read More
Learn What and How of Tableau If you are new to Business Intelligence and data visualization, use this blog to Learn What and How of Tableau. Gartner placed Tableau in the leadership quadrant year after year. Tableau is a popular choice among business users and developers around the globe. In this video, you will learn…
Read More
How to Load Data in Azure Data Lake Storage with Example Azure Data Lake Storage can store data of any size and variety. In the previous blog, we have created the Azure Data Lake Storage account. In this tutorial, I will show how to upload a sample excel file in the Azure Data Lake Storage…
Read More
What is Azure Data Lake Azure Data Lake is a data storage or repository of Structured and Unstructured data. It has no restrictions on the data size, thereby allowing storage of huge amounts of data. The stored data can be secured with Azure Active Directory. It also supports Azure Data Analytics that is used for…
Read More
Azure Data Factory Concepts Azure is a cloud computing platform provided by Microsoft. Azure provides numerous services. Azure data factory is one such service. In this blog, we will discuss Azure Data Factory Concepts and how it works. What is Azure Data Factory (ADF) Azure Data Factory is basically an ETL (Extract Transform and Load)…
Read More
How to Create Sample SQL Server database in Azure Azure is a cloud computing platform provided by Microsoft. It helps organizations of any size meet their business challenges. It provides various services that can be utilized on the cloud. In this tutorial, we will learn how to create a sample SQL Server database in Azure.…
Read More
Power BI Components Power BI is a powerful Business Intelligence and data visualization application. In this article, we will learn about different Power BI components. Gartner report places both Power BI and Tableau in the leadership quadrant. Difference between Power BI and Tableau. Power BI desktop Power BI desktop is an authoring tool and is…
Read More
Create Your First Tableau Visualization Tableau is a popular Business Intelligence and data visualization application. In this article we will learn how to create your first Tableau Visualization. This blog will also discuss how to connect Microsoft Excel database from Tableau. Download Tableau Tableau desktop trial version is available for two weeks. Tableau public is…
Read More
Joins in SQL Joins allow us to combine data from two or more tables based on Primary and Foreign keys. In this article, we will learn how Joins in SQL are implemented. Though join concepts are the same in all databases, here we will learn about joins in Oracle. If you are new to Oracle,…
Read More
Download and Install AdventureWorks Sample Database In this blog, we will learn how to Download and Install AdventureWorks Sample Database. We will be using AdventureWorks2017.bak database. Same steps are applicable to restore any database from the backup. Error – No backupset selected to be restored If you get an error – “No backupset selected to…
Read More