INSPIRIT
  • About us
  • Consulting
  • Support
  • Training
  • Join us
  • News
  • Contact
  • On Focus
  • EN
    • EN
    • BG
  • Menu Menu

FREE E-book: GET TO KNOW AZURE DATA STUDIO

June 8, 2020/by adm1n

This e-book introduces Azure Data Studio and helps you discover the main ADS features you can use for your daily job. It starts with installing and using the basic querying features in ADS and goes through more advanced concepts in an easy and exciting way by using examples and visuals. It goes beyond the basics explaining your next steps of developing modules and using notebooks. You will understand how to organize your files in workspace and even customize your ADS environment. The book is a good starting companion of your ADS journey.

Author: Margarita Naumova

FULL BOOK:

Download Now

Thank you!

https://inspirit.bg/wp-content/uploads/2020/06/ebook2.png 1070 937 adm1n https://inspirit.bg/wp-content/uploads/2025/01/Logo-new-2.png adm1n2020-06-08 10:36:012020-06-08 10:36:01FREE E-book: GET TO KNOW AZURE DATA STUDIO

FREE E-book: PROVISIONING and TESTING SQL SERVER 2019 BIG DATA CLUSTER

March 10, 2020/by adm1n

This e-book makes an overview of Big Data Clusters in SQL Server 2019. It goes through a step by step of BDC Deployment using Azure Kubernetes and show you how to connect and use BDC for accessing external data sources as Oracle tables.

Authors: Margarita Naumova & Rozalina Zaharieva

FULL BOOK:

Download Now

Thank you!

https://inspirit.bg/wp-content/uploads/2020/03/book.png 1189 858 adm1n https://inspirit.bg/wp-content/uploads/2025/01/Logo-new-2.png adm1n2020-03-10 09:26:102020-03-10 09:26:10FREE E-book: PROVISIONING and TESTING SQL SERVER 2019 BIG DATA CLUSTER

SQL&BI User group meeting October ’19

October 23, 2019/by adm1n
The October meetup for Bulgaria’s SQL&BI Group was held last night and it was an amazing experience as usual. The topic was datawarehouse modeling and in particular – covering the basics. The topic is indeed something that cannot be covered in a single meeting or two, but I believe it can be a very insightful series of events and topics. We even have several potential new topics, as it seems this subject definitely needs more love in the community 🙂 So, stay tuned and follow us in social media, so you don’t miss the sequel of this topic 🙂 (meetup | facebook) Link to the presentation you can find here.
https://inspirit.bg/wp-content/uploads/2019/10/SQL-user-group-meeting-02.jpg 1076 1614 adm1n https://inspirit.bg/wp-content/uploads/2025/01/Logo-new-2.png adm1n2019-10-23 10:15:302019-12-03 10:29:18SQL&BI User group meeting October ’19

Exciting data platform announcements at Microsoft Ignite 2019

September 11, 2019/by adm1n

Microsoft Ignite is running at full speed and there are several truly amazing features and products that are making the BI/Analytics/Database world much more fun that it is currently 🙂 So, what are the things that took our attention? Here’s the short list:

SQL Server 2019 is now GA – so all the new performance, monitoring and management improvements, big data clusters, calculation groups in analysis services, SSRS improvements, SA benefits changes, edition changes, and so on, are now available for you to evaluate and possibly upgrade. A quick-learning video series is also available to get through all new features of SQL Server 2019.
Azure Synapse Analytics – the successor of Azure Datawarehouse, this service gets us really, really excited! It’s promising petabyte scale, performance, PowerBI integration, ability to combine batch and streaming scenarios, irrelevant of size and schema. This is cool! So, here’s the announcement! Personally I intend to invest some time in getting up to speed with this service, so follow our webinars for more details 🙂
PowerBI world – so many things are happening there!! First – enterprise information management capabilities – data lineage and the ability to secure and audit the data, including prevention of export of sensitive data, classification of reports and overall security/audit integration! Second – Large Models for PowerBI Premium – well, yes, it’s in Premium and it allows you to run models up to 400 GBs (40 times more than the current 10 gigs). Third – oh, boy, those features!!! Those you’ll have to see for yourself, I can’t explain them 🙂

So, this was just the start of Ignite. I believe there is still more to come, so stay tuned!

https://inspirit.bg/wp-content/uploads/2019/09/88428.jpg 4480 6720 adm1n https://inspirit.bg/wp-content/uploads/2025/01/Logo-new-2.png adm1n2019-09-11 16:39:182019-11-25 14:24:22Exciting data platform announcements at Microsoft Ignite 2019

How to use the Microsoft Face API in PowerBI

