i
idrees_kan

Idrees Khan

@idrees_kan

Business Intelligence Dashboards and ETL

Pakistan
English, Urdu
About me
I build clean, interactive BI dashboards that turn messy data into clear decisions. 5+ years experience and 200+ dashboards delivered across operations, marketing, finance, and healthcare. Tools: Power BI, Tableau, Excel, SQL, Power Query, DAX. Share your KPIs and data source and I will deliver a dashboard that is fast, accurate, and easy to use.... Read more

Skills

i
idrees_kan
Idrees Khan
Offline • 

See my services

BI Analytics
I will build a bi dashboard with sql data model and automated reporting
From$15 / projectMore details
Data Dashboards
I will create an interactive tableau dashboard with KPI tracking and data visualization
From$20 / projectMore details

Portfolio

Work experience

Data Analyst | Power BI Developer

Afiniti

Feb 2023 - Dec 2025 • 2 yrs 10 mos

Built interactive Power BI dashboards to track real time customer interactions and key performance metrics for the team. Optimized data models and Star Schema relationships to handle complex datasets which specifically reduced report loading times and improved query performance. Utilized Power Query (M) to clean and process raw data while supporting Talend ETL pipelines to ensure consistent data flow from multiple sources. Wrote complex DAX measures to calculate custom metrics and turned raw data into actionable insights that helped the business identify customer churn risks. Defined standard KPIs in partnership with business analysts to create a Single Source of Truth and removed data discrepancies so the team could rely on consistent numbers

Senior Data Analyst | Tableau Specialist

Articares

May 2019 - Sep 2022 • 3 yrs 4 mos

Lead the Business Intelligence team by mentoring analysts and coordinating project workloads to ensure the timely delivery of high quality insights. Designed and architected a centralized Data Warehouse using dimensional modeling and Star Schema to create a unified structure that consolidated data from disparate sources. Designed and executed ETL workflows using Pentaho to handle the extraction and transformation of data ensuring the warehouse was populated with clean inputs. Write and optimize advanced SQL scripts to support the new warehouse architecture by improving query performance and ensuring seamless data retrieval for analytics. Develop dynamic Tableau dashboards directly on top of the optimized data warehouse to translate complex backend data into intuitive KPIs for stakeholders. Collaborate directly with clients to gather business requirements and translate their needs into technical specifications for strategic insight presentations. Produce comprehensive technical documentation detailing the data warehouse schema and dashboard functionality to ensure long term maintainability and knowledge transfer.