Logo Freelancer.com
Zaloguj się Zarejestruj się
Opublikuj Projekt
ODKRYWAJ
Azure
Excel
MySQL
Python
SQL
Zdjęcie profilowe
Zacząłeś obserwować
Błąd związany z obserwowaniem użytkownika.
Ten użytkownik nie pozwala użytkownikom na obserwowanie go.
Już obserwujesz tego użytkownika.
Twój abonament pozwala na obserwowanie 0 projektów. Zmień poziom abonamentu na wyższy tutaj.
Udało się przestać obserwować
Błąd w zakończeniu obserwowania użytkownika.
Udało Ci się polecić
Błąd podczas polecania użytkownika
Coś poszło nie tak. Proszę odświeżyć stronę i spróbować ponownie.
Udało się zweryfikować adres e-mail.
Awatar Użytkownika

Lookthru Limited

@JoshuaS23

monthly-level-two.svgverified-v2.svg
0,0
0
0,0
0,0
0%

Azure | Power BI | BI & Data Driven Solutions

$70 USD / godz.
・
Flaga
United Kingdom (6:12 AM)
・
Dołączył/a października 25, 2024
$70 USD / godz.
・
Lookthru is an end to end BI Consultancy specialising in solutions that add value and are tailored to your requirements. - Power BI Development - Datawarehouse Implementation - App Development - ML/AI Development - Azure - Tableau - AWS We can't help everyone but we may be a great fit, if you: ✅ Are investing in getting the most from your data. (Processes to Visualisation). ✅ Reduce manual dependencies and have scalable, optimised solutions developed for your needs. ✅Want to utilise Azure or AWS to take advantage of Cloud Architecture. ✅Want to automate new or existing processes in Power Automate, MS Flow or Azure Logic Apps. ✅Need ETL Pipelines in Azure Data Factory, Synapse Pipelines, AWS Glue or SSIS. ✅Want modern data solutions that make your data easily accessible to everyone who needs it, when they need it. Utilising MS SQL, PostgreSQL or MySQL in the cloud or on-premise. ✅Visually appealing dashboards in Power BI, Power Apps, Google Data Studio or Tableau.
Weryfikacje
Freelancer Python Developers United Kingdom
Wyświetl Wszystkie Python Developers w United Kingdom

Portfolio

Portfolio

