Project Details

Having Successfully completed the codebasics Power BI course, I gained valuable insights on problem-solving beyond the tools. The course covered essential tech skills like SQL, Power BI Desktop, Excel, DAX language, and DAX Studio for optimizing reports.
✔ Crafted calculated columns and measures using DAX language.✔ Mastered data modeling techniques.✔ Leveraged Bookmarks to switch between visuals and enabled smooth page navigation with buttons.✔ Implemented divide function for error-free division.✔ Created dynamic tables using M language.✔ Customized titles based on applied filters.✔ Incorporated KPI indicators and conditional formatting using icons and background colors.✔ Explored data validation techniques.
✔ Learned about Power BI services, report publishing, personal gateway setup, and app creation.✔ Acquired proficiency in collaboration, workspace management, and access permissions on Power BI services.✔ Analyzed Gross Price, Pre-Invoice Deductions, Post-Invoice Deductions.

Live Interactive Dashboard

Project Details

I led a pivotal project in 𝗧𝗲𝗹𝗮𝗻𝗴𝗮𝗻𝗮, leveraging data to drive socio-𝗲𝗰𝗼𝗻𝗼𝗺𝗶𝗰 𝗴𝗿𝗼𝘄𝘁𝗵. The goal was to provide the government with 𝗮𝗰𝘁𝗶𝗼𝗻𝗮𝗯𝗹𝗲 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝘀 and summarize key 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 𝗳𝗶𝗻𝗱𝗶𝗻𝗴𝘀 𝗶𝗻𝘁𝗼 𝗶𝗺𝗽𝗮𝗰𝘁𝗳𝘂𝗹 𝗣𝗼𝘄𝗲𝗿𝗣𝗼𝗶𝗻𝘁 𝗽𝗿𝗲𝘀𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀 to enhance 𝗱𝗮𝘁𝗮-𝗱𝗿𝗶𝘃𝗲𝗻 𝘀𝘁𝗼𝗿𝘆𝘁𝗲𝗹𝗹𝗶𝗻𝗴 𝗮𝗻𝗱 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻-𝗺𝗮𝗸𝗶𝗻𝗴 𝗱𝘂𝗿𝗶𝗻𝗴 𝗽𝗿𝗲𝘀𝗲𝗻𝘁𝗮𝘁𝗶𝗼𝗻𝘀
Insights:
E-challan revenue in Telangana surged significantly, increasing from 12% in 2020 to an impressive 48% in 2022
Year-to-year data indicates a consistent increase in electric vehicle demand in Telangana remake in 2022 by 60% sales of 63K
Hyderabad ranked the highest in motor-cycle sales revenue 207k in 2022
Plastic and rubber industry has taken its peak in 2022 with 58.56bn.
Pharmaceutical industry has grown due to Covid in 2021 by 43.26%
Fertilizers (Organic and Inorganic), Pesticides, Insecticides, and Related Se

Live Interactive Dashboard

Project Details

I would like to mention a few things that I have really enjoyed during to solve this case study.

🔸 I learned a special use case of the CROSS JOIN technique and used the Dense Rank technique (Window Function) for the first time in a real-life project.
🔸 I have used the Common Table Expression technique (CTE) multiple times. It really made my work easy. Thanks to the codebasics team, before the SQL course, I used to write long SQL queries to get the desired result, but the introduction of Subqueries, CTE, Temporary Table, and Views has reduced a significant amount of time.
🔸 This Project Challenge helped me to clear my understanding of the Consumer goods domain.
🔸 I have also tried to implement the data validation technique that I have learned from the courses. Basically, to validate the SQL query results, sometimes I have used MS Excel and cross-checked the result.
🔸 I must mention that I have improved my Googling skills, and it really helped me to find the desired result faster.