How to manage partitions dynamically in SSAS Tabular.
Partitioning your fact tables is a very good way of decreasing processing time when you load data into these tables. Often there is no need for processing the entire fact table every day, likely only the most recent data has changed in the underlaying table. Let’s say we have a fact table called FactSales which […]
Azure #1 for BizOne
There is no doubt that there are a lot of advantages of putting Analytic solutions in the cloud. You will be able to keep a much higher innovation rate, you can scale up and down as needed, you get access to testing new technologies quickly and cost effective, etc. However, when implementing the solutions ‘for […]
What is Machine Learning?
In a previous blog I discussed Big Data, what it is and how it can be used to benefit your business. The main purpose being to extract value from data by gaining insight e.g. “If I discount my product by 5%, I’ll increase sales by 10%”. The technique used to gain this insight is Analytics […]
Part 2: Converting Roles
Blog series: Part 1. Mutlidimensional vs Tabular Introduction on using xslt Converting data source Part 2. Converting Roles Part 3. Converting Dimensions (coming soon) Part 4. Converting Relationships Part 5. Converting Hierarchy Part 6. Converting Measures Part 7. Converting Calculated Measures (Name, Basic Calculation) In the first part of our series we compared the technical […]
Migrating SSAS Multidimensional Cubes to Tabular
Blog series: Part 1. Mutlidimensional vs Tabular Introduction on using xslt Converting data source Part 2. Converting Roles (coming soon) Part 3. Converting Dimensions Part 4. Converting Relationships Part 5. Converting Hierarchy Part 6. Converting Measures Part 7. Converting Calculated Measures (Name, Basic Calculation) Microsoft Azure Analysis Services is a fully managed platform as a […]
BizOne Introduces Population Forecast as a Service
In the coming years, we will be faced with major demographic challenges, which means that municipalities will require as much information as possible to predict the needs of schools, preschools, elderly care facilities and much more. In order to be able to plan for the long term, we believe that in addition to good forecasting, […]
Congratulations to Chris for achieving his MCSA!
Congratulations to Chris Sutcliffe on successfully achieving the MCSA! BizOne Asia would like to congratulate Chris on achieving the Microsoft Certified Solutions Associate (MCSA) SQL 2016 BI Development. This certification validates the skills required to implement Business Intelligence solutions using data warehouse, ETL, along with multidimensional and tabular data models and OLAP cubes on the […]
Di Truong Joins BizOne Asia
BizOne Asia continues to expand with a new addition to its team of consultants, Di Truong. Originally from Vietnam, Di is an experienced Senior Consultant who has a history of working in the banking/financial industry and oil and gas corporations. Before joining BizOne Asia, Di had the opportunity to work in Yangon with KBZ Bank, […]
Power BI Workshop Bangkok
BizOne Asia regularly holds free Microsoft Power BI workshops in Bangkok! Learn the latest self-service capabilities of Microsoft Power BI, understand the technologies available in the cloud and on-premises and learn how these technologies can help address business problems. Our workshop is the best way to learn about Microsoft Power BI and is for anyone […]
GDPR and Microsoft’s Data Discovery and Classification
On the 25th of May, countries across the European Union will begin enforcing the General Data Protection Regulation (GDPR). This change will not only affect how businesses in the UK and EU operate but also outside of the EU. This means any company who interacts with EU businesses’, residents’ or citizens’ data must conform with […]