Latest Power BI and AI articles from RADACAD team
In the last post, I have explained the main concepts and usage of “Optimization” problems and “Linear Programming”. In this post, I am going to explain a simple example of solving an optimization problems from [1]. Imagin, we have a company that produce Product 1 and Product 2, we want to maximize the profit of Read more about Optimization Problem in Power BI using R scripts: Part2[…]
There are some traditional problems in most of industries like how we can reach maximum profit, sales, production or how we can minimize our cost and loos. These types of problems can be seen in different areas such as microeconomic and company management, such as planning, production, transportation, technology . Although the modern management issues Read more about Optimization Problem in Power BI using R scripts: Part1[…]
Visualization is any kind of graphical representation that enable us to: Exploration, it help us to get more deep insight through huge amount of data Discovery, It also gives extra vision Analysis, it can be used to find pattern Communication, visualization help us to communicate better A few years ago Dr. Andrew Abela published a good Read more about Table with Embedded Chart in Power BI using R[…]
About the book; Quick Intro from Author In 2016, after bringing the capability of writing R codes inside Power BI, I’ve been encouraged to publish an online book through a set of blog posts. The main reason to publish this book online, was that there is no integrated and comprehensive book on how to use Read more about Online Book: Analytics with Power BI and R[…]
Busy schedule in last few months with lots of conferences and courses didn’t allowed me to publish 3rd version earlier. and now, here you go; 3rd edition of Power BI from Rookie to Rock Star book is available to download. this edition ended up with being 1075 pages! This book is already downloaded more than Read more about Edition 3 of Free Book: Power BI from Rookie to Rock Star – 1075 Pages![…]
M is the powerful language behind the scene of Power Query. Any transformation you apply will be written in M language. For many, M looks like a scary language. In this post I like to explain a bit of basics of M. Not mentioning any functions. Mainly I want to explain to you how the Read more about Basics of M: Power Query Formula Language[…]
In the last two posts (Part 1 and 2), I have explained the main process of creating the R custom Visual Packages in Power BI. there are some parts that still need improvement which I will do in next posts. In this post, I am going to show different R charts that can be used Read more about Interactive Charts using R and Power BI: Create Custom Visual Part 3[…]
We have got an idea of PowerApps working environment from the last post, now we can start customising functionalities of our TimeSheet App. Click here for a recap on all functions for our TimeSheet App. We are working on our first function in this post – Dropdown list: When creating a new timesheet record, team Read more about PowerApps – Building Timesheet App without Coding – Part 3 – Connecting to multiple data source, and getting ready to build dropdown lists[…]
Every so often I find myself needing to import data, but only want data relevant to values already existing in my data model. This is common where I build smaller models based on a subset of fact or transaction records. Rather than bring in entire dimension tables, I may only need the dimension records that Read more about Dynamic SQL Using Power Query[…]
The last post, we introduced Microsoft PowerApps, the solution to connect, create and share business apps with your team without coding, hence boost efficiency in your organisation, facilitate lean delivery and improve business agility. Pickup from the TimeSheet App we generated in just a minute from the last post, this time, we will help you Read more about PowerApps – Building Timesheet App without Coding – Part 2 – Get to know the environment[…]