In this video, we’ll take a look at the SWITCH function in DAX. Check out the advantages of SWITCH over the IF function.

Financial Management Consulting & Business Intelligence blog
In this video, we’ll take a look at the SWITCH function in DAX. Check out the advantages of SWITCH over the IF function.
To improve its digital tools and data management processes Toyota Ukraine, the official distributor of Toyota and Lexus cars, as well as spare parts in the country, integrated Microsoft Dynamics 365, Teams, Microsoft Power Platform and SharePoint Online.
The quality control department of KAMAZ introduced the “Manager’s monitor” using Power BI. Dashboards are used to get insights to the most relevant information, quickly identify negative trends, and find potential solutions and growing points. Product managers, business process owners and deputy quality directors have access to the business intelligence tool.
Earlier this week Microsoft released the November update for Power BI. In this article, we take a look at some of the new features that came out this month.
Before analytics can start supporting business decisions, a proper organizational system tailored for analytics needs to be designed first.
When the world emerges out of the pandemic, businesses will have to embrace changes in how they operate, get rid of some of the least effective practices and focus more on business intelligence (BI) and analytics to stay afloat.
Power Query is an extremely powerful tool, which can make our work a lot easier and faster. Instead of wasting your time doing monotonous tasks in Excel, you can spend more time analyzing data and finding insights.
Power ON’s Visual Planner provides write-back capabilities to a Power BI dashboard and is really helpful for planning and forecast purposes.
Companies, like Microsoft and Esri have launched real-time online dashboards to track all confirmed and suspected cases of COVID-19 along with a number of deaths and recovered patients.
The BI market is booming with new products, options and capabilities. Experts are predicting a large growth in the industry over the next few years. In this article, we’ll look into five major trends developing in the industry and try to analyze how BI will continue to transform businesses across the world.
Some IT industry experts predict COVID-19 concerns will increase the adoption of cloud-based services in the attempt to support a large-scale work from home strategy.
A skilled BI consultant will help you to figure out your needs, analyze requirements, properly implement a solution and, if needed, provide further support. Let’s take a closer look at the qualities you should seek in a BI consultant.
Before jumping into a BI implementation project, it is important to critically assess your company’s current needs, performance, operations and finances. Find out what to look out for.
According to a survey provided by the BI Survey website, the top 5 most serious problems that consultants come across are poor data quality (32 percent), company politics (26 percent), lack of interest from business users and poor data governance (21 percent), and administrative problems (19 percent).
The right BI tool can be the backbone of the finance department. Using modern BI tools, finance managers can move beyond simply keeping numbers organized and take a more proactive and intelligent approach, becoming a company’s key decision-makers.
“The biggest differentiator in public speaking in 2021 will be the design of visualizations,” a top-rated tech industry speaker.
To effectively manage the distribution of vaccines modern analytics and business intelligence solutions can come into play. This is the moment when analytics can display its true power to everyone and help humanity.
In the past, companies had to spend thousands of dollars just to make sure they can start using advanced analytics that required strong hardware requirements and computing power. In the recent years, the democratization of the cloud increased the adoption of advanced analytics across different industries.