🥇 Microsoft Certified Data Analyst
🥇 Senior Data Analyst and Engineer with more than 8 years of experience
🤵 Expert on complex data transformations and pixel-perfect reports development
🛠️ Power BI, Tableau, and Google Data Studio Expert. Other tools I'm proficient with : Metabase, AWS Quicksight , Azure Synapse, among others.
💻SQL, Python expert: scripting, data ingestion, stored procedures, etc.
I take the time to study every single project either complex or simple. This allows me to finish up the projects exceeding client expectations and within the deadline.
I am an expert in the following technologies and skills:
☑ Power BI Reports (Development & Maintenance)
● Get Data from several sources: SQL, NoSQL, CRM, ERP, API, Excel/CSV files, and other platforms.
● Cleaning and transformation using PowerQuery, Dataflows, centralized Datasets and Python scripting.
● Complex DAX measures to be represented in different visuals.
● Dynamic reports with filter, slicing, complex functionalities.
☑ Power BI Service Admin Portal Management
● Pro, Premium per User, Premium per Capacity, Embedded License analysis and dimensioning.
● User and Workspace management.
● Email subscription, alert thresholds configuration.
● Power BI API for analysis and complex tasks (identify datasets that take longer, add users automatically to any workspace, etc).
☑ Tableau Reports (Development & Maintenance)
● Data Source Integration: Proficient in connecting to various data sources such as SQL databases, NoSQL databases, CRM systems, ERP systems, APIs, Excel/CSV files, and more to extract and integrate data into Tableau.
● Data Preparation: Utilize Tableau's data preparation tools to clean, transform, and structure data effectively for reporting purposes.
● Advanced Calculations: Create complex calculations and measures using Tableau's calculated fields, table calculations, and level of detail (LOD) expressions for in-depth data analysis.
● Interactive Dashboards: Develop interactive and visually appealing Tableau dashboards with filter options, parameter controls, and dynamic actions to empower users in exploring data.
● Storytelling: Craft compelling data-driven stories using Tableau to communicate insights effectively to stakeholders.
☑ Tableau Server Administration
● Server Deployment: Expertise in deploying Tableau Server on-premises or on the cloud, ensuring high availability and scalability.
● User Management: Manage user accounts, groups, and permissions to ensure secure and controlled access to Tableau resources.
● Performance Optimization: Monitor server performance, identify bottlenecks, and optimize workbooks and dashboards for faster loading and responsiveness.
● Scheduled Refresh: Configure and schedule data source refreshes to keep dashboards up to date.
● Troubleshooting: Diagnose and resolve Tableau Server issues efficiently to minimize downtime.
☑ Looker Reports (Development & Maintenance)
● Data Modeling: Design and implement data models within Looker, creating a semantic layer for easy and consistent data exploration.
● LookML Development: Proficient in LookML to create reusable data definitions, explore data, and build custom dashboards.
● Custom Visualizations: Design and build custom visualizations using Looker's advanced charting capabilities.
● Embedding Looker: Integrate Looker into web applications or portals for seamless data access and visualization.
● Data Driven Insights: Utilize Looker's exploration features to uncover valuable insights from data and share them through reports and dashboards.
☑ Looker Instance Administration
● Instance Setup: Configure and set up Looker instances, ensuring optimal performance and security.
User Access Control: Manage user access, roles, and permissions within Looker to maintain data security and privacy.
● API Integration: Leverage Looker's API for automation, data extraction, and integration with other tools and platforms.
● Maintenance and Support: Perform routine maintenance tasks, handle upgrades, and provide ongoing support to ensure the smooth operation of Looker instances.
● Please feel free to contact me for an estimate of your project or any other inquiries.
Thank you for your time!