bigator

Power BI – Overview & Features (January 2017 Session)

Hello Everyone,

Here are the slides (Power BI – Jan 2017 Session) of my session of Jan 2017 @ Microsoft SQL User Group, Singapore.
Thank you very much for all your support 🙂

Event Info:
SG SQL User Group Meeting – January 2017
https://www.meetup.com/mssgug/events/236789616/

Kindly stay tuned for more upcoming events @ Meetup page – (Group Name: SG SQL User Group).

See you in again & thanks for coming.
Thanks, Khilit 🙂

bigatorFebruary 1, 2017 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorPosted in: Business Intelligence, Power BI, SQL Azure, SQL Server

SSIS Configurations – Deep Dive Session

Hello everyone,

Here are the slides of my session of “SSIS Configurations – Deep Dive” – @ Microsoft SQL User Group, Singapore

Thank you very much for all your support 🙂
My apologies for machine issues and I could not show you demo.

I will talk to team and ask for 20 minutes to show you this demo during next sessions (if possible).

Event Info:
SG SQL User Group Meeting – Oct 2015
http://www.meetup.com/mssgug/events/228948056/

Kindly stay tuned for more upcoming events @ Meetup page.(Group Name: SG SQL User Group).

See you in again & thanks for coming.
Thanks, Khilit 🙂

bigatorFebruary 25, 2016 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , ,  · Posted in: Business Intelligence, SSIS

Power BI – Overview, Updates & Examples (Session 2)

Hello everyone,

Here are the slides of my session of Power BI – Session 2 – @ Microsoft SQL User Group, Singapore

Thank you very much for all your support 🙂

Event Info:
SG SQL User Group Meeting – Oct 2015
http://www.meetup.com/mssgug/events/226181209/

Kindly stay tuned for more upcoming events @ Meetup page.(Group Name: SG SQL User Group).

See you in again & thanks for coming.
Thanks, Khilit 🙂

bigatorOctober 29, 2015 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , ,  · Posted in: Business Intelligence, Power BI, SQL Azure

Power BI Desktop – Introduction & Overview (Session 1)

Hello everyone,

My apologies for delay in uploading the slides of my first session of Power BI. Thank you very much for all your support 🙂

Slides of Power BI – Session 1 @ Microsoft SQL User Group, Singapore

Event Info:
SG SQL User Group Meeting – Sept 2015
http://www.meetup.com/mssgug/events/225067757/

I will be speaking again on Power BI in October 2015. Dates will be declared on FB and MeetUp page. Kindly reserve/confirm your seats through Meetup page (Group: SG SQL User Group).

See you in October 2015 @ Microsoft, Singapore.
Thanks, Khilit 🙂

bigatorOctober 14, 2015 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , ,  · Posted in: Power BI

MERGE your knowledge from EXPERTS – “Project BOTTICELLI”

Hi guys,

I am just about to write an introduction of “Project Botticelli” for you; but they gave their introduction in very nice and precise manner so I decided to extract that and put it here for your quick reference.

(Excerpt from https://projectbotticelli.com/about-project-botticelli-ltd)

Project Botticelli Ltd is a small company offering online training by business intelligence experts and consulting services focused on advanced analytics, with a focus on data mining, predictive and statistical analysis.

I have seen couple of their videos and I am impressed with explanation & demonstrations. Please check out their contents on their website (https://projectbotticelli.com/). Currently there are many FREE previews/videos available. Also check out their membership plans (https://projectbotticelli.com/membership)

You can get some finer information on following five topics:

  1. Data Mining
  2. DAX
  3. Excel BI
  4. MDX
  5. SQL BI

You know what to do next.

Thanks, Khilit

bigatorJune 6, 2014 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , , , ,  · Posted in: Business Intelligence, Data Mining, DMX, Excel, MDX, Pivot Table, Power Pivot, SQL Server, SSAS, Suggestion, Training

T-SQL Tip : Finding Running Total Value

Hi Guys,

In one of my SSRS Reporting needs, I need to display RunningTotal in some funny colors. Here is the script that I have used. I hope it may help you somewhere too 🙂

RunningTotal_SQL_Script

Thanks, Khilit

bigatorMay 21, 2014 · bigatorKhilitchandra Prajapati · bigatorOne Comment
bigatorTags: , ,  · Posted in: General, Interview QA, SQL Server

FREE E-Books from Microsoft Press

Hi guys,

Check out these FREE ebooks from experts of MS Press.

http://www.microsoftvirtualacademy.com/ebooks

Thanks, Khilit

bigatorApril 9, 2014 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorPosted in: Uncategorized

Three Things I’ve Learned From Warren Buffett – By Bill Gates

Hi Friends,
Just wanted to share with you quickly… a good article by Bill Gates.

http://www.linkedin.com/today/post/article/20130612065727-251749025-three-things-i-ve-learned-from-warren-buffett?trk=eml-mktg-celeb-bg-title

Thanks, Khilit

bigatorJune 14, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags:  · Posted in: General

MDX and DAX Query Formatter …. is back :)

Hi Friends,
Just to share with you quickly that “MDX and DAX Query Formatter” site is back online.

Here is the link: http://formatmdx.azurewebsites.net/

Thanks, Khilit

bigatorMay 13, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , , , ,  · Posted in: Business Intelligence, Data Mining, DMX, General, Interview QA, MDX, Query Tuning, SQL Server 2012, SSAS

Recover Backed-up query files in SQL Server Management Studio

Hi guys,

I just want to share quickly very handy tip regarding your SQL query sessions. When you open SQL queries in SSMS, you generally go on and work in newly opened pane/window but sometimes dont save that work.

SSMS by default saves them in the event of pre-mature closure or crash of SSMS or PC restart etc. You can find your SQL queries from following lcoation.

C:\Users\<UserName>\Documents\SQL Server Management Studio\Backup Files\Solution1

FYI, I have found my queries here:

SQL_Queries

P.S. I am using Windows Server 2008 Operating System. This path could vary based on the Operating System. You can figure it out for sure 🙂

I hope you find this interesting and helpful.

Thanks, Khilit

bigatorMay 7, 2013 · bigatorKhilitchandra Prajapati · bigatorNo Comments
bigatorTags: , ,  · Posted in: Business Intelligence, General, Quick Tips, SQL Server 2012, Tutorial


bigator