June 18, 2019/by adm1n
Using Cognitive Services as part of PowerBI dataflows has been made really easy, as long as you have Premium or Embedded capacity. But if you have only Pro/Free account or you need the Face Recognition API, then you need to work some magic to get through. In this post I’ll describe the steps to import data, returned as JSON from the Microsoft Face API and extract facial features into a nice little report. So let’s start with the setup – I have an Azure Blob container, where I have all my pictures and a deployed Face API, using the free tier. Then:

  • Import in PowerBI the contents of your Azure blob to get the full image path (hint: you’ll need to do some column merging to get the full path)
  • Make sure you’ve set proper permissions on the blob container
  • Open the Face API testing console and build your call to the Face API (hint: you need to use your API KEY from Azure Face deployment and a full path to an image, that the face API can access – I’ve done it with a sample image, uploaded in the Azure Blob folder). You API call should look like this:
  • Make sure you add/adjust all the properties you want from the API to detect i.e. “returnFaceAttributes = age,gender,smile,facialHair,glasses,emotion,makeup“
  • Now comes the difficult part – constructing the API call in PowerQuery and then transforming the input to meaningful data. The first step here is to open a Blank Query in Query Editor:
  • Then add the following text, where you need to replace the Ocp-Apim-Subscription-Key value with your API key:

let DataOutput = (ImageURL as text) =>
let
url = “https://northeurope.api.cognitive.microsoft.com/face/v1.0/detect?returnFaceId=true&returnFaceLandmarks=false&returnFaceAttributes=age,gender,smile,facialHair,glasses,emotion,makeup&recognitionModel=recognition_02&returnRecognitionModel=false”,
body = “{ “”url””: “”” & ImageURL & “””}”,
Parsed_JSON = Json.Document(body),
BuildQueryString = Uri.BuildQueryString(Parsed_JSON),
Source = Json.Document(Web.Contents(url,[Headers = [#”Content-Type”=”application/json”,#”Ocp-Apim-Subscription-Key”=”XXXXXXXXXX YOUR API KEY HERE XXXXXXXXXXX”], Content = Text.ToBinary(body) ] )),
#”Converted to Table1″ = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#”Expanded Column1″ = Table.ExpandRecordColumn(#”Converted to Table1″, “Column1”, {“faceId”, “faceRectangle”, “faceAttributes”}, {“faceId”, “faceRectangle”, “faceAttributes”})
in
#”Expanded Column1″
in DataOutput

This creates a function, that accepts an image path and sends it to the Face API, which in turn provides a JSON result with all the faces, recognized on the picture.

  • Next step is to remove the Errors from the Data column (right click on the column -> Remove Errors) and then Expand the sub-tables (using the expand column in the top right corner of the Data column)
  • Result should be something like this:

And that’s it. Enjoy!

https://inspirit.bg/wp-content/uploads/2019/10/microsoft-face-03.jpg 1076 1614 adm1n https://inspirit.bg/wp-content/uploads/2025/01/Logo-new-2.png adm1n2019-06-18 10:23:002019-12-03 10:32:37How to use the Microsoft Face API in PowerBI

SQL Server 2019 Discovery Day wrap-up

June 17, 2019/by adm1n

За четвърта поредна година конференцията SQL Server Discovery Day събра технологичната общност и представи новите тенденции и предстоящи възможности на излизащата в края на годината версия – SQL Server 2019. Покрити бяха теми, засягащи производителността на базите данни, интеграцията и имплементацията на big data клъстъри, както и множество теми, свързани с изкуствен интелект, анализ на данни и архитектурни решения в контекста на облачните инфраструктури. Техническата част от конференцията имаше три основни лекции, които може да намерите по-долу.

What’s new in SQL Server 2019, presented by Magi Naumova

Discovery Day 2019 Sofia – What is new in SQL Server 2019 from Ivan Donev

Big Data clusters in SQL Server 2019 by Rozalina Zaharieva and Dimitar Zahariev

Discovery Day 2019 Sofia – Big data clusters from Ivan Donev

BI and AI in the Microsoft Data Universe, presented by Ivan Donev

Bi and AI updates in the Microsoft Data Platform stack from Ivan Donev
https://inspirit.bg/wp-content/uploads/2019/06/sql-04.jpg 1076 1614 adm1n https://inspirit.bg/wp-content/uploads/2025/01/Logo-new-2.png adm1n2019-06-17 10:24:572019-12-03 10:34:31SQL Server 2019 Discovery Day wrap-up

LATEST NEWS

  • 2020 – Година изпълнена с предизвикателстваDecember 10, 2020 - 11:00 am
  • Маргарита Наумова с MVP награда от Майкрософт за 10-та поредна годинаJuly 2, 2020 - 9:54 am
  • NEW: Expert Help as a Service – Consulting, advices and Help for BI, Reporting, Advanced Analytics, SQL Server On Premise and in AzureMay 14, 2020 - 9:17 am
  • SQL Server 2020 Discovery Day се отлагаApril 9, 2020 - 2:08 pm
  • Обученията на SQL Master Academy по време на извънредно положение въведено в страната във връзка с Covid-19March 16, 2020 - 4:04 pm

Follow us on Facebook

Bulgarian office

Sofia Park

Building 93,

ap. 2.1

Sofia, Bulgaria

0888 81 89 78

Norwegian office

12 Brynsveien Str.

Floor 2

0667 Oslo, Norway

+47 919 299 12

Scroll to top