About Me

Twitter: @MikeDavisSQL

Mike Davis, MCTS, MCITP, is a Senior BI consultant at Pragmatic Works.  He is an author of a few Business intelligence books.  Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

You can also find me on Bidn.com/blogs/mikedavis

Advertisements

7 Responses to About Me

  1. Hi Mike,
    I had registered for your webinar today. But had technical problems and could not attend that. Will you be holding another webinar on cubes?
    If yes, I will be interested.
    Thanks
    Amrita

  2. Sharnitha says:

    Hello Mike ,
    I am having trouble with importing data from an Oracle database and i know the issue is a date field in the table. Some of the dates are actually dummy dates ie ex: 1/1/9999 but that is valid in the business the company is in . I cannot drop that field ,so can you suggest a work around. I have tried importing it into Access and it works fine , but when i refresh my Access DB , it blows up and wont refresh my power pivot any more . Please suggest what can be done .

  3. Sharnitha says:

    Thanks Mike, that was very helpful!!

  4. Sharnitha says:

    Mike i am having an issue trying to bring data from two tables in power pivot data model into the pivot table .Below is the query and i have both the tables in my data model with almost all the fields present in the DW. What am i doing wrong .

    select SUM(a.number_ac_qy),SUM(a.number_hp_qy),SUM(a.number_hs_qy),SUM(a.number_pp_qy),SUM(a.number_ps_qy)
    FROM lmis_account_profile a,
    lmis_bill_authorization b
    WHERE b.account_no =a.account_no
    AND b.bill_authorization_credit_dt>=’01-JAN-2013′
    AND b.bill_authorization_status_cd =’C’

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s