Divya MahajanforPartner Penspartnerpens.hashnode.dev·Mar 24, 2024AWS Database LayerLink to exam: https://aws.amazon.com/certification/certified-cloud-practitioner/ Introduction Databases Overview Databases provide structured storage with indexing and relationships. Relational Databases: OLTP: RDS & Aurora (SQL) NoSQL Databases:...DiscussAWS Certified Cloud Practitioner | CLF-C02 preparation KitDynamoDB Accelerator
Brian Bakerbrianbaker.hashnode.dev·Mar 18, 2024DAX (Data Analysis Expressions) Functions in Power BIPower BI is a powerful business intelligence tool that allows users to transform data into visually stunning and insightful reports. At the heart of Power BI lies DAX (Data Analysis Expressions), a formula language designed specifically for data anal...DiscussDataAnalysisExpressions
Luca Liuluca1iu.hashnode.dev·Mar 5, 2024Understanding Nested IF vs. SWITCH in Power BI: A Comparative AnalysisIntroduction: In Power BI, making decisions based on conditions is a common task encountered during data modeling and report creation. While the IF function provides a straightforward way to implement conditional logic, the SWITCH function offers a m...Discussdata analysis
Sweta_Sarangiswetasarangi.hashnode.dev·Mar 3, 2024Introduction to DAXBy using Data Analysis Expressions (DAX), you can add three types of calculations to your semantic model: Calculated tables Calculated columns Measures Calculated tables Utilizing a DAX formula enables the incorporation of a calculated table int...Discussdax
Luca Liuluca1iu.hashnode.dev·Dec 27, 2023Essential Step for Dashboard Creation: Creating Dynamic Date Table in Power BIWhy do you generally need to create a date table in Power BI, while it is not necessary in Tableau? In Power BI, a date table is necessary because the DAX language does not support built-in date functions, requiring the creation of a date table to pe...DiscussPowerBI
Rujay Taywaderujay1211.hashnode.dev·Nov 24, 2023Unveiling the Data Professional Landscape: Insights from Our Latest SurveyHello Data Enthusiasts! We recently conducted an insightful study aimed at understanding the diverse landscape of data professionals. We leveraged the power of Power BI to transform our survey results into an interactive dashboard that provides an ov...DiscussPowerBI
Parth Ladhashnode.thenavigatedata.com·Nov 16, 2023Power BI DAX — Let’s Understand the Difference Between SUM and SUMXWelcome to my Power BI blog! I’m passionate about helping people learn and use Power BI to create powerful data visualizations and insights. I’ll be sharing tips, tutorials, and case studies on a variety of topics, such as Data modeling, DAX, Report ...Discuss·48 readsPowerBI
Sandeep PawarProfabric.guru·Oct 30, 2023Formatting DAX Expression Returned By SemPy in FabricThere is an old Italian saying "If it's not formatted, it is not DAX" 😁 When you get the list of measures from SemPy, it's not formatted and is hard to read and understand. Thankfully, the SQLBI team has made the DAX parser and the formatter availab...Discuss·2 likes·501 readsmicrosoft fabric
Viraj Rathnayakavirajr.hashnode.dev·Jul 28, 2023How to get sales value for the previous 12 months from the latest available date in Power BI.In this post, we are going to find out how to, Getting previous 12 months' sales from today. Getting previous 12 months' sales from the latest available date. Getting the previous 12 months (or any number of months) is a pretty common requirement...DiscussPower BI
Viraj Rathnayakavirajr.hashnode.dev·Jul 16, 2023I've earned Microsoft certification for Power BI Data Analyst Associate (PL-300) & here's how I did it.🎉Spoiler Alert! It wasn't easy....😅 After 5 years I first started working with Power BI, I finally managed to earn my first Microsoft certification for Power BI Data Analyst Associate for one year (2023-2024) after passing the PL-300 exam by the narr...Discuss·1 likePowerBI