MDOS Consulting’s Post

Here’s a scenario on how a data engineer that has a good understanding of the operations can be viewed more as a business partner and thought leader: Biz manager to DE - “hey we would like you to dump our order help desk ticket system data into the analytics database. We think some employees are processing tickets much faster than others and want to use them as examples of what the expectation is” DE - “ok, but I do wonder why some are processing these tickets much faster” A few days later DE to biz mgr - “hey I loaded the ticket data and made it a repeatable process to run 3x a day. Additionally, I took a look at the employee velocity on ticket processing. There are a few that process roughly 2-3 times as much as the others. But when I looked into that, I saw that these employees are just picking the easy tickets to provide order status updates. They aren’t dealing with the more complex scenarios like damaged or missing items. So, I went ahead and enriched the dataset after it is landed to add these additional flag fields so that it can help you with your analyses going forward: - is_ord_stat_update - is_missing_item - is_dmg_item - is_return - is_exchange In the future, if you would like more disposition flags added, please let me know. Hope this helps!” Biz mgr - quietly thinks to themselves….i need to hire this person to be my snr analyst. They just gave me way more insights in a few days than my team has in 6 months. #dataengineering

Who wants to be part of our reporting/dashboard goals for 2024 and help empower Compliance with the data driven challenges? Can you translate data into a visual story using the most sophisticated tools on business intelligence, contact us now! #TribeOris #Compliance #OpRisk #DashboardsReports

Call me the "Data Janitor" because I could have a full-time job just cleaning up data discrepancies and maintaining accurate data. In a large enterprise, you can not just "set it and forget it". #dataanalyst #dataanalysis #datacleaning #datamanagement

📈 Are you planning a Data Transformation project for your business?⌚ Here's 10 reasons why hiring BaseOne could be beneficial for your team & company plans⤵️ - Expertise & experience in data transformation - Objectivity - Time savings - Cost savings - Access to new technologies & approaches - Improved decision making - Enhanced capabilities - Risk management - Increased efficiency - Improved business outcomes Working with our team of experts means you can leverage our expertise to achieve successful data transformation outcomes 📈 👋DM us or email hello@baseone.uk #datatransformation #consulting #businesstransformation #digitaltransformation #baseone

As a data analyst, have you ever been asked by the Sales team 👩🏽💻 to report on a specific customer segment? for eg. "medium" The "medium" bracket should include customers with at least 10 valid transactions within the first 15 days of the last 50-day period. To achieve this, a base table is needed that stores the customer IDs for that period and summarizes the number of transactions and total sales 💳. But what if this "customer segment" needs to be reused in multiple queries? Enter "Parameters" 💪🏻 Let's see them in action: DECLARE @StartDate DATE = DATEADD(DAY, -50, GETDATE()); DECLARE @MidDate DATE = DATEADD(DAY, -35, GETDATE()); and now they can be used in multiple queries by referencing them. For example: SELECT    customer_id,    COUNT(transaction_id) AS TransactionCount,    SUM(transaction_amount) AS TotalAmount FROM    transactions WHERE    transaction_date BETWEEN @StartDate AND @MidDate -- parameters GROUP BY    customer_id HAVING    COUNT(transaction_id) >= 10; There are multiple benefits of using parameters in queries: DRY Principle: Just like in coding, repetition in SQL queries can lead to chaos. Parameters help you follow best practices by keeping your queries clean and maintainable. ⚡️Speed: Parameters enable SQL servers to reuse execution plans, making your queries run faster. 🔐 Security: Parameters protect your data from SQL injection attacks, keeping it safe. 📖 Readability: Parameters make your queries easy to read and tweak, separating the structure from the data. Things to avoid when writing SQL: Hardcoding Values: Leads to errors, difficult maintenance, and security risks. Use parameters instead. Ignoring Performance: Can cause slow execution times. Parameters help by reusing execution plans. Overcomplicating Queries: Makes them hard to understand and maintain. Keep it simple and use parameters for dynamic values. #analytics #SQL #reporting #BI #dataanalytics

Q. Write a solution to find managers with at least five direct reports.(Question from leetcode SQL50) Difficulty: Medium +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | department | varchar | | managerId | int | +-------------+---------+ id is the primary key (column with unique values) for this table. Each row of this table indicates the name of an employee, their department, and the id of their manager. If managerId is null, then the employee does not have a manager. No employee will be the manager of themself.   Input: Employee table: +-----+-------+------------+-----------+ | id | name | department | managerId | +-----+-------+------------+-----------+ | 101 | John | A | null | | 102 | Dan | A | 101 | | 103 | James | A | 101 | | 104 | Amy | A | 101 | | 105 | Anne | A | 101 | | 106 | Ron | B | 101 | +-----+-------+------------+-----------+ My take on this question is as follows select e1.name from employee e1 join employee e2 on e1.id = e2.managerid group by e2.managerid having count(*)>=5 explanation: We need to use self join to join same table as employee_id with respect to manager_id, once joined we get employee details and their manager details in the same row. Now we simply have to apply group by and add a condition of count which needs to be 5 or above. We get managers with atleast 5 direct reports. #SQL #DBMS #Dataanalyst #businessanalyst #learn #upskillandgrow

basic of SQL ..... Oct 2024- Present 1. **Purpose of the Table**: Explain the objective of creating the table--whether it's for managing employee data, tracking performance, or analyzing workforce metrics. 2. **Key Features** - **Fields Included**: Mention the key columns (e.g., employee ID, name, incentive, salary ). - **Data Types**: Highlight any interesting data types you used (e.g., VARCHAR, INT, DATE). 3. **SQL Techniques Used**: - **Normalization**: If you applied normalization techniques, discuss how you structured the data. 4. **Learning Experience**: simple thing into a structure way... **Visuals* . #DataAnalyst #Hiring #Jobs #SQL

𝐈𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰 𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧: 𝐇𝐨𝐰 𝐖𝐨𝐮𝐥𝐝 𝐘𝐨𝐮 𝐃𝐞𝐥𝐞𝐭𝐞 𝐃𝐮𝐩𝐥𝐢𝐜𝐚𝐭𝐞 𝐑𝐨𝐰𝐬 𝐢𝐧 𝐒𝐐𝐋? 🤔 Data duplication can be a major challenge in data management. Today, I’ll show you two effective methods to delete duplicates: using ROW_NUMBER() and MIN(). 👉 𝐀𝐏𝐏𝐑𝐎𝐀𝐂𝐇 𝟏 💡: 𝐔𝐬𝐢𝐧𝐠 𝐑𝐎𝐖_𝐍𝐔𝐌𝐁𝐄𝐑() -- Delete duplicate rows keeping the first occurrence WITH Duplicates AS (   SELECT id FROM (     SELECT id,         ROW_NUMBER() OVER (PARTITION BY first_name, last_name, email            ORDER BY id         ) AS rn     FROM employees   ) sub   WHERE rn > 1 ) DELETE FROM employees WHERE id IN (SELECT id FROM Duplicates); 👉 𝐀𝐏𝐏𝐑𝐎𝐀𝐂𝐇 𝟐 💡: 𝐔𝐬𝐢𝐧𝐠 𝐌𝐈𝐍() -- Delete duplicate rows by keeping the smallest ID in each group: DELETE FROM employees WHERE id NOT IN (   SELECT MIN(id)   FROM employees   GROUP BY first_name, last_name, email ); Important Notes ✍ : 1) 📑 Backup Data: Always back up your data before running delete operations. 2) 🔍Test Query : Run the subquery first to ensure it returns the correct IDs before executing the DELETE statement. If you want to learn in detail watch this video by Ankit Bansal: https://lnkd.in/g4nNNcVb #sql #data_analysis #interviewprep

Urgently Required: Business Intelligence - send cv to sales.me@i-novateinfo.com Kindly source the profile with following skills. Big data analytics Good in AI Principles BI Solution Development: Collaboration: You'll be the glue that holds everything together, working side-by-side with analysts, customers, and everyone in between to figure out what the business needs and translate that into actionable plans. You'll also be on the lookout for ways to improve products based on what users are actually experiencing. Compliance and Governance: Keeping everything safe and secure is your mission! You'll be the champion of all things compliance, making sure everything follows the rules and regulations. Client Engagement and Travel: Sometimes you'll hit the road to meet with clients face-to-face, building strong relationships to ensure our systems integrate seamlessly with theirs. Effective Communication Ninja: Clear, confident, and consistent communication is your middle name. You can explain complex things simply and make sure everyone understands, no matter their background. Release and UAT Management: Manage release processes and coordinate User Acceptance Testing (UAT) to ensure solutions meet business requirements and are ready for production deployment.