Fantasy Premiere League Analytics Hub v3
Multi Seasonal Report to help Fantasy managers track player performance discover hidden gems and undervalued assets Main changes from previous version: Changed the pipeline from just python > powerbi to python >sql databae > powerbi' This was done to handle multi season analysi as the previous pipeline wasnt fit to do so Utilised bronze silver gold staging in sql More contextualised kpis Customiseable charts (parameters) Utilised HTML visuals for KPIs, Visuals (player explorrer page) and tooltips Star Schema Data Model eyJrIjoiMTVjMTdkMWEtZTQwOS00NDM0LTkxYTEtMjJmODY2ZDhmMTY0IiwidCI6ImQxMjA2OTQzLWJmY2MtNGM3NC04MmQ0LTA1ZTYzYTQzMzViZiJ9๐ Powerful interactive calendar in Power BI ๐
Did you know how powerful the native Power BI ๐ฆ๐ฐ๐ฎ๐๐๐ฒ๐ฟ ๐๐ต๐ฎ๐ฟ๐ is? What if I told you that, ๐ฐ๐ผ๐บ๐ฏ๐ถ๐ป๐ฒ๐ฑ ๐๐ถ๐๐ต ๐ฎ ๐ ๐ฎ๐๐ฟ๐ถ๐ , it could create a ๐ณ๐๐น๐น๐ ๐ถ๐ป๐๐ฒ๐ฟ๐ฎ๐ฐ๐๐ถ๐๐ฒ ๐ฐ๐ฎ๐น๐ฒ๐ป๐ฑ๐ฎ๐ฟ? Back in 2019, I created a ๐๐๐ฒ๐ฝ-๐ฏ๐-๐๐๐ฒ๐ฝ ๐๐๐๐ผ๐ฟ๐ถ๐ฎ๐น to show how to build a fully interactive calendar in Power BI by using the Matrix visual. While it worked well, I knew I could improve it. This year, I wanted to explore a new technique by ๐ฐ๐ผ๐บ๐ฏ๐ถ๐ป๐ถ๐ป๐ด ๐๐ต๐ฒ ๐ ๐ฎ๐๐ฟ๐ถ๐ ๐๐ถ๐๐ต ๐๐ต๐ฒ ๐ฆ๐ฐ๐ฎ๐๐๐ฒ๐ฟ ๐๐ต๐ฎ๐ฟ๐, and here is the result. ๐ช๐ต๐ฎ๐โ๐ ๐ป๐ฒ๐ ๐ถ๐ป ๐๐ต๐ถ๐ ๐๐ฒ๐ฟ๐๐ถ๐ผ๐ป? โข A full-year view with statutory holidays for Sรฉnรฉgal, France, and Quรฉbec โข A refined layout leveraging Scatter and Matrix visuals (no custom visuals) โข A dynamic title built with a simple SVG โ no external images required โข Interactive filters to switch between years, regions, and ๐ฐ๐ผ๐น๐ผ๐ฟ ๐ช๐ฎ๐ป๐ ๐๐ผ ๐ฒ๐ ๐ฝ๐น๐ผ๐ฟ๐ฒ ๐ถ๐ ๐๐ผ๐๐ฟ๐๐ฒ๐น๐ณ? Iโm making the .๐ฝ๐ฏ๐ถ๐ file available for free so you can dive in, customize it, see the logic behind it, and let me know your thoughts. eyJrIjoiOTQyY2JmMjQtZTIxOS00ZTI1LTgwOTMtYTU1Yjg5ZGZkZjI2IiwidCI6ImE5ZTRlYjg3LWY4OTAtNGE3My05YTYwLTRiMmVjZGI3ZWY4YiJ9&embedImagePlaceholder=true&pageName=75869a7237688a6574a1Canadian Big 6 Banks' Stock Market Tracker
For this new version, I wanted to challenge myself again: Can we create advanced stock market visuals in Power BI using only native visuals and DAX? The answer is yes. In this version, I added multiple chart types inside a single native Power BI visual: โข Candlestick Chart โข OHLC Bar Chart โข Mountain Chart โ Line chart with shaded area โข Moving Average โข Big 6 Banks selector โข Dynamic stock performance indicators And the best part: No SVG. No Bookmarks. No custom visuals. Only native Power BI visuals and DAX. This project is part of my ongoing exploration of how far we can push Power BIโs native capabilities when we combine creativity, data storytelling, and DAX logic. This tool is purely for educational purposes, knowledge sharing, and learning about Power BI. Download the PBIX file eyJrIjoiM2Q4OTQwMmEtYjE5NC00Y2Q2LThmZTEtZDBlZDI5ZDBmZGM5IiwidCI6ImE5ZTRlYjg3LWY4OTAtNGE3My05YTYwLTRiMmVjZGI3ZWY4YiJ9&embedImagePlaceholder=truePower BI Marketing Campaign Dashboard Template
Take Control of Your Marketing Campaigns with This Power BI Dashboard Template! Struggling with declining ad performance or wasted budgets? This Power BI Marketing Dashboard Template helps you track, analyze, and optimize campaigns in minutes. Key Benefits: Fix Underperforming Ads โ Spot drops in CTR, impressions, and clicks to adjust campaigns fast. Boost Conversions โ Identify low-converting campaigns and refine targeting for higher ROI. Optimize Ad Spend โ Compare CPC & ROAS across platforms (Facebook, Google, etc.) to allocate budgets smarter. Improve Device Targeting โ See which platforms (mobile vs. desktop) drive the most traffic and adjust placements. Increase Engagement โ Track likes, shares, and comments to create content that resonates with your audience. eyJrIjoiNGI5NmI4MzYtNDFmNy00N2RlLTk4N2UtMjlhYTg1Mjk2MzhhIiwidCI6ImE5NDUyNTg2LTJmNGMtNGNiMS04ZDJlLTI2ODkyODllZTcyNiIsImMiOjl9Crime Overview โ City of Los Angeles (2020 - 2024)
๐Los Angeles Crime Analysis Dashboard (2020โ2024) This project presents an end-to-end analytical dashboard exploring crime patterns in the City of Los Angeles using official LAPD open data. The report focuses on temporal trends, geographic distribution, crime characteristics, and victim demographics to uncover meaningful insights about when, where, and how crimes occur. ๐Tool: Power BI ๐ Period: 2020โ2024 ๐Location: Los Angeles, California ๐Data Source Los Angeles Police Department (LAPD) โ Open Data Portal Crime Data from 2020 to 2024 The dataset contains detailed records of reported incidents, including date and time, location, crime type, victim information, and weapon usage. Note: In October 2024, LAPD migrated from UCR to the NIBRS reporting system. The legacy dataset used in this analysis is no longer updated and is maintained only for historical purposes. Because newer records follow a different reporting standard and remain incomplete, 2025 data were excluded. ๐Key Analytical Areas ๐งญ Crime Overview Total crime volume across years Most common crime types Distribution across city areas Long-term trends ๐Temporal Patterns Crime distribution by hour of day Weekday vs weekend behavior Seasonal variation Identification of peak crime periods ๐บ๏ธ Geographic Analysis Crime hotspots across LAPD areas Spatial concentration of incidents Neighborhood-level differences ๐ฅVictim & Crime Characteristics Victim age and gender distribution Ethnicity patterns Crime severity (violent vs property) Weapon involvement Location types where crimes occur Adults represent the largest victim group, and crimes most frequently occur in public outdoor environments. โ ๏ธNotable Insights Property crimes dominate overall incident counts. Violent crimes account for roughly one quarter of reported cases. Personal force is the most commonly used โweapon,โ indicating many incidents involve direct physical contact rather than firearms. Outdoor/public spaces show the highest exposure to crime. Victim demographics broadly reflect the cityโs diverse population. Identity theft and other non-contact offenses highlight the growing role of non-traditional crime types. ๐ ๏ธ Analytical Approach The dashboard was built using a structured BI workflow: Data cleaning and transformation Calendar table for time intelligence Derived metrics and DAX measures Categorization of crimes (violent vs property) Aggregation of demographic groups Interactive filtering across all visuals ๐ฏPurpose This project demonstrates the ability to: Transform raw public data into analytical insights Design business-ready dashboards Apply data modeling and DAX Communicate findings through clear visual storytelling eyJrIjoiZjZlMjU3MzktMjU4OC00OGQ3LWIzMGMtOTI5N2JjNjI5NDI4IiwidCI6IjY1NWVhZjVhLTBhMTctNDEzOS05NzU5LTFlMDIzMTRkMDJhYiIsImMiOjZ9Netflix Content Acquisition Strategy Dashboard
Main Features: -Dynamic Insight and suggestion cards (specifically on the insights page) -allowing for multi genre filtering (and vs or selection) -Purpose is to give a quick snapshot look to a content aquisition team to what genre of movies is doing well in what region - Can be used for movie enjoyers to explore content in different regions for different genre(s) to find new things to watch eyJrIjoiMWY2Nzc3ZWEtNjNjNS00YjdhLThmMGYtMzk1ZGE4N2JlZWQ5IiwidCI6ImQxMjA2OTQzLWJmY2MtNGM3NC04MmQ0LTA1ZTYzYTQzMzViZiJ9๐ Powerful Sales Performance Dashboard in Power BI ๐
๐๐ Hello, I'm Cheikh Abdou Seye, and I'm passionate about the dynamic world of data engineering, management, and visualization. I'm excited to share my latest personal Power BI project - a robust Sales Performance Dashboard, crafted entirely using native visuals only! This dashboard provides deep insights into sales data from a fictitious metropolitan French retail grocery company. ------------- โ ๏ธ Disclaimer Please note that the datasets used to showcase this Sales Performance Dashboard were randomly generated using ChatGPT and are intended for demo purposes only. The sales representatives' names displayed are also fictitious. Any resemblance to real persons or businesses is purely coincidental. -------------------------------------- Business rules -------------------------------------- All visuals are conditionally formatted based on these 4 rules: Leaders (green): meet or exceed both Revenue Performance Target (95%) and Gross Margin Target (45%) Revenue Performers (R-p) (yellow): meet or exceed Revenue Performance Target (95%) only Gross Margin Performers (GM-p) (orange): meet or exceed Gross Margin Target (45%) only Need Help (red): Not meet both Revenue Performance Target (95%) and Gross Margin Target (45%) -------------------------------------- Key Features -------------------------------------- ๐ KPIs: shows Actual vs Target, trends, and comparison against precious period (MoM and YoY) New card combined with SVG styling (gradient sparkline) New card combined with SVG styling (comparison) Dynamic number formatting (G, M, k, etc.) ๐บ๏ธ Maps: Shape map with custom metropolitan French regions and department maps (topoJSON) Conditional formatting based on Revenue performance & Gross margin. In-Page bookmark for a toggling map view change (Region vs Departement) ๐งพ Table: shows a ranking (top-to-bottom) of Revenue performance & Gross margin, by Product and Sales managers (Departement and Region) SVG Sparkline to show Revenue trend (last 60 days) SVG Styling with Conditional formatting by Products and Sales Manager (Departement and Region) Slicer built with Field parameter. ๐ Magic Quadran: shows Product and Sales Manager in 4 clusters (Leaders, R-p; GM-p and Need Help) Scatter chart Conditional formatting based on Revenue performance & Gross margin. ๐ Audio Wave: shows the variance between Revenue Target and Actuals Error bar Conditional formatting based on Revenue performance & Gross margin. Slicer built with Field parameter for Period selection (D, W, M, Q, Y) -------------------------- The user-guided tour is entirely crafted with native Power BI elements (button, rectangle, speech bubble, and line) and bookmarks -------------------------- I hope this dashboard is useful and inspiring! If you like the dashboard features, please leave a comment and/or give a kudo! ๐ eyJrIjoiZjMxZjU2NWQtZGFlYy00MTA4LTg3Y2MtNzE5MDFhOWVhYmFjIiwidCI6ImE5ZTRlYjg3LWY4OTAtNGE3My05YTYwLTRiMmVjZGI3ZWY4YiJ9&embedImagePlaceholder=true&pageName=ReportSection110d3e656840690c8d4eYour Dashboard Canโt Answer Thisโฆ But This AI Can (Power BI + PowerMind)
Dashboards are powerfulโฆ but they have a fundamental limitation. They can only answer the questions they were designed for. Every new business question often means: โข Creating new DAX measures โข Updating the data model โข Rebuilding visuals And over time, reports become heavier, more complex, and harder to maintain. --- ๐ก This demo explores a different approach: What if your report could answer questions dynamically, without constantly adding new logic? --- ๐ In this report, an AI layer (PowerMind) is integrated directly into Power BI. It allows business users to: โข Ask questions in natural language โข Get instant insights and explanations โข Explore scenarios without modifying the report โข Access answers that were never predefined --- ๐ Impact on report design: Instead of continuously adding: โ Dozens of DAX measures โ Complex logic for every scenario You can: โ Keep a leaner data model โ Reduce the number of measures โ Let the AI handle exploratory and unexpected questions --- ๐ง From a business perspective: Users often rely on analysts to: โข Interpret results โข Answer follow-up questions โข Provide deeper insights This creates delays and bottlenecks. With this approach: โ The report becomes an assistant โ Users get answers instantly โ Decision-making becomes faster and more autonomous --- โจ User experience: Beyond functionality, this also makes reports more engaging and intuitive. In this demo, the AI is integrated in three ways: 1. Embedded directly in the main page. 2. Full-screen experience (see second page) 3. Popup assistant (click the icon in the bottom-left corner) This allows different interaction styles depending on the userโs needs. ๐ Try the interactive report: https://app.powerbi.com/view?r=eyJrIjoiZjAxNmQxZGEtNTliNi00MGRmLWIzMjktMGNkNWVmYzdmYTZhIiwidCI6IjkyMDE4ZTVmLWI1MzctNDQ1MS1iYWVhLThhNTQ5MTRiYmVhMSIsImMiOjF9 --- ๐ง Powered by PowerMind (Querixa) If you're working with Power BI and exploring how to make your reports more intelligent, lighter, and more interactive: ๐ https://querixa.com Happy to hear your feedback and thoughts. #PowerBI #MicrosoftFabric #BusinessIntelligence #DataAnalytics #AI #GenerativeAI #ConversationalAI #SelfServiceBI #DecisionMaking #DataDriven #Analytics #CustomVisual #PowerBICommunity #DigitalTransformation #AugmentedAnalytics #ModernBI #Copilot eyJrIjoiZjAxNmQxZGEtNTliNi00MGRmLWIzMjktMGNkNWVmYzdmYTZhIiwidCI6IjkyMDE4ZTVmLWI1MzctNDQ1MS1iYWVhLThhNTQ5MTRiYmVhMSIsImMiOjF9Marketing Campaign Performance Dashboard
Marketing Performance Intelligence Dashboard โ Built for Growth & ROI-Centric Teams A well-designed marketing campaign dashboard turns complex marketing data into clear, actionable insight. By consolidating key metrics such as sales, profit, ad spend, ROAS, CTR, CPC, impressions, clicks, and conversions into a single view, it enables faster and more confident decision-making. The report reveals: Centralized visibility: Consolidates sales, profit, ad spend, ROAS, CTR, CPC, impressions, clicks, and conversions into one unified view. Performance accountability: Makes it easy to assess which campaigns and channels are driving value versus consuming budget. Faster decision-making: Eliminates manual reporting and enables near real-time performance monitoring. Executive-ready insights: Presents high-level KPIs alongside supporting trends and breakdowns for deeper analysis. What makes this dashboard high-impact? This dashboard provides end-to-end visibility across channels, campaigns, devices, and locations, helping teams quickly identify whatโs working, whatโs not, and where budgets should be optimized. Interactive filters and trend analysis allow users to move seamlessly from high-level KPIs to detailed performance drivers without manual reporting. Ultimately, it supports smarter budget allocation, improved campaign efficiency, and stronger alignment between marketing, finance, and leadership โ transforming data into decisions, not just reports. Thank you, eyJrIjoiM2I4NjQ3OGUtOWU3OC00NjQ0LWIzMzYtNTdhMGU0ZmI2NzliIiwidCI6ImQ4ZTFiMDVlLTcwYWEtNGVmNy1iODc4LTQ2NmI2ODhmOTUyZiJ9
