Interesting Software to Know – For Data Architectures/Analytics
MuleSoft – Link
PowerBI Tips & Tricks
Links: 1. PowerBI Slicer (Filter by another Slicer) – SOLUTION: ENSURE BI-DIRECTIONAL RELATIONSHIP
File Naming Conventions
Why is it Important? 1. For Automation & Enabling automatic detection of files of latest dates (for automatic refresh) LINK: File Naming Conventions
Data Dictionary
Checklist: Link Source: 5 Ways to Create a Data Dictionary 7 Best Practices to Building a Data Dictionary
Qlik Sense Interview Questions
Links: Solved: Data storage in QVF vs QVD in Qlik Sense – Qlik Community – 1454400 Questions: Explain QVDs Explain how you can limit Row Level Information How do you set up Permissions and what are the different kinds of permissions Share with me some of the Apps you have created Are you proficient with …
SAMPLE Dataset
https://drive.google.com/drive/folders/0ByQlW_DfZdxHM3J2UXdPcWd3Wnc?resourcekey=0-obaLCXdVnoIA-frur9XrtA Datasets – Google Drive
PowerBI Interview Questions
Useful Links: https://app.powerbi.com/visuals [445 more FREE amazing visuals that users can use!!!] Calculated Columns vs Measures Implicit vs Explicit DAX Measure Calculate vs Filter Explain Cardinality Transform vs Add Column Active vs Inactive Relationships Primary Key vs Foreign Key Explain Drillthrough filters Explain the difference between “Switch to next level” vs “Expand next Level” and explain …
Real world project for Azure Data Engineers using Azure Data Factory, SQL, Data Lake, Databricks, HDInsight and PowerBI
Links to Read: Introduction to Azure Storage What is Azure SQL Database What is Azure Synapse Analytics What is Azure Cosmos DB What is Azure Data Lake Storage Gen 2 Copy Activity (ADF) Linked Services (ADF) Datasets (ADF) Pipelines (ADF) Validation Activity (ADF) Get Metadeta (ADF) If Condition (ADF) Web Activity (ADF) Delete Activity (ADF) …
Project Manager / PMO Interview Questions
Pitch: Explain the Project Management Framework (5 or 6 Processes) Explain Stakeholder Analysis Explain how do you categorize Risks & Issues Differentiation between Risk & Issue How do you define goals? What are the 6 areas you can negotiate on in a Project? Scope Costs and Benefits Timeline Success Criteria Roles and Responsibilities Resources Kindly …
Business Analyst Interview Question
Pitch: – As a business analyst I worked for a Bank’s Cybersecurity project that uses the product of BeyondTrust for Privilaged Identity Management. 2nd Project: Overview (SailPoint IQ) – Product Link SIQ is the ready-made SailPoint tool for screening and analyzing permission for file servers. Most of the data is unstructured and ensuring right …