PinnedJames Gnanasekaran·Nov 8, 2024How I Used ChatGPT to Convert a Complex Nested JSON to a CSV FileIntroduction Working with complex, nested JSON data is a challenge many data professionals face. Typically, we might write several lines of…
James Gnanasekaran·Jan 24Why Copilot Agents Struggle With Operational Data (and What Actually Works)A practical lesson in treating language and data differently when building Copilot Studio agents
James Gnanasekaran·Nov 22, 2025Understanding Power BI File Formats: PBIX, PBIP, and PBIR ExplainedIf you’ve been working with Power BI for a while, you’re probably familiar with the classic .pbix file format. But Microsoft has…A response icon2A response icon2
James Gnanasekaran·Mar 9, 2025Becoming a Microsoft Learn Student Ambassador (MLSA) — that’s awesome!The program is designed for students who are passionate about technology and want to develop their skills while helping their community.
James Gnanasekaran·Aug 30, 2024Validating SQL Query Changes: How to Compare Results Effectively“In the world of SQL, even the smallest change can have a significant impact. Ensuring that your modifications are accurate and don’t…
James Gnanasekaran·Apr 19, 2024Mastering Data Manipulation in AWS AthenaAWS Athena is a powerful serverless query service that allows you to analyze data directly from Amazon S3 using standard SQL. With Athena…
James Gnanasekaran·Dec 27, 2022My learning path for Power BIPower BI is a data visualization tool from Microsoft. It has been positioned as a Leader in the 2022 Gartner Magic Quadrant for Analytics…
InTDS ArchivebyJames Gnanasekaran·Feb 11, 2021The easiest way to get Rstudio Shiny server in an AWS EC2 instanceIf you are a data scientist who has an R shiny app running locally and you want to share it with the users in your organization, hosting…A response icon1A response icon1
InTDS ArchivebyJames Gnanasekaran·Jul 20, 2020How to clean up messy data?with OpenRefineA response icon2A response icon2