How to get started with Analytics in the Field of HR and important Measures like Employee Satisfaction
Whether you are a data scientist, analyst or business analyst, it is useful to understand what the individual departments actually do. What are their goals, how do they earn their money directly or indirectly, and how can the success be measured? It helped me to understand the key figures of…
What you should analyze when thinking about buying a Connector Software
It may well be that instead of programming each data pipeline yourself using e.g. Python and building an architecture for it, it can often be an option to buy a connector. The market for this is relatively large and ranges from holistic solutions such as talend and Alteryx to connectors…
How to Improve Report Performance in Data Studio
If you haven’t seen it yet, Google has made Data Studio even more powerful. Previously, there were only live connections to data sources, now there is the possibility to create snapshots via the Extract Connector, so that data does not always have to be reloaded.
Technical Features
Data extract creates a snapshot…
Cheat Sheet when working with Nested Data Structures
In the field of Data Science or Business Intelligence, one often comes into contact with nested data, for example when working with data from Google Maps or its open source counterpart OpenStreetMap and many other data sources. …
What are some Antipatterns in Business Intelligence and Designing Dashboards?
What are the don’ts when designing dashboards? Here are my experiences on what to avoid as a BI and Data Analytics team when creating dashboards and reports.
Mistake 1: Overloaded Dashboards
You should not overload your dashboards. Not by the number of charts and not by color or text. Here is an example from…
How User can improve Google Data Studio by Democracy
In case you didn’t know — Google has a super powerful BI tool named Data Studio. And the cool thing is that it’s also free. Learn more here [1]. But even better is that Google, as so often, offers a voting for new features [2]. …
How to Work with Numbers in BigQuery
Google’s BigQuery offers a whole range of math functions you can use — check here for more info. However, in my opinion there are a few functions that you really use often and need frequently especially in analytics and dashboarding. Maybe these will help you with your next project.
IS_NAN
Firstly…
Opinion — Why Big Tech Companies will continue their Growth in the Future
Possible Trends and Tendencies
Technology stocks skyrocketed over the past years, and many analysts believe they will continue to soar in the coming future — despite the COVID-pandemic, or precisely because of it, companies were forced to invest in digitalization especially in the field of Big Data, AI and Data Science.
Experts recommend, for…
How to work with BigQuery by using Python
For this example, I used Google Datalab. Cloud Datalab is easy to explore, visualize, analyze, and transform data using familiar languages, such as Python and SQL, interactively [1]. At the end of the day, communication also works like on a Jupyter notebook and can be realized in the same way…
Using the Concepts of Storytelling, Acceptance Criteria and the Big Idea
As a product owner, how can you package the requirements of the business into a user story that is easy to understand? It is also important that this is later understood by the developer and implemented close to the customer’s wishes. …