Wszystkie
Power BI (9)
Tableau (1)
Data Warehousing (4)
App Development (1)
12319445
Problem: The client faced challenges in consolidating diverse marketing data across multiple channels—including digital PPC ads on Bing, Google, and Facebook, as well as offline efforts like billboards, calls, and newspaper ads. This fragmentation prevented them from accurately assessing their marketing ROI or understanding customer lifetime value (LTV). Solution: Lookthru provided a comprehensive data integration solution to unify these marketing streams into a single, interactive Power BI dashboard. This dashboard offers a holistic view of the client’s marketing performance, enabling them to make data-driven decisions around ad spend, track ROI, and accurately calculate customer LTV. With Lookthru’s solution, the client now has the insights needed to refine strategies across channels and optimize their marketing impact.
Marketing Power BI Dashboard
12319443
The global chain struggled with fragmented data across various systems, including their CRM, ERP, and multiple SaaS solutions. This lack of centralized data made it difficult for leadership to make informed, data-driven decisions in key areas such as identifying ideal client profiles, determining optimal gym locations, and implementing proactive measures to prevent client churn. Without a unified view, the gym chain couldn't fully leverage its data to enhance customer engagement, boost retention, and strategically plan for growth. Solution: Lookthru delivered a comprehensive data warehousing and reporting solution to address these challenges. First, we set up an ETL process using AWS Redshift and lambda functions, consolidating data from the client’s CRM, ERP, and SaaS applications into a robust data warehouse. This centralized data repository provided a single source of truth, ensuring consistent and reliable data across all levels of the organization.
AWS Datawarehouse Development & Power BI Dashboards
12319441
A UK public sector organization faced challenges in tracking user adoption across the country. Without centralized data, they were unable to see where users originated, understand why they adopted the application, or measure the application's financial benefits. This lack of visibility limited the client’s ability to assess program impact and allocate resources effectively. Solution: Lookthru implemented a custom data integration solution to address these needs. Leveraging AWS Lambda, we set up a continuous data stream from AWS into a SQL environment, using AWS RDS to manage the data effectively. From here, we built a comprehensive data model tailored to the client's requirements, making the data available for reporting in both Power BI and Tableau. In the final solution, we developed intuitive dashboards that provided the client with real-time insights into user adoption patterns across the UK.
Tableau & Power BI Dashboard Development
12319437
Problem: The client faced a significant hurdle in extracting data from a non-conventional source, which lacked standard options for data extraction. This limitation hindered their ability to analyze key performance indicators (KPIs) effectively, impacting decision-making and overall business performance. The client needed a robust solution to access this data and transform it into actionable insights. Solution: Lookthru stepped in to provide a comprehensive solution tailored to the client's needs. We began by developing a custom API that enabled the extraction of data from the unconventional source. Alongside this, we designed an ETL process to streamline data flow into a newly developed data warehouse. Once the data was successfully landed in the warehouse, we proceeded to model the data to ensure it was structured for optimal analysis. Subsequently, we built a series of interactive reports using Power BI, enabling the client to visualize and understand their KPIs effectively.
ETL, Datawarehouse & BI Report
12319433
Problem: An Australian government body faced significant challenges in collecting and analyzing responses from businesses within its jurisdiction. With no existing system for data collection, processing, or visualization, the agency struggled to manage the overwhelming influx of data, resulting in delays and inefficiencies in decision-making. Solution: Lookthru provided a bespoke solution by closely collaborating with the app development team. We extracted data from DynamoDB in AWS and meticulously modeled it in Power BI, resulting in a fully dynamic report capable of analyzing thousands of responses. This innovative approach not only allowed the agency to act swiftly but also saved weeks of manual analysis for each data collection cycle.
Custom Power BI Development
12319427
Problem: In a fast-paced environment, the client struggled to track calls, personnel, and activities in real time. Without the ability to monitor these metrics instantaneously, they faced challenges in resource allocation and responding to dynamic demand, hindering operational efficiency. Solution: Lookthru provided a bespoke solution by setting up a real-time dashboard that streams data from the telemetry system. Utilizing Power BI and Power BI streaming datasets, we created an interactive and visually engaging dashboard that allows the client to track calls, people, and activities as they occur. This implementation enabled the client to resource effectively and gain immediate insights into demand, facilitating timely decision-making.
Realtime Power BI Dashboard
12319445
Problem: The client faced challenges in consolidating diverse marketing data across multiple channels—including digital PPC ads on Bing, Google, and Facebook, as well as offline efforts like billboards, calls, and newspaper ads. This fragmentation prevented them from accurately assessing their marketing ROI or understanding customer lifetime value (LTV). Solution: Lookthru provided a comprehensive data integration solution to unify these marketing streams into a single, interactive Power BI dashboard. This dashboard offers a holistic view of the client’s marketing performance, enabling them to make data-driven decisions around ad spend, track ROI, and accurately calculate customer LTV. With Lookthru’s solution, the client now has the insights needed to refine strategies across channels and optimize their marketing impact.
Marketing Power BI Dashboard
12319443
The global chain struggled with fragmented data across various systems, including their CRM, ERP, and multiple SaaS solutions. This lack of centralized data made it difficult for leadership to make informed, data-driven decisions in key areas such as identifying ideal client profiles, determining optimal gym locations, and implementing proactive measures to prevent client churn. Without a unified view, the gym chain couldn't fully leverage its data to enhance customer engagement, boost retention, and strategically plan for growth. Solution: Lookthru delivered a comprehensive data warehousing and reporting solution to address these challenges. First, we set up an ETL process using AWS Redshift and lambda functions, consolidating data from the client’s CRM, ERP, and SaaS applications into a robust data warehouse. This centralized data repository provided a single source of truth, ensuring consistent and reliable data across all levels of the organization.
AWS Datawarehouse Development & Power BI Dashboards
12319441
A UK public sector organization faced challenges in tracking user adoption across the country. Without centralized data, they were unable to see where users originated, understand why they adopted the application, or measure the application's financial benefits. This lack of visibility limited the client’s ability to assess program impact and allocate resources effectively. Solution: Lookthru implemented a custom data integration solution to address these needs. Leveraging AWS Lambda, we set up a continuous data stream from AWS into a SQL environment, using AWS RDS to manage the data effectively. From here, we built a comprehensive data model tailored to the client's requirements, making the data available for reporting in both Power BI and Tableau. In the final solution, we developed intuitive dashboards that provided the client with real-time insights into user adoption patterns across the UK.
Tableau & Power BI Dashboard Development
12319437
Problem: The client faced a significant hurdle in extracting data from a non-conventional source, which lacked standard options for data extraction. This limitation hindered their ability to analyze key performance indicators (KPIs) effectively, impacting decision-making and overall business performance. The client needed a robust solution to access this data and transform it into actionable insights. Solution: Lookthru stepped in to provide a comprehensive solution tailored to the client's needs. We began by developing a custom API that enabled the extraction of data from the unconventional source. Alongside this, we designed an ETL process to streamline data flow into a newly developed data warehouse. Once the data was successfully landed in the warehouse, we proceeded to model the data to ensure it was structured for optimal analysis. Subsequently, we built a series of interactive reports using Power BI, enabling the client to visualize and understand their KPIs effectively.
ETL, Datawarehouse & BI Report
12319433
Problem: An Australian government body faced significant challenges in collecting and analyzing responses from businesses within its jurisdiction. With no existing system for data collection, processing, or visualization, the agency struggled to manage the overwhelming influx of data, resulting in delays and inefficiencies in decision-making. Solution: Lookthru provided a bespoke solution by closely collaborating with the app development team. We extracted data from DynamoDB in AWS and meticulously modeled it in Power BI, resulting in a fully dynamic report capable of analyzing thousands of responses. This innovative approach not only allowed the agency to act swiftly but also saved weeks of manual analysis for each data collection cycle.
Custom Power BI Development
12319427
Problem: In a fast-paced environment, the client struggled to track calls, personnel, and activities in real time. Without the ability to monitor these metrics instantaneously, they faced challenges in resource allocation and responding to dynamic demand, hindering operational efficiency. Solution: Lookthru provided a bespoke solution by setting up a real-time dashboard that streams data from the telemetry system. Utilizing Power BI and Power BI streaming datasets, we created an interactive and visually engaging dashboard that allows the client to track calls, people, and activities as they occur. This implementation enabled the client to resource effectively and gain immediate insights into demand, facilitating timely decision-making.
Realtime Power BI Dashboard
Zmiany zapisane
0.0 · 0 Reviews
Oceny
Brak ocen do zobaczenia!
Doświadczenie
Principal Architect
lis, 2018 - Aktualnie
•
6 lat, 4 miesiące
Lookthru
lis, 2018 - Aktualnie
•
6 lat, 4 miesiące
No Description Provided
P

