sqlmadmin

Hello Friends, Here is another popular lab from Hands-On-Lab library: Managing Relationships in Power BI. To create logical connections between multiple sources for better analysis, we create relationships between the sources. The data from different data sources can then be joined for further analysis. This process of creating relationships comes under data modelling. In this [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Financial Dashboard in Power BI. The financial analysis is important for every business in order to work efficiently. It would be even better if all the financial analysis of the business comes up in single dashboard. Power BI empowers us to create such financial dashboards [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Task Group Sequence and For Loop Containers in SSIS. SSIS Containers are used for different purposes; some are used to group tasks together like Sequence Container or Group. We can also use Sequence Container to run the child tasks either sequentially or in parallel. Other [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Foreach Loop Container. SSIS Containers are used for different purposes; some are used to group tasks together like Sequence Container. Other Containers like Foreach Loop Container is used to run a loop for each member of a specified enumerator. This lab is divided into [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Data Loading – Part 1. Extracting and loading data is one of the first step in an ETL process. SSIS allows to extract and load data from many different data sources. However, in this lab, we’ll learn to extract data from Excel and XML [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Data Flow Transformations – Part 2. The Fuzzy lookup transformation is used to perform data cleansing such as standardizing data, correcting data or finding missing values. The Fuzzy grouping transformation is used to find duplicate records. In the first exercise, we’ll use Fuzzy lookup [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Data Flow Transformations – Part 1. Data Flow Task is used to move data from a source to a destination while applying various transformations on the data being moved as and when required. The lab talks about available sources, transformations and destinations available in [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Slowly Changing Dimensions in SSIS. A dimension is considered to be a Slowly Changing Dimensions in SSIS when the attributes change over a period of time. The SCD are categorized based on the methodology of historical records maintenance. Slowly Changing Dimensions in SSIS transformation helps [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Implementing Incremental Data Load and Inner Join in SSIS. In this Lab, we’ll learn about two of the most used transformation in SSIS, Lookup and Merge Join Transformations. In the first exercise, we’ll learn to implement incremental data load using Lookup Transformation. Incremental data load [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Error and Event Handling in SSIS. In this lab, we’ll learn to effectively use precedence constraints, implement error and event handling and logging. Precedence Constraints are the arrows used to connect two or more tasks in Control Flow and Data Flow. Precedence constraints govern the [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Calling Web Service From SSIS. In this lab, we’ll learn how to call a web service from SSIS. In the first exercise, we will learn how to use SSIS inbuilt component Web Service Task to call the Web Service and get the data in XML [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Advanced Data Cleansing In SSIS. In this lab, we’ll learn to implement DQL Cleansing transformation and the DQS knowledge base to clean dirty data. DQS Cleansing transformation helps in cleansing the dirty data. It takes the knowledge base created in the Data Quality client with [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: XML and Xquery in SQL Server. Extensive markup language(XML) is a language used to encode the documents in such a way that both Humans and Machines can read the data. XML was designed to store and transport the data. XQuery is a query used to [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Working with NULL in SQL Server. NULL is not a value, it only means that a value was not provided when the row was created. Special attentions need to be taken into account when dealing with nulls in SQL Server. One needs to remind that [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Working with Date and Time Datatypes in SQL Server. This lab focusses on date and time datatypes and functions available in SQL Server and how to effectively use the functions to solve real-world problems. The lab is divided into four exercise. In the first exercise, [...]

Hello Friends, Here is another popular lab from Hands-On-Lab library: Views in SQL Server. In Transact-SQL (T-SQL) a view allows us to create a virtual representation of table whose contents are defined by the query. The query that defines the view can be joined from one or more tables. Once a view is created we [...]