PinnedAnjola JimohKEY DAX CONCEPTS YOU SHOULD KNOW(PART 1)DAX is a data analysis expression language used in PowerBi. I attended a PowerBi conference sometimes last year where Ahmed Oyelowo…Jun 9, 20231Jun 9, 20231
Anjola JimohDATA DRIVEN DECISIONS: THE CRUCIAL ROLE OF DATA IN BUSINESS DECISION MAKING.Hey there! Been a while and I am so glad to write again. It’s been quite a ride. I am also genuinely happy to write to you and also improve…Jan 311Jan 311
Anjola JimohWHY SQL IS AN IMPORTANT SKILL FOR EVERY DATA PROFESSIONAL .Lately, I have been writing articles on SQL and my day-to-day tasks has been retrieving data from different sources which is an important…Aug 21, 2023Aug 21, 2023
Anjola JimohSUBQUERIES IN SQLLike the image above, a subquery is a query written inside another query. It is a nested query that can retrieve data from several tables…Aug 15, 20231Aug 15, 20231
Anjola JimohUPSERT IN SQLThe term Upsert in SQL allows you update a table if the specified condition already exists or insert a new row if the specified condition…Jul 25, 2023Jul 25, 2023
Anjola JimohTHE NATURAL LANGUAGE FEATURE IN POWERBI (Q&A)Microsoft PowerBI is a business intelligence tool and one of the great feature embedded in it is the Q&A visual.Jul 15, 2023Jul 15, 2023
Anjola JimohPIVOT TABLES IN SQLIf you are quite familiar with Power Query in Microsoft PowerBI or Microsoft Excel, then you probably know what it means to pivot a table…Jul 9, 20231Jul 9, 20231
Anjola JimohAGGREGATE FUNCTIONS IN SQL.Aggregate functions help in calculating multiple values and they return a single value.Jun 22, 20231Jun 22, 20231
Anjola JimohCTE- COMMON TABLE EXPRESSIONOne of the advanced SQL functions you need to know is CTE. During my daily study hour, I came across a task that I had to resolve using…Jun 2, 20233Jun 2, 20233