Tag Archives: Microsoft

Microsoft technology related posts and information, SQL Server, Business Intelligence

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 →

Power BI – World Tour (7 cities across the world)

Khilitchandra's Business Intelligence Blog Posted on by

The “Power BI User Group” (PUG) is going to run the “Power BI World Tour” with access to premium Power BI content designed by your local industry experts. Starting in August, the tour will visit seven cities throughout the World. Hurry up and register before 7 August to get discounted rates for this 2 days event. Check here for details: https://www.pbiusergroup.com/participate/pbi-world-tour 19-20 Aug @ New York 23-24 Aug @ London 28-29 Aug @ Copenhagen 4-5 Oct @ San Francisco 4-5 Oct @ Toronto 11-12 Oct @ Chicago 6-7 Nov @ Sydney I wish that next time, ASIA will be covered too … Continue reading →

“Quick Insights” feature in Power BI

Khilitchandra's Business Intelligence Blog Posted on by

What is it? How does it work? How it can be helpful? Power BI quickly searches different subsets of your dataset while applying a set of sophisticated algorithms to discover potentially-interesting insights. Power BI scans as much of a dataset as possible in an allotted amount of time. You can run Quick Insights against a dataset or tile (Related Insights). You can readily use any of suggested visualizations (i.e. quick insights) and build Report or Dashboard in minutes 🙂 So, in short – You can build your Report or Dashboard quickly by browsing through Dataset’s data insights. Then choose whatever … Continue reading →

Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)

Khilitchandra's Business Intelligence Blog Posted on by

Hi Guys, I have been waiting for an official certification from Microsoft on Power BI. And finally I saw the exam opened up. 🙂 Even though it is still marked in Beta but you can go-ahead and schedule if you want. Or you can start gearing up with necessary technical knowledge to complete the certification. Please check-out below link which has everything that you need to know and get prepared for it. Find out more @ https://www.microsoft.com/en-us/learning/exam-70-778.aspx Thanks, Khilit

Continue reading →