In this post we look at how to overcome some of the limitation of the DISTINCTCOUNT function in Power BI by employing a Slowly Changing Dimension Type 2 (SCD2) format.
Solving a DISTINCTCOUNT Problem with SCD2 in Power BI Read More »
About Abylon Abylon Consulting is a rapidly growing and innovative IT solutions provider with a strong focus on providing innovative BI solutions and consulting services. We have high expertise in Microsoft and Azure data analytics and BI products, hence many of our solutions are based on or tightly integrated with the relevant Microsoft products. Data
Senior Data Engineer Read More »
Our new blog post uncovers the top five challenges of Financial Planning, from Excel file consolidation to data quality issues, that sap precious time and focus from organizations.
Five Biggest Challenges in Financial Planning Read More »
Use custom validation on Master Data to cut out avoidable time-consuming issues in your ETL pipelines and give instant error feedback to your Master Data Administrator!
Master data custom validation using the Rapid Platform Read More »
In controlling and FP&A, tasks like analytics, reporting, and month-end closings in Excel involve significant data transformations from limited sources. Mastering Power Query offers the highest return on investment for such scenarios.
Unleashing the Power of Excel: From VBA to Power Query Read More »
We are excited to announce our latest enhancement to the Docuflow platform. The Regulatory Document Module has been upgraded with an AI-powered regulatory repository.
AI-Based Regulatory Repository: The Control System of the Future Read More »
Company Overview Established in 2016 Abylon Consulting is a rapidly growing and innovative IT solutions provider, with a strong focus on providing innovative BI solutions and consulting services. We have high expertise in Microsoft’s data analytics and BI and AI products, hence many of our solutions are based on or tightly integrated with the relevant
Account Executive (London) Read More »
With immense pride and excitement we’re announcing our next significant milestone: expanding internationally, beginning with the opening of our new office in the United Kingdom.
UK market here we go – Abylon’s International Ascent Read More »
The story of how a junior BI consultant with minimal work experience build a complete data warehouse, data marketplace and populated it with data all within 3 weeks using the Abylon Rapid Platform.
Data warehouse project using the Abylon Rapid Platform Read More »
The story of how we managed to automate the process of sales planning at a large software company by radically minimizing the manual work of the financial controllers.
Case Study: Sales planning automation Read More »
