Monthly Archives: August 2018

AZURE DATA WEEK – Azure Data Virtual Conference

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, There an upcoming Virtual Conference setup by Pragmatic Works. Super affordable (29 USD for entire Conference) and interesting. Go for it. When? October 8-12, 2018 Where? Online Need more information? azuredataweek@pragmaticworks.com Highlights of agenda per day: Monday, October 8th -> Power BI – The Exciting Future of Power BI – World-class Power BI Solutions – Accelerating Development with Power BI Embedded and APIs – Digital Storytelling with Power BI – Enterprise Identity and Security in Power BI – Data Security and Management in Power BI – Deploying and Managing Enterprise Power BI – Migrating to Power BI Quickly and … Continue reading →

SQL Saturday #784, Singapore – Great & Memorable Event – Thanks to All :)

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, I am very happy to share that we have successfully completed our yearly major event – SQL Saturday #784, Singapore. On behalf of entire Singapore PASS Chapter, we thank to all our prestigious speakers (Amit R S Bansal, Patrick Flynn, Karen Lopez, Dinesh Priyankara, Sanjiv Venkatram, David Alzamendi, Denny Cherry, Kevin Boles, Manohar Punna, Asanka Padmakumara, Naginder Singh Virdi, Senthamil Selvan, Sarbjit Singh Gill, Jason Aw, Dharmendra Keshari) for delivering great sessions and fill the day with knowledge and fun. Special thanks to PASS and Microsoft for gracious support to make this event great. Thanks to event organizers, … Continue reading →

Power BI Report Server – August 2018 Updates

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, People who are working on Power BI On-Premise, there are more updates for Power BI Report Server. Major features are related look and feel about the Reports/Dashboards. Plus there are few updates on Modelling and Formulas. Browse through below links and check out all examples provided by Microsoft Power BI Blog with examples 🙂 REPORTING Report Theming Buttons to trigger actions Combo chart line styles Improved default sort for visuals Numeric slicer Advanced slicer syncing Log axis improvements Data label options for funnel chart Set line stroke width to zero High contrast support for reports Donut radius control Pie … Continue reading →

Interact with Power BI with PowerShell

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, PowerShell is awesome command-line tool. Microsoft Team has recently released couple of Power BI APIs and PowerShell cmdlets – which will allow you to work with workspaces, dashboards, reports, datasets, and so forth in Power BI. But these cmdlets and APIs are not just limited to Administration purposes but also for other Power BI users. Basically there are 4 general categories of users who can leverage these cmdlets: Power BI administrators, who must work with resources at the Power BI tenant level, such as to enumerate workspaces, dashboards, reports, and datasets, recover orphaned workspaces, or discover the data … Continue reading →

Power BI Report Server – For On-Premise BI Solutions

Khilitchandra's Business Intelligence Blog Posted on by

Hi All, Power BI Report Server is now part of Power BI Premium. Power BI Premium, with Power BI Report Server will get you covered with a complete solution. Power BI Premium provides dedicated capacity in the cloud and enhanced performance – without requiring per-user licenses for those consuming reports. And, it includes Power BI Report Server for on-premises reporting too. Try this link to get started with Power BI Report Server (Download FREE trial). You just have to fill small form and that will kick the download. And good thing is – you can use any valid email address … Continue reading →

How to think & plan for Power BI in Hybrid Environment?

Khilitchandra's Business Intelligence Blog Posted on by

Hi, Good Saturday to you all 🙂 Power BI is growing leaps and bounds. It’s becoming more and more advanced and rich in its each release every month. BI folks loved the product since its release. But I still see that many architects/organizations still face challenges in uncovering true values of Power BI usage merely due to their unique organizational/architectural challenges. I came across a while paper this morning which shows best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data … Continue reading →

Power BI Desktop August 2018 Feature Summary

Khilitchandra's Business Intelligence Blog Posted on by

Hello all, Power BI Desktop August 2018 Feature Summary is out. Find out all features with demonstration at this link: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/ Here’s the complete list of August updates: Reporting Print reports through Export to PDF Create bookmark groups Theming generally available Slicer restatement Analytics Conditional formatting by values Python integration (preview) Q&A improvements Q&A in Power BI Desktop generally available Better matching experience for Power BI Desktop and Power BI Premium Modeling Data categories for measures Statistical DAX functions Custom visuals 3AG Systems – Column Chart with Variance Scatter Chart by Akvelon Small Multiples Line Chart Add Natural Language Summaries … Continue reading →

Webinar : Building a KPI Scorecard with Custom Visuals in Power BI

Khilitchandra's Business Intelligence Blog Posted on by

Hi Guys, Good Saturday to you all 🙂 There is an upcoming webinar which you might want to book your calendar for. It’s “Building a KPI Scorecard with Custom Visuals in Power BI”. Charles Sterling and Reid Havens will show us that knowing the right visuals or DAX to build out a high-level scorecard report can be challenging. Learn about some great custom visuals in conjunction with DAX calculations to build out a quality scorecard template to use in your business. Here is the YouTube link which will be live on “16th Aug 2018 10:00 AM PST“. Please book your … Continue reading →