Posts

Searching Blob Documents with the Azure Search Service

  One of the core services in the Microsoft Azure cloud platform is the Storage Service, which includes Blobs, Queues, and Table storage. Blobs are great for anything you would use a file system for, such as avatars, data files, XML/JSON files, ...and  documents . But until recently, documents in blob storage had one big shortcoming: they weren't searchable. That is no longer the case. In this post, we'll examine how to search documents in blob storage using the Azure Search Service. Azure Blob Basics Let's quickly cover the basic of Azure blobs: Storage Accounts . To work with storage, you need to allocate a  storage account  in the Azure Management Portal. A storage account can be used for any or all of the following: blob storage, queue storage, table storage. We're focusing on blob storage in this article. To access a storage account you need its name and a key. Containers . In your storage account, you can create one or more named  containers . A container is kind
Post a Comment
Read more

Microsoft Business Intelligence(MSBI)

  MSBI is an abbreviated form of Microsoft Business Intelligence. To understand MSBI, it is important to understand BI (Business Intelligence) first. Here we discussed different Business Intelligence tools including SSIS, SSRS, SSAS & many more. Similarly, What is MSBI? and its benefits. know more  msbi online course Data & Information Data is a technical term. A layman would not understand the data in a technical format, he would be able to gain information from that data only if it is in an understandable format. Business Intelligence When the raw data is converted into meaningful information by using tools and techniques or by performing analysis, cleansing, modeling, etc. is termed as BI. Business Intelligence includes the following: Data Cleansing – Data comes to any organization in a lot of formats. As per industry-wise, it is important to collect the data which is important and discard the unnecessary data. Sometimes a data may even contain some errors. So, the process o
1 comment
Read more

SSIS: DataFlow Transformations

  Transformations are defined as a core component in the Data flow of a package in SSIS. It is that part of the data flow to which we apply our business logic to manipulate and modify the input data into the required format before loading it to the destination. Different types of Transformations available in SSIS. 1. AGGREGATE : The Aggregate transformation applies aggregate functions to column values and copies the results to the transformation output. Besides aggregate functions, the transformation provides the GROUP BY clause, which you can use to specify groups to aggregate across. KNOW MORE msbi online training The Aggregate Transformation supports following operations: GROUP BY, SUM, AVERAGE, COUNT, COUNT DISTINCT, MINIMUM, MAXIMUM Example of Aggregate Transformation 2. AUDIT : Adds Package and Task level Metadata - such as Machine Name, Execution Instance, Package Name, Package ID, etc.. 3. CHARACTER MAP : When it comes to string formatting in SSIS, Character Map transformation
1 comment
Read more