Gareth H.

@pixelfusion1

 ·
Director - Client
I had the pleasure of working with Josh, and I can highly recommend him as a skilled and dedicated professional. Throughout our time working together, Josh consistently delivered high-quality work, displaying impressive technical proficiency and a deep commitment to project success. He approached every task with reliability, a collaborative mindset, and keen problem-solving skills, which greatly contributed to our team’s productivity and overall project outcomes. Josh is adept at handling complex challenges and consistently meets deadlines without compromising on quality. His attention to detail, clear communication, and adaptability made him an invaluable asset to our team. I am confident he will excel in any project he undertakes.
lis, 2018 - Aktualnie
•
6 lat, 4 miesiące
Senior BI Consultant
mar, 2021 - maj, 2023
•
2 lata, 2 miesiące
Hitachi Solutions
mar, 2021 - maj, 2023
•
2 lata, 2 miesiące
No Description Provided
mar, 2021 - maj, 2023
•
2 lata, 2 miesiące
Certyfikaty
US English - Level 1
US English
SQL - Level 1
SQL
Zaproszenie wysłane pomyślnie!
Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Logo Freelancer.com Poland / Polski
Pomoc i Wsparcie

Freelancer

Kategorie Projekty Konkursy Freelancerzy Enterprise Innowacyjne Wyzwania Rozwój Sztucznej Inteligencji Abonament Program Ulubionych Freelancerów Zarządzanie projektami Projekty lokalnePhoto Anywhere Prezentacja Interfejs API dla deweloperów Przejdź proces weryfikacji Aplikacja komputerowa

Na temat

Informacje o nas Jak to działa Ochrona Inwestor Mapa strony internetowej Historie Wiadomości Zespół Nagrody Materiały prasowe Kariera

Warunki

Polityka Prywatności Warunki świadczeń usług Polityka dotycząca praw autorskich Zasady postępowania Opłaty i prowizje

Partnerzy

Escrow.com Loadshift Warrior Forum

Aplikacje

Logo Apple App StoreLogo Google Play
Nie udało się skopiować do schowka. Proszę, spróbować ponownie po dostosowaniu uprawnień.
Skopiowane do schowka.

Zarejestrowani Użytkownicy

Całkowita Liczba Opublikowanych Projektów

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)