MDOS Consulting’s Post

Which SQL query would you write to fetch various projects from the employee responsibilities table? ANS :- Check if candidates understand that the distinct clause will help them fetch the data from the employee responsibilities table, which contains values for each employee. The distinct clause returns different values instead of duplicates.  Candidates may use the following query to answer this problem: SELECT DISTINCT (Project) FROM EmployeeResponsibilities #SQL,#POWER BI,#DATA ANALYST

I recently attended an interview of a product based company for Power BI Developer role, and these are the questions asked during the interview. Round 1. Time:- 1hrs 20min ➡️SQL Questions ----------------- 1 what is VARCHAR and NVARCHAR 2 what are constraints 3 difference between primary and foreign key 4 difference between Delete and Truncate 5 what are windows function 6 what is NTILE function 7 what is queryblock and deadlock 8 difference between RANK and DENSERANK 9 write SQL query to find City name whose start with vowels from City table 10 write SQL query to find and delete duplicate email from a table 11 Table ------------------ Jan  | 4000 Feb  | 3000 Mar | 4550 write SQL query to find sales performance of current month with previous month 12. what are steps you perform to enhance the performance of SQL queries 13. What is ACID properties in database. 14. Types of Isolation in SQL ➡️Power Bi Questions --------------------- 1 Difference between Power BI premium and Power Bi Pro licence 2 What are the key features of Power Bi desktop 3 difference between power pivot and power query 4 Difference between RELATED and RELATEDTABLE dax function 5 Difference between import mode and direct query 6 difference between MAX and MAXA emptable (input table) +-------+------------+------------+ | EmpId |    DOJ     |    DOL       | +-------+------------+------------+ |   1   | 01-Apr-24  | 05-Jul-24   | |   2   | 01-May-24  |                  | |   3   | 01-May-24  | 03-Jun-24 | |   4   | 03-Jun-24   |                   | |   5   | 05-Jul-24    |                   | +-------+------------+------------+ Output table +-------+---------+-------+-------+-------+ | Month | OpenCnt | Join  | Leave | Total | +-------+---------+-------+-------+-------+ | Apr   |    0    |   1   |   1   |   0   | | May   |    1    |   2   |   0   |   3   | | Jun   |    3    |   1   |   1   |   3   | | Jul   |    3    |   1   |   1   |   3   | +-------+---------+-------+-------+-------+ create 4 dax measure which calculate the Opencount, Join, Leave and Total as shown in output table. 12 .what are steps you performed to enhanced the performance of power bi report 13. what are visual, report and page level filter

I recently attended an interview of a product based company for Power BI Developer role, and these are the questions asked during the interview.   Round 1.  Time:- 1hrs 20min ➡️SQL Questions ----------------- 1 what is VARCHAR and NVARCHAR 2 what are constraints 3 difference between primary and foreign key 4 difference between Delete and Truncate 5 what are windows function 6 what is NTILE function 7 what is queryblock and deadlock 8 difference between RANK and DENSERANK 9 write SQL query to find City name whose start with vowels from City table 10 write SQL query to find and delete duplicate email from a table 11 Table ------------------ Jan  | 4000 Feb  | 3000 Mar | 4550   write SQL query to find sales performance of current month with previous month   12 what are steps you perform to enhance the performance of SQL queries 13 What is ACID properties in database. 14 Types of Isolation in SQL   ➡️Power Bi Questions --------------------- 1 Difference between Power BI premium and Power Bi Pro licence 2 What are the key features of Power Bi desktop 3 difference between power pivot and power query 4 Difference between RELATED and RELATEDTABLE dax function 5 Difference between import mode and direct query 6 difference between MAX and MAXA 7 emptable (input table) +-------+------------+------------+ | EmpId |    DOJ     |    DOL       | +-------+------------+------------+ |   1   | 01-Apr-24  | 05-Jul-24   | |   2   | 01-May-24  |                  | |   3   | 01-May-24  | 03-Jun-24 | |   4   | 03-Jun-24   |                   | |   5   | 05-Jul-24    |                   | +-------+------------+------------+     Output table +-------+---------+-------+-------+-------+ | Month | OpenCnt | Join  | Leave | Total | +-------+---------+-------+-------+-------+ | Apr   |    0    |   1   |   1   |   0   | | May   |    1    |   2   |   0   |   3   | | Jun   |    3    |   1   |   1   |   3   | | Jul   |    3    |   1   |   1   |   3   | +-------+---------+-------+-------+-------+     create 4 dax measure which calculate the Opencount, Join, Leave and Total as shown in output table.   12 what are steps you performed to enhanced the performance of power bi report 13 what are visual, report and page level filter 🟣 Follow Vivek Kumar Singh for more insightful content. For better reach Raghavan P Thodupunuri Bharath Vishal Jaiswal, PMP® Shashank Singh 🇮🇳 Munna Das Ankit Bansal Rishabh Mishra Vaibhav Lambat #sql #powerbi #dax #dataanalyst #powerbideveloper #datavisualization #linkedin

