Skip to main content

Data og BI Blog

Vi sætter fokus på data og business intelligence. Her deler vi vores erfaringer inden for data warehouse arkitektur, DAX og data modellering.


Predictive Analytics

Predictive analytics is a type of data analysis that uses statistical algorithms and machine learning techniques to identify patterns in data and make predictions about future events.It involves analyzing current and historical data to make predictions about future events or outcomes, such as customer behavior, market trends, or risk assessment.Predictive analytics relies on data mining, machine learning, and statistical analysis to make predictions.

Data Visualisation

Data VisualizationData visualization is the process of creating graphical representations of data in order to better understand, analyze, and communicate the insights and patterns that are present in the data.It involves using visual elements, such as charts, graphs, and maps, to represent data in a way that is easy to understand and interpret.Overall, data visualization is an important tool for data analysis and communication, and it is widely used in a variety of fields and applications, including business, science, and government.

Microsoft Cognitive Services

Microsoft Cognitive Services is a collection of APIs, SDKs, and services that enable developers to build intelligent applications that can see, hear, speak, understand, and interpret people’s needs using natural methods of communication.Cognitive Services includes a range of APIs and services that can be used to build applications that can understand and interpret text and speech, recognize and classify images and video, and analyze and understand sentiment and emotions.Cognitive Services is used in a wide range of applications, including image and speech recognition, natural language processing, customer service, and language translation.

Machine learning vs Artificial intelligence

– Machine learning and artificial intelligence (AI) are related, but distinct, fields of study and technology.– Artificial intelligence, on the other hand, is a broader field that encompasses machine learning as well as other approaches to building intelligent systems.– In summary, machine learning is a specific approach to building AI systems that involves training algorithms on data, while AI is a broader field that includes machine learning as well as other approaches to building intelligent systems

Prescriptive Analytics

A note on Prescriptive Analytics– Prescriptive analytics is a type of data analysis that uses advanced mathematical and computational techniques to generate recommendations for action.– Prescriptive analytics combines data, statistical algorithms, and machine learning techniques to generate insights and recommendations that can help organizations make better decisions.– By providing organizations with specific recommendations for action, prescriptive analytics can help them optimize their operations, reduce costs, and improve performance

What is Row Level Security

Row-level security (RLS) is a feature that allows you to control access to rows in a database table based on the user executing a query.It is used to implement data security policies that limit access to data based on the user’s role or identity.Overall, RLS is a useful tool for implementing data security policies and protecting sensitive data in a database.

Fundamental Tool: Microsoft Analysis Services

Microsoft Analysis Services is a business intelligence (BI) platform that enables organizations to create and deploy online analytical processing (OLAP) and data mining models for use in BI and analytics applications. It is a component of the Microsoft SQL Server database software, and it is designed to provide fast and efficient access to large volumes of data for analysis and reporting. Analysis Services supports two main types of models: multidimensional models and tabular models.

About the concept Tabular Model

A tabular model is a data model that is used to represent data in a tabular format for analysis and reporting. Tabular models are used in a variety of applications, including data warehousing, business intelligence, and data analysis. Overall, tabular models are a powerful tool for representing and analyzing data, and they are widely used by organizations to build data-driven applications and solutions.

Real-time Analytics

Real-time analytics is the process of collecting, analyzing, and acting on data as it is generated, rather than after the fact. It involves the use of technologies and techniques that allow organizations to process and analyze data in real-time, as it is being generated, rather than waiting for the data to be collected and analyzed at a later point in time. Real-time analytics has a wide range of applications, including customer behavior tracking, fraud detection, supply chain management, and real-time decision making. By providing organizations with immediate insights into their data, real-time analytics can help them make more informed and timely decisions, improve efficiency, and respond to changing conditions in real-time. To support real-time analytics, organizations may use technologies such as stream processing, in-memory databases, and real-time data visualization tools.

Why consider Business Intelligence

– Business intelligence (BI) and data warehousing are important tools for businesses because they can help organizations make better, more informed decisions – BI tools allow businesses to analyze data and present it in a way that is easily understandable, so that decision makers can identify trends, patterns, and opportunities – Investing in BI and data warehousing can help organizations gain a competitive advantage by providing them with the information they need to make data-driven decisions – Additionally, BI and data warehousing can help organizations better understand their customers and markets, and identify new opportunities for growth and innovation – Business intelligence (BI) supports decision making by providing organizations with the tools and information they need to analyze data and make informed decisions

Different Types of Analytics

There are many different types of analytics, including: – Real-time analytics: This type of analytics involves analyzing data as it is being generated, rather than analyzing data that has already been collected – It allows organizations to make informed decisions in real-time, based on the most current data available

Descriptive analytics

Descriptive analytics is a type of analytics that focuses on describing what has happened in the past. It involves summarizing and visualizing data to better understand patterns, trends, and relationships. Descriptive analytics is typically used to answer questions like: What has happened in the past? Descriptive analytics is an important first step in the data analysis process, as it allows organizations to understand their data and identify areas that may require further investigation.

What is Microsoft Azure Data Factory

Microsoft Azure Data Factory is a cloud-based data integration service that enables the creation, scheduling, and orchestration of data pipelines.It is designed to extract, transform, and load (ETL) data from a wide range of sources and destinations, both on-premises and in the cloud.Overall, Azure Data Factory is a powerful tool for managing and integrating data at scale, and it is widely used by organizations to build data-driven applications and solutions

Sentimental analysis

– Sentiment analysis, also known as opinion mining, is the process of using natural language processing and text analysis techniques to identify and extract subjective information from text data.– There are several different techniques that can be used for sentiment analysis, including rule-based approaches, machine learning algorithms, and lexicon-based approaches.– Overall, sentiment analysis is a useful tool for understanding and interpreting the attitudes and opinions expressed in text data, and can provide valuable insights for businesses and organizations.

Diagnostic analytics

Diagnostic analyticsDiagnostic analytics is a type of data analysis that is used to identify the root cause of a problem or issue.It involves analyzing data and using various tools and techniques to identify patterns, trends, and relationships in the data that can help explain why the problem is occurring.There are a variety of tools and techniques that can be used in diagnostic analytics, including data visualization, statistical analysis, and machine learning algorithms.