Temp Tables

Welcome to AInI: Analytics and Inspirational Ideas

Oct 10, 2020

Hi! I am Ainize, a data visualization, analytics and science passionate, but also a curious explorer of frameworks, models a innovation and ideas.

Basically anything that has to do with Analytics and INspirational Ideas.

Analysing Customer Dynamics with PowerBI

Dec 12, 2017

IDEAS: Customer Segmentation Retetion/Churn Value of your customer database Projection Customer, loyality, retention and value Movements Segments Dynamics PAST- Retention, Churn PRESENT- Segments, Value FUTURE -Projection of segmetns and value WHY IS THIS IMPORTANT? Because it would help you unlock the direction of your customer database and improve your retention strategy. Replicabel with your transactional dataset

Understanding our Customer Database is essential to understand our business. Not only which are the loyal clients, the new ones, the ones that are more likely to churn or the high value ones, but also understanding the dynamics between this groups and what is the trend moving forward.

We can learn about what makes a customer stay or leave and define out strategy by simply analyzing historical transactional data.

For this example I will use a dataset provide by the UCI, which contains all the transactions occurring between 01/12/2010 and 09/12/2011 for a UK-based and registered non-store online retail.

Machine Learning Fireside Chats by BBC Blue Rooms

Oct 10, 2017

Yesterday I attended for the first time the Machine Learning Fireside Chats meetup run by the BBC Blue Room. Even though it was quite far from work and home I could not help going after seeing the name of the speakers on the line up.

SQL Procedures in Alteryx

Jul 7, 2017

Do you love Alteryx but have already complex SQL queries that you would like to use as your input data? Alteryx is great and it is usually my go to point when I need to manipulate data. However, in the team we also use SQL quite often, for instance, there are some pre-defined queries that make it easier for us to get the output we want. In some cases, I want to develop further manipulation or analysis on those tables connecting them directly to Alteryx.

R & Git

Jun 6, 2017

I have being using R since I was at uni and I did recently discovered how to sync it with Github for version control of projects which is making my life much easier. I love being to have a version control of my project. Moreover, I can use any computer to work on my app which is giving me a lot of flexibility. There are obviuosly other tool as Google Drive, One Drive…that you can use to save your work through laptops but I just find the integration of R with Github very handy.

Tableau filters - Part II

May 5, 2017

Following from the previous post on “Tableau filters - Part I”, let’s get down to the nitty gritty how tos! We start with a graph and a filter, simple. The following graph shows the percentage of people per state that agree with each of the statements. Each state is a bar, the more on the right the bar is the bigger percentage of the population in that specific state agrees with that sentence.

Tableau filters - Part I

May 5, 2017

When it comes to Tableau Dashboards, I am known as a filter-hater within my team. I find them ugly and not very user friendly. That’s why I always try to find new ways to make filters more user-friendly. It usually helps me going through the following process: Built a Dashboard that is able to show the needed level of detail (use all the filters you need) See if some coloring/shaping can help If filtering is needed, can you incorporate it nicely in the view?

Hello World

May 5, 2017

Hello world! I am Ainize, Commercial Analyst in Global during the day and Consultant for ISGlobal at night. I am passionate about analytics, decision making, data, frameworks and having an impact through numbers. And that is what I will be writing about. Bilbao, Utrecht, Barcelona, Chicago and London are how I would describe my career so far. Each city has given me something different and special, not only at a professional level.

Posts

Oct 10, 2020