Juan G. Profile

EXPLORE

0.0

(0 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$70 USD / hour

madrid,

spain

$70 USD / hour

It's currently 9:42 PM here

Joined April 3, 2024

0 Recommendations

Juan G.

@Juanpebble

0.0

(0 reviews)

0.0

$70 USD / hour

madrid,

spain

$70 USD / hour

N/A

Jobs Completed

N/A

On Budget

N/A

On Time

N/A

Repeat Hire Rate

Senior Business Intelligence and Data solutions

I am a Senior Business Intelligence (BI) professional with over 6 years of experience in top-tier multinational companies. My focus is on creating ETL processes, designing dashboards, and analyzing data for strategic decision-making. In addition to my expertise in Excel and data management, I am proficient in the following tools and technologies: - **Python**: I leverage Python for data manipulation, analysis, and automation. - **SQL**: I am skilled in writing SQL queries to extract, transform, and load data from various databases. - **Tableau**: I create interactive visualizations and reports using Tableau to convey insights effectively. - **Qlik**: I utilize Qlik for data discovery, visualization, and business intelligence. - **Google Analytics**: I analyze website traffic and user behavior using Google Analytics.

See all Python Developers in Spain

Contact Juan G. about your job

Portfolio

I possess experience in SQL database management and have utilized it to develop interactive dashboards using Power BI and Qlik Sense.

My responsibilities have included data cleansing and structuring to create databases optimized for utilization within Power BI and other visualization platforms, ensuring seamless integration and efficient future utilization.

ETL, SQL and Data visualization

I have developed numerous business intelligence dashboards within Excel. One such example is an automated sales report tailored for Directors and Managers to gauge the performance of our sales team comprehensively.

This dashboard seamlessly integrates with our database through Power Query, ensuring real-time data updates. All visualizations are dynamic, adapting instantly to selected parameters. Profiles, contact information, and performance metrics adjust dynamically based on the chosen seller.

Moreover, a user-friendly interface includes a print function facilitated by a macro, enabling convenient document generation for offline reference.

Dashboard in Excel- Dynamic Sales Performance

I have created the main dashboard to monitor all digital business activities within one of the most prominent German companies.

I've integrated Google Analytics with another diverse data source, creating a comprehensive 360-degree dashboard. In this view, we can access SEO information, various trends, as well as a dashboard showcasing sales, traffic sources, top-selling products, and much more.

Data Studio Visualizations- Online business

ETL, SQL and Data visualization

Dashboard in Excel- Dynamic Sales Performance

Data Studio Visualizations- Online business

Reviews

Changes saved

No reviews to see here!

Experience

Tech Company

Jan 2024 - Present

-Definition, development and implementation of reports, dashboards, and visualizations to present key insights to stakeholders. -Analyze sales data to identify trends, patterns, and opportunities for improvement. -Collaborate with cross-functional teams to understand business requirements and translate them into analytical solutions. -Assist in business decision making -Find innovative solutions to challenging problems

Gambling Industry

Jan 2022 - Jan 2024 (2 years)

Regional Business Analyst. Responsible for the business analysis of a specific group of countries, providing insights to the management and commercial team with the aim of improving business metrics and getting the most out of the raw data set.

Multinational Company

Jan 2019 - Jan 2022 (3 years)

Giving support to other departments in data analysis, solution design, action plans, and changes to ensure a smooth running of the business. Drawing conclusions from data and business results. Preparation of reports/business status presentations aimed at decision-making by the management team.