Streamline Sharing Folder and Email Message using Power Automate ( Part 2, Send Email)

In the last post, I started to explain how I used Power Automate for my business case scenario using Power automate, Excel, and OneDrive for conference management that can be applied to all other training class scenarios.In the last post, I explained how to trigger a PowerAutomated via Excel and create a folder inside it. Read more about Streamline Sharing Folder and Email Message using Power Automate ( Part 2, Send Email)[…]

Streamline Sharing Folder and Email Message using Power Automate ( Part 1, Folder Creation)

Here I will share one of my business case scenario using Power automate, Excel and OneDrive for a conference management that can be apply to all other training class scenarios.we normally want to create a personalized folder for your students in class or for our speakers in a conference so they/we can put or files Read more about Streamline Sharing Folder and Email Message using Power Automate ( Part 1, Folder Creation)[…]

Anomaly Detection in Power BI

Anomaly detection is one of the popular topics in machine learning to detect uncommon data points in the datasets. For example, in a greenhouse, the temperature and other elements of the greenhouse may change suddenly and impact the plant’s health situation. Identifying the anomaly data in a credit card transaction, or in health data received Read more about Anomaly Detection in Power BI[…]

Ranking Chart in power BI Desktop Using Charticulator

Regarding using Charticulator for creating custom visuals, I come across one of the visuals in the Charticulator gallery and I decided to follow it up to see how it created. So I manage to create a dataset that has ranking, name and amount. https://charticulator.com/gallery/co2_emission_ranking.html In this example, I am using Carbon dioxide emission data for Read more about Ranking Chart in power BI Desktop Using Charticulator[…]

Remove Columns with Specific Patterns Name in Power BI using Power Query

I was in the middle of data transforming to create a clean dataset for a Charticulator post, that I come across a dataset as http://mdgs.un.org/unsd/mdg/SeriesDetail.aspx?srid=749 This dataset is for Carbon dioxide emissions in different countries around the world. The only columns I need from this datasets is about country name and the number of emissions for Read more about Remove Columns with Specific Patterns Name in Power BI using Power Query[…]

Q&A Visual – Define a Synonym for a Column

In the last two posts, I have explained what is Q&A visual and how we can define an adjective for each column. In this post, I will explain how to define a synonym for a column so if the business users use another word with the same meaning, still they able to use Q&A visual. Read more about Q&A Visual – Define a Synonym for a Column[…]

Text Entity Extraction in Power BI, Text Analytics Service

Another service to Microsoft Cognitive Text Analytics API is Text Analytics API, which is about Entity Linking, and Named Entity Recognition (NER). Entity Linking: Entity Linking able to identify the disambiguate the identity of an entity found in the text (for example, determining whether an occurrence of the word Mars refers to the planet, or Read more about Text Entity Extraction in Power BI, Text Analytics Service[…]

Q&A Visual – Define an Adjective for a Column

In the last post, I have explained how to work with Q&A visual . There is a way to define terms for the Q&N visual. There are two main terms Adjective Define an explanation for a column using a Measure. We able to define a measure as adjective for each columns of data. Columns Define Read more about Q&A Visual – Define an Adjective for a Column[…]

Q&A Visual in Power BI Desktop

In this post series, I am going to show how to use new Q&A visuals for the aim of creating easy visuals by typing the natural language and define some user-defined terms and how to manage it. This visual is now generally available for everyone. IN this post some introduction to this visual about how Read more about Q&A Visual in Power BI Desktop[…]

Power Automate for OCR

In the last post, I have explained how to use text recognizer fo the aim of detecting the text in a picture using the AI builder in Power Apps. In this post and video, you will how to call it in Power Automate and extract the text from an image that is located in Onedrive Read more about Power Automate for OCR[…]