Data Business Analyst
SCALING BUSINESSES WITH DATA VISUALIZATION. Developing tools to transform data-driven into Business-decision. SQL and Visualization Tools. Excel, GSheets, Power BI and Tableau.
BI Methodology
1.
Diagnostic
Is there clarity in the department regarding actions, objectives, and strategy. Is everyone committed to the department's objective? What data is created, needed, and used?
1.
Diagnostic
Is there clarity in the department regarding actions, objectives, and strategy. Is everyone committed to the department's objective? What data is created, needed, and used?
2.
Analytics Engineering and Commercial Business Plan
With analytics engineering, I ensure that the data is useful for analysis: I design dimensional models (star schema) for dashboards, complex SQL queries for business metrics, and document standardized KPI definitions.
2.
Analytics Engineering and Commercial Business Plan
With analytics engineering, I ensure that the data is useful for analysis: I design dimensional models (star schema) for dashboards, complex SQL queries for business metrics, and document standardized KPI definitions.
3.
Business Intelligence and Visualization
With business intelligence, I create daily visual tools that keep our KPIs and reports up-to-date, used by all decision-makers. Creative dashboards that all departments can read and understand.
3.
Business Intelligence and Visualization
With business intelligence, I create daily visual tools that keep our KPIs and reports up-to-date, used by all decision-makers. Creative dashboards that all departments can read and understand.
4.
Forecasting Models and Data Culture
And now, I can integrate forecasting models. Let's continue digging deeper into data culture.
4.
Forecasting Models and Data Culture
And now, I can integrate forecasting models. Let's continue digging deeper into data culture.
Past Experiences
Master Scorecard Tool
Visualize sales, profit, and logistics KPIs on a single page. The perfect tool for every Monday meeting.
Commercial Business Plan Review
At the end of each quarter, let's review the Business Plan. Different areas, different action plans, but all with the same analytical spirit.
Analyzer Tool
A dynamic dashboard that guides us from the general to the particular, in each commercial decision.
Scorecard by Area or Category or product
Each unit as an element of strategy, let's analyze our KPIs defined by Analytical Engineering.
SQL Queries
To ensure that the data is useful for analysis, i use analytics engineering in all SQL queries.
