Are business Dashboards easy to design? You tell me: you’ll need to draw a clear picture of the most valuable information about a business subject, in less than a minute. Of course, it should also be visually appealing, interactive, quick, and self-explanatory, what else?!
Although for many designers the Dashboards conception and development are intuitive activities, especially since the explosion of friendly tools and self-service BI, I believe that some guidelines and a methodology are necessary. To make a difference in the field we need to define our own style, our signature.
I have constantly been trying to “discipline” myself…
Design is one of the essential factors of a successful dashboard. At least as much as its content and the quality of the underlying data. Whereas the dashboard’s content and data quality are clearly measurable, design is more difficult to evaluate objectively, but fortunately we have some guidelines.
Why boring dashboard are boring? Why engaging dashboards are engaging? Dashboard designers need to know what can push a data visualization to rank low or high in the user’s appreciation range.
Some empiric but effective ideas that can give Dashboard design hints are the “Conventional” and “Gestalt” principles.
In this story I…
Tableau recently released a new feature “Quick LOD” that should make it easier to build LOD calculations. As an intensive LOD user, I want to try this feature out and share my thoughts with you.
When we build a data visualization we often need to dispose of multiple aggregation levels of the same measure at the same time, by using LOD calculations.
If we make a conceptual parallel with SQL, LOD expressions allow defining more than one different GROUP BY clauses in…
In this story I want to share a possible way to tackle the tricky understanding of complex (or complicated) SQL queries. When we need to handle some existing SQL code, maybe non-documented, poorly written, or uses SQL versions that we don’t master just yet, it can be frustrating to deal with it.
Whatever thing we need to do with it, just running it as it is, using it in a Data Science or Analytics process, modifying it, etc., in any case we need to understand it.
New data specializations always offer opportunities to the ones who can see them coming.
In this 2-parts story, I want to share some ideas about Self-Service Analytics.
In Part-1 I give an overview of what SSA is, explain the opportunities it offers to Data passionates, and walk through the subjects one needs to learn or improve to work in Self-Service Analytics.
In Part-2 I look in more detail at the needed skill sets, toolkits, and possible entry points to plan the SSA learning.
I call “Self-Service Analytics” the stack techniques and skills that allow anyone (not only technical users) in…
In general, a data model is a representation of how data is organized into database tables. I know, that’s not a rigorous/academic definition, but my only goal here is to be clear. For a given collection of data, representing a Business Process, there is a number of possibles ways to organize store them: do we store all data in 1 big table? Or in 2, in 100,.. ? It depends. For any Data Analytics- driven subject, ranging from classic Business Intelligence to the wildest Data Science applications, a very comfortable and efficient way is using Dimensional Modeling.
The topics will…
Key Performance Indicators (KPIs) are the bricks of any Dashboard, in any Business domain. A smart way to make those bricks is developing a KPI template, which is a set of expressions and parameters that blend data to explain the Business. Ok, but how can we make a KPI template?
In this article, I’m going to explain and show how to develop the underlying objects of a clean KPI visualization in a professional Dashboard. The idea is to build a KPI template that can be applied to any business domain.
“Upskilling” in any Data topic means 2 complementary things: learning new skills (languages, algorithms, etc.), and keeping up-to-date the skills you have already built.
In this story, my goal is to share with you some ways to upskill SQL / PL-SQL / T-SQL skills.
Any Data Science discipline, or any job title containing the “..Data..” word, requires at some point to query a database and to do some developments. Actually, any job interview I ever did (either as an interviewer or interviewee) tested the candidate’s SQL expertise, among other things.
But here comes the problem: once we get the job…
2020 gives birth to the unified “Social Credit System” in China. Before it becomes pandemic, I explain why Data Science can’t judge humans.
2020 will go down in history as the year of Covid-19. But another event could impact society even more: the final phase of the “Social Credit System” implementation in China.
I am going to share with you some of my thoughts on the topic, from a Data perspective. And I want also to raise some questions in particular (but not only) for Data Scientists.
Why do we care about the Chinese case? Because it is the first…
My 0$ “real-world” Data Science environment at home: Database, ETL, Data analytics, Dashboarding, in 9 steps.
In this my first Medium post I want to share with you a way to create a “real-world” data environment at home, based on the same components that most companies use to handle their data. Of course, on a much much smaller scale, and for free.
Why? I used similar frameworks when I was preparing for job interviews, to learn more about new Data Science tasks, reporting, database administration and development, and also to organize my own work.
The framework I’m presenting here is…
Data freelance. Data literacy evangelist. Math & music hobbyist.