Today, I decided to try my hands on this SQL project from Maven Analytics. Believe me, SQL Joins can really get complex. The Interesting thing though is how SQL language is able to connect seemlessly through different tables and extract data accurately. Take a look at this question and how the JOINS were structured to output the desired result 1. My partner and I want to come by each of the stores in person and meet the managers.  Please send over the managers’ names at each store, with the full address  of each property (street address, district, city, and country please).   */ CODE: SELECT   staff.first_name,   staff.last_name,   staff.store_id,   address.address AS street_address,   address.district AS district,   city.city AS city,   country.country AS country FROM    staff INNER JOIN address   ON staff.address_id = address.address_id INNER JOIN city   ON address.city_id = city.city_id INNER JOIN country   ON city.country_id = country.country_id; Result: Check attached image. Do you need data analysis services? I am just a DM away or 📞 Whatsapp me on +2347066938021 #DataAnalyst #BusinessIntelligence #DataAnalysis #Excel #PowerBI, #DataVisualization #Hiring #Analytics #CareerOpportunities #RemoteJobs #TechJobs #AnalystJobs #Remote #DataVisualization #NaijaDataAnalayst

Hi All, Kindly Share Your Approach Question 1: Use of Relationship DAX Functions In a star schema, all dimension tables are directly connected to a single fact table. Why Relationship functions RELATED and RELATEDTABLE are used if they have existing relationship? Question 2: Standardizing Currency Across Multiple Transaction Tables Given that you have 50 transaction tables with millions of records, each containing a common column named "Currency" with values in USD, INR, and CAD, how can you approach with SQL Query standardizing the currency format for reporting purposes without impacting query performance? #Interview Questions #Power BI Developer #BI Engineer #Data Analyst

Power BI Interview Questions & Answers a) Can we schedule refresh in 15 minutes? No, Power BI supports a minimum refresh interval of 30 minutes. Use DirectQuery or real-time streaming for more frequent updates. b)What is Date dimension table? Ans: Date dimension table is a vital part of data modeling, containing a comprehensive list of dates used to track time-based data. It includes columns like Date, Year, Quarter, Month, Week, and Day. It supports time intelligence calculations and improves query performance. c) Roles & Responsibilities of Project / Project end to end? In a Power BI project, roles may include: Project Manager, Data Analyst/Developer, Data Engineer, QA Tester, End Users d) What were data errors in Project? Common data errors: Inconsistent data formats, Missing values, Duplicates, Data entry errors These can be resolved through data cleaning and validation processes. e) What is Query Folding? Where did you use it? Translates Power Query transformations to the source query language, optimizing performance. Also used in complex ETL processes. #powerbinuggets #PowerBI #DataDimension #DAX

SQL Topics to Learn for Data Analyst/Business Analyst Roles 1. Basic: * SELECT statements * WHERE clause * JOINs (INNER, LEFT, RIGHT, FULL) * GROUP BY and HAVING * ORDER BY * Basic Aggregate Functions (COUNT, SUM, AVG, MIN, MAX) 2. Intermediate: * Subqueries * CASE statements * UNION and UNION ALL * Common Table Expressions (CTEs) * Window Functions (ROW_NUMBER, RANK, DENSE_RANK, OVER) * Data Manipulation (INSERT, UPDATE, DELETE) * Indexes and Performance Tuning 3. Advanced: * Advanced Window Functions (LEAD, LAG, NTILE) * Complex Subqueries and Correlated Subqueries * Advanced Performance Tuning #SQL #Data Analyst

