In this blog, we will see what the basic test scenarios for ETL testing are. However, before we go to the ETL test scenarios, let me first tell you what ETL is and how it works, along with the process involved with it. WHAT IS ETL? ETL stands for Extract-Transform-Load, and it is a process […]
Data + Intelligence
How to Convert Blank Values to Null in Flat File Source in SSIS Package
SQL Server Integration Services(SSIS): SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading. In […]
Introduction to Google Analytics – A Guide for Beginners
A guide towards an entry to Google Analytics with Naeem Sheikh. What is Google Analytics? Google Analytics is a web analytics service offered by Google that will help in tracking website traffic and generate an easy understandable report to analyze the performance of your website. It is basically divided into five major report i.e. Realtime […]
Adobe Customer Journey Analytics – Things You Must Know
What is Adobe Customer Journey Analytics? Adobe Customer Journey Analytics is an analytics ability that allows you to utilize the power of analysis workspace with data from Adobe experience platform. Adobe Customer Journey Analytics (CJA) is the new and upgraded successor of Adobe analytics. CJA can separate, filter, query, and visualize years’ worth of data, […]
Power BI: Merge and Append Queries
Introduction: Power BI’s merging and appending operations allow you to join data from multiple tables. The choice between the merge and append queries depends upon the type of concatenation you want to carry out based on your requirement. When you have one or more columns that you’d like to add to another query, then you […]
5 Commonly Asked Questions About Intrinsic Bias in AI/ML Models in Healthcare
Healthcare organizations play a key role in offering access to care, motivating skilled workers, and acting as social safety nets in their communities. They, along with life sciences organizations, serve on the front lines of addressing health equity. With a decade of experience in data content and knowledge, specializing in document processing, AI solutions, and […]
Matrices in machine learning
This article gives a sense of how matrix operations such as matrix multiplication arise in machine learning. Dense layers Before we get started, there is a small bit of prerequisite knowledge about “dense layers” of neural networks. What is a “dense layer”? Don’t worry about how “dense layers” fit into the big picture of a […]
THE PURPOSE OF VISUALIZATION IS INSIGHT, NOT PICTURE.
‘’Data Analytics is not Excel Data Analytics is not SQL Data Analytics is not Tableau Data Analytics is not Python or R Data analytics is not about tools, rather, it is about your ability to spot patterns in data and transform raw data into actionable insights. The tool are vehicles, they aren’t destinations.’’ DATA […]
Pass Microsoft Certified Power BI Data Analyst Exam | PL-300
I will be sharing my personal experience with learning Power BI and clearing the PL-300 (Earlier called DA-100) exam. I hope this will help the other aspirants. I would not be compromising the signed NDA; hence no questions will be disclosed in this article. About the Exam : PL-300: Microsoft Power BI Data Analyst Analyzing […]
Coveo: How to fix ContentDocumentLink requires a filter by a single Id
While crawling object ContentDodumentLink from Salesforce you might come across this issue which is a SOQL limitation on ContentDocumentLink object. the exact error from Coveo Source activity log looks like this: Implementation restriction: ContentDocumentLink requires a filter by a single Id on ContentDocumentId or LinkedEntityId using the equals operator or multiple Id’s using the IN […]
How to Implement Row Level Security in Power BI- Static RLS
What is RLS? RLS is Row Level security means restriction of data accessing for a particular user. Filters restrict the data at a row level. We can configure RLS for a dataset that we have imported into the Power BI desktop and can configure RLS in Power BI Service by defining the roles in the […]
How to Create and Use Paginated Reports in Power BI
Paginated Reports are the same as SSRS, which have come to Power BI with advanced features for better reports. Paginated Reports are well designed & formatted reports which are perfectly sized so we can print and share the reports effectively. We can also load images and charts on these reports. We can create highly formatted […]