Tutorial to Create a Power BI Report Using PostgreSQL

  • Comments posted to this topic are about the item Tutorial to Create a Power BI Report Using PostgreSQL

  • What would you recommend for learning more about indexing in Postgrsql?

    Thanks for the installation walk through. It will save some time the next time I have to install.

    412-977-3526 call/text

  • Robert Sterbal wrote:

    What would you recommend for learning more about indexing in Postgrsql?

    Perhaps the documentation? 😉  https://www.postgresql.org/docs/current/indexes.html

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Dear Lord... I'm a production DBA. Please grant me patience because, if you grant me strength, I'm gonna need bail money to go with it.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • In other words, once you've connected, it's pretty much the same as working with a SQL Server database?

    If I can execute a stored procedure in PostGreSQL, I assume I can just connect and use the query window to call the stored procedure. Right?

  • Thanks.

    For the first time in a long time I actually have a database that needs indexing. I imported about 9 million voter records from the Pennsylvania Full Voter Export.

    Right now most of my queries are 45 seconds. This should speed things up a bit.

    412-977-3526 call/text

  • Robert Sterbal wrote:

    Thanks.

    For the first time in a long time I actually have a database that needs indexing. I imported about 9 million voter records from the Pennsylvania Full Voter Export.

    To be honest, that sounds like a PII violation on the part of the keystone state. 🙁

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Dear Lord... I'm a production DBA. Please grant me patience because, if you grant me strength, I'm gonna need bail money to go with it.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • ---------- Forwarded message ---------

    From: ST, Elections <RA-Elections@pa.gov>

    Date: Tue, Sep 6, 2022 at 3:28 PM

    Subject: Re: [External] Creating a list of related political districts

    To: Robert Sterbal

     

    You would be able to publish that list of political subdivisions that belong to Congressional Districts.

    From: Robert Sterbal

    Sent: Monday, August 29, 2022 7:25 PM

    To: ST, Elections <RA-Elections@pa.gov>

    Subject: [External] Creating a list of related political districts

    ATTENTION: This email message is from an external sender. Do not open links or attachments from unknown senders. To report suspicious email, use the Report Phishing button in Outlook.

     

    I'm looking to create a spreadsheet that shows all the political subdivisions of each of the 17 Congressional districts in the state.

    One way of doing this is to use the PA Voter Export and filter the distinct political districts for each county.

    Would I be able to publish the resulting list on the internet?

    Thanks,

    --Robert Sterbal

    robert@sterbal.com

    412-977-3526

    Mosaics by Robert: https://www.facebook.com/groups/1783957901820381/ (for a fun distraction)

  • Will the real Robert Sterbal please stand up?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Dear Lord... I'm a production DBA. Please grant me patience because, if you grant me strength, I'm gonna need bail money to go with it.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Learning about indexes is work related.

    Letters to the state government are my own.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply