💪 Want to know how I can help you turn data into valuable insights? In addition to mastering the 𝗯𝗮𝘀𝗶𝗰𝘀 𝗼𝗳 𝗦𝗤𝗟 and 𝗝𝗼𝗶𝗻𝘀. I've acquired an array of incredible skills. Let's explore how I can turn data into valuable insights
✅ Subqueries, CTEs, Views, Temporary Tables: Explored advanced techniques to write complex queries using subqueries, Common Table Expressions (CTEs), and created and utilized views and temporary tables for efficient data handling.
✅ Fundamentals of ETL, Data Warehouse, OLAP, OLTP: Gained a comprehensive understanding of Extract, Transform, Load (ETL) processes, data warehousing concepts, and the difference between Online Analytical Processing (OLAP) and Online Transactional Processing (OLTP).
✅ User Defined Functions, Stored Procedures: Learned to create and use user-defined functions and stored procedures to enhance SQL code reusability and improve performance.
✅ Window Functions: Explored advanced analytical functions like OVER, ROW_NUMBER, RANK, DENSE_RANK, etc., enabling me to perform complex calculations and analysis within result sets.
✅ Data Engineer-Specific Topics: Explored essential aspects such as Indexes, Triggers, Events, User Accounts & Privileges, which are crucial for building robust data engineering solutions.
✅ Real Dataset with >1 million records: Engaged in industry-style project-based learning using a large-scale dataset, allowing me to apply the acquired skills in a real-world context and develop a solid foundation for working with substantial data volumes.
Provide Insights to Management in Consumer Goods Domain
Consumer Goods | Function : Excecutive Management
- Atliq Hardware (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.
- However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions.
- Hence, company decided to conduct a SQL challenge which will help them to understand the data.
- Check ad-hoc-request.pdf there are 10 ad hoc requests for which the business needs insights.
- Need to run a SQL query to answer these requests.
- The target audience of this dashboard is top-level management - hence want to create a presentation to show the insights.