Ghulam Murtaza Portfolio

🎛 Dynamic Dashboard Creation: Implemented parameters and calculations for interactive, real-time HR metric adjustments.

🌍 Diverse Visualization Tools: Developed geographic maps, bar charts, and line graphs showcasing hiring trends, regional statistics, and retention rates.

🖼 Optimized Dashboard Design: Structured visuals in strategic containers, ensuring an intuitive user experience.

🖱 User Interactivity: Incorporated filters and toggles, enabling users to dive deep into specific HR insights and view data adjustments dynamically.

🚀 Future Expansion: Envisioned date filters, expanded geographic insights.

PowerBI does not allow reports to be shared outside organization, To view Dashboard, click on View Dashboard to download or you can view pdf for quicker view

• View Dashboard
• View PDF

🗣️ Language Analysis: A comprehensive chart showcasing the count of views categorized by different languages, revealing audience preferences and regional popularity.

📆 Yearly Distribution: An insightful breakdown detailing the count of views by year, allowing stakeholders to track content performance over time and identify emerging trends.

🌟 IMDb Category Insights: A detailed visualization presenting the count of views based on IMDb categories, giving a perspective on which types of content are resonating most with the audience.

🎬 Genre Analysis: A chart that breaks down the count of views by genre, providing clarity on the kind of content genres that are most sought after by viewers.

🔍 Date Filter: An integrated date filter functionality, empowering users to refine their data view and focus on specific time frames for a more granular analysis.

📋 Requirement Gathering: Identified client needs like year-on-year metrics, severity analysis, monthly trends, and location-based insights.

🔗 Connecting to Data: Linked Excel accident data to Power BI, ensuring data integrity.

🧹 Data Cleaning and Processing: Rectified errors using Power Query, added columns for better sorting, and established date hierarchies.

🔗 Data Modeling: Linked accident data to a calendar table for enriched time-based analysis.

📊 Creating KPI Visuals: Displayed key metrics like casualties, growth, and severity with styled visuals.

📈 Building Other Charts: Introduced charts for monthly trends, casualty splits, road type insights, and a bubble map for locations.

🔍 Integrating Interactive Filters and Slicers: Integrated slicers and set filter interactions to enhance dashboard interactivity.

PowerBI does not allow reports to be shared outside organization, To view Dashboard, click on View Dashboard to download or you can view pdf for quicker view

💡 Learnt:

📚 What is a data model? Power BI's structured data representation crucial for accurate reporting and insights.

📋 Fact and dimension tables: Distinguishing between quantitative fact tables and descriptive dimension tables.

🔗 Relationships: Establishing connections between data tables for effective data querying.

🚦 Cardinalities: Understanding one-to-one, one-to-many, and many-to-many relationships in data modeling.

🔄 Active and inactive relationships: Differentiating between default and alternative table relationships using DAX for inactive ones.

🔍 Schemas: Grasping star, snowflake, and galaxy schemas and their design principles.

📝 Action Items: Importance of clean data, accurate relationships, model validation, and continuous improvement.