Data Analytics for Developers

In this category you will find technical articles with tips and best practices on:

  • Power BI: all new products, DAX, dimensional modeling, etc.
  • Improvement of descriptive, predictive and prescriptive analytical processes
  • Use cases and applications of Business Intelligence and Machine Learning, in general

Do you need to learn Power BI? Become a BI professional? Take your first steps with Machine Learning? Discover our courses and choose the one that best suits your needs and your level:

Updates on Data Analytics for Developers:

Azure Database integrated authentication with SSIS

In many scenarios, we face the need to use integrated authentication in order to gain access to the required data sources to feed our analytical system. In view of Azure’s increasingly widespread use, as is the case with at least part of our infrastructure, some of these sources are hosted in Azure databases. In this case, we will discuss an actual error that we have come across when configuring and using integrated authentication in Azure databases with SSIS.

read more

Power BI Bookmarks! What are they for? How can I use them?

In this entry, we will show you how to create bookmarks and different scenarios where they may be useful. Bookmarks are basically used to store the status of a specific report page including the filter selection and the visibility of the different objects, allowing the user to return to that same status by simply selecting the saved bookmark.

read more

Power BI Dataflows: How does the new tool work?

In this blog post, we will show you some information regarding the new Power BI functionality known as Dataflow, that already exists in services such as Office 365. We must highlight that this new service is still in the Beta stages, so it is currently subject to modifications and updates.

read more

Converting Excel files into CSV and uploading files using SSIS

Although SQL Server Integration Services, hereinafter SSIS, is capable of uploading Excel files, in most cases it can be time consuming because any small modifications to the Excel files can make the SSIS crash. For that reason, the best option is usually to transform those Excel files into .csv format, since uploading text files will cause you significantly less issues than the Excel files.

read more

Power BI (Audit) Usage Analytics; Get the most out of your Dashboards!

SolidQ has developed a powerful tool through Power BI itself that gives abundant information on the use of the organization´s Dashboards and Reports. Power BI Usage Analytics allows us to know, for example, whether a Dashboard is being used or not, if it is used a lot or a little, who uses them and at what times, what Workspace is used more, as well as compare uses of Reports / Dashboards between several dates, etc

read more

About us

We want to be part of your business project by building and implementing a Data Driven Strategy. We can share your digitalization path while providing innovative solutions based on our proven frameworks and expertise. We are global providers of technical consulting, mentoring and training services for Microsoft Data Management platforms. We focus on Data Management, Business Analytics, and AI.

Training

Check available courses. We deliver private and public training.

Free resources

Get free access and downlads to our contents: ebooks, events, publications....

Upcoming events

Find events near you and save your seat! Learn directly from the experts.

Meet us

Check our story and values. Would you like to be part of our team?

Let´s talk!

Write to us and we will get back to you as soon as possible.