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.
Firstly, there would be the function
IS_NAN(). This helps you to check if the value you want to calculate is a valid number or a NaN (Not a Number).
So in this example we would get back a false.
This function helps you to find the largest value from a…
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 example, the shares of:
Most of the companies you will hear about originate from the US. There are really no (big) players in the area of cloud or data analytics based in Europe, Africa or Asia (besides China). …
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 . At the end of the day, communication also works like on a Jupyter notebook and can be realized in the same way. In this article, I show you three typical and famous use cases which you can use for your projects and get a first idea how to use the Python and BigQuery together.
The integration of libraries via an import command is essential for the communication between BigQuery and Google Datalab…
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. But you should also be able to describe your plans briefly and concisely in discussions with management.
A user story is a software requirement formulated in everyday language and is deliberately kept short. For a deeper dive I would recommend the following article . In this example, I was actually able to keep the user story very short, as…
User research is an important part of the product development process and the user experience. After all, the end user is the best person to find out whether the developed product really meets their expectations and needs. In this article I would like to show three reasons why it is essential to know your user.
User Research can be extremely helpful to create a solid base for a good product design. By researching before the actual creation process, companies can detect the truly important features that users would like to have to meet their expectations and needs. User Research is…
What actually is a CIO and what are their tasks? How can they ensure future-driven IT while keeping operations running and what are CDOs, CTOs and CISOs?
A Chief Information Officer (CIO) generally performs tasks of strategic and operational management of information technology (IT) in a company. The CIO fulfills a cross-sectional task and should be able to negotiate at eye level with the board members, e.g., CEO or CFO .
The basic tasks of an IT manager is to ensure the operation of the IT systems and supporting the IT infrastructure. Due to the high level of dependency and…
Every IT manager is concerned with how to make the case for the cloud and justify the costs. But also whether the operation is really more cost-effective if it is not hosted by yourself. Here are my experiences with metrics that should or could be taken into account.
Cloud ROI (return on investment) is a measurement of how much money and time you save or make back from an investment in cloud technology .
Continue to host infrastructure, on-premise companies will notice that operating their own infrastructure in-house means large investments into their own hardware and software. But also other…
Finally, there is a standard connector from Data Studio to MySQL databases. Until recently, you could not natively connect Google’s great and free BI tool to MySQL databases . Here, I often had to take the detour and make data accessible via a Data Lake or Data Warehouse based on BigQuery, for example. Often, this is the standardized approach, but for smaller use cases and companies that may only run a handful of MySQL databases, the approach directly via Data Studio is of course simpler, faster and more cost-effective.
Under the menu item “Add data to report” you can then…
How can I align my Data Science or BI team well with what customers want and achieve greater customer satisfaction? Here, Jira and the Feature Forms are an ideal possibility. There are also great opportunities to bring this requests directly into the daily business of the data team.
With Jira Forms you can easily record feature requests from the business digitally. All you need is a free Jira account (usable with up to 10 people) and you’re ready to go.
If you just want to test a connection to a database, you can use the service freeSQLdatabase  with up to 5 MB. I use this service relatively often, because you always want to test a small use case, especially in the age of cloud and companies are reluctant and often very slow to put a test database on the public network.
Step 1: Set up an Account
Just go to the website and create your free account via email. This includes phpMyAdmin and 5 MB of storage.