Power BI Interview Questions & Answers 1. Can we schedule refresh in 15 min? Ans: No, Power BI supports a minimum refresh interval of 30 minutes. Use DirectQuery or real-time streaming for more frequent updates. 2. What is Date dimension table? Ans: Date dimension table is a vital part of data modeling, containing a comprehensive list of dates used to track time-based data. It includes columns like Date, Year, Quarter, Month, Week, and Day. It supports time intelligence calculations and improves query performance. 3. Roles & Responsibilities of Project / Project end to end? Ans: In a Power BI project, roles may include: Project Manager, Data Analyst/Developer, Data Engineer, QA Tester, End Users 4. What were data errors in Project? Ans: Common data errors include: Inconsistent data formats, Missing values, Duplicates, Data entry errors These can be resolved through data cleaning and validation processes. 5. What is Query Folding? Where did you use it? Ans: Translates Power Query transformations to the source query language, optimizing performance. Used in complex ETL processes. These are few Power BI questions.... #PowerBI #DataDimension #QueryFolding #DataErrors #DataCleaning #DAX #DataManipulation

Practical interview questions for an entry-level data analyst role in #Power_BI: along with answers ! 1. Data Import Scenario: Given a set of data in different formats (e.g., Excel, CSV, SQL Server), how would you import this data into Power BI? ➡️ Open Power BI: Start the Power BI Desktop application. ➡️ Get Data: Click on the "Get Data" button on the Home tab. ➡️ Choose Data Source: Select "Excel", "Text/CSV", or "SQL Server". ➡️ For Excel: Find and open the Excel file. ➡️ For CSV: Find and open the CSV file. ➡️ For SQL Server: Enter the server name and database name, then click "OK". ➡️ Load Data: Click "Load" to import the data, then create visual reports and dashboards. 2. Data Cleaning Exercise: You have a dataset with missing values and inconsistent formats. What steps would you take in Power BI to clean this data? ➡️ Open Power BI: Start the Power BI Desktop application. ➡️ Load Your Data: Import your dataset into Power BI using the "Get Data" button. ➡️ Open Power Query Editor: Click on "Transform Data" to open the Power Query Editor. ➡️ Remove Missing Values: Use the "Remove Rows" option to eliminate rows with missing values. ➡️ Fix Inconsistent Formats: Use "Transform" tab options like "Data Type" to ensure consistency (e.g., text, number, date). ➡️ Replace Values: Use the "Replace Values" option to fix inconsistencies, such as different spellings or formats. ➡️ Apply Changes: Click "Close & Apply" to save and apply the cleaned data to your Power BI report. 👉𝐉𝐨𝐛&𝐃𝐚𝐭𝐚 𝐫𝐞𝐟𝐞𝐫𝐫𝐚𝐥 ✅:https://lnkd.in/gcw-ziZm MADHU THANGELLA connect with me for more updates ! #DataCleaning #PowerBI #DataQuality #DataTransformation #DataPreparation #PowerQuery

How much SQL is enough SQL? If you’re a junior BI or data analyst, you don’t need to be an expert. But you will need to have mastered the basics. 👉SELECT, FROM, WHERE - that’s a given I’m afraid. 👉You’ll need to know your main join types. 👉Grouping and aggregation, date and time functions - you’re going to need those 👉The CASE statement, CAST and CONVERT are important too. 👉You’ll need to be able to handle NULLS, and know UNION & UNION ALL 👉It would be helpful if you could use CTEs / temp tables and had a decent understanding of one or two window functions. So if you’re in a junior role, or if you’re a manager and you have juniors in your team who lack these basic SQL knowledge, Then hit me up, and I’ll see how I can help. --------------------------------------------------------------------------- 👉 My SQL coaching program will teach these skills, and plenty more 👉 Check out my profile for more information and book a call to speak with me  -------------------------------------------------------------------------- #sql       #thebischool       #sqlsuperhero       #learnsql       #ukbusiness