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:
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.
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.
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.
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.
Measure the Strength of Association Between Two Categorical Variables: Mosaic Plot and Chi-Square Test
How to measure the strength of association between two categorical variables
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
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.