Author Archives: Khilitchandra Prajapati

Update: Brisbane Data Platform User Group

Khilitchandra's Business Intelligence Blog Posted on by

I would like to keep my Technical Community & my online friends updated that – I have moved from Singapore to Australia in year 2023. Hence during the movement, I could not keep up with my blogging. But I am back to community again 🙂 I have established a brand new FaceBook User Group for Australia Data Community. And I am getting very good response which is fueling my enthusiasm even more for community. Please check-out and join this group if you havent yet. The group is created with vision “ Brisbane Data Platform User Group is for Data professionals … Continue reading →

Interview with BIConsultingPro on Enterprise Data Architecture journey + Sharing of learnings on the way

Khilitchandra's Business Intelligence Blog Posted on by

I had the pleasure of sharing my Enterprise Data Architecture journey and experiences on the @BIConsultingPro channel. If you weren’t able to catch the live event, don’t worry! You can watch the recording at your convenience on YouTube. I hope it provides you with some valuable insights and guidance. A special thank you to Ajay Kumar for hosting me. It was truly an honor to be a part of your latest Tech Series – “Learn from the Best”. You can find the recording on YouTube here: https://lnkd.in/g7qpf_pQFor more content from BI Consulting Pro, visit their YouTube channel here: https://lnkd.in/gCDBRHJi

Continue reading →

Cool Tricks in Power BI for Advanced Users

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, Greetings. It was my great pleasure presenting into “Singapore Data Platform” Event. Please download Session Slides & Supporting Demo Files from here. I am very happy to see the enthusiasm and response from everyone. Thank you. Special thank you to all Organizers (Aroh, Asif & Pio). Stay tuned for more informative sessions 🙂 Thank you, Khilit

Continue reading →

Dashboards in Power BI with Real-time Data – SQL Saturday #818, Malaysia

Khilitchandra's Business Intelligence Blog Posted on by

Had a great time speaking @ SQL Saturday # 818, Microsoft Malaysia. My slides are here -> Dashboards in Power BI with Real-time Data Great audience & great speakers 🙂 Big thanks to Organizers, Microsoft & PASS. Nice engaging Tech sessions from Experts – Chiu Kiang Phua, Ian Choy Swee Ho, Hamid J. Fard, Deh Hui Chuan, Patrick Flynn, Jan Rokicki, Ben Weissman, David Alzamendi, Vinod Kumar, Asanka Padmakumara, Jonathan Stewart Thank you to Singapore PASS Chapter Team. Khilit

Continue reading →

Demystifying DAX in Power BI – Session @ Singapore DataCamp 2019

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, It was my great pleasure presenting into “Singapore DataCamp 2019” full day event @ Microsoft, Singapore. My slides & Demo PBIXs are here -> Demystifying DAX in Power BI I was very happy to see the enthusiasm and response of everyone. A special thank you to all our prestigious speakers – Dinesh Priyankara, Naginder Singh Virdi, Zack Loh, Hitendra Changlani, Sanjiv Venkartram, Hansamali Gamge, Nilesh Gule, Nisal Mihiranga, Nagaraj Venkatesan, Dharmendra Keshari, Fiqri, Kasun Pathirana, Khilitchandra A BIG thank you to Microsoft, Nagaraj Venkatesan & Pei Shang loh – without their generous support, this event would have not … Continue reading →

Power BI Web Scraping – Deck from “Data Visualization Day – Power BI” @ Microsoft

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, It was my great pleasure presenting today into “Data Visualization Day – Power BI” full day event @ Microsoft, Singapore. My slides & Demo PBIXs are here -> Data Visualization Day 2018-12-22 – Power BI Web Scraping – ZIP I extremely happy to see the enthusiasm and response of everyone, especially Attendees. Even during this holiday seasons, there were around 120+ ignited minds in session. Event after event & response from communities & people, I can clearly see that “Power BI” is a Rock Star 🙂 A special thank you to Sanjiv Venkatram for encouraging folks in Singapore to … Continue reading →

Power BI MixTape – Web Scraping, Architecture, Custom Functions, Custom Tooltip

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, It was fun & engaging session on 22nd Nov 2018 @ Singapore PASS Chapter, Microsoft. I presented few mix topics of Power BI e.g. Web Scraping, General architecture, Custom functions, Custom Tool-tip etc. I am thankful to all energetic folks who came (~7 pm after work) for attending the session – I consider that as great support. That’s what keeps us moving. Cheers 🙂 My slides & demo PBIX are here -> Meetup 2018-11-22 – Power BI MixTape – Web Scraping Thanks, Khilit

Continue reading →

Power BI Desktop September 2018 Feature Summary

Khilitchandra's Business Intelligence Blog Posted on by

Hello Guys, Power BI Desktop’s Monthly Feature Summary of September 2018 is out. Here is the direct links to features: Reporting Dot plot layout support in scatter charts Copy value and selection from table & matrix Built-in report theme options Report page tooltips generally available & Card support Accessibility improvements for analytics and formatting pane support Analytics Aggregations (preview) Q&A support for RLS Custom visuals Horizon Chart Text Enhancer by MAQ Software Advance Card Multi KPI Custom visual API updates Data connectivity PDF file connector (preview) SAP BW connector – support for measure properties Dataflows connector (beta) Data preparation M … Continue reading →

Quick Access Toolbar in Power BI Desktop – Get more working space for your productivity

Khilitchandra's Business Intelligence Blog Posted on by

Hi, Good Saturday to you all 🙂 I would like to share today a very small and quick Tip. This is for all those Users who needs some more space while building Power BI Reports. And at the same time, have their favorite options available in some corner. You can do that in few steps. 1. Launch Power BI Desktop (does not matter whether it’s Power BI Desktop or Power BI Desktop for Report Server). You should see something like this. 2. Right click anywhere on Ribbon -> Select “Show Quick Access Toolbar below the Ribbon”. 3. Then your Quick … Continue reading →

Power BI Desktops & File Extension (pbix file)

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, Microsoft Power BI Team is keep on releasing amazing features for Power BI Service as well as Power BI On-Premise version (i.e. Report BI Report Server). And obviously we would like to try them all 🙂 If you notice, Power BI Report files created in bother authoring tools (Power BI Desktop as well as Power BI Desktop for Report Server) have the same file extension (which is understood). But when you double click the pbix file and you want that to open in its correct authoring tool then you need to remember 1 rule before double clicking it. … Continue reading →