Month: August 2022

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 …

PowerBI Interview Questions Read More »

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) …

Real world project for Azure Data Engineers using Azure Data Factory, SQL, Data Lake, Databricks, HDInsight and PowerBI Read More »

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 …

Project Manager / PMO Interview Questions Read More »

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 …

Business Analyst Interview Question Read More »